[GNC] Saving over mysql file

peterb peterb at gmail.com
Wed Jan 6 14:25:56 EST 2021


Due to an error, I'm trying to re-save over my mysql database from an older
backup. The save appears to work trivially - it asks me if I want to
overwrite the database, I say yes, and then I see this:

[image: Screen Shot 2021-01-06 at 2.20.25 PM.png]

Clicking save dismisses the dialogue, but it reappears shortly thereafter.

In the trace file I see:
* 14:23:44  WARN <gnc.backend.dbi>
[GncDbiBackend<DbType::DBI_MYSQL>::session_begin()] Database already
exists, Might clobber it.
* 14:23:47 ERROR <gnc.backend.dbi> [drop_database()] Failed to switch out
of `gnucash`, drop will fail.
* 14:23:47  WARN <gnc.gui> [gnc_keyring_set_password()] OS X keychain
error: The specified item already exists in the keychain.
* 14:23:47  WARN <gnc.gui> [gnc_keyring_set_password()] The user will be
prompted for a password again next time.
* 14:23:47 ERROR <gnc.engine> gboolean qof_book_is_readonly(const QofBook
*): assertion 'book != NULL' failed
* 14:23:47 ERROR <gnc.engine> gboolean qof_book_is_readonly(const QofBook
*): assertion 'book != NULL' failed
* 14:23:47 ERROR <gnc.engine> gboolean qof_book_is_readonly(const QofBook
*): assertion 'book != NULL' failed
* 14:23:47 ERROR <gnc.engine> gboolean qof_book_is_readonly(const QofBook
*): assertion 'book != NULL' failed
* 14:23:47 ERROR <gnc.engine> gboolean qof_book_is_readonly(const QofBook
*): assertion 'book != NULL' failed
* 14:23:47 ERROR <gnc.engine> gboolean qof_book_is_readonly(const QofBook
*): assertion 'book != NULL' failed
* 14:23:47 ERROR <gnc.backend.sql> virtual void GncSqlBackend::sync(QofBook
*): assertion 'm_conn != nullptr' failed

What's the right way to recover from this?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2021-01-06 at 2.20.25 PM.png
Type: image/png
Size: 193680 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210106/7d027de3/attachment-0001.png>


More information about the gnucash-user mailing list