[GNC] V3.3 on Ubuntu 18.10 can't Save As over existing mysql database

[Colin Law]

I am using MySQL.  When I attempt to Save As over an existing database
I see the database already exists warning then when I tell it to go
ahead I get the generic server encountered error or bad or corrupt
data message.

In gnucash.trace I see
* 15:40:07  WARN <gnc.backend.dbi>
[GncDbiBackend<Type>::session_begin()] Databse already exists, Might
clobber it.
* 15:41:37  CRIT <gnc.backend.dbi>
[GncDbiBackend<Type>::session_begin()] Unable to create database
'gnucash'

If I then look in mysql I see that the database has been dropped, and
if I try to Save As again it creates the database correctly.  So it
appears the drop database is working but then it is unable to create
the new one for some reason after dropping, but is able to create it
if it does not need to drop it.
On Fri, 12 Oct 2018 at 15:29, John Ralls <jralls at ceridwen.us> wrote:
>
>
>
> On Oct 12, 2018, at 6:03 AM, Colin Law <clanlaw at gmail.com> wrote:
>
> I believe that on early 3.x versions that it was not possible to Save
> As on top of an existing database of the same name.  I thought that
> had been fixed in or before 3.3 but I note that it still fails using
> 3.3 from the Ubuntu 18.10 repository.  Also I cannot find a bug
> referring to the problem.
>
> Can someone elucidate?
>
>
> Colin,
>
> The bugs were https://bugs.gnucash.org/show_bug.cgi?id=796724 for MySQL/MariaDB and https://bugs.gnucash.org/show_bug.cgi?id=789594 for SQLite3.
>
> What DB Engine are you using and do you get an error or is it just refusing to drop the existing DB?
>
> Regards,
> John Ralls
>