Getting an error when running offlineimap now on Mac since a recent sqllite update

[T-Fen]

Output of brew config

HOMEBREW_VERSION: 4.3.17
ORIGIN: https://github.com/Homebrew/brew
HEAD: 3426911432b93dc46d20d910c2f4fd33cdac62a2
Last commit: 2 days ago
Core tap JSON: 21 Aug 12:28 UTC
Core cask tap JSON: 21 Aug 12:28 UTC
HOMEBREW_PREFIX: /opt/homebrew
HOMEBREW_CASK_OPTS: []
HOMEBREW_MAKE_JOBS: 10
Homebrew Ruby: 3.3.4 => /opt/homebrew/Library/Homebrew/vendor/portable-ruby/3.3.4_1/bin/ruby
CPU: 10-core 64-bit arm_firestorm_icestorm
Clang: 15.0.0 build 1500
Git: 2.46.0 => /opt/homebrew/bin/git
Curl: 8.7.1 => /usr/bin/curl
macOS: 14.6.1-arm64
CLT: 15.3.0.0.1.1708646388
Xcode: 15.4
Rosetta 2: false

Output of brew doctor

Warning: Some installed formulae are deprecated or disabled.
You should find replacements for the following formulae:
  cowsay
  neofetch
  openssl@1.1

Warning: You have the following deprecated, official taps tapped:
  Homebrew/homebrew-cask-fonts
Untap them with `brew untap`.

Warning: Homebrew's "sbin" was not found in your PATH but you have installed
formulae that put executables in /opt/homebrew/sbin.
Consider setting your PATH for example like so:
  echo 'export PATH="/opt/homebrew/sbin:$PATH"' >> ~/.zshrc

Warning: Some installed formulae are missing dependencies.
You should `brew install` the missing dependencies:
  brew install libgit2@1.7

Run `brew missing` for more details.

Description of issue

Your sqlite is not multithreading safe.
ERROR: ERROR in syncfolder for thesizemores folder INBOX.Trash: Traceback (most recent call last):
File "/opt/homebrew/Cellar/offlineimap/8.0.0_2/libexec/lib/python3.12/site-packages/offlineimap/accounts.py", line 610, in syncfolder
statusfolder.openfiles()
File "/opt/homebrew/Cellar/offlineimap/8.0.0_2/libexec/lib/python3.12/site-packages/offlineimap/folder/LocalStatusSQLite.py", line 107, in openfiles
assert sqlite.threadsafety == 1, 'Your sqlite is not multithreading safe.'
^^^^^^^^^^^^^^^^^^^^^^^^
AssertionError: Your sqlite is not multithreading safe

Relevant casks

sqlite offlineimap

[ZhongRuoyu]

It seems this issue has been fixed upstream (OfflineIMAP/offlineimap3@7cd32cf), but the fix is not included in a release yet. I have opened Homebrew/homebrew-core#181922 to patch the version that Homebrew currently ships.

[T-Fen]

Thank you!

…

On Wed, Aug 21, 2024 at 9:45 AM Ruoyu Zhong ***@***.***> wrote: It seems this issue has been fixed upstream (OfflineIMAP/offlineimap3@ 7cd32cf <OfflineIMAP/offlineimap3@7cd32cf>), but the fix is not included in a release yet. I have opened Homebrew/homebrew-core#181922 <Homebrew/homebrew-core#181922> to patch the version that Homebrew currently ships. — Reply to this email directly, view it on GitHub <#5565 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACHTXHATFTMBUSFLVF6KHX3ZSSKXHAVCNFSM6AAAAABM3545XKVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTANBQG44TMMA> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[ZhongRuoyu]

offlineimap has been updated in Homebrew. Please try brew update && brew upgrade offlineimap and let me know if the issue is fixed.

[T-Fen]

Thank you. It now runs. Also getting some non-fatal errors displayed when running (FYI):

`/opt/homebrew/Cellar/offlineimap/8.0.0_3/libexec/lib/python3.12/site-packages/imaplib2/imaplib2.py:2493: SyntaxWarning: invalid escape sequence '\D'
  ('store', ('1', 'FLAGS', '(\Deleted)')),
/opt/homebrew/Cellar/offlineimap/8.0.0_3/libexec/lib/python3.12/site-packages/imaplib2/imaplib2.py:2598: SyntaxWarning: invalid escape sequence '\D'
  run('uid', ('STORE', uid[-1], 'FLAGS', '(\Deleted)'))
/opt/homebrew/Cellar/offlineimap/8.0.0_3/libexec/lib/python3.12/site-packages/imaplib2/imaplib2.py:2612: SyntaxWarning: invalid escape sequence '\S'
  run('store', (num, '-FLAGS', '(\Seen)'), cb=False),
/opt/homebrew/Cellar/offlineimap/8.0.0_3/libexec/lib/python3.12/site-packages/imaplib2/imaplib2.py:2615: SyntaxWarning: invalid escape sequence '\D'
  run('uid', ('STORE', num, 'FLAGS', '(\Deleted)'))
/opt/homebrew/Cellar/offlineimap/8.0.0_3/libexec/lib/python3.12/site-packages/offlineimap/folder/Base.py:252: SyntaxWarning: invalid escape sequence '\/'
  basename = re.sub('(^|\/)\.$', '\\1dot', basename)
/opt/homebrew/Cellar/offlineimap/8.0.0_3/libexec/lib/python3.12/site-packages/offlineimap/folder/Base.py:869: SyntaxWarning: invalid escape sequence '\s'
  msg_id = re.search(b"\nmessage-id:[\s]+(<[A-Za-z0-9!#$%&'*+-/=?^_`{}|~.@ ]+>)",
/opt/homebrew/Cellar/offlineimap/8.0.0_3/libexec/lib/python3.12/site-packages/offlineimap/folder/Gmail.py:78: SyntaxWarning: invalid escape sequence '\s'
  m = re.search('X-GM-LABELS\s*[(](.*)[)]', data[0])
/opt/homebrew/Cellar/offlineimap/8.0.0_3/libexec/lib/python3.12/site-packages/offlineimap/folder/IMAP.py:512: SyntaxWarning: invalid escape sequence '\s'
  if re.search("(?:^|\\r|\\n)%s:\s*%s(?:\\r|\\n)" %
/opt/homebrew/Cellar/offlineimap/8.0.0_3/libexec/lib/python3.12/site-packages/offlineimap/folder/IMAP.py:519: SyntaxWarning: invalid escape sequence '\s'
  uid = re.search("UID\s+(\d+)", item, flags=re.IGNORECASE)
/opt/homebrew/Cellar/offlineimap/8.0.0_3/libexec/lib/python3.12/site-packages/offlineimap/folder/IMAP.py:529: SyntaxWarning: invalid escape sequence '\d'
  uid = re.search("\d+\s+\(UID\s+(\d+)", found,
/opt/homebrew/Cellar/offlineimap/8.0.0_3/libexec/lib/python3.12/site-packages/offlineimap/folder/Maildir.py:31: SyntaxWarning: invalid escape sequence '\d'
  re_uidmatch = re.compile(',U=(\d+)')
/opt/homebrew/Cellar/offlineimap/8.0.0_3/libexec/lib/python3.12/site-packages/offlineimap/folder/Maildir.py:33: SyntaxWarning: invalid escape sequence '\d'
  re_timestampmatch = re.compile('(\d+)')
/opt/homebrew/Cellar/offlineimap/8.0.0_3/libexec/lib/python3.12/site-packages/offlineimap/folder/Maildir.py:64: SyntaxWarning: invalid escape sequence '\w'
  self.re_flagmatch = re.compile('%s2,(\w*)' % self.infosep)
OfflineIMAP 8.0.0
  Licensed under the GNU GPL v2 or any later version (with an OpenSSL exception)
imaplib2 v3.06, Python v3.12.5, OpenSSL 3.3.1 4 Jun 2024
*** Processing account Fastmail
Establishing connection to mail.messagingengine.com:993 (Fastmail_Remote)`

[ZhongRuoyu]

Thanks; these should be fixed by Homebrew/homebrew-core#181936 too. You can run brew update && brew reinstall offlineimap to get the updated version.

[T-Fen]

Awesome, thanks!

…

On Wed, Aug 21, 2024 at 1:47 PM Ruoyu Zhong ***@***.***> wrote: Thanks; these should be fixed by Homebrew/homebrew-core#181936 <Homebrew/homebrew-core#181936> too. You can run brew update && brew reinstall offlineimap to get the updated version. — Reply to this email directly, view it on GitHub <#5565 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACHTXHADQ2FMYKRX3CGUOSDZSTHERAVCNFSM6AAAAABM3545XKVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTANBRGEYDOMA> . You are receiving this because you authored the thread.Message ID: ***@***.***>