Re: New kind of crash?

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: New kind of crash?
Date: 2013-03-09 03:17:36
Message-ID: 513AA9D0.8070601@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Do you have any non default procedural languages installed? I provoked
exactly that error with a similar script which used a PL/R procedure
(see BUGS thread "PL/R Median Busts Commit"...the cause is signal
hi-jacking in that case).

Regards

Mark

On 09/03/13 13:27, Josh Berkus wrote:
> Folks,
>
> This is one I've never seen before:
>
> => select generate_master_tables();
> WARNING: AbortTransaction while in COMMIT state
> PANIC: cannot abort transaction 9387287, it was already committed
> PANIC: cannot abort transaction 9387287, it was already committed
> The connection to the server was lost. Attempting reset: Failed.
> Time: 42259.753 ms
> !>
>
> Interestingly, Postges came back up on its own after about a minute and
> seems to be OK. The stored procedure in question is one which creates
> about 600 tables. This actually exceeds max_locks_per_transaction, but
> what happened above is not the normal failure for that.
>
> Note that the tables were, in fact, created, and as far as I can tell
> there's no corruption of the database.
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2013-03-09 03:27:09 Re: New kind of crash?
Previous Message Josh Berkus 2013-03-09 00:27:30 New kind of crash?