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