After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 796117 - Connecting 3.1 to an existing mysql db drops all data
Connecting 3.1 to an existing mysql db drops all data
Status: RESOLVED OBSOLETE
Product: GnuCash
Classification: Other
Component: Backend - SQL
3.1
Other Linux
: Normal major
: future
Assigned To: gnucash-core-maint
gnucash-core-maint
Depends on:
Blocks:
 
 
Reported: 2018-05-14 21:18 UTC by bondpp7_2
Modified: 2018-06-30 00:10 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description bondpp7_2 2018-05-14 21:18:29 UTC 
When running with "--debug", the only output is:

Gtk-Message: 17:14:35.419: GtkDialog mapped without a transient parent. This is discouraged.


However, I see all my data has been removed from every table (other than accounts_back), while the tables themselves are still present.  Fortunately, my database was backed up.
Comment 1 John Ralls 2018-05-27 01:05:14 UTC 
What version of GnuCash before 3.1 did you last use to open the DB?
If you're willing, please try again, this time with --log gnc.backend.dbi=debug. That will record all of the sql queries and may point to where in the process it failed.
Comment 2 John Ralls 2018-05-29 17:11:11 UTC 
I just managed to reproduce this by creating an accounts_back table. It looks like the failed-backup-recovery code is a bit too aggressive.

You can probably work around the problem by removing any %_back tables after restoring your backup. Please let me know if that solves the problem.
Comment 3 John Ralls 2018-06-02 23:35:37 UTC 
I've fixed the problem of clearing all tables if any backup tables are found, that will be in 3.2. If you can confirm that was the problem we can close this.
Comment 4 John Ralls 2018-06-30 00:10:10 UTC 
GnuCash bug tracking has moved to a new Bugzilla host. The new URL for this bug is https://bugs.gnucash.org/show_bug.cgi?id=796117. Please continue processing the bug there and please update any external references or bookmarks.