On 20/07/2020 23:00, Phil Stracchino wrote:
On 2020-07-20 06:39, Martin Simmons wrote:
On Sat, 18 Jul 2020 10:20:25 -0400, Phil Stracchino said:
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.
Try applying that change at sql_cmds.c:94 and it ought to go away. I
don't know whether sqlite supports IF EXISTS, but isn't sqlite support
deprecated anyway?
Well, PostgreSQL has the "IF EXISTS" option for "DROP TABLE":
<https://www.postgresql.org/docs/11/sql-droptable.html>
Shows:
DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
Might just apply it here - oops, too late! It's after 0:01, away the
backups go!! Tomorrow :-)
Cheers,
Gary B-)
_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel
