pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
find open transactions/locks in 7.2? 2+ messages / 2 participants [nested] [flat]
* find open transactions/locks in 7.2? @ 2003-06-09 19:21 george young <gry@ll.mit.edu> 0 siblings, 0 replies; 2+ messages in thread From: george young @ 2003-06-09 19:21 UTC (permalink / raw) To: pgsql-sql [select version() --> PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 3.0.4] I'm getting hangups every day or so, I presume due to some open transaction that insert/update/delete'ed on a table that is used by my main app without a commit. Is there some way (in 7.2!) to find who's locking what or who has a transaction open? -- George -- I cannot think why the whole bed of the ocean is not one solid mass of oysters, so prolific they seem. Ah, I am wandering! Strange how the brain controls the brain! -- Sherlock Holmes in "The Dying Detective" ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: find open transactions/locks in 7.2? @ 2003-06-11 11:00 Christoph Haller <ch@rodos.fzk.de> 0 siblings, 0 replies; 2+ messages in thread From: Christoph Haller @ 2003-06-11 11:00 UTC (permalink / raw) To: pgsql-sql; gry@ll.mit.edu > > [select version() --> PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 3.0.4] > > I'm getting hangups every day or so, I presume due to some open transaction > that insert/update/delete'ed on a table that is used by my main app without > a commit. > > Is there some way (in 7.2!) to find who's locking what or who has > a transaction open? > AFAICT No. There has been a thread on a similar topic [HACKERS] Can pessimistic locking be emulated? but it was all referring to 7.3. Anyway, you might want to check. Regards, Christoph ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-06-11 11:00 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2003-06-09 19:21 find open transactions/locks in 7.2? george young <gry@ll.mit.edu> 2003-06-11 11:00 Re: find open transactions/locks in 7.2? Christoph Haller <ch@rodos.fzk.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox