1、问题现象

数据看板的客流数据不更新了

2、解决步骤

2.1、检查所有连接器状态

登录debezium服务器，执行如下命令

cd /data/scripts/release/

sh /data/scripts/release/check_and_restart_connectors.sh  或 ./check_and_restart_connectors.sh

如果输出里面提示有连接器报错，但是重启失败，根据失败提示处理，实在不行，则手动重启。

2.2、手动重启报错的连接器

curl -X DELETE debezium服务器的ip:8083/connectors/报错的连接器名称

cd /data/scripts/release/

curl -i -X POST -H “Accept:application/json” -H “Content-Type:application/json” debezium服务器的ip:8083/connectors/ -d @报错的连接器名称.json

2.3、检查重启后连接器的状态

curl -s debezium服务器的ip:8083/connectors/报错的连接器名称/status | jq

[root@localhost release]# curl -s debezium服务器的ip:8083/connectors/hongli-release-connect/status | jq
{
  "name": "hongli-release-connect",
  "connector": {
    "state": "RUNNING",
    "worker_id": "172.17.0.1:8083"
  },
  "tasks": [
    {
      "id": 0,
      "state": "RUNNING",
      "worker_id": "172.17.0.1:8083"
    }
  ],
  "type": "source"
}

结果如上图则说明已经正常。