[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    [ADMIN] Duplicating log lines from postmaster
From:       Justin Cragin <justin.cragin () mxlogic ! com>
Date:       2003-10-28 23:17:21
[Download RAW message or body]

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)



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
[prev in list] [next in list] [prev in thread] [next in thread]