github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/tests/integration_tests/processor_resolved_ts_fallback/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  function run() {
    12  	# TODO: kafka sink has bug with this case, remove this after bug is fixed
    13  	if [ "$SINK_TYPE" == "kafka" ]; then
    14  		return
    15  	fi
    16  
    17  	rm -rf $WORK_DIR && mkdir -p $WORK_DIR
    18  	start_tidb_cluster --workdir $WORK_DIR
    19  	cd $WORK_DIR
    20  
    21  	export GO_FAILPOINTS='github.com/pingcap/tiflow/cdc/sink/dmlsink/txn/mysql/MySQLSinkExecDMLError=return(true);github.com/pingcap/tiflow/cdc/sink/dmlsink/mq/dmlproducer/KafkaSinkAsyncSendError=return(true)'
    22  	run_cdc_server --workdir $WORK_DIR --binary $CDC_BINARY --logsuffix "1" --addr "127.0.0.1:8301" --pd "http://${UP_PD_HOST_1}:${UP_PD_PORT_1}"
    23  
    24  	TOPIC_NAME="ticdc-processor-resolved-ts-fallback-test-$RANDOM"
    25  	case $SINK_TYPE in
    26  	kafka) SINK_URI="kafka://kafka01:9092/$TOPIC_NAME?partition-num=4&kafka-version=${KAFKA_VERSION}&max-message-bytes=10485760" ;;
    27  	storage) SINK_URI="file://$WORK_DIR/storage_test/$TOPIC_NAME?protocol=canal-json&enable-tidb-extension=true" ;;
    28  	pulsar)
    29  		run_pulsar_cluster $WORK_DIR normal
    30  		SINK_URI="pulsar://127.0.0.1:6650/$TOPIC_NAME?protocol=canal-json&enable-tidb-extension=true"
    31  		;;
    32  	*) SINK_URI="mysql://normal:123456@127.0.0.1:3306/" ;;
    33  	esac
    34  	run_cdc_cli changefeed create --sink-uri="$SINK_URI" --server="127.0.0.1:8301"
    35  	case $SINK_TYPE in
    36  	kafka) run_kafka_consumer $WORK_DIR "kafka://127.0.0.1:9092/$TOPIC_NAME?protocol=open-protocol&partition-num=4&version=${KAFKA_VERSION}&max-message-bytes=10485760" ;;
    37  	storage) run_storage_consumer $WORK_DIR $SINK_URI "" "" ;;
    38  	pulsar) run_pulsar_consumer --upstream-uri $SINK_URI ;;
    39  	esac
    40  
    41  	run_sql "CREATE database processor_resolved_ts_fallback;" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    42  	run_sql "CREATE table processor_resolved_ts_fallback.t1(id int primary key auto_increment, val int);" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    43  	# wait table t1 is processed by cdc server
    44  	ensure 10 "cdc cli processor list --server http://127.0.0.1:8301 |jq '.|length'|grep -E '^1$'"
    45  	# check the t1 is replicated to downstream to make sure the t1 is dispatched to cdc1
    46  	check_table_exists "processor_resolved_ts_fallback.t1" ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT}
    47  
    48  	export GO_FAILPOINTS=''
    49  	run_cdc_server --workdir $WORK_DIR --binary $CDC_BINARY --logsuffix "2" --addr "127.0.0.1:8302" --pd "http://${UP_PD_HOST_1}:${UP_PD_PORT_1}"
    50  	run_sql "CREATE table processor_resolved_ts_fallback.t2(id int primary key auto_increment, val int);" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    51  	run_sql "CREATE table processor_resolved_ts_fallback.t3(id int primary key auto_increment, val int);" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    52  	check_table_exists "processor_resolved_ts_fallback.t2" ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT}
    53  	check_table_exists "processor_resolved_ts_fallback.t3" ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT}
    54  	ensure 10 "cdc cli processor list --server http://127.0.0.1:8301 |jq '.|length'|grep -E '^2$'"
    55  
    56  	run_sql "INSERT INTO processor_resolved_ts_fallback.t1 values (),(),();" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    57  	cdc1_pid=$(lsof -i TCP:8301 -s TCP:LISTEN -t 2>/dev/null)
    58  	echo "killing cdc1: $cdc1_pid"
    59  	kill -9 $cdc1_pid &>/dev/null || true
    60  	# wait cdc server 1 is panic
    61  	ensure 10 "cdc cli capture list --server http://127.0.0.1:8302 |jq '.|length'|grep -E '^1$'"
    62  	run_sql "INSERT INTO processor_resolved_ts_fallback.t1 values (),(),();" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    63  	run_sql "INSERT INTO processor_resolved_ts_fallback.t2 values (),(),();" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    64  
    65  	check_sync_diff $WORK_DIR $CUR/conf/diff_config.toml
    66  
    67  	cleanup_process $CDC_BINARY
    68  }
    69  
    70  trap stop_tidb_cluster EXIT
    71  run $*
    72  check_logs $WORK_DIR
    73  echo "[$(date)] <<<<<< run test case $TEST_NAME success! >>>>>>"