Possible unrelated issue
Phil Stracchino <[email protected]>
| Newsgroups | gmane.comp.sysutils.backup.bacula.devel |
|---|---|
| Organization | Babylon Communications |
| Message-ID | <[email protected]> |
2020-07-18 4:31:00 12 [ERROR] Slave SQL: Error 'Unknown table 'bacula.DelCandidates'' on query. Default database: 'bacula'. Query: 'DROP TABLE DelCandidates', Internal MariaDB error code: 1051 2020-07-18 4:31:00 12 [Warning] WSREP: Ignoring error 'Unknown table 'bacula.DelCandidates'' on query. Default database: 'bacula'. Query: 'DROP TABLE DelCandidates', Error_code: 1051 2020-07-18 4:31:03 0 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000072 of size 134217728 bytes 2020-07-18 4:31:03 0 [Note] WSREP: Deleted page /var/lib/mysql/gcache.page.000071 2020-07-18 4:32:59 15 [ERROR] Slave SQL: Error 'Unknown table 'bacula.DelCandidates'' on query. Default database: 'bacula'. Query: 'DROP TABLE DelCandidates', Internal MariaDB error code: 1051 2020-07-18 4:32:59 15 [Warning] WSREP: Ignoring error 'Unknown table 'bacula.DelCandidates'' on query. Default database: 'bacula'. Query: 'DROP TABLE DelCandidates', Error_code: 1051 2020-07-18 4:33:44 12 [ERROR] Slave SQL: Error 'Unknown table 'bacula.DelCandidates'' on query. Default database: 'bacula'. Query: 'DROP TABLE DelCandidates', Internal MariaDB error code: 1051 2020-07-18 4:33:44 12 [Warning] WSREP: Ignoring error 'Unknown table 'bacula.DelCandidates'' on query. Default database: 'bacula'. Query: 'DROP TABLE DelCandidates', Error_code: 1051 Just found this this morning. Seems like an awful lot of failed DROPS. I haven't read far enough through the code yet to see why Bacula is so many times trying to drop a table that doesn't exist, but it could be avoided by simply changing DROP TABLE DelCandidates to DROP TABLE IF EXISTS DelCandidates at sql_cmds.c:94. -- Phil Stracchino Babylon Communications [email protected] [email protected] Landline: +1.603.293.8485 Mobile: +1.603.998.6958