The following bug has been logged on the website:
Bug reference: 12785
Logged by: Daniele
Email address: daniele.posenato@smartec.ch
PostgreSQL version: 9.3.3
Operating system: W7 professionale 64 bit
Description:
Hi,
For an industrial application I have the same software running on 4
different PCs with the same characteristics and configurations. Each PC has
its how postgresql database. All 4 PC are doing the same things.
On one PC sometimes (about one per week) I get the server process (PID 2872)
was terminated by exception 0xC0000005.
On the log file I have these information:
2015-02-13 22:46:05 CET LOG: server process (PID 2872) was terminated by
exception 0xC0000005
2015-02-13 22:46:05 CET DETAIL: Failed process was running: SELECT * FROM
highvaluelogs INNER JOIN (SELECT * FROM hvforeachpoint WHERE logID>0) AS
SQL1 ON highvaluelogs.logID=SQL1.logID ORDER BY highvaluelogs.logtimestamp
DESC;
2015-02-13 22:46:05 CET HINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
I am not able to figure out way the query is able to crash the service. The
query is executed every 10 seconds and it is crashing the service only in
one PC.
Thanks in advance for the support.
Best regard
Daniele