Statistic collector too many fork

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Statistic collector too many fork
Дата
Msg-id aoe3dn$1063$1@news.hub.org
обсуждение исходный текст
Ответы Re: Statistic collector too many fork  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hi to all,
Is it normal that after a while is like if the statistics collector fork a
lot
of time in only one second ?

Oct 11 16:51:28 pserver2 postgres[8898]: [1943390] DEBUG:  reaping dead
processes
Oct 11 16:51:28 pserver2 postgres[8898]: [1943391] DEBUG:  statistics
collector process (pid 16882) exited with exit code 1
Oct 11 16:51:28 pserver2 postgres[8898]: [1943392] DEBUG:  reaping dead
processes
Oct 11 16:51:28 pserver2 postgres[8898]: [1943393] DEBUG:  statistics
collector process (pid 16884) exited with exit code 1
Oct 11 16:51:28 pserver2 postgres[8898]: [1943394] DEBUG:  reaping dead
processes
Oct 11 16:51:28 pserver2 postgres[8898]: [1943395] DEBUG:  statistics
collector process (pid 16886) exited with exit code 1
Oct 11 16:51:28 pserver2 postgres[8898]: [1943396] DEBUG:  reaping dead
processes
Oct 11 16:51:28 pserver2 postgres[8898]: [1943397] DEBUG:  statistics
collector process (pid 16888) exited with exit code 1
Oct 11 16:51:28 pserver2 postgres[8898]: [1943398] DEBUG:  reaping dead
processes
Oct 11 16:51:28 pserver2 postgres[8898]: [1943399] DEBUG:  statistics
collector process (pid 16890) exited with exit code 1
Oct 11 16:51:28 pserver2 postgres[8898]: [1943400] DEBUG:  reaping dead
processes
Oct 11 16:51:28 pserver2 postgres[8898]: [1943401] DEBUG:  statistics
collector process (pid 16892) exited with exit code 1
Oct 11 16:51:28 pserver2 postgres[8898]: [1943402] DEBUG:  reaping dead
processes
Oct 11 16:51:28 pserver2 postgres[8898]: [1943403] DEBUG:  statistics
collector process (pid 16894) exited with exit code 1
Oct 11 16:51:28 pserver2 postgres[8898]: [1943404] DEBUG:  reaping dead
processes
[SNIPP]

and a lot more.

At the end my partition was full, now I don't know what was the cause (disk
almost full / to many line in the log )
and the effect ( statistics collector bug / disk full ).


Ciao
Gaetano



В списке pgsql-admin по дате отправления:

Предыдущее
От: Ragnar Kjørstad
Дата:
Сообщение: Re: Multiple backends on a single physical database
Следующее
От: Chris Miles
Дата:
Сообщение: Re: Multiple backends on a single physical database