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 number
IT34090
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-09-02
Closed date
2021-01-25
Last modified date
2021-01-25
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
[{"Line of Business":{"code":null,"label":null},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]
Document Information
Modified date:
26 January 2021