Re: How to release locks

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to release locks
Date: 2006-03-22 08:01:56
Message-ID: dvr0g0$28gv$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


"Andrus" <eetasoft(at)online(dot)ee> wrote
>
> insert command takes a long time. I terminated the client application from
> Windows XP client manager during insert command.
> At next re-run application and pgadmin both hang in DELETE FROM line
>
> I think I can reproduce this. Postgres server is in FreeBSD.
> I can require server admin to do something after the problem occurs.
>
> What should I do after reproducing the problem ?
>

A backtrace information would be most useful. Just build a debug verison
(--enable-debug) and restart the server, when you reproduce the problem,
attach gdb to it, then "bt".

Regards,
Qingqing

In response to

Browse pgsql-general by date

  From Date Subject
Next Message surabhi.ahuja 2006-03-22 08:10:13 back slash separated values
Previous Message Andrus 2006-03-22 07:56:57 Re: How to release locks