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 IT02540 Status: Closed

CHANGING TABLE TYPE FROM RAW TO STANDARD DURING AN ARCHIVE CAN LEAD TO
ROLLFORWARD ERRORS AND DISABLED CHUNK DURING A RESTORE

product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problem description:
If you run the following sequence of commands in a logged 
database after an L0 archive has been started and before it 
finishes and some checkpoints and log switches occur during the 
archive and then use this archive to restore the instance 
(including the rollforward of the log. logs filled during the 
archive), you can see rollforward errors -126  and a chunk being 
taken offline during the restore: 
 
alter table <tabname> type (raw) 
insert into <tabname> 
alter table  <tabname> type (standard) 
update <tabname> 
 
During the restore, in the rollforward part of logical restore 
you will see this type of assertion failure: 
 
14:03:03  Rollforward of log record failed. iserrno = 126 
14:03:03  Log Record: log = 15, pos = 0x611c, type = 
OLDRSAM:HUPAFT(43), trans = 3619337690157154330 
14:03:04  Assert Warning: Chunk 2 is being taken OFFLINE. 
14:03:04  IBM Informix Dynamic Server Version 12.10.FC2 
14:03:04   Who: Session(14, informix@sles11a, 0, 0x44d2d068) 
                Thread(43, xchg_1.9, 44cf25b8, 8) 
                File: rsmirror.c Line: 1926 
14:03:04   Results: Dynamic Server will block at next checkpoint 
14:03:04   Action: Shutdown (onmode -k) or override (onmode -O) 
14:03:04  stack trace for pid 3471 written to 
/sqldist/1210fc2/tmp/af.41396f7 
14:03:04   See Also: /sqldist/1210fc2/tmp/af.41396f7 
14:03:04  Rollforward of log record failed. iserrno = 126 
14:03:04  Log Record: log = 15, pos = 0x611c, type = 
OLDRSAM:HUPAFT(43), trans = 26 
14:03:05  Logical Log 15 Complete, timestamp: 0x2245d4. 
14:03:05  Checkpoint blocked by down space, waiting for override 
or shutdown 
 
If you have the ONDBSPACEDOWN parameter set to 0 or if you run 
'onmode -O' after the instance gets blocked in checkpoint, the 
affected chunk will be permanently marked offline.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IDS-12.10.xC5                                      * 
****************************************************************
Local Fix:
Solution
Problem Fixed In IDS-12.10.xC5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
13.06.2014
16.10.2015
16.10.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
12.10.xC5 FixList
12.10.xC5.W1 FixList