From: | Bo Thorbjørn Jensen <bo(at)budget123(dot)dk> |
---|---|
To: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | exception 0xC0000005 PostgreSQL 9.1.6 on Windows Server 2008 R2 |
Date: | 2012-10-05 12:33:36 |
Message-ID: | AD7252BEFBCA3846A8D34ABCDA258D089BD59A@EXMBX03.mailcloud.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Yesterday (and twice today) we got this from pg_log:
2012-10-04 14:29:08 CEST LOG: server process (PID 1416) was terminated by exception 0xC0000005
2012-10-04 14:29:08 CEST HINT: See C include file "ntstatus.h" for a description of the hexadecimal value.
2012-10-04 14:29:08 CEST LOG: terminating any other active server processes
Version string is: PostgreSQL 9.1.6, compiled by Visual C++ build 1500, 64-bit
OS version: Windows Server 2008 R2 (6 GB memory 64bit)
This has started occurring after upgrading from 9.1.5 AND adding a plpgsql function "log_insert()" (tables and function appended).
Application log suggests a an exception during a rollback is occurring:
2012-10-04 14:29:08,322 [26] Log ERROR ***** - Error in LogClass.Insert(). Cause: Object reference not set to an instance of an object.
Stack Trace: at Npgsql.NpgsqlCommand.ClearPoolAndCreateException(Exception e)
at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
at Npgsql.NpgsqlCommand.ExecuteBlind()
at Npgsql.NpgsqlTransaction.Rollback()
*snip*
Removing the use of said function from application seems to have removed the issue.
I have tried replicating it on a similar setup to no avail :(. Hence the appended script will not guarantee an exception (in fact I can't get the exception from other than live environment)
The live environment has around 1500 databases and on average 10-20 open connections.
I hope you can shed some light, but I understand this is too little to go on for a proper investigation.
Kind regards
Bo Thorbjørn Jensen
Attachment | Content-Type | Size |
---|---|---|
logtables.sql | application/octet-stream | 3.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | franco.ricci | 2012-10-06 14:14:47 | BUG #7586: PL/Perl problem |
Previous Message | katsuhito.habaguchi | 2012-10-05 02:39:33 | BUG #7585: PostgreSQL service stop |