[pkg-bacula-devel] Bug#854042: db insert crashes

[Carsten Leonhardt]

Control: reassign -1 bacula-director-mysql

Hi,

> since some days I get this and all job fails:
>
> [quote]
> 03-Feb 12:05 merkur.jff-webhosting.net-dir JobId 0: Fatal error:
> sql_create.c:86 Create DB Job record INSERT INTO Job
> (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId,Comment) VALUES
> ('merkur-data.2017-02-03_12.05.01_04','merkur-data','B','I','C','2017-02-03
> 12:05:01',1486119901,2,'') failed. ERR=Incorrect datetime value: '0000-00-00
> 00:00:00' for column 'StartTime' at row 1
> [/quote]
>
> I you need more infos pleas ask.

while you didn't say so in your bug report, I suppose you are using a
MySQL-Database.

Your problem is discussed here:

https://sourceforge.net/p/bacula/mailman/bacula-users/thread/30db3ed3-64e9-53f6-8b65-8147a9575776%40caerllewys.net/#msg35406296

So, did you upgrade your MySQL-Server just before the errors started
occuring? If yes, from which version to which? Or did you maybe purge
your MySQL-Server and then reinstalled a newer version or something like
that?

 - Carsten