Hi all,
Happy to new year!
So, I have trie with Mariadb Server version: 10.2.29-MariaDB-log.
I have restore bacula database before all my update and run update_mysql_tables
with success.
But, when I start a backup I get this message again :
Fatal error: sql_create.c:84 Create DB Job record INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId,Comment) VALUES
('Backup-obiwan.2020-01-10_10.34.15_03','Backup-obiwan','B','I','C','2020-01-10
10:34:14',1578648854,1,'') failed. ERR=Field 'StartTime' doesn't have a default
value
I don't understand. If mysql cause that, why with Mariadb is the same ?
And in the script update_mysql_table, I see it:
ALTER TABLE Job ALTER COLUMN StartTime DROP DEFAULT;
Regards,
Erwan
-----Message d'origine-----
De : William Muriithi <will...@perasotech.com>
Envoyé : lundi 23 décembre 2019 15:58
À : Erwan RIGOLLOT <er...@rigollot.eu>; bacula-users@lists.sourceforge.net
Objet : Re: /usr/libexec/bacula/update_mysql_tables
Hi Erwan,
Honestly, your problem has nothing to do with bacula, its purely database
related.
First, if you insist on using mysql 8, you can't use the version you are using.
You need at least Bacula Release 9.4.3. This is because you will need this
bug fix.
Change mysql my_bool to bool as it was removed from mysql - Done on May 2019
Second, the error bacula reported during insert "ERR=Field 'StartTime' doesn't
have a default value" is because, previously mysql used to allow null dates.
Current sql_mode don't allow that any more. Google on sql_mode and dates and
you should get an idea on what to do that suites Gentoo.
In short, your pains are all caused by mysql and require just mysql skills to
resolve.
Regards,
William
________________________________________
From: Erwan RIGOLLOT <er...@rigollot.eu>
Sent: December 23, 2019 9:41 AM
To: bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] /usr/libexec/bacula/update_mysql_tables
Hi all,
Anyone can help me ?
Thanks
Erwan
-----Message d'origine-----
De : Erwan RIGOLLOT <er...@rigollot.eu>
Envoyé : jeudi 28 novembre 2019 16:18
À : bacula-users@lists.sourceforge.net
Objet : Re: [Bacula-users] /usr/libexec/bacula/update_mysql_tables
Hi William and all,
I have a catalog backup before update.
So I have try this "sql_mode = NO_ENGINE_SUBSTITUTION" because I would like to
keep version of my distribution (gentoo).
(But if i have to do different, i will do).
The script /usr/libexec/bacula/update_mysql_tables run good:
This script will update a Bacula MySQL database from version 12-15 to 16
Depending on the current version of your catalog, you may have to run this
script multiple times.
Enter password:
Enter password:
Update of Bacula MySQL tables 15 to 16 succeeded.
Enter password:
So I try to do backup, and doesn't work :
28-nov. 16:13 obiwan-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
('Backup-tardis.2019-11-28_16.13.50_03','Backup-tardis','B','I','C','2019-11-28
16:13:48',1574954028,5,'') failed. ERR=Field 'StartTime' doesn't have a default
value
I don't understand because the script update_mysql_tables remove default value
?!?
Can you help me ?
Thanks and have a good day !
-----Message d'origine-----
De : William Muriithi <will...@perasotech.com> Envoyé : vendredi 22 novembre
2019 16:41 À : Erwan RIGOLLOT <er...@rigollot.eu>;
bacula-users@lists.sourceforge.net
Objet : Re: /usr/libexec/bacula/update_mysql_tables
Hi Erwan,
Hope you had made a catalog backup before schema upgrade.
You can't use bacula 9.0 with mysql 8. mysql made some change that were only
fixed in a later bacula version, think bacula 9.2.
So if you have to use mysql 8, please use the latest bacula binaries.
Alternatively, use Mariadb, which would be my advice as it don't change your
plans at all.
Also, change the sql mode to match that of earlier versions. Something like
this "sql_mode = NO_ENGINE_SUBSTITUTION"
Anyway, all this depends on whether you have a backup.
Regard,
William
From: Erwan RIGOLLOT <er...@rigollot.eu>
Sent: November 22, 2019 9:50 AM
To: bacula-users@lists.sourceforge.net <bacula-users@lists.sourceforge.net>
Subject: [Bacula-users] /usr/libexec/bacula/update_mysql_tables
Hello,
I have try to update bacula database after update Mysql (8.0.17) and bacula (
9.0.8-r1).
I have get this result and backup don't work .... :
This script will update a Bacula MySQL database from version 12-15 to 16
Depending on the current version of your catalog, you may have to run this
script multiple times.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1067 (42000) at line 3: Invalid default value for 'FirstWritten'
ERROR 1060 (42S21) at line 4: Duplicate column name 'VolParts'
ERROR 1067 (42000) at line 5: Invalid default value for 'FirstWritten'
ERROR 1067 (42000) at line 6: Invalid default value for 'FirstWritten'
ERROR 1067 (42000) at line 7: Invalid default value for 'FirstWritten'
ERROR 1067 (42000) at line 13: Invalid default value for 'StartTime'
ERROR 1067 (42000) at line 14: Invalid default value for 'SchedTime'
ERROR 1067 (42000) at line 15: Invalid default value for 'SchedTime'
ERROR 1067 (42000) at line 16: Invalid default value for 'SchedTime'
ERROR 1067 (42000) at line 17: Invalid default value for 'StartTime'
ERROR 1067 (42000) at line 18: Invalid default value for 'SchedTime'
ERROR 1067 (42000) at line 19: Invalid default value for 'SchedTime'
ERROR 1067 (42000) at line 20: Invalid default value for 'SchedTime'
ERROR 1067 (42000) at line 23: Invalid default value for 'LastWritten'
ERROR 1067 (42000) at line 24: Invalid default value for 'FirstWritten'
ERROR 1067 (42000) at line 25: Invalid default value for 'FirstWritten'
ERROR 1067 (42000) at line 26: Invalid default value for 'FirstWritten'
ERROR 1067 (42000) at line 29: Invalid default value for 'SchedTime'
Update of Bacula MySQL tables 15 to 16 succeeded.
mysql: [Warning] Using a password on the command line interface can be insecure.
Thanks,
Erwan
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fbacula-users&data=02%7C01%7Cerwan%40rigollot.eu%7C7281801eca1f4f0fae2c08d787b87c7b%7C61b429f8f50a44a2aea1286497c97ee3%7C0%7C0%7C637127098752631759&sdata=aGvuDQTO8mFXPx9pFspWa4od8N%2BhNYlAHAoz7Yc4ZbQ%3D&reserved=0
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fbacula-users&data=02%7C01%7Cerwan%40rigollot.eu%7C7281801eca1f4f0fae2c08d787b87c7b%7C61b429f8f50a44a2aea1286497c97ee3%7C0%7C0%7C637127098752641754&sdata=uCvNRuGzoMpF9wysvjoNxCLGykbEbJcFUAaN08EDCIo%3D&reserved=0
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
