IC65787: UPGRADE TO 11.50.XC6 FROM OTHER 11.50 VERSIONS DOES NOT REBUILD SYSMASTER DATABASE LEADING TO MEMORY CORRUPTION AND A CRASH

APAR status

• Closed as program error.

Error description

• You upgrade to a 32-bit version of 11.50.xC6 from a previous
  32-bit version of 11.50 or
  you upgrade to a 64-bit version of 11.50.xC6 from a previous
  64-bit version of 11.50.
  
  You run a query involving the sysmaster table sysptnhdr or view
  systabinfo. This leads to various forms of memory corruption
  causing assertion failures with stack traces similar to these:
  
   base: 0x000000000b7e2000
    len:   69632
     pc: 0x0000000100e22d58
    tos: 0x0000000101558e11
  state: running
     vp: 1
  
   ucontext: 0x000000010155a060
    siginfo: 0x000000010155a340
             si_signo: 11  si_code: 1   si_errno: 0 si_pid: 0
  si_uid: 0
             si_addr: 0x000000000001da58 si_value:
  0x0000000000000000  si_fd: 0
  
  0x100e14178 oninit :: recover_pool_bad_block
  0x100e10ad4 oninit :: mt_free
  0x100e89070 oninit :: fmclose
  0x100318ee4 oninit :: sqisclose
  0x1001bd374 oninit :: closerel
  0x10035be20 oninit :: scan_free
  0x100664548 oninit :: join_free
  0x10066783c oninit :: group_free
  0x10038d5d4 oninit :: merge_free
  0x1001bbf5c oninit :: closecb
  0x1001bba60 oninit :: close_cb_subtree_r
  0x1001bb87c oninit :: close_cb_subtree
  0x1001bb2d4 oninit :: closesdb
  0x1001ba63c oninit :: doreleasesdb
  0x1005250a8 oninit :: sq_release
  0x1005ce868 oninit :: sqmain
  0x100ec02b4 oninit :: listen_verify
  0x100ebf6ac oninit :: spawn_thread
  0x100df1ba8 oninit :: startup
  
  Or:
  
   base: 0x000000011257e000
    len:   69632
     pc: 0x00000001020f10c8
    tos: 0x0000000102ad5411
  state: running
     vp: 1
  
   ucontext: 0x0000000102ad67b0
    siginfo: 0x0000000102ad6a90
             si_signo: 11  si_code: 1   si_errno: 0 si_pid: 0
  si_uid: 0
             si_addr: 0x0000000000010090 si_value:
  0x0000000000000000  si_fd: 0
  
  0x1008bbf30 oninit :: nextrange
  0x1008b2280 oninit :: scan_open
  0x100f35714 oninit :: join_open
  0x100f3b1cc oninit :: group_open
  0x10091bbc4 oninit :: merge_open
  0x1008de244 oninit :: prepselect
  0x100c684c0 oninit :: open_cursor
  0x100c66710 oninit :: sql_open
  0x100c66274 oninit :: sq_open
  0x100dfdb88 oninit :: sqmain
  0x10224389c oninit :: listen_verify
  0x102242004 oninit :: spawn_thread
  0x102082808 oninit :: startup
  

Local fix

• 1. Make sure no users are connected to the sysmaster database
  while rebuilding sysmaster database.
  2. Force a rebuild of the sysmaster database by running one of
  these commands as user informix:
  on UNIX or Linux run $INFORMIXDIR/etc/buildsmi
  on Windows run %INFORMIXDIR%\etc\buildsmi.bat
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users who upgrade to a 32-bit version of 11.50.xC6 from a    *
  * previous 32-bit version of 11.50 or                          *
  * users who upgrade to a 64-bit version of 11.50.xC6 from a    *
  * previous 64-bit version of 11.50.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The sysmaster database is not rebuilt during the upgrade     *
  * process. A query involving the sysmaster table sysptnhdr or  *
  * view systabinfo causes various types of memory corruption    *
  * causing assertion failures.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50.xC6W1 or higher.                            *
  ****************************************************************
  

Problem conclusion

• This problem is first fixed in 11.50.xC6W1.
  

Temporary fix

Comments

• If you already upgraded to 11.50.xC6 and are now upgrading to
  11.50.xC6W1 then you still have to rebuild the sysmaster
  database using the steps in the Local Fix above.
  
  For download information, go to:
  http://www-933.ibm.com/support/fixcentral/
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSN

     UP