Nested each invocation raises an Segmentation fault (core dumped)

[vit1251]

Issue Summary

Using nested iteration on large tables raise an Seffalt:

db.each(query1, (err, row) => {
    db.each(query2, (err, row) => {
       // code here...
    });
})

Any solution?

Steps to Reproduce

1. Write nested queryes with each request
2. Execute code

Version

5.0.7

Node.js Version

16.15.0

How did you install the library?

npm i

[daniellockyer]

I can reproduce this with the following:

const sqlite3 = require('./').verbose();
const db = new sqlite3.Database(':memory:');

db.serialize(() => {
    db.run("CREATE TABLE lorem (info TEXT)");

    const stmt = db.prepare("INSERT INTO lorem VALUES (?)");
    for (let i = 0; i < 1; i++) {
        stmt.run("Ipsum " + i);
    }
    stmt.finalize();

    db.each("SELECT rowid AS id, info FROM lorem", (err, row) => {
        db.each("SELECT rowid AS id, info FROM lorem", (err, row) => {
            console.log('inner', err, row);
        });

        console.log(err, row);
    });
});

db.close();

On v5.0.6, I get the following output:

null { id: 1, info: 'Ipsum 0' }
inner Error: SQLITE_MISUSE: Database handle is closed
--> in Database#each('SELECT rowid AS id, info FROM lorem', [Function (anonymous)])
    at Statement.<anonymous> (/Users/neo/code/devops/node-sqlite3/a.js:14:12) {
  errno: 21,
  code: 'SQLITE_MISUSE',
  __augmented: true
} undefined

On v5.0.7, I get a segfault.

[daniellockyer]

This should be fixed in v5.0.8 🙂