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
