René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"The timeout setting is not honored when a transaction is active (with example)","articleBody":"# Bug report\n\n### Bug description:\n\nThe timeout argument to sqlite3.connect is not honored and a \"sqlite3.OperationalError: database is locked\" is triggered immediately if this script is invoked a second time while the first is still running (sleeping). This only happens when a\ntransaction is active - if the BEGIN statement is removed the bug is not triggered.\n\nExpected behavior: the script should wait for up to 10 seconds for the first invocation to finish before giving up\nActual behavior: the script immediately crashes with \"sqlite3.OperationalError: database is locked\"\n\nPython version: 3.11.2 (Debian: python3.11-minimal 3.11.2-6+deb12u3, libpython3.11-stdlib:amd64 3.11.2-6+deb12u3)\nSQLite version: 3.40.1 (Debian: sqlite3 3.40.1-2)\nOS: Debian GNU/Linux 12.7\nKernel: Linux 6.1.0-22-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.94-1 (2024-06-21) x86_64 GNU/Linux\n\n```\n#\n# a table must be manually created first:\n#   sqlite3 testcase.db 'CREATE TABLE IF NOT EXISTS customers (a)'\n# (if this is done by the script the bug is not triggered for some reason)\n#\n\nimport sqlite3\nimport time\n\nconn = sqlite3.connect(\n    'testcase.db',\n    isolation_level = None, # test case will work even if this is left out\n    timeout = 10\n)\n\nc = conn.cursor()\n\nprint('starting transaction')\nc.execute('''BEGIN''')\nprint('transaction started')\n\nprint('doing SELECT')\nc.execute('SELECT * FROM customers', ())\nprint('did SELECT')\n\nprint('doing UPDATE')\nc.execute('UPDATE customers SET a = 0 WHERE a = 999999', ())\nprint('did UPDATE')\n\nprint('sleeping')\ntime.sleep(30)\nprint('slept')\n\nprint('transaction ended')\n\n```\n\n\n### CPython versions tested on:\n\n3.11\n\n### Operating systems tested on:\n\nLinux","author":{"url":"https://github.com/jogc","@type":"Person","name":"jogc"},"datePublished":"2024-09-25T10:42:41.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/124510/cpython/issues/124510"}