[Bug]: async query hangs on 15.1.1

[joprice]

What happened?

The latest version of op-sqlite hangs on async queries.

I have two branches https://github.com/joprice/rn-repro/tree/op-sqlite and https://github.com/joprice/rn-repro/tree/op-sqlite-15.0.7 with a simple query run sync and async. The async one hangs indefinitely on the latest (op-sqlite branch)

I went back two versions as the intermediate one introduced the optimized promise handling, which is likely where the bug is.

op-sqlite version

15.1.1

React Native version

0.82.1

Reproducible Example

https://github.com/joprice/rn-repro/tree/op-sqlite

[ospfranco]

Thank you! I will take a look ASAP

[kiranlak]

I have the same problem. The quickest way for me to reproduce is to reload an app (e.g., R in an expo app).

Using async, setting the journal mode hangs after reloading.

const db = open({
    name: dbName,
    location: getDatabaseDir(),
});
await db.execute("PRAGMA journal_mode = 'wal';");

whereas

const db = open({
    name: dbName,
    location: getDatabaseDir(),
});
db.executeSync("PRAGMA journal_mode = 'wal';");

works.

[craftzdog]

I managed to reproduce it on the example project of my library:
https://github.com/craftzdog/pouchdb-adapter-react-native-sqlite
If you upgrade op-sqlite >= 15.1.0, the app hangs indefinitely on await tx.execute(...).
I suspect that this change might affect it: #341

[ospfranco]

I'm busy this days, I will take a look when possible but just revert to previous version for now. Nothing wrong with that version :)

[ospfranco]

Try 15.1.2 should fix the issue

[craftzdog]

Thank you, @ospfranco! It works fine now.