Urgent from Sybase: Possible data integrity issues caused to partitioned data-only locked tables when upgrading to Adaptive Server Enterprise 15
Summary: This document describes an issue that affects data integrity when upgrading to ASE15.0 and ASE15.0 ESD#1. This affects of this issue are limited to data-only locked (DOL) tables that have been partitioned. The issue is not platform specific. This problem is avoided by either upgrading to a version of ASE 15 that has had the issue fixed or by taking an extra step to complete the upgrade process.
This document contains the following sections:
- Customer Alert
A partitioned DOL table in a pre-ASE15 database is unpartitioned as part of the upgrade process when the database is upgraded to ASE15. Once the upgrade is complete, the creation of empty partitions using the ALTER TABLE...PARTITION command followed by a CREATE CLUSTERED INDEX command on the table may result in data loss. During the creation of the clustered index on larger tables Adaptive Server Enterprise can fail to qualify some data pages leading to data inconsistency and data loss.
This issue is being tracked under Sybase CR# 416514. This CR is fixed in the following EBFs, or one that supersedes it.
|Linux x86 32-bit||13247|
|Windows x86 32-bit||13248|
Workaround: Immediately after upgrading to an affected version of ASE15 you must execute the following SQL on all previously partitioned DOL tables that have been unpartitioned during the upgrade. Once this command completes successfully, you may then proceed with re-partitioning and re-indexing the objects.
select count(*) from <tablename> (index <tablename>)
Symptoms: If you have already conducted an upgrade to ASE15 with a database that contained a partitioned DOL table and you have re-partitioned and re-indexed it without completing the step above first, there is a possibility the table has missing data. Perform a select count(*) from <tablename> in order to determine if the table has the correct number of rows.
Sybase strongly recommends that either the work around above is used or the upgrade is done with a version of ASE15 that has CR# 416514 fixed in it.
The EBFs can be obtained from the Sybase EBFs and Maintenance site.
Follow the instructions in the EBF cover letter to install the EBF.
If you require further assistance please contact your local support center. The contact numbers can be found in the About Support section under Support & Services at the www.sybase.com website.