Sign In

I keep getting this error message

Replies
8
Author
Time

I have occasionally been getting this error message when I refresh a page or post something:

😦

Error: remaining connection slots are reserved for non-replication superuser connections
at EventEmitter.<anonymous> (/srv/www/originaltrilogy.com/comitium/node_modules/citizen/lib/helpers.js:246:13)
at emitOne (events.js:96:13)
at EventEmitter.emit (events.js:188:7)
at /srv/www/originaltrilogy.com/comitium/app/patterns/models/private-topics.js:119:17
at groupTracker (/srv/www/originaltrilogy.com/comitium/node_modules/citizen/lib/helpers.js:298:9)
at EventEmitter.<anonymous> (/srv/www/originaltrilogy.com/comitium/node_modules/citizen/lib/helpers.js:244:7)
at emitOne (events.js:96:13)
at EventEmitter.emit (events.js:188:7)
at /srv/www/originaltrilogy.com/comitium/app/patterns/models/private-topics.js:84:21
at .<anonymous> (/srv/www/originaltrilogy.com/comitium/node_modules/pg-pool/index.js:57:11)

Author
Time

was the forum just down for everyone else as well?

I kept getting this error message

😦

error: remaining connection slots are reserved for non-replication superuser connections
at Connection.parseE (/srv/www/originaltrilogy.com/comitium/node_modules/pg/lib/connection.js:551:11)
at Connection.parseMessage (/srv/www/originaltrilogy.com/comitium/node_modules/pg/lib/connection.js:378:17)
at Socket.<anonymous> (/srv/www/originaltrilogy.com/comitium/node_modules/pg/lib/connection.js:117:22)
at emitOne (events.js:96:13)
at Socket.emit (events.js:188:7)
at Socket.wrapped (/srv/www/originaltrilogy.com/comitium/node_modules/newrelic/lib/transaction/tracer/index.js:161:28)
at Socket.wrappedEmit [as emit] (/srv/www/originaltrilogy.com/comitium/node_modules/newrelic/lib/transaction/tracer/index.js:193:46)
at readableAddChunk (_stream_readable.js:177:18)
at Socket.Readable.push (_stream_readable.js:135:10)
at TCP.onread (net.js:542:20)

This post has been edited.

Author
Time

We occasionally get hammered by crawlers that consume all available database connections. I’ve implemented improved connection pooling in the next update, which should hopefully fix this problem.

The things you pwn end up pwning you.

Author
Time

And maybe it’s a good idea to configure the server to NOT show the stack, it’s not very secure

Author
Time

pittrek said:

And maybe it’s a good idea to configure the server to NOT show the stack, it’s not very secure

Traditionally, this is true, but if your entire stack is open source like ours, there are no real secrets. The entire codebase is publicly available on GitHub. If you want to learn our technology stack in the hopes of identifying an attack vector, a quick perusal of package.json in the root of the project provides a nice outline based on the npm packages installed with the app — right down to the version number.

The only thing in the error that’s not public is the path to the app on the web server, but anybody who gains access to the file system has defeated several layers of security and already has the keys to the kingdom.

From a UX perspective, the errors are ugly. That just comes down to time and priorities.

The things you pwn end up pwning you.

Author
Time

I’ve been getting this error quite often today.

error: remaining connection slots are reserved for non-replication superuser connections
at Connection.parseE (/srv/www/originaltrilogy.com/comitium/node_modules/pg/lib/connection.js:554:11)
at Connection.parseMessage (/srv/www/originaltrilogy.com/comitium/node_modules/pg/lib/connection.js:381:17)
at Socket.<anonymous> (/srv/www/originaltrilogy.com/comitium/node_modules/pg/lib/connection.js:117:22)
at emitOne (events.js:96:13)
at Socket.emit (events.js:188:7)
at Socket.wrapped (/srv/www/originaltrilogy.com/comitium/node_modules/newrelic/lib/transaction/tracer/index.js:161:28)
at Socket.wrappedEmit [as emit] (/srv/www/originaltrilogy.com/comitium/node_modules/newrelic/lib/transaction/tracer/index.js:193:46)
at readableAddChunk (_stream_readable.js:176:18)
at Socket.Readable.push (_stream_readable.js:134:10)
at TCP.onread (net.js:548:20)

“Collective fear stimulates herd instinct, and tends to produce ferocity toward those who are not regarded as members of the herd.”
― Bertrand Russell, Unpopular Essays

“When the debate is lost, slander becomes the tool of the loser.”

― Socrates

To the top