Director 9.6.7 died on a duplicate Path entry

Phil Stracchino <[email protected]>
Newsgroups gmane.comp.sysutils.backup.bacula.devel
Organization Babylon Communications
Message-ID <[email protected]>

16-Dec 04:39 minbar-dir JobId 28076: Fatal error: sql_create.c:589
Create db Path record INSERT INTO Path (Path) VALUES
('/usr/src/linux-5.10.1-gentoo/include/linux/fsl/') failed.
ERR=Duplicate entry '/usr/src/linux-5.10.1-gentoo/include/linux/fsl/'
for key 'Path'
16-Dec 04:39 minbar-dir JobId 28076: Fatal error: catreq.c:664 attribute
create error. ERR=sql_create.c:589 Create db Path record INSERT INTO
Path (Path) VALUES ('/usr/src/linux-5.10.1-gentoo/include/linux/fsl/')
failed. ERR=Duplicate entry
'/usr/src/linux-5.10.1-gentoo/include/linux/fsl/' for key 'Path'


I'm going to guess maybe a race condition occurred between separate
threads where two jobs happened to try to write the same Path at the
same time.  This is a low-probability failure, but should we consider
doing an INSERT IGNORE or REPLACE INTO here?


-- 
  Phil Stracchino
  Babylon Communications
  [email protected]
  [email protected]
  Landline: +1.603.293.8485
  Mobile:   +1.603.998.6958
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.