IDS9.40FC2断言失败的分析建议

描述信息：

       2008-08-28 04:00:08 countermd(SunOS 5.9)上的informix 9.40fc2出现断言失败。

 

===online.log中的信息=======================================

04:00:08  Password Validation for user [informix] failed!

04:00:08  Check for password aging/account lock-out.

04:00:08  listener-thread: err = -952: oserr = 0: errstr = informix: User (informix)'s password is not correct for the database server.

 

04:00:08  Password Validation for user [informix] failed!

04:00:08  Check for password aging/account lock-out.

04:00:08  listener-thread: err = -952: oserr = 0: errstr = informix: User (informix)'s password is not correct for the database server.

 

04:00:08  Password Validation for user [informix] failed!

04:00:08  Check for password aging/account lock-out.

04:00:08  listener-thread: err = -952: oserr = 0: errstr = informix: User (informix)'s password is not correct for the database server.

 

04:00:08  listener-thread: err = -25546: oserr = 0: errstr = : Invalid ASF assoc_id.

 

04:00:08  Assert Failed: No Exception Handler

04:00:08  IBM Informix Dynamic Server Version 9.40.FC2   

04:00:08   Who: Session(46800, informix@, 0, 0)

              Thread(11, tlitcplst, 0, 1)

              File: mtex.c Line: 431

04:00:08   Results: Exception Caught. Type: MT_EX_OS, Context: mem

04:00:08   Action: Please notify IBM Informix Technical Support.

04:00:08  stack trace for pid 23939 written to /tmp/af.3f36c50

04:00:08   See Also: /tmp/af.3f36c50

04:00:16  mtex.c, line 431, thread 11, proc id 23939, No Exception Handler.

04:03:14  Fuzzy Checkpoint Completed:  duration was 2 seconds, 42 buffers not flushed,

timestamp: 123761549.

04:03:14  Checkpoint loguniq 70, logpos 0x2b2238, timestamp: 123761549

 

=== af.3f36c50 中的信息=========================================

04:00:16  Found during mt_shm_malloc_segid 3

04:00:16  Pool 'global' (0x2bc308040)

04:00:16  Bad free block 0x2bde6dd88

blk-64

00000002bde6dd48: 00000000 00000000 00000000 00000000   ........ ........

00000002bde6dd58: 00000000 00000000 ffffffff ffffffff   ........ ........

00000002bde6dd68: 00000002 bde6dfa8 00000002 bde6d930   ........ .......0

00000002bde6dd78: 00000000 00000248 00000005 7bcdbb21   .......H ....{..!

blk+64

00000002bde6dd88: 00000064 bc3086f8 00000002 bc3086f8   ...d.0.. .....0..

00000002bde6dd98: 00000005 78610df1 00000000 00000000   ....xa.. ........

00000002bde6dda8: 00000000 00000000 00000000 00000000   ........ ........

00000002bde6ddb8: 00000000 00000000 00000000 00000000   ........ ........

04:00:16  Bad free block removed from pool

04:00:16  Attempting to clean up all block list...

04:00:16  Pool 'global' (0x2bc308040)

04:00:16  Bad block header 0x2bde6dd60

blk-64

00000002bde6dd20: 00000002 bf83a0b0 00000000 00000000   ........ ........

00000002bde6dd30: 00000000 00000000 00000000 00000000   ........ ........

00000002bde6dd40: 00000000 00000000 00000000 00000000   ........ ........

00000002bde6dd50: 00000000 00000000 00000000 00000000   ........ ........

04:00:16  Bad block removed from pool

04:00:16 

04:00:16  IBM Informix Dynamic Server Version 9.40.FC2     Software Serial Number AAA#B000000

 

04:00:16  Assert Warning: Memory free block header corruption detected in mt_shm_malloc_segid 3

04:00:16   Who: Session(40366, informix@, 0, 0)

              Thread(11, tlitcplst, 0, 1)

              File: mtshpool.c Line: 3403

04:00:16   Results: Pool repaired

04:00:16   Action: Please notify IBM Informix Technical Support.

04:00:16  Stack for thread: 11 tlitcplst

 

 base: 0x00000002bd9c4000

  len:   69632

   pc: 0x00000001008662f4

  tos: 0x00000002bd9d29b1

state: running

   vp: 1

 

问题分析：

       使用错误的用户名或者密码导致内存出错或者断言失败。这个情况指的是当两个用户尝试同时连接到数据库时，同时其中的一个用户因为错误的用户名或者密码而被拒绝访问。

       Attempting to connect with an invalid userid or password results in memory corruption or an Assert failure. This specifically occurs when two users are trying to connect at the same time and one is rejected because of an invalid userid or password.

问题的建议：

       这是一个确认并且在ids 9.40fc4上已经修复的BUG。

 

BUG NO.	COMPONENT	DESCRIPTION
164947	ONLINE - ASF	CONNECT WITH INVALID USERID / PASSWORD CORRUPTS MEMORY OR CRASHES SERVER

 

       因此，建议对该数据库进行升到，建议的版本为ids 9.40fc7w4或者以上较为稳定的版本。