Informix - Problem description
Problem IT10690 | Status: Closed |
PROMOTING AN RSS SERVER TO PRIMARY MARKS REGULAR AND TEMP SMART BLOB SPACES SBSPACES OFFLINE | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
If you want to make an RSS server a primary, the steps loosely are: $ oninit -PHY $ onmode -d secondary prim $ onmode -d make primary rss After running the "make primary", for sbspaces, you will see messages like these in the online.log: 15:51:59 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored. 15:51:59 Logical Recovery Started. 15:51:59 10 recovery worker threads will be started. 15:52:00 Logical Recovery has reached the transaction cleanup phase. 15:52:00 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 15:52:01 Bringing system to Quiescent Mode with no Logical Restore. 15:52:01 Assert Warning: recreate of temporary sbspsace failed sbsnum:6, err=12120 15:52:01 IBM Informix Dynamic Server Version 12.10.FC5W1 15:52:01 Who: Session(1, informix@server, 0, 0x44c31028) Thread(7, main_loop(), 44bea028, 8) File: rstbs.c Line: 4878 15:52:01 Results: Downing sbspace. 15:52:01 Action: Please notify IBM Informix Techical Support. 15:52:01 stack trace for pid 20885 written to /opt/informix/tmp/af.3ef6071 15:52:01 See Also: /opt/informix/tmp/af.3ef6071 15:52:01 recreate of temporary sbspsace failed sbsnum:6, err=12120 15:52:02 Assert Warning: Chunk 6 is being taken OFFLINE. 15:52:02 IBM Informix Dynamic Server Version 12.10.FC5W1 15:52:02 Who: Session(1, informix@server, 0, 0x44c31028) Thread(7, main_loop(), 44bea028, 1) File: rsmirror.c Line: 1933 15:52:02 Results: DBspace sbs1 is disabled. 15:52:02 Action: Restore DBspace sbs1 15:52:02 stack trace for pid 20864 written to /opt/informix/tmp/af.3ef6071 15:52:02 See Also: /opt/informix/tmp/af.3ef6071 15:52:02 Chunk 6 is being taken OFFLINE. 15:52:02 Assert Warning: recreate of temporary sbspsace failed sbsnum:7, err=12120 15:52:02 IBM Informix Dynamic Server Version 12.10.FC5W1 15:52:02 Who: Session(1, informix@server, 0, 0x44c31028) Thread(7, main_loop(), 44bea028, 1) File: rstbs.c Line: 4878 15:52:02 Results: Downing sbspace. 15:52:02 Action: Please notify IBM Informix Techical Support. 15:52:02 stack trace for pid 20864 written to /opt/informix/tmp/af.3ef6071 15:52:02 See Also: /opt/informix/tmp/af.3ef6071 15:52:02 recreate of temporary sbspsace failed sbsnum:7, err=12120 15:52:03 Assert Warning: Chunk 7 is being taken OFFLINE. 15:52:03 IBM Informix Dynamic Server Version 12.10.FC5W1 15:52:03 Who: Session(1, informix@server, 0, 0x44c31028) Thread(7, main_loop(), 44bea028, 1) File: rsmirror.c Line: 1933 15:52:03 Results: DBspace tmpsbs1 is disabled. 15:52:03 Action: Restore DBspace tmpsbs1 15:52:03 stack trace for pid 20864 written to /opt/informix/tmp/af.3ef6071 15:52:03 See Also: /opt/informix/tmp/af.3ef6071 15:52:03 Chunk 7 is being taken OFFLINE. 15:52:04 Quiescent Mode 15:52:04 Checkpoint Completed: duration was 0 seconds. 15:52:04 Tue Aug 11 - loguniq 4, logpos 0xbd018, timestamp: 0x3c852 Interval: 20 15:52:04 Maximum server connections 0 15:52:04 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 1 After running onmode -m, on 12.10.FC3XY, the server mode was left as: IBM Informix Dynamic Server Version 12.10.FC3XY -- On-Line (Prim) (CKPT INP) -- Up 00:08:28 -- 190536 Kbytes Blocked:OVERRIDE_DOWN_SPACE While on 12.10.FC5W1, the server mode was left as: IBM Informix Dynamic Server Version 12.10.FC5W1 -- On-Line (Prim) -- Up 00:01:15 -- 190544 Kbytes and an onstat -d showed the sbspaces marked down, for instance: $ onstat -d IBM Informix Dynamic Server Version 12.10.FC5W1 -- On-Line (Prim) -- Up 00:55:29 -- 190544 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name 44af9028 1 0x40001 1 1 2048 N BA informix rootdbs 44c30050 2 0x40001 2 1 2048 N BA informix dbs1 44c30280 3 0x42001 3 1 2048 N TBA informix tmpdbs1 44c304b0 4 0x40001 4 1 2048 N BA informix dbs2 44c306e0 5 0x42001 5 1 2048 N TBA informix tmpdbs2 44c30910 6 0x4a005 6 1 2048 NDUBA informix sbs1 44c30b40 7 0x4a005 7 1 2048 NDUBA informix tmpsbs1 7 active, 2047 maximum Chunks address chunk/dbs offset size free bpages flags pathname 44af9258 1 1 0 150000 83482 PO-B-- ./root.chunk 45b23028 2 2 0 40000 39947 PO-B-- ./dbs.1 45b24028 3 3 0 40000 39947 PO-B-- ./tmpdbs.1 45b25028 4 4 0 40000 39947 PO-B-- ./dbs.2 45b26028 5 5 0 40000 39947 PO-B-- ./tmpdbs.2 45b27028 6 6 0 40000 37232 37232 PDSB-- ./sbspace Metadata 2715 2020 2715 45b28028 7 7 0 40000 37232 37232 PDSB-- ./tmpsbs.1 Metadata 2715 2020 2715 7 active, 32766 maximum NOTE: The values in the "size" and "free" columns for DBspace chunks are displayed in terms of "pgsize" of the DBspace to which they belong. Expanded chunk capacity mode: always | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC6 * **************************************************************** | |
Local Fix: | |
Solution | |
Problem Fixed In IBM Informix Server 12.10.xC6 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.08.2015 30.12.2015 30.12.2015 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC6 | |
Problem solved according to the fixlist(s) of the following version(s) | |
12.10.xC6 |