[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 ?
Parents
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
Reply
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
Children
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