Thread: BUG #5578: postrgesql database crash

BUG #5578: postrgesql database crash

From
"yhou"
Date:
The following bug has been logged online:

Bug reference:      5578
Logged by:          yhou
Email address:      yhou@dtri.com
PostgreSQL version: 8.3.8-1
Operating system:   windows 2000
Description:        postrgesql database crash
Details:

My program will use postgresal database, after start my program ,I find it
hangs always, so I check the db log,and find these exception:

2010-07-27 14:08:22 EDT LOG:  loaded library
"$libdir/plugins/plugin_debugger.dll"
2010-07-27 14:08:22 EDT LOG:  loaded library
"$libdir/plugins/plugin_debugger.dll"
2010-07-27 14:08:22 EDT LOG:  CreateProcess call failed: A blocking
operation was interrupted by a call to WSACancelBlockingCall.

     (error code 5)
2010-07-27 14:08:22 EDT LOG:  could not fork new process for connection: A
blocking operation was interrupted by a call to WSACancelBlockingCall.


2010-07-27 14:08:23 EDT LOG:  CreateProcess call failed: A blocking
operation was interrupted by a call to WSACancelBlockingCall.

     (error code 5)
2010-07-27 14:08:23 EDT LOG:  could not fork new process for connection: A
blocking operation was interrupted by a call to WSACancelBlockingCall.

...(fill of this exception)

Re: BUG #5578: postrgesql database crash

From
Alex Hunsaker
Date:
On Thu, Jul 29, 2010 at 20:01, yhou <yhou@dtri.com> wrote:
> Operating system: =C2=A0 windows 2000

> My program will use postgresal database, after start my program ,I find it
> hangs always, so I check the db log,and find these exception:
>
> 2010-07-27 14:08:22 EDT LOG: =C2=A0loaded library
> "$libdir/plugins/plugin_debugger.dll"
> 2010-07-27 14:08:22 EDT LOG: =C2=A0loaded library
> "$libdir/plugins/plugin_debugger.dll"
> 2010-07-27 14:08:22 EDT LOG: =C2=A0CreateProcess call failed: A blocking
> operation was interrupted by a call to WSACancelBlockingCall.

Huh, what happens if you take out the loading of plugin_debugger.dll
(and any shared_preload_lib/local_preload_lib for that matter) ?

Re: BUG #5578: postrgesql database crash

From
pratikchirania
Date:
We have a similar issue with postgres 9.0.1
Any ideas?

I dint see any updates in the 9.1 release notes.. Has this issue been
addressed?

Regards,
Pratik Chirania
Hewlett-Packard

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/BUG-5578-postrgesql-database-crash-tp2259469p5077853.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

Re: BUG #5578: postrgesql database crash

From
pratikchirania
Date:
We have a similar issue with postgres 9.0.1
Any ideas?

I dint see any updates in the 9.1 release notes.. Has this issue been
addressed?

Regards,
Pratik Chirania

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/BUG-5578-postrgesql-database-crash-tp2259469p5077868.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

Re: BUG #5578: postrgesql database crash

From
Robert Haas
Date:
On Thu, Dec 15, 2011 at 10:48 AM, pratikchirania <pratik.chirania@hp.com> wrote:
> We have a similar issue with postgres 9.0.1
> Any ideas?
>
> I dint see any updates in the 9.1 release notes.. Has this issue been
> addressed?

I don't think we have enough information to address the issue here.
Can you provide any more details?  I mean, it seems clear that process
creation is failing on the OP's system, but it certainly doesn't fail
all the time for everyone, so there must be something different about
that particular machine.  However, there are no details in that bug
report to help us guess what the relevant difference might be.  The
debugger plugin *might* be relevant, but I think it's more likely a
red herring, and the real issue is something else entirely.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company