|
Problem IT34090
|
Status: Closed |
AUTOLOCATE DOES NOT WORK FOR FRAGMENTS ON VARCHAR OR LVARCHAR using with rowid COLUMNS, WILL LEAD TO AN AF INSTEAD
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| 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= procid=532
reason: mem |
| 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= procid=532 *
* reason: mem *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 (when available) or *
* 14.10.xC5. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* 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= procid=532 *
* reason: mem *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 (when available) or *
* 14.10.xC5. *
**************************************************************** |
| Comment |
Fixed in Informix Server 12.10.xC15 and 14.10.xC5. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.09.2020
25.01.2021
25.01.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
