Connections Crashing

From: "Shahbaz A(dot) Tyagi" <shahbaz(dot)tyagi(at)sphere(dot)ae>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Connections Crashing
Date: 2009-05-13 20:33:41
Message-ID: 63C02A6561C942ACB13BEE717E85B3C6@dxb.sphere.ae
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message George Kao 2009-05-13 20:56:23 how to extract data from bytea so it is be used in blob for mysql database
Previous Message WP Perquin 2009-05-13 20:08:13 Re: regexp_matches problem