home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 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 IT08467 Status: Closed

SEGV POSSIBLE IN DBS_TOTAL_SPACE WHEN CREATING OBJECT USING AUTOLOCATE
FEATURE WHILE CONCURRENTLY ADDING A DBSPACE

product:
IFMX ULT WHSE E / IM0019BOS / C10 - IDS 12.10
Problem description:
A session attempting to create a table/index that is using the 
autolocate feature can generate a SEGV in dbs_total_space() due 
to a timing problem with a 2nd thread attempting to add a 
dbspace. 
 
Stack trace of the crashing thread would look something like 
this: 
 
afstack 
mt_ex_throw_sig 
afsig_handler 
<signal frame> 
dbs_total_space 
rs_locate_idx 
makedetach 
concreatidx 
dounique 
creatab 
aud_creatab 
excommand 
sq_execute 
sqmain 
spawn_thread 
th_init_initgls 
startup 
 
or 
 
afstack 
mt_ex_throw_sig 
afsig_handler 
<signal frame> 
dbs_total_space 
rs_locate_rrfrag 
st2cb 
tab2cb 
stmt2cb 
p_sp2cb 
parsecmd 
sqcmd 
sq_cmnd 
sq_prepare 
sqmain 
listen_verify 
spawn_thread 
th_init_initgls 
startup 
 
current SQL for AF'ing session: 
 
  CREATE COLLECTION "d_35976558867.system.users" TABLE 
system_users (id 
    CHAR(128) PRIMARY KEY NOT NULL, data bson, modCount BIGINT, 
flags INT) 
    EXTENT SIZE 64 NEXT SIZE 64 LOCK MODE ROW 
 
Session attempting to add dbspace: 
 
  execute function task("create dbspace from storagepool", 
"newdbs1", "10 
    MB") 
 
*Note it doesn't need to be a session adding a dbspace via the 
admin task, a regular onspaces -c -d would also cause problems.* 
 
top portion of stack for thread attempting to add space: 
 
yield_processor_mvp 
mt_lock_wait 
mt_lock 
rschkadd 
aud_ischkadd 
admin_dbs_create 
admin_create_dbspace_from_storagepool 
do_job_cc 
admin_cc
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users running with AUTOLOCATE set in a DDL-intensive         * 
* environment with spaces being added or dropped               * 
* simultaneously.                                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10.xC6                      * 
****************************************************************
Local Fix:
Solution
Problem Fixed In IBM Informix Server 12.10.xC6
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
22.04.2015
30.12.2015
30.12.2015
Problem solved at the following versions (IBM BugInfos)
12.10.xC6
Problem solved according to the fixlist(s) of the following version(s)
12.10.xC6 FixList