Re: Hung jobs: continued diagnosis
Phil Stracchino <[email protected]>
| Newsgroups | gmane.comp.sysutils.backup.bacula.devel |
|---|---|
| Organization | Babylon Communications |
| Message-ID | <[email protected]> |
On 2020-07-14 11:30, Martin Simmons wrote: > Sorry if you've already mentioned it, but is the 9.6.3 Director the same old > binary as you used in the past? Or have you recompiled it recently? If it is > the old binary, maybe something else has changed that affects compilation, so > you could try recompiling 9.6.3 to check that still works. Recompiled at each upgrade/downgrade. >> It seems likely, based upon my understanding of MySQL and of Galera >> clusters, that the underlying root cause of the problem may be a race >> condition between threads attempting to create two rows with the same id. > > Yes, but according to https://mariadb.org/auto-increments-in-galera/ this is > not supposed to happen in Galera. At which I sheepishly notice that I have wsrep_auto_increment_control OFF when I'd have sworn it was on. Which doesn't change the fact that it works that way with 9.6.3. Nevertheless, I'll retest 9.6.5 with that change just to be certain. If this solves the problem, it's an easy requirement. -- Phil Stracchino Babylon Communications [email protected] [email protected] Landline: +1.603.293.8485 Mobile: +1.603.998.6958