Re: Strange crash logs - Mailing list pgsql-general

From Rocco Zanni
Subject Re: Strange crash logs
Date
Msg-id FF4532F7-9F7A-4FA5-8375-75C37C95FBE9@spreaker.com
Whole thread Raw
In response to Re: Strange crash logs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi Tom,
we've discovered more informations in the meanwhile.

It seems that a bug in our backup tools caused a freeze in the
database filesystem. The tool was stucked inside an xfs_freeze for a
several minutes and caused the kernel to terminate processes locked
waiting for write lock. One of this processes was postgresql.

I don't believe that was an issue on postgres-side.

Bye,
Rocco

---
Rocco Zanni
rocco.zanni@spreaker.com
http://www.spreaker.com

Il giorno 09/mag/12, alle ore 17:08, Tom Lane ha scritto:

> Rocco Zanni <rocco.zanni@spreaker.com> writes:
>> someone can help me understanding what happened in this crash logs?
>> http://pastebin.com/0ruR4egm
>
> What was happening *before* the lines you showed?
>
> The information there seems to indicate that something got stuck while
> holding the ProcStructLock, but there's no way to tell what or why
> from
> this much info.
>
>             regards, tom lane


pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: PostgreSQL Session #4 : Call for Papers
Next
From: Chris Hanks
Date:
Subject: Retrieving multiple columns from a subquery