Cardano-db-Sync-Extended -> Error 814-808 errMessage = "Failed reading: takeWhile1"

Developers Cardano Integration
1

Hi everyone,

Can someone help me with this, please?

I’m synching cardano-db-sync-extended(mainNet), but I got stuck on epoch 208, slot_no 4803040, block_no 4506000, with the following error:

Any suggestions for what to do ?

[db-sync-node:Error:814] [2021-04-23 10:36:49.22 UTC] runDBThread: ConversionFailed {errSQLType = “numeric”, errSQLTableOid = Just (Oid 2416872704), errSQLField = “p\225\US\144\239\DEL”, errHaskellType = “Ratio Integer”, errMessage = “Failed reading: takeWhile1”}
[db-sync-node:Error:817] [2021-04-23 10:36:49.22 UTC] recvMsgRollForward: AsyncCancelled
[db-sync-node:Error:808] [2021-04-23 10:36:49.22 UTC] ChainSyncWithBlocksPtcl: ConversionFailed {errSQLType = “numeric”, errSQLTableOid = Just (Oid 2416872704), errSQLField = “p\225\US\144\239\DEL”, errHaskellType = “Ratio Integer”, errMessage = “Failed reading: takeWhile1”}
[db-sync-node.Mux:Info:805] [2021-04-23 10:36:49.22 UTC] Bearer on ConnectionId {localAddress = LocalAddress “”, remoteAddress = LocalAddress “/opt/cardano/cnode/sockets/node0.socket”} event: State: Dead
[db-sync-node.Mux:Notice:805] [2021-04-23 10:36:49.22 UTC] Bearer on ConnectionId {localAddress = LocalAddress “”, remoteAddress = LocalAddress “/opt/cardano/cnode/sockets/node0.socket”} event: Miniprotocol MiniProtocolNum 5 InitiatorDir terminated with exception ConversionFailed {errSQLType = “numeric”, errSQLTableOid = Just (Oid 2416872704), errSQLField = “p\225\US\144\239\DEL”, errHaskellType = “Ratio Integer”, errMessage = “Failed reading: takeWhile1”}
[db-sync-node.Subscription:Error:804] [2021-04-23 10:36:49.22 UTC] Identity Application Exception: LocalAddress “/opt/cardano/cnode/sockets/node0.socket” ConversionFailed {errSQLType = “numeric”, errSQLTableOid = Just (Oid 2416872704), errSQLField = “p\225\US\144\239\DEL”, errHaskellType = “Ratio Integer”, errMessage = “Failed reading: takeWhile1”}
[db-sync-node.ErrorPolicy:Error:4] [2021-04-23 10:36:49.22 UTC] IP LocalAddress “/opt/cardano/cnode/sockets/node0.socket” ErrorPolicyUnhandledApplicationException (ConversionFailed {errSQLType = “numeric”, errSQLTableOid = Just (Oid 2416872704), errSQLField = “p\225\US\144\239\DEL”, errHaskellType = “Ratio Integer”, errMessage = “Failed reading: takeWhile1”})

Thanks

2

Ok, since I didn’t have any news about this, here is what I’m doing:

I’m trying to sync db-sync-mainnet but from time to time, appears an error like this, or Error Calculate fee, or db get corrupted, don’t know if its just with me.

But:

I’m executing backup every 50 epoch, and here is how I do:

BACKUP

1 - STOP DB-SYNC
2 - COPY BKP LEDGER-STATE DIR
tar -cvf ledger-bkps/ledger-state-bkp.tar ledger-state/
3 - Copy BKP DB
pg_dump -Fc -h -U cexplorer -f ledger-bkps/cexplorer.dump

And if something get bad, I just restore:

RESTORE
1 - STOP DB-SYNC
2 - DROP DATABASE
dropdb cexplorer
3 - CREATE DATABASE
PGPASSFILE=config/pgpass-mainnet scripts/postgresql-setup.sh --createdb
4 - Remove ledger-state dir
rm -r ledger-state
5 - Choose ledger-state bkp and untar
tar -xvf ledger-state-bkp.tar -C …/
6 - Restore DB file(same datetime as ledger-state)
pg_restore -d cexplorer -h -U cexplorer.dump