Sign in
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

  • This topic has 5 replies, 5 voices, and was last updated 3 weeks, 4 days ago by .
Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #11632
    Avatar photoclebot

    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 ­čśë

    #11634
    Avatar photoNorbert

    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

    x-Snap-2024.01.24-001

    #11657
    Avatar photoscharny

    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.

    #11659
    Avatar photoTomasz Dziuda

    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

    --
    Do you appreciate the support you've received today? If so, consider donating to the Publii team by clicking here; we'll be sure to use your donation to make Publii even better!

    #11663
    Avatar photosibo999

    Great thanks, Sooner the better please

    #11677
    Avatar photoclebot

    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!

Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.