{"id":2017,"date":"2024-12-16T14:10:13","date_gmt":"2024-12-16T06:10:13","guid":{"rendered":"http:\/\/www.algmain.com\/?p=2017"},"modified":"2024-12-16T14:11:44","modified_gmt":"2024-12-16T06:11:44","slug":"python-sqlite-objects-created-in-a-thread-can-only-be-used-in-that-same-thread","status":"publish","type":"post","link":"http:\/\/www.algmain.com\/index.php\/2024\/12\/16\/python-sqlite-objects-created-in-a-thread-can-only-be-used-in-that-same-thread\/","title":{"rendered":"\u89e3\u51b3Python SQLite3\u62a5\u9519\uff1aSQLite objects created in a thread can only be used in that same thread"},"content":{"rendered":"\n<p>\u4f7f\u7528\u5728 Python3.6 \u73af\u5883\u4e0b\uff0c\u5f53\u591a\u7ebf\u7a0b\u73af\u5883\u4e2d\uff0c\u67d0\u4e2a\u7ebf\u7a0b\u4f7f\u7528sqlite3\u6a21\u5757\u8fde\u63a5sqlite3 \u6570\u636e\u5e93\uff0c\u7a0d\u540e\u7684\u67e5\u8be2\u8fc7\u7a0b\u4e2d\uff0c\u51fa\u73b0\u9519\u8bef\u63d0\u9192\uff1aSQLite objects created in a thread can only be used in that same thread \u2026<br>\u67e5\u9605\u6587\u6863\u53d1\u73b0sqlite3.connect()\u65b9\u6cd5\u4e2d\u6709\u4e2acheck_same_thread\u7f3a\u7701\u503c\u4e3aTrue\uff0c\u5c06\u5176\u8bbe\u7f6e\u4e3aFalse\uff0c\u5373\u53ef\u89e3\u51b3\u8be5\u62a5\u9519\u3002<\/p>\n\n\n\n<p>\u4f8b\u5982\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import sqlite3<\/code><\/pre>\n\n\n\n<h1 class=\"wp-block-heading\">\u5728\u591a\u7ebf\u7a0b\u4e2d\u4f1a\u62a5\u9519\u7684\u8fde\u63a5:<\/h1>\n\n\n\n<pre class=\"wp-block-code\"><code># \u9ed8\u8ba4check_same_thread=True\nconn = sqlite3.connect(db_path, timeout=10)<\/code><\/pre>\n\n\n\n<h1 class=\"wp-block-heading\">\u5728\u591a\u7ebf\u7a0b\u4e2d\u4e0d\u4f1a\u62a5\u9519\u7684\u8fde\u63a5:<\/h1>\n\n\n\n<pre class=\"wp-block-code\"><code># \u663e\u5f0f\u8bbe\u7f6echeck_same_thread=False\nconn = sqlite3.connect(db_path, timeout=10, check_same_thread=False) <\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4f7f\u7528\u5728 Python3.6 \u73af\u5883\u4e0b\uff0c\u5f53\u591a\u7ebf\u7a0b\u73af\u5883\u4e2d\uff0c\u67d0\u4e2a\u7ebf\u7a0b\u4f7f\u7528sqlite3\u6a21\u5757\u8fde\u63a5sqlite3 \u6570\u636e\u5e93\uff0c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2017","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.algmain.com\/index.php\/wp-json\/wp\/v2\/posts\/2017"}],"collection":[{"href":"http:\/\/www.algmain.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.algmain.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.algmain.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.algmain.com\/index.php\/wp-json\/wp\/v2\/comments?post=2017"}],"version-history":[{"count":2,"href":"http:\/\/www.algmain.com\/index.php\/wp-json\/wp\/v2\/posts\/2017\/revisions"}],"predecessor-version":[{"id":2019,"href":"http:\/\/www.algmain.com\/index.php\/wp-json\/wp\/v2\/posts\/2017\/revisions\/2019"}],"wp:attachment":[{"href":"http:\/\/www.algmain.com\/index.php\/wp-json\/wp\/v2\/media?parent=2017"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.algmain.com\/index.php\/wp-json\/wp\/v2\/categories?post=2017"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.algmain.com\/index.php\/wp-json\/wp\/v2\/tags?post=2017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}