Re: Possible unrelated issue

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