SQLException on memory allocation

Posted in 2010

Summary

Sridip Bhattacharya found ralloc memory growing quickly in a session on IDS 11.50.FC6WE, causing application memory-allocation exceptions. Sridip solved it: onstat -g stm showed thousands of open statements, and closing sessions fixed it. John Miller said the application was not closing cursors or statements and suggested IFX_AUTO_FREE. Jan Virt reported a similar XA leak fixed by 11.50.FC7.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Versions, Editions & End-of-Life

SRIDIP BHATTACHARYA — Sun, 21 Nov 2010 12:53:00 — source: IIUG Forums & Mailing Lists

Hi, I am using IBM Informix Dynamic Server Version 11.50.FC6WE, RHEl 5 (18GB RAM, x64) and an application is continuously inserting into a table (around 10+ records per sec). After certain time getting memory allocation exception in application logs. But no issue found in online log. To resolve the application is required to restarted. On analysis found that ralloc in onstat -g ufr <sid> is increasing continuously and very fast. sqscb, buft_buffer & fragman are also increasing. Memory usage for pool name 1661: size memid 3288 overhead 144 scb 2920 ostcb 11049648 sqscb 72 sql 2387656 filetable 12110416 fragman 2520 osenv 7816368 sqtcb 552 hashfiletab 16536 log 1592 gentcb 267308008 ralloc 30170368 opentable 1120 rdahead 2208 temprec 392 keys 648 ru 733384 sapi 886800 ID(512) 20114040 buft_buffer Please suggest if it is a informix config issue or there is memory leak in the application. Regards, Sridip

↪ replying to SRIDIP BHATTACHARYA

SRIDIP BHATTACHARYA — Mon, 22 Nov 2010 11:10:22 — source: IIUG Forums & Mailing Lists

Hi, There was a bug in IDS 10 that (IC50084 ONLINE-SQL) A memory leak occurs in ralloc when repeatedly executing a stored procedure which returns a set type. But how I am getting the same issue in IDS 11.5FC6WE? Can any one suggest... Regards, Sridip

↪ replying to SRIDIP BHATTACHARYA

SRIDIP BHATTACHARYA — Sat, 04 Dec 2010 20:26:26 — source: IIUG Forums & Mailing Lists

Issue resolved, onstat -g stm was showing thousands of open statements, on closing thesessions issue was resolved. Regards

↪ replying to SRIDIP BHATTACHARYA

John Miller iii — Sat, 04 Dec 2010 23:19:23 — source: IIUG Forums & Mailing Lists

This generally means the application is not closing the cursor or prepare statement. If the is a java program, please make sure the garbage collector is not responsible for free the cursors/statements. You can automatically force a free on a close, by setting the application environment variable IFX_AUTO_FREE. John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 12/04/2010 12:26:27 PM: > [image removed] > > Re: SQLException on memory allocation [22114] > > SRIDIP BHATTACHARYA > > to: > > ids > > 12/04/2010 12:26 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Issue resolved, > > onstat -g stm was showing thousands of open statements, on closing the> sessions issue was resolved. > > Regards > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to John Miller iii

JAN VIRT — Thu, 09 Dec 2010 16:14:44 — source: IIUG Forums & Mailing Lists

there are several bugs in the version you're using which are causing memory leaks, in our case it was related to prepare and open/close cursor loop in XA transactions. same symptomps with ralloc. upgrade to Informix 11.50.FC7 solved the issue. ;)

Related threads

Glossary

onstat