user6809: I recently created a new server and install of Cardano node and db sync (1.34.1 & 12.0.2) on same machine. I implemented the snapshot restore to bring the Postgres DB up to EPOCH 325 and was able to successfully connect and query the data without issue.  However, now I would like for DB sync to start loading any new (delta) data beyond EPOCH 325, but the DB sync appears to be "sitting" at an operation called "Deleting 8751 blocks up to slot 55342638".  The operation has been running for 10+ hours and I'm starting to become concerned that the DB sync is not working.
NOTE
I do understand that the DB sync operation can take a considerable amount of time, especially for the more recent blocks.  However, from a data processing perspective this is getting hard to comprehend, especially without being able to see logs or events that could show progress.
I'm sure others are experiencing the same issue and if you were able to find a solution, please do share.  All help is very much appreciated.

user4771: I have the same issue. Because of corrupted connection to a remote cardano-node.
After connection got fixed, db-sync still wants to remove 203 blocks (the other day 213) and that takes forever.

Mar 31 14:13:46 ip-10-31-12-145 cardano-db-sync[682]: [db-sync-node:Info:59] [2022-03-31 14:13:46.35 UTC] Deleting 203 blocks up to slot 57168135

Actually, I have never seen db-sync to finish that procedure and I was always switching to manual snapshot restore procedure, that is more predictable in that case.
My machine is beefy AWS instance running dbsync and postgres v14 only.
I would appreciate any Postgres troubleshooting tips.
db-sync logs show nothing after message about deletion.
In processes I see:

postgres     776     663 98 14:13 ?        00:17:00 postgres: 14/main: cardano mainnet [local] DELETE


user5926: I am the main dev on db-sync.

"Deleting 8751 blocks up to slot 55342638"

The message that is to be expected right after that is "Blocks deleted", but deleting 8751 blocks should only take 10s of minutes at most providing the machine you are running on meets the minimum system requirements.

6809: <p>I recently created a new server and install of Cardano node and db sync (1.34.1 &amp; 12.0.2) on same machine. I implemented the snapshot restore to bring the Postgres DB up to EPOCH 325 and was able to successfully connect and query the data without issue.  However, now I would like for DB sync to start loading any new (delta) data beyond EPOCH 325, but the DB sync appears to be &quot;sitting&quot; at an operation called &quot;Deleting 8751 blocks up to slot 55342638&quot;.  The operation has been running for 10+ hours and I'm starting to become concerned that the DB sync is not working.</p>
<p><em>NOTE</em>
I do understand that the DB sync operation can take a considerable amount of time, especially for the more recent blocks.  However, from a data processing perspective this is getting hard to comprehend, especially without being able to see logs or events that could show progress.</p>
<p>I'm sure others are experiencing the same issue and if you were able to find a solution, please do share.  All help is very much appreciated.</p>
 4771: <p>I have the same issue. Because of corrupted connection to a remote cardano-node.
After connection got fixed, db-sync still wants to remove 203 blocks (the other day 213) and that takes forever.</p>
<blockquote>
<p>Mar 31 14:13:46 ip-10-31-12-145 cardano-db-sync[682]: [db-sync-node:Info:59] [2022-03-31 14:13:46.35 UTC] Deleting 203 blocks up to slot 57168135</p>
</blockquote>
<p>Actually, I have never seen db-sync to finish that procedure and I was always switching to manual snapshot restore procedure, that is more predictable in that case.</p>
<p>My machine is beefy AWS instance running dbsync and postgres v14 only.</p>
<p>I would appreciate any Postgres troubleshooting tips.</p>
<p>db-sync logs show nothing after message about deletion.
In processes I see:</p>
<blockquote>
<p>postgres     776     663 98 14:13 ?        00:17:00 postgres: 14/main: cardano mainnet [local] DELETE</p>
</blockquote>
 5926: <p>I am the main dev on <code>db-sync</code>.</p>
<blockquote>
<p>&quot;Deleting 8751 blocks up to slot 55342638&quot;</p>
</blockquote>
<p>The message that is to be expected right after that is &quot;Blocks deleted&quot;, but deleting 8751 blocks should only take 10s of minutes at most providing the machine you are running on <a href="https://github.com/input-output-hk/cardano-db-sync#system-requirements" rel="nofollow noreferrer">meets the minimum system requirements</a>.</p>
