BUG #11903: Segmentation fault

From: dimon99901(at)mail(dot)ru
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #11903: Segmentation fault
Date: 2014-11-07 06:21:22
Message-ID: 20141107062122.2465.60482@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 11903
Logged by: Dmitry
Email address: dimon99901(at)mail(dot)ru
PostgreSQL version: 9.3.4
Operating system: Debian 7.7 (Wheezy)
Description:

I saw in postgres log following messages:

2014-11-06 13:58:02 GMT LOG: server process (PID 44060) was terminated by
signal 11: Segmentation fault
2014-11-06 13:58:02 GMT DETAIL: Failed process was running: select id_user
from site.items where id_item = '10795593'
2014-11-06 13:58:02 GMT LOG: terminating any other active server processes
2014-11-06 13:58:02 GMT WARNING: terminating connection because of crash of
another server process
2014-11-06 13:58:02 GMT DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.

Further, postgres generates 6Kiops for 2min on the HDD (I assume that
postgres checked data for corruption).

This situation occures 1 times a day for 2 days.

I planned upgrade to 9.3.5, but i have not seen this bug in 9.3.5 release
notes.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2014-11-07 07:02:57 Re: BUG #11883: Year 1500 not treated as leap year when it was a leap year
Previous Message Michael Paquier 2014-11-07 02:06:25 Re: Invalid page in block on autovacuum