Re: URGENT issue: pg-xlog growing on master!

Поиск

Список

Период

Сортировка

От	Dinesh Kumar
Тема	Re: URGENT issue: pg-xlog growing on master!
Дата	10 июня 2013 г. 14:47:59
Msg-id	CAKWsr7gfYQ0Ojag_-paFASQheDr0qDf7F4nfw07AxQzUDftb_g@mail.gmail.com обсуждение исходный текст
Ответ на	URGENT issue: pg-xlog growing on master! (Niels Kristian Schjødt <nielskristian@autouncle.com>)
Список	pgsql-performance

Дерево обсуждения

Hi, My pg_xlog dir has been growing rapidly the last 4 days, and my disk is now almost full (1000Gb) even though the database is only 50Gb. I have a streaming replication server running, and in the log of the slave it says:

cp: cannot stat `/var/lib/postgresql/9.2/wals/0000000200000E1B000000A9': No such file or directory
cp: cannot stat `/var/lib/postgresql/9.2/wals/0000000200000E1B000000A9': No such file or directory
2013-06-10 11:21:45 GMT FATAL: could not connect to the primary server: could not connect to server: No route to host
Is the server running on host "192.168.0.4" and accepting
TCP/IP connections on port 5432?

All the time.

I have tried to restart the server, but that didn't help. I checked the master, and the file /var/lib/postgresql/9.2/wals/0000000200000E1B000000A9 does not exist! I'm pretty lost here, can someone help me solve this and get my master server cleaned up. What is causing this, and what do I need to do?

IIRC, this kind of situation we may expect, when the archive command was failed at master side. Could you verify, how many files "000000xxxxxxx.ready" reside under the master's pg_xlog/archive_status directory. And also, verify the master server's recent pg_log file, for finding the root cause of the master server down issue.

Dinesh

--
Dinesh Kumar

Software Engineer