importsqlite3importthreadingKB=sqlite3.connect("example.db",check_same_thread=False)defexecute_query():cursor=KB.cursor()cursor.execute("SELECT * FROM test_table")result=cursor.fetchall()assertresult== [(1,'test1'), (2,'test2'), (3,'test3')],str(result)returnresultdefrun_threads():threads= []foriinrange(50):thread=threading.Thread(target=execute_query)threads.append(thread)thread.start()forthreadinthreads:thread.join()deftest_multithreading():cursor=KB.cursor()cursor.execute("""CREATE TABLE IF NOT EXISTS test_table (id INTEGER PRIMARY KEY, value TEXT)"""    )KB.commit()cursor.execute("""DELETE FROM test_table""")KB.commit()cursor.execute("""INSERT INTO test_table (value) VALUES ('test1')""")cursor.execute("""INSERT INTO test_table (value) VALUES ('test2')""")cursor.execute("""INSERT INTO test_table (value) VALUES ('test3')""")KB.commit()run_threads()KB.close()if__name__=="__main__":test_multithreading()

Exception in thread Thread-3 (execute_query):Traceback (most recent call last):  File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner    self.run()  File "/usr/lib/python3.12/threading.py", line 1010, in runException in thread Thread-7 (execute_query):Traceback (most recent call last):  File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner    self._target(*self._args, **self._kwargs)  File "/home/user/tmp/kb_test.py", line 13, in execute_query    self.run()  File "/usr/lib/python3.12/threading.py", line 1010, in runException in thread Thread-12 (execute_query):Traceback (most recent call last):  File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner    assert result == [(1, 'test1'), (2, 'test2'), (3, 'test3')], str(result)    self._target(*self._args, **self._kwargs)AssertionError: [(1, 'test2'), (3, 'test3')]  File "/home/user/tmp/kb_test.py", line 13, in execute_queryException in thread Thread-1 (execute_query):Traceback (most recent call last):  File "/usr/lib/python3.12/threading.py", line 1073, in _bootstrap_inner    self.run()    assert result == [(1, 'test1'), (2, 'test2'), (3, 'test3')], str(result)    self.run()AssertionError: [(3, 'test3')]  File "/usr/lib/python3.12/threading.py", line 1010, in run  File "/usr/lib/python3.12/threading.py", line 1010, in run    self._target(*self._args, **self._kwargs)  File "/home/user/tmp/kb_test.py", line 13, in execute_query    self._target(*self._args, **self._kwargs)  File "/home/user/tmp/kb_test.py", line 13, in execute_query    assert result == [(1, 'test1'), (2, 'test2'), (3, 'test3')], str(result)    assert result == [(1, 'test1'), (2, 'test2'), (3, 'test3')], str(result)AssertionError: [(None, None), (), (2, 'test2'), (), (), (2, 'test2'), (0, None), (1, 'test1'), (2, 'test2'), (3, 'test3')]AssertionError: [(3, 'test3')]