GDA: possible problem
Mark Johnson
mrj001 at shaw.ca
Wed Jan 30 03:44:52 EST 2008
Phil,
I decided to check my postgresql log file for insight into the poor
performance. While doing so, I noticed the following:
ERROR: null value in column "slot_id" violates not-null
constraint
STATEMENT: INSERT INTO slots (obj_guid, name, slot_type, int64_val,
string_val, double_val, times
pec_val, guid_val, numeric_val_num, numeric_val_denom) VALUES
('77889f8da5fb434ae68891da19bef5ad', 'reconcile-info/last-date', 1,
1199170799, NULL, NULL, '1969-12-31', NULL, 0, 1)
ERROR: null value in column "slot_id" violates not-null
constraint
STATEMENT: INSERT INTO slots (obj_guid, name, slot_type, int64_val,
string_val, double_val, times
pec_val, guid_val, numeric_val_num, numeric_val_denom) VALUES
('77889f8da5fb434ae68891da19bef5ad', 'reconcile-info/include-children',
1, 0, NULL, NULL, '1969-12-31', NULL, 0, 1)
ERROR: null value in column "slot_id" violates not-null
constraint
STATEMENT: INSERT INTO slots (obj_guid, name, slot_type, int64_val,
string_val, double_val, times
pec_val, guid_val, numeric_val_num, numeric_val_denom) VALUES
('77889f8da5fb434ae68891da19bef5ad',
'reconcile-info/last-interval/days', 1, 0, NULL, NULL, '1969-12-31',
NULL, 0, 1)
and many many other similar entries. These appear just after the
NOTICEs about creating table primary keys creating implicit indices.
Therefore, these were done by the initial save to the db just after
creating the db schema. I note that my slots table is empty.
Mark
More information about the gnucash-devel
mailing list