BUG #11903: Segmentation fault - Mailing list pgsql-bugs

From dimon99901@mail.ru
Subject BUG #11903: Segmentation fault
Date
Msg-id 20141107062122.2465.60482@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #11903: Segmentation fault  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      11903
Logged by:          Dmitry
Email address:      dimon99901@mail.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.

pgsql-bugs by date:

Previous
From: Bruce Hunsaker
Date:
Subject: Re: BUG #11883: Year 1500 not treated as leap year when it was a leap year
Next
From: koposov@ast.cam.ac.uk
Date:
Subject: BUG #11904: out of memory when scanning large number of partitions