[GNC] sqlite error from gnucash 2.6.19

[John Ralls]

> On Apr 27, 2019, at 10:00 AM, Jeff Abrahamson <jeff at p27.eu> wrote:
> 
> I opened a gnucash file (sqlite, gnucash v2.6.19, built from version
> c1b5e6c8d+) and saw a stream of errors in /tmp/gnucash.trace
> 
>    * 18:36:09  CRIT <gnc.engine> xaccAccountGetName: assertion
>    'GNC_IS_ACCOUNT(acc)' failed
> 
> I presume this means some bit of corruption in the sqlite file, but
> googling isn't helping me know what to do about it.  Something gnucash
> specific?  Use sqlite tools directly?  Other?
> 

Don't leap to conclusions. First run GnuCash with the --debug option. That will provide a great deal more information that should help resolve where the error is coming from.

If it does prove to be a database problem next run gnucash with --log gnc.backend.dbi=debug which will print out all of the SQL queries. If it's really corrupt data then the errors will be interleaved with the queries. That should provide you enough information to query the database with the sqlite3 command-line tool and figure out exactly what's wrong.

Regards,
John Ralls