user7251: Chain index is not syncing in tesnet after Slot: 62510369,
BlockId: d931221f9bc4cae34de422d9f4281a2b0344e86aac6b31eb54e2ee90f44a09b9
I converted to POSIX TIME and is: Friday, 22 July 2022 8:19:45.999 AM, related with the time frame of the new babbage era.
I download and built the latest plutus apps (commit 139c0429f2c7a656ff6114e6373f895d29132860) and syncing from zero again with no success.
Im using with cardano-node-1.35.0-linux which is syncing 100%.
There was similar issues with cardano-db-sync and they said they fix the issue there.
https://github.com/input-output-hk/cardano-db-sync/issues/1181
https://github.com/input-output-hk/cardano-db-sync/issues/1182
Here also, some report about the chain index rolling back slots after this slot:
https://github.com/input-output-hk/plutus-apps/pull/557
Any idea?
Im Running in WSL2 with Ubuntu.
The message from chain index is:
[chain-index:Info:33] [2022-07-17 01:06:05.64 UTC] Syncing (98.21%). Processed 0 blocks, 1 rollbacks in the last 12s. Current tip is Point(Slot 62510369, BlockId d931221f9bc4cae34de422d9f4281a2b0344e86aac6b31eb54e2ee90f44a09b9)
Here is full detaiuled run of chain index with verbose:
Command line config:
AppConfig {acLogConfigPath = Nothing, acMinLogLevel = Just Debug, acConfigPath = Just "/home/manuelpadilla/source/cardano-falcon-stakepool-devs/cardano-falcon-stakepol-devs-haskell/files/config/cardano-chain-index/chain-index-config.json", acCLIConfigOverrides = CLIConfigOverrides {ccSocketPath = Nothing, ccDbPath = Nothing, ccPort = Nothing, ccNetworkId = Nothing, ccAppendTransactionQueueSize = Nothing}, acCommand = StartChainIndex}

Logging config:
Representation {minSeverity = Debug, rotation = Nothing, setupScribes = [ScribeDefinition {scKind = StdoutSK, scFormat = ScText, scName = "stdout", scPrivacy = ScPublic, scRotation = Nothing, scMinSev = Debug, scMaxSev = Emergency}], defaultScribes = [(StdoutSK,"stdout")], setupBackends = [KatipBK,AggregationBK,MonitoringBK,EKGViewBK], defaultBackends = [KatipBK,AggregationBK,EKGViewBK], hasEKG = Just (Endpoint ("localhost",12790)), hasGraylog = Nothing, hasPrometheus = Nothing, hasGUI = Nothing, traceForwardTo = Nothing, forwardDelay = Nothing, traceAcceptAt = Nothing, options = fromList []}

Chain Index config:
Socket: /home/manuelpadilla/source/tools/cardano-node-1.35.0-linux2/db/node.socket
Db: /home/manuelpadilla/source/tools/cardano-chain-index/chain-index.db
Port: 9083
Network Id: Testnet (NetworkMagic {unNetworkMagic = 1097911063})
Security Param: 2160
Store from: BlockNo 0
Append transaction queue size: 500

The tip of the local node: SlotNo 63654709
Connecting to the node using socket: /home/manuelpadilla/source/tools/cardano-node-1.35.0-linux2/db/node.socket
[chain-index:Debug:11] [2022-07-17 02:13:00.78 UTC] BeamLogItem: SqlLog: SELECT "t0"."row_slot" AS "res0", "t0"."row_block_id" AS "res1", "t0"."row_block_number" AS "res2" FROM "tips" AS "t0" ORDER BY "t0"."row_slot" DESC;
-- With values: []
Starting webserver on port 9083
A Swagger UI for the endpoints are available at http://localhost:9083/swagger/swagger-ui
[chain-index:Debug:33] [2022-07-17 02:13:02.79 UTC] BeamLogItem: SqlLog: DELETE FROM "tips" WHERE ("row_slot")>(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:02.79 UTC] BeamLogItem: SqlLog: DELETE FROM "utxo_out_refs" WHERE EXISTS (SELECT "t0"."output_row_tip__row_slot" AS "res0", "t0"."output_row_out_ref" AS "res1" FROM "unspent_outputs" AS "t0" WHERE (("t0"."output_row_tip__row_slot")>(?)) AND (("row_out_ref")=("t0"."output_row_out_ref")));
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:14.08 UTC] BeamLogItem: SqlLog: DELETE FROM "unspent_outputs" WHERE ("output_row_tip__row_slot")>(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:14.08 UTC] BeamLogItem: SqlLog: DELETE FROM "unmatched_inputs" WHERE ("input_row_tip__row_slot")>(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:14.08 UTC] BeamLogItem: SqlLog: SELECT "t0"."output_row_tip__row_slot" AS "res0", "t0"."output_row_out_ref" AS "res1" FROM "unspent_outputs" AS "t0";
-- With values: []
[chain-index:Debug:33] [2022-07-17 02:13:14.79 UTC] BeamLogItem: SqlLog: SELECT "t0"."input_row_tip__row_slot" AS "res0", "t0"."input_row_out_ref" AS "res1" FROM "unmatched_inputs" AS "t0";
-- With values: []
[chain-index:Debug:33] [2022-07-17 02:13:14.86 UTC] BeamLogItem: SqlLog: SELECT "t0"."row_slot" AS "res0", "t0"."row_block_id" AS "res1", "t0"."row_block_number" AS "res2" FROM "tips" AS "t0" ORDER BY "t0"."row_slot" ASC;
-- With values: []
[chain-index:Debug:33] [2022-07-17 02:13:15.85 UTC] BeamLogItem: SqlLog: DELETE FROM "tips" WHERE ("row_slot")>(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:15.86 UTC] BeamLogItem: SqlLog: DELETE FROM "utxo_out_refs" WHERE EXISTS (SELECT "t0"."output_row_tip__row_slot" AS "res0", "t0"."output_row_out_ref" AS "res1" FROM "unspent_outputs" AS "t0" WHERE (("t0"."output_row_tip__row_slot")>(?)) AND (("row_out_ref")=("t0"."output_row_out_ref")));
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:27.56 UTC] BeamLogItem: SqlLog: DELETE FROM "unspent_outputs" WHERE ("output_row_tip__row_slot")>(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:27.56 UTC] BeamLogItem: SqlLog: DELETE FROM "unmatched_inputs" WHERE ("input_row_tip__row_slot")>(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:27.56 UTC] RollbackSuccess: New tip is Tip(Slot 62510369, BlockId d931221f9bc4cae34de422d9f4281a2b0344e86aac6b31eb54e2ee90f44a09b9, BlockNumber 3680594)
[chain-index:Debug:33] [2022-07-17 02:13:27.56 UTC] BeamLogItem: SqlLog: DELETE FROM "tips" WHERE ("row_slot")>(?);
-- With values: [SQLInteger 62510369]
[chain-index:Info:33] [2022-07-17 02:13:27.56 UTC] Syncing (98.20%). Processed 0 blocks, 1 rollbacks in the last 11s. Current tip is Point(Slot 62510369, BlockId d931221f9bc4cae34de422d9f4281a2b0344e86aac6b31eb54e2ee90f44a09b9)
[chain-index:Debug:33] [2022-07-17 02:13:27.56 UTC] BeamLogItem: SqlLog: DELETE FROM "utxo_out_refs" WHERE EXISTS (SELECT "t0"."output_row_tip__row_slot" AS "res0", "t0"."output_row_out_ref" AS "res1" FROM "unspent_outputs" AS "t0" WHERE (("t0"."output_row_tip__row_slot")>(?)) AND (("row_out_ref")=("t0"."output_row_out_ref")));
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:39.04 UTC] BeamLogItem: SqlLog: DELETE FROM "unspent_outputs" WHERE ("output_row_tip__row_slot")>(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:39.04 UTC] BeamLogItem: SqlLog: DELETE FROM "unmatched_inputs" WHERE ("input_row_tip__row_slot")>(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:39.04 UTC] BeamLogItem: SqlLog: SELECT "t0"."output_row_tip__row_slot" AS "res0", "t0"."output_row_out_ref" AS "res1" FROM "unspent_outputs" AS "t0";
-- With values: []
[chain-index:Debug:33] [2022-07-17 02:13:39.68 UTC] BeamLogItem: SqlLog: SELECT "t0"."input_row_tip__row_slot" AS "res0", "t0"."input_row_out_ref" AS "res1" FROM "unmatched_inputs" AS "t0";
-- With values: []
[chain-index:Debug:33] [2022-07-17 02:13:39.77 UTC] BeamLogItem: SqlLog: SELECT "t0"."row_slot" AS "res0", "t0"."row_block_id" AS "res1", "t0"."row_block_number" AS "res2" FROM "tips" AS "t0" ORDER BY "t0"."row_slot" ASC;
-- With values: []
[chain-index:Debug:33] [2022-07-17 02:13:40.69 UTC] BeamLogItem: SqlLog: DELETE FROM "tips" WHERE ("row_slot")>(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:40.69 UTC] BeamLogItem: SqlLog: DELETE FROM "utxo_out_refs" WHERE EXISTS (SELECT "t0"."output_row_tip__row_slot" AS "res0", "t0"."output_row_out_ref" AS "res1" FROM "unspent_outputs" AS "t0" WHERE (("t0"."output_row_tip__row_slot")>(?)) AND (("row_out_ref")=("t0"."output_row_out_ref")));
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:52.59 UTC] BeamLogItem: SqlLog: DELETE FROM "unspent_outputs" WHERE ("output_row_tip__row_slot")>(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:52.59 UTC] BeamLogItem: SqlLog: DELETE FROM "unmatched_inputs" WHERE ("input_row_tip__row_slot")>(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:52.59 UTC] RollbackSuccess: New tip is Tip(Slot 62510369, BlockId d931221f9bc4cae34de422d9f4281a2b0344e86aac6b31eb54e2ee90f44a09b9, BlockNumber 3680594)
[chain-index:Info:33] [2022-07-17 02:13:52.59 UTC] Syncing (98.20%). Processed 0 blocks, 1 rollbacks in the last 11s. Current tip is Point(Slot 62510369, BlockId d931221f9bc4cae34de422d9f4281a2b0344e86aac6b31eb54e2ee90f44a09b9)
[chain-index:Debug:33] [2022-07-17 02:13:52.59 UTC] BeamLogItem: SqlLog: DELETE FROM "tips" WHERE ("row_slot")>(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:52.59 UTC] BeamLogItem: SqlLog: DELETE FROM "utxo_out_refs" WHERE EXISTS (SELECT "t0"."output_row_tip__row_slot" AS "res0", "t0"."output_row_out_ref" AS "res1" FROM "unspent_outputs" AS "t0" WHERE (("t0"."output_row_tip__row_slot")>(?)) AND (("row_out_ref")=("t0"."output_row_out_ref")));
-- With values: [SQLInteger 62510369]


user252: Similar to cardano-db-sync references you found, every repo that is interacting with node has to go through updates to be able to read blocks post Vasil H/F.

Here also, some report about the chain index rolling back slots after this slot: https://github.com/input-output-hk/plutus-apps/pull/557

As mentioned in the issue, the work for compatibility with Vasil for plutus-apps is being done in next-node branch, it's not yet ready for PAB and will likely be part of upcoming release.

7251: <p>Chain index is not syncing in tesnet after Slot: 62510369,
BlockId: d931221f9bc4cae34de422d9f4281a2b0344e86aac6b31eb54e2ee90f44a09b9</p>
<p>I converted to POSIX TIME and is: Friday, 22 July 2022 8:19:45.999 AM, related with the time frame of the new babbage era.</p>
<p>I download and built the latest plutus apps (commit 139c0429f2c7a656ff6114e6373f895d29132860) and syncing from zero again with no success.
Im using with cardano-node-1.35.0-linux which is syncing 100%.</p>
<p>There was similar issues with cardano-db-sync and they said they fix the issue there.
<a href="https://github.com/input-output-hk/cardano-db-sync/issues/1181" rel="nofollow noreferrer">https://github.com/input-output-hk/cardano-db-sync/issues/1181</a>
<a href="https://github.com/input-output-hk/cardano-db-sync/issues/1182" rel="nofollow noreferrer">https://github.com/input-output-hk/cardano-db-sync/issues/1182</a></p>
<p>Here also, some report about the chain index rolling back slots after this slot:
<a href="https://github.com/input-output-hk/plutus-apps/pull/557" rel="nofollow noreferrer">https://github.com/input-output-hk/plutus-apps/pull/557</a></p>
<p>Any idea?</p>
<p>Im Running in WSL2 with Ubuntu.</p>
<p>The message from chain index is:</p>
<p>[chain-index:Info:33] [2022-07-17 01:06:05.64 UTC] Syncing (98.21%). Processed 0 blocks, 1 rollbacks in the last 12s. Current tip is Point(Slot 62510369, BlockId d931221f9bc4cae34de422d9f4281a2b0344e86aac6b31eb54e2ee90f44a09b9)</p>
<p>Here is full detaiuled run of chain index with verbose:</p>
<pre><code>Command line config:
AppConfig {acLogConfigPath = Nothing, acMinLogLevel = Just Debug, acConfigPath = Just &quot;/home/manuelpadilla/source/cardano-falcon-stakepool-devs/cardano-falcon-stakepol-devs-haskell/files/config/cardano-chain-index/chain-index-config.json&quot;, acCLIConfigOverrides = CLIConfigOverrides {ccSocketPath = Nothing, ccDbPath = Nothing, ccPort = Nothing, ccNetworkId = Nothing, ccAppendTransactionQueueSize = Nothing}, acCommand = StartChainIndex}

Logging config:
Representation {minSeverity = Debug, rotation = Nothing, setupScribes = [ScribeDefinition {scKind = StdoutSK, scFormat = ScText, scName = &quot;stdout&quot;, scPrivacy = ScPublic, scRotation = Nothing, scMinSev = Debug, scMaxSev = Emergency}], defaultScribes = [(StdoutSK,&quot;stdout&quot;)], setupBackends = [KatipBK,AggregationBK,MonitoringBK,EKGViewBK], defaultBackends = [KatipBK,AggregationBK,EKGViewBK], hasEKG = Just (Endpoint (&quot;localhost&quot;,12790)), hasGraylog = Nothing, hasPrometheus = Nothing, hasGUI = Nothing, traceForwardTo = Nothing, forwardDelay = Nothing, traceAcceptAt = Nothing, options = fromList []}

Chain Index config:
Socket: /home/manuelpadilla/source/tools/cardano-node-1.35.0-linux2/db/node.socket
Db: /home/manuelpadilla/source/tools/cardano-chain-index/chain-index.db
Port: 9083
Network Id: Testnet (NetworkMagic {unNetworkMagic = 1097911063})
Security Param: 2160
Store from: BlockNo 0
Append transaction queue size: 500

The tip of the local node: SlotNo 63654709
Connecting to the node using socket: /home/manuelpadilla/source/tools/cardano-node-1.35.0-linux2/db/node.socket
[chain-index:Debug:11] [2022-07-17 02:13:00.78 UTC] BeamLogItem: SqlLog: SELECT &quot;t0&quot;.&quot;row_slot&quot; AS &quot;res0&quot;, &quot;t0&quot;.&quot;row_block_id&quot; AS &quot;res1&quot;, &quot;t0&quot;.&quot;row_block_number&quot; AS &quot;res2&quot; FROM &quot;tips&quot; AS &quot;t0&quot; ORDER BY &quot;t0&quot;.&quot;row_slot&quot; DESC;
-- With values: []
Starting webserver on port 9083
A Swagger UI for the endpoints are available at http://localhost:9083/swagger/swagger-ui
[chain-index:Debug:33] [2022-07-17 02:13:02.79 UTC] BeamLogItem: SqlLog: DELETE FROM &quot;tips&quot; WHERE (&quot;row_slot&quot;)&gt;(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:02.79 UTC] BeamLogItem: SqlLog: DELETE FROM &quot;utxo_out_refs&quot; WHERE EXISTS (SELECT &quot;t0&quot;.&quot;output_row_tip__row_slot&quot; AS &quot;res0&quot;, &quot;t0&quot;.&quot;output_row_out_ref&quot; AS &quot;res1&quot; FROM &quot;unspent_outputs&quot; AS &quot;t0&quot; WHERE ((&quot;t0&quot;.&quot;output_row_tip__row_slot&quot;)&gt;(?)) AND ((&quot;row_out_ref&quot;)=(&quot;t0&quot;.&quot;output_row_out_ref&quot;)));
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:14.08 UTC] BeamLogItem: SqlLog: DELETE FROM &quot;unspent_outputs&quot; WHERE (&quot;output_row_tip__row_slot&quot;)&gt;(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:14.08 UTC] BeamLogItem: SqlLog: DELETE FROM &quot;unmatched_inputs&quot; WHERE (&quot;input_row_tip__row_slot&quot;)&gt;(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:14.08 UTC] BeamLogItem: SqlLog: SELECT &quot;t0&quot;.&quot;output_row_tip__row_slot&quot; AS &quot;res0&quot;, &quot;t0&quot;.&quot;output_row_out_ref&quot; AS &quot;res1&quot; FROM &quot;unspent_outputs&quot; AS &quot;t0&quot;;
-- With values: []
[chain-index:Debug:33] [2022-07-17 02:13:14.79 UTC] BeamLogItem: SqlLog: SELECT &quot;t0&quot;.&quot;input_row_tip__row_slot&quot; AS &quot;res0&quot;, &quot;t0&quot;.&quot;input_row_out_ref&quot; AS &quot;res1&quot; FROM &quot;unmatched_inputs&quot; AS &quot;t0&quot;;
-- With values: []
[chain-index:Debug:33] [2022-07-17 02:13:14.86 UTC] BeamLogItem: SqlLog: SELECT &quot;t0&quot;.&quot;row_slot&quot; AS &quot;res0&quot;, &quot;t0&quot;.&quot;row_block_id&quot; AS &quot;res1&quot;, &quot;t0&quot;.&quot;row_block_number&quot; AS &quot;res2&quot; FROM &quot;tips&quot; AS &quot;t0&quot; ORDER BY &quot;t0&quot;.&quot;row_slot&quot; ASC;
-- With values: []
[chain-index:Debug:33] [2022-07-17 02:13:15.85 UTC] BeamLogItem: SqlLog: DELETE FROM &quot;tips&quot; WHERE (&quot;row_slot&quot;)&gt;(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:15.86 UTC] BeamLogItem: SqlLog: DELETE FROM &quot;utxo_out_refs&quot; WHERE EXISTS (SELECT &quot;t0&quot;.&quot;output_row_tip__row_slot&quot; AS &quot;res0&quot;, &quot;t0&quot;.&quot;output_row_out_ref&quot; AS &quot;res1&quot; FROM &quot;unspent_outputs&quot; AS &quot;t0&quot; WHERE ((&quot;t0&quot;.&quot;output_row_tip__row_slot&quot;)&gt;(?)) AND ((&quot;row_out_ref&quot;)=(&quot;t0&quot;.&quot;output_row_out_ref&quot;)));
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:27.56 UTC] BeamLogItem: SqlLog: DELETE FROM &quot;unspent_outputs&quot; WHERE (&quot;output_row_tip__row_slot&quot;)&gt;(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:27.56 UTC] BeamLogItem: SqlLog: DELETE FROM &quot;unmatched_inputs&quot; WHERE (&quot;input_row_tip__row_slot&quot;)&gt;(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:27.56 UTC] RollbackSuccess: New tip is Tip(Slot 62510369, BlockId d931221f9bc4cae34de422d9f4281a2b0344e86aac6b31eb54e2ee90f44a09b9, BlockNumber 3680594)
[chain-index:Debug:33] [2022-07-17 02:13:27.56 UTC] BeamLogItem: SqlLog: DELETE FROM &quot;tips&quot; WHERE (&quot;row_slot&quot;)&gt;(?);
-- With values: [SQLInteger 62510369]
[chain-index:Info:33] [2022-07-17 02:13:27.56 UTC] Syncing (98.20%). Processed 0 blocks, 1 rollbacks in the last 11s. Current tip is Point(Slot 62510369, BlockId d931221f9bc4cae34de422d9f4281a2b0344e86aac6b31eb54e2ee90f44a09b9)
[chain-index:Debug:33] [2022-07-17 02:13:27.56 UTC] BeamLogItem: SqlLog: DELETE FROM &quot;utxo_out_refs&quot; WHERE EXISTS (SELECT &quot;t0&quot;.&quot;output_row_tip__row_slot&quot; AS &quot;res0&quot;, &quot;t0&quot;.&quot;output_row_out_ref&quot; AS &quot;res1&quot; FROM &quot;unspent_outputs&quot; AS &quot;t0&quot; WHERE ((&quot;t0&quot;.&quot;output_row_tip__row_slot&quot;)&gt;(?)) AND ((&quot;row_out_ref&quot;)=(&quot;t0&quot;.&quot;output_row_out_ref&quot;)));
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:39.04 UTC] BeamLogItem: SqlLog: DELETE FROM &quot;unspent_outputs&quot; WHERE (&quot;output_row_tip__row_slot&quot;)&gt;(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:39.04 UTC] BeamLogItem: SqlLog: DELETE FROM &quot;unmatched_inputs&quot; WHERE (&quot;input_row_tip__row_slot&quot;)&gt;(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:39.04 UTC] BeamLogItem: SqlLog: SELECT &quot;t0&quot;.&quot;output_row_tip__row_slot&quot; AS &quot;res0&quot;, &quot;t0&quot;.&quot;output_row_out_ref&quot; AS &quot;res1&quot; FROM &quot;unspent_outputs&quot; AS &quot;t0&quot;;
-- With values: []
[chain-index:Debug:33] [2022-07-17 02:13:39.68 UTC] BeamLogItem: SqlLog: SELECT &quot;t0&quot;.&quot;input_row_tip__row_slot&quot; AS &quot;res0&quot;, &quot;t0&quot;.&quot;input_row_out_ref&quot; AS &quot;res1&quot; FROM &quot;unmatched_inputs&quot; AS &quot;t0&quot;;
-- With values: []
[chain-index:Debug:33] [2022-07-17 02:13:39.77 UTC] BeamLogItem: SqlLog: SELECT &quot;t0&quot;.&quot;row_slot&quot; AS &quot;res0&quot;, &quot;t0&quot;.&quot;row_block_id&quot; AS &quot;res1&quot;, &quot;t0&quot;.&quot;row_block_number&quot; AS &quot;res2&quot; FROM &quot;tips&quot; AS &quot;t0&quot; ORDER BY &quot;t0&quot;.&quot;row_slot&quot; ASC;
-- With values: []
[chain-index:Debug:33] [2022-07-17 02:13:40.69 UTC] BeamLogItem: SqlLog: DELETE FROM &quot;tips&quot; WHERE (&quot;row_slot&quot;)&gt;(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:40.69 UTC] BeamLogItem: SqlLog: DELETE FROM &quot;utxo_out_refs&quot; WHERE EXISTS (SELECT &quot;t0&quot;.&quot;output_row_tip__row_slot&quot; AS &quot;res0&quot;, &quot;t0&quot;.&quot;output_row_out_ref&quot; AS &quot;res1&quot; FROM &quot;unspent_outputs&quot; AS &quot;t0&quot; WHERE ((&quot;t0&quot;.&quot;output_row_tip__row_slot&quot;)&gt;(?)) AND ((&quot;row_out_ref&quot;)=(&quot;t0&quot;.&quot;output_row_out_ref&quot;)));
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:52.59 UTC] BeamLogItem: SqlLog: DELETE FROM &quot;unspent_outputs&quot; WHERE (&quot;output_row_tip__row_slot&quot;)&gt;(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:52.59 UTC] BeamLogItem: SqlLog: DELETE FROM &quot;unmatched_inputs&quot; WHERE (&quot;input_row_tip__row_slot&quot;)&gt;(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:52.59 UTC] RollbackSuccess: New tip is Tip(Slot 62510369, BlockId d931221f9bc4cae34de422d9f4281a2b0344e86aac6b31eb54e2ee90f44a09b9, BlockNumber 3680594)
[chain-index:Info:33] [2022-07-17 02:13:52.59 UTC] Syncing (98.20%). Processed 0 blocks, 1 rollbacks in the last 11s. Current tip is Point(Slot 62510369, BlockId d931221f9bc4cae34de422d9f4281a2b0344e86aac6b31eb54e2ee90f44a09b9)
[chain-index:Debug:33] [2022-07-17 02:13:52.59 UTC] BeamLogItem: SqlLog: DELETE FROM &quot;tips&quot; WHERE (&quot;row_slot&quot;)&gt;(?);
-- With values: [SQLInteger 62510369]
[chain-index:Debug:33] [2022-07-17 02:13:52.59 UTC] BeamLogItem: SqlLog: DELETE FROM &quot;utxo_out_refs&quot; WHERE EXISTS (SELECT &quot;t0&quot;.&quot;output_row_tip__row_slot&quot; AS &quot;res0&quot;, &quot;t0&quot;.&quot;output_row_out_ref&quot; AS &quot;res1&quot; FROM &quot;unspent_outputs&quot; AS &quot;t0&quot; WHERE ((&quot;t0&quot;.&quot;output_row_tip__row_slot&quot;)&gt;(?)) AND ((&quot;row_out_ref&quot;)=(&quot;t0&quot;.&quot;output_row_out_ref&quot;)));
-- With values: [SQLInteger 62510369]
</code></pre>
 252: <p>Similar to cardano-db-sync references you found, every repo that is interacting with node has to go through updates to be able to read blocks post Vasil H/F.</p>
<blockquote>
<p>Here also, some report about the chain index rolling back slots after this slot: <a href="https://github.com/input-output-hk/plutus-apps/pull/557" rel="nofollow noreferrer">https://github.com/input-output-hk/plutus-apps/pull/557</a></p>
</blockquote>
<p>As mentioned in the issue, the work for compatibility with Vasil for plutus-apps is being done in <a href="https://github.com/input-output-hk/plutus-apps/tree/next-node" rel="nofollow noreferrer">next-node</a> branch, it's not yet ready for PAB and will likely be part of upcoming release.</p>
