Your message dated Mon, 24 Aug 2009 22:33:21 +0000 with message-id <e1mfi6l-0006w3...@ries.debian.org> and subject line Bug#542810: fixed in bacula 3.0.2-3 has caused the Debian Bug report #542810, regarding update from sqlite2 will fail because of AUTOINCREMENT in table definition 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.) -- 542810: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=542810 Debian Bug Tracking System Contact ow...@bugs.debian.org with problems
--- Begin Message ---Package: bacula-director-sqlite3 Version: 3.0.2-1 Severity: serious Hello. During the update from a previous sqlite2-base director, the postinst runs the following command: sqlite "$DB" .dump | sqlite3 "$DB.sqlite3" This will fail on older installations of bacula-director-sqlite, because the database may contain table schemas like the following: CREATE TABLE Filename ( FilenameId INTEGER UNSIGNED AUTOINCREMENT, Name TEXT DEFAULT "", PRIMARY KEY(FilenameId) ); Problem is, sqlite3 does not understand AUTOINCREMENT in this way, this keyword is only allowed alongside a PRIMARY KEY statement. Besides, every integer primary key will autoincrement without this keyword, as per http://sqlite.org/faq.html#q1 I suggest using a statement like this in the postinst of bacula-director-sqlite3: sqlite "$DB" .dump | sed 's/ AUTOINCREMENT,/,/' | sqlite3 "$DB.sqlite3" This will eliminate the unwanted AUTOINCREMENT and the resulting database dump will be the same as a newly created bacula sqlite3 database: CREATE TABLE Filename ( FilenameId INTEGER UNSIGNED, Name TEXT DEFAULT "", PRIMARY KEY(FilenameId) ); But: testing revealed the FilenameId column will not autoincrement despite it being the primary key for this table. This sees more like a bug to be discussed with upstream. From my reading of the source and my tests with sqlite3, the currect table schema should not be working. The (to me) correct schema of this table should be: CREATE TABLE Filename ( FilenameId INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT DEFAULT "", ); So far, I am unsure what to do. -- System Information: Debian Release: squeeze/sid APT prefers unstable APT policy: (900, 'unstable'), (200, 'experimental') Architecture: i386 (i686) Kernel: Linux 2.6.29.1-217 Locale: lang=de...@euro, lc_ctype=de...@euro (charmap=ISO-8859-15) Shell: /bin/sh linked to /bin/dash Versions of packages bacula-director-sqlite3 depends on: ii bacula-director-common 2.4.4-1+b1 network backup, recovery and verif ii debconf [debconf-2.0] 1.5.27 Debian configuration management sy ii libc6 2.9-25 GNU C Library: Shared libraries ii libgcc1 1:4.4.1-2 GCC support library ii libsqlite3-0 3.6.17-2 SQLite 3 shared library ii libstdc++6 4.4.1-2 The GNU Standard C++ Library v3 ii libwrap0 7.6.q-18 Wietse Venema's TCP wrappers libra ii python2.4 2.4.6-2 An interactive high-level object-o ii sqlite3 3.6.17-2 A command line interface for SQLit bacula-director-sqlite3 recommends no packages. bacula-director-sqlite3 suggests no packages.
--- End Message ---
--- Begin Message ---Source: bacula Source-Version: 3.0.2-3 We believe that the bug you reported is fixed in the latest version of bacula, which is due to be installed in the Debian FTP archive: bacula-client_3.0.2-3_all.deb to pool/main/b/bacula/bacula-client_3.0.2-3_all.deb bacula-common-mysql_3.0.2-3_i386.deb to pool/main/b/bacula/bacula-common-mysql_3.0.2-3_i386.deb bacula-common-pgsql_3.0.2-3_i386.deb to pool/main/b/bacula/bacula-common-pgsql_3.0.2-3_i386.deb bacula-common-sqlite3_3.0.2-3_i386.deb to pool/main/b/bacula/bacula-common-sqlite3_3.0.2-3_i386.deb bacula-common_3.0.2-3_i386.deb to pool/main/b/bacula/bacula-common_3.0.2-3_i386.deb bacula-console-qt_3.0.2-3_i386.deb to pool/main/b/bacula/bacula-console-qt_3.0.2-3_i386.deb bacula-console_3.0.2-3_i386.deb to pool/main/b/bacula/bacula-console_3.0.2-3_i386.deb bacula-director-common_3.0.2-3_i386.deb to pool/main/b/bacula/bacula-director-common_3.0.2-3_i386.deb bacula-director-mysql_3.0.2-3_i386.deb to pool/main/b/bacula/bacula-director-mysql_3.0.2-3_i386.deb bacula-director-pgsql_3.0.2-3_i386.deb to pool/main/b/bacula/bacula-director-pgsql_3.0.2-3_i386.deb bacula-director-sqlite3_3.0.2-3_i386.deb to pool/main/b/bacula/bacula-director-sqlite3_3.0.2-3_i386.deb bacula-director-sqlite_3.0.2-3_all.deb to pool/main/b/bacula/bacula-director-sqlite_3.0.2-3_all.deb bacula-fd_3.0.2-3_i386.deb to pool/main/b/bacula/bacula-fd_3.0.2-3_i386.deb bacula-sd-mysql_3.0.2-3_i386.deb to pool/main/b/bacula/bacula-sd-mysql_3.0.2-3_i386.deb bacula-sd-pgsql_3.0.2-3_i386.deb to pool/main/b/bacula/bacula-sd-pgsql_3.0.2-3_i386.deb bacula-sd-sqlite3_3.0.2-3_i386.deb to pool/main/b/bacula/bacula-sd-sqlite3_3.0.2-3_i386.deb bacula-sd-sqlite_3.0.2-3_i386.deb to pool/main/b/bacula/bacula-sd-sqlite_3.0.2-3_i386.deb bacula-sd_3.0.2-3_i386.deb to pool/main/b/bacula/bacula-sd_3.0.2-3_i386.deb bacula-server_3.0.2-3_all.deb to pool/main/b/bacula/bacula-server_3.0.2-3_all.deb bacula-traymonitor_3.0.2-3_i386.deb to pool/main/b/bacula/bacula-traymonitor_3.0.2-3_i386.deb bacula_3.0.2-3.diff.gz to pool/main/b/bacula/bacula_3.0.2-3.diff.gz bacula_3.0.2-3.dsc to pool/main/b/bacula/bacula_3.0.2-3.dsc bacula_3.0.2-3_all.deb to pool/main/b/bacula/bacula_3.0.2-3_all.deb 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 542...@bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. John Goerzen <jgoer...@complete.org> (supplier of updated bacula 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...@debian.org) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Format: 1.8 Date: Mon, 24 Aug 2009 16:22:41 -0500 Source: bacula Binary: bacula bacula-common bacula-common-sqlite3 bacula-common-pgsql bacula-common-mysql bacula-director-common bacula-director-sqlite bacula-director-sqlite3 bacula-director-mysql bacula-director-pgsql bacula-client bacula-fd bacula-server bacula-sd bacula-sd-sqlite3 bacula-sd-sqlite bacula-sd-mysql bacula-sd-pgsql bacula-console bacula-console-qt bacula-traymonitor Architecture: source all i386 Version: 3.0.2-3 Distribution: unstable Urgency: low Maintainer: John Goerzen <jgoer...@complete.org> Changed-By: John Goerzen <jgoer...@complete.org> Description: bacula - network backup, recovery and verification - meta-package bacula-client - network backup, recovery and verification - client meta-package bacula-common - network backup, recovery and verification - common support files bacula-common-mysql - network backup, recovery and verification - MySQL common files bacula-common-pgsql - network backup, recovery and verification - PostgreSQL common fil bacula-common-sqlite3 - network backup, recovery and verification - SQLite v3 common file bacula-console - network backup, recovery and verification - text console bacula-console-qt - Bacula Administration Tool Console bacula-director-common - network backup, recovery and verification - Director common files bacula-director-mysql - network backup, recovery and verification - MySQL storage for Dir bacula-director-pgsql - network backup, recovery and verification - PostgreSQL storage fo bacula-director-sqlite - network backup, recovery and verification - SQLite 2 director tra bacula-director-sqlite3 - network backup, recovery and verification - SQLite 3 storage for bacula-fd - network backup, recovery and verification - file daemon bacula-sd - network backup, recovery and verification - storage daemon bacula-sd-mysql - network backup, recovery and verification - MySQL SD tools bacula-sd-pgsql - network backup, recovery and verification - PostgreSQL SD tools bacula-sd-sqlite - network backup, recovery and verification - SQLite SD tools bacula-sd-sqlite3 - network backup, recovery and verification - SQLite 3 SD tools bacula-server - network backup, recovery and verification - server meta-package bacula-traymonitor - network backup, recovery and verification - tray monitor Closes: 542810 542829 543330 543345 Changes: bacula (3.0.2-3) unstable; urgency=low . * bacula-director-common doesn't require bacula-fd. Patch from Sven Hartge. Closes: #542829. * Use sed to tweak AUTOINCREMENT columns on sqlite2->sqlite3 upgrades. Closes: #542810. * Correct dep on "sqlite2" to "sqlite". Closes: #543330. * Chown converted sqlite2->sqlite3 db to bacula:bacula. Closes: #543345. Checksums-Sha1: 641c31c6f086478b4d41c63c90d332de6aeb3c3c 1945 bacula_3.0.2-3.dsc 545b92676d972ba4b07743b8df064787dd241a7d 45716 bacula_3.0.2-3.diff.gz 1a0366c51115c28881a484a58944d3c4c278b9e6 1018 bacula_3.0.2-3_all.deb 286d66ec896ccaa807886083ccb9e309f2bf944c 38718 bacula-director-sqlite_3.0.2-3_all.deb ed36e6a6df2bd01461c7a183ad6cfc58a5311953 38744 bacula-client_3.0.2-3_all.deb 1c52ce583ae9870b00b627c6375b28c08aa35720 38670 bacula-server_3.0.2-3_all.deb 971d074c88589a76a44e45ef4f89a3daf7a3538f 599234 bacula-common_3.0.2-3_i386.deb 491e5b28dabcfe8f7fbb8da502d9f49268611254 79792 bacula-common-sqlite3_3.0.2-3_i386.deb 5cab6ee8f3e9573e3d3dd4709a8f910551a3127f 83608 bacula-common-pgsql_3.0.2-3_i386.deb 6b7b8210a16d190bc0be766895d678a55d25945e 80206 bacula-common-mysql_3.0.2-3_i386.deb 77474645ee8cd73b7988907d5be4c374e78acfc5 48748 bacula-director-common_3.0.2-3_i386.deb 908c46f83921974d0c8c9f06c7a57f1bcf075083 277944 bacula-director-sqlite3_3.0.2-3_i386.deb b19db956e3f97d4630ca8648b303dc5f81ae25b2 277912 bacula-director-mysql_3.0.2-3_i386.deb cce5dbf7e3dcac82a5d95d014d7f1da7b0975c9a 278738 bacula-director-pgsql_3.0.2-3_i386.deb a7bc2ae5745b4c52f8f643a3ba197f49a2756103 104680 bacula-fd_3.0.2-3_i386.deb 4155513c429bd12a7af60cd4a293592d156f22f1 431238 bacula-sd_3.0.2-3_i386.deb 7b67035de08c5850350014481963df98aafd779a 406118 bacula-sd-sqlite3_3.0.2-3_i386.deb 90a38dddd564d58d573886df3977165c855c1461 38650 bacula-sd-sqlite_3.0.2-3_i386.deb fc373c2626b880202192c7d32e379626fb8050a3 406158 bacula-sd-mysql_3.0.2-3_i386.deb 8183e229ba85cd23c09b3877f8d4380a9265c1f8 406180 bacula-sd-pgsql_3.0.2-3_i386.deb 824fa3b69bbc23aff72f6aa2857f8519ac7e6845 58236 bacula-console_3.0.2-3_i386.deb 4f26d9c13b624d49bc0f33b4bdde3ebd112d2fa4 549434 bacula-console-qt_3.0.2-3_i386.deb 1853871058ee3d922f162d139692bb96fb27e743 58482 bacula-traymonitor_3.0.2-3_i386.deb Checksums-Sha256: 37e8d9369ce9d98f6eb6521fb5d53a93cc21589058c4cd9456104dbefc6efee1 1945 bacula_3.0.2-3.dsc 213783003f490339e4e65aba8b7c225f81d441b9e8d15ab76852c057497508b5 45716 bacula_3.0.2-3.diff.gz ade686b486a4af714b52160a28d1571a678418853379410e3512392750b78003 1018 bacula_3.0.2-3_all.deb d67e17f78d44928ec6dd1565d36c6cd62d2590fd2c811d582e6f1294020c84aa 38718 bacula-director-sqlite_3.0.2-3_all.deb 7680df5a0c54d695fa2825823649d6dc870ed6160bca24050109c24376a554d8 38744 bacula-client_3.0.2-3_all.deb f3ebafbde915d2aedf7c02786220eaa2d9ce44dac53c65dfbf8dee1f928ad060 38670 bacula-server_3.0.2-3_all.deb 68a0b2df1bf93ce72d6f721c73aa13e85c62593f8a97ac36c2278e4293361cd8 599234 bacula-common_3.0.2-3_i386.deb 2bb407089cad37a403644a5a2d8efc768bbc03c32f8ae55ca94d2ec7f8466245 79792 bacula-common-sqlite3_3.0.2-3_i386.deb 445a6772c496a662c4c35d28a3e4f671c33d75e3330c42d6d0c30269e6dae90c 83608 bacula-common-pgsql_3.0.2-3_i386.deb a8729f53e34ced91bad5c20249d78098d899cecb4d70ef538aec49bb7572f1fc 80206 bacula-common-mysql_3.0.2-3_i386.deb ebe9548ef1734f908d983ba4e09aa813f4f2ec82dde4a9dfea63091b4d2b83b8 48748 bacula-director-common_3.0.2-3_i386.deb 61290f87e64e0292365e242c5b9468b651d36919edafad25f34405f8a246cb1a 277944 bacula-director-sqlite3_3.0.2-3_i386.deb f98ddb6167820716016a35f8629a8af49925a74c6eee7ef3902bee2658c74c68 277912 bacula-director-mysql_3.0.2-3_i386.deb 20fe69859bd18bce5aac913dcd6c4fca34eb8e90ce5bdfc48a0643fc58cc624c 278738 bacula-director-pgsql_3.0.2-3_i386.deb 2776d115c0d7a6a3062cd64176f442b07041e906ce8c29c761749ce279b3a0f5 104680 bacula-fd_3.0.2-3_i386.deb 3ef90babbf09d77d4cfdc6e2ea203624dff9e9862e46416f6f9c410014c5b9a9 431238 bacula-sd_3.0.2-3_i386.deb 2f8fa3b0f5a976a2fbfbc5ecc2a8b8003d87f9755256ad24deae6b9f46292ff5 406118 bacula-sd-sqlite3_3.0.2-3_i386.deb 2e279458d86096e8fd0565394b62b3ce78db835bf1e2465a2592f1252eb61832 38650 bacula-sd-sqlite_3.0.2-3_i386.deb c12b19c08cdc5f8b04025a583d941f6854366f3578071943c3cf7041909c0049 406158 bacula-sd-mysql_3.0.2-3_i386.deb b9ae73182957e78e840bc895c72d32b8f82036efd4de07305e18ae63cf78d696 406180 bacula-sd-pgsql_3.0.2-3_i386.deb ff24f52a36be7f78605612e426edea934cb83ff4f31f0bf68ad7321d124851ed 58236 bacula-console_3.0.2-3_i386.deb b54eed3258971f9e1a91f6f15cd63ecdce4dfa08280edd8cd77529b2de6e38f8 549434 bacula-console-qt_3.0.2-3_i386.deb 48998ed0f951f9c0e24e3a107bf7da04dbaa3aa16945768e3ae7266f84f9c5bc 58482 bacula-traymonitor_3.0.2-3_i386.deb Files: f4dfbfc6dbced0ad6bee5ca3a98a2040 1945 admin optional bacula_3.0.2-3.dsc 948765ac484787e4a840c4088256a7e3 45716 admin optional bacula_3.0.2-3.diff.gz 616f3ce4bae85b7cfe154f5a55b3764c 1018 admin optional bacula_3.0.2-3_all.deb 145d5a2283c375d353216ad06924b659 38718 admin optional bacula-director-sqlite_3.0.2-3_all.deb e3a979df7febf6a22d03d6e835ab00da 38744 admin optional bacula-client_3.0.2-3_all.deb ee3be83c86a961402f390f8fa84ae1bb 38670 admin optional bacula-server_3.0.2-3_all.deb fb2b8f47086b426b29792bece930adde 599234 admin optional bacula-common_3.0.2-3_i386.deb 6663b81ea10d43fb2551b3acb4695a1b 79792 admin optional bacula-common-sqlite3_3.0.2-3_i386.deb 9029e477c71f0b0fc2d0767d873372d0 83608 admin optional bacula-common-pgsql_3.0.2-3_i386.deb 1631ec43db78a58af2ece07a0a1e992e 80206 admin optional bacula-common-mysql_3.0.2-3_i386.deb 1cfe27d67a75b3dae19e56a34d1674e4 48748 admin optional bacula-director-common_3.0.2-3_i386.deb 707513043ae164db3d3844df4d42bd79 277944 admin optional bacula-director-sqlite3_3.0.2-3_i386.deb ea0f3e01bdf9c5d9afd4ab42e59ac9d9 277912 admin optional bacula-director-mysql_3.0.2-3_i386.deb 687ac736e9b2d5aa11a4df07aab8606d 278738 admin optional bacula-director-pgsql_3.0.2-3_i386.deb eada5b2db05c4680084cfe6c7bc80f00 104680 admin optional bacula-fd_3.0.2-3_i386.deb 1ed0c2b48de7112b6e164b8ea9324ff4 431238 admin optional bacula-sd_3.0.2-3_i386.deb 55cb3075791af29a519cede482913e4d 406118 admin optional bacula-sd-sqlite3_3.0.2-3_i386.deb f4a0c6c2e521b09c5cc5315e088fd015 38650 admin optional bacula-sd-sqlite_3.0.2-3_i386.deb f8186f978404f14718eb47fa1bc7a27f 406158 admin optional bacula-sd-mysql_3.0.2-3_i386.deb 95dd3db444d1cfabdd56b717e185d137 406180 admin optional bacula-sd-pgsql_3.0.2-3_i386.deb 0997e7bfb332db56f65c3b1a04876812 58236 admin optional bacula-console_3.0.2-3_i386.deb de736b8a8461777628d8bd182810bf3f 549434 admin optional bacula-console-qt_3.0.2-3_i386.deb 19cbb55b38910adc9ed123ec293fc1f0 58482 admin optional bacula-traymonitor_3.0.2-3_i386.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkqTB1EACgkQthyt9Q6V7ksiMwCeOaRzZMXETqypiUi21UBKoEiX vNUAn26qj/ahsFLdQCKrLe+ebCOG0P7U =2tCk -----END PGP SIGNATURE-----
--- End Message ---
