VACUUM ANALYZE problem on linux

From: Oleg Broytmann <phd(at)sun(dot)med(dot)ru>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: VACUUM ANALYZE problem on linux
Date: 1999-02-08 12:37:37
Message-ID: Pine.SOL2.3.96.SK.990208152921.719B-100000@sun.med.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 while processing 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(at)earthling(dot)net
Programmers don't die, they just GOSUB without RETURN.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 1999-02-08 12:59:54 Keywords
Previous Message Zeugswetter Andreas IZ5 1999-02-08 12:05:39 Re: [HACKERS] Problems with >2GB tables on Linux 2.0