Thread: Duplicating log lines from postmaster

Duplicating log lines from postmaster

From
Justin Cragin
Date:
31 October 2003, 16:55:05
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)