ErickWendel / parallelizing-nodejs-ops

Example of how to Migrate 1M items from MongoDB to Postgres in just a few minutes using Node.js child process
https://youtu.be/EnK8-x8L9TY
144 stars 72 forks source link

error: sorry, too many clients already #1

Open alexandremsouza1 opened 4 months ago

alexandremsouza1 commented 4 months ago

progress [░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░] 0% | 0/1000000 | 14sC:\Trabalho\NODE PROJECT\parallelizing-nodejs-ops\node_modules\pg-protocol\dist\parser.js:283 const message = name === 'notice' ? new messages_1.NoticeMessage(length, messageValue) : new messages_1.DatabaseError(messageValue, length, name); ^

error: sorry, too many clients already at Parser.parseErrorMessage (C:\Trabalho\NODE PROJECT\parallelizing-nodejs-ops\node_modules\pg-protocol\dist\parser.js:283:98) at Parser.handlePacket (C:\Trabalho\NODE PROJECT\parallelizing-nodejs-ops\node_modules\pg-protocol\dist\parser.js:122:29) at Parser.parse (C:\Trabalho\NODE PROJECT\parallelizing-nodejs-ops\node_modules\pg-protocol\dist\parser.js:35:38) at Socket. (C:\Trabalho\NODE PROJECT\parallelizing-nodejs-ops\node_modules\pg-protocol\dist\index.js:11:42) at Socket.emit (node:events:517:28) at addChunk (node:internal/streams/readable:368:12) at readableAddChunk (node:internal/streams/readable:341:9) at Readable.push (node:internal/streams/readable:278:10) at TCP.onStreamRead (node:internal/stream_base_commons:190:23) { length: 85, severity: 'FATAL', code: '53300', detail: undefined, hint: undefined, position: undefined, internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'proc.c', line: '351', routine: 'InitProcess' }

WillianAgostini commented 4 months ago

Hi @alexandremsouza1

try decreasing the CLUSTER_SIZE variable and restart docker images