Hey Phil, Thank you very much, I deleted the 2 lines that you suggested and ran the script again and it took about 20-30 minutes to update/convert the database successfully, I had to enter my MYSQL password multiple times before its completed.
My Bacula Server is up and running again and I am happy. 🙂 Thanks again, see logs below for reference [root@baculaserver bacula]# ./update_mysql_tables -u root -p 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 Enter password: Enter password: DO NOT BREAK THE SCRIPT AFTER THIS POINT DO NOT BREAK THE SCRIPT AFTER THIS POINT Update of Bacula MySQL tables from 16 to 1017 succeeded. Enter password: Enter password: Update of Bacula MySQL tables from 1017 to 1018 succeeded. Enter password: Enter password: Update of Bacula MySQL tables 1018 to 1019 succeeded. (From 16) Enter password: Enter password: Update of Bacula MySQL tables 1019 to 1020 succeeded. Enter password: Enter password: Update of Bacula MySQL tables 1020 to 1021 succeeded. Enter password: Enter password: ERROR 1067 (42000) at line 53: Invalid default value for 'EventsInsertTime' ERROR 1146 (42S02) at line 66: Table 'bacula.Events' doesn't exist Update of Bacula MySQL tables 1021 to 1022 succeeded. Enter password: [root@baculaserv bacula]# Regards, Humphrey ________________________________ From: Phil Stracchino <ph...@caerllewys.net> Sent: Monday, May 31, 2021 10:50 PM To: bacula-users@lists.sourceforge.net <bacula-users@lists.sourceforge.net> Subject: Re: [Bacula-users] Update of Bacula MySQL tables from 16 to 1017 failed. [Help!] On 5/31/21 3:22 PM, Humphrey Bryant via Bacula-users wrote: > Hi All, > > I had a perfectly good Bacula 9.6.6 Server and upgraded Bacula 9.6.6 to > the new Bacula 11.03 and now my bacula-dir will not start. 🙁 Also the > database upgrade was not done automatically even though I used > slanesh-Bacula REPO to do the upgrade. I tried updating the database > manually by running the scripts provided, I'm getting the following error: > ERROR 1064 (42000) at line 9: You have an error in your SQL syntax; > check the manual that corresponds to your MariaDB server version for the > right syntax to use near 'IF EXISTS JobId on File' at line 1 > Update of Bacula MySQL tables from 16 to 1017 failed. > > Please see full details below when I run the command to manually update > the database. > I am currently using MariDB as my database ( I never had any issues with > it until now) > > root@baculaserver bacula]# ./update_mysql_tables -u root -p > > 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 > > Enter password: > Enter password: > ERROR 1064 (42000) at line 9: You have an error in your SQL syntax; > check the manual that corresponds to your MariaDB server version for the > right syntax to use near 'IF EXISTS JobId on File' at line 1 > Update of Bacula MySQL tables from 16 to 1017 failed. Humphrey, Actually, there is no point to that DROP INDEX operation, because the entire table is going to be dropped after its replacement is rebuilt anyway. What you can (and probably should) do is find the following two lines: DROP INDEX IF EXISTS JobId on File; DROP INDEX IF EXISTS JobId_2 on File; And, frankly, just delete them. They serve no purpose. If you prefer to have those indexes dropped anyway in the script, then just delete the words 'IF EXISTS' from these two lines ONLY. The reason they are there is probably a copy-paste error on my part. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
