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) | |