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 <clan...@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 <jra...@ceridwen.us> wrote: >> >> >> >> On Oct 12, 2018, at 6:03 AM, Colin Law <clan...@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 >> _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.