github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/tests/integration_tests/multi_tables_ddl_v2/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  	# test kafka sink only in this case
    13  	if [ "$SINK_TYPE" != "kafka" ]; then
    14  		return
    15  	fi
    16  
    17  	rm -rf $WORK_DIR && mkdir -p $WORK_DIR
    18  
    19  	start_tidb_cluster --workdir $WORK_DIR
    20  
    21  	cd $WORK_DIR
    22  
    23  	# record tso before we create tables to skip the system table DDLs
    24  	start_ts=$(cdc cli tso query --pd=http://$UP_PD_HOST_1:$UP_PD_PORT_1)
    25  
    26  	run_cdc_server --workdir $WORK_DIR --binary $CDC_BINARY
    27  
    28  	TOPIC_NAME_1="ticdc-multi-tables-ddl-test-normal-$RANDOM"
    29  	TOPIC_NAME_2="ticdc-multi-tables-ddl-test-error-1-$RANDOM"
    30  	TOPIC_NAME_3="ticdc-multi-tables-ddl-test-error-2-$RANDOM"
    31  
    32  	case $SINK_TYPE in
    33  	*) ;;
    34  	esac
    35  
    36  	cf_normal="test-normal"
    37  	cf_err1="test-error-1"
    38  	cf_err2="test-error-2"
    39  
    40  	if [ "$SINK_TYPE" == "kafka" ]; then
    41  		SINK_URI="kafka://127.0.0.1:9092/$TOPIC_NAME_1?protocol=open-protocol&partition-num=4&kafka-version=${KAFKA_VERSION}&max-message-bytes=10485760"
    42  		cdc cli changefeed create -c=$cf_normal --start-ts=$start_ts --sink-uri="$SINK_URI" --config="$CUR/conf/normal.toml"
    43  
    44  		SINK_URI="kafka://127.0.0.1:9092/$TOPIC_NAME_2?protocol=open-protocol&partition-num=4&kafka-version=${KAFKA_VERSION}&max-message-bytes=10485760"
    45  		cdc cli changefeed create -c=$cf_err1 --start-ts=$start_ts --sink-uri="$SINK_URI" --config="$CUR/conf/error-1.toml"
    46  
    47  		SINK_URI="kafka://127.0.0.1:9092/$TOPIC_NAME_3?protocol=open-protocol&partition-num=4&kafka-version=${KAFKA_VERSION}&max-message-bytes=10485760"
    48  		cdc cli changefeed create -c=$cf_err2 --start-ts=$start_ts --sink-uri="$SINK_URI" --config="$CUR/conf/error-2.toml"
    49  
    50  		run_kafka_consumer $WORK_DIR "kafka://127.0.0.1:9092/$TOPIC_NAME_1?protocol=open-protocol&partition-num=4&version=${KAFKA_VERSION}&max-message-bytes=10485760"
    51  		run_kafka_consumer $WORK_DIR "kafka://127.0.0.1:9092/$TOPIC_NAME_2?protocol=open-protocol&partition-num=4&version=${KAFKA_VERSION}&max-message-bytes=10485760"
    52  		run_kafka_consumer $WORK_DIR "kafka://127.0.0.1:9092/$TOPIC_NAME_3?protocol=open-protocol&partition-num=4&version=${KAFKA_VERSION}&max-message-bytes=10485760"
    53  	else
    54  		SINK_URI="mysql://normal:123456@127.0.0.1:3306/"
    55  		cdc cli changefeed create -c=$cf_normal --start-ts=$start_ts --sink-uri="$SINK_URI" --config="$CUR/conf/normal.toml"
    56  		cdc cli changefeed create -c=$cf_err1 --start-ts=$start_ts --sink-uri="$SINK_URI" --config="$CUR/conf/error-1.toml"
    57  		cdc cli changefeed create -c=$cf_err2 --start-ts=$start_ts --sink-uri="$SINK_URI" --config="$CUR/conf/error-2.toml"
    58  	fi
    59  
    60  	run_sql_file $CUR/data/test.sql ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    61  	check_table_exists multi_tables_ddl_test.t55 ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT}
    62  	check_table_exists multi_tables_ddl_test.t66 ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT}
    63  	check_table_exists multi_tables_ddl_test.t7 ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT}
    64  	check_table_exists multi_tables_ddl_test.t88 ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT}
    65  	# sync_diff can't check non-exist table, so we check expected tables are created in downstream first
    66  	check_table_exists multi_tables_ddl_test.finish_mark ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT}
    67  	echo "check table exists success"
    68  
    69  	# changefeed test-error will not report an error, "multi_tables_ddl_test.t555 to multi_tables_ddl_test.t55" patr will be skipped.
    70  	run_sql "rename table multi_tables_ddl_test.t7 to multi_tables_ddl_test.t77, multi_tables_ddl_test.t555 to multi_tables_ddl_test.t55;" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    71  
    72  	check_changefeed_state "http://${UP_PD_HOST_1}:${UP_PD_PORT_1}" $cf_normal "normal" "null" ""
    73  	check_changefeed_state "http://${UP_PD_HOST_1}:${UP_PD_PORT_1}" $cf_err1 "normal" "null" ""
    74  	check_changefeed_state "http://${UP_PD_HOST_1}:${UP_PD_PORT_1}" $cf_err2 "failed" "ErrSyncRenameTableFailed" ""
    75  
    76  	check_sync_diff $WORK_DIR $CUR/conf/diff_config.toml 60
    77  
    78  	cleanup_process $CDC_BINARY
    79  }
    80  
    81  trap stop_tidb_cluster EXIT
    82  run $*
    83  check_logs $WORK_DIR
    84  echo "[$(date)] <<<<<< run test case $TEST_NAME success! >>>>>>"