Server ended the connection

[Seyronh]

Maybe this is not the right site for this error but i cant found a solution

Current Behavior

await this.database.sqlSELECT Titulo FROM Libros ORDER BY Titulo ASC LIMIT 25; //This works well
await await this.database.sqlSELECT * FROM Libros WHERE Titulo = ${titleinput}; //This throws an error

Expected Behavior

await this.database.sqlSELECT Titulo FROM Libros ORDER BY Titulo ASC LIMIT 25; //This works well
await await this.database.sqlSELECT * FROM Libros WHERE Titulo = ${titleinput}; //Works well

Steps to Reproduce the Problem

1.Execute select query

Environment

• Version: 1.0.354
• Platform: Linux
• Node.js Version: 18.19.1
• Bun version: 1.1.42

Throwed Error

processCommandsFinish - error 9 | /** Default tls connection port /
10 | exports.DEFAULT_PORT = 8860;
11 | /* Custom error reported by SQLiteCloud drivers /
12 | class SQLiteCloudError extends Error {
13 | constructor(message, args) {
14 | super(message);
^
SQLiteCloudError: Server ended the connection
at new SQLiteCloudError (/home/ubuntu/BookNest/node_modules/@sqlitecloud/drivers/lib/drivers/types.js:14:9)
at /home/ubuntu/BookNest/node_modules/@sqlitecloud/drivers/lib/drivers/connection-tls.js:114:44
at emit (node:events:72:22)
at endReadableNT (node:stream:2211:47)
9 | /* Default tls connection port /
10 | exports.DEFAULT_PORT = 8860;
11 | /* Custom error reported by SQLiteCloud drivers */
12 | class SQLiteCloudError extends Error {
13 | constructor(message, args) {
14 | super(message);
^
SQLiteCloudError: Server ended the connection
at new SQLiteCloudError (/home/ubuntu/BookNest/node_modules/@sqlitecloud/drivers/lib/drivers/types.js:14:9)
at /home/ubuntu/BookNest/node_modules/@sqlitecloud/drivers/lib/drivers/connection-tls.js:114:44
at emit (node:events:72:22)
at endReadableNT (node:stream:2211:47)
Bun v1.1.42 (Linux x64)

[Seyronh]

Okey it happens randomly and i dont know why it starts working and later it stops working

this is my code to connect every time i want to use sql i use SqlManager.getInstance() and then use the corresponding methods

export class SqlManager {
	private static instance: SqlManager;
	private database: Database;
	public static getInstance(): SqlManager {
		if (!SqlManager.instance) {
			SqlManager.instance = new SqlManager();
		}
		return SqlManager.instance;
	}
	public constructor() {
		this.database = new Database({
			connectionstring: process.env.SQLCLOUD_CONNECTION_STRING,
		});
	}
       public async getAllBooks(): Promise<Book[]> {
		const books = await this.database.sql`SELECT * FROM Libros`;

		return books.map((e) => {
			return convertToBook(e);
		});
	}
	...

[danielebriggi]

await this.database.sqlSELECT Titulo FROM Libros ORDER BY Titulo ASC LIMIT 25; //This works well
await await this.database.sqlSELECT * FROM Libros WHERE Titulo = ${titleinput}; //This throws an error

what you report is the expected behavior and as you wrote later it seems to work but not always. Can you please go to the dashboard, click on the question mark icon on the right corner and send us the reference of this ticket and your project Id? in this way can see if there are issue on your node. Thank you

[danielebriggi]

we improved the connection management in the recent version of the driver. They should have fixed your issue.
Remember also to not share the connection between requests. If the connection is closed the instance is recreated.