On Fri, 2010-04-30 at 11:14 -0500, Kevin Grittner wrote:
> Claudio Freire <[email protected]> wrote:
>
> > I know it doesn't look like a deadlock from where you're standing,
> > but it does so from where I am.
>
> It's possible that you're filtering out the information which would
> be most useful to diagnosing the problem. Next time it happens,
> please send the entire output from pg_locks and pg_stat_activity
> (preferably as attachments to avoid wrapping issues), along with the
> information listed under "Things you need to mention" on this page:
pg_stat_activity not, but pg_locks I did save:
madmax=# select * from pg_locks;
locktype | database | relation | page | tuple | virtualxid |
transactionid | classid | objid | objsubid | virtualtransaction | pid |
mode | granted
---------------+----------+----------+-------+-------+------------+---------------+---------+-------+----------+--------------------+-------+------------------+---------
relation | 1397730 | 1398075 | | | |
| | | | 63/15761 | 11157 | RowExclusiveLock
| t
relation | 1397730 | 1398075 | | | |
| | | | 4/10902 | 6421 | RowExclusiveLock
| t
tuple | 1397730 | 1398075 | 33783 | 38 | |
| | | | 63/15761 | 11157 | ExclusiveLock
| t
virtualxid | | | | | 63/15761 |
| | | | 63/15761 | 11157 | ExclusiveLock
| t
virtualxid | | | | | 4/10902 |
| | | | 4/10902 | 6421 | ExclusiveLock
| t
relation | 1397730 | 1397973 | | | |
| | | | 63/15761 | 11157 | AccessShareLock
| t
relation | 1397730 | 1398733 | | | |
| | | | 4/10902 | 6421 | AccessShareLock
| t
relation | 1397730 | 1397973 | | | |
| | | | 4/10902 | 6421 | AccessShareLock
| t
relation | 1397730 | 10969 | | | |
| | | | 64/26597 | 15370 | AccessShareLock
| t
relation | 1397730 | 1397891 | | | |
| | | | 4/10902 | 6421 | AccessShareLock
| t
relation | 1397730 | 1397891 | | | |
| | | | 63/15761 | 11157 | AccessShareLock
| t
transactionid | | | | | |
39773877 | | | | 63/15761 | 11157 | ShareLock
| f
relation | 1397730 | 1398783 | | | |
| | | | 4/10902 | 6421 | RowExclusiveLock
| t
relation | 1397730 | 1398783 | | | |
| | | | 63/15761 | 11157 | RowExclusiveLock
| t
transactionid | | | | | |
39773877 | | | | 4/10902 | 6421 |
ExclusiveLock | t
relation | 1397730 | 1398737 | | | |
| | | | 4/10902 | 6421 | AccessShareLock
| t
virtualxid | | | | | 64/26597 |
| | | | 64/26597 | 15370 | ExclusiveLock
| t
relation | 1397730 | 1398737 | | | |
| | | | 63/15761 | 11157 | AccessShareLock
| t
relation | 1397730 | 1398939 | | | |
| | | | 4/10902 | 6421 | AccessShareLock
| t
transactionid | | | | | |
39783847 | | | | 63/15761 | 11157 |
ExclusiveLock | t
relation | 1397730 | 1398939 | | | |
| | | | 63/15761 | 11157 | AccessShareLock
| t
relation | 1397730 | 1398761 | | | |
| | | | 63/15761 | 11157 | AccessShareLock
| t
relation | 1397730 | 1397882 | | | |
| | | | 4/10902 | 6421 | AccessShareLock
| t
relation | 1397730 | 1398938 | | | |
| | | | 4/10902 | 6421 | AccessShareLock
| t
relation | 1397730 | 1398938 | | | |
| | | | 63/15761 | 11157 | AccessShareLock
| t
relation | 1397730 | 1398735 | | | |
| | | | 4/10902 | 6421 | AccessShareLock
| t
relation | 1397730 | 1398761 | | | |
| | | | 4/10902 | 6421 | AccessShareLock
| t
(27 rows)
--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
