Re: Weird lock or bug maybe?

From: go <go(at)ugnn(dot)ru>
To: Ben-Nes Yonatan <da(at)canaan(dot)co(dot)il>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Weird lock or bug maybe?
Date: 2005-08-05 09:13:35
Message-ID: 2622776109.20050805131335@ugnn.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there

I have much problems with wierd locking too. I thing
that it problem is connected with localisation - when
i update a "problem" row (which have text fields) with
any different text data in text fields - all locks
dissapper. I hope this info can help to solve this bug
(because in PG 7.2.3 i didnt saw this problems//)

--
Thanks

BNY> Hi All,

BNY> I got 2 very simple tables, one hold few values and got a unique field
BNY> to be used as identifier and the other table got a reference to that
BNY> table (foreign key).
BNY> At my last testing before the problem I inserted to each one of the
BNY> tables about 1 million rows, for the process of inserting new
BNY> information I begin a transaction, delete all the previous information,
BNY> insert the new information and commit the transaction.
BNY> So far it never gave me any problems (though its the first time that I
BNY> let a foreign key to exist) but now from some reason it "locks" a
BNY> specific row from being deleted.... for example:
BNY> If ill query: DELETE FROM table1; it will just get stuck...
BNY> If ill try: DELETE FROM table1 WHERE table1_id=1523; it will work in
BNY> most cases but for some rows it will just get stuck!
BNY> Anyone know anything about this weird problem?
BNY> By the way when I restarted the DB server I was able to delete the
BNY> current row which stucked the process but then I got stuck at some other
BNY> row at the table....

BNY> Thanks in advance,
BNY> Ben-Nes Yonatan

BNY> ---------------------------(end of broadcast)---------------------------
BNY> TIP 9: In versions below 8.0, the planner will ignore your desire to
BNY> choose an index scan if your joining column's datatypes do not
BNY> match

--
С уважением,
Игорь mailto:go(at)ugnn(dot)ru

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-08-05 09:24:00 Re: Slow Inserts on 1 table?
Previous Message David Goodenough 2005-08-05 09:08:42 Does preparing statements other than selects help performance?