[Info-Ingres] Ingres on Itanium, not to good

[Laframboise André]

Thanks Karl,

Yeah, It may be better to lower the open files back to 1024, 
I'll get a max open file error but at least the processes don't hang.

I installed the Itanium SP5, I'll find out early tomorrow if the FD is still
hardcoded. 

BTW: I also opened an issue with Ingres.com, Anxious to see what they say.

Thanks,

Andre 

-----Original Message-----
From: info-ingres-bounces at kettleriverconsulting.com [mailto:info-ingres-bounces at kettleriverconsulting.com] On Behalf Of Karl & Betty Schendel
Sent: Wednesday, December 05, 2007 10:27 PM
To: info-ingres at kettleriverconsulting.com
Subject: Re: [Info-Ingres] Ingres on Itanium, not to good

At 8:43 PM -0500 12/5/07, Laframboise André wrote:
>We recently migrated a huge database from 2.6/0305 on Tru64 to 2.6/0305 on Linux Itanium.
>
>It looked great for a while. Speed was fast, but short lived. The 
>servers would hang for no apparent reason.
>After 2 days of looking for the obvious, I found this in the dbms_XXX.logs.
>' iiCLfdreg FATAL: fd 1058 surpasses max fd 1024' after which, the 
>servers stopped Responding.
>
>I increased the open files to no avail.

Try going the other way:  set the max open fd's to 1024.

>
>Anyone know if the 2.6 0604 SP5 fix this ?

Not sure.  There's an implementation glitch on linux that limits Ingres to using 1024 file descriptors.  (Ingres's
problem, not linux's.)   Ingres is supposed to hard-limit
itself to 1024 on linux, but I guess your ingres doesn't have this limit.  You could ask tech support if SP5 does.

Karl

_______________________________________________
Info-Ingres mailing list
Info-Ingres at kettleriverconsulting.com
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres