Hi, I'm suffering from exactly the same problem: After updating from 16.2 to 17.4.2 the step "Sending Accurate information" takes now hours instead seconds with 16.2, also "Sending spooled attrs to the Director." The Query in question is as posted from jsfrerot.
My System ist Ubuntu 16.04 with MariaDB 10.0. The File-Table is 21 GB large. > Please check if the indexes on the File table match the ones defined in > /usr/lib/bareos/scripts/ddl/creates/mysql.sql > > May be do > ANALYZE TABLE File; > in mysql again. The indexes are correct, no changes after ANALYZE and OPTIMIZE. But I noticed something odd: The incremental backup directly after the update was as fast as with 16.2, also the differential backup following on the next day. Starting with the next incremental backups the jobs took ages. Here the backup state for an exemplary host: Bareos 16.2 (very fast 'accurate') - Full Backup - 5x Incremental - Differential - 6x Incremental - Differential - 5x Incremental Update to Bareos 17.2 - Incremental (still very fast) - Differential (still very fast) - Incremental (slow) - Full (fast) - Incremental (fast) - Incremental (slow) I hope this helps to narrow down the error. Is there anything more I could try? Kind regards Markus -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to bareos-users+unsubscr...@googlegroups.com. To post to this group, send email to bareos-users@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
