[GNC] V3 cannot save on top of existing mysql database

Colin Law clanlaw at gmail.com
Thu Jul 5 04:12:56 EDT 2018


Are the powers-that-be aware of an apparent bug that prevents File > Save
As > Mysql over an existing database?

The trace file shows

* 09:04:54  WARN <gnc.backend.dbi> [GncDbiBackend<Type>::session_begin()]
Databse already exists, Might clobber it.
* 09:05:00  CRIT <gnc.backend.dbi> [error_handler()] DBI error: 1050: Table
'versions' already exists
* 09:05:00  CRIT <gnc.backend.dbi> [GncDbiSqlConnection::create_table()]
Error in dbi_result_free() result
* 09:05:00  CRIT <gnc.backend.dbi> [error_handler()] DBI error: 1062:
Duplicate entry 'Gnucash' for key 'PRIMARY'
* 09:05:00  CRIT <gnc.backend.dbi>
[GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
INSERT INTO versions VALUES('Gnucash',3000002)
* 09:05:00  CRIT <gnc.backend.sql>
[GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
versions VALUES('Gnucash',3000002)
* 09:05:00  CRIT <gnc.backend.sql> [GncSqlBackend::set_table_version()] SQL
error: INSERT INTO versions VALUES('Gnucash',3000002)
* 09:05:00  CRIT <gnc.backend.dbi> [error_handler()] DBI error: 1062:
Duplicate entry 'Gnucash-Resave' for key 'PRIMARY'
* 09:05:00  CRIT <gnc.backend.dbi>
[GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
INSERT INTO versions VALUES('Gnucash-Resave',19920)
* 09:05:00  CRIT <gnc.backend.sql>
[GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
versions VALUES('Gnucash-Resave',19920)
* 09:05:00  CRIT <gnc.backend.sql> [GncSqlBackend::set_table_version()] SQL
error: INSERT INTO versions VALUES('Gnucash-Resave',19920)
* 09:05:00  CRIT <gnc.backend.dbi> [error_handler()] DBI error: 1050: Table
'books' already exists
* 09:05:00  CRIT <gnc.backend.dbi> [GncDbiSqlConnection::create_table()]
Error in dbi_result_free() result
.......

To replicate open an XML file, do File > Save As a new mysql db, revert to
the XML one again, and Save As Mysql again with the same db name.

This is v3.2 build from tarball on Ubuntu 18.04.  Mysql 5.7.22.

Colin


More information about the gnucash-user mailing list