IBM Support

After applying Rational Synergy patch Informix fails to start with "Open transaction detected when changing log versions" error

Troubleshooting


Problem

Attempts to upgrade IBM Rational Synergy results in the IBM Informix server failing to come online with the error "Open transaction detected when changing log versions".

Symptom

Your Informix online.log shows messages similar to the following:

10:00:15 Conversion from version 11.50 Started
10:00:16 RESTORE_POINT_DIR '/ccm/ccm_71/informix/tmp/1' contains old restore point files /ccm/ccm_71/informix/tmp/1/reserved_pages'
10:00:16 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

10:00:16 Started 1 B-tree scanners.
10:00:16 B-tree scanner threshold set at 5000.
10:00:16 B-tree scanner range scan size set to -1.
10:00:16 B-tree scanner ALICE mode set to 6.
10:00:16 B-tree scanner index compression level set to med.
10:00:16 Physical Recovery Started at Page (1:2362).
10:00:16 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
10:00:16 Logical Recovery Started.
10:00:16 10 recovery worker threads will be started.
10:00:16 Open transaction detected when changing log versions.
10:00:17 Cannot Rollforward from Checkpoint.
10:00:18 oninit: Fatal error in shared memory initialization

10:00:18 IBM Informix Dynamic Server Stopped.

10:00:18 mt_shm_remove: WARNING: may not have removed all/correct segments

Cause

This happens when your Informix IDS server version is upgraded as part of Rational Synergy patch (for example Synergy 7.1.0.5) and not all transactions were closed before the original Informix instance was upgraded.

The onrestorept failed, as the directory containing the backup files (/tmp/0) was void of any data and no actual migration has taken place.

See Technote 1308083: Upgrade to IDS 11.50 fails with open transaction and rollfoward errors for additional information on the Informix error.

Diagnosing The Problem

If your IDS instance fails to come online following a Rational Synergy patch installation, check your Informix online.log for the following error messages:

  • Open transaction detected when changing log versions
  • Cannot Rollforward from Checkpoint
  • oninit: Fatal error in shared memory initialization"

If there errors are present then it seems likely that not all transactions were closed before the original instance was shut down. The upgrade of Informix IDS did not complete and the patch needs to be reapplied.

Resolving The Problem

Resolve the existing problem:

    If you have already encountered this problem then the only resolution is to return to a valid backup of your database by:
    • Deleting the database and unpacking it again form a reliable backup

    or
    • Deleting the Informix part of the database and restoring just the Informix data from a reliable backup. Rational Client Support should be contacted to do this correctly.

Prevent the problem in future:
  • Shutdown the Rational Synergy database.

      • To make sure to complete all Informix IDS transactions before attempting to apply any Rational Synergy patches which include an update for Informix IDS. You can do this by shutting down the database using the command ccmdb shutdown <database path> before applying the patches or upgrades.
or
  • Rollback any open Informix IDS transactions.

[{"Product":{"code":"SSC6Q5","label":"Rational Synergy"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"General Information","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF027","label":"Solaris"},{"code":"PF016","label":"Linux"},{"code":"PF010","label":"HP-UX"},{"code":"PF002","label":"AIX"}],"Version":"7.1.0.5;7.1.0.6;7.2;7.2.0.1;7.2.0.2;7.2.0.3","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
22 December 2020

UID

swg21618610

Page Feedback