IC67611: LONG TRANSACTION ROLLBACK OF XA PREPARED TRANSACTION TERMINATES SERVER WHEN INDEX ON BOOLEAN COLUMN IS INVOLVED

APAR status

• Closed as program error.

Error description

• A long transaction rollback of a XA prepared transaction
  terminates the server when an index on a boolean column is
  involved.
  
  create table mybool
  ( id serial,
    cc char(5),
    cb boolean,
    primary key (id)
  ) lock mode row;
  
  create index ix1 on mybool(cb);
  
  insert into mybool values(0,'xxxxx','t');
  
  It might happen that the transaction remains on the server after
  it was XA prepared.
  When it becomes long the server tries to abort it heuristically.
  
  In this situation the server terminates unexpectedly with the
  following stack:
  
  
  ( 0)  0x4000000000fb7ee8   legacy_hp_afstack + 0x320
  ( 1)  0x4000000000fb7384   afstack + 0x64
  ( 2)  0x4000000000fbced0   mt_ex_throw_sig + 0x380
  ( 3)  0x4000000000f6d868   afsig_handler + 0x108
  ( 4)  0xc00000000bb0c8d0   _sigreturn
  ( 5)  0x400000000040fd20   udr_sapi_prep + 0x30
  ( 6)  0x400000000098c920   load_udr_seq + 0x1e8
  ( 7)  0x400000000098a564   doitem + 0x124
  ( 8)  0x4000000000987eb0   logundo + 0x2290
  ( 9)  0x4000000000b851d4   rlogm_undo + 0x16c
  (10)  0x40000000009854d8   rollback + 0x2d0
  (11)  0x4000000000984d7c   rsrollback + 0x494
  (12)  0x400000000099d92c   cleantx + 0x3e4
  (13)  0x40000000002d330c   clean_ltx + 0x14
  (14)  0x4000000000f84e14   startup + 0xd4
  (15)  0x4000000000f84bfc   resume + 0x10c
  
  Subsequent attempts to restart the server will fail with the
  same stack.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IDS 9 and above                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When an un-associated XA transaction(no owner) becomes long  *
  * and is rolled back, if database changes in this transaction  *
  * involves UDR (i.e index on boolean column), server SEGV.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * upgrade to IDS 11.50.xC7 when available                      *
  ****************************************************************
  

Problem conclusion

• First fixed in IDS 11.50 xC7
  

Temporary fix

Comments

• For download information, go to:
  http://www.ibm.com/support/fixcentral
  

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

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSY

     UP