On Tuesday, August 16, 2016 at 11:01:42 PM UTC+2, Tilman Glotzner wrote:
> Udate for "Upgrading baroes database":
Well, the fix was only a partial one -- there are apparently more issues in the
definition of the database tables. I tried to run a backup job which results in
this error message:
JobId 0: Fatal error: sql_create.c:98 Create DB Job record INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId,Comment) VALUES
('BackupTgvs2ToDisk.2016-08-16_23.53.02_14','BackupTgvs2ToDisk','B','F','C','2016-08-16
23:53:00',1471384380,7,'') failed. ERR=Incorrect datetime value: '0000-00-00
00:00:00'
The root cause seems to be identical with that of my last posting, i.e. the
default value for the column is invalid. I tried alter the column definition.
Now, I am in a dead lock situation however:
mysql> ALTER TABLE `Job` MODIFY COLUMN `StartTime` TIMESTAMP NOT NULL DEFAULT
CURRENT_TIMESTAMP;
ERROR 1067 (42000): Invalid default value for 'SchedTime'
mysql> ALTER TABLE `Job` MODIFY COLUMN `SchedTime` TIMESTAMP NOT NULL DEFAULT
CURRENT_TIMESTAMP;
ERROR 1067 (42000): Invalid default value for 'StartTime'
And there is another issue with bconsole: The word completion using the tab key
and CTRL-R for reverse search no longer works.
Help is appreciated...
Thanks
Tilman
--
You received this message because you are subscribed to the Google Groups
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
For more options, visit https://groups.google.com/d/optout.
