NoModificationAllowedError: Failed to execute 'createSyncAccessHandle' on 'FileSystemFileHandle'

[raineorshine]

Platform: Chrome
Thoughtspace: 1m
Fully replicated

I get this error about 50% of the time on refresh.

The status says "Disconnected • Pending initial sync".

NoModificationAllowedError: Failed to execute 'createSyncAccessHandle' on 'FileSystemFileHandle': Access Handles cannot be created if there is another open Access Handle or Writable stream associated with the same file.
Failed to fetch tables: Error: sqlite3_open_v2

[raineorshine]

@obezzad Confirmed that this is still an issue. Can you investigate? Thanks!

[raineorshine]

This is a known issue that apparently happens because the db connection is still active in the Worker. A SharedWorker or ServiceWorker is necessary to get around this, and to enable multi-tab use.

Reducing to low priority.

See: cybersemics/partykit-em#10

[obezzad]

@raineorshine Fabian's observations are excellent and do align with what I've experienced. I'd just like to add that this issue happens on shared workers as well. Notably, when we close the last tab, it effectively kills the worker, sometimes leaving the handle open when a slow query is still ongoing.