Re: [Bacula-devel] Director 9.6.7 died on a duplicate Path entry

2020-12-18 Thread Eric Bollengier via Bacula-devel
Hello Phil, On 12/17/20 11:21 PM, Phil Stracchino wrote: 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/

Re: [Bacula-devel] Director 9.6.7 died on a duplicate Path entry

2020-12-18 Thread Phil Stracchino
On 12/18/20 8:02 AM, Eric Bollengier via Bacula-devel wrote: > Hello Phil, > > On 12/17/20 11:21 PM, Phil Stracchino wrote: >> >> 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/lin

Re: [Bacula-devel] Director 9.6.7 died on a duplicate Path entry

2020-12-18 Thread Eric Bollengier via Bacula-devel
Hello Phil, On 2020-12-18 15:38, Phil Stracchino wrote: > On 12/18/20 8:02 AM, Eric Bollengier via Bacula-devel wrote: >> >> This is a strange error, it would mean that you don't use the Batch >> insert mode >> >> in your job, because we don't insert Path records one by one (Maybe in bscan >> >>

Re: [Bacula-devel] Director 9.6.7 died on a duplicate Path entry

2020-12-18 Thread Phil Stracchino
On 12/18/20 10:50 AM, Eric Bollengier via Bacula-devel wrote: > Hello Phil, > > I would recommend to test again, the batch mode is doing the insert of > the File records 32 by 32 (with MySQL) in the batch table, and for the > Path/File update, it's done with one query each. I hope that the > limit