René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlite: Session methods crash after DatabaseSync is closed and reopened","articleBody":"### Version\n\nmain\n\n### Platform\n\n```text\nmacOS 26.5.2\n```\n\n### Subsystem\n\nsqlite\n\n### What steps will reproduce the bug?\n\n```js\nimport { DatabaseSync } from 'node:sqlite';\n\nconst method = process.argv[2] ?? 'changeset';\nconst db = new DatabaseSync(':memory:');\n\ndb.exec('CREATE TABLE data (id INTEGER PRIMARY KEY)');\nconst session = db.createSession();\n\ndb.close();\ndb.open();\n\nconsole.log(`calling session.${method}()`);\nsession[method]();\nconsole.log('returned');\n```\n\n### How often does it reproduce? Is there a required condition?\n\nAlways\n\n### What is the expected behavior? Why is that the expected behavior?\n\nClosing the database should invalidate associated session wrappers; after reopening, either method should throw an error such as `Error: session is not open`.\n\n### What do you see instead?\n\n```sh\n$ ../node/node repro.js changeset\ncalling session.changeset()\n[1]    65858 segmentation fault  ../node/node repro.js changeset\n```\n\n```sh\n$ ../node/node repro.js close\ncalling session.close()\n[1]    66266 segmentation fault  ../node/node repro.js close\n```\n\nBoth methods terminate the process because the session wrapper retains a stale native handle after `db.close()`.\n\n\n### Additional information\n\n_No response_","author":{"url":"https://github.com/trivikr","@type":"Person","name":"trivikr"},"datePublished":"2026-07-27T14:40:28Z","url":"https://github.com/nodejs/node/issues/64782"}