BUG #2676: postmaster using 100% cpu from odbc disconnect

From: "Luke McFarlane" <luke(at)fisheye(dot)com(dot)au>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2676: postmaster using 100% cpu from odbc disconnect
Date: 2006-10-05 04:18:11
Message-ID: 200610050418.k954IBPd091502@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2676
Logged by: Luke McFarlane
Email address: luke(at)fisheye(dot)com(dot)au
PostgreSQL version: 8.1.4
Operating system: Mandriva Linux 2006.0 Kernel 2.6.15.7 SMP
Description: postmaster using 100% cpu from odbc disconnect
Details:

Hi

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%. If I run the query manually it takes literally
milliseconds to complete.

When I did a netstat -nt I did not see any active connection from the
offending remote user.

Any input would be appreciated.

Thanks

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-10-05 05:03:10 Re: BUG #2676: postmaster using 100% cpu from odbc disconnect
Previous Message Tom Lane 2006-10-04 22:34:12 Re: BUG #2674: libedit not detected