Error Informix 7.23 - Could somebody help me ??
Posted in 1999
Hello everybody.
I'm running Informix 7.23 UC6 with IBM-AIX. I received this error message
when the database went down.
The continuous backup was being executed and gave me the following message:
=======================================================================
Logbackup failed - buc_fe.c : Archive API processing failed at line 422
=======================================================================
Here is the database log file, I hope somebody can help me with this...
16:44:12 Checkpoint Completed: duration was 2 seconds.
16:47:12 Assert Failed: Internal Error - Segmentation Violation
16:47:12 Who: Session(39636, root@f50br, 71776, 1074147016)
Thread(40716, sqlexec, 4004efd4, 3)
16:47:12 Results: OnLine must abort
16:47:12 Action: Reinitialize shared memory
16:47:12 See Also: /tmp/af.9f0c6d3f
16:47:12 rsinit.c, line 9968, thread 40716, proc id 15024, Segmentation
Violation.
16:47:12 PANIC: Attempting to bring system down
Arquivo do tmp
==============
16:47:11
16:47:12 Assert Failed: Internal Error - Segmentation Violation
16:47:12 Who: Session(39636, root@f50br, 71776, 1074147016)
Thread(40716, sqlexec, 4004efd4, 3)
16:47:12 Results: OnLine must abort
16:47:12 Action: Reinitialize shared memory
16:47:12 See Also: /tmp/af.9f0c6d3f
16:47:12 Stack for thread: 40716 sqlexec
base: 0x43334544
len: 36864
pc: 0x10030a88
tos: 0x4333c4e8
0x10030bb4 afstack (0x4333c79c, 0x41a406ac, 0x4333c618, 0x30005000,
0x0, 0x41cd814c, 0x6000cad9, 0x0)
0x10031af0 mt_affail (0x1002e744, 0x0, 0x0, 0x5f2, 0x40081a54, 0x40,
0x0, 0x200009e0)
0x1001a5d0 rsam_affail (0x2007e898, 0x40002014, 0x4333ca78, 0x2b,
0x403a10b4, 0x28, 0x4333ca98, 0x20078a24)
0x1000e28c hang_thread (0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x100144d4 afsig_segv (0x2, 0x70e8000, 0x4333ce18, 0x2007c79c,
0x10000004, 0x0, 0x4333cf28, 0x22840621)
0x10069db0 plscb_cleanup (0x10191cf0, 0x0, 0x0, 0x20078a24, 0x0, 0x0, 0x0,
0x2005b0e8)
0x40b76ed0 ***unknown*** (0x10197e74, 0x0, 0x4333d368, 0x2007e848, 0x1,
0x1, 0x0, 0x2007e850)
0x10062fd0 destroy_session (0xffffffff, 0x7, 0x42e2d79c, 0x0, 0x4333d35c,
0xffffffff, 0x4333d278, 0x0)
0x100828c4 sqsetconerr (0x2007e850, 0x2007c79c, 0x2, 0x2007e850,
0x42f56070, 0x0, 0x4333d388, 0x28420881)
0x1006022c asf_recv (0x10211e98, 0x2007e850, 0x4333d428, 0x0,
0x1021217c, 0x4333d398, 0x74757269, 0x736d6f00)
0x10060ac0 _iread (0x10060154, 0x0, 0x0, 0x2005b0e8, 0x11, 0x0,
0x0, 0x2007d80c)
0x100608e4 _igetint (0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x101ba994 sqmain (0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x1048d4cc startup (0x0, 0xffffffff, 0x4333d664, 0x43334530, 0x120,
0x86671cb4, 0x42e296b4, 0x433344ac)
0x00000000
16:47:12
------------------ End of assertion failure 0 -----------------
And the next day, I received these 2 errors (but the database did not shut
down):
-----------------------------------------------------------
15:34:04 Checkpoint Completed: duration was 3 seconds.
15:34:25 listener-thread: err = -25587: Network receive failed.
15:35:08 Assert Failed: Condition Failed (Bad memory pointer 0x1018f14), In
(mt_shm_free)
15:35:08 Who: Session(4695, root@f50br, 83910, 0)
Thread(4797, sqlexec, 0, 1)
15:35:08 Action: Please notify Informix Technical Support.
15:35:08 See Also: /tmp/af.12bdaddc
arquivo do tmp
==============
15:35:08
15:35:08 Assert Failed: Condition Failed (Bad memory pointer 0x1018f14), In
(mt_shm_free)
15:35:08 Who: Session(4695, root@f50br, 83910, 0)
Thread(4797, sqlexec, 0, 1)
15:35:08 Action: Please notify Informix Technical Support.
15:35:08 See Also: /tmp/af.12bdaddc
15:35:08 Stack for thread: 4797 sqlexec
base: 0x424a0014
len: 36864
pc: 0x10030a88
tos: 0x424a7798
0x10030bb4 afstack (0x424a7a4c, 0x415187d0, 0x424a78c8, 0x30005000,
0x0, 0x420bac90, 0x6000cad9, 0x0)
0x10031af0 mt_affail (0x424a7cc8, 0x409f1280, 0x424a7f98, 0x20002958,
0x0, 0x60000000, 0x6000cad9, 0x0)
0x1002caf8 mem_asfail (0x424a7f98, 0x2000293c, 0x1018f14, 0x300008a4,
0x0, 0x70000000, 0x0, 0x30000000)
0x1002f7f4 mt_shm_free (0x30012dc0, 0x2007c7a0, 0x10, 0x401f70c0,
0xa00328, 0x3f66, 0x400069e8, 0x41506570)
0x101ad1e8 netscb_cleanup (0xc, 0x0, 0x4408c0f0, 0x2007e848, 0x0,
0xffffffff, 0x424a89b8, 0x2007e850)
0x10197250 discshm (0x1035c448, 0x316df000, 0x424a8a88, 0x2007e850,
0x0, 0x0, 0x424a89f8, 0x4408db10)
0x101917d8 tlDiscon (0xffffffff, 0x1, 0x0, 0x2007e850, 0x1, 0x8,
0x424a8a38, 0x4039226c)
0x10473cec slSQIdiscon (0x2, 0x41237fb8, 0x424a8ab8, 0x30005000,
0x1010578c, 0x2007d7b0, 0x2007d7b4, 0x2007c79c)
0x1046eb5c pfDiscon (0x101169d0, 0x2007d7b4, 0x20014418, 0x0,
0x438c3158, 0x2007e850, 0x20014418, 0x2007f7dc)
0x1047b058 cmDiscon (0xc, 0x0, 0x424a8b38, 0x0, 0x438c3158,
0x2007e850, 0x0, 0x2007e850)
0x10190e90 ascAbort (0x0, 0x2007e850, 0x424a8b78, 0x0, 0x10335148,
0x2007e850, 0x0, 0x20003ea0)
0x1018a8f0 asfExit (0x10310048, 0x0, 0x424a8bd8, 0x42340481,
0x10085f0c, 0x0, 0x424a8bf8, 0x20078a24)
0x1018af7c ASF_Call (0x40978f50, 0x40608998, 0x0, 0xffffffff,
0x41e04168, 0x438c35a0, 0x424a8c68, 0x41e03f20)
0x1030b030 sqscb_cleanup (0x10197e74, 0x412cc658, 0x424a8cd8, 0x28882422,
0x102a1de0, 0x0, 0x424a8cd8, 0x412cdd10)
0x10063004 destroy_session (0xffffffff, 0x7, 0x41e03f98, 0x0, 0x424a8e2c,
0xffffffff, 0x424a8d48, 0x20)
0x100828c4 sqsetconerr (0x412cd888, 0x0, 0x20, 0x2007e850, 0x0,
0x412cdb50, 0x424a8ee8, 0x0)
0x1006022c asf_recv (0x10210f30, 0x2007e850, 0x424a8ef8, 0x80000000,
0x7, 0x0, 0x20003ea0, 0x2007d80c)
0x10060ac0 _iread (0x10060154, 0x69706373, 0x686d0000, 0x0, 0x0,
0x0, 0x20003ea0, 0x0)
0x100608e4 _igetint (0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x101ba994 sqmain (0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x1048d4cc startup (0x0, 0xffffffff, 0x424ba000, 0x424a0000, 0xfec,
0x8495afec, 0x404c1f64, 0x41cf5930)
0x00000000
15:35:08
------------------ End of assertion failure 0 -----------------
16:14:36 Checkpoint Completed: duration was 3 seconds.
16:15:52 Logical Log 16235 Complete.
16:15:53 Process exited with return code 255: /bin/sh /bin/sh -c/usr/informix/etc/log_full.sh 2 23 "Logical Log 16235 Complete.""Logical Log
16235 Complete."
16:17:01 Assert Failed: Memory block header corruption detected in
mt_shm_free 1
16:17:01 Who: Session(5177, root@f50br, 22770, 0)
Thread(5273, sqlexec, 0, 4)
16:17:01 Results: Pool repaired
16:17:01 Action: Please notify Informix Technical Support.
16:17:01 See Also: /tmp/af.1499b7ad
arquivo do tmp
==============
16:17:01 Found during mt_shm_free 1
16:17:01 Pool 'global' (0x40002014)
16:17:01 Bad block header 0x401dc284
blk-64
401dc244: 401dc0a4 00000018 401dc284 401dc20c @....... @...@...
401dc254: 0000003c 803b84cc 2002ab28 00030000 ...<.;.. ..(....
401dc264: 00000000 00000000 00000000 00000000 ........ ........
401dc274: 4046c0f8 00000000 00000000 401dc0a4 @F...... ....@...
blk+64401dc284