"Unhandled Promise Rejection: InvalidStateError: The object is in an invalid state" ?

[chanon]

Hello, I am using wa-sqlite instead of the official SQLite wasm because I like the wa-sqlite interface better.

But I'm running into an issue in Safari that looks like it is the same thing as:
sqlite/sqlite-wasm#79 (comment)

But I'm getting it as an unhandled exception.

I'm not completely sure if it is the same thing. This is how I am initializing (in a Worker):

import SQLiteESMFactory from 'wa-sqlite/dist/wa-sqlite.mjs';
import { AccessHandlePoolVFS as VFS } from 'wa-sqlite/src/examples/AccessHandlePoolVFS.js';
import * as SQLite from 'wa-sqlite';

// Initialize SQLite and handle messages
async function initializeSQLite() {
	try {
		const module = await SQLiteESMFactory();
		sqlite3 = SQLite.Factory(module);

		// register vfs system.
		const vfs = new VFS('dbs')
		// @ts-ignore
		sqlite3.vfs_register(vfs, true);
	}
	catch (error: any) {
		console.error(error)
		ctx.postMessage('failed')
	}
}

I get the error as an unhandled rejection:

let retries = 0

addEventListener('unhandledrejection', async (ev) => {
	console.error('worker unhandledrejection!:')
	console.log(ev)
	retries++;
	if (retries > 5)
		return
	await initializeSQLite()
})

Doing the above doesn't fix it, but just creates more
Unhandled Promise Rejection: InvalidStateError: The object is in an invalid state
rejections.

[rhashimoto]

My guess would be that you have multiple contexts accessing the same OPFS files, e.g. you have multiple tabs open on your page or one page is opening multiple Workers. AccessHandlePoolVFS works only on one context at a time.

Apart from that you haven't provided enough information for me to debug it (such as the wa-sqlite version, a stack trace, whether it works on other browsers, etc.) without investing a lot of effort. I suggest creating a test web page with a minimal reproducible example that shows the bad behavior, e.g. using GitHub Pages.

Alternatively, you can look at how the demo handles initialization in demo-worker.js, or the much simpler hello demo (you'll need to change its VFS), and see where what you're doing diverges.

[chanon]

Thank you for the response.
I am specifically managing multiple tabs by using a Worker and leader tab election.
The problem happens in Safari sometimes when reloading a single tab,
If I keep having the problem I will try creating a minimal reproduction as you say.