|
Problem IT14870
|
Status: Closed |
ASSERT FAILED TRYING TO DETACH A FRAGMENT USING FORCE_DDL_EXEC AND OTHER CONCURRENT THREADS HAVING TO GROW THEIR OPENTAB
|
| product: |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 |
| Problem description: |
The session trying to detach the fragment can sometimes hit a
SEGV assertion failure with the stack looking like this:
afstack
mt_ex_throw_sig
afsig_handler
create_open_partition_txn_list
rspnforce_excl_access
ispnopen_with_forceddl
openfrags
fmftopen_with_child
fmftopen
ddaltfrag
aud_ddaltfrag
excommand
sq_execute
sqmain
On Linux the create_open_partition_txn_list frame was not
present, it's in-lined into rspnforce_excl_access. This is a
timing problem so will not occur all the time.
Sess SQL Current Iso Lock SQL
ISAM F.E.
Id Stmt type Database Lvl Mode ERR
ERR Vers Explain
1300938 ALTER FRAGMENT lsk CR Not Wait 0
0 9.24 Off
Current SQL statement (4) :
alter fragment on table xyz detach partition xyz_1
old_xyz_1 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of the FORCE_DDL_EXEC feature on systems with lots of *
* contention for the table being altered. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 11.70.xC9 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.04.2016
09.06.2017
09.06.2017 |
| Problem solved at the following versions (IBM BugInfos) |
11.70.xC9
|
| Problem solved according to the fixlist(s) of the following version(s) |
