Hi All,



We have a host on which we run an api program. When run interactively
its fine, but when its run as a daemon process (under the same username)
it fails with IIAPI_ST_OUT_OF_MEMORY.



The kernel.shmmax is set to 350000000.



There are no messages in the ingres errlog. Ingres version is II
2.6/0604 (int.lnx/00) +p12166.



I suspect something in the kernel as the host recently crashed and the
system disk has had to be rebuilt.



Any suggestions would be welcome.



Martin Bowes

Hi Martin,
You may try seting API trace and see if the trace shows some more
details on the error.
Regards,
Divya


--
Divya

Hi Martin,

Check that the II_* Ingres environment variables are set in the daemon
process. It happened to me once when I didn't have II_TIMEZONE_NAME or
II_DATE_FORMAT set (I can't remember which one).

Hope this helps,
Dave


--
thoda04

Yes I have seen this happening once to a user who did not have the
II_SYSTEM defined correctly, so this could well be caused because of
incorrect environment settings.
Regards,
Divya


--
Divya

Hi Martin,

The error IIAPI_ST_OUT_OF_MEMORY might happen even if the application
is unable to initialize the INGRES API layer. During initialization the
the INGRES API layer has to read INGRES configuration info. If for some
reason it fails to read the INGRES configuration info this error will be
thrown. As stated by Vidya and Dave it is quite possible the daemon
process is unable to access the OS configuration for INGRES ( II_SYSTEM
variable ) and hence the error. If it is possible to get a API trace,
the additional info from the trace will shed some light about the cause
of the problem.

Hope this helps.

Regards,
Usha


--
rajus01

On Dec 11, 2009, at 12:02 PM, Ingres Forums wrote:

I certainly understand the implementation reasons for this, but I have
to opine that IIAPI_ST_OUT_OF_MEMORY is hardly an elegant way
to say "You don't have II_SYSTEM set." :-)

Karl

Yes, I agree Karl. If for sure the IIAPI_ST_OUT_OF_MEMORY in this case
occurred because II_SYSTEM is not set, then the fix for bug 117496
should address this with a better error message. I will have to make
sure if this fix is crossed to II 2.6/0604 release reported here....

Regards,
Usha


--
rajus01

Just confirmed that a better Ingres API error message if II_SYSTEM is
not set is available in Ingres releases IngresR3 and later...

Regards,
Usha


--
rajus01

Hi All,

User has just confirmed that his .bash_profile was not sourcing his
..bashrc so his batch environment was not being set correctly..ie
II_SYSTEM et al were down the tubes.

As it was all working until the host crashed and burned I assume the
correct stuff must have been junked when we lost the system disk.

Glad to hear there is an improved message

Marty