FATAL 1: Memory exhausted in AllocSetAlloc()
От | Thomas Heller |
---|---|
Тема | FATAL 1: Memory exhausted in AllocSetAlloc() |
Дата | |
Msg-id | 004c01c07bc5$993ba2d0$b7217fd4@kjkafjuprmkaec обсуждение исходный текст |
Ответы |
Re: FATAL 1: Memory exhausted in AllocSetAlloc()
|
Список | pgsql-admin |
Hi there! The last db-crash (kernel panic) caused a little error on my db-files i think. After the crash i had to recreate some indexes but no data were lost. Everything is running quite ok now, except for one BIG error. The postgres process crashes every now and then without giving any information on any reasons. :( AND I can't use pg_dumpall, vacuumdb -z. All the time I run a program that is supposed to dump my database or analyze it. I get the following error from the program: FATAL 1: Memory exhausted in AllocSetAlloc() pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. connection to server was lost vacuumdb: vacuum failed pg_dumpall: pg_dumpall failed I'm running a postgres-7.0.3 on a p3-800 with 768mb ram. postgres is the only thing running on that machine. The Database Directory is 500mb big. I have several tables (some arround 5k entries and about 5 tables are >100k entries). The DB is heavy loaded (linux load of 6-20 at main time) and I plan to move it to a bigger machine. The only problem is that i can't dump my db. :( Somebody got any advices how I can dump or vacuum my db again? thanks in advance, thomas
В списке pgsql-admin по дате отправления: