Im not a MySQL crack but "EXPLAIN Job;" results in
[...]
Field | Type | Null |Key|
Default | Extra |
SchedTime | datetime | YES | | 0000-00-00 00:00:00
| |
StartTime | datetime | YES | | 0000-00-00
00:00:00 | |
EndTime | datetime | YES | | 0000-00-00
00:00:00 | |
RealEndTime | datetime | YES | | 0000-00-00 00:00:00
| |
[...]
and also an querying an entry of the old data results in displaying
correct values:
JobId | Job | Name | SchedTime |
StartTime | EndTime
179281 | server1.db.2016-09-12_19.30.17_10 | server1.db | 2016-09-12
19:30:17 | 2016-09-13 12:58:15 | 2016-09-13 12:58:16
It would be really interesting how Bacula 7 is handling this timestamp
thing when generating the SQL-command
Am 30.09.16 um 10:49 schrieb Andreas Nastke:
> looks to me as if this toy (mysql) finally handles invalid
> timestamps as erroneous.
>
>
>
> Daniel Heitepriem schrieb:
>> Hi guys,
>>
>> any thoughts on this ?
>>
>> Thanks and regards,
>> Daniel Heitepriem
>>
>> Am 20.09.16 um 12:01 schrieb Daniel Heitepriem:
>>
>> Hello everyone,
>>
>> I updated my old bacula database from version 12 (Bacula version
>> 5.0.0)
>> to version 15 (Bacula version 7.4.2) which went more or less without
>> errors (see below):
>>
>> bacula@...:~/etc$ ./update_mysql_tables -u bacula -p
>>
>> This script will update a Bacula MySQL database from version 12-14
>> to 15
>>
>> Depending on the current version of your catalog,
>> you may have to run this script multiple times.
>>
>> Enter password:
>> Enter password:
>> ERROR 1067 (42000) at line 19: Invalid default value for 'SchedTime'
>> Update of Bacula MySQL tables from 12 to 13 succeeded.
>> Enter password:
>> Enter password:
>>
>> Update of Bacula MySQL tables from 13 to 14 succeeded.
>> Enter password:
>> Enter password:
>> ERROR 1067 (42000) at line 5: Invalid default value for
>> 'FirstWritten'
>> ERROR 1067 (42000) at line 6: Invalid default value for
>> 'FirstWritten'
>> ERROR 1067 (42000) at line 7: Invalid default value for
>> 'FirstWritten'
>> ERROR 1067 (42000) at line 8: Invalid default value for
>> 'FirstWritten'
>> ERROR 1067 (42000) at line 9: Invalid default value for
>> 'FirstWritten'
>> ERROR 1067 (42000) at line 29: Invalid default value for 'SchedTime'
>> Update of Bacula MySQL tables from 14 to 15 succeeded.
>> Enter password:
>> bacula@...:~/etc$
>>
>> After that I tried to restore a file which gave me this error in
>> bconsole:
>> 20-Sep 13:13 backup-host-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
>> ('RestoreFiles.2016-09-20_13.13.49_03','RestoreFiles','R','F','C','2016-09-20
>>
>>
>> 13:13:43',1474370023,128,'') failed. ERR=Incorrect datetime value:
>> '0000-00-00 00:00:00' for column 'StartTime' at row 1
>>
>> How can I fix this?
>> Thanks you very much.
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>> ------------------------------------------------------------------------------
>>
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Bacula-users mailing list
>> Bacula-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
