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 |