Navigation

    全志在线开发者论坛

    • Register
    • Login
    • Search
    • Categories
    • Tags
    • 在线文档
    • 社区主页

    V851 Sqlite无法打开数据库,显示SQL ERROR : database is locked

    V Series
    3
    5
    1905
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • E
      EricWoneX LV 3 last edited by

      V851 使用Tina系统,交叉编译Sqlite之后,将Sqlite push至板子时,一直无法打开数据库,错误信息显示:SQL ERROR : database is locked

      目标系统:Tina Linux (5.0, r0-7277fac)
      host系统:Ubuntu 22.04
      gcc版本:6.4.1

      sqlite库与cli编译如下:

      $ arm-openwrt-linux-muslgnueabi-gcc -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_RBU -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_STAT4 -DSQLITE_THREADSAFE=0 -Wno-all -g shell.c sqlite3.c -ldl -lm -o sqlite3
      

      已试过关闭thread safe

      -DSQLITE_THREADSAFE=1 -pthread
      

      还是不行。

      还望各位大神不吝指教!

      M 2 Replies Last reply Reply Quote Share 0
      • M
        mabaofu LV 4 @EricWoneX last edited by

        This post is deleted!
        1 Reply Last reply Reply Quote Share 0
        • M
          mabaofu LV 4 @EricWoneX last edited by

          @ericwonex 解决了没啊

          E 1 Reply Last reply Reply Quote Share 0
          • E
            EricWoneX LV 3 @mabaofu last edited by

            @mabaofu 现在还没解决,最后直接写文件里,有解决办法了吗
            ?

            M 1 Reply Last reply Reply Quote Share 0
            • M
              minjialong LV 4 @EricWoneX last edited by

              @ericwonex 我也遇到了这个问题,不知道怎么解决,你那边解决了吗,不吝赐教

              1 Reply Last reply Reply Quote Share 0
              • 1 / 1
              • First post
                Last post

              Copyright © 2024 深圳全志在线有限公司 粤ICP备2021084185号 粤公网安备44030502007680号

              行为准则 | 用户协议 | 隐私权政策