Connection error

[jaakluo]

I'm getting a connection error when testing a connection/trying to connect to a persistent database. The database is created with DuckDB CLI version 1.2.0.

[Error: Serialization Error: Failed to deserialize: expected end of object, but found field id: 100] {
    errno: -1,
    code: 'DUCKDB_NODEJS_ERROR',
    errorType: 'Serialization'
}

Installing a newer version of duckdb-async (1.1.3) fixes this issue.

[alza-bitz]

Installing a newer version of duckdb-async (1.1.3) fixes this issue.

Hi, can you detail the steps you took to install this newer version, and specifically where it was installed?

I am getting the same error, but when I try your suggested fix, on making a connection attempt duckdb tells me You need to upgrade "duckdb-async@0.10.2" to connect to DuckDB and I cannot get past that error unless I uninstall the newer suggested version and re-install the older version 0.10.2. But on doing that, of course I again hit the same serialization error.

Details

I installed the version of duckdb-async you suggested in the ~/.local/share/vscode-sqltools/ path in my dev container using npm install duckdb-async@1.1.3

This path is where it tries to install version 0.10.2 automatically, so I assume this is the correct location for a dev container setup?

Environment

VSCode dev container with the following versions installed:

/workspaces/myproject $ duckdb --version
v1.3.2 (Ossivalis) 0b83e5d2f6

sql tools 0.28.4
sql tools duck db driver 1.0.0 (from "evidence")

/workspaces/myproject $ node --version
v22.18.0

Steps

1. Create and populate db

   /workspaces/myproject $ duckdb my_database.db
   

   CREATE TABLE users (id INTEGER, name VARCHAR);
   INSERT INTO users VALUES (1, 'Alice'), (2, 'Bob');
   SELECT * FROM users;
   .exit
   

2. Create sql tools connection for db file /workspaces/myproject/my_database.db
3. Save connection and try to connect from sql tools

Expected

Connects without error

Actual

[1756204994192] INFO  (ls): Connection instance created for DuckDB.
    ns: "conn-manager"
[1756204994205] ERROR (ls): Connecting error: {"code":-32001,"data":{"driver":"DuckDB","driverOptions":{}},"name":"Error"}
    ns: "conn-manager"
[1756204994205] ERROR (ls): Open connection error
    ns: "conn-manager"
[1756204994206] ERROR (ext): ERROR: Error opening connection Serialization Error: Failed to deserialize: expected end of object, but found field id: 100, {"code":-32001,"data":{"driver":"DuckDB","driverOptions":{}}}
    ns: "error-handler"

[jaakluo]

Update the AbstractDriver dependency version in src/ls/driver.ts (line 22) to 1.3.2. VScode prompts & forces to install the version defined there. I just created a vsix file from my local version and installed the sqtools-duckdb-driver extension from the vsix file (which should prompt to install duckdb-async 1.3.2).