Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Missing sequences #69

Closed
linuskendall opened this issue May 9, 2023 · 6 comments
Closed

Missing sequences #69

linuskendall opened this issue May 9, 2023 · 6 comments

Comments

@linuskendall
Copy link
Collaborator

Since there's no way to reindex missing sequence number if a new sequence number has been ingested for the same node_idx, this means we end up with missing sequence numbers in the DB any time a future transaction is indexed before a previous one has been indexed.

So far we haven't observed this creating practical issues but I am not sure if it shouldn't mean problem if say, a transfer instruction is processed before the corresponding mint instruction. In this case the ownership change should fail since it calles update_asset and this update_asset call won't work because the asset is not present in the DB?

@ngundotra
Copy link
Collaborator

Ah then maybe backfiller should be checking if there are 1-1 match between distinct leaf ids & right_most_path length of the tree

@linuskendall
Copy link
Collaborator Author

So here's my example tree for this issue:

[F8f9xjjzNi9EiDb3t1MWy8Aa72yrSu71Hq3b1zd3TNn1] tree has gaps 136 != 129
[F8f9xjjzNi9EiDb3t1MWy8Aa72yrSu71Hq3b1zd3TNn1] indexing is failed, seq=136 max_seq=MaxSeqItem { max_seq: 136, cnt_seq: 129 }
[F8f9xjjzNi9EiDb3t1MWy8Aa72yrSu71Hq3b1zd3TNn1] missing seq: [MissingSeq { missing_seq: 3 }, MissingSeq { missing_seq: 8 }, MissingSeq { missing_seq: 11 }, MissingSeq { missing_seq: 26 }, MissingSeq { missing_seq: 68 }, MissingSeq { missing_seq: 97 }, MissingSeq { missing_seq: 115 }]

So missing sequences 3,8,11,26,68,97,115 in the DB. Here are the sequence numbers, node idx, transactions:

141 133 45ua85Z6n1gHQ6KXEJzJ2MqbwA2tonNR3M24VppgcJRtKkjybJPFWRQDNuWSAB96PAgTFAWc3jErp1wuB3MsR7QW 0
140 132 362432mSYvrvr3aweeAHZJyA2cZPSEFoBovuBnAA7319GRrbuoLfaP8s7Kev2zHVDiog7hEaxjsYFspwG2ErYVdc 1
139 131 5p9GKMCWW4ggtk9Tv7JHaocW41voPuJqDdZcNhz5pqM9genCuRjb2Zjz7XBfxgeUUHqr6zUqEX2e1nsuJFRv7DYE 2
138 130 4kyysBE7mfikGAGFT3cxL1DPS5PcMGRFhTUBrjuvGxkXdGPSQA6VzVRRbgh7ZRC9mdAKz1yAsH97hBNW5pYMMLq1 3
137 129 3WfUDRVRYRV8ku1oqexMHJtzps5xzQF563qzFS2h1ew3ZovtoAq1cVWMTi5HpkGQenyR7QrNd9XG4ioyntNp3umg 4
136 128 4e3m6ZWAPAyaV792e68wXNzGf1wcgV69swaVH1Ajc95ycKPfRQRm2Fnm2k7PtaEAtvHsjNnAHe4CXGVRkBcz1Lq6 5
135 127 3Q6fLSnq9SoebpnAXd8yfJNEG5LKk9bazi1mPny91TThGjymmkYG6BZzdBAFMVMKSf254DYxqvF6jRQ6QkfwGDxj 6
134 126 4ytduPBtVp2b1QsqRVAbRbbqSsvaaDYqPAZLYkArcb5bJYR9jVn2rX5dAAoHFVGTRrkdsDyFqaHAb2RQPZ45EuGd 7
133 125 5jwjJ46hSM5PkXjWwMfLoznpxZGfUqTNELTDSjxVL6S85tyd2MQkTvuvvtN2AiqPXEC33SUbNgEzTZBRUdLEAVVm 8
132 124 4Cdgw6vKhe1Qn8FEJgL7XTCcQFVXCuNHiAaXwdT8amihctAsGAXHVumnksz7rsSd9PxinEA3TWALE4yXKTnspKQr 9
131 95 5QfTJ6VjHqFEGA8yFWcrxzw5ffFQtBBcSVbdYp5cwuZVD9HhHmeFtY3MfE3wtXaFKUcCQZWAG18MTjGNoBAxi1PT 10
130 7 21DhCRLZht4hnf5LHrxF8SfmSvVgig33rtGNeEhdzgrW6jZzfQCBTbv7REkBmtVaEhPbqf123pzf3mqiFE3wmBbs 11
129 25 4JtCaWvm1xboX8rAVBniqy5csPEBNcaCuqiieY1A7asJ3xjqQKqYrHSCnKhe6TX3KyEJaLYT9ZaRyXoB1GXYdgoM 12
128 123 F9uUEN6pB6YSgub5kSYHa7Rz9wa5z9JwYh4mfy5bwKRvPFK7Nqk6izX5xccuuMEXkVZBe6by6z6SQpvbZNip6Fd 13
127 122 2CkFFSjvvif7YKjVi7ikvHtSvhYJaxHX5TEgKdbBiKw7ddyFf5KyGt7gsUPPPbxXQQKjtqJPc8DuSE2Hdik5H9gw 14
126 113 5jDTePKQgWeBrVKcLXZBSD7G1rhyNhZNf7T5H7viWbhpygw11StNVvbFPXt87FVGeggAQQeYmwtaWiyANNXJSyWZ 15
125 121 3iRMrBBz8XejYTdtD9haoDZdWsC1j46wnFUTrzH2Tdfb712g5EkhJkktwwfr5mqMeqixfnQ3EaYxepSvmJ9r6myA 16
124 120 Sg24yd5XX9AiHMePbx1FDKQuvmE6YAQkbuynExCFgSQEjCMnMhFtme9zjFUqD7z9YGeVUS4JspoyNPwNGL17WXV 17
123 67 b8zVqYnQwU8EsKkvUdy1Q15xty1KMWH555FsxvZGNUdfVhEyfgMush3XqugASrNYcZdrNLc8QGH4ahrHRtdZ1yz 18
122 119 bXp8LH8EAT85v9cZpMBsUY9C4hjWtYys52TU2L6pQSzAzbvZRdFks27HGAdnnP29VdqTZgv9vgSYgs9vRj339SA 19
121 2 2yj4wJhVf5rVUTWPwEgJT3dNheCNji2bzYghbjiEWBsfYyWqRWZPqGxCGHFnzr51nC3fw74BHE1eGhHrw5S7aeH7 20
120 118 3rXH1yZ1gxcxdmjNZdokZLPV7nNfYc43Ge9mH3S61Y4Ke5GcJtiyB1gLgxNTkcwtenixRJrgvdPsoRZrC63kJpmN 21
119 117 LC3v5sZctgZ2WdiBpMWj5pcMuXjXLBMq8NqEpWSQjP9jqTmM216zNU55bjWMgzwuPfQRrTPjx7qHHo63KWaRwJZ 22
118 116 3HUF5C2Xt18G41Y912sxzgNhXDB5CVz8iabh9NM4aDQw6u4Tj3cRnNw9nC3UDNVgiHYyuJytQPDJ5CLRaciKDG1C 23
117 115 9BDDYbr6fJt5Y8e2CoNKzYwivF6YVdxddF5A65iftod6R76kXRg5cFpJbJ3pKNp7xaB8qFR9EeMmVyKbcRRtahQ 24
116 114 2GhY9Y2BEw4C6xVv29P5U6t352R1oLCqUFt8Q5X9Yts8k2zKuRzbBenNMArNjDTcqofV9PCbf2z2ibfurv5ucEdS 25
115 113 5dbPHs6dnCaAs1vxDyAtyGLmiCjs63JNYotKASxt3XmSgM6K2HBa9CBNYTiKLtuFA9woFSULGMMACtB5nG3yQdwc 26
114 112 4kVbmiS77YxbiD89iWYDtNof6bVkH2YNvtp4sq2C8NpdtTrg26kinJNyMiFxFBRo6DoAhFUoS2N6SN792eHmh91f 27
113 111 2rPHd3nU2mgh2sPRUKEREGUngnQfbTfF3xrvB5WJQaDhhCvqny5nrgzfJUgMZJoFYtCmjXm7mNmXvjDyboknuJL1 28
112 110 4WhdLR9tfpv9TdQ62AsaZCVtoVWYALcdqmm7dBwP8mLGAw3QcTyXm6RAYnX1KWvpJNeLcp7Vawmzx8ZLFagGzgAB 29
111 109 5CeNQ7Q3ZCetJ6vfA4bNfiDJUKCfnbJxzV7ET8P3tsJ4pxDU7ZHsmU5BRzUSDEvDRR6YYVC1DgARSQC5e9z56AjV 30
110 108 5deUU4U6m9PHtHM6xK7MaWAhFiLrLYzpKK3foNQvhB3azjKNRXVTx6nzrFxTTVRnuDS3bc9mbZXxw65KHpCPJhHS 31
109 107 5MYMsXJwVYkKKR63tEbAZW7JtsAgh179koBuTmAzv7Wa3goXydAhNg9uhAtuY1eTPF3yJ8Pw2n11EsC8xhngUpAZ 32
108 106 31oTJSovak4HWowgjuDPFkjz1RzbrHPHXg9wXj5ZzJXYp9WD4u6agC4gxr4nARUJgNLYcd2ZBcM8FeYXiSgjjMTA 33
107 105 41qHv2cx9BWqkxEEtHDVTiY4vRenjqZaEoCP8QL4UUQ48ex8oK3ot5aFe7LcmgfxzD6aA9mafmStD3EX7anpAeci 34
106 104 5PxD6sAjWXEruQ9pwa6y9DRAX1cKz6LHvyf4KdpLGDnmcF5UB1R2JbJ1bRrdGL3JEWQMn5rh98pp4PCdtpimFXgr 35
105 103 3KdSk7SMzzGMXqsSFi3kU9hYDpw8z7QdSWri4Rsjcd1eu44NU91q5jf1vZWszhBhaYwXt2k96gEdntxu3bd4oVWk 36
104 102 2hf4KHJ9EguRK4jxSB8st4uRTpiWktUdzx1Nti2zaDJsqJxtinGhryjT28GmYZoaoziKn47kyWAVD5KahvgCcvtx 37
103 101 3gP9JvKeDXF7ufoqjvU8jJc6qCD9fQnZpGrS5gdqQy6LxFRX9p83BcqgmihsP7qb828T6WXU1thyuWyFGzjCtZuK 38
102 100 DiroJD7ZDTmvYBSUfqTwgXDvRhRB1KrftmGzA5nwH6JArg1NH9jYT22qCYe1GG7HUP3FqgTvsYJvCghQmBHh5Zy 39
101 99 3dm34u1bfFQ5C4sQnbxwmj3BaZWKcPgBQg21BdmTbAgywZQKnn8KNhNeKJwUe7osU4vQiWKEhojYy8oATpMqGECd 40
100 98 2x5nwjaaUR4Hr9emNYtNagYi7hNjq68fNzyrAB86zEDnHN1mB6UrZ51d3dNi9q37R1vpswLwKGY3gfzZQf4Zz7VD 41
99 97 34d9drhaVEj2kYuS9F4unqoMXsJSKctfNDTa6o6xPfaELUeBttmtS6V4iJZarJVSmzgUMe7PsqrYd7rqLvpXTxhi 42
98 96 UUfDGkVH6XkR9xyMGKeAhPc4abnbL3aAp3drs59kiLTPPjz4tGH9NYxBtf2YQ3KGtRinVsjtZjbfFGDVVCT2mn5 43
97 95 4CoebXXYWPcEWMT2PRC3FuzPyK4Sx7Bvq7mvCnb8k6FWZP6TVbhRcaKQvVK7z8igcjRRGMPo9jYmiw2vJvZUDo6S 44
96 94 2TDZ6mTpRNuo9UF2c7Ew1sUczkHCVz7RxMLF9qs8DXLiPr4YBG1SA17jsdJCrtEFo3diuC1w29B8b5puMtTsp2Zk 45
95 93 5zVNi4hUSkHqv7t387rxVimzjD5JY9JdrFsV8KrPBzMqEyCtiiDiy9Twiio1KH7owoiy1n5CuHAqPJmnoqN5i77A 46
94 92 3jbVj8AaNPvcqFFaFagshAw9e9aGsxHUXTVKgHdC4jyQfS1dq368thQVWibM6G9Xjn5WiRR5h2kz39juRsibKPXH 47
93 91 5rWfNJRhsQ9j4T9Wu9ucNEjCAZ4Eepn3YiYvQhQnaEWUVj2ciiVDv9TBHhNm7mYn8ianW5MUY4oovs7RYURe7PLi 48
92 90 evqLSg48BpfsbSgNa6x1EHUxSXJsDNGKBz8rjBPaqhnuBTw2YuGv8ncyEjETM9NudFTrHHyaqgJZKStWTvWH1xc 49
91 89 5pnBzHtwVWSPjvhZXg7hp6H4MHihUUKfjvqHhoggj9QyGrFahJz1d2UwKKoJRRy3FGjuqYMpMuThdeeNpwpcR1tj 50
90 88 3m8VnwWxRYCeBtH1n8hd7D3AGMTbLFgKFmntkt71ksyFPiSpiRfcMTzYPXG4mKYAodKomAj5rUvdCo6dbG9SPs6c 51
89 87 5rWwPCGKTvQfGggP2w1mdgprTBJ2aBM6whsByi4yioYGsNdN5DDd4KTwV6pyUaFdXjN8DSCQSHdicW8f3iDQ9kMC 52
88 86 4AnHRV5VftxkZohz5z4SC3zaagGUAwUBb4bn6CVwXTZHc45u9bmdVrfVuKBQUwRrt9UVpixCRuZF3WKMH9d49kEL 53
87 10 5rshtU8wLMZjMW2jGe83HdBqPHau38yRHQ4pkxCvTF8p9wsPMCPdL5ZzZi93qTLepjcT2bQcVT9gs9GgHybH278k 54
86 85 2ZA7UDrtbNVa13pJNukWuq44rKZSfji6tzR4Eh5TRUCbuE1pEXbWapmXd4HkxZiZ9yUgytF5swWLnSZ1r1YK8pwQ 55
85 84 65no2Kf7sTGtH7XxuGwfTs2uTHnyZhrpVJeg1saiQw17etVwCqWKEyDpBYkVBPtsn9m7XXY3i1Q6m1ffYyCpTAdx 56
84 83 4F9r9xEwzFj3Dknm231V54V4SUyNudkUHGpd86eNgjZs1PbcVHdQVeDux3r7cnoijDv3QooHkL7txFXTsxuz5mQk 57
83 82 25hJTncxYX5zopaEZNpabLcBqcRTRsju3xBxWXXh5T7mRPk4Q22EG1NqopFGKChnGYv2fiB3cufukERfaKpiaSBp 58
82 81 4idED4ZrQW1oPTNLtW3JKUd86tTUybFjwsaka6hDKkPT8Tm88mJf8ciWBAPiQ7f15p8RhXjjRNgktF839xeBNvNF 59
81 80 5YkyZ6t5cuKAhuszEsa41WDkqfFZn9FZRLWhCpiQainr1RCYnophaEeNVnBLtqtjZzKVUJ7qsMCbcESYgifE6ZsU 60
80 79 3Gju7u58ZFneptGd6CxSpuNkibjv9A6JYwWqn3ixqviiW1PDtH16LSWQoJiEzqAciCWUUmWUQf6odTbEDTbHXrjx 61
79 78 5w9hQmJAmdDzJcYEcscRosrbCkyHzjCEf9yS6wUKUhvCzuhNRdfuNMZr6nfBY23r2f6ZcqjxAx57zMpFbHqhPwoS 62
78 77 3ujBha9XvUM5cuoHWeAVz8YTEB34DhJFZKZBMvVUx8gpbXeqiH1wffdLsK61ZFnvum1hgVus8HB7my3sDNBkqCkF 63
77 76 KWvd5XaR4bxHzJxkCaumU3iMyT4CiK4vbPvxjjzFsA6MtfNUWzrTxnNH2UVLtTqzqG4PdpayBydPtX3DBR3Jf2r 64
76 75 4DRBJDCaJ5xTn6RhPXL7UhHkvWdbkLLGQ5B7rtgBGkDLjLeR3oDTNeEiXv6suKYtZrwGPzgxnGWTntuvqgbEAdbD 65
75 74 5QCfNNAHfJiGDCW55dLQbJejpcJ2Bwa7hnzWBEMcCUtjtpd3VjdEU1h8LoiAmvZYfW4Mdef2xtNahcpSatdfztuE 66
74 73 2WLmFoYT82bqnNHBagekHdrMiyRBC38XRXSdGZrAcdbRSmmMpxkmaZKk68iDCTth7uEnp3VvberYV1YLRp8CG9HS 67
73 72 2PmQ2bUyv9Trw4CaTADAmXcePKq5vZadfGAoydPkFb2jVizdiZA2nLvSoa3rkGTds9UWtfNqMjT72UJRpFzmo5gP 68
72 71 27NG32brZPiFtYPSawMkK7mQAhS1WVEEMvFmu4QqkjWwAgUkj9DheX3FgYYisJZaFjPBfVr7jt6m54y44U94wrZA 69
71 70 g8AoDkYzYt7vLpW5txqWvPpa2Ar57TtU5k1m5ufVzAiac3qv8h1pKX9xnQZuMAXDkDBBVRa1HCNgNbzupk1dcXC 70
70 69 3BD4bVb8sxBhLALmTuKZLBoqqgzfNk5FuF8FhbWu98d4dkGwyZ29uQezE4ebB5psZRGJfxR8poPNMCXQ9o8Sb8dh 71
69 68 5UqXjT49W4fjtrvDVzmVZY7mH6D3WjSBugrbDXXtWUkEeXc6aqD9kZgwaaJDEbCN7QRWpthsK6vcQKYj7cNpwmxV 72
68 67 5d5gvFZ7DfRGD5d6J9eyRWb4F6NzUcrneDsQniBWXYTJh8Zhmhh4xeo5czKV3J5kg9ZpWFsmVZUU47SCNHvJiyzc 73
67 66 4TcLbwjYkSWJYtiBUNCKeYZiRz7ceE4pWMaN3hJGbXfhnmterWp2juqDVeFiD4wzziimWmfGXHNSWMC7MXtYjEdr 74
66 65 3miqHjSYYeHWBDwk7CXkDTQYWD92rbgh8fJFsWFhZw5Y9mDMeB38R7zY8QruUdUEWqEuq4wEAeA6q6ky9VB1YHSA 75
65 64 UUfh7p722aRh798NDNNoysrxjgzvGj9CMdkH86cuJVSMtqs3pXkNvJSC7zAmpyHyvJeFSnkqfcdcj42qZiNX2hw 76
64 63 4UiHYPYx7u4v2F4QL275XJepPFwW5SZYq8eynaSRRGwhyJ6wbSz1pWpsN4GwpNAcZWkUhePciGCvYoEhpD56MdjC 77
63 62 5BTrMsmsp5K91sMaADkxZtFMCW71GyCKdVmsAQbEVxpr11f7oUMeSJyQ6CoSo1nNzzHsSBJnZM2VN4K1ec8KkUDH 78
62 61 4ePsPaXo6qZGrkQwQZ3BqXed18w2qLrGgMyTPziyyc5pt9mQjMSxkkkGp3UBdPpk7XRcJCD38QB2gcrJqFZeu5RU 79
61 60 3Y4zaoV9P5Fws2LvyZpX3vXpM5eTaDnw8C3gyQ9dGDjKdafbbW3LMo34BEbjKkRsHV7RHBLgNLkpQycni9idGJJN 80
60 59 4RJCsh8n3JZRz7fdewdc43cVGddSPFbTj7JWWTWJ4JcwjerPUB7Mv3Whh44ypY2aND1k6jE6U14CYwx5EbdFyH3x 81
59 58 8WoXiH7DJYC3fiw1r4NNvKuj1D1438NXWAGNxxGsbF1enMVUgnv1wzsL5thLv1fxGDJyJWDRaQFLDCiFJ2Q78u8 82
58 57 3KLei5ACiDZHF3f67Zfi1hSQmAjHf5oZUs6dYCNt78muyAs66jLJ8idyVuiGsV5JvEHzxK1p1edWe6pA1H8iZinf 83
57 56 44xhU5gZzCLqCeh8R3eZkKr71KbAsvBVWr386Fq6y2jsoPwShV8A4nQfYbHZVWZLUtdyQ9EqbHHXSV4y6B42GXxS 84
56 55 2v4Fbmbqfgo3YBCtS4VgBNt29tYNGJyWNB8mWmVcYmh36BrkQHceWB9dmZKJsMDeCnHQGgT5vYdnsRYmC5g2cp5X 85
55 54 5VrL6ZJB9vJy4XZhXrHV7VkU1YXhM9rL7iqUkjXxpCPD75nWmg9qDwv4JsEjzZ4NKSvaU6SoyqV56hk4MB1R3ZKW 86
54 53 4NbHAKJd6nUmmD8AkVRiNwry1jmZQxEXUGt3pzagbMwngUMvbSULS8f9uz7rJ19jyDGBgKP8NnujW6mhYpieeCsm 87
53 52 4pBJdJZkeWbb771bgpNhRbDCp2VkMdC5SFwVp3hBVd5s61Uq43gxF7twire64JdFjraX7m7crPDgvorEYutWyZVy 88
52 51 4MXDMuZHqzb7HmZG1TRmChcysqzsixts1yjGtUhuauAk4pBcYanYQfKoX9jBdXmhLZssCJqABaAqRWD9Nd4Va9jN 89
51 50 3jbYFsQFRyjoZVMn2HnTU2m1wfgVQVXS5mqNN5KwrX7CXFYuTSnKUP2Q73sFNxNJMjAom4TQ3iUbttLpqhSyVSgj 90
50 49 Xo497PNmB5Vyj57KSNWeEtnqiaAksFmpMkjnscT8yqx1Q9PBxtfBXofFhCZT8JZw5dcuvEtZ6C47ELk8Gbo472R 91
49 48 5BSmcf9JxBn1GKR8JLZcxFKxGZSrNc3HjZkAHDWw7dZQAQGNjyVUv8MtvL77MvFsUmNVVjquHV8NhFKzrwQqzd8W 92
48 47 MfPbSsbFL9Wcwe1v4Ku9KbMFjchkLXaGiiDajuomCzJxLqVfStZQueWwKGpBh4nebaC54XgoRDZquB4MRDr5kHg 93
47 46 4N7gzJ2PZp2QNYwHVAgZgQvDSECdsdLs7vVQ7XG3uDxh27M1Mn2CYxSwzAsuiRhWozRyw5oqD1XHT86X7kbkJGRc 94
46 45 4qbwbbk1EKKk6GDqNNDmWyRYedyrDP9yJzoRrj8n6AfyKZwj1xiPHpnqb6kkFdE4HQ2k5PLtZ1tVn2STdVNKWsPz 95
45 44 2qynAfef3gcjLQ4bsRiA6cVYqsHKMvgH4ExKDQADbcd4q7MKzYzwgjPzr2P6mkqGgAwNE1Dg9iiGeLXwHdo84sZU 96
44 43 5j5wMCfU3TDVdK2WMFSMjjbPBkCBTyEy7H2R9zps8qqGfyTQRvLxQJtFxGkFnsNy63mXs2fA5HauzazDvyqXbA5s 97
43 42 DAB4cJNFCXfASQEpHivhz4i5fHaMXGpcu73RCJtoyZoZhkUrPbCwUrcAUM6AyWVEytKq9wv9N6hZR8G8HmxZdxL 98
42 41 4Z37qUwT3o2xaoySaa3uxEVnQUHYqspTKEKGtCfe1Cyc4PQGGcRutYbRDqAaTQ2TMomsAbL5g6V3bqZ6f1EsTUNi 99
41 40 2KSQAxs1gui4Uh6Etwi39MXTF4vZ9V9QCwKnNkkDC8gi6EhrANheAJvHW8MheYomT5X4hu1pR4wxh5cbiwiJmoEC 100
40 39 4KmGUGo5YZBDTfWCv8C2PSbm7Daw34KXZaFiR72WY1p1AXigFYhWAHkezyrtq7jmax2hjt8zpwjC7JxA2Q4mE95U 101
39 38 575dRXpCLUT9kkmJBBDHghK55MExPJrPfifqKg8hhQGE31nNgqo6Z5PAHUEUDxWo8qQLWWTJZG3sSwrFfBo31t3G 102
38 37 3YanJejeuLd7ZfLWC3tZJoXEb35WAgV1oGJokkyUC8eHg7eJLFGqeLw6ZdBpraYyDHwr6MdhsqtjrUK72z1y2uFV 103
37 36 51nJuFqtvNkafbzTwcsAhwGygJd3Fk3k277cctDnpR1PtC5bJnck5g2M3Ry2b4wjLFe7kkrJvHPgeMCiHfEfSB8a 104
36 35 27LuMCXp1ZLyRpLPhcYY3T3ub6CyRtsfGkeZJK3GTa3zAdgsxVgAsNRDdaby9kMxskNwQRiqG969SjghKb5e9Mxw 105
35 34 2p13T63ogvM6XjnfeoqsUrN6f56ybBC3Mjc69iGCybJDy8Xkp12cAVyjo2FzjUdPfjzh3Kw2vLfr96k8WNM5zMSn 106
34 33 2tDxihJ7VgBMs2zpdvYtXJE7TFfhigBP7CVUxwgi4brcmvULmj8ANPhAZdszbFDR7yyeutmWSPiKuQqXbPqGWG5B 107
33 32 4zmRQdPXeH6DXTHFHERmRw9yESeF71hB52G5mhpaSatnbPXAnpctPc5fGiUv2Bz4CEDHw8HtM3mu4tZ64DhE538u 108
32 31 3KNNnJBq1orGtwc772p5rMGJGiz9XGNNiYDkLz65QSu9BKHGpzgPwVEmE97az4d8EycQPBUahpQA1adYH3vjqX5j 109
31 30 hkwqNBuFe8J8y7NPAiqTq6oePWX6ea2iwa38DqFskuTZ86CMonL3mNAFCo259FBM71qsnzJapyWie2DKBSkZrV2 110
30 29 64XVL2RzNav6DSzU3hnz5C8v5xD4VhYdrJFrVgjSY5LToQBdhWbtWTgyi9yGqxiRQQgiZHTmSBcxq7oTrsZ4DWXQ 111
29 28 2hCZbfXDSBn5KtQF8TrE61zxe3qSWoham4KJjVzFTXYbWK3gC5tmueAExjQYnyisWMs4HHCst2kZy54dJCUmwBFf 112
28 27 2CPu3aMiwr9CkTTgopNC6hQpg7wh1t9cbMXqcgrnuQP4bJFHjVPtAaCiciyeFiSYCBF3iqtBHQ9PnRTiva7FjHuB 113
27 26 SWVz3LjyLvv1Z6nbZpK68W1zMkZAeMNHS2om3rtX9txT5o2bQ4JGZpKZTLjBYeD1TDbnuSrB41W5d2rvtaPoWGc 114
26 25 YeTLEkqwYWbSdgKTpADsavKWakJ43N9B1VXvEN4CND64HTM8uehMQZDB7DLxtgqGA515vZLYP9RsA6byKryTerB 115
25 24 4agdaJyMGdhGPwFFiuoCxGkw5WqK3PAP6i8pJkV4sF9zBPqZ9pgXX81wrf6eskr73bCsyaYmHwHptgTFxR2BEYbv 116
24 23 so9BAwNkmpo63dJXxAxcSmHqjAoFwDGJJhYmMRCCp5jZk3pqn6EA86FpQBk853x84Myy5JQGqCxCsmghVYjuDUS 117
23 22 2bH47JS5h98a3vHimCEQ8nUbHLg539YUAyvJgiNqXzoNwn5QRqfA5MGMeSYcFAcP9XiSxDnizBVB9syFR3gPRiZ2 118
22 21 2T14xBGrXntJwxm4eaa15LrVFbtK3gMjggy1yfFvGftnAk53wX28DkLM2dQVDTMPGcJdMvQPZFptt6rXDrejJvTG 119
21 20 5qrpLuThwUNPQNiqcdP47UEa8hb8pU7mDJJsuRdNaNVHqiuREsgC2XuTNHS2eDSkb8Q7fJ7tXvvPo4tNcBj6H3HH 120
20 19 3eeXx2o5DyvEua4njUVDkYTXoX7sgEgiC97Xgp3Xv4f3eQsRdYR9R5e4xWvGTbQ3z7MeDTLeuj3yi8SUwVz5Ym1d 121
19 18 4pVkgvH4JRGzYdCWfL1geGVMsmKPmdpcAP59mZbuV2N5mSSmN9FFk9SyJAJyanAk4L79LUBpXubeJtGKMjfBagGS 122
18 17 49phEiASpmx6jyoccQsXPjrnvryp3xZP55y6mck8cPDbZi4Aeu2cKnhrUeAx59PSVLkJgpEGYq8XzbGJXLxatzJ4 123
17 16 2bLpsXEUmeDpM96bGEq749HBkLGEH6JKqeBzBDhCafstFRRDAaN3S7VdKp7uyCvMUXujZinNYFeGSjzKa6MQPJRR 124
16 15 5TDeJ1bn3LwzN7Ys2cfCUf9twmm91GAVnEtYox8Jkg8rcf82wVtwcXaiW9en7JbtW3RxAusTvWWScjdFW2dpVZE4 125
15 14 2T2Ua1xFiNDjJuK7CrH3FDcVKGFgQE1V3e7dCE624Lr6xYaTpmbCkkKekjY4EKRzUsiGxKfgWgN1hnKwRRdT7bmy 126
14 13 5zeraxewequ8atTQ7pWYeZJS58o4EbAPkW5JrfmHdzraU2XGdU87XQkPNaZhXuTPLkgXZ8P58Uyt6CD9bMWKQ4pP 127
13 12 4n9HeG2SENW1ZbxWqSu318X792TWE8VuWvuMLCCzFGLNpXVTSyKvXy2p9S3xNssHSHironSZ9niMGHB7t3CbJoyr 128
12 11 51FJ78MCx3eTyTyYBoE7oTrRMCUnATra5wKRL6DJqwkYxippANwzJxjrXFnMCDYMEobzz45KVXzDUTxNWMcaBUvz 129
11 10 5STB6hFe2NqMTL35wC45Ur8ncDbi2sZRXzo88ZRbGur1BeNquwYD6DJoqHQq9QWGyALMaJMiKMtEmfyLMrCVk7xc 130
10 9 2uYoK4kVm5e3WDzxEvDfaNgGP1APxUiLyh8whJaJGGq8zBig26R9BoBn5iPXeDHr3WZiP8EMnuW8ycQqk6bL2kxu 131
9 8 3CG7BC8ZePEW2mY5z6z1tuo5d3HAS1SQujk9nqGC6KhYf2pbHP2MZVyUn9LjY4sKqPRe8JMMmq93AaJVTo7gnjsP 132
8 7 2ZmF8PjXCkSVLMX8QtZfmtUaeXAB1xGLQbVtSHMszvkxAJMgpMSspURPqNqRPZqe48J57JgJJefLkTdpKztWjU4L 133
7 6 4w9TbK3AEqqHMtuDvoQrshDQNc8aXgEMccj8cw3bEHxAF1uHEkEGRxmirXVuLwh2kfHNeHqXh6b37FR1DEEvreij 134
6 5 3V6zmcKi76xMAS77PFDfBFHLVMNVpTXAaqoKyd3iT2qGU6oo471KKahdK1dkWX1RHL9oCM6W8Y2SDG3HCGfFo4j2 135
5 4 5XYedd2gNGCAbq8e6W53YvchcyRdYhexGivuTYLazQY71xNCKycRvGk6A64vCRdv7Qpc6pfqjAduiAsrYXpxCRPZ 136
4 3 5UsSA6wK6nmmNRXUGTbCh3A2RjxEFcGynn9UeUx6MfcqEsfUSaSxBEK9fkivAmMcSShKMdVV3LM6qXJFukUJekoU 137
3 2 M4MfqFArW5NdWHqDTmvYb7rfe9MipgjfaaTWh9FfB2DngqoHHzr8RUxx4ynUKyCUTc89k9ApuJzwhvJw1okfUJ8 138
2 1 fKXbfsjs4S5i9QP5gGWJfjAi7weHyxa8mNwUMShjpur4g8iJEWGMrahz6T22Sa59e8TjUXBoV4qKHbPqSpp5e3v 139
1 0 4t2VzdcbMkKFDwDR9Lge42Y7KBn1DKyRhj6qNWWKcioTDqQssZVHbXCLNQnVEcb8sMoDrYgbuut8AKeyq9t7vVxT 140
0 0 5vdnmVY2ghDW1BBCJZHU6gXeH6mB89AzCUdFKDobkLoF52vPN8CHjq99njnrqqqxLdfV4AkXnbnjEsdsnMGndvw5 141

@linuskendall
Copy link
Collaborator Author

However, in all these cases it looks like in cl_items the seq for the mint instruction is missing but the asset still exists in the assets table.

@linuskendall
Copy link
Collaborator Author

I see, this actually make sense since

        let mut query = cl_items::Entity::insert(item)
            .on_conflict(
                OnConflict::columns([cl_items::Column::Tree, cl_items::Column::NodeIdx])
                    .update_columns([
                        cl_items::Column::Hash,
                        cl_items::Column::Seq,
                        cl_items::Column::LeafIdx,
                        cl_items::Column::Level,
                    ])
                    .to_owned(),
            )
            .build(DbBackend::Postgres);
        if !filling {
            query.sql = format!("{} WHERE excluded.seq > cl_items.seq", query.sql);
        }

So these sequence numbers were ingested correctly but then just overridden.. Now I'm not clear quite still how the metaplex indexer handles the scenario where the Transfer transaction would be indexed before the Mint one.

@linuskendall
Copy link
Collaborator Author

After discussion with @austbot and @danenbm I believe the missing sequences here are not in themselves a problem with this tree. We'll be checking further to making sure that it isn't. There is however a potential problem is #71 .

@linuskendall linuskendall changed the title MIssing sequences Missing sequences May 11, 2023
@linuskendall
Copy link
Collaborator Author

Believe this has been solved.

muhitrhn pushed a commit to muhitrhn/digital-asset-rpc-infrastructure that referenced this issue Oct 6, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants