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 <
daniel.hicks....@dmea.osd.mil> 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:bacula-...@dflc.ch]
> *Sent:* Friday, September 1, 2017 12:11 PM
> *To:* Jerry Lowry <michaiah2...@gmail.com>;
> bacula-users@lists.sourceforge.net
> *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 <michaiah2...@gmail.com> 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
> Bacula-users@lists.sourceforge.net
> 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
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
