Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: Hung SQL Up...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 6 Topic 15510 of 17437
Post > Topic >>

Re: Hung SQL Update Linux Redhat 4U5 Postgres 8.3.1

by tgl@[EMAIL PROTECTED] (Tom Lane) May 12, 2008 at 03:11 PM

Craig Vosburgh <craig.vosburgh@[EMAIL PROTECTED]
> writes:
> Second, any words of wisdom to help run to ground who's keeping me from
> getting the lock on the offending row?  The row in the lock table that
shows
> granted false does not show as belonging to a database or relation (both
> null) so I can't join through to get the table info from pg_table.

What's the locktype?  If (as I suspect) it's a transaction or
virtualtransaction lock, then which process holds that lock and what's
it doing?  For that matter, what is the stuck process doing?
pg_stat_activity output should be sufficient here.

			regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 6 Posts in Topic:
Re: Hung SQL Update Linux Redhat 4U5 Postgres 8.3.1
craig.vosburgh@[EMAIL PRO  2008-05-12 11:43:37 
Re: Hung SQL Update Linux Redhat 4U5 Postgres 8.3.1
tgl@[EMAIL PROTECTED] (T  2008-05-12 14:16:06 
Re: Hung SQL Update Linux Redhat 4U5 Postgres 8.3.1
craig.vosburgh@[EMAIL PRO  2008-05-12 13:07:38 
Re: Hung SQL Update Linux Redhat 4U5 Postgres 8.3.1
tgl@[EMAIL PROTECTED] (T  2008-05-12 15:11:27 
Re: Hung SQL Update Linux Redhat 4U5 Postgres 8.3.1
craig.vosburgh@[EMAIL PRO  2008-05-12 16:19:46 
Re: Hung SQL Update Linux Redhat 4U5 Postgres 8.3.1
tgl@[EMAIL PROTECTED] (T  2008-05-12 18:49:31 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 12:45:06 CST 2008.