Fwd: [Bug 609581] Gnucash 2.3.8 offers to create db and then fails to do so

[Donald Allen]

I am trying to add a comment with attachments to this bug and I'm
getting errors from the gnome server. So I'll tell you what I've found
here and will update the bug database when things start working again
on their end.

Here's the tail of the postgresql.log:

LOG:  database system is shut down
LOG:  database system was shut down at 2010-03-13 22:40:45 EST
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started
FATAL:  database "gnucash" does not exist
FATAL:  database "gnucash" does not exist
FATAL:  database "gnucash" does not exist
ERROR:  new encoding (UTF8) is incompatible with the encoding of the
template database (SQL_ASCII)
HINT:  Use the same encoding as in the template database, or use
template0 as template.
STATEMENT:  CREATE DATABASE gnucash WITH ENCODING 'UTF8'

Here's the relevant part of the gnucash.trace file:

* 10:04:44  CRIT <gnc.core-utils> gnc_uri_create_uri: assertion `path
!= 0' failed
* 10:04:45 DEBUG <gnc.backend.dbi> [enter
gnc-backend-dbi.c:gnc_dbi_postgres_session_begin()]
* 10:04:45  INFO <gnc.backend.dbi>     [pgsql_error_fn] DBI error:
FATAL:  database "gnucash" does not exist

* 10:04:45  CRIT <gnc.backend.dbi>     gnc_dbi_set_error: assertion
`dbi_conn != NULL' failed
* 10:04:45 DEBUG <gnc.backend.dbi> [leave gnc_dbi_postgres_session_begin()]
* 10:04:56 DEBUG <gnc.backend.dbi> [enter
gnc-backend-dbi.c:gnc_dbi_session_end()]
* 10:04:56 DEBUG <gnc.backend.dbi> [leave gnc_dbi_session_end()]
* 10:05:09  INFO <gnc.backend.dbi> [gnc_dbi_check_sqlite3_file]
exists, does not have SQLite format string -> not DBI
* 10:05:15  WARN <gnc.backend.xml> Invalid timestamp in data file.
Look for a 'trn:date-posted' entry with a date of 1969-12-31 or
1970-01-01.
* 10:05:16  CRIT <gnc.core-utils> gnc_uri_create_uri: assertion `path
!= 0' failed
* 10:05:40 DEBUG <gnc.backend.dbi> [enter
gnc-backend-dbi.c:gnc_dbi_postgres_session_begin()]
* 10:05:40  INFO <gnc.backend.dbi>     [pgsql_error_fn] DBI error:
FATAL:  database "gnucash" does not exist

* 10:05:40  CRIT <gnc.backend.dbi>     gnc_dbi_set_error: assertion
`dbi_conn != NULL' failed
* 10:05:40 DEBUG <gnc.backend.dbi> [leave gnc_dbi_postgres_session_begin()]
* 10:05:45 DEBUG <gnc.backend.dbi> [enter
gnc-backend-dbi.c:gnc_dbi_postgres_session_begin()]
* 10:05:45  INFO <gnc.backend.dbi>     [pgsql_error_fn] DBI error:
FATAL:  database "gnucash" does not exist

* 10:05:45  CRIT <gnc.backend.dbi>     gnc_dbi_set_error: assertion
`dbi_conn != NULL' failed
* 10:05:45  CRIT <gnc.backend.dbi>     [pgsql_error_fn()] DBI error:
ERROR:  new encoding (UTF8) is incompatible with the encoding of the
template database (SQL_ASCII)
HINT:  Use the same encoding as in the template database, or use
template0 as template.

* 10:05:45  CRIT <gnc.backend.dbi>     gnc_dbi_set_error: assertion
`dbi_conn != NULL' failed
* 10:05:45  CRIT <gnc.backend.dbi>
[gnc_dbi_postgres_session_begin()] Unable to create database 'gnucash'
* 10:05:45 DEBUG <gnc.backend.dbi> [leave gnc_dbi_postgres_session_begin()]
* 10:08:14 DEBUG <gnc.backend.dbi> [enter
gnc-backend-dbi.c:gnc_dbi_session_end()]
* 10:08:14 DEBUG <gnc.backend.dbi> [leave gnc_dbi_session_end()]

So it looks like a character-encoding mismatch.

Hope this helps.

/Don



---------- Forwarded message ----------
From: GnuCash <bugzilla at gnome.org>
Date: Sun, Mar 7, 2010 at 2:54 PM
Subject: [Bug 609581] Gnucash 2.3.8 offers to create db and then fails to do so
To: donaldcallen at gmail.com


https://bugzilla.gnome.org/show_bug.cgi?id=609581
 GnuCash | SQL Backend | 2.3.8

--- Comment #3 from Phil Longstaff <plongstaff at rogers.com> 2010-03-07
18:54:12 UTC ---
Does the gnucash.trace file and/or postgres server log have more information?

--
Configure bugmail: https://bugzilla.gnome.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You reported the bug.