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

[Donald Allen]

FYI, the "errors from the gnome server" turned out to be a bug in
Chromium (serves me right for using a browser still in beta): the
gnucash.trace file was not readable by my main account, having been
written from my test account with permissions set to 600. Chromium sat
there spinning until something timed out. When I tried it with Firefox
on a hunch, I got an explicit error message about the permission
problem. Attachments have been uploaded.

/Don

On Sun, Mar 14, 2010 at 10:34 AM, Donald Allen <donaldcallen at gmail.com> wrote:
> 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.
>