>>>>> On Thu, 18 Jun 2020 11:58:23 -0400, Phil Stracchino said: > > Got a different error today ... in addition to hung jobs, one job failed. > > 18-Jun 04:30 minbar-dir JobId 25001: Fatal error: sql_create.c:968 > Create db File > +record INSERT INTO File > (FileIndex,JobId,PathId,FilenameId,LStat,MD5,DeltaSeq) > +VALUES (5,25001,97893,109,'R0AAQAJ E EHt J A A -B J IA D Be6dSR BZdRfz > BZdRfz A A > +C','0',0) failed. ERR=Duplicate entry '908202766' for key > 'PRIMARY'18-Jun 04:30 > +minbar-dir JobId 25001: Fatal error: catreq.c:513 Attribute create error: > +ERR=sql_create.c:968 Create db File record INSERT INTO File > +(FileIndex,JobId,PathId,FilenameId,LStat,MD5,DeltaSeq) VALUES > +(5,25001,97893,109,'R0AAQAJ E EHt J A A -B J IA D Be6dSR BZdRfz BZdRfz A A > +C','0',0) failed. ERR=Duplicate entry '908202766' for key > 'PRIMARY'18-Jun 04:30 > +asgard-fd JobId 25001: Error: bsock.c:383 Write error sending 76 bytes > to Storage > > > That duplicate PRIMARY key shouldn't be able to happen.
The insert command is not even setting the PRIMARY key (FileId), so that suggests a bug in MariaDB or the table is corrupted. __Martin _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
