Skip to content

[BugFix] Fix materialized view cannot refresh in different database. #52806

[BugFix] Fix materialized view cannot refresh in different database.

[BugFix] Fix materialized view cannot refresh in different database. #52806

Triggered via pull request October 24, 2024 14:20
Status Success
Total duration 24s
Artifacts

ci-doc-checker.yml

on: pull_request_target
DOC FILTER
4s
DOC FILTER
ADD DOC LABEL
0s
ADD DOC LABEL
REMOVE DOC LABEL
2s
REMOVE DOC LABEL
markdownlint
0s
markdownlint
behavior-unchange
0s
behavior-unchange
Fit to window
Zoom out
Zoom in

Annotations

51 errors and 3 warnings
REMOVE DOC LABEL
Error: failed to remove labels: documentation
TestSQLCases.test_partial_update: TestSQLCases#L1
Regex didn't match: '.*column mode partial update on table with sort key cannot update sort key column.*' not found in "E: (5025, 'no associated load channel 6a7257d2-921d-11ef-8bad-00163e04bc6d')" : sql result not match regex: - [SQL]: update tab3 set v1 = 1111, v2 = (select sum(tab2.v2) from tab2); - [exp]: .*column mode partial update on table with sort key cannot update sort key column.* - [act]: E: (5025, 'no associated load channel 6a7257d2-921d-11ef-8bad-00163e04bc6d') ---
TestSQLCases.test_runtime_filter_push_down_on_local_right_offsprings_of_broadcast_join_with_grf_for_colocate: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset'))
TestSQLCases.test_rewrite_sum_by_associative_rule: TestSQLCases#L1
Element counts were not equal: First has 1, Second has 0: '5\t10' First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.21.249.180 alive: true inBlacklist: true] [172.21.249.179 alive: true inBlacklist: false] [172.21.249.181 alive: true inBlacklist: false] ')" : sql result not match: - [SQL]: select sum(t1.c0+1),sum(t1.c1+1) from t0 right outer join t1 on t0.c0 = t1.c0; - [exp]: ['5\t10'] - [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.21.249.180 alive: true inBlacklist: true] [172.21.249.179 alive: true inBlacklist: false] [172.21.249.181 alive: true inBlacklist: false] ')"] ---
TestSQLCases.test_runtime_filter_push_down_on_local_right_offsprings_of_broadcast_join_with_grf: TestSQLCases#L1
Element counts were not equal: First has 1, Second has 0: '-9052740415' First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.21.249.180 alive: true inBlacklist: true] [172.21.249.179 alive: true inBlacklist: false] [172.21.249.181 alive: true inBlacklist: false] ')" : sql result not match: - [SQL]: with cte0 as ( select t1.c0, sum(murmur_hash3_32(t1.c1)) as c1, sum(murmur_hash3_32(t1.c2)) as c2 from t1 group by t1.c0 ), cte1 as( select coalesce(cte0.c0, -1) as c0, sum(cte0.c1) c1, sum(cte0.c2) c2, sum(murmur_hash3_32(t0.c0)) as d0, sum(murmur_hash3_32(t0.c1)) as d1, sum(murmur_hash3_32 (t0.c2)) as d2 from cte0 INNER JOIN[broadcast] t0 on t0.c0 = cte0.c0 group by 1 ), cte2 as( select cte1.c0, cte1.c1, cte1.c2, cte1.d0, cte1.d1, cte1.d2, murmur_hash3_32(t2.c0) as e0, murmur_hash3_32(t2.c1) as e1, murmur_hash3_32(t2.c2) as e2 from cte1 inner join[shuffle] t2 on cte1.c0 = t2.c0 ) select coalesce(sum(murmur_hash3_32(c0)+c1+c2+d0+d1+d2+e0+e1+e2), 0) as fingerprint from cte2; - [exp]: ['-9052740415'] - [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.21.249.180 alive: true inBlacklist: true] [172.21.249.179 alive: true inBlacklist: false] [172.21.249.181 alive: true inBlacklist: false] ')"] ---
TestSQLCases.test_query_cache_use_fresh_global_dict: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (5025, '[E111]Fail to connect Socket{id=25769803983 addr=172.21.249.180:8060} (0x0x7efdbb827b40): Connection refused [R1][E112]Not connected to 172.21.249.180:8060 yet, server_id=25769803983 [R2][E112]Not connected to 172.21.249.180:8060 yet, server_id=25769803983 [R3][E112]Not connected to 172.21.249.180:8060 yet, server_id=25769803983: be:172.21.249.180: BE:10003'))
TestSQLCases.test_same_correlation_col_in: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_parse_and_rewrite_or_predicate: TestSQLCases#L1
Element counts were not equal: First has 1, Second has 0: '426666' First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.21.249.180 alive: true inBlacklist: true] [172.21.249.179 alive: true inBlacklist: false] [172.21.249.181 alive: true inBlacklist: false] ')" : sql result not match: - [SQL]: select count(1) from t1 where concat(c_str_3_low1, '1') < 'b1'; - [exp]: ['426666'] - [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.21.249.180 alive: true inBlacklist: true] [172.21.249.179 alive: true inBlacklist: false] [172.21.249.181 alive: true inBlacklist: false] ')"] ---
TestSQLCases.test_resource_group_exclusive_cpu_cores_borrowing_cpu: TestSQLCases#L1
[CONCURRENCY] FAIL: - Thread-thread name 1-0-0 - Thread-thread name 2-1-0 - Thread-thread name 5-4-0 - Thread-thread name 3-2-0 - Thread-thread name 4-3-0
TestSQLCases.test_sample_collection: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_schema_change: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_schema_change_for_add_optimization: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_schema_change_with_sync_mv: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_schema_scan_rpc_failed: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'sending update failpoint status request fails'))
TestSQLCases.test_select_after_truncate_list_partition: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_select_async_mv: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_select_be_bvars: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.21.249.180 alive: true inBlacklist: true] [172.21.249.179 alive: true inBlacklist: false] [172.21.249.181 alive: true inBlacklist: false] '))
TestSQLCases.test_select_from_be_tablets_with_any_priv: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_select_into_outfile: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_select_into_outfile_csv_inconsistent_converter_and_column: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_select_out_file: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_serialize_key_agg: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_set_partition_version: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_short_circuit: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_short_circuit_unique: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_show_column: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_show_create_routine_load_basic: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_show_materialized_view: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_single_replica: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_single_table_mv_rewrite: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_skew_join: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_skewed_partition: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_sink_nested_map: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'Access storage error. Error message: failed to get file schema: Unable to validate object, host: 172.21.249.180'))
TestSQLCases.test_sort_key_agg_tbl_with_rollup: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_sink_nested_list: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.21.249.180 alive: true inBlacklist: true] [172.21.249.179 alive: true inBlacklist: false] [172.21.249.181 alive: true inBlacklist: false] '))
TestSQLCases.test_session_number_window_function: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
TestSQLCases.test_pipeline_level_runtime_filter: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (5025, '[E104]Fail to read from Socket{id=204 fd=207 addr=172.21.249.180:8060:40738} (0x0x7efdbb8273c0): Connection reset by peer [R1][E112]Not connected to 172.21.249.180:8060 yet, server_id=204 [R2][E112]Not connected to 172.21.249.180:8060 yet, server_id=204 [R3][E112]Not connected to 172.21.249.180:8060 yet, server_id=204: BE:10003'))
TestSQLCases.test_resource_group_big_query: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (5025, '[E104]Fail to read from Socket{id=204 fd=207 addr=172.21.249.180:8060:40738} (0x0x7efdbb8273c0): Connection reset by peer [R1][E112]Not connected to 172.21.249.180:8060 yet, server_id=204 [R2][E112]Not connected to 172.21.249.180:8060 yet, server_id=204 [R3][E112]Not connected to 172.21.249.180:8060 yet, server_id=204'))
TestSQLCases.test_sr_8537: TestSQLCases#L1
0 != 7 : [SHELL ERROR] - cmd : shell: curl --location-trusted -u root: -T ${root_path}/lib/../common/data/stream_load/sr_8537.csv -XPUT -H label:stream_load_1668145399844 -H column_separator:, ${url}/api/test_number_bf5a0936_6183_11ed_b695_00163e0b9de0/sr_8537/_stream_load - code: 7 - msg : curl: (7) Failed to connect to 172.21.249.180 port 8038: Connection refused
TestSQLCases.test_str_to_map: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'Table replication num should be less than or equal to the number of available BE nodes. You can change this default by setting the replication_num table properties. Current alive backend is [10003,10004]. , table=t1, replication_num=3, default_replication_num=3'))
TestSQLCases.test_struct_schema_change: TestSQLCases#L1
0 != 7 : [SHELL ERROR] - cmd : shell: curl --location-trusted -u root: -H "Expect:100-continue" -H "format: json" -T ${root_path}/lib/../common/data/stream_load/sr_struct_schema_change_data1.json -XPUT ${url}/api/test_struct_schema_change_db/tab1/_stream_load - code: 7 - msg : curl: (7) Failed to connect to 172.21.249.180 port 8038: Connection refused
TestSQLCases.test_sync_materialized_view3: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'Table replication num should be less than or equal to the number of available BE nodes. You can change this default by setting the replication_num table properties. Current alive backend is [10003,10004]. , table=store_sales, replication_num=3, default_replication_num=3'))
TestSQLCases.test_sync_materialized_view_count_distinct: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'Table replication num should be less than or equal to the number of available BE nodes. You can change this default by setting the replication_num table properties. Current alive backend is [10003,10004]. , table=user_event, replication_num=3, default_replication_num=3'))
TestSQLCases.test_sync_materialized_view_rewrite_with_case_when: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'Table replication num should be less than or equal to the number of available BE nodes. You can change this default by setting the replication_num table properties. Current alive backend is [10003,10004]. , table=t1, replication_num=3, default_replication_num=3'))
TestSQLCases.test_sync_materialized_view_unorder: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'Table replication num should be less than or equal to the number of available BE nodes. You can change this default by setting the replication_num table properties. Current alive backend is [10003,10004]. , table=t1, replication_num=3, default_replication_num=3'))
TestSQLCases.test_sync_materialized_view_with_colocate: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'Table replication num should be less than or equal to the number of available BE nodes. You can change this default by setting the replication_num table properties. Current alive backend is [10003,10004]. , table=user_tags, replication_num=3, default_replication_num=3'))
TestSQLCases.test_sync_mv: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'Table replication num should be less than or equal to the number of available BE nodes. You can change this default by setting the replication_num table properties. Current alive backend is [10003,10004]. , table=t, replication_num=3, default_replication_num=3'))
TestSQLCases.test_table_profile: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'Table replication num should be less than or equal to the number of available BE nodes. You can change this default by setting the replication_num table properties. Current alive backend is [10003,10004]. , table=t, replication_num=3, default_replication_num=3'))
TestSQLCases.test_to_json: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'Table replication num should be less than or equal to the number of available BE nodes. You can change this default by setting the replication_num table properties. Current alive backend is [10003,10004]. , table=t0, replication_num=3, default_replication_num=3'))
TestSQLCases.test_transparent_mv_basic: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'Table replication num should be less than or equal to the number of available BE nodes. You can change this default by setting the replication_num table properties. Current alive backend is [10003,10004]. , table=t1, replication_num=3, default_replication_num=3'))
TestSQLCases.test_transparent_mv_iceberg_part1: TestSQLCases#L1
True is not false : sql result not match: actual with E(E: (1064, 'Getting analyzing error. Detail message: Table replication num should be less than of equal to the number of available BE nodes. You can change this default by setting the replication_num table properties. Current alive backend is [10003,10004]..'))
REMOVE DOC LABEL
The following actions uses node12 which is deprecated and will be forced to run on node16: actions-ecosystem/action-remove-labels@v1. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
REMOVE DOC LABEL
The following actions use a deprecated Node.js version and will be forced to run on node20: actions-ecosystem/action-remove-labels@v1. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
REMOVE DOC LABEL
failed to remove label: documentation: HttpError: Label does not exist