node.js sqlite3 - error when adding rows dynamically

Question

This error occurs when I add 20 strings to my table through a for-loop:

ERROR: SQLITE_ERROR: cannot start a transaction within a transaction at Error (native)

Here is the relevant code:

var sqlite3 = require('sqlite3').verbose();
var Players_db = new sqlite3.Database('./db/Players');

Players_db.serialize(function() 
{
    Players_db.run("BEGIN TRANSACTION");
    Players_db.run("CREATE TABLE IF NOT EXISTS Players(string TEXT)");
    Players_db.run("COMMIT");
    console.log('Players_db init')
});

// This part is a simplification, but it shouldn't make a difference.
for (var i = 0; i < 20; i ++) 
{
    Players_db.run("BEGIN TRANSACTION");
    Players_db.run("INSERT INTO Players VALUES('"+a_string+"')");
    Players_db.run("COMMIT");
}

It also appears that the for-loop finishes successfully (and data is being appended to the db), but shortly afterwards it crashes with the said error.

KlwntSingh · Accepted Answer · 2015-07-13 10:07:32Z

1

Try this

        Players_db.serialize(function() 
        {
            Players_db.run("BEGIN TRANSACTION");
            for (var i = 0; i < 20; i ++) 
            {
               Players_db.run("INSERT INTO Players VALUES('"+a_string+"')");
            }
            Players_db.run("COMMIT");
        })

answered Jul 13, 2015 at 10:07

KlwntSingh

1,0928 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Eivind Over a year ago

It works, but due to the nature of the application, I cannot add the rows from the same serialize event.

Eivind Over a year ago

I figured out I could use a serialize function for every new row. Thank you1

Collectives™ on Stack Overflow

node.js sqlite3 - error when adding rows dynamically

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related