GNOME Bugzilla – Bug 782868
SAVEPOINT support breaks saving to sqlite on Windows fails
Last modified: 2018-06-29 23:56:56 UTC
This was pointed out by a user Jannick in testing the fix for bug 781634. As of gnucash 2.6.16 saving to sqlite on Windows fails with the error: "The server at URL xyz experienced an error or encountered bad or corrupt data. The tracefile at that point has some more information: * 16:43:32 CRIT <GLib> g_utf8_to_utf16: assertion 'str != NULL' failed * 16:43:34 CRIT <gnc.backend.dbi> [sqlite3_error_fn()] DBI error: 1: near "SAVEPOINT": syntax error * 16:43:34 CRIT <gnc.backend.dbi> [gnc_dbi_transaction_begin()] BEGIN transaction failed() * 16:43:34 CRIT <gnc.backend.dbi> gnc_dbi_transaction_rollback: assertion 'sql_savepoint > 0' failed * 16:43:34 CRIT <gnc.backend.dbi> gnc_dbi_transaction_rollback: assertion 'sql_savepoint > 0' failed SAVEPOINT support in Gnucash was added in commit https://github.com/Gnucash/gnucash/commit/979e6397c15290550231d3 However SAVEPOINT support was only added to sqlite in version 3.7.7 where we ship gnucash with version 3.6.1. Current sqlite version is 3.18
We have upgraded sqlite on Windows to 3.18, which seems to fix the issue. This fix will go into the next gnucash release (2.6.17). For those who like to try it already now, any nightly build after May 19 should work. http://code.gnucash.org/builds/win32/maint/
On Win10 saving to sqlite3 works fine with the May 22, 2017 nightly build (http://code.gnucash.org/builds/win32/maint/gnucash-2.6.16-2017-05-22-git-e43e30d+-setup.exe). Thanks!
*** Bug 784335 has been marked as a duplicate of this bug. ***
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=782868. Please update any external references or bookmarks.