Why am I getting SQLiteCloudError: Connection error with ECONNRESET during initial connection?

[jeonghunjae]

Hi,

I’m using the @sqlitecloud/drivers Node.js driver to connect to my SQLiteCloud database. When starting my server, I see this error repeatedly:

My connection string looks like this:

const db = new Database('sqlitecloud://myhost.g4.sqlite.cloud:8860/database.sqlite?apikey=MY_API_KEY&connectTimeout=5000&socketTimeout=60000');

I also tried wrapping my connection logic with a retry mechanism, but still see frequent ECONNRESET errors.

Questions:
1. What does this ECONNRESET specifically mean in the context of SQLiteCloud?
2. Could it be caused by firewall/network restrictions on my cloud server (for example, Cloudtype)?
3. Is there a recommended way to make a more stable connection, such as keep-alives, reconnect strategies, or database pooling?

Any insight would be appreciated — thanks in advance!

--- error message --

2025-07-03 10:50:29 Server is running on port 3000
2025-07-03 10:50:29 processCommandsFinish - error with no registered callback SQLiteCloudError: Connection error
2025-07-03 10:50:29 at TLSSocket. (/app/node_modules/@sqlitecloud/drivers/lib/drivers/connection-tls.js:109:40)
2025-07-03 10:50:29 at TLSSocket.emit (node:events:513:28)
2025-07-03 10:50:29 at emitErrorNT (node:internal/streams/destroy:157:8)
2025-07-03 10:50:29 at emitErrorCloseNT (node:internal/streams/destroy:122:3)
2025-07-03 10:50:29 at processTicksAndRejections (node:internal/process/task_queues:83:21) {
2025-07-03 10:50:29 errorCode: 'ERR_CONNECTION_ERROR',
2025-07-03 10:50:29 cause: Error: read ECONNRESET
2025-07-03 10:50:29 at TLSWrap.onStreamRead (node:internal/stream_base_commons:217:20) {
2025-07-03 10:50:29 errno: -104,
2025-07-03 10:50:29 code: 'ECONNRESET',
2025-07-03 10:50:29 syscall: 'read'
2025-07-03 10:50:29 }

[danielebriggi]

This error is usually generated by the server (the database node) which brutally closes the connection. I want to check on your node if there are any issues. Can you please contact us from your project on the Dashboard? You can find the button on the top right of the page.
Your firewall as well can interfere with the TCP connection.
We recommend to open a new Database connection to the node for every single request to your server and close it to the end.