Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ========== 10.216.73.202 ==========
- Output from netstat -p:
- tcp 0 0 10.216.73.20:postgresql dc.scom2012dev.co:46988 ESTABLISHED 23451/postgres: isx
- tcp 0 0 10.216.73.20:postgresql dc.scom2012dev.co:48077 ESTABLISHED 26453/postgres: isx
- Output from psql isxo -c "select pid, locktype, transactionid, virtualtransaction, mode, granted, relname, relkind, datname, usename, current_query, waiting, query_start, client_addr, client_port from pg_locks left outer join pg_class on oid = relation left outer join pg_stat_activity on pid = procpid where pid <> pg_backend_pid() order by pid, granted, relname;"
- pid | locktype | transactionid | virtualtransaction | mode | granted | relname | relkind | datname | usename | current_query | waiting | query_start | client_addr | client_port
- -------+---------------+---------------+--------------------+-----------------------+---------+----------------------------------------+---------+---------+----------+--------------------------------------------------------------+---------+-------------------------------+---------------+-------------
- 23451 | relation | | 35/717 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | f | 2013-01-11 10:25:32.323659+00 | 10.216.73.204 |
- 23451 | relation | | 35/717 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | f | 2013-01-11 10:25:32.323659+00 | 10.216.73.204 |
- 23451 | virtualxid | | 35/717 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | f | 2013-01-11 10:25:32.323659+00 | 10.216.73.204 |
- 23451 | transactionid | 201515 | 35/717 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | f | 2013-01-11 10:25:32.323659+00 | 10.216.73.204 |
- 26453 | transactionid | 201515 | 72/122 | ShareLock | f | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.351276+00 | 10.216.73.204 |
- 26453 | relation | | 72/122 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.351276+00 | 10.216.73.204 |
- 26453 | tuple | | 72/122 | ExclusiveLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.351276+00 | 10.216.73.204 |
- 26453 | relation | | 72/122 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.351276+00 | 10.216.73.204 |
- 26453 | virtualxid | | 72/122 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.351276+00 | 10.216.73.204 |
- ========== 10.216.73.204 ==========
- Output from netstat -p:
- tcp 0 0 dc.scom2012dev.co:48715 dc.scom2012d:postgresql ESTABLISHED 7606/pgpool: isxous
- tcp 0 0 10.216.73.56:5433 10.216.73.56:58608 ESTABLISHED 7606/pgpool: isxous
- tcp 0 0 dc.scom2012dev.co:48077 10.216.73.20:postgresql ESTABLISHED 7606/pgpool: isxous
- tcp 37 0 dc.scom2012dev.co:46988 10.216.73.20:postgresql ESTABLISHED 7681/pgpool: isxous
- tcp 0 0 dc.scom2012dev.co:47626 dc.scom2012d:postgresql ESTABLISHED 7681/pgpool: isxous
- tcp 0 0 10.216.73.56:5433 10.216.73.56:57519 ESTABLISHED 7681/pgpool: isxous
- tcp 0 0 dc.scom2012d:postgresql dc.scom2012dev.co:47626 ESTABLISHED 12464/postgres: isx
- tcp 0 0 dc.scom2012d:postgresql dc.scom2012dev.co:48715 ESTABLISHED 17789/postgres: isx
- Output from psql isxo -c "select pid, locktype, transactionid, virtualtransaction, mode, granted, relname, relkind, datname, usename, current_query, waiting, query_start, client_addr, client_port from pg_locks left outer join pg_class on oid = relation left outer join pg_stat_activity on pid = procpid where pid <> pg_backend_pid() order by pid, granted, relname;"
- pid | locktype | transactionid | virtualtransaction | mode | granted | relname | relkind | datname | usename | current_query | waiting | query_start | client_addr | client_port
- -------+---------------+---------------+--------------------+-----------------------+---------+-----------------------------------------+---------+---------+----------+--------------------------------------------------------------+---------+-------------------------------+---------------+-------------
- 17789 | relation | | 72/242 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | f | 2013-01-11 10:25:32.347289+00 | 10.216.73.204 |
- 17789 | relation | | 72/242 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | f | 2013-01-11 10:25:32.347289+00 | 10.216.73.204 |
- 17789 | transactionid | 201520 | 72/242 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | f | 2013-01-11 10:25:32.347289+00 | 10.216.73.204 |
- 17789 | virtualxid | | 72/242 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | f | 2013-01-11 10:25:32.347289+00 | 10.216.73.204 |
- 12464 | transactionid | 201520 | 35/1659 | ShareLock | f | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.319068+00 | 10.216.73.204 |
- 12464 | relation | | 35/1659 | RowShareLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.319068+00 | 10.216.73.204 |
- 12464 | tuple | | 35/1659 | ExclusiveLock | t | qrtz_mem_locks | r | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.319068+00 | 10.216.73.204 |
- 12464 | relation | | 35/1659 | AccessShareLock | t | qrtz_mem_locks_pkey | i | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.319068+00 | 10.216.73.204 |
- 12464 | virtualxid | | 35/1659 | ExclusiveLock | t | | | isxo | isxouser | SELECT * FROM QRTZ_MEM_LOCKS WHERE LOCK_NAME = $1 FOR UPDATE | t | 2013-01-11 10:25:32.319068+00 | 10.216.73.204 |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement