Describe the bug I’m working on a chat app. That means, that my app receives events asynchronously. For example such an event could be a new message.

It happens pretty often, that multiple messages are received at the same time, which means that the app tries to add multiple messages at the same time to the database. On Android that works perfectly fine. But on iOS web and electron it doesn’t work as expected at all.

On iOS and web only one of the multiple messages are saved. The other datasets are discarded without any error.

On electron the following exception is thrown:

To Reproduce The following code does not work as expected (on web and electron):

 async addDataToTestDB() {
    // Since I'm not using await here, these operations are called simultaneously.
    this.insertData('id1', 'Bob');
    this.insertData('id2', 'Lina');
    this.insertData('id3', 'Maria');
  }

  async insertData(id: string, name: string) {
    const dbConnection = await this.sqlite.openDB('test-db');
    const result = await dbConnection.run('REPLACE INTO test(id, name) VALUES(?,?)', [id, name]);

    // The following line is only necessary on web platform
    await this.sqlite.saveToStore('test-db');
  }

But if I actively take care that there are no simultaneous db queries, the bug does not appear.

 async addDataToTestDB() {
    await this.insertData('id1', 'Bob');
    await this.insertData('id2', 'Lina');
    await this.insertData('id3', 'Maria');
  }

Expected behavior Simultaneous database write actions should work.

Desktop (please complete the following information):

• OS: macOS 12.3.1
• Browser: Safari
• Version: 15.4

Demo code

1. clone repo: git@github.com:tobiasmuecksch/capacitor-sqlite-angular.git
2. test web: npm run start
3. test electron: npm run electron:start

Click buttons in this order (while looking at the js console):

1. “Create Tables”
2. “Insert some data”
3. “print select all to console”
4. “drop database”