pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Strategy for unlocking query 2+ messages / 2 participants [nested] [flat]
* Strategy for unlocking query @ 2001-04-04 15:34 Graham Vickrage <graham@digitalplanit.com> 0 siblings, 1 reply; 2+ messages in thread From: Graham Vickrage @ 2001-04-04 15:34 UTC (permalink / raw) To: pgsql-sql I have just done a rather large transaction via a telnet/psql session which executed OK. The problem occured when the telnet session timed out before I could commit the rows. This must have locked the rows in question because when I tried to vacuum the table it just hung. What is the best way of dealing with this problem as I ended up stopping and restarting the postmaster? Also are functions within functions dealt with in a 'transactional' sense? Cheers Graham Attachments: winmail.dat (application/ms-tnef, 1.7K) download ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Strategy for unlocking query @ 2001-04-04 16:07 Tom Lane <tgl@sss.pgh.pa.us> parent: Graham Vickrage <graham@digitalplanit.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2001-04-04 16:07 UTC (permalink / raw) To: Graham Vickrage <graham@digitalplanit.com>; +Cc: pgsql-sql "Graham Vickrage" <graham@digitalplanit.com> writes: > I have just done a rather large transaction via a telnet/psql session which > executed OK. The problem occured when the telnet session timed out before I > could commit the rows. > This must have locked the rows in question because when I tried to vacuum > the table it just hung. Probably the backend process was still there and didn't yet realize that the client connection had died. It would notice eventually, but I think the timeout involved is typically an hour or so (this is determined by the TCP protocols and isn't under our control). > What is the best way of dealing with this problem as I ended up stopping and > restarting the postmaster? It would've been sufficient to find and SIGTERM the individual backend from the lost session. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-04-04 16:07 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2001-04-04 15:34 Strategy for unlocking query Graham Vickrage <graham@digitalplanit.com> 2001-04-04 16:07 ` Tom Lane <tgl@sss.pgh.pa.us>
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