IT34090: AUTOLOCATE DOES NOT WORK FOR FRAGMENTS ON VARCHAR OR LVARCHAR using with rowid COLUMNS, WILL LEAD TO AN AF INSTEAD

APAR status

• Closed as program error.

Error description

• Setting AUTOLOCATE to a positive number  should create new
  fragments when the existing ones have reached the max number of
  pages.
  This is working fine for character fragments, but does not work
  for varchar or lvarchar columns when using the "with Rowid"
  syntax.
  
  Instead after trying to create a new fragment, the instance will
  hang
  this is from the online.log
  16:20:37  WARNING: partition 'rep1:ebach.rr_table_with_varchar':
  no more pages
  16:20:37  WARNING: partition 'rep1:ebach.rr_table_with_varchar':
  no more pages
  16:20:37  Assert Failed: Exception Caught. Type: MT_EX_OS,
  Context: mem
  16:20:37  IBM Informix Dynamic Server Version 12.10.FC14
  16:20:37   Who: Session(40, ebach@darkwood, 22134, 0x44f3c618)
                  Thread(68, sqlexec, 44efce08, 1)
                  File: mtex.c Line: 420
  16:20:37   Action: Please notify IBM Informix Technical Support.
  16:20:37  stack trace for pid 10957 written to
  /chunks/ebach/12.10/darkw121f14_eb1t/af.42c3535
  16:20:37   See Also:
  /chunks/ebach/12.10/darkw121f14_eb1t/af.42c3535
  16:20:39  Exception Caught. Type: MT_EX_OS, Context: mem
  16:20:40  (-9791): ERROR: Routine execution trap --
  procname=<insert_data1> procid=532
      reason: mem
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5.  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Setting AUTOLOCATE to a positive number should create new    *
  * fragments when the existing ones have reached the max number *
  * of                                                           *
  * pages.                                                       *
  * This is working fine for character fragments, but does not   *
  * work                                                         *
  * for varchar or lvarchar columns when using the "with Rowid"  *
  * syntax.                                                      *
  *                                                              *
  * Instead, after trying to create a new fragment, the instance *
  * will hang.                                                   *
  * This is from the online.log:                                 *
  *                                                              *
  * 16:20:37  WARNING: partition                                 *
  * 'rep1:ebach.rr_table_with_varchar':                          *
  * no more pages                                                *
  * 16:20:37  WARNING: partition                                 *
  * 'rep1:ebach.rr_table_with_varchar':                          *
  * no more pages                                                *
  * 16:20:37  Assert Failed: Exception Caught. Type: MT_EX_OS,   *
  * Context: mem                                                 *
  * 16:20:37  IBM Informix Dynamic Server Version 12.10.FC14     *
  * 16:20:37   Who: Session(40, ebach@darkwood, 22134,           *
  * 0x44f3c618)                                                  *
  *                 Thread(68, sqlexec, 44efce08, 1)             *
  *                 File: mtex.c Line: 420                       *
  * 16:20:37   Action: Please notify IBM Informix Technical      *
  * Support.                                                     *
  * 16:20:37  stack trace for pid 10957 written to               *
  * /chunks/ebach/12.10/darkw121f14_eb1t/af.42c3535              *
  * 16:20:37   See Also:                                         *
  * /chunks/ebach/12.10/darkw121f14_eb1t/af.42c3535              *
  * 16:20:39  Exception Caught. Type: MT_EX_OS, Context: mem     *
  * 16:20:40  (-9791): ERROR: Routine execution trap --          *
  * procname=<insert_data1> procid=532                           *
  *     reason: mem                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 12.10.xC15 (when available) or    *
  * 14.10.xC5.                                                   *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC15 and 14.10.xC5.
  

Temporary fix

Comments

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

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels