Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #2676: postmaster using 100% cpu from odbc disconnect - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2676: postmaster using 100% cpu from odbc disconnect
Date
Msg-id 8414.1160024590@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2676: postmaster using 100% cpu from odbc disconnect  ("Luke McFarlane" <luke@fisheye.com.au>)
List pgsql-bugs
Tree view 
"Luke McFarlane" <luke@fisheye.com.au> writes:
> User connects to database via Visual Basic & ODBC. During his session VB
> crashed. The query that was executed was selecting all records from a simple
> view (approx 20,000 records). The query has been running for 68 minutes,
> postmaster on 100%.

Tried to reproduce this by killing psql mid-query ... no luck.

Do you want to gdb that backend process and see what it's doing?

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Luke McFarlane"
Date:
Subject: BUG #2676: postmaster using 100% cpu from odbc disconnect
Next
From: Jim Nasby
Date:
Subject: Re: BUG #2661: select time with time zone not converting