pid in pg_locks not present in procpid pg_stat_activity

Started by frank_lupoabout 23 years ago4 messagesgeneral

frank_lupo@email.it

about 23 years ago

I have a problem to verify user to lock a object database. The corrspondence pid from pg_loks to pg_stat_activity not found.
pippo=# select * from pg_locks\g
relation | database | transaction | pid | mode | granted
----------+----------+-------------+------+---------------------+---------
1734991 | 16976 | | 500 | AccessExclusiveLock | t
17785 | 16976 | | 500 | AccessExclusiveLock | t
| | 19091 | 500 | ExclusiveLock | t
1735213 | 16976 | | 500 | AccessExclusiveLock | t
18209 | 16976 | | 500 | AccessExclusiveLock | t
1734989 | 16976 | | 500 | AccessExclusiveLock | t
| | 19290 | 1356 | ExclusiveLock | t
1734987 | 16976 | | 500 | AccessExclusiveLock | t
1734988 | 16976 | | 500 | AccessExclusiveLock | t
17
34986 |

16976 | | 500 | AccessExclusiveLock | t
1734990 | 16976 | | 500 | AccessExclusiveLock | t
16757 | 16976 | | 1356 | AccessShareLock | t
(12 rows)
pippo=# select * from pg_stat_activity\g
datid | datname | procpid | usesysid | usename | current_query
-------+---------+---------+----------+---------------+---------------
16976 | gedis30 | 1356 | 100 | Administrator |
Tanks

Bye !!
Frank Lupo (Wolf) !!

/\_ _/\
\ o o /
--ooo-----ooo---

--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Solo su Occhialeria.it una vastissima scelta a prezzi insuperabili!
Per te le migliori marche e un incredibile assortimento.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=880&d=24-1

Tom Lane

tgl@sss.pgh.pa.us

about 23 years ago

In reply to: frank_lupo (#1)

Re: pid in pg_locks not present in procpid pg_stat_activity

"=?utf-8?Q?frank=5Flupo?=" <frank_lupo@email.it> writes:

I have a problem to verify user to lock a object database. The corrspondenc=
e pid from pg_loks to pg_stat_activity not found.

Hm, you sure that PID 500 didn't simply quit between the time you
examined one table and the time you examined the other?

regards, tom lane

frank_lupo

frank_lupo@email.it

about 23 years ago

In reply to: Tom Lane (#2)

Re: pid in pg_locks not present in procpid pg_stat_activity

"=?utf-8?Q?frank=5Flupo?=" writes:

I have a problem to verify user to lock a object database. The corrspondenc=
e pid from pg_loks to pg_stat_activity not found.

Hm, you sure that PID 500 didn't simply quit between the time you
examined one table and the time you examined the other?

regards, tom lane

I have verified selecting more times from pg_locks and pg_stat_activity but he can be like you say .

tanks

Bye !!
Frank Lupo (Wolf) !!

/\_ _/\
\ o o /
--ooo-----ooo---

--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Quando hai bisogno di liquidità non devi spiegare per cosa. Conto Privilegiato è discreto.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=1240&d=24-1

Import Notes

Resolved by subject fallback

frank_lupo

frank_lupo@email.it

about 23 years ago

In reply to: frank_lupo (#3)

Re: pid in pg_locks not present in procpid pg_stat_activity

"=?utf-8?Q?frank=5Flupo?=" writes:

I have a problem to verify user to lock a object database. The corrspondenc=
e pid from pg_loks to pg_stat_activity not found.

Hm, you sure that PID 500 didn't simply quit between the time you
examined one table and the time you examined the other?

regards, tom lane

I agree with you.

Thanks

Bye !!
Frank Lupo (Wolf) !!

/\_ _/\
\ o o /
--ooo-----ooo---

--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Mobility Conference Exhibition 2003: l'evento di Assolombarda sulla mobility.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=1124&d=24-1

Import Notes

Resolved by subject fallback