RE: Logical recovery failiure

And when you placed a support call with Informix they said ??? What changes have been made recently? 7.30.TC3 is very old, the first even reasonably stable version for NT. It also means you must be NT SP3 or earlier - not Y2K compliant! I suggest you upgrade the engine, then apply SP6 to NT. They problem could be anywhere. You do have plenty of memory don't you? MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Mitja Zabukovec Sent: Thursday, November 23, 2000 8:52 PM To: informix-list@iiug.org Subject: Logical recovery failiure Hello, I'm taking care of installation of an application, that uses Informix DB server, version 7.3 and I have this problem: every 2 weeks or so DB server stops for no obvious reason and in logs are this errors: IEEC events: 1) Logical recovery failiure, restore operation failed while recovering database transactions from the logical log ( repeated 3 times ) 2) An internal subsystem failiure alert occured 'MT' ( repeated 2 times ) At the bottom of thi mail is the piece of af.xxx file, that was generated when the error occured. Logical log backup is made to the disk, dbspaces were created onto raw device. At the time this error occurs, application doesn't do anything extraordinary. It does only things, that it does all the time, that is, it fills the database with records that come from the network of electronic door locks. After I restart the database, everything works fine. Does anybody know, what might be the problem ? Regards, Mitja Zabukovec af.xxx : 07:39:04 logundo: type 29, iserrno 101 07:39:04 07:39:04 Informix Dynamic Server Version 7.30.TC3 07:39:04 Assert Failed: Rollback error 101 07:39:04 Who: Session(1930, guard@MORS_OVS1234, 117, 0) Thread(1968, sqlexec, 0, 1) File: r:\\rsam\\rstrans.c Line: 2116 07:39:04 Results: Log record (OLDRSAM:DELITEM) in log 572, offset0x24e410 was not rolled back 07:39:04 Action: Use 'onlog' to view the transaction and repair manually. ........... C:\\INFORMIX\\bin\\onstat -g ses 1930: Informix Dynamic Server Version 7.30.TC3 -- On-Line -- Up 7 days 15:59:12 -- 142656 Kbytes session #RSAM total used id user tty pid hostname threads memory memory 1930 guard MORS_OVS 117 MORS_OVS 1 38649856 33109576 tid name rstcb flags curstk status 1968 sqlexec 11b90518 --RPX-- 580 11b90518 running Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag 1930 V 11f48018 38649856 5540280 99189 7831 name free used name free used overhead 0 120 scb 0 96 opentable 0 26823040 filetable 0 2792 ru 0 224 misc 0 152 blobio 0 9176 log 0 4200 temprec 0 2376 blob 0 2560 ralloc 0 513928 gentcb 0 12200 ostcb 0 2024 sort 0 56 sqscb 0 19784 rdahead 0 640 hashfiletab 0 280 osenv 0 736 buft_buffer 0 920 sqtcb 0 3559976 fragman 0 2154296 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers 1930 INSERT guard CR Wait 5 -242 -101 9.20 Current SQL statement : INSERT INTO lognetc (dttm ,idregistry ,idregstatus ,idtpmessage ,idevent ,nbcard ,idcompany ,idcontrol ,idcomment ,addcomment ,color ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Last parsed SQL statement : INSERT INTO lognetc (dttm ,idregistry ,idregstatus ,idtpmessage ,idevent ,nbcard ,idcompany ,idcontrol ,idcomment ,addcomment ,color ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ===========------------- - - - - - - C:\\INFORMIX\\bin\\onstat -g sql 1930: Informix Dynamic Server Version 7.30.TC3 -- On-Line -- Up 7 days 15:59:12 -- 142656 Kbytes Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers 1930 INSERT guard CR Wait 5 -242 -101 9.20 Current SQL statement : INSERT INTO lognetc (dttm ,idregistry ,idregstatus ,idtpmessage ,idevent ,nbcard ,idcompany ,idcontrol ,idcomment ,addcomment ,color ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Last parsed SQL statement : INSERT INTO lognetc (dttm ,idregistry ,idregstatus ,idtpmessage ,idevent ,nbcard ,idcompany ,idcontrol ,idcomment ,addcomment ,color ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ------------------------ C:\\INFORMIX\\bin\\onstat -c: Informix Dynamic Server Version 7.30.TC3 -- On-Line -- Up 7 days 15:59:12 -- 142656 Kbytes Configuration File: C:\\INFORMIX/etc/ONCONFIG.ol_guarddbs #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig.std # Description: Informix Dynamic Server Configuration Parameters # #************************************************************************** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name # ROOTPATH C:\\IFMXDATA\\ol_guarddbs\\rootdbs_dat.000 # Path for devicecontaining root dbspace ROOTPATH \\\\.\\H: ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 102400 # Size of root dbspace (Kbytes)# Disk Mirroring Configuration Parameters MIRROR 1 # Mirroring flag (Yes = 1, No = 0) # MIRRORPATH D:\\IFMXDATA\\ol_guarddbs\\rootdbs_mirr.000 # Path for device containing mirrored root MIRRORPATH \\\\.\\I: MIRROROFFSET 0 # Offset into mirrored device (Kbytes)# Physical Log Configuration PHYSDBS rootdbs # Location (dbspace) of physical log PHYSFILE 2000 # Physical log file size (Kbytes)# Logical Log Configuration LOGFILES 15 # Number of logical log files LOGSIZE 500 # Logical log size (Kbytes)LOG_BACKUP_MODE CONT # Logical log backup mode (MANUAL, CONT) # Diagnostics MSGPATH C:\\INFORMIX\\ol_guarddbs.log # System message log file path CONSOLE C:\\INFORMIX\\conol_guarddbs.log # System console message path ALARMPROGRAM C:\\INFORMIX\\etc\\log_full.bat # Alarm program path # System Diagnostic Script. # SYSALARMPROGRAM - Full path of the system diagnostic script (e.g. # c:\\informix\\etc\\evidence.bat.) Set this parameter # if you want a different Diagnostic Script than # {INFORMIXDIR}\\etc\\evidence.bat, which is default. # System Archive Tape Device # TAPEDEV