Hello,
I've noticed GnuCash tries to re-create database objects over and
over. The attached log is what obtained running gnucash a second time
(defaulting to open a postgresql url). Is this behavior expected?
Running today's trunk.
-- Daniele
* 13:49:56 DEBUG <gnc.backend.dbi> [enter gnc-backend-dbi.c:gnc_dbi_postgres_session_begin()]
* 13:49:56 DEBUG <gnc.backend.dbi> [leave gnc_dbi_postgres_session_begin()]
* 13:49:56 DEBUG <gnc.backend.dbi> [enter gnc-backend-dbi.c:gnc_dbi_load()] be=0x27e9510, book=0x20b6540
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE versions (table_name varchar(50) PRIMARY KEY NOT NULL, table_version integer NOT NULL)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "versions" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE transactions (guid varchar(32) PRIMARY KEY NOT NULL, currency_guid varchar(32) NOT NULL, num varchar(2048) NOT NULL, post_date timestamp without time zone, enter_date timestamp without time zone, description varchar(2048))
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "transactions" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('transactions',3)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('transactions',3)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('transactions',3)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_index] SQL: CREATE INDEX tx_post_date_index ON transactions (post_date)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "tx_post_date_index" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_index()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE splits (guid varchar(32) PRIMARY KEY NOT NULL, tx_guid varchar(32) NOT NULL, account_guid varchar(32) NOT NULL, memo varchar(2048) NOT NULL, action varchar(2048) NOT NULL, reconcile_state varchar(1) NOT NULL, reconcile_date timestamp without time zone, value_num int8 NOT NULL, value_denom int8 NOT NULL, quantity_num int8 NOT NULL, quantity_denom int8 NOT NULL, lot_guid varchar(32))
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "splits" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('splits',4)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('splits',4)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('splits',4)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_index] SQL: CREATE INDEX splits_tx_guid_index ON splits (tx_guid)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "splits_tx_guid_index" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_index()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_index] SQL: CREATE INDEX splits_account_guid_index ON splits (account_guid)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "splits_account_guid_index" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_index()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE lots (guid varchar(32) PRIMARY KEY NOT NULL, account_guid varchar(32), is_closed integer NOT NULL)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "lots" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('lots',2)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('lots',2)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('lots',2)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE customers (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(2048) NOT NULL, id varchar(2048) NOT NULL, notes varchar(2048) NOT NULL, active integer NOT NULL, discount_num int8 NOT NULL, discount_denom int8 NOT NULL, credit_num int8 NOT NULL, credit_denom int8 NOT NULL, currency varchar(32) NOT NULL, tax_override integer NOT NULL, addr_name varchar(1024), addr_addr1 varchar(1024), addr_addr2 varchar(1024), addr_addr3 varchar(1024), addr_addr4 varchar(1024), addr_phone varchar(128), addr_fax varchar(128), addr_email varchar(256), shipaddr_name varchar(1024), shipaddr_addr1 varchar(1024), shipaddr_addr2 varchar(1024), shipaddr_addr3 varchar(1024), shipaddr_addr4 varchar(1024), shipaddr_phone varchar(128), shipaddr_fax varchar(128), shipaddr_email varchar(256), terms varchar(32), tax_included integer, taxtable varchar(32))
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "customers" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('customers',2)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('customers',2)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('customers',2)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE jobs (guid varchar(32) PRIMARY KEY NOT NULL, id varchar(2048) NOT NULL, name varchar(2048) NOT NULL, reference varchar(2048) NOT NULL, active integer NOT NULL, owner_type integer, owner_guid varchar(32))
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "jobs" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('jobs',1)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('jobs',1)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('jobs',1)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE budgets (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(2048) NOT NULL, description varchar(2048), num_periods integer NOT NULL)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "budgets" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('budgets',1)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('budgets',1)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('budgets',1)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE budget_amounts (id serial PRIMARY KEY NOT NULL, budget_guid varchar(32) NOT NULL, account_guid varchar(32) NOT NULL, period_num integer NOT NULL, amount_num int8 NOT NULL, amount_denom int8 NOT NULL)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "budget_amounts" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('budget_amounts',1)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('budget_amounts',1)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('budget_amounts',1)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE recurrences (id serial PRIMARY KEY NOT NULL, obj_guid varchar(32) NOT NULL, recurrence_mult integer NOT NULL, recurrence_period_type varchar(2048) NOT NULL, recurrence_period_start date NOT NULL)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "recurrences" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('recurrences',1)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('recurrences',1)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('recurrences',1)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE taxtables (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(50) NOT NULL, refcount int8 NOT NULL, invisible integer NOT NULL, parent varchar(32))
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "taxtables" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('taxtables',2)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('taxtables',2)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('taxtables',2)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE taxtable_entries (id serial PRIMARY KEY NOT NULL, taxtable varchar(32) NOT NULL, account varchar(32) NOT NULL, amount_num int8 NOT NULL, amount_denom int8 NOT NULL, type integer NOT NULL)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "taxtable_entries" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('taxtable_entries',3)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('taxtable_entries',3)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('taxtable_entries',3)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE commodities (guid varchar(32) PRIMARY KEY NOT NULL, namespace varchar(2048) NOT NULL, mnemonic varchar(2048) NOT NULL, fullname varchar(2048), cusip varchar(2048), fraction integer NOT NULL, quote_flag integer NOT NULL, quote_source varchar(2048), quote_tz varchar(2048))
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "commodities" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('commodities',1)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('commodities',1)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('commodities',1)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE accounts (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(2048) NOT NULL, account_type varchar(2048) NOT NULL, commodity_guid varchar(32), commodity_scu integer NOT NULL, non_std_scu integer NOT NULL, parent_guid varchar(32), code varchar(2048), description varchar(2048), hidden integer, placeholder integer)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "accounts" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('accounts',1)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('accounts',1)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('accounts',1)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE slots (id serial PRIMARY KEY NOT NULL, obj_guid varchar(32) NOT NULL, name varchar(4096) NOT NULL, slot_type integer NOT NULL, int64_val int8, string_val varchar(4096), double_val double precision, timespec_val timestamp without time zone, guid_val varchar(32), numeric_val_num int8, numeric_val_denom int8)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "slots" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('slots',2)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('slots',2)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('slots',2)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_index] SQL: CREATE INDEX slots_guid_index ON slots (obj_guid)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "slots_guid_index" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_index()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE employees (guid varchar(32) PRIMARY KEY NOT NULL, username varchar(2048) NOT NULL, id varchar(2048) NOT NULL, language varchar(2048) NOT NULL, acl varchar(2048) NOT NULL, active integer NOT NULL, currency varchar(32) NOT NULL, ccard_guid varchar(32), workday_num int8 NOT NULL, workday_denom int8 NOT NULL, rate_num int8 NOT NULL, rate_denom int8 NOT NULL, addr_name varchar(1024), addr_addr1 varchar(1024), addr_addr2 varchar(1024), addr_addr3 varchar(1024), addr_addr4 varchar(1024), addr_phone varchar(128), addr_fax varchar(128), addr_email varchar(256))
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "employees" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('employees',2)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('employees',2)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('employees',2)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE orders (guid varchar(32) PRIMARY KEY NOT NULL, id varchar(2048) NOT NULL, notes varchar(2048) NOT NULL, reference varchar(2048) NOT NULL, active integer NOT NULL, date_opened timestamp without time zone NOT NULL, date_closed timestamp without time zone NOT NULL, owner_type integer NOT NULL, owner_guid varchar(32) NOT NULL)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "orders" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('orders',1)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('orders',1)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('orders',1)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE schedxactions (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(2048), enabled integer NOT NULL, start_date date, end_date date, last_occur date, num_occur integer NOT NULL, rem_occur integer NOT NULL, auto_create integer NOT NULL, auto_notify integer NOT NULL, adv_creation integer NOT NULL, adv_notify integer NOT NULL, instance_count integer NOT NULL, template_act_guid varchar(32) NOT NULL)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "schedxactions" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('schedxactions',1)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('schedxactions',1)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('schedxactions',1)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE billterms (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(2048) NOT NULL, description varchar(2048) NOT NULL, refcount integer NOT NULL, invisible integer NOT NULL, parent varchar(32), type varchar(2048) NOT NULL, duedays integer, discountdays integer, discount_num int8, discount_denom int8, cutoff integer)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "billterms" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('billterms',2)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('billterms',2)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('billterms',2)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE prices (guid varchar(32) PRIMARY KEY NOT NULL, commodity_guid varchar(32) NOT NULL, currency_guid varchar(32) NOT NULL, date timestamp without time zone NOT NULL, source varchar(2048), type varchar(2048), value_num int8 NOT NULL, value_denom int8 NOT NULL)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "prices" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('prices',2)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('prices',2)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('prices',2)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE invoices (guid varchar(32) PRIMARY KEY NOT NULL, id varchar(2048) NOT NULL, date_opened timestamp without time zone, date_posted timestamp without time zone, notes varchar(2048) NOT NULL, active integer NOT NULL, currency varchar(32) NOT NULL, owner_type integer, owner_guid varchar(32), terms varchar(32), billing_id varchar(2048), post_txn varchar(32), post_lot varchar(32), post_acc varchar(32), billto_type integer, billto_guid varchar(32), charge_amt_num int8, charge_amt_denom int8)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "invoices" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('invoices',3)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('invoices',3)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('invoices',3)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE books (guid varchar(32) PRIMARY KEY NOT NULL, root_account_guid varchar(32) NOT NULL, root_template_guid varchar(32) NOT NULL)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "books" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('books',1)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('books',1)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('books',1)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE entries (guid varchar(32) PRIMARY KEY NOT NULL, date timestamp without time zone NOT NULL, date_entered timestamp without time zone, description varchar(2048), action varchar(2048), notes varchar(2048), quantity_num int8, quantity_denom int8, i_acct varchar(32), i_price_num int8, i_price_denom int8, i_discount_num int8, i_discount_denom int8, invoice varchar(32), i_disc_type varchar(2048), i_disc_how varchar(2048), i_taxable integer, i_taxincluded integer, i_taxtable varchar(32), b_acct varchar(32), b_price_num int8, b_price_denom int8, bill varchar(32), b_taxable integer, b_taxincluded integer, b_taxtable varchar(32), b_paytype integer, billable integer, billto_type integer, billto_guid varchar(32), order_guid varchar(32))
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "entries" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('entries',3)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('entries',3)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('entries',3)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_create_table] SQL: CREATE TABLE vendors (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(2048) NOT NULL, id varchar(2048) NOT NULL, notes varchar(2048) NOT NULL, currency varchar(32) NOT NULL, active integer NOT NULL, tax_override integer NOT NULL, addr_name varchar(1024), addr_addr1 varchar(1024), addr_addr2 varchar(1024), addr_addr3 varchar(1024), addr_addr4 varchar(1024), addr_phone varchar(128), addr_fax varchar(128), addr_email varchar(256), terms varchar(32), tax_inc varchar(2048), tax_table varchar(32))
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: relation "vendors" already exists
* 13:49:56 CRIT <gnc.backend.dbi> [conn_create_table()] Error in dbi_result_free() result
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_nonselect_statement] SQL: INSERT INTO versions VALUES('vendors',1)
* 13:49:56 CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: ERROR: duplicate key value violates unique constraint "versions_pkey"
* 13:49:56 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error executing SQL INSERT INTO versions VALUES('vendors',1)
* 13:49:56 CRIT <gnc.backend.sql> [gnc_sql_set_table_version()] SQL error: INSERT INTO versions VALUES('vendors',1)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM books
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM slots WHERE obj_guid='de55247b2fb2097bd8efe7e9059eb390'
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM commodities
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM commodities)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM accounts
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM accounts)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM lots
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM lots)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM billterms
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM taxtables
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM transactions
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM customers
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM jobs
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM budgets
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM employees
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM orders
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM schedxactions
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM prices
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM prices)
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM invoices
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM entries
* 13:49:56 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] SQL: SELECT * FROM vendors
* 13:49:56 DEBUG <gnc.backend.dbi> [leave gnc_dbi_load()]
* 13:50:00 DEBUG <gnc.backend.dbi> [enter gnc-backend-dbi.c:gnc_dbi_session_end()]
* 13:50:00 DEBUG <gnc.backend.dbi> [leave gnc_dbi_session_end()]
_______________________________________________
gnucash-devel mailing list
[email protected]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
