Your message dated Tue, 15 Nov 2022 16:09:37 +0000
with message-id <[email protected]>
and subject line Bug#1022943: fixed in sympa 6.2.70~dfsg-1
has caused the Debian Bug report #1022943,
regarding sympa upgrade corrupts its own sqlite3 database
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 [email protected]
immediately.)
--
1022943: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1022943
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: sympa
Version: 6.2.66~dfsg-2+b2
Severity: important
I'm trying to upgrade from 6.2.66~dfsg-2+b1 to 6.2.66~dfsg-2+b2 and
during the upgrade procedure sympa post install script fails with:
...
Upgrading Sympa internals (health check)
Database /var/lib/dbconfig-common/sqlite3/sympa/sympa defined in
sympa.conf has not the right structure or is unreachable. Verify db_xxx
parameters in sympa.conf
Error messages in /var/log/sympa.log look like this:
Oct 28 06:39:50 sympa sympa/health_check[62414]: err main::#227 >
Sympa::DatabaseManager::probe_db#186 >
Sympa::DatabaseManager::_check_fields#388 >
Sympa::DatabaseDriver::SQLite::update_field#228 >
Sympa::DatabaseDriver::SQLite::_update_table#727 >
Sympa::DatabaseDriver::SQLite::do_query#584 >
Sympa::Database::do_query#251 Unable to prepare SQL statement CREATE
TABLE one_time_ticket_table_20221028063947_62414_new (#012#011
ticket_one_time_ticket#011text PRIMARY ...[shortened]: (S1000)
incomplete input
Oct 28 06:39:50 sympa sympa/health_check[62414]: err main::#227 >
Sympa::DatabaseManager::probe_db#186 >
Sympa::DatabaseManager::_check_fields#388 >
Sympa::DatabaseDriver::SQLite::update_field#228 >
Sympa::DatabaseDriver::SQLite::_update_table#728 Could not create
temporary table "one_time_ticket_table_20221028063947_62414_new"
Oct 28 06:39:50 sympa sympa/health_check[62414]: err main::#227 >
Sympa::DatabaseManager::probe_db#186 >
Sympa::DatabaseManager::_check_fields#388 >
Sympa::DatabaseDriver::SQLite::update_field#231 Could not update field
status_one_time_ticket in table one_time_ticket_table (text)
Oct 28 06:39:50 sympa sympa/health_check[62414]: err main::#227 >
Sympa::DatabaseManager::probe_db#186 >
Sympa::DatabaseManager::_check_fields#399 Fields update in database
failed. Aborting
Oct 28 06:39:50 sympa sympa/health_check[62414]: err main::#227 >
Sympa::DatabaseManager::probe_db#196 Unable to check the validity of
fields definition for table one_time_ticket_table. Aborting
How do I fix this?
--
Aleksi Suhonen
() ascii ribbon campaign
/\ support plain text e-mail
--- End Message ---
--- Begin Message ---
Source: sympa
Source-Version: 6.2.70~dfsg-1
Done: Emmanuel Bouthenot <[email protected]>
We believe that the bug you reported is fixed in the latest version of
sympa, 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 [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Emmanuel Bouthenot <[email protected]> (supplier of updated sympa 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 [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Format: 1.8
Date: Sun, 13 Nov 2022 09:16:37 +0000
Source: sympa
Architecture: source
Version: 6.2.70~dfsg-1
Distribution: unstable
Urgency: medium
Maintainer: Debian Sympa team <[email protected]>
Changed-By: Emmanuel Bouthenot <[email protected]>
Closes: 1022943
Changes:
sympa (6.2.70~dfsg-1) unstable; urgency=medium
.
* New upstream release.
- sympa_wizard is now replaced by 'sympa config' command (packaging
updated accordingly).
* Refresh manpages typos patches.
* Remove mhonarc patch (no longer needed).
* Add a patch to fix SQLite schema upgrade (Closes: #1022943)
* Add a patch to fix 'sympa config' command return code
Checksums-Sha1:
b7f414d8b2688da6f80bf4351e5660c9a25c4350 2526 sympa_6.2.70~dfsg-1.dsc
2e56e3dd1a414a4a8046bcd79b08c879909203a9 3854052 sympa_6.2.70~dfsg.orig.tar.xz
ca5f032f3678f978085a9ba1960ab3fa25477db1 167636
sympa_6.2.70~dfsg-1.debian.tar.xz
53eeaacd0bd224bf6d66e4b15cf9ccb9be1022cf 14658
sympa_6.2.70~dfsg-1_source.buildinfo
Checksums-Sha256:
cce6a5b0a44e889329e09b4a9c36aebf5fd0d97a9b28639db8c9e55953bac5e7 2526
sympa_6.2.70~dfsg-1.dsc
92fd93f2c62ff917fe84d55118922244691a63018fd32fd62befa683a121eca0 3854052
sympa_6.2.70~dfsg.orig.tar.xz
e8e9191a7013f0e3dc0f64bf1e0e47a8e3c955b223e777047fbfd3f67333bc20 167636
sympa_6.2.70~dfsg-1.debian.tar.xz
7b23169ed3960dcf2fd295821fc1414f3656d69d2bdee46a0447420e2f60dba7 14658
sympa_6.2.70~dfsg-1_source.buildinfo
Files:
14ff66d7b40c8bba2fc1b5079a9c866f 2526 mail optional sympa_6.2.70~dfsg-1.dsc
3fc73fdfbff7ceea8a521f34ee707133 3854052 mail optional
sympa_6.2.70~dfsg.orig.tar.xz
533abf7996899424ab07be2b3125e3af 167636 mail optional
sympa_6.2.70~dfsg-1.debian.tar.xz
495c6022e76e175a69bbb46515926976 14658 mail optional
sympa_6.2.70~dfsg-1_source.buildinfo
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCgAdFiEETQ1Tfow3vJnf8QuHSwd3I5KdQsMFAmNzs/kACgkQSwd3I5Kd
QsPy+A/+I4GR8Fq76I+Tz+/Dkqhd6RZLmyyHnbPym7NSYUTyNutJBF6dU22HSVrW
pp2/Pw/VKDNJmhVjQol67/MHQmEGYVCnvuAaU6ODKwg3Wj+v8Q0gGxUUfpdGVYkR
WFMkc0a4R9ZOj9idc6rkkeWxWqLCkhk/TyRihMDhBc9L/F2JABSPTMgFHnNaC5/H
fJ4uKhgEVE063uNIpD1PDKi/wNRIJKtatfW+abSRhxx2MdrvGeYcEYQGZ4EBgUSM
yRqYeWhMREu9djRpNLZtdpwiStQdpqJNbZl//LyZnMP+GEelXf3v+FwJYqw7XeEV
w8Zt9SYHxxegHrQNc5X1OC7GR+NqBSsHiaaxhI9HU84PAdWWzKdeyHY8dZz9LRlU
hCOFvF5V/R80Gwh6N+vVKIB9FKSPV6eZ1uvs+s6ehS0UW2DVBoSoG2/2r81fy99L
KzzHEGJtwoMQi1T4D1j4VKhqKwitoXkzpFgRvuvH/JcrmLg2Tt/0ZyeuXWay+2Xb
DSyznQ3pPuXrUB270lnzcQcHwrGhYMkjlhqD5wyJsgqzgSVv8jP/SV+mrGIeFyeb
j6Mw0Z7h3+gOyXjd19Rx3gohk4C/hsqfP16BZrVdbOwX1Ilh1xSiUFeFFXkHwEci
UaTRBxbvSf4EBLZYd3CSZ5+FmJtjUYwsJG9Aisx2iMJWn4l7n3s=
=6Kds
-----END PGP SIGNATURE-----
--- End Message ---
