We're evolving to serve you better! This current forum has transitioned to read-only mode. For new discussions, support, and engagement, we've moved to GitHub Discussions.

SQLite error due to Dropbox synchronization with Publii 0.44.4

January 25, 2024 at 7:42 am #11632

[anonymous]

I have a lot of SQLite errors in the Publii backend:

A JavaScript error occurred in the main process
Uncaught Exception:
SQlite3Error: database is locked
at Database._handleError
….

Sometime, it works fine, sometimes not, espacially for posts and website generation.

The problem comes from the Dropbow synchronisation. The SQLite file is locked by the Dropbox client to sync it with the cloud, while Publii needs to write data!

It was’nt the case with the previous releases of Publii. I don’t know why it happens now…

To fix the problem, simply suspend Dropbox synchronization when working on the Publii backend 😉

January 25, 2024 at 10:15 am #11634

[anonymous]

Hallo zusammen,
ich habe das Vertrauen in Publii langsam verloren. Ich arbeite mit der vorletzten Version, nachdem ich das Programm völlig neu aufgesetzt habe. Jetzt habe ich den nicht mehr den bisherigen SqLight3-Fehler, sondern mehrfach bricht der Upload nach etwa 4-5 Stunden ab mit der angefügten JacaScript-Fehlermeldung.
So ist das nicht mehr nur ärgerlich, sondern macht auch nun wirklich keinen Spaß mehr.

Glückauf aus Dorsten
Norbert

January 27, 2024 at 10:54 am #11657

[anonymous]

i have this problem too. i am using the latest version of publii and my server is fine but publii won’t compile and gives this error when i have to close it.

January 27, 2024 at 6:54 pm #11659

[anonymous]

Hi,

Finally we have decided to use better-sqlite3 (previous library) on mac OS / Windows and node-sqlite3-wasm on linux.

It is the only solution to solve issues with glibc on Linux and avoid issues with locked files on Windows.

The problem seems to be an issue with locking method used by node-sqlite3-wasm library.

I will prepare prebuild version with this fix in the next week so I can share it with you

January 28, 2024 at 4:51 pm #11663

[anonymous]

Great thanks, Sooner the better please

January 30, 2024 at 8:49 am #11677

[anonymous]

Thanks for your feedback, Tomasz! I see your point, not so easy to understand this issue… But if you have a solution, it’s perfect!

Have a good day!