Hello, On Mon, 2014-10-20 at 11:57 +0100, Martin Simmons wrote: > > > > it seems i have to dump spooled attrs files tomorrow and compare to > > database to see at which attrs have been inserted and at which one it > > stops. > > I think that will be difficult, because the insert is a join of various other > temporary tables so the order may be random. > > > > has anyone a better idea how to debug this problem? > > i am little bit lost :) because in the last 6 years since > > i am using bacula i never run into a problem like this. > > Maybe you can attach strace or gdb to the mysql process running this insert > statement to see what it is doing? It doesn't look like a Bacula problem, but > it might be a bug in mysql. >
will try this tomorrow, today i was not a office. but now i noticed the failed jobs are missing exactly one file. for whatever reason the batch insert stops before the last file. mysql> select count(*) from File where JobId = '636019'; +----------+ | count(*) | +----------+ | 616859 | +----------+ 1 row in set (0.00 sec) mysql> select JobFiles from Job where JobId = '636019'; +----------+ | JobFiles | +----------+ | 616860 | +----------+ 1 row in set (0.00 sec) best regards ulrich ------------------------------------------------------------------------------ Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://p.sf.net/sfu/Zoho _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
