dslijian2015
2019-07-19 19:31
浏览 461
已采纳

带有journal_mode = WAL的go-sqlite3给出“数据库已锁定”错误

In go, I open a sqlite3 database using the mattn/go-sqlite3 module. I set the database journalling mode to WAL immediately after opening using a PRAGMA journal_mode=WAL.

However, if I try to open the database from a second process while the first is running, the second cannot open it and instead gets the "database is locked" error. This happens even if I did not perform any transactions.

The connection string I am using is:

"file:mydbfile.db?cache=shared&mode=rwc"

(I intend to answer my own question, since it took a long time to debug)

  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dpxkkhu1812 2019-07-19 19:35
    已采纳

    If you want to enable journal_mode=WAL, you should add it to the connection string:

    "file:mydbfile.db?cache=shared&mode=rwc&_journal_mode=WAL"
    

    As part of opening the database, go-sqlite3 will execute PRAGMA statements to set various defaults. One of these defaults is setting the journal_mode=DELETE. However, if another process has the database opened, the mode cannot be changed back to DELETE. Executing this statement fails with "database is locked" and so you will see the open operation fail with that error.

    The complete list of connection string parameters is listed at https://github.com/mattn/go-sqlite3

    已采纳该答案
    打赏 评论

相关推荐 更多相似问题