John,

system had been running ok till this morning when it crashed again. same set of errors though on a different table this time. While the system was unavailable to users I have got the file descriptors changed on the server from 256 to 1024. I'm now monitoring the system again.

Many thanks for your help.

Zoe
-----Original Message-----
From: Dennis, John [mailto:John.Dennis (AT) ca (DOT) com]
Sent: 04 March 2005 02:22
To: Goodchild, Zoe
Subject: E_CL0654_DILRU_ALL_PINNED_ERR



Hi Zoe,

I responded to your query about this error on the newsgroup, but perhaps you haven't seen my reply. If you have and discovered that my resolution doesn't work, then I apologise for sending this again.

The error E_CL0654_DILRU_ALL_PINNED_ERR is almost certainly caused by running out of file descriptors. You can either increase the number of file descriptors available in the OS (the ulimit -aH command will show you how manyyou have) - or alternatively reducing the number of file descriptors that Ingres will attempt to keep open at one time (by reducing the dmf_hash_sizeparameter in CBF) might help. The preferred option is to increase the number of descriptors available.

It doesn't appear as though you have opened an issue for this - I am certain that the support team in the UK would have been able to give you the answer to this very quickly.

Regards,
John


John Dennis
Computer Associates
Technology Specialist, Ingres
tel: +61 3 9727 8922
fax: +61 3 9727 3491
mobile: +61 411 150 009
john.dennis (AT) ca (DOT) com




_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

This Email is confidential and intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing or copying of the email is strictly prohibited.

If you have received this email in error please notify Bexley Council by telephone on +44 (0) 208 303 7777.

Web Site: http://www.bexley.gov.uk