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

带有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

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 关于IMageEnView 图标定位问题
  • ¥20 求解答(matlab)
  • ¥30 ffmpeg库使用过程中遇到的问题
  • ¥15 pyqt5 中python如何通过Qtwebchannel主动发消息给web前端
  • ¥15 关于HTML中title获取xml内容的问题
  • ¥15 fanuc机器人PRIO083数字信号未复原错误,如何解决?
  • ¥20 如何为现有电路板增加远程控制功能
  • ¥15 UE5打包失败,求解决
  • ¥15 请问STM32G431的CANOPEN协议函数怎么写
  • ¥15 graphpad prism 三因素重复测定报错