Skip to main content
Delphix

SnapSync of an ASE Database Fails with Error 5.16.2.2 when Choosing "New full backup" Option (KBA1482)

 

 

KBA

KBA#1482

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0 6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1, 6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0, 6.0.10.0, 6.0.10.1, 6.0.11.0

5.3

5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0, 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0

5.2

5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1, 5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

Issue

Running a SnapSync of a Sybase database with the "New full backup" option fails with an error similar to the following.

Run SnapSync for database "bucks".

Failed to dump the database "bucks" on instance "RH65_ASE16_S1" using backup server "RH65_ASE16_TGT_S1_BS": 501602: Backup Server: 5.16.2.2: Client-Library error: Error number 44, Layer 4, Origin 1, Severity 4: ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.

Make sure that the backup servers are configured correctly between the source instance "RH65_ASE16_S1" and the staging instance "RH65_ASE16_TGT_S1", and try the operation again.

Troubleshooting

The Sybase backup server error log on the staging host, /opt/sybase/errorlogs/RH65_ASE16_TGT_S1_BS.log, shows the reason for the failed connection attempt from the source host.

Aug  6 05:42:33 2016: Backup Server: 2.24.2.1: The host '10.43.43.196' is not authorized to connect to this Backup Server.
Aug  6 05:42:33 2016: Backup Server: 5.40.2.1: Login host authentication has failed.

Cause

Sybase ASE 15.7 SP50 introduced Remote Dump Host Control which provides the ability to restrict connections to the backup server to only specified hosts.

Resolution

Client hosts can be added using the Sybase hosts.allow file on the staging host. By default, it resides in the $SYBASE directory but the current location is shown in the backup server log file during start-up, for example:

Aug  6 01:25:19 2016: Backup Server: 1.88.1.1: The hosts authentication file used by the backup server is '/opt/sybase/16-0/hosts.allow'.

The hosts.allow file can be created if it does not already exist. The file contains entries of the following form, specifying the IP address or hostname of the system running the backupserver process and the client system that is attempting to connect.

<host_running_backup_server>    <host_trying_to_connect>