My problem with the label command comes down do this, the INSERT into
the Media Record fails since FirstWritten doesn't have a default value.
Details below.
From very old posting this seems to be an incompatibility with newer
Mysql that doesnt want NULL values. For the record, I'm running Bacula
9.0.6 and Mysql 5.7 both of which are the defaults on Ubuntu 18.04.
Suggestions?
The failing INSERT:
14-Mar 15:55 orac-dir JobId 3992: Error: sql_create.c:439 Create DB
Media record INSERT INTO Media
(VolumeName,MediaType,MediaTypeId,PoolId,MaxVolBytes,VolCapacityBytes,Recycle,VolRetention,VolUseDuration,M
axVolJobs,MaxVolFiles,VolStatus,Slot,VolBytes,InChanger,VolReadTime,VolWriteTime,VolType,VolParts,VolCloudParts,LastPartBytes,EndFile,EndBlock,LabelType,StorageId,DeviceId,LocationId,ScratchPoolId,RecyclePo
olId,Enabled,ActionOnPurge,CacheRetention)VALUES
('Vol0013','File',0,2,53687091200,0,1,7776000,0,0,0,'Append',0,0,0,0,0,0,0,0,'0',0,0,0,1,0,0,0,0,1,0,0)
failed. ERR=Field 'FirstWritten' doesn't have a default value
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
