Strange crash logs

Started by Rocco Zannialmost 14 years ago3 messagesgeneral
Jump to latest
#1Rocco Zanni
rocco.zanni@spreaker.com

Hi,
someone can help me understanding what happened in this crash logs?

http://pastebin.com/0ruR4egm

PostgreSQL version is:
- PostgreSQL 9.1.2 on x86_64-pc-linux-gnu, compiled by gcc-4.6.real
(Ubuntu/Linaro 4.6.1-9ubuntu3) 4.6.1, 64-bit

Thanks,
Rocco

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Rocco Zanni (#1)
Re: Strange crash logs

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

#3Rocco Zanni
rocco.zanni@spreaker.com
In reply to: Tom Lane (#2)
Re: Strange crash logs

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:

Show quoted text

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