chdb-io / chdb-node Goto Github PK

Hi there,
We have a ClickHouse Cloud service in production and we're trying to use chdb-node in our tests suite to simulate that service.
When running our tests suite we run into an issue where an exception is raised from the ClickHouse engine and we're having a hard time identifying what's wrong.

For each series of tests, we instantiate a new Session, perform some operations and then clean up the session.
After a few operations, we get the following error:

terminate called after throwing an instance of 'DB::Exception'
  what():  Storage is about to be deleted. Done active task as if it was aborted.
Aborted (core dumped)

We also get the following one (but less often):

terminate called after throwing an instance of 'DB::Exception'
  what():  Cancelled merging parts
Aborted (core dumped)

Configuration:

• NodeJS v20.11.0
• chdb-node v1.1.3

I'm curious if you guys ran into this issue in other context.
I also wrote a simple script that generates many sessions in series and for each session performs a few insert and select operations, and I didn't encounter the problem. So it could be something with our CI suite but so far I'm clueless.

I'm pretty positive I'm not deleting the session while it's been used but maybe I made a mistake.

Any pointers or ideas would be much appreciated. Also happy to re-post this somewhere else if it's more suitable there.
Thank you.

This is quite a simple issue, none of the examples in the README file work:

Example n°1:

const { query } = require("chdb");
const ret = query("SELECT version(), 'Hello chDB', chdb()", "CSV");

Will produce the following error: Uncaught Error: Error in native callback.

Example n°2:

const { Session } = require("chdb");
const session = new Session("./chdb-node-tmp");
const ret = session.query("SELECT 123", "CSV")

Will make ret have the value '' (empty string).

Here's my environment:

OS: Mac OSX Ventura 13.2.1
Architecture: M1 Apple Silicone
Package Version: 1.1.2
Node.js Version: v18.4.0