VACUUM ANALYZE problem on linux
От | Oleg Broytmann |
---|---|
Тема | VACUUM ANALYZE problem on linux |
Дата | |
Msg-id | Pine.SOL2.3.96.SK.990208152921.719B-100000@sun.med.ru обсуждение исходный текст |
Ответы |
Re: [HACKERS] VACUUM ANALYZE problem on linux
|
Список | pgsql-hackers |
Hello! A week ago I reported a problem with VACUUM ANALYZE on linux and memory error. Three good guys saw my database and two of them for VACUUM problem, I hope (Tom Lane and Thomas Lockhart). Have you reproduced the case? I ran VACUUM ANALYZE on table basis. Results: ----- Script ----- VACUUM ANALYZE sections; VACUUM ANALYZE subsections; VACUUM ANALYZE positions; VACUUM ANALYZE cities; VACUUM ANALYZE districts; VACUUM ANALYZE shop_types; VACUUM ANALYZE shops; VACUUM ANALYZE producers; VACUUM ANALYZE products; VACUUM ANALYZE correspondents; VACUUM ANALYZE shop_corr; VACUUM ANALYZE money4corr; VACUUM ANALYZE raw_maillog; VACUUM ANALYZE corr_mail_errors; VACUUM ANALYZE pos_rating; VACUUM ANALYZE motd; VACUUM ANALYZE central; VACUUM ANALYZE bad_data; VACUUM ANALYZE today_history; VACUUM ANALYZE currencies; VACUUM ANALYZE currency_exch; VACUUM ANALYZE param_int; VACUUM ANALYZE param_str; VACUUM ANALYZE param_float; VACUUM ANALYZE param_datetime; VACUUM ANALYZE palette; VACUUM ANALYZE units; VACUUM ANALYZE mail_ecod; ----- Log ----- VACUUM VACUUM VACUUM VACUUM VACUUM VACUUM VACUUM VACUUM ----- Errors ----- VACUUM ANALYZE sections; VACUUM ANALYZE subsections; VACUUM ANALYZE positions; VACUUM ANALYZE cities; VACUUM ANALYZE districts; VACUUM ANALYZE shop_types; VACUUM ANALYZE shops; VACUUM ANALYZE producers; VACUUM ANALYZE products; pqReadData() -- backend closed the channel unexpectedly.This probably means the backend terminated abnormally before or whileprocessing the request. We have lost the connection to the backend, so further processing is impossible. Terminating. ----- End ----- If I remove "products" from script, the next table to fail is "palette". If I remove "palette" - all goes well. Oleg. ---- Oleg Broytmann http://members.xoom.com/phd2/ phd2@earthling.net Programmers don't die, they justGOSUB without RETURN.
В списке pgsql-hackers по дате отправления: