Informix - Problem description
Problem IT27542 | Status: Closed |
ASSERT FAILURE WHEN CREATING INDEX ONLINE AND NOT ENOUGH SPACE IN DBSPACE AND SP_AUTOEXPAND 0 | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
While creating an ONLINE index on a dbspace with not enough space, the engine will Assert Fail if SP_AUTOEXPAND 0. You will see a message in online.log like: 09/26/17 11:19:11 Warning: The storage pool is out of space. To enable automatic chunk creation use the OpenAdmin Tool to add space to the pool. 09/26/17 11:19:11 Assert Failed: Invalid Mutex Type 09/26/17 11:19:11 IBM Informix Dynamic Server Version 12.10.FC8 09/26/17 11:19:11 Who: Session(349, informix@xxxxxxxx, 10459, 115fb4148) Thread(77428, pimage_0x1600004, 115f93de8, 9) File: mt.c Line: 9014 09/26/17 11:19:11 stack trace for pid 20240 written to /opt/informix/etc/af_files/af.545895b AF With following stack: 12:07:39 SHM Globals and Master Pool/Master Block Adresses: 12:07:39 shmcb = 0x000000010a1e0678 12:07:39 rhead = 0x000000010a24d800 12:07:39 pool list = 0x000000010a1e0750 12:07:39 block pool list = 0x000000010a247358 12:07:39 TRANSP = 0x0000000115fabb38 12:07:39 PARTP = 0x0000000000000000 12:07:39 PARTNP = 0x0000000000000000 12:07:39 OPENP = 0x0000000000000000 12:07:39 FILEP = 0x0000000000000000 12:07:39 Raw hex dump of stack located in /opt/informix/etc/af_files/af.545895b.rawstk 12:07:39 Stack for thread: 349 pimage_0x1600004 base: 0x0000000118197000 len: 135168 pc: 0x00000001012d63e0 tos: 0x00000001181b6661 state: running vp: 1 ucontext: siginfo: oninit :: afstack oninit :: afhandler oninit :: afcrash_interface oninit :: mt_lock_helper oninit :: exit_thread oninit :: idxbld_pimage_proc oninit :: startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS 12.10.xC11 and older versions. * **************************************************************** * PROBLEM DESCRIPTION: * * Assert Failure when creating index ONLINE and not enough * * space in dbspace and SP_AUTOEXPAND 0. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 26.12.2018 07.10.2019 07.10.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC12 | |
Problem solved according to the fixlist(s) of the following version(s) |