[NOTABUG] [7.350] postgresql errors while initializing

Hi

probably normal when doing first initialization but there is some errors for postgresql

2008:11:20-19:41:01 (none) postgres[4315]: [3-1] ERROR:  index "cluster_id_m" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [3-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [3-3] 	

2008:11:20-19:41:01 (none) postgres[4315]: [3-4] 	DROP INDEX public.cluster_id_m;

2008:11:20-19:41:01 (none) postgres[4315]: [4-1] ERROR:  index "message_id_m" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [4-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [4-3] 	DROP INDEX public.message_id_m;

2008:11:20-19:41:01 (none) postgres[4315]: [5-1] ERROR:  index "recipient_m" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [5-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [5-3] 	DROP INDEX public.recipient_m;

2008:11:20-19:41:01 (none) postgres[4315]: [6-1] ERROR:  index "sender_m" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [6-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [6-3] 	DROP INDEX public.sender_m;

2008:11:20-19:41:01 (none) postgres[4315]: [7-1] ERROR:  index "location_m" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [7-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [7-3] 	DROP INDEX public.location_m;

2008:11:20-19:41:01 (none) postgres[4315]: [8-1] ERROR:  index "action_m" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [8-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [8-3] 	DROP INDEX public.action_m;

2008:11:20-19:41:01 (none) postgres[4315]: [9-1] ERROR:  index "received_m" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [9-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [9-3] 	DROP INDEX public.received_m;

2008:11:20-19:41:01 (none) postgres[4315]: [10-1] ERROR:  index "size_m" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [10-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [10-3] 	DROP INDEX public.size_m;

2008:11:20-19:41:01 (none) postgres[4315]: [11-1] ERROR:  index "src_m" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [11-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [11-3] 	DROP INDEX public.src_m;

2008:11:20-19:41:01 (none) postgres[4315]: [12-1] ERROR:  relation "public.m" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [12-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [12-3] 	

2008:11:20-19:41:01 (none) postgres[4315]: [12-4] 	ALTER TABLE ONLY public.m DROP CONSTRAINT primary_m;

2008:11:20-19:41:01 (none) postgres[4315]: [13-1] ERROR:  table "m" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [13-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [13-3] 	DROP TABLE public.m;

2008:11:20-19:41:01 (none) postgres[4315]: [14-1] ERROR:  type "location_m_enum" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [14-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [14-3] 	

2008:11:20-19:41:01 (none) postgres[4315]: [14-4] 	

2008:11:20-19:41:01 (none) postgres[4315]: [14-5] 	DROP TYPE location_m_enum;

2008:11:20-19:41:01 (none) postgres[4315]: [15-1] ERROR:  type "action_m_enum" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [15-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [15-3] 	DROP TYPE action_m_enum;

2008:11:20-19:41:01 (none) postgres[4315]: [16-1] NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "primary_m" for table "m"

2008:11:20-19:41:01 (none) postgres[4315]: [17-1] ERROR:  index "cluster_id_q" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [17-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [17-3] 	

2008:11:20-19:41:01 (none) postgres[4315]: [17-4] 	DROP INDEX public.cluster_id_q;

2008:11:20-19:41:01 (none) postgres[4315]: [18-1] ERROR:  index "message_id_q" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [18-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [18-3] 	DROP INDEX public.message_id_q;

2008:11:20-19:41:01 (none) postgres[4315]: [19-1] ERROR:  index "recipient_q" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [19-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [19-3] 	DROP INDEX public.recipient_q;

2008:11:20-19:41:01 (none) postgres[4315]: [20-1] ERROR:  index "sender_q" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [20-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [20-3] 	DROP INDEX public.sender_q;

2008:11:20-19:41:01 (none) postgres[4315]: [21-1] ERROR:  index "action_q" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [21-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [21-3] 	DROP INDEX public.action_q;

2008:11:20-19:41:01 (none) postgres[4315]: [22-1] ERROR:  index "reason_q" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [22-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [22-3] 	DROP INDEX public.reason_q;

2008:11:20-19:41:01 (none) postgres[4315]: [23-1] ERROR:  index "received_q" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [23-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [23-3] 	DROP INDEX public.received_q;

2008:11:20-19:41:01 (none) postgres[4315]: [24-1] ERROR:  index "size_q" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [24-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [24-3] 	DROP INDEX public.size_q;

2008:11:20-19:41:01 (none) postgres[4315]: [25-1] ERROR:  index "src_q" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [25-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [25-3] 	DROP INDEX public.src_q;

2008:11:20-19:41:01 (none) postgres[4315]: [26-1] ERROR:  index "reported_q" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [26-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [26-3] 	DROP INDEX public.reported_q;

2008:11:20-19:41:01 (none) postgres[4315]: [27-1] ERROR:  relation "public.q" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [27-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [27-3] 	

2008:11:20-19:41:01 (none) postgres[4315]: [27-4] 	ALTER TABLE ONLY public.q DROP CONSTRAINT primary_q;

2008:11:20-19:41:01 (none) postgres[4315]: [28-1] ERROR:  table "q" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [28-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [28-3] 	DROP TABLE public.q;

2008:11:20-19:41:01 (none) postgres[4315]: [29-1] ERROR:  type "reason_q_enum" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [29-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [29-3] 	

2008:11:20-19:41:01 (none) postgres[4315]: [29-4] 	DROP TYPE reason_q_enum;

2008:11:20-19:41:01 (none) postgres[4315]: [30-1] ERROR:  type "action_q_enum" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [30-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [30-3] 	DROP TYPE action_q_enum;

2008:11:20-19:41:01 (none) postgres[4315]: [31-1] NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "primary_q" for table "q"

2008:11:20-19:41:01 (none) postgres[4315]: [32-1] ERROR:  index "cluster_id_l" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [32-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [32-3] 	

2008:11:20-19:41:01 (none) postgres[4315]: [32-4] 	DROP INDEX public.cluster_id_l;

2008:11:20-19:41:01 (none) postgres[4315]: [33-1] ERROR:  index "message_id_l" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [33-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [33-3] 	DROP INDEX public.message_id_l;

2008:11:20-19:41:01 (none) postgres[4315]: [34-1] ERROR:  index "recipient_l" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [34-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [34-3] 	DROP INDEX public.recipient_l;

2008:11:20-19:41:01 (none) postgres[4315]: [35-1] ERROR:  index "sender_l" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [35-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [35-3] 	DROP INDEX public.sender_l;

2008:11:20-19:41:01 (none) postgres[4315]: [36-1] ERROR:  index "result_l" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [36-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [36-3] 	DROP INDEX public.result_l;

2008:11:20-19:41:01 (none) postgres[4315]: [37-1] ERROR:  index "result_time_l" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [37-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [37-3] 	DROP INDEX public.result_time_l;

2008:11:20-19:41:01 (none) postgres[4315]: [38-1] ERROR:  index "reason_l" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [38-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [38-3] 	DROP INDEX public.reason_l;

2008:11:20-19:41:01 (none) postgres[4315]: [39-1] ERROR:  index "received_l" does not exist

2008:11:20-19:41:01 (none) postgres[4315]: [39-2] STATEMENT:  

2008:11:20-19:41:01 (none) postgres[4315]: [39-3] 	DROP INDEX public.received_l;

2008:11:20-19:41:01 (none) postgres[4315]: [40-1] ERROR:  index "size_l" does not exist

...
should this be logged into system logs ?
0 tom_01 over 16 years ago

This isn't very nice, but "normal". The scripts that create the SQL schema have drop clauses to remove eventually existing entries. They throw these errors when initializing an empty DB.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 koma over 16 years ago

Try "Drop Index IF EXIST ..." to avoid erros.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 tom_01 over 16 years ago in reply to koma

Useless waste of perfectly good CPU cycles! We'll switch off logging instead [:D]
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Monarch over 16 years ago in reply to tom_01

My god, I can't believe it [;)]
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel