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