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

[John Ralls]

Check your MySQL logs and see if it’s raising error 1007 (database exists) after the second CREATE DATABASE query. There might be a timing issue where MySQL is still cleaning up after the DROP DATABASE when the second create query arrives. If so it might be evident from the MySQL logs.

Regards,
John Ralls


> On Oct 12, 2018, at 7:45 AM, Colin Law <clanlaw at gmail.com> wrote:
> 
> 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
>>