home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT36107 Status: Closed

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

product:
INFORMIX SERVER / 5725A3900 / E10 - 
Problem 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
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:                                              *
****************************************************************
Local Fix:
Solution
Workaround
****************************************************************
* 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:                                              *
****************************************************************
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
04.03.2021
25.11.2022
24.02.2023
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)