RE: 465 Error reading blob images
Can't seem to find a memory leak (as yet...) Definitely not a disk problem, /tmp and tempspace were fine even though program produced the problem.... still looking for suggestions... I suspect memory allocation somewhere as well, but can't seem to find anything...
VB app connects to EngA and reads through table1. Table1 is actually a synonym in EngB.
Any ideas?
-----Original Message-----
From: owner-informix-list@iiug.org
[mailto:owner-informix-list@iiug.org]On Behalf Of Murray Wood
Sent: Wednesday, May 28, 2003 8:35 PM
To: 'Informix-List (E-mail)'
Subject: RE: 465 Error reading blob images
Look for a memory leak, probably in your VB application. Regularly look at the memory used by each part of all components - engine and application.
MW
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org]On Behalf Of Zunino, Kathy
> Sent: Thursday, 29 May 2003 1:58 p.m.
> To: Informix-List (E-mail)
> Subject: 465 Error reading blob images
>
>
> Using IDS 9.30.FC1 on HPUX 11i, we're having some problems
> with reading blob images. We're working on a project to read
> in large numbers of blob images and store them off onto
> another media (outside of the Informix engine). Our VB
> program runs along fine for many hours, then sporadically in
> the middle of the night, it gets a "-465 No more memory for
> locator buffer." error and dies. This program does mostly
> reads. The program only seems to get this error when we have
> more than 1 session running, and each session runs for over 8
> hours before we start seeing this error.
>
> select debid ,credfo from dcs_blob:table1
> where (debid = ? ) AND (accid = ? )>
> and sometimes:
>
> update dcs_blob:table1 set path = ? where
> (debid = ? ) AND (accid = ? )
>
> The error comes up on the read statement. Any clue what's
> going on? What resource am I running out of? (and why am I
> running out of it after 8 to 12 hours of processing?) (I do
> have an case open with Tech Support - they suggested that I'm
> running out of /tmp or tempspace which I'll test for tonight.)
>
> TIA!
>
>
> (Simplified) table schema:
>
> create table table1 (
> debid integer ,
> accid smallint ,
> hitflag char(1),
> path char(80),
> credfo text in ods_blobspace,
> updatedatetime datetime year to second
> default current year to second
> ) in ods_dbspace11 extent size 160000 next size 16000 lock mode row;>
> create unique index xstcreditrptpkey on stcreditreport
> (debid,accid) using btree in ods_dbspace10 ;
> alter table stcreditreport add constraint primary
> key (debid,accid) constraint ustcrdrep_credrqst ;>
>
> ods_blobspace contains about 70 GB of blob images at 10K blobpage.
>
> -- ~~~~~~~~~~~~~~~~~~~~~~
> K Zunino
> -- ~~~~~~~~~~~~~~~~~~~~~~
>
>
>
>
>
>
>
>
> **********************************************************************
> Privileged/Confidential information may be contained in this
> message.
> If you are not an addressee indicated in this message (or responsible
> for delivery of the message to such person[s]), you may not copy or
> deliver this message to anyone. If you have received this message in
> error, you should destroy and delete it from your computer and notify
> the sender by reply email. Opinions, conclusions and other
> information
> in this message that do not relate to the official business of
> Diversified Collection Services shall be understood as neither given
> nor endorsed by the company. Accordingly, Diversified Collection
> Services disclaims all responsibility and accepts no
> responsibility for
> the consequences of any person(s) acting, or refraining from acting,
> on such information prior to the receipt by that person(s) of
> subsequent written confirmation.
> **********************************************************************
>
>