Unable to connect to Vertica 25.3

[protobi-pieter]

I seem to be unable to connect to Vertica 25.3 using this driver whereas the legacy driver works fine.

Problem

vertica-nodejs driver hangs for 15+ seconds during connection initialization and is ultimately unable to connect, while the legacy vertica driver (wvanbergen/node-vertica) connects in ~113ms to the same database with identical credentials.

I see that Vertica 24.0+ has default timeout limits, I tried setting ALTER DATABASE protobi_db SET IdleTimeoutInitializingConnectionsMs = 0; and ALTER DATABASE protobi_db SET IdleTimeoutInitializingConnectionsMs = 30000 to no avail.

Side-by-Side Comparison

✓ Legacy driver (wvanbergen/node-vertica) - WORKS:

const Vertica = require('vertica');

Vertica.connect({
    host: 'db-test.mydomain.com',
    port: 5433,
    user: 'test_user',
    password: '**********',
    database: 'my_db'
}, function(err, connection) {
    // ✓ CONNECTED in 113ms
    connection.query('SELECT version() AS version', function(err, result) {
        console.log(result.rows[0][0]);
        // Vertica Analytic Database v25.3.0-0
    });
});

✗ Official driver (vertica-nodejs) - HANGS:
const { Client } = require('vertica-nodejs');

const client = new Client({
    host: 'db-test.mydomain.com',
    port: 5433,
    user: 'test_user',
    password: '**********',
    database: 'my_db'
});

await client.connect();
// ✗ Hangs for 15+ seconds, never completes

Environment

- vertica-nodejs: v1.0.3
- Node.js: v20.19.5
- Vertica Server: v25.3.0-0
- IdleTimeoutInitializingConnectionsMs: 0 (disabled - no server-side timeout)

Impact

Connection initialization fails, what might I be missing?

Notes

- Server timeout has been disabled (IdleTimeoutInitializingConnectionsMs = 0) or set high (30000)
- Driver appears to hang indefinitely, not hitting any timeout
- Tested with explicit tls_mode: 'disable' - same behavior

[h-serizawa]

It works for me.

[test.js]

const { Client } = require('vertica-nodejs');

const client = new Client({
    host: '192.168.1.116',
    port: 5433,
    user: 'dbadmin',
    password: '',
    database: 'trial3'
});

client.connect();

client.query("SELECT version()", (err, res) => {
    console.log(err || res.rows[0]);
    client.end();
});

$ node test.js
{ version: 'Vertica Analytic Database v25.3.0-0' }

Can you see the following log messages in vertica.log file when trying to connect to the database from vertica-nodejs?

[Session] <INFO> Accepted new connection. Total connection count is 1
<LOG> @v_trial3_node0001: 00000: Initializing session for host=192.168.1.115 port=42396 (total sockets in use by all connections 1)
[Session] <INFO> Set client compatibility from the protocol_compat option: 'VER'.
[Session] <INFO> Set idle timeout for remote host 192.168.1.115 to 00:00:10
<LOG> @v_trial3_node0001: 00000: Authentication - sendAuthRequest: user=dbadmin database=trial3 host=192.168.1.115 authType=0
<LOG> @v_trial3_node0001: 00000: Connection authenticated: user=dbadmin database=trial3 host=192.168.1.115
<LOG> @v_trial3_node0001: 00000: Client pid: 63062
<LOG> @v_trial3_node0001: 00000: Current idle session timeout = UNLIMITED
<LOG> @v_trial3_node0001: 00000: Current session grace period: UNLIMITED

I confirmed this using the following environment:

• Vertica version: 25.3.0-0
• vertica-nodejs: 1.1.4 (Node.js: 16.20.2, Red Hat Enterprise Linux 9.6)