IT31187: ALTER TABLE CAN FAIL WITH -959/-172 AND ASSERT FAILED

APAR status

• Closed as program error.

Error description

• This alter:
  
  alter table test add (a17 integer);
  
  ... might fail with:
  
  959: The current transaction has been rolled back due to an
  internal error.
  172: ISAM error:  Unexpected internal error
  
  The table schema:
  
  create table test
    (
      a1 integer,
      a2 integer,
      a3 integer,
      a4 integer,
      a5 integer,
      a6 integer,
      a7 integer,
      a8 integer,
      a9 integer,
       a10 integer,
       a11 integer,
       a12 integer,
       a13 integer,
       a14 integer,
       a15 integer,
       a16 integer
  ) extent size 16 next size 16 lock mode page;
  
  create index test_idx1 on test (a1, a2, a3, a4, a5, a6, a7, a8,
  a9, a10, a11, a12, a13, a14, a15, a16);
  
  Assert Failed is also generated
  
  12:24:57  Assert Failed: No Exception Handler
  12:24:57  IBM Informix Dynamic Server Version 14.10.FC3DE
  12:24:57   Who: Session(51, user@host, 7047, 0x454ae048)
                  Thread(67, sqlexec, 4546d8c8, 1)
                  File: mtex.c Line: 508
  12:24:57   Results: Exception Caught. Type: MT_EX_OS, Context:
  mem
  
  afsig_handler
  (Linux) <signal frame>
  setconcol
  tab2cb
  stmt2cb
  p_sp2cb
  parsecmd
  sqcmd
  sq_prepare
  sqmain
  spawn_thread
  th_init_initgls
  startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4.  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to Informix Server 12.10.xC14 or 14.10.xC4.           *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC14 and 14.10.xC4.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels