Skip site navigation (1) Skip section navigation (2)

BUG #6187: Select query stuck

From: "Bhavesh Dangi" <dangi(dot)bhavesh86(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6187: Select query stuck
Date: 2011-08-30 11:28:49
Message-ID: 201108301128.p7UBSn5K098487@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      6187
Logged by:          Bhavesh Dangi
Email address:      dangi(dot)bhavesh86(at)gmail(dot)com
PostgreSQL version: PostgreSQL8.0.1
Operating system:   i686-pc-linux-gnu
Description:        Select query stuck
Details: 

Hello,

Here the problem is SELECT query takes a lot of time(in days) to return a
result than expected time and sometimes it stop to responding. Its totally
hang. We are suffering from last 1 years by having this issue. If it will
happen then we finding that query from pg_stat_activity and cancel it but
that is not a solution of problem.
We also found that almost SELECT queries are stuck. We are also continuous
performing veccumdb before 2 billion transactions. 
I hope that you will be provide some way to solve it.

Thanks & Regards,
Bhavesh Dangi

Responses

pgsql-bugs by date

Next:From: Jan SneldersDate: 2011-08-30 13:18:56
Subject: Postgresql ACID bug?
Previous:From: LampaDate: 2011-08-30 11:20:20
Subject: BUG #6186: out of memory while analyze

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group