Re: [Bacula-users] [Non-DoD Source] Re: database upgrade problem

On 09/01/17 21:50, Jerry Lowry wrote: > > Okay, on the one system that I upgraded to 9.0.3 I also upgraded the > database engine to mariadb 12.2.8.  Was still getting the error.  I then > went back to the July email and saw that they removed the > |STRICT_TRANS_TABLES| >

Re: [Bacula-users] [Non-DoD Source] Re: database upgrade problem

Okay, on the one system that I upgraded to 9.0.3 I also upgraded the database engine to mariadb 12.2.8. Was still getting the error. I then went back to the July email and saw that they removed the STRICT_TRANS_TABLES

Re: [Bacula-users] [Non-DoD Source] Re: database upgrade problem

On 09/01/17 17:28, Davide Franco wrote: > Do you use MySQL or MariaDb ? > > It is something related to default value for datetime fields. > > MariaDb does not accept 0 or Null ( I don't remember). You need the > check previous thread in this mailing list. This is correct, it is not a MariaDB vs

Re: [Bacula-users] [Non-DoD Source] Re: database upgrade problem

Do you use MySQL or MariaDb ? It is something related to default value for datetime fields. MariaDb does not accept 0 or Null ( I don't remember). You need the check previous thread in this mailing list. To fix the problem you need to update the database schema manually, or find someone who prod

Re: [Bacula-users] Bacula Verification Procedures

On 09/01/2017 12:53 PM, Bill Arlofski wrote: > On 09/01/2017 06:36 AM, Jim Richardson wrote: >> Bill, >> >> Thank you so much for the response. This is the best possible answer I >> could have received. I will put your script in play. I will most likely >> make changes to have this run automag

Re: [Bacula-users] [Non-DoD Source] Re: database upgrade problem

Davide, I am having this same issue. Can you clarify how to make sure the catalog upgrade is done. I did the update to tables without error but am not sure it is the same. Thank you Dan Hicks | 916-999-2711 From: Davide Franco [mailto:bacula-...@dflc.ch] Sent: Friday, September 1, 2017 12:11

Re: [Bacula-users] database upgrade problem

Hi Jerry, Make sure the catalog upgrade has been done without issue. This seems to be related to Mariadb. Good luck Davide On Fri, 1 Sep 2017 at 17:38, Jerry Lowry wrote: > Hi, > I finally got my backup server upgraded to 9..0.3. I have run the > database update and it succeeded with out an

Re: [Bacula-users] Bacula Verification Procedures

On 09/01/2017 06:36 AM, Jim Richardson wrote: > Bill, > > Thank you so much for the response. This is the best possible answer I could > have received. I will put your script in play. I will most likely make > changes to have this run automagically 😊 say quarterly. Modifications would > be

[Bacula-users] database upgrade problem

Hi, I finally got my backup server upgraded to 9..0.3. I have run the database update and it succeeded with out any errors. But I get this error any time I start a job: 01-Sep 00:20 kilchis-dir JobId 0: Fatal error: sql_create.c:84 Create DB Job record INSERT INTO Job (Job,Name,Type,Level,JobStat

Re: [Bacula-users] Bacula Verification Procedures

Bill, Thank you so much for the response. This is the best possible answer I could have received. I will put your script in play. I will most likely make changes to have this run automagically 😊 say quarterly. Modifications would be to pull jobs ids for those jobs and feed the script. Unle

[Bacula-users] Observations on speeding-up backups by splitting jobs

Hi all, the following observations might be useful for other users looking to speed-up their backups. It might be specific to our local system architecture, but we hope that it might also help others to achieve shorter backup runtimes. Setup: -- The file server is an EMC VNX5200 unified stor