Re: [Info-Ingres] Mutex: DCB iidbdb

Hi Richard,



On the servers where I see this problem (all have patch 13001) the grep
shows THREAD.



On the servers with the prior patch level I used (12479) the grep has no
output.



Marty



From: David Richard [mailto:Richard.David-at-aah.co.uk]
Sent: 28 August 2008 10:44
To: martin.bowes-at-iua.org.uk
Subject: RE: [Info-Ingres] Mutex: DCB iidbdb
Importance: High



Hi Martin,
We're also experiencing an intermittent hang on a very similar platform
to yours. We're currently on Patch 13017 with one expected anytime...)

What do you get when you run the following shell command? :-
grep 'fd_affinity' $II_SYSTEM/ingres/files/config.dat
Best regards,
Richard

Richard David
Senior Database Administrator
Business Systems
AAH Pharmaceuticals
tel (direct): +44 (0)2476 432992
fax: +44 (0)2476 432333
mobile: +44 (0)7810 784690
email: richard.david-at-aah.co.uk

-----Original Message-----
From: info-ingres-bounces-at-kettleriverconsulting.com
[mailto:info-ingres-bounces-at-kettleriverconsulting.com
] On Behalf Of
Martin Bowes
Sent: 28 August 2008 10:09
To: Ingres and related product discussion forum
Subject: [Info-Ingres] Mutex: DCB iidbdb

Hi everyone,
I'm running II 9.1.1 (a64.lnx/103)NPTL + patch13001 on Red Hat
Enterprise Linux Server release 5 (Tikanga).
About once a week my servers freeze up and new connections stall in
Mutex: DCB iidbdb
This sucks big time.
I've checked on the Ingres Tech support site and there are three old
bugs listed against the Mutex but none of them seem relevant in this
case.

Can anyone shed some light on the details shown by show mutex?
I get...
show mutex 00002AAAB9806810
Mutex at 00002AAAB9806810: Name: DCB iidbdb, EXCL owner: (tid:
1080768832, pid: 8227)
Shared: 0 Collisions: 0 Hwm: 0
Excl: 15 Collisions: 13
The pid=8227 was the DBMS server pid.
Does the tid tell me anything?
Martin Bowes

************************************************** **********************


DISCLAIMER

The information contained in this e-mail is confidential and is intended


for the recipient only.

If you have received it in error, please notify us immediately by reply
e-mail and then delete it from your system. Please do not copy it or use
it for any other purposes, or disclose the content of the e-mail to any
other person or store or copy the information in any medium.

The views contained in this e-mail are those of the author and not
necessarily those of AAH Pharmaceuticals Ltd.

AAH Pharmaceuticals Ltd is a company incorporated in England and Wales
under company number 123458 and whose registered office is at Sapphire
Court, Walsgrave Triangle, Coventry, CV2 2TX

************************************************** **********************