Since a few days Bacula isn't able to create new jobs.
I got this error:
25-Apr 23:15 ftirtaper-dir JobId 0: Fatal error: sql_create.c:90 Create
DB Job record INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId,Comment)
VALUES
('Ftirrd02_2-Backup.2018-04-25_23.15.00_53','Ftirrd02_2-Backup','B','F','C','2018-04-25
23:15:00',1524690900,3,'') failed. ERR=Incorrect datetime value:
'0000-00-00 00:00:00' for column 'StartTime' at row 1
I run Bacula 7.0.5 with MySQL 5.7.22 on Ubuntu Server 16.04.4 LTS.
I tried to create a table job in a test database with this command from
make_mysql_tables
CREATE TABLE Job (
JobId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
Job TINYBLOB NOT NULL,
Name TINYBLOB NOT NULL,
Type BINARY(1) NOT NULL,
Level BINARY(1) NOT NULL,
ClientId INTEGER DEFAULT 0 REFERENCES Client,
JobStatus BINARY(1) NOT NULL,
SchedTime DATETIME DEFAULT 0,
StartTime DATETIME DEFAULT 0,
EndTime DATETIME DEFAULT 0,
RealEndTime DATETIME DEFAULT 0,
JobTDate BIGINT UNSIGNED DEFAULT 0,
VolSessionId INTEGER UNSIGNED DEFAULT 0,
VolSessionTime INTEGER UNSIGNED DEFAULT 0,
JobFiles INTEGER UNSIGNED DEFAULT 0,
JobBytes BIGINT UNSIGNED DEFAULT 0,
ReadBytes BIGINT UNSIGNED DEFAULT 0,
JobErrors INTEGER UNSIGNED DEFAULT 0,
JobMissingFiles INTEGER UNSIGNED DEFAULT 0,
PoolId INTEGER UNSIGNED DEFAULT 0 REFERENCES Pool,
FileSetId INTEGER UNSIGNED DEFAULT 0 REFERENCES FileSet,
PriorJobId INTEGER UNSIGNED DEFAULT 0 REFERENCES Job,
PurgedFiles TINYINT DEFAULT 0,
HasBase TINYINT DEFAULT 0,
HasCache TINYINT DEFAULT 0,
Reviewed TINYINT DEFAULT 0,
Comment BLOB,
PRIMARY KEY(JobId),
INDEX (Name(128))
);
It doesn't work. An error occurs:
ERROR 1067 (42000): Invalid default value for 'SchedTime'
When I alter the default value of ShedTime to '1970-01-01 00:00:00' this
entry works but the error occurs with the next DATETIME entry StartTime.
Could you please help me to overcome this error in Bacula.
Many thanks in advance for your help.
Bye, Peter Grupe
--
Peter Grupe
Universität Bremen
Institut für Fernerkundung
Otto-Hahn-Alle 1, NW1, U3240
D-28359 Bremen
------------------------------------------------------------------------------
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
