Unstable - Error when trying to over write sqlite file
Robert Fewell
14ubobit at gmail.com
Sat Oct 28 08:49:28 EDT 2017
Hi,
This cropped up while doing some tests...
Start Gnucash with --nofile, take all default options and when saving use
sqlite3 option and appropriate file name, close Gnucash.
Start Gnucash again with --nofile, again take all default options and when
saving use sqlite3 again with the same file name, dialogue appears asking
if you want to overwrite, say yes and then this dialogue appears..
"The server URL at /root/unstable-sql3-1.gnucash experienced an error or
encountered bad or corrupt data", close
In the trace file entries like these are present...
* 13:30:11 CRIT <gnc.engine.sx> gnc_sx_get_sxes_referencing_account:
assertion 'sxactions != NULL' failed
* 13:30:21 WARN <gnc.backend.dbi> [GncDbiBackend<Type>::session_begin()]
Might clobber, no force
* 13:30:24 CRIT <gnc.backend.dbi> [error_handler()] DBI error: 1: table
versions already exists
* 13:30:24 CRIT <gnc.backend.dbi> [GncDbiSqlConnection::create_table()]
Error in dbi_result_free() result
* 13:30:24 CRIT <gnc.backend.dbi> [error_handler()] DBI error: 19: UNIQUE
constraint failed: versions.table_name
* 13:30:24 CRIT <gnc.backend.dbi>
[GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
INSERT INTO versions VALUES('Gnucash',2070000)
* 13:30:24 CRIT <gnc.backend.sql>
[GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
versions VALUES('Gnucash',2070000)
* 13:30:24 CRIT <gnc.backend.sql> [GncSqlBackend::set_table_version()] SQL
error: INSERT INTO versions VALUES('Gnucash',2070000)
* 13:30:24 CRIT <gnc.backend.dbi> [error_handler()] DBI error: 19: UNIQUE
constraint failed: versions.table_name
* 13:30:24 CRIT <gnc.backend.dbi>
[GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
INSERT INTO versions VALUES('Gnucash-Resave',19920)
Should I raise a bug for this ?
Bob
More information about the gnucash-devel
mailing list