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