unhandledRejection: Promise { <rejected> TypeError [ERR_MISSING_ARGS]: The "options" or "port" or "path" argument must be specified

[700software]

unhandledRejection: Promise {
  <rejected> TypeError [ERR_MISSING_ARGS]: The "options" or "port" or "path" argument must be specified
      at new NodeError (node:internal/errors:329:5)
      at Socket.connect (node:net:932:11)
      at Object.connect (node:net:197:17)
      at Object.connect (C:\...\node_modules\postgres\lib\connection.js:390:13) {
    code: 'ERR_MISSING_ARGS'
  }
}

This error occurs intermittently.

I have an unusual config here: { ..., idle_timeout:1, max:5 }

Error is occuring here:

postgres/lib/connection.js

Line 390 in 4a6669c

: net.connect(

When error occurs it is because i == 1 but I only have one host and port so net.connect is called with options undefined, undefined instead of the port number.

I think what is happening is multiple connections are trying to be reopened simultaneously

[700software]

I would move the i >= options.host.length && (i = 0) out of the onclose and put it immediately after net.connect but that would mess up the failover logic

postgres/lib/connection.js

Line 360 in 4a6669c

!ended && !succeeded && i < options.host.length

[700software]

Maybe only reopening one at a time would work.. I think multiple are trying to be reopened (due to multiple sql`...` calls) after all had idle timeout.

[porsager]

Thanks a lot for the good description @700software .. I'm currently in the process of a reimplementation of the connection handling since the current implementation doesn't hold up to the requirement of the features it needs to support, as well as more options for dynamic queries, cancellation of queries, max connection lifetime etc. The goal is to resolve issues like these at the same time.

[porsager]

Also, just to be sure, this is with beta 11 correct?

[700software]

correct, just verified

[porsager]

I'll think about removing the failover logic for now since it's buggy and affecting regular usage..

[700software]

beta8 seems to be fine