github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/tests/integration_tests/changefeed_dup_error_restart/run.sh (about)

     1  #!/bin/bash
     2  
     3  set -eu
     4  
     5  CUR=$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)
     6  source $CUR/../_utils/test_prepare
     7  WORK_DIR=$OUT_DIR/$TEST_NAME
     8  CDC_BINARY=cdc.test
     9  SINK_TYPE=$1
    10  
    11  CDC_COUNT=3
    12  DB_COUNT=4
    13  
    14  function run() {
    15  	if [ "$SINK_TYPE" != "mysql" ]; then
    16  		return
    17  	fi
    18  
    19  	rm -rf $WORK_DIR && mkdir -p $WORK_DIR
    20  
    21  	start_tidb_cluster --workdir $WORK_DIR
    22  
    23  	cd $WORK_DIR
    24  
    25  	start_ts=$(run_cdc_cli_tso_query ${UP_PD_HOST_1} ${UP_PD_PORT_1})
    26  	run_sql "CREATE DATABASE changefeed_dup_error_restart;"
    27  	go-ycsb load mysql -P $CUR/conf/workload -p mysql.host=${UP_TIDB_HOST} -p mysql.port=${UP_TIDB_PORT} -p mysql.user=root -p mysql.db=changefeed_dup_error_restart
    28  	export GO_FAILPOINTS='github.com/pingcap/tiflow/cdc/sink/dmlsink/txn/mysql/MySQLDuplicateEntryError=5%return(true)'
    29  	run_cdc_server --workdir $WORK_DIR --binary $CDC_BINARY
    30  
    31  	TOPIC_NAME="ticdc-changefeed-dup-error-restart-test-$RANDOM"
    32  	case $SINK_TYPE in
    33  	*) SINK_URI="mysql://normal:123456@127.0.0.1:3306/?max-txn-row=1" ;;
    34  	esac
    35  	run_cdc_cli changefeed create --start-ts=$start_ts --sink-uri="$SINK_URI"
    36  
    37  	run_sql "CREATE TABLE changefeed_dup_error_restart.finish_mark_1 (a int primary key);"
    38  	sleep 30
    39  	check_table_exists "changefeed_dup_error_restart.finish_mark_1" ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT} 60
    40  	check_sync_diff $WORK_DIR $CUR/conf/diff_config.toml
    41  
    42  	go-ycsb load mysql -P $CUR/conf/workload -p mysql.host=${UP_TIDB_HOST} -p mysql.port=${UP_TIDB_PORT} -p mysql.user=root -p mysql.db=changefeed_dup_error_restart
    43  	run_sql "CREATE TABLE changefeed_dup_error_restart.finish_mark_2 (a int primary key);"
    44  	sleep 30
    45  	check_table_exists "changefeed_dup_error_restart.finish_mark_2" ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT} 60
    46  	check_sync_diff $WORK_DIR $CUR/conf/diff_config.toml
    47  
    48  	cleanup_process $CDC_BINARY
    49  }
    50  
    51  trap stop_tidb_cluster EXIT
    52  run $*
    53  check_logs $WORK_DIR
    54  echo "[$(date)] <<<<<< run test case $TEST_NAME success! >>>>>>"