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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users