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.
However, when it was time for its first backup job
29-Apr 23:05 orac-dir JobId 0: Fatal error: sql_create.c:84 Create DB
Job record INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId,Comment)
VALUES
('BackupClient1.2018-04-29_23.05.00_03','BackupClient1','B','D','C','2018-04-29
23:05:00',1525057500,1,'') failed. ERR=Incorrect datetime value:
'0000-00-00 00:00:00' for column 'StartTime' at row 1
29-Apr 23:10 orac-dir JobId 0: Fatal error: sql_create.c:84 Create DB
Job record INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId,Comment)
VALUES
('BackupCatalog.2018-04-29_23.10.00_04','BackupCatalog','B','F','C','2018-04-29
23:10:00',1525057800,1,'') failed. ERR=Incorrect datetime value:
'0000-00-00 00:00:00' for column 'StartTime' at row 1
The new version is Version: 9.0.6 (20 November 2017). Not sure what the
old version was.
------------------------------------------------------------------------------
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
