Data Protection Advisor - SSL SYSCALL error when importing datastore

Summary: Running a datastore import fails within 2 minutes with SSL SYSCALL error

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.

Symptoms

On the DPA datastore, when running a datastore import using the following command:

Linux:  <install dir>/emc/dpa/services/bin> ./dpa.sh ds import <location and name of import file> --debug
Windows<install dir>\emc\dpa\services\bin> dpa ds import <location and name of import file> --debug
The --debug parameter is not mandatory but it displays details on the import progress on the screen.
The following error is observed:
[DEBUG] pg_restore: processing data for table "dpa.bkup_ddclone"
[DEBUG] pg_restore: processing data for table "dpa.backupevent"
[DEBUG] pg_restore: processing data for table "dpa.backup_media"
[DEBUG] pg_restore: processing data for table "dpa.backupjob"
[DEBUG] pg_restore: error: error returned by PQputCopyData: SSL SYSCALL error: EOF detected
[DEBUG] pg_restore: error: a worker process died unexpectedly
Completed in : 1min 52secs

Cause

This error is caused by low memory resources on the DPA Datastore server.

Resolution

Confirm the minimum memory requirements are configured, which is outlined in the DPA Administration Guide.
DPA also needs to be tuned for the memory resources on the server.

Example, if 32GB of memory is allocated to the server, DPA should be tuned as follows:
Linux<install dir>/emc/dpa/services/bin> ./dpa.sh ds tune 32GB
Windows: <install dir>\emc\dpa\services\bin> dpa ds 32GB

The DPA service needs to be restarted for the tuning to take affect:
Linux:  <install dir>/emc/dpa/services/bin> ./dpa.sh ds restart
Windows<install dir>\emc\dpa\services\bin> dpa ds restart

The import should now complete successfully.
Please contact DELL Technical Support for further information.

Affected Products

Data Protection Advisor
Article Properties
Article Number: 000213154
Article Type: Solution
Last Modified: 30 Aug 2023
Version:  3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.