IBM Support

IT36107: ASSERT WARNING ON HDR SEC WHILE USING ACTIVELY USING TEMP DBSPACE AND IT'S DROPPED / RECREATED ON PRI

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • On a HDR sec running query(ies) using temp dbspace and on PRI
    temp dbspace is dropped. ie. to recreate it with a bigger size,
    you'll get Assert Warning like:
    
    08:38:50  IBM Informix Dynamic Server Version 14.10.FC5
    
    08:38:50  Assert Warning: I/O bad request chunk 10, pagenum 85,
    pagecnt 32
    08:38:50   Who: Session(244, informix@xxxxxxxxxxxxx, 31559,
    0x5efbc068)
                    Thread(257, sqlexec, 4597f2e8, 11)
                    File: rsbuff.c Line: 5984
    08:38:50   Action: Please notify IBM Informix Technical Support.
    08:38:50  SHM Globals and Master Pool/Master Block Adresses:
    
    08:38:50  shmcb =           0x000000004401a448
    08:38:50  rhead =           0x0000000044087800
    08:38:50  pool list =       0x000000004401a520
    08:38:50  block pool list = 0x0000000044081d28
    08:38:50  TRANSP =          0x000000005efbc068
    08:38:50  PARTP =           0x000000005f567230
    08:38:50  PARTNP =          0x000000005f567348
    08:38:50  OPENP =           0x000000005f8e4828
    08:38:50  FILEP =           0x000000005f8f1460
    08:38:50  Raw hex dump of stack located in
    /prods/14.10/FC5/tmp/af.4e9e2ea.rawstk
    08:38:50  Stack for thread: 257 sqlexec
    
     base: 0x000000005f921000
      len:   102400
       pc: 0x00000000014a5f2d
      tos: 0x000000005f937880
    state: running
       vp: 11
    
    0x00000000014a5f2d (oninit) afstack
    0x00000000014aae49 (oninit) afhandler
    0x00000000014ab5a2 (oninit) afwarn_interface
    0x0000000000e61d60 (oninit) physio
    0x0000000000f1b403 (oninit) srtrdbuf
    0x0000000000f1b5e3 (oninit) srtnext
    0x0000000000f21f45 (oninit) srtread
    0x0000000000890a92 (oninit) sort_next
    0x000000000086d2bf (oninit) getrow
    0x000000000086ea1e (oninit) fetchrow
    0x0000000000608464 (oninit) exfetch
    0x0000000000aa51fd (oninit) sql_nfetch
    0x0000000000aa58b4 (oninit) sq_nfetch
    0x0000000000b8dc2e (oninit) sqmain
    0x00000000015d5286 (oninit) spawn_thread
    0x0000000001496903 (oninit) th_init_initgls
    0x00000000014ddb2f (oninit) startup
    
    ----------------------------------------------------------------
    --------------------------------------------------
    
    08:38:51  IBM Informix Dynamic Server Version 14.10.FC5
    
    08:38:51  Assert Warning: pthdrpage:ptdrop:bad bfget
    08:38:51   Who: Session(244, informix@xxxxxxxxxxxxxxxxxxxxx,
    31559, 0x5efbc068)
                    Thread(257, sqlexec, 4597f2e8, 11)
                    File: rspartn.c Line: 8631
    08:38:51   Results: Cannot use TBLSpace page for TBLSpace
    10485762
    08:38:51   Action: Run 'oncheck -pt 10485762'
    08:38:51  SHM Globals and Master Pool/Master Block Adresses:
    
    08:38:51  shmcb =           0x000000004401a448
    08:38:51  rhead =           0x0000000044087800
    08:38:51  pool list =       0x000000004401a520
    08:38:51  block pool list = 0x0000000044081d28
    08:38:51  TRANSP =          0x000000005efbb988
    08:38:51  PARTP =           0x000000005f567230
    08:38:51  PARTNP =          0x000000005f567348
    08:38:51  OPENP =           0x000000005f8e4828
    08:38:51  FILEP =           0x000000005f8f1460
    08:38:51  Raw hex dump of stack located in
    /prods/14.10/FC5/tmp/af.4e9e2ea.rawstk
    08:38:51  Stack for thread: 257 sqlexec
    
     base: 0x000000005f921000
      len:   102400
       pc: 0x00000000014a5f2d
      tos: 0x000000005f937970
    state: running
       vp: 11
    
    0x00000000014a5f2d (oninit) afstack
    0x00000000014aae49 (oninit) afhandler
    0x00000000014ab5a2 (oninit) afwarn_interface
    0x0000000000dcb947 (oninit) pthdrgetx
    0x0000000000de3aee (oninit) ptdrop
    0x0000000000e74a29 (oninit) stmp_drop
    0x0000000000f22e6c (oninit) srtclose
    0x000000000088fa3a (oninit) sort_close
    0x0000000000660375 (oninit) closecb
    0x0000000000661ea6 (oninit) close_cb_subtree
    0x0000000000662ce7 (oninit) closesdb
    0x0000000000aa46c9 (oninit) sq_close
    0x0000000000b8dc2e (oninit) sqmain
    0x00000000015d5286 (oninit) spawn_thread
    0x0000000001496903 (oninit) th_init_initgls
    0x00000000014ddb2f (oninit) startup
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * 14.10.xC5                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Assert Warning on HDR sec while using actively using temp    *
    * dbspace and it's dropped / recreated on PRI                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

  • future:  Future releases or versions will address this defect.
    

APAR Information

  • APAR number

    IT36107

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    E10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-03-04

  • Closed date

    2022-11-25

  • Last modified date

    2023-02-24

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

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

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10"}]

Document Information

Modified date:
24 February 2023