[GNC] Saving over mysql file

[peterb]

I went ahead and deleted the DB and recreated it.  ¯\_(ツ)_/¯

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

>
> 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/57fb2848/attachment-0001.png>