home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
15.0.xC1.2 FixList
14.10.xC13.3 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

Informix - Problembeschreibung

Problem IT10690 Status: Geschlossen

PROMOTING AN RSS SERVER TO PRIMARY MARKS REGULAR AND TEMP SMART BLOB SPACES
SBSPACES OFFLINE

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10.xC6                      * 
****************************************************************
Local-Fix:
Lösung
Problem Fixed In IBM Informix Server 12.10.xC6
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
13.08.2015
30.12.2015
30.12.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
12.10.xC6
Problem behoben lt. FixList in der Version
12.10.xC6 FixList