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 produce a patch.
Hope this help.
Regards
On Fri, 1 Sep 2017 at 23:04, Hicks, Daniel CTR OSD DMEA <
[email protected]> wrote:
> 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:[email protected]]
> *Sent:* Friday, September 1, 2017 12:11 PM
> *To:* Jerry Lowry <[email protected]>;
> [email protected]
> *Subject:* [Non-DoD Source] 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 <[email protected]> wrote:
>
> 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,JobStatus,SchedTime,JobTDate,ClientId,Comment) VALUES
> ('BackupCatalog.2017-09-01_00.20.18_03','BackupCatalog','B','F','C','2017-09-01
> 00:20:16',1504250416,15,'') failed. ERR=Field 'StartTime' doesn't have a
> default value
>
> Does this mean the update did not work?
>
> thanks for the help!
>
> jerry
>
>
> ------------------------------------------------------------------------------
> 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
>
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
