Phil Stracchino wrote on 05/04/2018 01:57 PM:
On 05/04/18 12:09, Ken Mandelberg wrote:
With this mysqld always fails apparently with
018-05-04T15:55:57.823432Z 0 [ERROR] unknown variable
'SQL_MODE=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
That looks correct to me. Try making sql_mode lower case. And just out
of constructive paranoia, don't copy and paste, retype the line by hand
just to be certain there are no weird non-printing characters in there.
Actually, going to lower case was enough. One problem solved!
Aside from the startup problem, with sql_mode set dynamically to avoid
the zero date issue, I still have another
one. Bacula does a QUERY to Media with a large number of fields which
includes VolType, but gets
Unknown column 'VolType' in 'field list'
You HAVE run the Bacula table upgrade script, right?
From my original post
--------------
I did a Ubuntu update from 16.04 to 18.04. The automatic Bacula update
as part of the OS upgrade partially failed.
After the upgrade I found myself with
bacula-dir JobId 0: Fatal error: Version error for database "bacula".
Wanted 16, got 14
So I ran
/usr/share/bacula-director/update_mysql_tables
I had to change db_name in the script to "bacula", but it seemed to have
worked and the the director was able to start
-------------
I hope I ran the right script. To be honest I was surprised the only copy was in
/usr/share and that I had to hand edit the db_name to 'bacula" in the script.
It did change from 14 to 16. The Query to Media has a long list of fields and
comparing the query to fields in the Media Table
I see 7 missing fields: VolType,VolHoles,VolHoleBytes,
VolABytes,VolCloudParts,LastPart,LastPartBytes.
Looking at the script it should have added these fields but didn't. I wonder if
that was because I ran it before the zero date
issue was fixed.
Any suggestion on how to recover? The VersionId does show 16, so the script is
not going to re-run as is.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
