Hi all,
(sent this yesterday to the wrong address... let's retry :-)
I guess the subject says it all, but here are some details:
- Bacula version being upgraded is 9.6.6
The current version of the database:
+-----------+
| VersionId |
+-----------+
| 16 |
+-----------+
- Upgrade fails as follows:
This script will update a Bacula MySQL database
from any from version 12-15 or 1014-1021 to version 1022
which is needed to convert from any Bacula Enterprise
version 4.0.x or later to version 12.4.x
or Bacula Community versions 5.0.x, 5.2.x, 7.4.x, 9.x.x to
Community version 11.0
Depending on the current version of your catalog, you may
have to run this script multiple times
ERROR 1264 (22003) at line 24: Out of range value for column 'FileIndex'
at row 1
Update of Bacula MySQL tables from 16 to 1017 failed.
This would indicate that the file_temp table is using an unsigned
version of FileIndex however it should be signed, so changing the
schema of that temp table makes it go further,
- after this fix, it will still show errors:
This script will update a Bacula MySQL database
from any from version 12-15 or 1014-1021 to version 1022
which is needed to convert from any Bacula Enterprise
version 4.0.x or later to version 12.4.x
or Bacula Community versions 5.0.x, 5.2.x, 7.4.x, 9.x.x to
Community version 11.0
Depending on the current version of your catalog, you may
have to run this script multiple times
Update of Bacula MySQL tables from 16 to 1017 succeeded.
ERROR 1050 (42S01) at line 2: Table 'FileMedia' already exists
Update of Bacula MySQL tables from 1017 to 1018 succeeded.
ERROR 1264 (22003) at line 2: Out of range value for column 'FileIndex'
at row 1626663
Update of Bacula MySQL tables 1018 to 1019 succeeded. (From 16)
Update of Bacula MySQL tables 1019 to 1020 succeeded.
Update of Bacula MySQL tables 1020 to 1021 succeeded.
ERROR 1050 (42S01) at line 3: Table 'TagJob' already exists
ERROR 1050 (42S01) at line 10: Table 'TagClient' already exists
ERROR 1050 (42S01) at line 17: Table 'TagMedia' already exists
ERROR 1050 (42S01) at line 24: Table 'TagObject' already exists
ERROR 1050 (42S01) at line 31: Table 'Object' already exists
ERROR 1061 (42000) at line 48: Duplicate key name 'object_jobid_idx'
ERROR 1061 (42000) at line 49: Duplicate key name 'object_type_idx'
ERROR 1061 (42000) at line 50: Duplicate key name 'object_name_idx'
ERROR 1061 (42000) at line 51: Duplicate key name 'object_source_idx'
ERROR 1050 (42S01) at line 53: Table 'Events' already exists
ERROR 1061 (42000) at line 66: Duplicate key name 'events_time_idx'
Update of Bacula MySQL tables 1021 to 1022 succeeded.
The above may or may not be a real success; this problem was reported to
me by someone who could not subscribe the the list (which way be another
issue...)
In any case, the MySQL upgrade script seems to need some additional
attention. So, if someone with a MySQL instance available feels inclined
to have a look, I know of at least one happy user :-)
By now, i.e. since yesterday, the user noticing this created and patch
which probably is worth looking at:
--- update_mysql_tables.orig Tue Dec 15 10:27:22 2020
+++ update_mysql_tables Tue Dec 15 10:57:10 2020
@@ -168,7 +168,7 @@
CREATE TABLE file_temp (
FileId BIGINT UNSIGNED NOT NULL,
- FileIndex INTEGER UNSIGNED DEFAULT 0,
+ FileIndex INTEGER DEFAULT 0,
JobId INTEGER UNSIGNED NOT NULL,
PathId INTEGER UNSIGNED NOT NULL,
Filename BLOB NOT NULL,
@@ -321,9 +321,9 @@
if [ "$SKIP1018" = 1 -a "$DBVERSION" -eq 1018 ]; then
if mysql $* -f <<END-OF-DATA
USE ${db_name};
-ALTER TABLE File MODIFY FileIndex INTEGER UNSIGNED DEFAULT 0;
-ALTER TABLE RestoreObject MODIFY FileIndex INTEGER UNSIGNED DEFAULT 0;
-ALTER TABLE BaseFiles MODIFY FileIndex INTEGER UNSIGNED DEFAULT 0;
+ALTER TABLE File MODIFY FileIndex INTEGER DEFAULT 0;
+ALTER TABLE RestoreObject MODIFY FileIndex INTEGER DEFAULT 0;
+ALTER TABLE BaseFiles MODIFY FileIndex INTEGER DEFAULT 0;
UPDATE Version SET VersionId=1019;
END-OF-DATA
then
(patch ends above this line)
Cheers,
Arno
PS:
I also noted that I can not get a password reset link from
bugs.bacula.org because I need to know my user name and mail address for
reseting, or sign up with a different mail addres...
--
Arno Lehmann
IT-Service Lehmann
Sandstr. 6, 49080 Osnabrück
_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel
