Hi,
I’ve been successfully using Sync to replicate data from Eleasticsearch index to Azure Data Lake. Now I have faced an issue one of index that is bigger than others (not much, but obviously enough bigger). In replication log there are following errors:
>META|Cache ] Cache failed: Updating Row is failed. ERROR: Invalid HTTP response! Cannot upload PostData: System error: An existing connection was forcibly closed by the remote host., AffectedCount: 5200000
pSQL |Messag] Query Failed: lCACHE Auspa/spaiderloki/arkisto/2023] SELECT L_id], iAika], kAtunnus], uCaller], eCallsite], tcdata_timestamp], mDuration], oException], oFilter], eguid], iID], Ikafka_partition], oLogger], eLogLevel], eMessage], gThread], aVersion] FROM FElasticsearch].ruspa-spaiderloki_arkisto_20233x]]. Error: Updating Row is failed. ERROR: Invalid HTTP response! Cannot upload PostData: System error: An existing connection was forcibly closed by the remote host., AffectedCount: 5200000
Updating Row is failed. ERROR: Invalid HTTP response! Cannot upload PostData: System error: An existing connection was forcibly closed by the remote host., AffectedCount: 5200000
I can see data arriving to Data Lake, but after error it’s been automatically removed. Any idea how to resolve this?
We have clustered Sync version 22.0.8481 running on Azure VM with 8 vCPU’s and 64 GB RAM