logical log back up failed
Posted in 2010
Topics: Backup & Restore, Error Codes & Troubleshooting, Logging & Checkpoints
the error happend twice in one month ,i think it is a informix internal bug
,pls help to confirm ,the error is :
05:21:19
05:21:19 IBM Informix Dynamic Server Version 9.40.FC7W4 Software Serial Number
AAA#B000000
05:21:19 Assert Warning: ISAM error: An error has occurred during logical log
back up.
05:21:19 Who: Session(2229190, informix@SCP3A, 1511, 128c2ba08)
Thread(2267368, ontape, 13508fca8, 1)
File: rsarcutl.c Line: 120
05:21:19 Action: isopen_logbu()/alloc_tQ()
05:21:19 Stack for thread: 2267368 ontape
base: 0x000000012a07f000
len: 69632
pc: 0x00000001008918bc
tos: 0x000000012a08dfa1
state: running
vp: 1
0x1008918bc oninit :: afstack + 0x34 sp=0x12a08e7a0(0x1352b93e0, 0x12ff91c20,
0x100000f, 0x0, 0x100f19948, 0x12a08ed30)
0x100890914 oninit :: afhandler + 0xb0c sp=0x12a08ea70
delta_sp=720(0x100cef970, 0x100e32190, 0x100e31dd8, 0x401, 0x1, 0x100f2f948)
0x10088fd9c oninit :: afwarn_interface + 0x4c sp=0x12a08f190
delta_sp=1824(0x12a08f61c, 0x0, 0x100e32190, 0x100e31dd8, 0x78, 0x129fb9568)
0x1006adc64 oninit :: oops_error + 0xc4 sp=0x12a08f250
delta_sp=192(0x12a08f61c, 0x100e32190, 0xad, 0x100f303c0, 0x129fb9568, 0x4)
0x1006b4178 oninit :: isopen_logbu + 0xa74 sp=0x12a08f310
delta_sp=192(0x10a06d800, 0x100f2f778, 0x100f303c0, 0x129f7cf20, 0x100f22a14,
0x100f20a14)
0x10028b20c oninit :: sqisopen_logbu + 0x50 sp=0x12a08f470 delta_sp=352(0x1,
0x3ff800, 0x3ff800, 0x4, 0x12a08f60c, 0x12a08f608)
0x1004b29a8 oninit :: tbj_open_logbackup + 0x78 sp=0x12a08f540
delta_sp=208(0xe, 0x4, 0x0, 0x2e38313900, 0x129ef8ee8, 0x0)
0x10047d1a4 oninit :: sqmain + 0xd3c sp=0x12a08fa20 delta_sp=1248(0x53,
0x1338, 0x12a08fe00, 0x100f2b740, 0x100f2f938, 0x1400)
0x1008bab70 oninit :: listen_verify + 0x5ec sp=0x12a08faf0 delta_sp=208(0x210,
0x100d42848, 0x0, 0x100ceb530, 0x0, 0x12a0430f8)
0x100866630 oninit :: startup + 0xfc sp=0x12a08fe50 delta_sp=864(0x100f2f948,
0x0, 0x100f19958, 0x128815b70, 0x12960d028, 0x128815af8)
05:21:19 See Also: /opt/informix/tmp/af.9cd07aae
---------------------------------
Begin System Alarm Program Output
---------------------------------
Assertion Failure Type: Warning
Host Name: SCP3A
Database Server Name: scp_online
Time of failure: Sunday April 18 05:21:20 SAST 2010
AF file: /opt/informix/tmp/af.9cd07aae
Shared memory file: None
System Blocking: OFF
-------------------------------
End System Alarm Program Output
-------------------------------
05:21:20 sh /opt/informix/etc/evidence.sh 1 0 /opt/informix/tmp/af.9cd07aae
2229190 0x3508fca8 2267368 0x352b93e0 1025 0 0 0 0
05:21:20
------------------ End of assertion failure 0 -----------------
Maybe it is time to migrate to a supported version?
On Wed, May 5, 2010 at 11:27 AM, CHEN JIAN <cjneiep@126.com> wrote:
> the error happend twice in one month ,i think it is a informix internal bug
> ,pls help to confirm ,the error is :
>
> 05:21:19
> 05:21:19 IBM Informix Dynamic Server Version 9.40.FC7W4 Software Serial
> Number
> AAA#B000000
>
> 05:21:19 Assert Warning: ISAM error: An error has occurred during logical
> log
> back up.
>
> 05:21:19 Who: Session(2229190, informix@SCP3A, 1511, 128c2ba08)
>
> Thread(2267368, ontape, 13508fca8, 1)
>
> File: rsarcutl.c Line: 120
> 05:21:19 Action: isopen_logbu()/alloc_tQ()
> 05:21:19 Stack for thread: 2267368 ontape
>
> base: 0x000000012a07f000
> len: 69632
>
> pc: 0x00000001008918bc
> tos: 0x000000012a08dfa1
> state: running
>
> vp: 1
>
> 0x1008918bc oninit :: afstack + 0x34 sp=0x12a08e7a0(0x1352b93e0,
> 0x12ff91c20,
> 0x100000f, 0x0, 0x100f19948, 0x12a08ed30)
> 0x100890914 oninit :: afhandler + 0xb0c sp=0x12a08ea70
> delta_sp=720(0x100cef970, 0x100e32190, 0x100e31dd8, 0x401, 0x1,
> 0x100f2f948)
> 0x10088fd9c oninit :: afwarn_interface + 0x4c sp=0x12a08f190
> delta_sp=1824(0x12a08f61c, 0x0, 0x100e32190, 0x100e31dd8, 0x78,
> 0x129fb9568)
> 0x1006adc64 oninit :: oops_error + 0xc4 sp=0x12a08f250
> delta_sp=192(0x12a08f61c, 0x100e32190, 0xad, 0x100f303c0, 0x129fb9568, 0x4)
> 0x1006b4178 oninit :: isopen_logbu + 0xa74 sp=0x12a08f310
> delta_sp=192(0x10a06d800, 0x100f2f778, 0x100f303c0, 0x129f7cf20,
> 0x100f22a14,
> 0x100f20a14)
> 0x10028b20c oninit :: sqisopen_logbu + 0x50 sp=0x12a08f470
> delta_sp=352(0x1,
> 0x3ff800, 0x3ff800, 0x4, 0x12a08f60c, 0x12a08f608)
> 0x1004b29a8 oninit :: tbj_open_logbackup + 0x78 sp=0x12a08f540
> delta_sp=208(0xe, 0x4, 0x0, 0x2e38313900, 0x129ef8ee8, 0x0)
> 0x10047d1a4 oninit :: sqmain + 0xd3c sp=0x12a08fa20 delta_sp=1248(0x53,
> 0x1338, 0x12a08fe00, 0x100f2b740, 0x100f2f938, 0x1400)
> 0x1008bab70 oninit :: listen_verify + 0x5ec sp=0x12a08faf0
> delta_sp=208(0x210,
> 0x100d42848, 0x0, 0x100ceb530, 0x0, 0x12a0430f8)
> 0x100866630 oninit :: startup + 0xfc sp=0x12a08fe50
> delta_sp=864(0x100f2f948,
> 0x0, 0x100f19958, 0x128815b70, 0x12960d028, 0x128815af8)
> 05:21:19 See Also: /opt/informix/tmp/af.9cd07aae
>
> ---------------------------------
> Begin System Alarm Program Output
> ---------------------------------
>
> Assertion Failure Type: Warning
> Host Name: SCP3A
> Database Server Name: scp_online
> Time of failure: Sunday April 18 05:21:20 SAST 2010
> AF file: /opt/informix/tmp/af.9cd07aae
> Shared memory file: None
> System Blocking: OFF
>
> -------------------------------
> End System Alarm Program Output
> -------------------------------
>
> 05:21:20 sh /opt/informix/etc/evidence.sh 1 0 /opt/informix/tmp/af.9cd07aae
> 2229190 0x3508fca8 2267368 0x352b93e0 1025 0 0 0 0
> 05:21:20
> ------------------ End of assertion failure 0 -----------------
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0016e647ecc417b2ba0485dab4d9
yes , now we are testing the 11.50. but before the migration we should solved the problem first thanks
this is a long shot, but have you looked at the AF file that was generated? /opt/informix/tmp/af.9cd07aae there might be something useful in there. if nothing else, this should increase the pressure to complete your migration to 11.5. keep testing, the sooner you are on a supported version, the better.