Anthony Presley
2004-11-23 23:10:14 UTC
Hi all,
Not being very thrilled w/ Informix's "quality" these past few months.
Have a stickler of a problem though.
Yesterday, I tried pulling up a blob out of our db, with id [primary
key] of 17845. It came up saying something about the blob stamp, and
that I needed to run oncheck on it. So I did, and it found an error
in the page, and fixed it.
Today, after trying to fetch it again, it did the same thing. So I
figured, hmm ... we don't need the data, so I'll just delete it. At
which point all hell breaks loose. The system went down hard --
Informix just died. It won't come up with a standard "oninit -v".
When trying to get it into quiescient mode, I get a LOT in my log
files [Below].
However, I can't keep it up long enough to DO anything. How do I tell
it to IGNORE the log files while coming up? Surely there's a way?
It seems that it had an error deleting the row, which caused a problem
in the index, and the index got marked as invalid. Now, b/c of the
logs, it can't roll them forward, and dies. Seems a "relatively"
small problem.
Would love some help, probably willing to pay for a fix. This is the
second time in one year this has happened -- and I don't remember what
I did last time to fix it.
Also, I HAVE tried running what it suggests: oncheck -pt 4194496, b/c
the db DOES come up for about 3 seconds before crashing. However, I
end up getting the error "ISAM error: Primary and Mirror chunks are
bad" on that.
How do I fix?
Thanks so much.
--Anthony
17:28:34 Event alarms enabled. ALARMPROG =
'/opt/informix/etc/eventalarm'
17:28:42 DR: DRAUTO is 0 (Off)
17:28:43 Informix Dynamic Server Version 7.31.UD2 Software Serial
Number AAD#J306433
17:28:43 Informix Dynamic Server Initialized -- Shared Memory
Initialized.
17:28:43 Physical Recovery Started.
17:28:43 Physical Recovery Complete: 696 Pages Restored.
17:28:43 Logical Recovery Started.
17:28:43 Rollforward of log record failed. iserrno = 126
17:28:43 Log Record: log = 8374, pos = 622018, type =
OLDRSAM:PBDELETE(39), trans = 262
17:28:43 Assert Failed: pthdrpage:ptalloc:bad bfget
17:28:43 Informix Dynamic Server Version 7.31.UD2
17:28:43 Who: Session(12, ***@corp.inventconnect.com, 0,
1000833944)
Thread(141, xchg_1.4, 3ba6845c, 1)
File: rspartn.c Line: 5364
17:28:43 Results: Cannot use TBLSpace page for TBLSpace 4194496
17:28:43 Action: Run 'oncheck -pt 4194496'
17:28:44 See Also: /tmp/af.475b99a
17:28:44 Assert Failed: Error during recovery left index
inconsistent.
17:28:44 Informix Dynamic Server Version 7.31.UD2
17:28:44 Who: Session(12, ***@corp.inventconnect.com, 0,
1000833944)
Thread(141, xchg_1.4, 3ba6845c, 1)
File: rskey.c Line: 1374
17:28:44 Results: Index 'Cannot use TBLSpace page for TBLSpace
4194496Key#7' is now unusable
17:28:44 Action: Run 'oncheck -cI Cannot use TBLSpace page for
TBLSpace 4194496Key#7'
17:28:44 See Also: /tmp/af.475b99a
17:28:44 Rollforward of log record failed. iserrno = 172
17:28:44 Log Record: log = 8374, pos = 63c234, type =
OLDRSAM:ADDITEM(28), trans = 229
17:28:44 Rollforward of log record failed. iserrno = 172
17:28:44 Log Record: log = 8374, pos = 63c234, type =
OLDRSAM:ADDITEM(28), trans = 229
17:28:44 Assert Failed: No Exception Handler
17:28:44 Informix Dynamic Server Version 7.31.UD2
17:28:44 Who: Session(12, ***@corp.inventconnect.com, 0,
1000829576)
Thread(147, xchg_2.0, 3ba6a244, 1)
File: mtex.c Line: 450
17:28:44 Results: Exception Caught. Type: MT_EX_OS, Context: mem
17:28:44 Action: Please notify Informix Technical Support.
17:28:47 Assert Failed: Chunk 4 is being taken OFFLINE.
17:28:47 Informix Dynamic Server Version 7.31.UD2
17:28:47 Who: Session(12, ***@corp.inventconnect.com, 0,
1000831032)
Thread(139, xchg_1.2, 3ba67a64, 3)
File: rsmirror.c Line: 1784
17:28:47 Results: Dynamic Server will block at next checkpoint
17:28:47 Action: Shutdown (onmode -k) or override (onmode -O)
17:28:47 See Also: /tmp/af.473b99a
17:28:47 Rollforward of log record failed. iserrno = 126
17:28:47 Log Record: log = 8374, pos = 622018, type =
OLDRSAM:PBDELETE(39), trans = 262
17:28:48 See Also: /tmp/af.47bb99b, shmem.47bb99b.0
17:29:07 mtex.c, line 450, thread 147, proc id 3639, No Exception
Handler.
17:29:09 PANIC: Attempting to bring system down
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Requested shared memory segment size rounded from 50502KB to
50504KB
Tue Nov 23 17:30:30 2004
17:30:30 Event alarms enabled. ALARMPROG =
'/opt/informix/etc/eventalarm'
17:30:39 DR: DRAUTO is 0 (Off)
17:30:40 Informix Dynamic Server Version 7.31.UD2 Software Serial
Number AAD#J306433
17:30:40 Informix Dynamic Server Initialized -- Shared Memory
Initialized.
17:30:40 Physical Recovery Started.
17:30:40 Physical Recovery Complete: 696 Pages Restored.
17:30:40 Logical Recovery Started.
17:30:40 Rollforward of log record failed. iserrno = 126
17:30:40 Log Record: log = 8374, pos = 622018, type =
OLDRSAM:PBDELETE(39), trans = 262
17:30:40 Rollforward of log record failed. iserrno = 126
17:30:40 Log Record: log = 8374, pos = 632040, type =
OLDRSAM:HUPDATE(73), trans = 257
17:30:45 Assert Failed: Chunk 4 is being taken OFFLINE.
17:30:45 Informix Dynamic Server Version 7.31.UD2
17:30:45 Who: Session(12, ***@corp.inventconnect.com, 0,
1000831032)
Thread(139, xchg_1.2, 3ba67a64, 1)
File: rsmirror.c Line: 1784
17:30:45 Results: Dynamic Server will block at next checkpoint
17:30:45 Action: Shutdown (onmode -k) or override (onmode -O)
17:30:45 See Also: /tmp/af.473ba0f
17:30:45 Rollforward of log record failed. iserrno = 126
17:30:45 Log Record: log = 8374, pos = 622018, type =
OLDRSAM:PBDELETE(39), trans = 262
17:30:45 Assert Failed: Chunk 4 is being taken OFFLINE.
17:30:45 Informix Dynamic Server Version 7.31.UD2
17:30:45 Who: Session(12, ***@corp.inventconnect.com, 0,
1000832124)
Thread(146, xchg_1.9, 3ba69d48, 1)
File: rsmirror.c Line: 1784
17:30:45 Results: Dynamic Server will block at next checkpoint
17:30:45 Action: Shutdown (onmode -k) or override (onmode -O)
17:30:46 See Also: /tmp/af.47aba0f
17:30:46 Rollforward of log record failed. iserrno = 126
17:30:46 Log Record: log = 8374, pos = 632040, type =
OLDRSAM:HUPDATE(73), trans = 257
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 632098, type =
OLDRSAM:ADDITEM(28), trans = 257
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 632098, type =
OLDRSAM:ADDITEM(28), trans = 257
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6320d8, type =
OLDRSAM:DELITEM(29), trans = 257
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6320d8, type =
OLDRSAM:DELITEM(29), trans = 257
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 632118, type =
OLDRSAM:ADDITEM(28), trans = 257
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 632118, type =
OLDRSAM:ADDITEM(28), trans = 257
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63214c, type =
OLDRSAM:DELITEM(29), trans = 257
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63214c, type =
OLDRSAM:DELITEM(29), trans = 257
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636040, type =
OLDRSAM:UNIQID(17), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636040, type =
OLDRSAM:UNIQID(17), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6360cc, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6360cc, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636100, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636100, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636134, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636134, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636168, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636168, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63619c, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63619c, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6361d4, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6361d4, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636218, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636218, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636250, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636250, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a040, type =
OLDRSAM:UNIQID(17), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a040, type =
OLDRSAM:UNIQID(17), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a0d4, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a0d4, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a108, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a108, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a13c, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a13c, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a170, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a170, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a1a4, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a1a4, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a1dc, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a1dc, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a224, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a224, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63708c, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63708c, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6370c0, type =
OLDRSAM:DELITEM(29), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6370c0, type =
OLDRSAM:DELITEM(29), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6370f4, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6370f4, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 637134, type =
OLDRSAM:DELITEM(29), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 637134, type =
OLDRSAM:DELITEM(29), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 637174, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 637174, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6371a8, type =
OLDRSAM:DELITEM(29), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6371a8, type =
OLDRSAM:DELITEM(29), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a25c, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a25c, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c040, type =
OLDRSAM:UNIQID(17), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c040, type =
OLDRSAM:UNIQID(17), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c0c8, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c0c8, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c0fc, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c0fc, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c130, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c130, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c164, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c164, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c198, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e130, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e130, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e164, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e164, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e198, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e198, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e1cc, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e1cc, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e200, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e200, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e234, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e234, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Assert Failed: No Exception Handler
17:30:46 Informix Dynamic Server Version 7.31.UD2
17:30:46 Who: Session(12, ***@corp.inventconnect.com, 0,
1000829576)
Thread(147, xchg_2.0, 3ba6a244, 3)
File: mtex.c Line: 450
17:30:46 Results: Exception Caught. Type: MT_EX_OS, Context: mem
17:30:46 Action: Please notify Informix Technical Support.
17:30:50 See Also: /tmp/af.47bba16, shmem.47bba16.0
17:31:11 mtex.c, line 450, thread 147, proc id 4277, No Exception
Handler.
17:31:13 PANIC: Attempting to bring system down
Not being very thrilled w/ Informix's "quality" these past few months.
Have a stickler of a problem though.
Yesterday, I tried pulling up a blob out of our db, with id [primary
key] of 17845. It came up saying something about the blob stamp, and
that I needed to run oncheck on it. So I did, and it found an error
in the page, and fixed it.
Today, after trying to fetch it again, it did the same thing. So I
figured, hmm ... we don't need the data, so I'll just delete it. At
which point all hell breaks loose. The system went down hard --
Informix just died. It won't come up with a standard "oninit -v".
When trying to get it into quiescient mode, I get a LOT in my log
files [Below].
However, I can't keep it up long enough to DO anything. How do I tell
it to IGNORE the log files while coming up? Surely there's a way?
It seems that it had an error deleting the row, which caused a problem
in the index, and the index got marked as invalid. Now, b/c of the
logs, it can't roll them forward, and dies. Seems a "relatively"
small problem.
Would love some help, probably willing to pay for a fix. This is the
second time in one year this has happened -- and I don't remember what
I did last time to fix it.
Also, I HAVE tried running what it suggests: oncheck -pt 4194496, b/c
the db DOES come up for about 3 seconds before crashing. However, I
end up getting the error "ISAM error: Primary and Mirror chunks are
bad" on that.
How do I fix?
Thanks so much.
--Anthony
17:28:34 Event alarms enabled. ALARMPROG =
'/opt/informix/etc/eventalarm'
17:28:42 DR: DRAUTO is 0 (Off)
17:28:43 Informix Dynamic Server Version 7.31.UD2 Software Serial
Number AAD#J306433
17:28:43 Informix Dynamic Server Initialized -- Shared Memory
Initialized.
17:28:43 Physical Recovery Started.
17:28:43 Physical Recovery Complete: 696 Pages Restored.
17:28:43 Logical Recovery Started.
17:28:43 Rollforward of log record failed. iserrno = 126
17:28:43 Log Record: log = 8374, pos = 622018, type =
OLDRSAM:PBDELETE(39), trans = 262
17:28:43 Assert Failed: pthdrpage:ptalloc:bad bfget
17:28:43 Informix Dynamic Server Version 7.31.UD2
17:28:43 Who: Session(12, ***@corp.inventconnect.com, 0,
1000833944)
Thread(141, xchg_1.4, 3ba6845c, 1)
File: rspartn.c Line: 5364
17:28:43 Results: Cannot use TBLSpace page for TBLSpace 4194496
17:28:43 Action: Run 'oncheck -pt 4194496'
17:28:44 See Also: /tmp/af.475b99a
17:28:44 Assert Failed: Error during recovery left index
inconsistent.
17:28:44 Informix Dynamic Server Version 7.31.UD2
17:28:44 Who: Session(12, ***@corp.inventconnect.com, 0,
1000833944)
Thread(141, xchg_1.4, 3ba6845c, 1)
File: rskey.c Line: 1374
17:28:44 Results: Index 'Cannot use TBLSpace page for TBLSpace
4194496Key#7' is now unusable
17:28:44 Action: Run 'oncheck -cI Cannot use TBLSpace page for
TBLSpace 4194496Key#7'
17:28:44 See Also: /tmp/af.475b99a
17:28:44 Rollforward of log record failed. iserrno = 172
17:28:44 Log Record: log = 8374, pos = 63c234, type =
OLDRSAM:ADDITEM(28), trans = 229
17:28:44 Rollforward of log record failed. iserrno = 172
17:28:44 Log Record: log = 8374, pos = 63c234, type =
OLDRSAM:ADDITEM(28), trans = 229
17:28:44 Assert Failed: No Exception Handler
17:28:44 Informix Dynamic Server Version 7.31.UD2
17:28:44 Who: Session(12, ***@corp.inventconnect.com, 0,
1000829576)
Thread(147, xchg_2.0, 3ba6a244, 1)
File: mtex.c Line: 450
17:28:44 Results: Exception Caught. Type: MT_EX_OS, Context: mem
17:28:44 Action: Please notify Informix Technical Support.
17:28:47 Assert Failed: Chunk 4 is being taken OFFLINE.
17:28:47 Informix Dynamic Server Version 7.31.UD2
17:28:47 Who: Session(12, ***@corp.inventconnect.com, 0,
1000831032)
Thread(139, xchg_1.2, 3ba67a64, 3)
File: rsmirror.c Line: 1784
17:28:47 Results: Dynamic Server will block at next checkpoint
17:28:47 Action: Shutdown (onmode -k) or override (onmode -O)
17:28:47 See Also: /tmp/af.473b99a
17:28:47 Rollforward of log record failed. iserrno = 126
17:28:47 Log Record: log = 8374, pos = 622018, type =
OLDRSAM:PBDELETE(39), trans = 262
17:28:48 See Also: /tmp/af.47bb99b, shmem.47bb99b.0
17:29:07 mtex.c, line 450, thread 147, proc id 3639, No Exception
Handler.
17:29:09 PANIC: Attempting to bring system down
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Segment locked: addr=0x10000000, size=731848704
17:30:29 Requested shared memory segment size rounded from 50502KB to
50504KB
Tue Nov 23 17:30:30 2004
17:30:30 Event alarms enabled. ALARMPROG =
'/opt/informix/etc/eventalarm'
17:30:39 DR: DRAUTO is 0 (Off)
17:30:40 Informix Dynamic Server Version 7.31.UD2 Software Serial
Number AAD#J306433
17:30:40 Informix Dynamic Server Initialized -- Shared Memory
Initialized.
17:30:40 Physical Recovery Started.
17:30:40 Physical Recovery Complete: 696 Pages Restored.
17:30:40 Logical Recovery Started.
17:30:40 Rollforward of log record failed. iserrno = 126
17:30:40 Log Record: log = 8374, pos = 622018, type =
OLDRSAM:PBDELETE(39), trans = 262
17:30:40 Rollforward of log record failed. iserrno = 126
17:30:40 Log Record: log = 8374, pos = 632040, type =
OLDRSAM:HUPDATE(73), trans = 257
17:30:45 Assert Failed: Chunk 4 is being taken OFFLINE.
17:30:45 Informix Dynamic Server Version 7.31.UD2
17:30:45 Who: Session(12, ***@corp.inventconnect.com, 0,
1000831032)
Thread(139, xchg_1.2, 3ba67a64, 1)
File: rsmirror.c Line: 1784
17:30:45 Results: Dynamic Server will block at next checkpoint
17:30:45 Action: Shutdown (onmode -k) or override (onmode -O)
17:30:45 See Also: /tmp/af.473ba0f
17:30:45 Rollforward of log record failed. iserrno = 126
17:30:45 Log Record: log = 8374, pos = 622018, type =
OLDRSAM:PBDELETE(39), trans = 262
17:30:45 Assert Failed: Chunk 4 is being taken OFFLINE.
17:30:45 Informix Dynamic Server Version 7.31.UD2
17:30:45 Who: Session(12, ***@corp.inventconnect.com, 0,
1000832124)
Thread(146, xchg_1.9, 3ba69d48, 1)
File: rsmirror.c Line: 1784
17:30:45 Results: Dynamic Server will block at next checkpoint
17:30:45 Action: Shutdown (onmode -k) or override (onmode -O)
17:30:46 See Also: /tmp/af.47aba0f
17:30:46 Rollforward of log record failed. iserrno = 126
17:30:46 Log Record: log = 8374, pos = 632040, type =
OLDRSAM:HUPDATE(73), trans = 257
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 632098, type =
OLDRSAM:ADDITEM(28), trans = 257
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 632098, type =
OLDRSAM:ADDITEM(28), trans = 257
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6320d8, type =
OLDRSAM:DELITEM(29), trans = 257
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6320d8, type =
OLDRSAM:DELITEM(29), trans = 257
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 632118, type =
OLDRSAM:ADDITEM(28), trans = 257
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 632118, type =
OLDRSAM:ADDITEM(28), trans = 257
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63214c, type =
OLDRSAM:DELITEM(29), trans = 257
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63214c, type =
OLDRSAM:DELITEM(29), trans = 257
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636040, type =
OLDRSAM:UNIQID(17), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636040, type =
OLDRSAM:UNIQID(17), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6360cc, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6360cc, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636100, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636100, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636134, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636134, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636168, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636168, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63619c, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63619c, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6361d4, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6361d4, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636218, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636218, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636250, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 636250, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a040, type =
OLDRSAM:UNIQID(17), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a040, type =
OLDRSAM:UNIQID(17), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a0d4, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a0d4, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a108, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a108, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a13c, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a13c, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a170, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a170, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a1a4, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a1a4, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a1dc, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a1dc, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a224, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a224, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63708c, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63708c, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6370c0, type =
OLDRSAM:DELITEM(29), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6370c0, type =
OLDRSAM:DELITEM(29), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6370f4, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6370f4, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 637134, type =
OLDRSAM:DELITEM(29), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 637134, type =
OLDRSAM:DELITEM(29), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 637174, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 637174, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6371a8, type =
OLDRSAM:DELITEM(29), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 6371a8, type =
OLDRSAM:DELITEM(29), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a25c, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63a25c, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c040, type =
OLDRSAM:UNIQID(17), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c040, type =
OLDRSAM:UNIQID(17), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c0c8, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c0c8, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c0fc, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c0fc, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c130, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c130, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c164, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c164, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63c198, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e130, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e130, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e164, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e164, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e198, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e198, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e1cc, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e1cc, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e200, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e200, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e234, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Rollforward of log record failed. iserrno = 101
17:30:46 Log Record: log = 8374, pos = 63e234, type =
OLDRSAM:ADDITEM(28), trans = 229
17:30:46 Assert Failed: No Exception Handler
17:30:46 Informix Dynamic Server Version 7.31.UD2
17:30:46 Who: Session(12, ***@corp.inventconnect.com, 0,
1000829576)
Thread(147, xchg_2.0, 3ba6a244, 3)
File: mtex.c Line: 450
17:30:46 Results: Exception Caught. Type: MT_EX_OS, Context: mem
17:30:46 Action: Please notify Informix Technical Support.
17:30:50 See Also: /tmp/af.47bba16, shmem.47bba16.0
17:31:11 mtex.c, line 450, thread 147, proc id 4277, No Exception
Handler.
17:31:13 PANIC: Attempting to bring system down