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 <[email protected]> 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: [email protected] https://bugzilla.gnome.org/show_bug.cgi?id=609581 GnuCash | SQL Backend | 2.3.8 --- Comment #3 from Phil Longstaff <[email protected]> 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. _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
