From: Greg Williamson <gwilliamson39@yahoo.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Question about ALTER TABLE DROP CONSTRAINT on 9.1 -- psql crashes
Date: Thu, 9 Aug 2012 17:35:10 -0700 (PDT)
Message-ID: <1344558910.70207.YahooMailNeo@web125906.mail.ne1.yahoo.com> (raw)
In-Reply-To: <8579.1344557984@sss.pgh.pa.us>
References: <1344557082.43876.YahooMailNeo@web125906.mail.ne1.yahoo.com>
<8579.1344557984@sss.pgh.pa.us>
Tom --
>________________________________
><...>>
>> WTF? That should certainly not happen. Have you perhaps got a script
>> that runs around sending SIGTERM to backends that it thinks are blocking
>> something? Does anything show up in the postmaster log when this
>> happens?
>
>No, we have processes that kill IDLE IN TRANSACTIONs ruthlessly, but nothing that kills any other processes. There is an outside chance that this ran at just the same time that a cronjob ran the REINDEX command for the table (unlikely but I am going to shut off the cronjob and try this again).
>
>
>It does not log an ERROR to the log file; I can wade intio the log and see what else it says but it will take a little while (about 800 megs per hour) to answer that.
>
>
>Thanks, and I'll report back soon.
>
>
>Greg
>-
>
>
>
>
>=
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gwilliamson39@yahoo.com, tgl@sss.pgh.pa.us
Subject: Re: Question about ALTER TABLE DROP CONSTRAINT on 9.1 -- psql crashes
In-Reply-To: <1344558910.70207.YahooMailNeo@web125906.mail.ne1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox