Informix - Problembeschreibung
| Problem IT08467 | Status: Geschlossen | 
SEGV POSSIBLE IN DBS_TOTAL_SPACE WHEN CREATING OBJECT USING AUTOLOCATE FEATURE WHILE CONCURRENTLY ADDING A DBSPACE  | |
| Produkt: | |
IFMX ULT WHSE E / IM0019BOS / C10 - IDS 12.10  | |
| Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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: | |
| Lösung | |
Problem Fixed In IBM Informix Server 12.10.xC6  | |
| Workaround | |
keiner bekannt / siehe Local-Fix  | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung:  | 22.04.2015 30.12.2015 30.12.2015  | 
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC6  | |
| Problem behoben lt. FixList in der Version | |
| 12.10.xC6 | 
 |