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 number
IC67611
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-04-02
Closed date
2012-10-31
Last modified date
2012-11-01
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 November 2012