Your message dated Tue, 31 Mar 2015 04:34:42 +0000
with message-id <[email protected]>
and subject line Bug#708339: fixed in dbconfig-common 1.8.50
has caused the Debian Bug report #708339,
regarding upgrade steps executed multiple times if the steps happen
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.)
--
708339: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=708339
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: roundcube
Version: 0.7.2-9
Severity: important
Dear Maintainer,
I've upgraded my squeeze system to wheezy and faced problems during the
roundcube mysql update.
Detailed sequence:
* The first upgrade failed because I had modified the mysql permissions of
root@localhost. This is
not a bug in itself, I just let you know for the context:
Creating database backup in
/var/cache/dbconfig-common/backups/roundcube_0.3.1-6.mysql.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:
NO).
unable to connect to mysql server.
error encountered backing up the old database:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:
NO)
* once I had modified the permissions back, I retried the upgrade (in "don't
ask questions" mode)
but this failed again:
creating database backup in
/var/cache/dbconfig-common/backups/roundcube_0.3.1-6.mysql.
applying upgrade sql for 0.3.1-6 -> 0.5-1.
applying upgrade sql for 0.3.1-6 -> 0.6+dfsg-1.
applying upgrade sql for 0.3.1-6 -> 0.7-1.
applying upgrade sql for 0.3.1-6 -> 0.7.1-1.
dbconfig-common: flushing administrative password
applying upgrade sql for 0.3.1-6 -> 0.5-1.
error encountered processing
/usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.5-1:
mysql said: ERROR 1146 (42S02) at line 5: Table 'roundcube.messages' doesn't
exist
I'm surprised to see that the 0.3.1-6 - > 0.5-1 step took place twice. The
failure is
caused by the "messages" table being dropped in the 0.3.1-6 -> 0.7-1 update.
I then started hacking my way through it, and noticed that the backup in
/var/cache was
actually in a strange mixed state. Turns out that the backup is recreated at
_every_
attempt. So, after the first failed attempt, the backup is replaced with a
half-backed
one, which means that even if I had fixed the duplicate application of the
update
script, I wouldn't have been able to go smoothly through the whole process.
Luckily I had another pristine backup, and used that to get out of it (along
with changing
the upgrade script to succeeded). I didn't look into the reason why the script
was applied
multiple times, but the last attempt looked like:
creating database backup in
/var/cache/dbconfig-common/backups/roundcube_0.3.1-6.mysql.
applying upgrade sql for 0.3.1-6 -> 0.5-1.
applying upgrade sql for 0.3.1-6 -> 0.6+dfsg-1.
applying upgrade sql for 0.3.1-6 -> 0.7-1.
applying upgrade sql for 0.3.1-6 -> 0.7.1-1.
dbconfig-common: flushing administrative password
applying upgrade sql for 0.3.1-6 -> 0.7.1-1.
dbconfig-common: flushing administrative password
applying upgrade sql for 0.3.1-6 -> 0.7.1-1.
dbconfig-common: flushing administrative password
Let me know if there are additional bits of information you'd find useful.
-- System Information:
Debian Release: 7.0
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: i386 (i686)
Kernel: Linux 2.6.32.33-kvm-i386-20111128-dirty (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages roundcube-core depends on:
ii apache2-mpm-prefork [httpd] 2.2.22-13
ii dbconfig-common 1.8.47+nmu1
ii debconf [debconf-2.0] 1.5.49
ii libjs-jquery 1.7.2+dfsg-1
ii libjs-jquery-ui 1.8.ooops.21+dfsg-2
ii libmagic1 5.11-2
ii php-auth 1.6.2-1
ii php-mail-mime 1.8.4-1
ii php-mdb2 2.5.0b3-2
ii php-net-smtp 1.6.1-1
ii php-net-socket 1.0.9-2
ii php5 5.4.4-14
ii php5-gd 5.4.4-14
ii php5-intl 5.4.4-14
ii php5-mcrypt 5.4.4-14
ii php5-pspell 5.4.4-14
ii roundcube-mysql 0.7.2-9
ii tinymce 3.4.8+dfsg0-1
ii ucf 3.0025+nmu3
roundcube-core recommends no packages.
Versions of packages roundcube-core suggests:
ii php-auth-sasl 1.0.4-1
pn php-crypt-gpg <none>
pn roundcube-plugins <none>
roundcube depends on no packages.
-- debconf information:
roundcube/dbconfig-install: true
roundcube/db/dbname: roundcube
roundcube/pgsql/authmethod-admin: ident
roundcube/pgsql/admin-user: postgres
roundcube/internal/skip-preseed: false
roundcube/db/app-user: roundcube
roundcube/dbconfig-reinstall: false
roundcube/restart-webserver: true
roundcube/dbconfig-upgrade: true
roundcube/remote/port:
roundcube/pgsql/no-empty-passwords:
roundcube/passwords-do-not-match:
roundcube/internal/reconfiguring: false
* roundcube/upgrade-error: retry (skip questions)
roundcube/pgsql/authmethod-user: password
roundcube/purge: false
roundcube/language: en_US
roundcube/remote/newhost:
roundcube/pgsql/changeconf: false
roundcube/upgrade-backup: true
roundcube/install-error: abort
roundcube/mysql/admin-user: root
roundcube/hosts:
roundcube/dbconfig-remove:
roundcube/mysql/method: unix socket
roundcube/remove-error: abort
roundcube/pgsql/method: unix socket
roundcube/pgsql/manualconf:
roundcube/db/basepath:
roundcube/reconfigure-webserver: apache2, lighttpd
roundcube/database-type: mysql
roundcube/remote/host:
roundcube/missing-db-package-error: abort
--- End Message ---
--- Begin Message ---
Source: dbconfig-common
Source-Version: 1.8.50
We believe that the bug you reported is fixed in the latest version of
dbconfig-common, 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.
Paul Gevers <[email protected]> (supplier of updated dbconfig-common 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: SHA256
Format: 1.8
Date: Mon, 30 Mar 2015 20:46:21 +0200
Source: dbconfig-common
Binary: dbconfig-common
Architecture: source all
Version: 1.8.50
Distribution: experimental
Urgency: medium
Maintainer: Paul Gevers <[email protected]>
Changed-By: Paul Gevers <[email protected]>
Description:
dbconfig-common - common framework for packaging database applications
Closes: 497035 506511 533777 581646 599896 607171 665742 673840 703365 705222
705335 708339 723885
Changes:
dbconfig-common (1.8.50) experimental; urgency=medium
.
* Prevent running upgrades twice on error (Closes: #708339)
* Revert (undocumented) purge logic change in 1.8.48.
* Fix and unify error handling (Closes: #581646, #497035, #723885)
* Move reset internal/reconfiguring from postinst to dbc_postinst_cleanup
* Replace all debconf priorities with a variable (Closes: #607171)
* Raise priorities when retrying after error
* Check for existance of dbc_logfile before writing (Closes: #705335)
* Remove some unneeded code
* Drop database during reinstall (Closes: #665742)
* Check if database exists before dropping
* Fix for #573524 was incomplete, also forget passwords in debconf during
reconfigure (they can be filled during dbc_preseed_package_debconf)
* Only ask for dbadmin password if needed for updates (Closes: 599896)
* Fix typo in dbc_migrate: password-confirm -> app-password-confirm
* Fix prerm to ask admin_pass if needed during maintainer code
(Closes: #705222)
* Unify the error handling; also (Closes: #723885)
* Make check for DEBIAN_FRONTEND case insensitive (LP: #1406700)
* Don't use dbc_dballow as variable name in dbconfig-generate-include
(Closes: #533777)
* Fix regression in one of the previous uploads which broke preseeding
by packages using dbconfig-common
* Allow the admin to specify the domain for the GRANT calls (MySQL)
(Closes: #673840, #506511)
* Allow backup from password questions (Closes: #703365)
* Insert the name of the dbadmin into the debconf templates to avoid
confusion
* Improvements to the test script
* Update d/copyright to machine-readable format
* Update TODO
* Update Debconf templates, including review from debian-l10n. No
call for review on purpose yet.
Checksums-Sha1:
2a99a38f43dfba17a3cf36ff84c029bbf07263f5 1364 dbconfig-common_1.8.50.dsc
3e140aa4cb857f23c4f3d6bbfc137d2a74f47172 190528 dbconfig-common_1.8.50.tar.xz
db36e148dad4a77c170122304fc0fb9bcc5bf2bf 540284 dbconfig-common_1.8.50_all.deb
Checksums-Sha256:
4b97ab6ff1e7a713cf36115d210f26a926c3c421c37e3eb99032645b838d4c44 1364
dbconfig-common_1.8.50.dsc
f5e60ae75548ed87b1724ff68b358caa7982aefd39c3388085324a06ea6caea8 190528
dbconfig-common_1.8.50.tar.xz
690334a3ab3d20a27665a0ab33e21b32231c2a86825ef234d8e2152e5cb26fdd 540284
dbconfig-common_1.8.50_all.deb
Files:
97ce6730fb240b4cb7570298bb5c1f60 1364 admin optional dbconfig-common_1.8.50.dsc
cf155e3e4f25989e00aad4c28fe9eb44 190528 admin optional
dbconfig-common_1.8.50.tar.xz
4f35069b77b89b2b71b3680999af990e 540284 admin optional
dbconfig-common_1.8.50_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
iQEcBAEBCAAGBQJVGiI5AAoJEJxcmesFvXUKMckIALpA5k4xkY94CIGWGPwIWsNG
uOy0xfEmrA0hQY9lCgaG1Ew92pTO2aZI6ZlbWcZD7JtVKbOiiZHbrs1XUwrbTnpd
ul9y+RsVvZAT4iIL6Z9kU54iI2/S+zr/r8u1Mp0hmxmgZaf/g2abIWuuwRchJelU
Vc3Y878JgueyQSJkWOCfDGh6tfQtP5jekzPkii0m3uzjJsBfd4+E5n3hv7ota4Ho
yYbn/cbn4gfijC5QstX39PG16L48vLGRo0fvg5H3vOX2W0pSSv13ap/TQMzi8JIz
mhao2pWfvqVr8jTB+PGkYp5tUcmqKD0yO6ui6+9IbE2OpjVdE78MR7Z2dAXfQ6U=
=sfim
-----END PGP SIGNATURE-----
--- End Message ---
