Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[Info-Ingres] IIAPI_ST_OUT_OF_MEMORY

2 views
Skip to first unread message

Martin Bowes

unread,
Dec 11, 2009, 9:49:18 AM12/11/09
to Ingres and related product discussion forum

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

Ingres Forums

unread,
Dec 11, 2009, 10:09:28 AM12/11/09
to

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


--
Divya
------------------------------------------------------------------------
Divya's Profile: http://community.ingres.com/forum/member.php?userid=1442
View this thread: http://community.ingres.com/forum/showthread.php?t=11481

Ingres Forums

unread,
Dec 11, 2009, 11:12:39 AM12/11/09
to

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
------------------------------------------------------------------------
thoda04's Profile: http://community.ingres.com/forum/member.php?userid=42

Ingres Forums

unread,
Dec 11, 2009, 11:22:28 AM12/11/09
to

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
------------------------------------------------------------------------
Divya's Profile: http://community.ingres.com/forum/member.php?userid=1442

Ingres Forums

unread,
Dec 11, 2009, 12:02:57 PM12/11/09
to

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
------------------------------------------------------------------------
rajus01's Profile: http://community.ingres.com/forum/member.php?userid=1596

Karl Schendel

unread,
Dec 11, 2009, 12:21:22 PM12/11/09
to Ingres and related product discussion forum

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

>
> The error IIAPI_ST_OUT_OF_MEMORY might happen even if the application
> is unable to initialize the INGRES API layer.

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


Ingres Forums

unread,
Dec 11, 2009, 1:27:16 PM12/11/09
to

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....

Ingres Forums

unread,
Dec 11, 2009, 1:37:44 PM12/11/09
to

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

Martin Bowes

unread,
Dec 15, 2009, 6:57:16 AM12/15/09
to Ingres and related product discussion forum
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

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

Marty


0 new messages