IBM Support

IT30715: LOCKING TEMPORARY TABLE CAUSES HDR PRIMARY TO CRASH

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Customer upgraded to 12.10.xC5 and also started seeing the
    crash.
    
    Steps to duplicate the issue. I was not able to duplicate the
    issue on aix64 but I can on linux64. Customer is on windows.
    
    setup an HDR pair and a logged stores7. Then do
    
    begin work;
    create temp table temp_tab1(c1 int);
    lock table temp_tab1 in exclusive mode;
    
    12:02:16  Assert Failed: No Exception Handler
    12:02:16  IBM Informix Dynamic Server Version 12.10.FC5
    12:02:16   Who: Session(69, informix@keelut, 12053, 0x44c36d78)
            Thread(98, sqlexec, 44bf80a8, 1)
            File: mtex.c Line: 508
    12:02:16   Results: Exception Caught. Type: MT_EX_OS, Context:
    mem
    12:02:16   Action: Please notify IBM Informix Techical Support.
    12:02:16   See Also: /usr2/as_support/...../tmp/af.44a3118
    12:02:17  Thread ID 98 will now be suspended.
    
    
    Snippet from af file
    12:02:16  Context ptr = 0x000000004d837030
    12:02:16  Siginfo ptr = 0x000000004d837160
    12:02:16  Reg  0(R8)      0xfefefefefefefeff Reg  1(R9)
    0xfefefefefefeff30
    12:02:16  Reg  2(R10)     0x0000000000000042 Reg  3(R11)
    0x0000003e25a7a057
    12:02:16  Reg  4(R12)     0x000000004625f5f0 Reg  5(R13)
    0x0000000000000002
    12:02:16  Reg  6(R14)     0x0000000045f8a028 Reg  7(R15)
    0x000000000000000a
    12:02:16  Reg  8(RDI)     0x000000004d8374a2 Reg  9(RSI)
    0x0000000000000000
    12:02:16  Reg 10(RBP)     0x000000004601f930 Reg 11(RBX)
    0x000000004d8374a0
    12:02:16  Reg 12(RDX)     0x000000004d8374a2 Reg 13(RAX)
    0x0000000000000002
    12:02:16  Reg 14(RCX)     0x0000000000000000 Reg 15(RSP)
    0x000000004d837478
    12:02:16  Reg 16(RIP)     0x0000003e25a78840 Reg 17(EFL)
    0x0000000000010246
    12:02:16  Reg 18(CSGSFS)  0x0000000000000033 Reg 19(ERR)
    0x0000000000000004
    12:02:16  Reg 20(TRAPNO)  0x000000000000000e Reg 21(OLDMASK)
    0x0000000000000000
    12:02:16  Reg 22(CR2)     0x0000000000000000
    12:02:16  SHM Globals and Master Pool/Master Block Adresses:
    
    12:02:16  shmcb =           0x000000004400e658
    12:02:16  rhead =           0x000000004407b800
    12:02:16  pool list =       0x000000004400e730
    12:02:16  block pool list = 0x0000000044075338
    12:02:16  TRANSP =          0x0000000044c36d78
    12:02:16  PARTP =           0x00000000462e4028
    12:02:16  PARTNP =          0x00000000462e4138
    12:02:16  OPENP =           0x000000004601f028
    12:02:16  FILEP =           0x000000004601f460
    12:02:16  Raw hex dump of stack located in /usr2/
    /tmp/af.44a3118.rawstk
    12:02:16  Stack for thread: 98 sqlexec
    
     base: 0x000000004d828000
      len:   69632
       pc: 0x00000000013f47d7
      tos: 0x000000004d836780
    state: running
       vp: 1
    
    0x00000000013f47d7 (oninit) afstack
    0x00000000013fbbec (oninit) mt_ex_throw_sig
    0x0000000001397fe3 (oninit) afsig_handler
    0x0000003e2660e4c0 (Linux) <signal frame>
    0x0000003e25a78840 (/lib64/libc-2.5.so) __GI_strcpy
    0x000000000119431d (oninit) cloneLogTableLock
    0x0000000000748453 (oninit) dolock_int
    0x00000000006b7d3e (oninit) aud_dolock
    0x00000000005c9d05 (oninit) excommand
    0x0000000000a0de3c (oninit) sq_execute
    0x0000000000acfd2e (oninit) sqmain
    0x00000000014e5175 (oninit) spawn_thread
    0x00000000013f1920 (oninit) th_init_initgls
    0x00000000013b93a8 (oninit) startup
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of IDS 11.70.xC9 and previous versions.                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Locking temporary table causes HDR Primary to crash.         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Informix 11.70.xC9W2.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT30715

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    B70

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-10-25

  • Closed date

    2019-11-04

  • Last modified date

    2020-08-31

  • 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

[{"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B70"}]

Document Information

Modified date:
01 September 2020