Received: from helpdesk.senet.com.au (helpdesk.senet.com.au [203.34.34.120]) by hub.org (8.9.3/8.9.3) with ESMTP id XAA20773 for ; Fri, 23 Jul 1999 23:34:23 -0400 (EDT) (envelope-from wayne@helpdesk.senet.com.au) Received: (from wayne@localhost) by helpdesk.senet.com.au (8.9.1/8.9.1) id NAA08108; Sat, 24 Jul 1999 13:04:09 +0930 (CST) From: Wayne Piekarski Message-Id: <199907240334.NAA08108@helpdesk.senet.com.au> Subject: In-Reply-To: <199907240259.WAA14092@hub.org> from pgsql-sql-digest at "Jul 23, 99 10:59:58 pm" To: pgsql-sql@hub.org Date: Sat, 24 Jul 1999 13:04:09 +0930 (CST) Cc: yjchui@ms.chttl.com.tw X-Mailer: ELM [version 2.4ME+ PL40 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > From: Yann-Ju Chu > Subject: about stuck spinlock of postgresq-l6.4.2 > > I have checked the postgresql mail list about the stuck spinlock. > I have found one about the related discusion and there is one line for > stuck spinlock error as > > " The above errors are a normal 6.4.2 with no patches - I am not running > Tom's patch yet" > > I have tried to find the patch to avoid stuck spinlock and not success. > Could anybody please tell me where to get the patch abou the stuck spinlock? Hi, I installed the patch you mentioned to fix the spinlock problems but I found that even still we had problems with backends locking up and sitting idle waiting for nothing, and other related problems. I highly recommend you upgrade to 6.5 because it has fixed a lot of these problems for us. See my next post to hackers/sql for more information. ciao, Wayne ------------------------------------------------------------------------------ Wayne Piekarski Tel: (08) 8221 5221 Research & Development Manager Fax: (08) 8221 5220 SE Network Access Pty Ltd Mob: 0407 395 889 222 Grote Street Email: wayne@senet.com.au Adelaide SA 5000 WWW: http://www.senet.com.au