| Latest versions | fixlist |
| 14.10.xC10 |
 |
| 12.10.xC16.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
Informix - Problem description
| Problem IT28948 | Status: Closed |
MOVING A HDR SECONDARY TO BECOME A PRIMARY CAN SHOW VERY LARGE OR NEGATIVE VALUES IN COMMITED AND ROLLED BACK | |
| product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
| Problem description: | |
If a HDR secondary has been running for a long time and there
has been lots of transactions (commited or rolled back) then the
logical recovery message will show all of these since the HDR
secondary has been running. On a bust system, these values can
be very large or exceed the size of a signed integer and appear
as negative.
1/24/18 04:12:23 Logical Recovery has reached the transaction
cleanup phase.
11/24/18 04:12:23 Checkpoint Completed: duration was 0
seconds.
11/24/18 04:12:23 Sat Nov 24 - loguniq 1077721, logpos 0xf018,
timestamp: 0x9c686cf9 Interval: 1644071
11/24/18 04:12:23 Maximum server connections 409
11/24/18 04:12:23 Checkpoint Statistics - Avg. Txn Block Time
0.000, # Txns blocked 0, Plog used 4, Llog used 1
11/24/18 04:12:23 Logical Recovery Complete.
-872217792 Committed, 68362201 Rolled Back, 0 Open, 0
Bad Locks
11/24/18 04:12:23 Logical Recovery Complete.
11/24/18 04:12:26 Quiescent Mode | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS versions prior to 12.10.xC14. * **************************************************************** * PROBLEM DESCRIPTION: * * Moving a HDR secondary to become a primary can show very * * large or negative values in commited and rolledback. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
| Local Fix: | |
This is purely cosmetic. | |
| Solution | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 26.04.2019 24.09.2019 24.09.2019 |
| Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
