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
|
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-----