Your message dated Tue, 10 Jan 2023 22:21:25 +0000
with message-id <e1pfmzl-002yit...@fasolo.debian.org>
and subject line Bug#1027837: fixed in offlineimap3
0.0~git20211018.e64c254+dfsg-2
has caused the Debian Bug report #1027837,
regarding offlineimap3: "AssertionError: Your sqlite is not multithreading
safe" with python3.11
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
1027837: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1027837
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Package: offlineimap3
Version: 0.0~git20211018.e64c254+dfsg-1
Severity: grave
Tags: fixed-upstream patch
Justification: renders package unusable
Forwarded: https://github.com/OfflineIMAP/offlineimap3/issues/136
Control: block 1026825 by -1
After upgrading to python3 (>= 3.11) I get lots of these errors:
> ERROR: ERROR in syncfolder for REDACTED folder .REDACTED: Traceback (most
> recent call last):
> File "/usr/share/offlineimap3/offlineimap/accounts.py", line 610, in
> syncfolder
> statusfolder.openfiles()
> File "/usr/share/offlineimap3/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
and as far as I can tell, no mail is synchronized.
https://github.com/OfflineIMAP/offlineimap3/pull/139 appears to be the
upstream solution for this, and seems to be a suitable patch for the
version currently in Debian. Please see attached or the upstream PR.
smcv
-- System Information:
Debian Release: bookworm/sid
APT prefers unstable-debug
APT policy: (500, 'unstable-debug'), (500, 'stable-security'), (500,
'oldstable-debug'), (500, 'oldoldstable'), (500, 'buildd-unstable'), (500,
'unstable'), (500, 'testing'), (500, 'stable'), (500, 'oldstable'), (1,
'experimental-debug'), (1, 'buildd-experimental'), (1, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 6.0.0-6-amd64 (SMP w/4 CPU threads; PREEMPT)
Locale: LANG=en_GB.utf8, LC_CTYPE=en_GB.utf8 (charmap=UTF-8), LANGUAGE=en_GB:en
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages offlineimap3 depends on:
ii ca-certificates 20211016
ii python3 3.11.1-1
ii python3-distro 1.8.0-1
ii python3-imaplib2 2.57-5.2
offlineimap3 recommends no packages.
Versions of packages offlineimap3 suggests:
pn python3-gssapi <none>
-- no debconf information
-- debsums errors found:
debsums: changed file
/usr/share/offlineimap3/offlineimap/folder/LocalStatusSQLite.py (from
offlineimap3 package)
>From 7cd32cf834b34a3d4675b29bebcd32dc1e5ef128 Mon Sep 17 00:00:00 2001
From: 0pointerexception <w...@wmeyer.eu>
Date: Thu, 17 Nov 2022 19:43:58 +0100
Subject: [PATCH] LocalStatusSQLite.py: Python 3.11 compatible threadsafety
check
Signed-off-by: 0pointerexception <w...@wmeyer.eu>
---
offlineimap/folder/LocalStatusSQLite.py | 10 ++++++++--
1 file changed, 8 insertions(+), 2 deletions(-)
diff --git a/offlineimap/folder/LocalStatusSQLite.py b/offlineimap/folder/LocalStatusSQLite.py
index a576b9ca..3c44643f 100644
--- a/offlineimap/folder/LocalStatusSQLite.py
+++ b/offlineimap/folder/LocalStatusSQLite.py
@@ -17,7 +17,7 @@
import os
import sqlite3 as sqlite
-from sys import exc_info
+from sys import exc_info,version_info
from threading import Lock
from .Base import BaseFolder
@@ -75,6 +75,11 @@ def __init__(self, name, repository):
self.filename = os.path.join(self.getroot(), self.getfolderbasename())
self._newfolder = False # Flag if the folder is new.
+ """
+ sqlite threading mode must be 3 as of Python 3.11, checking against
+ 1 for versions below Python 3.11 to sustain backwards compatibility.
+ """
+ self._threading_mode_const = 3 if version_info.minor >=11 else 1
dirname = os.path.dirname(self.filename)
if not os.path.exists(dirname):
@@ -102,9 +107,10 @@ def __exit__(self, exc_type, exc_val, exc_tb):
if self._in_transactions < 1:
self.connection.commit()
+
def openfiles(self):
# Make sure sqlite is in multithreading SERIALIZE mode.
- assert sqlite.threadsafety == 1, 'Your sqlite is not multithreading safe.'
+ assert sqlite.threadsafety == self._threading_mode_const, 'Your sqlite is not multithreading safe.'
with self._databaseFileLock.getLock():
# Try to establish connection, no need for threadsafety in __init__.
--- End Message ---
--- Begin Message ---
Source: offlineimap3
Source-Version: 0.0~git20211018.e64c254+dfsg-2
Done: Bastian Germann <b...@debian.org>
We believe that the bug you reported is fixed in the latest version of
offlineimap3, which is due to be installed in the Debian FTP archive.
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to 1027...@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Bastian Germann <b...@debian.org> (supplier of updated offlineimap3 package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmas...@ftp-master.debian.org)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Format: 1.8
Date: Tue, 10 Jan 2023 22:44:57 +0100
Source: offlineimap3
Architecture: source
Version: 0.0~git20211018.e64c254+dfsg-2
Distribution: unstable
Urgency: medium
Maintainer: Debian Python Team <team+pyt...@tracker.debian.org>
Changed-By: Bastian Germann <b...@debian.org>
Closes: 1027837
Changes:
offlineimap3 (0.0~git20211018.e64c254+dfsg-2) unstable; urgency=medium
.
* Team upload
* Patch: Python 3.11 compatible threadsafety check (Closes: #1027837)
Checksums-Sha1:
4b3b53156306846884f595af71b7fba040f53c34 2285
offlineimap3_0.0~git20211018.e64c254+dfsg-2.dsc
7a79178da6ed89c1005b38725ce9b929ac0fe19e 7368
offlineimap3_0.0~git20211018.e64c254+dfsg-2.debian.tar.xz
83307ad0d14dc8b5f3e31bcff3b189d881591951 6833
offlineimap3_0.0~git20211018.e64c254+dfsg-2_source.buildinfo
Checksums-Sha256:
8087f85ba0ba640d70d7b8a348e7baec9ab1d2739eb815762043c99b5064ec85 2285
offlineimap3_0.0~git20211018.e64c254+dfsg-2.dsc
74ae31dff16d90505e62c77d144d8855aacc62b8a8b08848f8e3032f59265219 7368
offlineimap3_0.0~git20211018.e64c254+dfsg-2.debian.tar.xz
c0e73a9bc13cca76722ac7c3e15affea5420bf1b406a0c95e297a9057a3e5f98 6833
offlineimap3_0.0~git20211018.e64c254+dfsg-2_source.buildinfo
Files:
6d5d332e6331cf12b9318cf956592fee 2285 mail optional
offlineimap3_0.0~git20211018.e64c254+dfsg-2.dsc
2ee4e2dcdd55778b5d426e86c71e06d1 7368 mail optional
offlineimap3_0.0~git20211018.e64c254+dfsg-2.debian.tar.xz
d88d1f2c4c8cd92435be68c2a6399653 6833 mail optional
offlineimap3_0.0~git20211018.e64c254+dfsg-2_source.buildinfo
-----BEGIN PGP SIGNATURE-----
iQHEBAEBCgAuFiEEQGIgyLhVKAI3jM5BH1x6i0VWQxQFAmO94HQQHGJhZ2VAZGVi
aWFuLm9yZwAKCRAfXHqLRVZDFBckDADGHUbt75WeZVkNGT/rNzav5KMGYBfKCDqt
JPytAS/jKr1vhNcHp76Wv5spWnxuIBljYdYw6awviRtE2p2q1HiSkI9DCHGapkyD
UCQKmYJ40kEhawY93ljHhapgs2pcD6FDfGHhYYN8SACtjh6pmdeAnwUWZSswxnFl
DuC1ztus+qPbtT7PkCDnDKXqCuKIXNWwu8M2TdHMb9CshjPjNoRg0zXVSoafkeK5
PwBOBWnbLIdrMHJ3uLteep4R2oIjxvl0sGa78kVhIvYVnqulXV3DwAgC5Tjcw+R9
Nf5H3V8WclRs78Ixw8GavIzwAPF+36ji6983PIwj+KJpsI62xb/7llWajn4EN31u
/de8f+Fh17IK+ZePSiMBU1GDGZRVR3ykD2jXj5rGurN890WoQuJDrtJYVtBs8vxZ
Gt7k7xSsRyvhQ0mlbg8KebpCtfI9QxkZ7r0emlGAuPWNmk4i3PDDFrrqGaGfhX0O
eMNHYJEfepS2Koh3soNzWBzpjf2IMzE=
=xnE/
-----END PGP SIGNATURE-----
--- End Message ---
