gda crash in load_owner() with PostgreSQL backend
Mark Johnson
mrj001 at shaw.ca
Thu Feb 14 20:04:42 EST 2008
Graham Menhennitt wrote:
> Mark Johnson wrote:
>
>> Graham Menhennitt wrote:
>>
>>> Phil Longstaff wrote:
>>>
>>>
>>>> Graham Menhennitt wrote:
>>>>
>>>>
>>>>> saved. I then try to load from the DB using a command line
>>>>> parameter of
>>>>> the DSN. It runs for a few seconds and then crashes with a
>>>>> segmentation
>>>>> violation.
>>>>>
>>>> I just committed rev 16942 which should fix this. I don't use the
>>>> business objects, so please exercise them.
>>>>
>>> Yes, that fixed it, thanks. I still get a message when it starts saying
>>> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
>>> "billterms_pkey" for table "billterms"
>>> but my data seems to load correctly. Note that I don't actually have any
>>> billing terms in my data.
>>>
>>> I'll do some more testing.
>>>
>>> Thanks,
>>> Graham
>>>
>>>
>>>
>> The notice is normal PostgreSQL output. It means that when you create
>> a primary key, it implicitly creates an index. I expect that the
>> purpose of the message is to inform the user of the name of that index
>> object, as the existence of the index to support the primary key is
>> necessary.
>>
>>
> Agreed. But why does it happen on re-opening the database? Why wasn't it
> created when the database was originally created? Actually, looking back
> through my xterm output, it's been "created" twice - once when the
> original database was created and once when it was re-opened...
>
>
> $ gnucash finance
>
>
> This is a development version. It may or may not work.
> Report bugs and other problems to gnucash-devel at gnucash.org.
> You can also lookup and file bug reports at http://bugzilla.gnome.org
> The last stable version was GnuCash 2.2.2
> The next stable version will be GnuCash 2.4
>
> Found Finance::Quote version 1.13
> Error: xaccOpenLog(): cannot open journal
> 2 No such file or directory
> Implementation missing: database_constraints_update_list() in
> gda-dict-database.c line 1214
> Implementation missing: database_constraints_update_list() in
> gda-dict-database.c line 1214
> Implementation missing: database_constraints_update_list() in
> gda-dict-database.c line 1214
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "customers_pkey" for table "customers"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "jobs_pkey" for table "jobs"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "transactions_pkey" for table "transactions"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "splits_pkey" for table "splits"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "lots_pkey" for table "lots"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "budgets_pkey" for table "budgets"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "taxtables_pkey" for table "taxtables"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "taxtable_entries_pkey" for table "taxtable_entries"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "recurrences_pkey" for table "recurrences"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "employees_pkey" for table "employees"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "orders_pkey" for table "orders"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "commodities_pkey" for table "commodities"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "accounts_pkey" for table "accounts"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "slots_pkey" for table "slots"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "schedxactions_pkey" for table "schedxactions"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "invoices_pkey" for table "invoices"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "prices_pkey" for table "prices"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "entries_pkey" for table "entries"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "vendors_pkey" for table "vendors"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "books_pkey" for table "books"
> Implementation missing: database_constraints_update_list() in
> gda-dict-database.c line 1214
> Implementation missing: database_constraints_update_list() in
> gda-dict-database.c line 1214
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "customers_pkey" for table "customers"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "jobs_pkey" for table "jobs"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "transactions_pkey" for table "transactions"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "splits_pkey" for table "splits"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "lots_pkey" for table "lots"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "budgets_pkey" for table "budgets"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "taxtables_pkey" for table "taxtables"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "taxtable_entries_pkey" for table "taxtable_entries"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "recurrences_pkey" for table "recurrences"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "employees_pkey" for table "employees"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "orders_pkey" for table "orders"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "commodities_pkey" for table "commodities"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "accounts_pkey" for table "accounts"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "slots_pkey" for table "slots"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "schedxactions_pkey" for table "schedxactions"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "billterms_pkey" for table "billterms"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "invoices_pkey" for table "invoices"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "prices_pkey" for table "prices"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "entries_pkey" for table "entries"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "vendors_pkey" for table "vendors"
> Implementation missing: database_constraints_update_list() in
> gda-dict-database.c line 1214
> Implementation missing: database_constraints_update_list() in
> gda-dict-database.c line 1214
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "customers_pkey" for table "customers"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "jobs_pkey" for table "jobs"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "transactions_pkey" for table "transactions"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "splits_pkey" for table "splits"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "lots_pkey" for table "lots"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "budgets_pkey" for table "budgets"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "taxtables_pkey" for table "taxtables"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "taxtable_entries_pkey" for table "taxtable_entries"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "recurrences_pkey" for table "recurrences"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "employees_pkey" for table "employees"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "orders_pkey" for table "orders"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "commodities_pkey" for table "commodities"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "accounts_pkey" for table "accounts"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "slots_pkey" for table "slots"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "schedxactions_pkey" for table "schedxactions"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "invoices_pkey" for table "invoices"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "prices_pkey" for table "prices"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "entries_pkey" for table "entries"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "vendors_pkey" for table "vendors"
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "books_pkey" for table "books"
> Implementation missing: database_constraints_update_list() in
> gda-dict-database.c line 1214
> $ gnucash gda://@ggg
>
>
> This is a development version. It may or may not work.
> Report bugs and other problems to gnucash-devel at gnucash.org.
> You can also lookup and file bug reports at http://bugzilla.gnome.org
> The last stable version was GnuCash 2.2.2
> The next stable version will be GnuCash 2.4
>
> Found Finance::Quote version 1.13
> Implementation missing: database_constraints_update_list() in
> gda-dict-database.c line 1214
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "billterms_pkey" for table "billterms"
> Implementation missing: database_constraints_update_list() in
> gda-dict-database.c line 1214
>
>
>
The above should have gone to the list as well.
Phil, it seems to be creating billterms on the second run each time.
I've seen this too, but I had thought when I saw this that it had
something to do with my using a new SVN of gnucash. I guess that was wrong.
Also, it looks like you get two notices for each table. Did you do the
"Database connection" twice? Either way it's a problem. If you did
save to the DB twice, gnucash-gda should have detected that there was
already data there and refused to wipe it. (Already noted in another
post.) If you didn't save twice, then gnucash-gda is doing something
redundant.
Mark
More information about the gnucash-devel
mailing list