home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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 FixList