search

ucd-library / fin

FIN (Fedora IN docker) Base Services
MIT License
0 stars 0 forks source link

Dbsync crashes initially after starting the cluster from a new state #58

Open UcDust opened 1 year ago

UcDust commented 1 year ago

Dbsync crashes initially after starting the cluster from a new state. The logs show-

2023-08-01 13:40:12 {"name":"fin-server-generic-localhost:3000","hostname":"4937543c0de2","pid":19,"level":50,"msg":"DbSync readLoop error error: relation \"dbsync.event_queue\" does not exist\n    at Parser.parseErrorMessage (/fin/services/node_modules/pg-protocol/dist/parser.js:287:98)\n    at Parser.handlePacket (/fin/services/node_modules/pg-protocol/dist/parser.js:126:29)\n    at Parser.parse (/fin/services/node_modules/pg-protocol/dist/parser.js:39:38)\n    at Socket.<anonymous> (/fin/services/node_modules/pg-protocol/dist/index.js:11:42)\n    at Socket.emit (node:events:513:28)\n    at addChunk (node:internal/streams/readable:315:12)\n    at readableAddChunk (node:internal/streams/readable:289:9)\n    at Socket.Readable.push (node:internal/streams/readable:228:10)\n    at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {\n  length: 117,\n  severity: 'ERROR',\n  code: '42P01',\n  detail: undefined,\n  hint: undefined,\n  position: '15',\n  internalPosition: undefined,\n  internalQuery: undefined,\n  where: undefined,\n  schema: undefined,\n  table: undefined,\n  column: undefined,\n  dataType: undefined,\n  constraint: undefined,\n  file: 'parse_relation.c',\n  line: '1360',\n  routine: 'parserOpenTable'\n}","time":"2023-08-01T20:40:12.185Z","v":0}
2023-08-01 13:40:12 {"name":"fin-server-generic-localhost:3000","hostname":"4937543c0de2","pid":19,"level":50,"msg":"DbSync processCheckQueueLoop error error: relation \"dbsync.event_queue\" does not exist\n    at Parser.parseErrorMessage (/fin/services/node_modules/pg-protocol/dist/parser.js:287:98)\n    at Parser.handlePacket (/fin/services/node_modules/pg-protocol/dist/parser.js:126:29)\n    at Parser.parse (/fin/services/node_modules/pg-protocol/dist/parser.js:39:38)\n    at Socket.<anonymous> (/fin/services/node_modules/pg-protocol/dist/index.js:11:42)\n    at Socket.emit (node:events:513:28)\n    at addChunk (node:internal/streams/readable:315:12)\n    at readableAddChunk (node:internal/streams/readable:289:9)\n    at Socket.Readable.push (node:internal/streams/readable:228:10)\n    at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {\n  length: 117,\n  severity: 'ERROR',\n  code: '42P01',\n  detail: undefined,\n  hint: undefined,\n  position: '15',\n  internalPosition: undefined,\n  internalQuery: undefined,\n  where: undefined,\n  schema: undefined,\n  table: undefined,\n  column: undefined,\n  dataType: undefined,\n  constraint: undefined,\n  file: 'parse_relation.c',\n  line: '1360',\n  routine: 'parserOpenTable'\n}","time":"2023-08-01T20:40:12.205Z","v":0}
2023-08-01 13:40:12 {"name":"fin-server-generic-localhost:3000","hostname":"4937543c0de2","pid":19,"level":50,"msg":"DbSync nextDataModelValidation error error: relation \"dbsync.validate_queue\" does not exist\n    at Parser.parseErrorMessage (/fin/services/node_modules/pg-protocol/dist/parser.js:287:98)\n    at Parser.handlePacket (/fin/services/node_modules/pg-protocol/dist/parser.js:126:29)\n    at Parser.parse (/fin/services/node_modules/pg-protocol/dist/parser.js:39:38)\n    at Socket.<anonymous> (/fin/services/node_modules/pg-protocol/dist/index.js:11:42)\n    at Socket.emit (node:events:513:28)\n    at addChunk (node:internal/streams/readable:315:12)\n    at readableAddChunk (node:internal/streams/readable:289:9)\n    at Socket.Readable.push (node:internal/streams/readable:228:10)\n    at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {\n  length: 120,\n  severity: 'ERROR',\n  code: '42P01',\n  detail: undefined,\n  hint: undefined,\n  position: '29',\n  internalPosition: undefined,\n  internalQuery: undefined,\n  where: undefined,\n  schema: undefined,\n  table: undefined,\n  column: undefined,\n  dataType: undefined,\n  constraint: undefined,\n  file: 'parse_relation.c',\n  line: '1360',\n  routine: 'parserOpenTable'\n}","time":"2023-08-01T20:40:12.236Z","v":0}
2023-08-01 13:40:12 /fin/services/node_modules/pg-protocol/dist/parser.js:287
2023-08-01 13:40:12         const message = name === 'notice' ? new messages_1.NoticeMessage(length, messageValue) : new messages_1.DatabaseError(messageValue, length, name);
2023-08-01 13:40:12                                                                                                  ^
2023-08-01 13:40:12 
2023-08-01 13:40:12 error: relation "update_status" does not exist
2023-08-01 13:40:12     at Parser.parseErrorMessage (/fin/services/node_modules/pg-protocol/dist/parser.js:287:98)
2023-08-01 13:40:12     at Parser.handlePacket (/fin/services/node_modules/pg-protocol/dist/parser.js:126:29)
2023-08-01 13:40:12     at Parser.parse (/fin/services/node_modules/pg-protocol/dist/parser.js:39:38)
2023-08-01 13:40:12     at Socket.<anonymous> (/fin/services/node_modules/pg-protocol/dist/index.js:11:42)
2023-08-01 13:40:12     at Socket.emit (node:events:513:28)
2023-08-01 13:40:12     at addChunk (node:internal/streams/readable:315:12)
2023-08-01 13:40:12     at readableAddChunk (node:internal/streams/readable:289:9)
2023-08-01 13:40:12     at Socket.Readable.push (node:internal/streams/readable:228:10)
2023-08-01 13:40:12     at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
2023-08-01 13:40:12   length: 112,
2023-08-01 13:40:12   severity: 'ERROR',
2023-08-01 13:40:12   code: '42P01',
2023-08-01 13:40:12   detail: undefined,
2023-08-01 13:40:12   hint: undefined,
2023-08-01 13:40:12   position: '29',
2023-08-01 13:40:12   internalPosition: undefined,
2023-08-01 13:40:12   internalQuery: undefined,
2023-08-01 13:40:12   where: undefined,
2023-08-01 13:40:12   schema: undefined,
2023-08-01 13:40:12   table: undefined,
2023-08-01 13:40:12   column: undefined,
2023-08-01 13:40:12   dataType: undefined,
2023-08-01 13:40:12   constraint: undefined,
2023-08-01 13:40:12   file: 'parse_relation.c',
2023-08-01 13:40:12   line: '1381',
2023-08-01 13:40:12   routine: 'parserOpenTable'
2023-08-01 13:40:12 }