Synchronizing an ASE dSource After Performing an ASE Reorg Rebuild (KBA5293)

Issue

Following a "reorg rebuild" on a table in an ASE database, ASE requires a full database dump before transaction log dumps can be performed (refer to ASE reorg rebuild documentation). Delphix is unable to resume loading transaction logs until it first loads the full database dump.

Once Delphix ingests a full database dump, a background process called "Validated Sync" starts running on Delphix to keep it synchronized with the source database. Currently Validated Sync synchronizes itself with the source database by ingesting either transaction logs or full database dumps but not both:

• If "truncate log on chkpt = true", Delphix ingests full database dumps.
• If "truncate log on chkpt = false", Delphix ingests transactions logs (after ingesting an initial full database dump to get started).

In the case of a dSource that is ingesting transaction logs, Delphix skips the full database dump and tries to load the subsequent transaction log. A fault similar to the following will be raised:

Title Validated sync failed for dSource
Target bigdb
Details Validated sync failed for dSource "bigdb". For dSource "bigdb", failed to load a source transaction dump 4305: Specified file 'dump device' is out of sequence. Current time stamp is Dec 11 2019 12:00:01:053PM while dump was from Dec 11 2019 12:57:26:953PM.

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies

Major Release	All Sub Releases
All	All

Resolution

To resolve this issue, it is necessary to ask Delphix to ingest the full database dump that is taken right after the ASE reorg rebuild job/script completes. There are many ways to make Delphix ingest the backup:

Click the camera icon for the dSource and ask Delphix to ingest the "Most Recent Existing Full Backup" or "Specific Existing Full Backups".

The same ask can be initiated using the Delphix Command Line Interface (CLI) or APIs. These can be incorporated in a script for automation.

Some customers who have faced this issue have added the dxtoolkit dx_snapshot_db ( https://github.com/delphix/dxtoolkit/wiki/dx_snapshot_db ) command to their ASE "reorg rebuild" script such that it loads the full database dump created after the "reorg rebuild" command completes. For example:

$ isql -Udb_user -Pdb_password -S ASE160 -i reorg_rebuild.sql
$ isql -Udb_user -Pdb_password -S ASE160 -i dump_database_ABC.sql
$ dx_snapshot_db -engine neal5350.dcenter.delphix.com -name bigdb --usebackup yes

Troubleshooting

Does the database in question have the ASE "reorg rebuild" command run against it (typically a weekend activity)? If so, look for these types of faults being thrown by Delphix:

Title Validated sync failed for dSource
Target bigdb
Details Validated sync failed for dSource "bigdb". For dSource "bigdb", failed to load a source transaction dump 4305: Specified file 'dump device' is out of sequence. Current time stamp is Dec 11 2019 12:00:01:053PM while dump was from Dec 11 2019 12:57:26:953PM.