Weird mailing list bounce - Mailing list pgsql-www

From Greg Sabino Mullane
Subject Weird mailing list bounce
Date
Msg-id 8857f7403b58894cc93f1b65018bfaf7@biglumber.com
Whole thread Raw
Responses Re: Weird mailing list bounce  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
List pgsql-www
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
NotDashEscaped: You need GnuPG to verify this message


I received this strange bounce when posting to the -general 
mailing list a couple weeks ago. Looks like it made it to 
the mailing list, but the box after that rejected it because 
of a "fail[ed] syntax check". Unfortunately, it gives no 
details as to what that actually means, and if the problem 
is with my headers or the ones majordomo added. Anyone have 
clues or ideas on how to diagnose?

==Begin forwarded message==

From: Mail Delivery System <Mailer-Daemon@zql.com>
To: greg@turnstep.com
Subject: Mail delivery failed: returning message to sender
Date: 8:28 PM on Wednesday, February 08, 2012
X-Failed-Recipients: pgsql-general@postgresql.org
This message was created automatically by mail delivery software.

A message that you sent could not be delivered to one or more of its
recipients. This is a permanent error. The following address(es) failed:
 pgsql-general@postgresql.org   SMTP error from remote mail server after end of data:   host makus.postgresql.org
[98.129.198.125]:550 Message headers fail syntax check
 

------ This is a copy of the message, including all the headers. ------

Return-path: <greg@turnstep.com>
Received: from localhost.localdomain ([127.0.0.1] helo=localhost)
by zql.com with smtp (Exim 4.68)
(envelope-from <greg@turnstep.com>)
id 1RvIoG-0000nu-GY; Wed, 08 Feb 2012 20:28:28 -0500
From: "Greg Sabino Mullane" <greg@turnstep.com>
To: pgsql-general@postgresql.org
Cc: pgsql-general <pgsql-general@postgresql.org> Content-Type: text/plain; charset=ISO-8859-1 X-PG-Spam-Score: -2.7
(--)X-Mailing-List: pgsql-general List-Archive: <http://archives.postgresql.org/pgsql-general> List-Help:
<mailto:majordomo@postgresql.org?body=help>List-ID: <pgsql-general.postgresql.org> List-Owner:
<mailto:pgsql-general-owner@postgresql.org>List-Post: <mailto:pgsql-general@postgresql.org> List-Subscribe:
<mailto:majordomo@postgresql.org?body=sub%20pgsql-general>AlekseyTsalolikhin <atsaloli.tech@gmail.com>
 
CC: pgsql-general <pgsql-general@postgresql.org> Content-Type: text/plain; charset=ISO-8859-1 X-PG-Spam-Score: -2.7
(--)X-Mailing-List: pgsql-general List-Archive: <http://archives.postgresql.org/pgsql-general> List-Help:
<mailto:majordomo@postgresql.org?body=help>List-ID: <pgsql-general.postgresql.org> List-Owner:
<mailto:pgsql-general-owner@postgresql.org>List-Post: <mailto:pgsql-general@postgresql.org> List-Subscribe:
<mailto:majordomo@postgresql.org?body=sub%20pgsql-general>AlekseyTsalolikhin <atsaloli.tech@gmail.com>
 
Subject: Re: [GENERAL] phantom long-running query (check_postgres.pl reports a long-running query, but the database
logsdon`t show it)
 
X-PGP-Key: 2529 DF6A B8F7 9407 E944  45B4 BC9B 9067 1496 4AC8
X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
In-Reply-To: <CA+jMWocErE4Ek3qpY-DGwiSKqckPZtZhv4iAYX5tGX1tfeRXxA@mail.gmail.com>
Date: Thu,  9 Feb 2012 01:28:28 -0000
X-Mailer: JoyMail 2.4.0
Message-ID: <42ce54325a082b7437d6d7241c8ab4a3@biglumber.com>


-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


...
> POSTGRES_QUERY_TIME WARNING: (host:xxx) longest query: 264s
> (database:xxx PID:xxx port:xxx address:xxx username:xxx)
...
> postgres log showed other long-running queries, but nothing over 48s.
>
> It's really interesting why the database server log does not show this query.

It's not in the logs because it hasn't stopped running yet. Once 
it finishes, it will appear in the logs. You need to query 
pg_stat_database to see what query it is.

Remember that check_postgres looks at things happening right now, 
it is not a historical tool.

- -- 
Greg Sabino Mullane greg@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201202082027
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAk8zISMACgkQvJuQZxSWSsjy1wCg3mQHshSbOY7fDOK5YP/j2lqS
8qIAoML2jObVcNrIRwZWAgnOAZK58X/X
=kPb3
-----END PGP SIGNATURE-----




-- 
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 201202190809
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAk9A9J0ACgkQvJuQZxSWSsigSACg99a3MqmiIxZcjdcLEMa2cyck
RPYAn0MtYhLgUz1uezcUGUbEgwOKIxpn
=UD4m
-----END PGP SIGNATURE-----




pgsql-www by date:

Previous
From: Robert Haas
Date:
Subject: Re: incorrect claim regarding SE-Postgres
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: Weird mailing list bounce