apiVersion: api/v1
kind: Case
name: br_pitr_sysbench_pitr_restore
framework:
    generic:
        command:
            - /pitrSysbenchPiTRRestore
        workingDir: /
        image: hub-new.pingcap.net/tools/br-pitr-sysbench-pitr-restore
        imagePullPolicy: Always
        defaultTimeout: 3600
parameters:
    - type: RESOURCE
      name: dst_tidb
      default: dst-tidb
    - type: RESOURCE
      name: src_tidb
      default: src-tidb
    - type: RESOURCE
      name: br
      default: br
    - type: RESOURCE
      name: mc
      default: mc
    - type: RESOURCE
      name: workload
      default: workload
    - type: RESOURCE
      name: syncdiff
      default: syncdiff
    - type: STRING
      name: br_log_opts
      default: |
          {"storage":"s3://tmp/br-log-backup?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true","timeout":"10m", "task-name": "task1", "backup-log-options": ["--check-requirements=false"]}
    - type: STRING
      name: br_opts
      default: |
          {"storage":"s3://tmp/br-log-backup?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true","timeout":"30m", "backup-options": ["--check-requirements=false"]}
    - type: STRING
      name: br_log_restore_opts
      default: |
          {"storage":"s3://tmp/br-log-backup?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true","timeout":"120m", "restore-point-options": ["--concurrency=8", "--check-requirements=false"]}
    - type: STRING
      name: mc_rm_opts
      default: |
          {"path":"qa-minio/tmp/br-log-backup","timeout":"120m"}

summary: Run sysbench worklad, do log backup and full backup, and do PiTR restore
steps: |
    1. Start log backup
    2. Do full backup
    3. Start workload
    4. Wait checkpoint move forward
    6. Do a PiTR restore, and check data consistency (restored-ts = ts1)

expectedResult: |
    1. log backup checkpoint is normal
    2. PiTR restore is successful, and data consistency check passed

category: FUNCTIONALITY
priority: P1
supportedVersions:
    - '>6.1'
automation: AUTOMATED
tags:
    - br
    - acceptance
designer: zhangfubin@pingcap.com