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

Carsten Leonhardt leo at debian.org
Fri Feb 3 14:31:38 UTC 2017

Control: reassign -1 bacula-director-mysql


> 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

Your problem is discussed here:


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

 - Carsten

More information about the pkg-bacula-devel mailing list