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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Luke McFarlane" <luke(at)fisheye(dot)com(dot)au>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2676: postmaster using 100% cpu from odbc disconnect
Date: 2006-10-05 05:03:10
Message-ID: 8414.1160024590@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Luke McFarlane" <luke(at)fisheye(dot)com(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message CN 2006-10-05 05:48:47 BUG #2677: BCC 5.5 can't compile libpq 8.2 beta 1
Previous Message Luke McFarlane 2006-10-05 04:18:11 BUG #2676: postmaster using 100% cpu from odbc disconnect