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.