tags 569285 pending thanks A commit relevant to this bug has occurred.
Revision: 0541ba6d8725f2d891b09934a227a835859be10c commit 0541ba6d8725f2d891b09934a227a835859be10c Author: John Goerzen <jgoer...@complete.org> Date: Mon Feb 22 11:12:44 2010 -0600 Fix MySQL upgrade removing Stripe in JobMedia Closes: #569285 Alter update_mysql_tables.in to make sure we don't drop a column that doesn't exist. Create shell script to handle this process appropriately. Details at http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=569285 http://bugs.bacula.org/view.php?id=1498 Quoting from John Goerzen's report at the second URL: In Bacula 5.0.0, src/cats/update_mysql_tables.in contains this line: ALTER TABLE JobMedia DROP Stripe ; And indeed, in Bacula 3.0.0, src/cats/make_mysql_tables.in created that column. Trouble is: bacula/updatedb$ grep -i stripe *mysql* update_mysql_tables_8_to_9:ALTER TABLE JobMedia ADD COLUMN Stripe INTEGER UNSIGNED NOT NULL DEFAULT 0; update_mysql_tables_9_to_10.in:ALTER TABLE JobMedia DROP COLUMN Stripe; In other words, users that were running Bacula 1.38, and upgraded to 2.0, would have had the Stripe column removed at that point and never re-created. It seems like somebody added the code to remove the stripe column to 2.0 but forgot to remove it from the make_mysql_tables.in until 5.0. I do not know what a good solution to this is. MySQL does not appear to support an "IF EXISTS" clause to DROP COLUMN. Diff: http://git.debian.org/?p=users/jgoerzen/bacula;a=commitdiff_plain;h=0541ba6d8725f2d891b09934a227a835859be10c debian/bacula-director-mysql.dirs | 1 + debian/bacula-director-mysql.script.5.0.0 | 62 +++++++++++++++++++++++++++++ debian/rules | 3 + src/cats/update_mysql_tables.in | 1 - 4 files changed, 66 insertions(+), 1 deletions(-) create mode 100644 debian/bacula-director-mysql.script.5.0.0 More details are available at: http://git.debian.org/?p=users/jgoerzen/bacula;a=commit;h=0541ba6d8725f2d891b09934a227a835859be10c -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org