Problem storing data in database

angelo-veltens at web.de angelo-veltens at web.de
Sat Oct 15 14:08:26 EDT 2016


Hi, thanks for your response.

When I try to connect to a non-existing database I get the following errors:

* 19:45:39  CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: FATAL:  Datenbank »gnucash_new« existiert nicht

* 19:45:39  CRIT <gnc.backend.dbi> gnc_dbi_set_error: assertion 'dbi_conn != NULL' failed
* 19:45:39  CRIT <gnc.backend.dbi> [gnc_dbi_postgres_session_begin()] Unable to connect to database 'gnucash_new'
* 19:45:40  WARN <gnc.backend.dbi> [gnc_dbi_unlock()] No lock table in database, so not unlocking it.
* 19:45:40  CRIT <gnc.engine.sx> gnc_sx_get_sxes_referencing_account: assertion 'sxactions != NULL' failed

(Datenbank »gnucash_new« existiert nicht == Database "gnucash_new" does not exist.)

The privileges of the gnucash user are:

Role name |                         Attributes                         | Member of 
-----------+------------------------------------------------------------+-----------
 gnucash   | Superuser, Create DB                               | {}

What's wrong, now?

Best regards,
Angelo

-----Original Message-----
From: John Ralls <jralls at ceridwen.us>
To: angelo-veltens at web.de
Cc: gnucash-user at gnucash.org
Sent: Fr., 14 Okt. 2016 23:42
Subject: Re: Problem storing data in database


> On Oct 14, 2016, at 6:36 PM, angelo-veltens at web.de wrote:
> 
> Hello together, 
> 
> I am trying to connect gnucash to a postgres database, but cannot get it running. When trying to save, following error pops up in the GUI: 
> 
> Der Server unter der URL »postgres://gnucash@localhost/gnucash« stiess auf einen Fehler oder benutzte falsche oder fehlerhafte Daten. 
> 
> Connection via JDBC using a database tool works fine! 
> 
> Following errors occur in the gnucash.trace file: 
> 
> * 18:56:22  WARN <gnc.backend.dbi> [gnc_dbi_postgres_session_begin()] Databse already exists, Might clobber it. 
> * 18:56:24  CRIT <gnc.backend.dbi> conn_table_operation: assertion 'table_name_list != NULL' failed 
> * 18:56:24  CRIT <gnc.backend.dbi> conn_table_operation: assertion 'table_name_list != NULL' failed 
> * 18:56:25  WARN <gnc.backend.dbi> [gnc_dbi_unlock()] No lock table in database, so not unlocking it. 
> 
> My setup: 
> - gnucash 2.6.12 on fedora linux 
> - postgresql 9.6 with an empty schema named "gnucash" and a user "gnucash" that has all permissions granted to it 
> - libdbi 0.9.0 
> - libdbi-dbd-pgsql 0.9.0 
> 
> What's happening here? 

Try deleting the gnucash database or pointing GnuCash at a different name. GnuCash needs to create the database itself. Do make sure that the user "gnucash" has privs to create databases.

Regards,
John Ralls




More information about the gnucash-user mailing list