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
