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

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 is sysrouted FROM one or more of the following:

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

Fix information

Applicable component levels