Skip site navigation (1) Skip section navigation (2)

Re: System hangs when Insert/Update

From: Lee Kwok Shing <kslee(at)graduate(dot)hku(dot)hk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: System hangs when Insert/Update
Date: 2001-06-04 15:39:43
Message-ID: 3B1BABBF.E9E84893@graduate.hku.hk (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Tom,
  Thanks for yout information.

  There should be no clients disconnect in the middle of a transaction since
the problem happens even if there is only one update.

More have capture some traces, the query seems hanged after the phase
  ProcessQuery
and before
  CommitTransactionCommand

  The query plan and the parser outputs process phase has been passed.

  So it seems that the query is stuck at committing the transaction...

  It is even strange that after I killing the process and issue the same
query again, it success !!!

  Thanks again !
  Regards,

Lee Kwok Shing

Tom Lane wrote:

> Lee Kwok Shing <kslee(at)graduate(dot)hku(dot)hk> writes:
> >   I am using PostgreSQL 7.0.2 on RH 6.2
> >   The DB works smoothly in the past 8 months but until recently, the
> > system would hang when doing insert or update statements.
>
> Second thought on this: do you have any clients that might disconnect in
> the middle of a transaction?  If so, update to 7.0.3 (or later).
>
>                         regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
Lee Kwok Shing (***)
http://www.geocities.com/lkslee.geo


Attachment: kslee.vcf
Description: text/x-vcard (178 bytes)

In response to

pgsql-admin by date

Next:From: Chris RuprechtDate: 2001-06-04 18:22:56
Subject: data/base file structure
Previous:From: Tom LaneDate: 2001-06-04 14:15:04
Subject: Re: Alternate database locations

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group