Re: Possible unrelated issue

>>>>> 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