[GNC] Saving over mysql file

[peterb]

Clicking "save" on subsequent runs repeats the message
* 14:40:28 ERROR <gnc.backend.sql> virtual void GncSqlBackend::sync(QofBook
*): assertion 'm_conn != nullptr' failed
so I don't think it's simply the DB being readonly (I opened and closed the
DB from a second machine to make sure the lock was released).

On Wed, Jan 6, 2021 at 2:25 PM peterb <peterb at gmail.com> wrote:

> 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/90df6c3a/attachment-0001.png>