RE: Logbackup failed - ISAM error: cannot allocate memory.
--=====================_1237475816==.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed
I do not know if this fits, but we were having a memory leak problem with
9.30UC1. We ran out of memory whenever we did an
"unload to <file> select <col...> from <table>"
where the select selected a lot of rows and <col...> included a column
having a composite data type. In our case the column was a row type with 5
components; I'm not sure if your spatial stuff uses composite types. A
workaround we came up with was to replace the above statement with
"unload to <file> select <col>::lvarchar from <table>" (i.e. explicit cast
to lvarchar, which will only work depending on the size of the
composite column).
This bug was fixed in 9.30UC6 (I believe) and 9.40UC1 - we went straight to
9.4.
Mike
At 03:42 PM 8/4/04, Murray Wood (IList) wrote:
>I would not be running 9.30.UC2 - upgrade.
>
>I presume you have SHMVIRTSIZE 800Mb and SHMADD 1Gb. There is a total
>2.6Gb shared memory.
>There is plenty free now, but you need to find what requires that large
>amount of shared memory. When it runs out your system will want to add
>another 1Gb of shared memory, which it cannot.
>
>You need to determine if your application or engine has a memory leak - or
>do you have sufficient users to consume this large amount of shared memory.
>
>I would configure SMHADD much smaller and possibly SHMVIRTSIZE larger, if
>it is necessary.
>
>MW
>
> > -----Original Message-----
> > From: owner-informix-list@iiug.org
> > [mailto:owner-informix-list@iiug.org]On Behalf Of M.J.R.
> > Sent: Thursday, 5 August 2004 2:49 a.m.
> > To: informix-list@iiug.org
> > Subject: Re: Logbackup failed - ISAM error: cannot allocate memory.
> >
> >
> > The following stats were taken while the instance is
> > running ok ... after I bounced it and was able to
> > restart ontape -c. If/when it decides to give the
> > ISAM error again, I'll redo the commands and repost.
> > BTW ... the online.log file gave this message, too:
> > shmat: [EMFILE][24]: out of shared memory segments,> > check system SHMSEG
> >
> > Is SHMSEG an AIX enviroment available?
> >
> > onstat -g seg reveals:> > Segment Summary:
> > id key addr size ovhd class
> > blkused blkfree
> > 1703937 1381451777 30000000 751370240 237716 R
> > 183413 27
> > 917506 1381451778 60000000 805306368 25176 V
> > 23091 173517
> > 2490373 1381451779 90000000 1048723456 32608 V
> > 8 256028
> > Total: - - 2605400064 - -
> > 206512 429572
> >
> > (* segment locked in memory)
> >
> > onstat -l reveals:> > Physical Logging
> > Buffer bufused bufsize numpages numwrits pages/io
> > P-1 8 16 348 30 11.60
> > phybegin physize phypos phyused %used
> > 300035 2000 278 24 1.20
> >
> > Logical Logging
> > Buffer bufused bufsize numrecs numpages numwrits
> > recs/pages pages/io
> > L-2 7 16 16601 697 71
> > 23.8 9.8
> > Subsystem numrecs Log Space used
> > OLDRSAM 16601 2764148
> >
> > address number flags uniqid begin size
> > used %used
> > 601a9900 4 U-B---- 12288 400435 1024
> > 1024 100.00
> > 601a9938 5 U-B---- 12289 400835 1024
> > 1024 100.00
> > 601a9970 6 U-B---- 12290 400c35 1024
> > 1024 100.00
> > 601a99a8 7 U-B---- 12291 401035 1024
> > 1024 100.00
> > 601a99e0 8 U-B---- 12292 401435 1024
> > 1024 100.00
> > 601a9a18 9 U-B---- 12293 401835 1024
> > 1024 100.00
> > 601a9a50 10 U-B---- 12294 600803 1024
> > 1024 100.00
> > 601a9a88 11 U-B---- 12295 600c03 1024
> > 1024 100.00
> > 601a9ac0 12 U-B---- 12296 601003 1024
> > 1024 100.00
> > 601a9af8 13 U-B---- 12297 601403 1024
> > 1024 100.00
> > 601a9b30 14 U-B---- 12298 601803 1024
> > 1024 100.00
> > 601a9b68 15 U---C-L 12299 601c03 1024
> > 509 49.71
> > 601a9ba0 16 U-B---- 12250 602003 1024
> > 1024 100.00
> > 601a9bd8 17 U-B---- 12251 602403 1024
> > 1024 100.00
> > 601a9c10 18 U-B---- 12252 602803 1024
> > 1024 100.00
> > 601a9c48 19 U-B---- 12253 602c03 1024
> > 1024 100.00
> > 601a9c80 20 U-B---- 12254 603003 1024
> > 1024 100.00
> > 601a9cb8 21 U-B---- 12255 603403 1024
> > 1024 100.00
> > 601a9cf0 22 U-B---- 12256 603803 1024
> > 1024 100.00
> > 601a9d28 23 U-B---- 12257 603c03 1024
> > 1024 100.00
> > 601a9d60 24 U-B---- 12258 604003 1024
> > 1024 100.00
> > 601a9d98 25 U-B---- 12259 604403 1024
> > 1024 100.00
> > 601a9dd0 26 U-B---- 12260 604803 1024
> > 1024 100.00
> > 601a9e08 27 U-B---- 12261 604c03 1024
> > 1024 100.00
> > 601a9e40 28 U-B---- 12262 605003 1024
> > 1024 100.00
> > 601a9e78 29 U-B---- 12263 605403 1024
> > 1024 100.00
> > 601a9eb0 30 U-B---- 12264 605803 1024
> > 1024 100.00
> > 601a9ee8 31 U-B---- 12265 605c03 1024
> > 1024 100.00
> > 601a9f20 32 U-B---- 12266 606003 1024
> > 1024 100.00
> > 601a9f58 33 U-B---- 12267 606403 1024
> > 1024 100.00
> > 601a9f90 34 U-B---- 12268 606803 1024
> > 1024 100.00
> > 601a9fc8 35 U-B---- 12269 606c03 1024
> > 1024 100.00
> > 60106ac0 1 U-B---- 12270 400035 1024
> > 1024 100.00
> > 60106af8 2 U-B---- 12271 600003 1024
> > 1024 100.00
> > 60106b30 3 U-B---- 12272 600403 1024
> > 1024 100.00
> > 60106b68 36 U-B---- 12273 607003 1024
> > 1024 100.00
> > 60106ba0 37 U-B---- 12274 607403 1024
> > 1024 100.00
> > 60106bd8 38 U-B---- 12275 607803 1024
> > 1024 100.00
> > 60106c10 39 U-B---- 12276 607c03 1024
> > 1024 100.00
> > 60106c48 40 U-B---- 12277 608003 1024
> > 1024 100.00
> > 60106c80 41 U-B---- 12278 608403 1024
> > 1024 100.00
> > 60106cb8 42 U-B---- 12279 608803 1024
> > 1024 100.00
> > 60106cf0 43 U-B---- 12280 608c03 1024
> > 1024 100.00
> > 60106d28 44 U-B---- 12281 609003 1024
> > 1024 100.00
> > 60106d60 45 U-B---- 12282 609403 1024
> > 1024 100.00
> > 60106d98 46 U-B---- 12283 609803 1024
> > 1024 100.00
> > 60106dd0 47 U-B---- 12284 609c03 1024
> > 1024 100.00
> > 60106e08 48