FW: SQL -406 Memory allocation failed.

We've recently started receiving this error during and onbar restore. It was working fine in the past. IDS: BM Informix Dynamic Server Version 9.40.HC6X1 -- On-Line -- Up 108 days 15:01:51 -- 526420 Kbytes OS: HP-UX B.11.11 U 9000/800 The restore abended with a similar error as during the Disaster test: 2009-10-13 12:00:44 18439 18436 Out of memory 2009-10-13 12:00:44 18439 18436 An attempt to add 534505 to a linked list failed with error 7 2009-10-13 12:00:44 18439 18436 SQL -406 Memory allocation failed. 2009-10-13 12:00:44 18439 18436 /opt/informix/ifx940.hc6x1/bin/onbar_d complete, returning 158 (0x9e) Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com <mailto:2244650553@messaging.sprintpcs.com> Page via Skytel: 2244650553@sprint.skytel.com <mailto:2244650553@sprint.skytel.com> Informix or MySQL Primary: 9110210@skytel.com <mailto:9110210@skytel.com> Informix or MySQL Secondary: 7276872@skytel.com <mailto:7276872@skytel.com> " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU *******************************************************************

Well the "Out of memory" message indicates a failure of a malloc. You might try turning on bar debug to like 3 or 5 and seeing what more details you can get. The "534505" is likely the object name it was trying to insert onto a list of objects, not sure if that is a logical log id or what else it might be. If malloc is failing now it could be because onbar is having to track more objects for your restore, or could there have been some other change and now onbar is loading up some object too low and so the onbar heap is crashing into a shared library, or even shared memory which is what's causing the malloc to fail? Not sure if HP has any way to get a process map of the onbar process so you could see what might be conflicting with the heap. Jacques Renaut IBM Informix Advanced Support APD Team You wrote: >We've recently started receiving this error during and onbar restore. >It was working fine in the past. > >IDS: > >IBM Informix Dynamic Server Version 9.40.HC6X1 -- On-Line -- Up 108 days 15:01:51 -- 526420 Kbytes > >OS: > >HP-UX B.11.11 U 9000/800> >The restore abended with a similar error as during the Disaster test: > >2009-10-13 12:00:44 18439 18436 Out of memory >2009-10-13 12:00:44 18439 18436 An attempt to add 534505 to a linked list failed with error 7 >2009-10-13 12:00:44 18439 18436 SQL -406 Memory allocation failed. >2009-10-13 12:00:44 18439 18436 /opt/informix/ifx940.hc6x1/bin/onbar_d complete, returning 158 (0x9e)

I would suggest that you look at how big your ixbar file is. It might be that this file has grown and now you are just trying to load to many backup objects as Jacques pointed out. If you have not been running onsmsync to keep the ixbar file trimmed you can look at this utility. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 10/14/2009 01:01:39 PM: > [image removed] > > Re: FW: SQL -406 Memory allocation failed. [17558]> > > Jacques Renaut > > to: > > ids > > 10/14/2009 01:07 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Well the "Out of memory" message indicates a failure of a malloc. You might > try turning on bar debug to like 3 or 5 and seeing what more details you can > get. The "534505" is likely the object name it was trying to insert onto a > list of objects, not sure if that is a logical log id or what else it might > be. If malloc is failing now it could be because onbar is having to > track more > objects for your restore, or could there have been some other change and now > onbar is loading up some object too low and so the onbar heap is > crashing into > a shared library, or even shared memory which is what's causing the malloc to > fail? Not sure if HP has any way to get a process map of the onbar process so > you could see what might be conflicting with the heap. > > Jacques Renaut > IBM Informix Advanced Support > APD Team > > You wrote: > >We've recently started receiving this error during and onbar restore. > >It was working fine in the past. > > > >IDS: > > > >IBM Informix Dynamic Server Version 9.40.HC6X1 -- On-Line -- Up 108 > days 15:01:51 -- 526420 Kbytes > > > >OS: > > > >HP-UX B.11.11 U 9000/800> > > >The restore abended with a similar error as during the Disaster test: > > > >2009-10-13 12:00:44 18439 18436 Out of memory > >2009-10-13 12:00:44 18439 18436 An attempt to add 534505 to a linked > list failed with error 7 > >2009-10-13 12:00:44 18439 18436 SQL -406 Memory allocation > failed. > >2009-10-13 12:00:44 18439 18436 /opt/informix/ifx940.hc6x1/bin/onbar_d > complete, returning 158 (0x9e) > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

This worked. We reduced the ixbar file, since it was gigantic. Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John Miller iii Sent: Wednesday, October 14, 2009 5:37 PM To: ids@iiug.org Subject: Re: FW: SQL -406 Memory allocation failed. [17569] I would suggest that you look at how big your ixbar file is. It might be that this file has grown and now you are just trying to load to many backup objects as Jacques pointed out. If you have not been running onsmsync to keep the ixbar file trimmed you can look at this utility. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 10/14/2009 01:01:39 PM: > [image removed] > > Re: FW: SQL -406 Memory allocation failed. [17558]> > > Jacques Renaut > > to: > > ids > > 10/14/2009 01:07 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Well the "Out of memory" message indicates a failure of a malloc. You might > try turning on bar debug to like 3 or 5 and seeing what more details you can > get. The "534505" is likely the object name it was trying to insert onto a > list of objects, not sure if that is a logical log id or what else it might > be. If malloc is failing now it could be because onbar is having to > track more > objects for your restore, or could there have been some other change and now > onbar is loading up some object too low and so the onbar heap is > crashing into > a shared library, or even shared memory which is what's causing the malloc to > fail? Not sure if HP has any way to get a process map of the onbar process so > you could see what might be conflicting with the heap. > > Jacques Renaut > IBM Informix Advanced Support > APD Team > > You wrote: > >We've recently started receiving this error during and onbar restore. > >It was working fine in the past. > > > >IDS: > > > >IBM Informix Dynamic Server Version 9.40.HC6X1 -- On-Line -- Up 108 > days 15:01:51 -- 526420 Kbytes > > > >OS: > > > >HP-UX B.11.11 U 9000/800> > > >The restore abended with a similar error as during the Disaster test: > > > >2009-10-13 12:00:44 18439 18436 Out of memory > >2009-10-13 12:00:44 18439 18436 An attempt to add 534505 to a linked > list failed with error 7 > >2009-10-13 12:00:44 18439 18436 SQL -406 Memory allocation > failed. > >2009-10-13 12:00:44 18439 18436 /opt/informix/ifx940.hc6x1/bin/onbar_d > complete, returning 158 (0x9e) > > > ************************************************************************ ******* > Forum Note: Use "Reply" to post a response in the discussion forum. > ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.