BUG #12785: server process (PID 2872) was terminated by exception 0xC0000005
От | daniele.posenato@smartec.ch |
---|---|
Тема | BUG #12785: server process (PID 2872) was terminated by exception 0xC0000005 |
Дата | |
Msg-id | 20150219095550.8732.11319@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #12785: server process (PID 2872) was terminated by
exception 0xC0000005
|
Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: