suche 36x36
  • Admin-Scout-small-Banner
           

    CURSOR Admin-Scout

    get the ultimate tool for Informix

    pfeil  
Latest versionsfixlist
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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)
Informix EditionsInformix Editions
Informix Editions
DocumentationDocumentation
Documentation
IBM NewsletterIBM Newsletter
IBM Newsletter
Current BugsCurrent Bugs
Current Bugs
Bug ResearchBug Research
Bug Research
Bug FixlistsBug Fixlists
Bug Fixlists
Release NotesRelease Notes
Release Notes
Machine NotesMachine Notes
Machine Notes
Release NewsRelease News
Release News
Product LifecycleProduct Lifecycle
Lifecycle
Media DownloadMedia Download
Media Download