resources

December 15, 2011 – Update: Database Defragmentation, Database Compaction, or $PREFETCHON May Cause Corruption

This alert supersedes the alert: “December 5, 2011– Database Defragmentation, Database Compaction, or $PREFETCHON May Cause Corruption ”

InterSystems has determined that only the following specific platforms and version combinations of Caché and Ensemble are at risk of being affected by the defect identified in the earlier alert:

  • Windows: All currently released versions of Caché beginning with 5.0.21, and all currently released versions of Ensemble beginning with 3.0
  • VMS: All currently released versions of Caché beginning with 5.0.21, and all currently released versions of Ensemble beginning with 3.0
  • OSX: All currently released versions of Caché beginning with 2011.1.0
  • Linux: All currently released versions of Caché beginning with 2011.1.0

Other platforms and version combinations are not at risk of being affected by this defect.

Please see the text of the earlier alert for further details:

” December 5, 2011 – Alert: Database Defragmentation, Database Compaction, or $PREFETCHON May Cause Corruption

InterSystems has corrected a defect that can cause corruption while using any of the following features:

  • The Legacy GCOMPACT utility
  • The $PREFETCHON function (if used by your application code)
  • Database Compaction
  • Database Defragmentation

This defect affects Caché versions 5.0 through the latest release (2011.1.2) and Ensemble version 3.0 through the latest release (2010.2).

This defect can be triggered when any of the above operations coincides with a database expansion; if you have not used any of the above features, this defect doesn’t impact your database(s). Additionally, if you have used any of the above features, and have since run a successful integrity check of the database(s) in question, this defect didn’t impact your database(s).

The correction for this defect, identified as JO2486, will be included in all future Caché and Ensemble releases including maintenance releases. The correction is also available via Ad Hoc distribution.

Until the correction is in place, the Database Defragmentation, Database Compaction, Legacy GCOMPACT, and $PREFETCHON features should not be used.

If you have used any of these features, InterSystems recommends performing an integrity check of the database(s) in question.”

If you have any questions regarding this, please contact InterSystems Worldwide Response Center (WRC).


December 5, 2011 – Alert: Database Defragmentation, Database Compaction, or $PREFETCHON May Cause Corruption

This alert has been superseded by the December 15 alert.


July 15, 2011 – Alert: Database Compaction May Cause Corruption

InterSystems has identified a defect in the Database Compaction feature that can cause the target database to become corrupted.

The Database Compaction feature was introduced in Caché and Ensemble versions 2010.2, and all releases 2010.2.0 and later are at risk.  The older global compaction utility, ^GCOMPACT, is not affected.

The correction for this defect will appear in all future releases.  Until the correction is in place, the Database Compaction feature should not be used.  If you have used Database Compaction to compact a database, InterSystems recommends performing an integrity check of that database to verify that no corruption has occurred.

If you have any questions regarding this, please contact InterSystems Worldwide Response Center (WRC).


May 3, 2011 – Caché & Ensemble 2010.2.4 Recalled

InterSystems has discovered a defect in the recently released Caché and Ensemble 2010.2.4 that can cause the upgrade to this version to fail, or startup immediately following upgrade to fail.  This distribution has been recalled.  If you have already received a distribution of this version please contact InterSystems Worldwide Response Center (WRC).

The defect affects Caché and Ensemble on all platforms and operating systems.

A correction will be included in the upcoming 2010.2.5 release.


February 14, 2011 – Alert: Missing Shadowing Updates

InterSystems has corrected a defect in Caché Shadowing that can result in updates being skipped on the destination shadow.

The defect affects Caché and Ensemble versions 2008.1.0 through 2010.2.2 on all platforms and operating systems.

This defect can be triggered during a journal switch or rollover on the shadowing source database server. When triggered, a small number of records at the end of the previous journal will not be applied on the destination shadow.  Data on the shadowing source is unaffected.

The likelihood of encountering this defect is low, however, when encountered there is no indication on the destination shadow that records have been skipped.

The correction for this defect, identified as HYY1619, will be included in all future Caché and Ensemble releases including maintenance releases.  The correction is also available via Ad Hoc distribution.

If you have any questions regarding this, please contact InterSystems Worldwide Response Center (WRC).


January 6, 2011 – Alert: Online Backup Unsafe on 2010.2 for AIX

InterSystems has corrected a defect that can cause problems when using Caché Online Backup. The defect affects Caché and Ensemble versions 2010.2.1 and 2010.2.2 only on AIX systems.

As a result of this defect, if a Caché Online Backup is performed, any or all of the following problems may occur:

  • The backup may fail with <DATABASE> or <DATABASE MAP LABEL> errors.
  • Later restoration of the backup (either a failed or successful backup) may result in a corrupt database.
  • The Write Image Journal file may become corrupt, compromising the ability to recover from a crash.

The correction for this defect is identified as WDS378. It is available via Ad Hoc Distribution, and will be included in all future releases.

Sites at risk need to take two corrective actions:

  • Implement a safe backup strategy until the correction can be installed.
  • Check for Write Image Journal corruption and correct it if found.

Safe Backup Strategy:  Discontinue use of Caché Online Backup until the correction can be installed. The recommended backup strategy is External Backup, which typically allows for zero downtime backups. Documentation is available online.

Write Image Journal Corruption:  You can determine if the Write Image Journal (WIJ) has become corrupt with the following OS command. It should be run from the manager’s directory of your Caché/Ensemble installation:

../bin/cwdimj -s. -j[path_to_WIJ] -d1

If the WIJ has been corrupted in this way, the output of that command will report “Format incompatible with current version”.  To correct this corruption, a clean shutdown and restart of Caché/Ensemble must be scheduled at the earliest convenience.

If you have further questions regarding this, please contact the InterSystems Worldwide Response Center (WRC).