offlineimap3 icon indicating copy to clipboard operation
offlineimap3 copied to clipboard

assert sqlite.threadsafety == 1, 'Your sqlite is not multithreading safe.'

Open generateui opened this issue 3 years ago • 3 comments

General informations

  • system/distribution (with version):
  • offlineimap version (offlineimap -V): offlineimap v8.0.0, imaplib2 v3.06, Python v3.11.2, OpenSSL 1.1.1t 7 Feb 2023

I did a brew install on a MacOS with M2 chip. I copied the config from another (working) instance, and I got:

😎 /Users/ruud❱offlineimap -f Folder -a accountname
OfflineIMAP 8.0.0
  Licensed under the GNU GPL v2 or any later version (with an OpenSSL exception)
imaplib2 v3.06, Python v3.11.2, OpenSSL 1.1.1t  7 Feb 2023
Account sync accountname:
 *** Processing account accountname
 Establishing connection to imap.gmail.com:993 (gmail)
Folder Reviews [acc: accountname]:
 ERROR: ERROR in syncfolder for accountname folder Reviews: Traceback (most recent call last):
  File "/opt/homebrew/Cellar/offlineimap/8.0.0_1/libexec/lib/python3.11/site-packages/offlineimap/accounts.py", line 610, in syncfolder
    statusfolder.openfiles()
  File "/opt/homebrew/Cellar/offlineimap/8.0.0_1/libexec/lib/python3.11/site-packages/offlineimap/folder/LocalStatusSQLite.py", line 108, in openfiles
    assert sqlite.threadsafety == 1, 'Your sqlite is not multithreading safe.'
           ^^^^^^^^^^^^^^^^^^^^^^^^
AssertionError: Your sqlite is not multithreading safe.

  Your sqlite is not multithreading safe.
Account sync accountname:
 *** Finished account 'accountname' in 0:00
ERROR: Exceptions occurred during the run!
ERROR: ERROR in syncfolder for accountname folder Reviews: Traceback (most recent call last):
  File "/opt/homebrew/Cellar/offlineimap/8.0.0_1/libexec/lib/python3.11/site-packages/offlineimap/accounts.py", line 610, in syncfolder
    statusfolder.openfiles()
  File "/opt/homebrew/Cellar/offlineimap/8.0.0_1/libexec/lib/python3.11/site-packages/offlineimap/folder/LocalStatusSQLite.py", line 108, in openfiles
    assert sqlite.threadsafety == 1, 'Your sqlite is not multithreading safe.'
           ^^^^^^^^^^^^^^^^^^^^^^^^
AssertionError: Your sqlite is not multithreading safe.

I deleted the assertion and now it works fine. Iirc I did this in the past too, but didn't bother to file an issue.

generateui avatar Mar 14 '23 10:03 generateui

Same for me. There was a recent MR about this though: https://github.com/OfflineIMAP/offlineimap3/pull/139

I also deleted the assertion and it works fine for me.

Dima-369 avatar Mar 17 '23 23:03 Dima-369

Fixed in https://github.com/OfflineIMAP/offlineimap3/pull/139

The fix is unreleased, see: https://github.com/OfflineIMAP/offlineimap3/issues/151

WhyNotHugo avatar Jul 10 '23 12:07 WhyNotHugo