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 ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
