Hello everyone,
I’ve been working on upgrading our entire infrastructure. We recently upgraded all of our nodes to version 8.1.2. We also run a Cardano DB Sync instance with one of our nodes with its latest version
cardano-node 8.1.2 - linux-x86_64 - ghc-8.10
git rev d2d90b48c5577b4412d5c9c9968b55f8ab4b9767
Cardano-db-sync 13.1.1.3 - linux-x86_64 - ghc-8.10
git revision 6e69a80797f2d68423b25ca7787e81533b367e42
Now, for the past five days, the DBSync cannot stay up to date. I restored the whole thing from a snapshot.
https://update-cardano-mainnet.iohk.io/cardano-db-sync/13.1/db-sync-snapshot-schema-13.1-block-9492777-x86_64.tgz
I upgraded my PostgreSQL instance to version 15; in addition, I optimized the instance following the Guild Operators instructions
https://cardano-community.github.io/guild-operators/Appendix/postgres/#tuning-your-instance
And for some reason, the system is not capable of staying up to date.
cexplorer=# select now () - max (time) as behind_by from block ;
behind_by
------------------------
5 days 15:27:47.289634
(1 row)
cexplorer=# select now () - max (time) as behind_by from block ;
behind_by
------------------------
5 days 15:27:51.986572
(1 row)
We have plenty of memory available, as you can see.
Although the DBSync seems like it is not consuming as much memory as it should.
Looking at the logs for dbsync and cnode, I don’t see any error. All I see is “Handling input offset …”
dbsync logs
{"app":[],"at":"2023-11-02T13:37:19.29Z","data":{"kind":"LogMessage","message":"Handling input offset 4900000"},"env":"<unknown>:67e42","host":"","loc":null,"msg":"","ns":["db-sync-node"],"pid":"1962038","sev":"Info","thread":"6"}
Node is 100% Synced and fully working. I did notice many incoming connections (47 at this time)
gLiveView
We would really appreciate if anyone can shine some light on this problem. It seems many of us are going through the same issue.
Thank you,