SPL routine error 721 during data import

Hi all, is there anybody who is able to give me some hints about this error? I have red the finderr output, but it won' help! ----------------------- update sch_save set (gwg) = (_gwg) where (and (and (= styc, _styc_typ), (= waeh, 0)), (= gwg, " "));expression:(= TRIM ( BOTH ' ' FROM as_rpk), "DEFAULT") evaluates to f exception : looking for handler SQL error = -721 ISAM error = 0 error string = = "AAAC8g"exception : no appropriate handler ----------------------- 17:16:06 17:16:06 Informix Dynamic Server Version 9.40.UC1 Software Serial Number 17:16:06 Assert Failed: Condition Failed (Memory pointer (0x7c051fe0) freed twice), In (mt_shm_free) 17:16:06 Who: Session(32, informix@madb01, 2927, 0x7b4afd18) Thread(3184, sqlexec, 7b485b88, 3) File: mtshpool.c Line: 3132 17:16:06 Action: Please notify Informix Technical Support. 17:16:06 Stack for thread: 3184 sqlexec base: 0x7ceea000 len: 266240 pc: 0x085cfa2b tos: 0x7cf2a2c0 state: running vp: 3 --------------------------- Thanks Sven -----Ursprüngliche Nachricht----- Von: Gerd Kaluzi.... [mailto:gerd.kaluzinski@bytec.de] Gesendet: Donnerstag, 3. Juli 2003 09:11 An: ids@iiug.org Betreff: Re: Enhanced ALARMPROGRAM for backups [1480] Why not simply use the ALARMPROGRAM to catch the logid which is full. Event 23 is initiated each time a log becomes full. BUNNY On Thu, 3 Jul 2003 01:45:55 -0400 (EDT) "CHRIS PRIEST" <chris.priest@asic.gov.au> wrote: > Hi There, > > I want to be able to create a new file for every log backup switch. I was thinking of doing the following > > 1) have the script use perl:dbi to get current log number > 2) run the ontape -a > 3) copy the file to contain the log_number > 4) touch a new file for LTAPEDEV > 5) have an OS job rsync these log_numbered files offsite. > > In this way I have a set of files that tell me exactly what logs should be in them. Similar to Oracle archive redo logs. > > Is this a valid approach or is there a better way of doing this. I can't have a tape device ( or want one ). > > Regards > > Chris > -- Mit freundlichen Grüßen Gerd Kaluzinski \\\\\\\\|// (o o) --------------------------------------------------ooO-(_)-Ooo--- Gerd Kaluzinski mailto:gerd.kaluzinski@bytec.de Manager Consulting mailto:support@bytec.de Informix Certified Senior System Engineer http://www.bytec.de BYTEC GmbH Telefon: 07541-585-1019 Hermann-Metzger-Str. 7 Fax : 07541-585-2019 88045 Friedrichshafen Ooo. -------------------------------------------------.ooO----( )--- ( ) (_/ \\\\_)

This is an engine bug. You should report it to Informix Technical Support. Michael Schuran, Sven wrote: > Hi all, > > is there anybody who is able to give me some hints about this error? > I have red the finderr output, but it won' help! > > > ----------------------- > update sch_save set > (gwg) = (_gwg) > where (and (and (= styc, _styc_typ), (= waeh, 0)), (= gwg, " "));> expression:(= TRIM ( BOTH ' ' FROM as_rpk), "DEFAULT") > evaluates to f > exception : looking for handler > SQL error = -721 ISAM error = 0 error string = = "AAAC8g"> exception : no appropriate handler > ----------------------- > > > 17:16:06 > 17:16:06 Informix Dynamic Server Version 9.40.UC1 Software Serial Number > > 17:16:06 Assert Failed: Condition Failed (Memory pointer (0x7c051fe0) freed twice), In (mt_shm_free) > 17:16:06 Who: Session(32, informix@madb01, 2927, 0x7b4afd18) > Thread(3184, sqlexec, 7b485b88, 3) > File: mtshpool.c Line: 3132 > 17:16:06 Action: Please notify Informix Technical Support. > 17:16:06 Stack for thread: 3184 sqlexec > > base: 0x7ceea000 > len: 266240 > pc: 0x085cfa2b > tos: 0x7cf2a2c0 > state: running > vp: 3 > > --------------------------- > > Thanks Sven > > > -----Ursprüngliche Nachricht----- > Von: Gerd Kaluzi.... [mailto:gerd.kaluzinski@bytec.de] > Gesendet: Donnerstag, 3. Juli 2003 09:11 > An: ids@iiug.org > Betreff: Re: Enhanced ALARMPROGRAM for backups [1480] > > > Why not simply use the ALARMPROGRAM to catch the logid which is full. Event 23 is initiated each time a log becomes full. > > BUNNY > > On Thu, 3 Jul 2003 01:45:55 -0400 (EDT) > "CHRIS PRIEST" <chris.priest@asic.gov.au> wrote: > > >> Hi There, >> >> I want to be able to create a new file for every log backup switch. I was thinking of doing the following >> >> 1) have the script use perl:dbi to get current log number >> 2) run the ontape -a >> 3) copy the file to contain the log_number >> 4) touch a new file for LTAPEDEV >> 5) have an OS job rsync these log_numbered files offsite. >> >> In this way I have a set of files that tell me exactly what logs should be in them. Similar to Oracle archive redo logs. >> >> Is this a valid approach or is there a better way of doing this. I can't have a tape device ( or want one ). >> >>Regards >> >> Chris >> > > > -- === Michael Mueller ================== Tel. + 49 8171 63600 Fax. + 49 8171 63615 Web: http://www.mm.kay-mueller.de http://www.planets.kay-mueller.de ======================================