Sqlite sqlite3_config 报错 21

最新推荐文章于 2025-06-19 09:10:58 发布

承接各种编程私活

最新推荐文章于 2025-06-19 09:10:58 发布

阅读量5.2k

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库文章标签： sqlite 多线程

本文链接：https://blog.youkuaiyun.com/Silver_sail/article/details/39047733

数据库专栏收录该内容

17 篇文章

订阅专栏

在使用Sqlite3_config()设置多线程模式时遇到21号错误码，解决方法是先调用sqlite3_shutdown()，再依次调用sqlite3_config()和sqlite3_initialize()。同时，确保所有查询都使用同一连接，以实现对数据库连接的序列化。此问题在iOS 5上表现为误用错误。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

要使用Sqlite进行开发，需要用sqlite3_config()函数设置多线程模式，结果发现调用此函数一直ERROR，错误码是21.查看了相关的错误码文档，不明所以。。。之后果断google，找到了问题的所在和解决方案：

I struggled long and hard with this as well and finally got the solution.

sqlite3_config() needs to be called before sqlite3_initialize(). However, the OS might initialize sqlite for us so I also do a sqlite3_shutdown() before the sqlite3_config() i.e. 1) sqlite3_shutdown() 2) sqlite3_config() 3) sqlite3_initialize().

Then its also necessary to use the same connection for every query as it is the access to the database connection that gets serialized. As described herehttp://www.sqlite.org/capi3ref.html#sqliteconfigserialized

So I create a connection as soon as the app starts up and the pass that connection to every class that needs it.

地址：http://stackoverflow.com/questions/7795973/setting-sqlite-config-sqlite-config-serialized-returns-sqlite-misuse-on-ios-5