>>>>> On Sat, 18 Jul 2020 10:20:25 -0400, Phil Stracchino said: > > 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.
I get that for every job with PostgreSQL too. __Martin _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
