Duplicating log lines from postmaster

Поиск
Список
Период
Сортировка
От Justin Cragin
Тема Duplicating log lines from postmaster
Дата
Msg-id 3F9EFB0D.6090101@mxlogic.com
обсуждение исходный текст
Список pgsql-admin
I am seeing strange behavior with my postmaster logs, it seems to be
writing out each line of a log entry 10 times.  This seems to have
started recently without any know config changes.
I am running 7.3.2 on RedHat 7.3 i386.  Below is a snippet from the logs.

Thanks in advance for any help.

Thanks, Justin Cragin

Oct 28 10:04:18 p01d187 postgres[11125]: [1] ERROR:  parser: parse error
at or near "AND" at character 82
Oct 28 10:04:18 p01d187 postgres[11125]: [1] ERROR:  parser: parse error
at or near "AND" at character 82
Oct 28 10:04:18 p01d187 postgres[11125]: [1] ERROR:  parser: parse error
at or near "AND" at character 82
Oct 28 10:04:18 p01d187 postgres[11125]: [1] ERROR:  parser: parse error
at or near "AND" at character 82
Oct 28 10:04:18 p01d187 postgres[11125]: [1] ERROR:  parser: parse error
at or near "AND" at character 82
Oct 28 10:04:18 p01d187 postgres[11125]: [1] ERROR:  parser: parse error
at or near "AND" at character 82
Oct 28 10:04:18 p01d187 postgres[11125]: [1] ERROR:  parser: parse error
at or near "AND" at character 82
Oct 28 10:04:18 p01d187 postgres[11125]: [1] ERROR:  parser: parse error
at or near "AND" at character 82
Oct 28 10:04:18 p01d187 postgres[11125]: [1] ERROR:  parser: parse error
at or near "AND" at character 82
Oct 28 10:04:18 p01d187 postgres[11125]: [1] ERROR:  parser: parse error
at or near "AND" at character 82
Oct 28 10:04:18 p01d187 postgres[11125]: [2-1] LOG:  statement: UPDATE
mxl_key_sub SET active = 0 WHERE domain_id = 8023409 AND key_bucket_id
=  AND scope = '2' AND  (dir='I'
Oct 28 10:04:18 p01d187 postgres[11125]: [2-1] LOG:  statement: UPDATE
mxl_key_sub SET active = 0 WHERE domain_id = 8023409 AND key_bucket_id
=  AND scope = '2' AND  (dir='I'
Oct 28 10:04:18 p01d187 postgres[11125]: [2-1] LOG:  statement: UPDATE
mxl_key_sub SET active = 0 WHERE domain_id = 8023409 AND key_bucket_id
=  AND scope = '2' AND  (dir='I'
Oct 28 10:04:18 p01d187 postgres[11125]: [2-1] LOG:  statement: UPDATE
mxl_key_sub SET active = 0 WHERE domain_id = 8023409 AND key_bucket_id
=  AND scope = '2' AND  (dir='I'
Oct 28 10:04:18 p01d187 postgres[11125]: [2-1] LOG:  statement: UPDATE
mxl_key_sub SET active = 0 WHERE domain_id = 8023409 AND key_bucket_id
=  AND scope = '2' AND  (dir='I'
Oct 28 10:04:18 p01d187 postgres[11125]: [2-1] LOG:  statement: UPDATE
mxl_key_sub SET active = 0 WHERE domain_id = 8023409 AND key_bucket_id
=  AND scope = '2' AND  (dir='I'
Oct 28 10:04:18 p01d187 postgres[11125]: [2-1] LOG:  statement: UPDATE
mxl_key_sub SET active = 0 WHERE domain_id = 8023409 AND key_bucket_id
=  AND scope = '2' AND  (dir='I'
Oct 28 10:04:18 p01d187 postgres[11125]: [2-1] LOG:  statement: UPDATE
mxl_key_sub SET active = 0 WHERE domain_id = 8023409 AND key_bucket_id
=  AND scope = '2' AND  (dir='I'
Oct 28 10:04:18 p01d187 postgres[11125]: [2-1] LOG:  statement: UPDATE
mxl_key_sub SET active = 0 WHERE domain_id = 8023409 AND key_bucket_id
=  AND scope = '2' AND  (dir='I'
Oct 28 10:04:18 p01d187 postgres[11125]: [2-1] LOG:  statement: UPDATE
mxl_key_sub SET active = 0 WHERE domain_id = 8023409 AND key_bucket_id
=  AND scope = '2' AND  (dir='I'
Oct 28 10:04:18 p01d187 postgres[11125]: [2-2]  OR dir is null)
Oct 28 10:04:18 p01d187 postgres[11125]: [2-2]  OR dir is null)
Oct 28 10:04:18 p01d187 postgres[11125]: [2-2]  OR dir is null)
Oct 28 10:04:18 p01d187 postgres[11125]: [2-2]  OR dir is null)
Oct 28 10:04:18 p01d187 postgres[11125]: [2-2]  OR dir is null)
Oct 28 10:04:18 p01d187 postgres[11125]: [2-2]  OR dir is null)
Oct 28 10:04:18 p01d187 postgres[11125]: [2-2]  OR dir is null)
Oct 28 10:04:18 p01d187 postgres[11125]: [2-2]  OR dir is null)
Oct 28 10:04:18 p01d187 postgres[11125]: [2-2]  OR dir is null)
Oct 28 10:04:18 p01d187 postgres[11125]: [2-2]  OR dir is null)


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

Предыдущее
От: Andreas Schmitz
Дата:
Сообщение: Re: another pg database corruption?
Следующее
От: "Dilip Angal"
Дата:
Сообщение: Help in Postgres Admin