Backing up cases in eDiscovery Platform hangs, resulting in an error stating connection lost to MySQL
Article ID: 100014912
Updated On:
Description
Error Message
The following excerpts can be found in the Server Log of the case home for the failing case:
INFO [cluster.locator.backup] (running-thpool.jobmanager.0.27308.1.5.19.4294970110:) CaseName:[] UserName:[
com.teneo.esa.common.exception.TeneoRuntimeException: [#80088] Runtime error: D:/mysql/bin/mysqldump.exe -v --lock-tables=FALSE -h localhost -u esadbuser -p*** esadb_lds_case_a5xirmssms : -- Connecting to localhost...
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `t_generic_data` at row:
at com.teneo.esa.common.process.Command.executeStreams(Command.java:305)
at com.teneo.esa.common.database.MySQLAssistant.backupDatabase(MySQLAssistant.java:305)
at com.teneo.esa.cluster.DBInstanceManager.exportDBInstance(DBInstanceManager.java:403)
at com.teneo.esa.cluster.ClusterUpdateService.backupLocator(ClusterUpdateService.java:1229)
at com.teneo.esa.cluster.ClusterUpdateService.backupLocators(ClusterUpdateService.java:1024)
at com.teneo.esa.cluster.ClusterUpdateService.access$900(ClusterUpdateService.java:107)
at com.teneo.esa.cluster.ClusterUpdateService$8.call(ClusterUpdateService.java:998)
at com.teneo.esa.admin.service.AbstractService.ensureReady(AbstractService.java:1425)
at com.teneo.esa.cluster.ClusterServiceBase.abortableLeasedEnsureReady(ClusterServiceBase.java:163)
at com.teneo.esa.cluster.ClusterUpdateService.backupDataStores(ClusterUpdateService.java:1003) Workaround:
A manual backup of the case can be run.
Resolution
Scheduled case backups in eDP run 3 concurrently by default.
Lowering concurrent backups to 1 at a time should resolve the issue.
This can be done with the following steps:
1. Log into the eDP User Interface.
2. System > Support Features
3. Select Property Browser from the drop down.
4. In Name of property to change put:
esa.jobmanager.type.CASE_BACKUP.nodeExecutionThrottle
5. In New value (leave blank to remove) put:
1
6. Hit Submit
7. Restart the eDP services via Clearwell Utility option 3 and then 4.
Issue/Introduction
