| Latest versions | fixlist |
| 14.10.xC11 |
 |
| 12.10.xC16.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
Informix - Problem description
| Problem IT03546 | Status: Closed |
ASSERT WARNING RECREATE TEMP SBSPACE, CORRUPT DBSPACE RESERVED PAGES AFTER REVERSION FROM 12.10.FC4 TO 12.10.FC2 | |
| product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
| Problem description: | |
The following assertion can be seen after reverting from
12.10.FC4 to 12.10.FC2 and also corrupt dbspace reserved pages
(missing name),
which is also seen in onstat -d
17:25:41 Assert Warning: recreate of temporary sbspsace failed
sbsnum:6, err=0
17:25:41 Who: Session(1, informix@server, 0, 0x44bee028)
Thread(7, main_loop(), 44ba8028, 1)
File: rstbs.c Line: 4679
17:25:41 Results: Downing sbspace.
17:25:41 Action: Please notify IBM Informix Technical Support.
17:25:41 Raw hex dump of stack located in
/work3/laube/pmrs/90399_004_000/tmp/af.3efc265.rawstk
17:25:41 Stack for thread: 7 main_loop()
(oninit) afstack
(oninit) afhandler
(oninit) afwarn_interface
(oninit) recreate_tmpsbspace
(oninit) clean_dbspaces
(oninit) main_loop
(oninit) th_init_initgls
(oninit) startup
The dbspace output of onstat -d should look like:
$ onstat -d
IBM Informix Dynamic Server Version 12.10.FC2 -- On-Line -- Up
00:00:41 -- 156264 Kbytes
Dbspaces
address number flags fchunk nchunks pgsize
flags owner name
44abe028 1 0x60001 1 1 2048
N BA informix rootdbs
45a81028 2 0x60001 2 1 2048
N BA informix dbs1
45a811d0 3 0x60001 3 1 2048
N BA informix dbs2
45a81378 4 0x42001 4 1 2048
N TBA informix tmpdbs1
45a81520 5 0x42001 5 1 2048
N TBA informix tmpdbs2
45a816c8 6 0x4a001 6 1 2048
N UBA informix tmpsbs1
45a81870 7 0x4a001 7 1 2048
N UBA informix tmpsbs2
45a81a18 8 0x68001 8 1 2048
N SBA informix sbs1
45a81bc0 9 0x68001 9 1 2048
N SBA informix sbs2
9 active, 2047 maximum
But now looks like:
Dbspaces
address number flags fchunk nchunks pgsize
flags owner name
44abe028 1 0x60001 1 1 2048
N BA informix
45a7f028 2 0x60001 2 1 2048
N BA informix
45a7f1d0 3 0x60001 3 1 2048
N BA informix
45a7f378 4 0x42001 4 1 2048
N TBA informix
45a7f520 5 0x42001 5 1 2048
N TBA informix
45a7f6c8 6 0x4a005 6 1 2048
NDUBA informix
45a7f870 7 0x4a005 7 1 2048
NDUBA informix
45a7fa18 8 0x68001 8 1 2048
N SBA informix
45a7fbc0 9 0x68001 9 1 2048
N SBA informix
9 active, 2047 maximum
Note the missing dbspace names also observed in oncheck -pr
output. | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS 12.10.xC4 and above * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IDS-12.10.xC5 * **************************************************************** | |
| Local Fix: | |
| Solution | |
Problem Fixed In IDS-12.10.xC5 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 01.08.2014 16.10.2015 16.10.2015 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 12.10.xC5 |
|
| 12.10.xC5.W1 |
|