Issues after postgres goes down

[snowkidind]

This is a known issue where if the database goes down / oom / crashes for some alternative reason, the program is unable to regain consciousness and needs to be manually restarted.

---

2023-08-18 06:56:14 Job: Extract Transactions completed in 965.00703 ms
error: terminating connection due to administrator command
at Parser.parseErrorMessage (/buriram/keny/txRipper/node_modules/pg-protocol/dist/parser.js:287:98)
at Parser.handlePacket (/buriram/keny/txRipper/node_modules/pg-protocol/dist/parser.js:126:29)
at Parser.parse (/buriram/keny/txRipper/node_modules/pg-protocol/dist/parser.js:39:38)
at Socket. (/buriram/keny/txRipper/node_modules/pg-protocol/dist/index.js:11:42)
at Socket.emit (events.js:400:28)
at addChunk (internal/streams/readable.js:293:12)
at readableAddChunk (internal/streams/readable.js:267:9)
at Socket.Readable.push (internal/streams/readable.js:206:10)
at TCP.onStreamRead (internal/stream_base_commons.js:188:23)2023-08-18 06:56:14 Database Error:pauseStatus

2023-08-18 06:56:14 NOTICE: Converting batch to addressCache
error: the database system is shutting down
at Parser.parseErrorMessage (/buriram/keny/txRipper/node_modules/pg-protocol/dist/parser.js:287:98)
at Parser.handlePacket (/buriram/keny/txRipper/node_modules/pg-protocol/dist/parser.js:126:29)
at Parser.parse (/buriram/keny/txRipper/node_modules/pg-protocol/dist/parser.js:39:38)
at Socket. (/buriram/keny/txRipper/node_modules/pg-protocol/dist/index.js:11:42)
at Socket.emit (events.js:400:28)
at addChunk (internal/streams/readable.js:293:12)
at readableAddChunk (internal/streams/readable.js:267:9)
at Socket.Readable.push (internal/streams/readable.js:206:10)
at TCP.onStreamRead (internal/stream_base_commons.js:188:23)2023-08-18 06:56:14 Database Error

2023-08-18 06:56:14 deploying children for job: 1368d311-83f2-46ca-8e7d-6450780dac90
2023-08-18 06:56:15 Job: Convert Batch completed in 583.142345 ms
Error: connect ECONNREFUSED 127.0.0.1:5432
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1159:16)2023-08-18 06:56:15 Database Error:pauseStatus

Error: connect ECONNREFUSED 127.0.0.1:5432
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1159:16)2023-08-18 06:56:15 Database Error:getInt

2023-08-18 06:56:15 NOTICE: initializing transactionId_seq to 0
Error: connect ECONNREFUSED 127.0.0.1:5432
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1159:16)2023-08-18 06:56:15 Database Error:setInt

2023-08-18 06:56:15 NOTICE: Importing Batch to database
2023-08-18 06:56:15 writing to file: /buriram/keny/txRipper/derived/tmp/1368d311-83f2-46ca-8e7d-6450780dac90.sql
Command failed: psql -d ripper -f /buriram/keny/txRipper/derived/tmp/1368d311-83f2-46ca-8e7d-6450780dac90.sql
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
2023-08-18 06:56:15 1

psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
2023-08-18 06:56:15 1

2023-08-18 06:56:15

2023-08-18 06:56:15 Notice: Couldn't insert file into database. exiting.
2023-08-18 06:56:15 The problem was at file: 1368d311-83f2-46ca-8e7d-6450780dac90
Error: connect ECONNREFUSED 127.0.0.1:5432
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1159:16)2023-08-18 06:56:15 Database Error:setBool

2023-08-18 06:56:15 Job: synchronize completed in 1.652133186 s
An Error occurred during this cycle. Will retry from last sync point.2023-08-18 06:56:15 1

2023-08-18 06:56:25 New Block:17937949 behind by: 7 blocks
2023-08-18 06:56:38 New Block:17937950 behind by: 8 blocks /// etc.