logo Sign In

I keep getting this error message

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

I got it, too, when trying to read a private topic. Reloading the page worked.

Ceci n’est pas une signature.

Author
Time
 (Edited)

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)

Author
Time

was down for a bit earlier today for me.

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.

Forum Administrator

MTFBWY…A

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.

Forum Administrator

MTFBWY…A

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)