启动【版本3.1.0】校验服务报错 Build data extraction task table cannot be empty

【标题描述】:启动抽取任务报错，请问是什么原因
Build data extraction task table cannot be empty

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
CentOS Linux release 7.9.2009
Linux ya-gaussdb-dev.novalocal 3.10.0-693.el7.x86_64 #1 SMP Tue Aug 22 21:09:27 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
【测试环境】(单机/1主x备x级联备):
openGauss 3.0.0 单机
MySQL 5.7

【配置文件】
application-source.yml
server:
  port: 9002
logging:
  config: # log4j2source.xml

spring:
  check:
    server-uri: http://127.0.0.1:9000
  extract:
    schema: demo
    databaseType: MS
    endpoint: SOURCE
    query-dop: 8 # openGauss database Parallel Query session config
    debezium-enable: false
    debezium-topic: topic # debezium topic
    debezium-groupId: debezium-extract-group # debezium topic groupId
    debezium-time-period: 1 # Debezium incremental migration verification time period: 24 * 60 unit: Min
    # debezium-num-period: Debezium incremental migration verification is the threshold value of the number
    # of incremental change records. The default value is 1000. The threshold value should be greater than 100
    debezium-num-period: 1000

kafka:
    bootstrap-servers: localhost:9092
  datasource:
    druid:
      dataSourceOne:
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://127.0.0.1:3306/demo?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC
        username: dts
        password: Pass@123 # The password text may contain special characters, which need to be enclosed in quotation marks
        # Configure initialization connection pool size, minimum number of connections, and maximum number of connections
        # Users can make appropriate adjustments according to the number of current database tables
        initialSize: 5 # initialization connection pool size
        minIdle: 10 # minimum number of connections
        maxActive: 20 # maximum number of connections
        testWhileIdle: false

application-sink.yml配置
server:
  port: 9001
logging:
  config: # log4j2sink.xml
spring:
  check:
    server-uri: http://127.0.0.1:9000
  extract:
    schema: demo
    databaseType: OG
    query-dop: 8 # openGauss database Parallel Query session config
    debezium-enable: false # no need config,but not delete
    debezium-topic:  # no need config,but not delete
    debezium-groupId: # no need config,but not delete
    debezium-serializer: AvroSerializer # StringSerializer or AvroSerializer
    debezium-avro-registry: http://localhost:8081 # avro schema registry
    debezium-time-period: 1 # no need config,but not delete
    debezium-num-period: 1000 # no need config,but not delete
  kafka:
    bootstrap-servers: localhost:9092
  datasource:
    druid:
      dataSourceOne:
        driver-class-name: org.opengauss.Driver
        url: jdbc:opengauss://127.0.0.1:5432/demo?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC
        username: opengauss_test
        password: 'Pass@123'  # The password text may contain special characters, which need to be enclosed in quotation marks
        # Configure initialization connection pool size, minimum number of connections, and maximum number of connections
        # Users can make appropriate adjustments according to the number of current database tables
        initialSize: 5 # initialization connection pool size
        minIdle: 10 # minimum number of connections
        maxActive: 20 # maximum number of connections
        testWhileIdle: false

【预置条件】:
全量数据校验环境搭建成功
【操作步骤】(请填写详细的操作步骤):
1. mysql5.7测试表
![输入图片说明](https://foruda.gitee.com/images/1679471058747600961/70e5906f_10300685.png "屏幕截图")
2. 启动kafaka和zookeeper
3. 启动source:
java  -Dspring.config.additional-location=config/application-source.yml -jar datachecker-extract-0.0.1.jar --spring.profiles.active=source
4. 启动sink
java -Dspring.config.additional-location=config/application-sink.yml -jar datachecker-extract-0.0.1.jar --spring.profiles.active=sink
5. 启动check
java -Dspring.config.additional-location=config/application.yml -jar datachecker-check-0.0.1.jar

报错source-extract 报错：
![输入图片说明](https://foruda.gitee.com/images/1679470819816820044/656e7630_10300685.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1679470832871352571/56b3700a_10300685.png "屏幕截图")
sink-extract错误
![输入图片说明](https://foruda.gitee.com/images/1679470799030089491/6ee24bed_10300685.png "屏幕截图")
check 日志
![输入图片说明](https://foruda.gitee.com/images/1679470862715448875/c5b499f0_10300685.png "屏幕截图")
【实际输出】:
MySQL、openGauss抽取服务报错
【原因分析】:

openGauss/openGauss-tools-datachecker-performance

内容风险标识

评论 (5)

openGauss/openGauss-tools-datachecker-performance .gitee-modal { width: 500px !important; }

内容风险标识