Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I was running a process to update a bunch of rows in postgres database and it locked up. Now I can't select anything out of it. None of my processes are "idle in transaction" when I execute ps auxwww|grep ^postgres

Also the output of my locks select is:

-[ RECORD 1 ]------+----------------
locktype           | relation
database           | 16384
relation           | 11000
page               | 
tuple              | 
virtualxid         | 
transactionid      | 
classid            | 
objid              | 
objsubid           | 
virtualtransaction | 3/4
pid                | 18655
mode               | AccessShareLock
granted            | t
-[ RECORD 2 ]------+----------------
locktype           | virtualxid
database           | 
relation           | 
page               | 
tuple              | 
virtualxid         | 3/4
transactionid      | 
classid            | 
objid              | 
objsubid           | 
virtualtransaction | 3/4
pid                | 18655
mode               | ExclusiveLock
granted            | t

but I'm not sure what I can with that info. I also restarted my db and no luck. Any ideas?

share
    
What exactly do you mean by "locked up"? Show the full "select locks" command you ran to produce that result, the output of select version(), and the output of select * from pg_stat_activity where state <> 'idle' –  Craig Ringer Jul 14 '13 at 6:56
    
And what exactly do you mean by restarting the DB? Which version? Which OS? –  dezso Jul 14 '13 at 7:46
    
Voted to hold question as "unclear what you're asking". –  Craig Ringer Jul 15 '13 at 3:11
comments disabled on deleted / locked posts

migration rejected from serverfault.com Jul 15 '13 at 10:53

This question came from our site for professional system and network administrators. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as unclear what you're asking by Craig Ringer, StanleyJohns, ypercube, Mark Storey-Smith, Paul White Jul 15 '13 at 10:53

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.