Обсуждение: BUG #8748: server process was terminated by exception 0xFFFFFFFF
BUG #8748: server process was terminated by exception 0xFFFFFFFF
От
costas@pebblelearning.co.uk
Дата:
The following bug has been logged on the website: Bug reference: 8748 Logged by: Costas Email address: costas@pebblelearning.co.uk PostgreSQL version: 9.1.9 Operating system: Windows Server 2008 R2 Description: Hello all, PostgreSQL 9.1.9 terminated due to exception code 0xFFFFFFFF which cannot be found in ntstatus.h as suggested by the logs. Other services on the server continued to run normally. The server , is a master on a binary replication setup. The good folk at #postgresql suggested that this might be a bug. I've included the logs below. 2014-01-06 23:57:46 UTC [11352]: [6863-1] user=postgres,db=somdb LOG: duration: 0.000 ms statement: select 'Npgsql121201' 2014-01-06 23:57:46 UTC [11352]: [6864-1] user=postgres,db=somdb LOG: duration: 0.000 ms statement: BEGIN; SET TRANSACTION ISOLATION LEVEL READ COMMITTED; 2014-01-06 23:57:46 UTC [11352]: [6865-1] user=postgres,db=somdb LOG: duration: 1.000 ms statement: select * from "table" 2014-01-06 23:57:46 UTC [11352]: [6866-1] user=postgres,db=somdb LOG: duration: 0.000 ms statement: COMMIT 2014-01-06 23:57:46 UTC [11352]: [6867-1] user=postgres,db=somdb LOG: duration: 0.000 ms statement: unlisten * 2014-01-06 23:57:48 UTC [1616]: [4-1] user=,db= LOG: server process (PID 2656) was terminated by exception 0xFFFFFFFF 2014-01-06 23:57:48 UTC [1616]: [5-1] user=,db= HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2014-01-06 23:57:48 UTC [1616]: [6-1] user=,db= LOG: terminating any other active server processes 2014-01-06 23:57:48 UTC [10400]: [224-1] user=postgres,db=somotherdb WARNING: terminating connection because of crash of another server process 2014-01-06 23:57:48 UTC [10400]: [225-1] user=postgres,db=somotherdb 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. 2014-01-06 23:57:48 UTC [10400]: [226-1] user=postgres,db=somotherdb HINT: In a moment you should be able to reconnect to the database and repeat your command. 2014-01-06 23:58:03 UTC [1616]: [7-1] user=,db= LOG: archiver process (PID 10732) exited with exit code 1 2014-01-06 23:58:04 UTC [1616]: [8-1] user=,db= LOG: all server processes terminated; reinitializing 2014-01-06 23:58:14 UTC [1616]: [9-1] user=,db= FATAL: pre-existing shared memory block is still in use 2014-01-06 23:58:14 UTC [1616]: [10-1] user=,db= HINT: Check if there are any old server processes still running, and terminate them