suche 36x36
  • Admin-Scout-small-Banner
           

    CURSOR Admin-Scout

    get the ultimate tool for Informix

    pfeil  
Latest versionsfixlist
14.10.xC10 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
Informix EditionsInformix Editions
Informix Editions
DocumentationDocumentation
Documentation
IBM NewsletterIBM Newsletter
IBM Newsletter
Current BugsCurrent Bugs
Current Bugs
Bug ResearchBug Research
Bug Research
Bug FixlistsBug Fixlists
Bug Fixlists
Release NotesRelease Notes
Release Notes
Machine NotesMachine Notes
Machine Notes
Release NewsRelease News
Release News
Product LifecycleProduct Lifecycle
Lifecycle
Media DownloadMedia Download
Media Download