Connections Crashing - Mailing list pgsql-general

From Shahbaz A. Tyagi
Subject Connections Crashing
Date
Msg-id 63C02A6561C942ACB13BEE717E85B3C6@dxb.sphere.ae
Whole thread Raw
Responses Re: Connections Crashing
List pgsql-general

Hi,

 

We are using Postgres 8.3.1 binary distribution, and copying the same along with software installation.

 

From last some time we have started getting error as message dialog showing error 0xC0000142 and after that, connections are crashing.

 

Windows login is administrator user and Postgres user, we are creating before hand.

 

Postgres logs shows following

 

 

LOG:  execute <unnamed>: select stpsetting0_.NF_DEVICE_ID as NF14_1_, stpsetting0_.ID as ID1_, stpsetting0_.ID as ID74_0_, stpsetting0_.NF_ENABLED as NF2_74_0_, stpsetting0_.NF_BASE_TYPE as NF3_74_0_, stpsetting0_.NF_PROTOCOL_SPECS as NF4_74_0_, stpsetting0_.NF_PRIORITY as NF5_74_0_, stpsetting0_.NF_VLAN_ID as NF6_74_0_, stpsetting0_.NF_OPTION1 as NF7_74_0_, stpsetting0_.NF_OPTION2 as NF8_74_0_, stpsetting0_.NF_HOLD_TIME as NF9_74_0_, stpsetting0_.NF_FORWARD_DELAY as NF10_74_0_, stpsetting0_.NF_BRIDGE_MAX_AGE as NF11_74_0_, stpsetting0_.NF_BRIDGE_HELLO_TIME as NF12_74_0_, stpsetting0_.NF_BRIDGE_FORWARD_DELAY as NF13_74_0_, stpsetting0_.NF_DEVICE_ID as NF14_74_0_ from networkManager.NT_STP_SETTINGS stpsetting0_ where stpsetting0_.NF_DEVICE_ID=$1

DETAIL:  parameters: $1 = '6698'

LOG:  execute S_2: COMMIT

LOG:  server process (PID 8156) was terminated by exception 0xC0000142

HINT:  See C include file "ntstatus.h" for a description of the hexadecimal value.

LOG:  terminating any other active server processes

WARNING:  terminating connection because of crash of another server process

 

 

What can be possible reasons for that and whats the solution.

 

Thanks,

 

 

 

 

pgsql-general by date:

Previous
From: "WP Perquin"
Date:
Subject: Re: regexp_matches problem
Next
From: "George Kao"
Date:
Subject: how to extract data from bytea so it is be used in blob for mysql database