:DTS-077100: An exception occurred while data synchronization to the target database

Problem description

The following error message is displayed when a DTS task data synchronization to the ELK Stack.

DTS-077100: Record Replicator error in table bangkaowang_data.answer. cause by [java.sql.SQLException: java.sql.SQLException: blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];] About more information in [https://yq.aliyun.com/articles/508049].

Cause

If the indexes have read-only parameters, when the disk usage of each data node in the Elasticsearch cluster exceeds 95%, the automatic protection of Elasticsearch is triggered.

Solution

Under normal circumstances, you must first clean the unwanted index or history of obsolete data, or forcing the disk to free up disk space, disk usage falls below 85% after, and then restore cluster writing functions. The following are the specific operation steps.

1. Log on to the Kibana console and run the following command:

   PUT _all/_settings
   {
   "index": {
     "blocks": {
       "read_only_allow_delete": null
       }
     }
   }

2. If an error is reported, run the following command:

   PUT _settings
   {
   "index": {
     "blocks": {
       "read_only_allow_delete": null
       }
     }
   }

Application scope

• Data Transmission Service (DTS)