search

apache / doris

Apache Doris is an easy-to-use, high performance and unified analytics database.
https://doris.apache.org
Apache License 2.0
12.77k stars 3.29k forks source link

[Bug] 查询报错failed to initialize storage reader #31299

Open hnwkz opened 9 months ago

hnwkz commented 9 months ago

Search before asking

Version

doris-2.0.4-rc06-003a815b63

What's Wrong?

执行查询语句： SELECT store_day, game_code, app_id, media, os_name, creative, SUM(cost) AS cost, SUM(installs) AS installs, SUM(total_pay_amount_after_proportion_1) AS total_pay_amount_after_proportion_1, SUM(total_pay_amount_after_proportion_3) AS total_pay_amount_after_proportion_3, SUM(total_pay_amount_after_proportion_7) AS total_pay_amount_after_proportion_7 FROM ads.ads_bi_flat_ad_8 WHERE media IN('facebook', 'applovin') GROUP BY store_day, game_code, app_id, media, os_name, creative;

报如下错误： [2024-02-23 09:41:56] [HY000][1105] errCode = 2, detailMessage = (10.240.4.3)[CANCELLED][INTERNAL_ERROR]failed to initialize storage reader. tablet=105669072.1794131352.0542281d7c66c5a9-0333d4769be9169d, res=[NOT_IMPLEMENTED_ERROR]to be implemented [2024-02-23 09:41:56] 0# doris::RowwiseIterator::next_block_view(std::vector<doris::vectorized::IteratorRowRef, std::allocator >) at /home/zcp/repo_center/doris_release/doris/be/src/olap/iterators.h:137 [2024-02-23 09:41:56] 1# doris::BetaRowsetReader::next_block_view(std::vector<doris::vectorized::IteratorRowRef, std::allocator >) at /home/zcp/repo_center/doris_release/doris/be/src/common/status.h:442 [2024-02-23 09:41:56] 2# doris::vectorized::VCollectIterator::Level0Iterator::refresh_current_row() at /home/zcp/repo_center/doris_release/doris/be/src/common/status.h:442 [2024-02-23 09:41:56] 3# doris::vectorized::VCollectIterator::Level0Iterator::init(bool) at /home/zcp/repo_center/doris_release/doris/be/src/vec/olap/vcollect_iterator.cpp:472 [2024-02-23 09:41:56] 4# doris::vectorized::VCollectIterator::build_heap(std::vector<std::shared_ptr, std::allocator<std::shared_ptr > >&) at /home/zcp/repo_center/doris_release/doris/be/src/common/status.h:442 [2024-02-23 09:41:56] 5# doris::vectorized::BlockReader::_init_collect_iter(doris::TabletReader::ReaderParams const&) at /home/zcp/repo_center/doris_release/doris/be/src/common/status.h:442 [2024-02-23 09:41:56] 6# doris::vectorized::BlockReader::init(doris::TabletReader::ReaderParams const&) at /home/zcp/repo_center/doris_release/doris/be/src/common/status.h:442 [2024-02-23 09:41:56] 7# doris::vectorized::NewOlapScanner::open(doris::RuntimeState) at /home/zcp/repo_center/doris_release/doris/be/src/common/status.h:442 [2024-02-23 09:41:56] 8# doris::vectorized::ScannerScheduler::_scanner_scan(doris::vectorized::ScannerScheduler, doris::vectorized::ScannerContext, std::shared_ptr) at /home/zcp/repo_center/doris_release/doris/be/src/common/status.h:354 [2024-02-23 09:41:56] 9# std::_Function_handler<void (), doris::vectorized::ScannerScheduler::_schedule_scanners(doris::vectorized::ScannerContext)::$_1::operator()() const::{lambda()#3}>::_M_invoke(std::_Any_data const&) at /var/local/ldb_toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/shared_ptr_base.h:701 [2024-02-23 09:41:56] 10# doris::WorkThreadPool::work_thread(int) at /var/local/ldb_toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/atomic_base.h:646 [2024-02-23 09:41:56] 11# execute_native_thread_routine at /data/gcc-11.1.0/build/x86_64-pc-linux-gnu/libstdc++-v3/include/bits/unique_ptr.h:85 [2024-02-23 09:41:56] 12# start_thread [2024-02-23 09:41:56] 13# clone [2024-02-23 09:41:56] , backend=10.240.4.3 [2024-02-23 09:41:56] 0# doris::vectorized::NewOlapScanner::open(doris::RuntimeState) at /var/local/ldb_toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/basic_string.h:187 [2024-02-23 09:41:56] 1# doris::vectorized::ScannerScheduler::_scanner_scan(doris::vectorized::ScannerScheduler, doris::vectorized::ScannerContext, std::shared_ptr) at /home/zcp/repo_center/doris_release/doris/be/src/common/status.h:354 [2024-02-23 09:41:56] 2# std::_Function_handler<void (), doris::vectorized::ScannerScheduler::_schedule_scanners(doris::vectorized::ScannerContext)::$_1::operator()() const::{lambda()#3}>::_M_invoke(std::_Any_data const&) at /var/local/ldb_toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/shared_ptr_base.h:701 [2024-02-23 09:41:56] 3# doris::WorkThreadPool::work_thread(int) at /var/local/ldb_toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/atomic_base.h:646 [2024-02-23 09:41:56] 4# execute_native_thread_routine at /data/gcc-11.1.0/build/x86_64-pc-linux-gnu/libstdc++-v3/include/bits/unique_ptr.h:85 [2024-02-23 09:41:56] 5# start_thread [2024-02-23 09:41:56] 6# clone

通过获取报错的tablet_id，执行 ADMIN SET REPLICA STATUS PROPERTIES("tablet_id" = "105665808", "backend_id" = "79078857", "status" = "bad"); 能恢复正常，但是有时候损坏的tablet太多，使用该语句十分麻烦，只能通过新建一个表结构完全一样的表： create table ads.ads_bi_flat_ad_8_temp like ads.ads_bi_flat_ad_8; 然后再全量insert into 进去： insert into ads.ads_bi_flat_ad_8_temp select * from ads.ads_bi_flat_ad_8; 再执行替换表： ALTER TABLE ads_bi_flat_ad_8 REPLACE WITH TABLE ads_bi_flat_ad_8_temp PROPERTIES('swap' = 'true'); 能恢复正常，该错误随机间隔出现，十分困扰。

建表语句如下： CREATE TABLE ads_bi_flat_ad_8 ( store_day date NULL, game_id int(11) NULL, app_id varchar(255) NULL, os_name varchar(64) NULL, media varchar(512) NULL, country varchar(32) NULL, af_prt varchar(512) NULL, campaign varchar(1024) NULL, adgroup varchar(1024) NULL, creative varchar(2048) NULL, game_name varchar(64) REPLACE_IF_NOT_NULL NULL, game_code varchar(64) REPLACE_IF_NOT_NULL NULL, media_group varchar(64) REPLACE_IF_NOT_NULL NULL, country_name varchar(64) REPLACE_IF_NOT_NULL NULL, country_tier varchar(64) REPLACE_IF_NOT_NULL NULL, country_group varchar(64) REPLACE_IF_NOT_NULL NULL, country_group_en varchar(64) REPLACE_IF_NOT_NULL NULL, app_code varchar(64) REPLACE_IF_NOT_NULL NULL, app_id_market_code varchar(64) REPLACE_IF_NOT_NULL NULL, app_id_status varchar(64) REPLACE_IF_NOT_NULL NULL, sdk_channel_code varchar(64) REPLACE_IF_NOT_NULL NULL, sdk_channel_name varchar(64) REPLACE_IF_NOT_NULL NULL, installs bigint(20) REPLACE_IF_NOT_NULL NULL, install_conversion bigint(20) REPLACE_IF_NOT_NULL NULL, reinstall bigint(20) REPLACE_IF_NOT_NULL NULL, dnu bigint(20) REPLACE_IF_NOT_NULL NULL, role_dnu bigint(20) REPLACE_IF_NOT_NULL NULL, device_id_dnu bigint(20) REPLACE_IF_NOT_NULL NULL, dau bigint(20) REPLACE_IF_NOT_NULL NULL, device_id_dau bigint(20) REPLACE_IF_NOT_NULL NULL, pay double REPLACE_IF_NOT_NULL NULL, cost double REPLACE_IF_NOT_NULL NULL, impressions bigint(20) REPLACE_IF_NOT_NULL NULL, clicks bigint(20) REPLACE_IF_NOT_NULL NULL, pay_num bigint(20) REPLACE_IF_NOT_NULL NULL, history_first_pay_num bigint(20) REPLACE_IF_NOT_NULL NULL, register_bind_num bigint(20) REPLACE_IF_NOT_NULL NULL, login_bind_num bigint(20) REPLACE_IF_NOT_NULL NULL, admob_pay double REPLACE_IF_NOT_NULL NULL, total_pay_amount_max_yesterday double REPLACE_IF_NOT_NULL NULL, total_pay_amount_after_proportion_max_yesterday double REPLACE_IF_NOT_NULL NULL, recall_account bigint(20) REPLACE_IF_NOT_NULL NULL, wake_account bigint(20) REPLACE_IF_NOT_NULL NULL, new_add_account_current_month_pay double REPLACE_IF_NOT_NULL NULL, new_add_account_current_quarter_pay double REPLACE_IF_NOT_NULL NULL, recall_account_current_month_pay double REPLACE_IF_NOT_NULL NULL, recall_account_current_quarter_pay double REPLACE_IF_NOT_NULL NULL, retention_1 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_2 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_3 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_4 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_5 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_6 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_7 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_14 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_30 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_60 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_90 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_120 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_150 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_180 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_210 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_240 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_270 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_300 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_330 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_360 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_540 bigint(20) REPLACE_IF_NOT_NULL NULL, retention_720 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_1 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_2 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_3 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_4 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_5 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_6 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_7 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_14 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_30 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_60 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_90 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_120 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_150 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_180 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_210 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_240 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_270 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_300 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_330 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_360 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_540 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_login_retention_720 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_num_1 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_num_2 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_num_3 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_num_4 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_num_5 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_num_6 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_num_7 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_num_14 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_num_30 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_num_60 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_num_90 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_num_120 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_num_150 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_num_180 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_time_1 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_time_2 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_time_3 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_time_4 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_time_5 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_time_6 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_time_7 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_time_14 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_time_30 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_time_60 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_time_90 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_time_120 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_time_150 bigint(20) REPLACE_IF_NOT_NULL NULL, pay_time_180 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_amount_1 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_2 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_3 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_4 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_5 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_6 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_7 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_14 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_30 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_60 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_90 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_120 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_150 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_180 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_after_proportion_1 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_after_proportion_2 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_after_proportion_3 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_after_proportion_4 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_after_proportion_5 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_after_proportion_6 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_after_proportion_7 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_after_proportion_14 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_after_proportion_30 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_after_proportion_60 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_after_proportion_90 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_after_proportion_120 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_after_proportion_150 double REPLACE_IF_NOT_NULL NULL, total_pay_amount_after_proportion_180 double REPLACE_IF_NOT_NULL NULL, total_pay_num_1 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_num_2 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_num_3 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_num_4 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_num_5 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_num_6 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_num_7 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_num_14 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_num_30 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_num_60 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_num_90 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_num_120 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_num_150 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_num_180 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_time_1 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_time_2 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_time_3 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_time_4 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_time_5 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_time_6 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_time_7 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_time_14 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_time_30 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_time_60 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_time_90 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_time_120 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_time_150 bigint(20) REPLACE_IF_NOT_NULL NULL, total_pay_time_180 bigint(20) REPLACE_IF_NOT_NULL NULL ) ENGINE=OLAP AGGREGATE KEY(store_day, game_id, app_id, os_name, media, country, af_prt, campaign, adgroup, creative) COMMENT 'OLAP' PARTITION BY RANGE(store_day) () DISTRIBUTED BY HASH(game_id) BUCKETS 1 PROPERTIES ( "replication_allocation" = "tag.location.default: 3", "is_being_synced" = "false", "dynamic_partition.enable" = "true", "dynamic_partition.time_unit" = "DAY", "dynamic_partition.time_zone" = "Europe/London", "dynamic_partition.start" = "-2147483648", "dynamic_partition.end" = "7", "dynamic_partition.prefix" = "p", "dynamic_partition.replication_allocation" = "tag.location.default: 3", "dynamic_partition.buckets" = "1", "dynamic_partition.create_history_partition" = "true", "dynamic_partition.history_partition_num" = "2529", "dynamic_partition.hot_partition_num" = "0", "dynamic_partition.reserved_history_periods" = "NULL", "dynamic_partition.storage_policy" = "", "dynamic_partition.storage_medium" = "SSD", "storage_format" = "V2", "light_schema_change" = "true", "disable_auto_compaction" = "false", "enable_single_replica_compaction" = "false" );

示例数据如下： insert into ads.ads_bi_flat_ad_8 (store_day, game_id, app_id, os_name, media, country, af_prt, campaign, adgroup, creative, game_name, game_code, media_group, country_name, country_tier, country_group, country_group_en, app_code, app_id_market_code, app_id_status, sdk_channel_code, sdk_channel_name, installs, install_conversion, reinstall, dnu, role_dnu, device_id_dnu, dau, device_id_dau, pay, cost, impressions, clicks, pay_num, history_first_pay_num, register_bind_num, login_bind_num, admob_pay, total_pay_amount_max_yesterday, total_pay_amount_after_proportion_max_yesterday, recall_account, wake_account, new_add_account_current_month_pay, new_add_account_current_quarter_pay, recall_account_current_month_pay, recall_account_current_quarter_pay, retention_1, retention_2, retention_3, retention_4, retention_5, retention_6, retention_7, retention_14, retention_30, retention_60, retention_90, retention_120, retention_150, retention_180, retention_210, retention_240, retention_270, retention_300, retention_330, retention_360, retention_540, retention_720, pay_login_retention_1, pay_login_retention_2, pay_login_retention_3, pay_login_retention_4, pay_login_retention_5, pay_login_retention_6, pay_login_retention_7, pay_login_retention_14, pay_login_retention_30, pay_login_retention_60, pay_login_retention_90, pay_login_retention_120, pay_login_retention_150, pay_login_retention_180, pay_login_retention_210, pay_login_retention_240, pay_login_retention_270, pay_login_retention_300, pay_login_retention_330, pay_login_retention_360, pay_login_retention_540, pay_login_retention_720, pay_num_1, pay_num_2, pay_num_3, pay_num_4, pay_num_5, pay_num_6, pay_num_7, pay_num_14, pay_num_30, pay_num_60, pay_num_90, pay_num_120, pay_num_150, pay_num_180, pay_time_1, pay_time_2, pay_time_3, pay_time_4, pay_time_5, pay_time_6, pay_time_7, pay_time_14, pay_time_30, pay_time_60, pay_time_90, pay_time_120, pay_time_150, pay_time_180, total_pay_amount_1, total_pay_amount_2, total_pay_amount_3, total_pay_amount_4, total_pay_amount_5, total_pay_amount_6, total_pay_amount_7, total_pay_amount_14, total_pay_amount_30, total_pay_amount_60, total_pay_amount_90, total_pay_amount_120, total_pay_amount_150, total_pay_amount_180, total_pay_amount_after_proportion_1, total_pay_amount_after_proportion_2, total_pay_amount_after_proportion_3, total_pay_amount_after_proportion_4, total_pay_amount_after_proportion_5, total_pay_amount_after_proportion_6, total_pay_amount_after_proportion_7, total_pay_amount_after_proportion_14, total_pay_amount_after_proportion_30, total_pay_amount_after_proportion_60, total_pay_amount_after_proportion_90, total_pay_amount_after_proportion_120, total_pay_amount_after_proportion_150, total_pay_amount_after_proportion_180, total_pay_num_1, total_pay_num_2, total_pay_num_3, total_pay_num_4, total_pay_num_5, total_pay_num_6, total_pay_num_7, total_pay_num_14, total_pay_num_30, total_pay_num_60, total_pay_num_90, total_pay_num_120, total_pay_num_150, total_pay_num_180, total_pay_time_1, total_pay_time_2, total_pay_time_3, total_pay_time_4, total_pay_time_5, total_pay_time_6, total_pay_time_7, total_pay_time_14, total_pay_time_30, total_pay_time_60, total_pay_time_90, total_pay_time_120, total_pay_time_150, total_pay_time_180) values ('2017-06-22', 10002, 'xxxxxxxxx', 'android', 'facebook', 'at', 'facebook', null, null, null, 'War and Magic', 'WAM', '自投', '奥地利', 'T1', '西欧', 'EU', 'WAM-GB', 'gb', 'enable', 'android', 'GooglePlay', null, null, null, null, null, null, 3, 0, 4.99, null, null, null, 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('2017-06-22', 10002, 'xxxxxx', 'android', 'facebook', 'au', 'facebook', null, null, null, 'War and Magic', 'WAM', '自投', '澳大利亚', 'T1', '英语', 'EN', 'WAM-GB', 'gb', 'enable', 'android', 'GooglePlay', null, null, null, null, null, null, 13, 0, 4.99, null, null, null, 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('2017-06-22', 10002, 'xxxxxxxxxx', 'android', 'facebook', 'ba', 'facebook', null, null, null, 'War and Magic', 'WAM', '自投', '波斯尼亚和黑塞哥维那', 'T5', '东欧', 'EU', 'WAM-GB', 'gb', 'enable', 'android', 'GooglePlay', null, null, null, 1, null, 0, 1, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), ('2017-06-22', 10002, 'xxxxxxxxxxxxxxxxxxxx', 'android', 'facebook', 'be', 'facebook', null, null, null, 'War and Magic', 'WAM', '自投', '比利时', 'T2', '西欧', 'EU', 'WAM-GB', 'gb', 'enable', 'android', 'GooglePlay', null, null, null, 2, null, 0, 2, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), ('2017-06-22', 10002, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 'android', 'facebook', 'bg', 'facebook', null, null, null, 'War and Magic', 'WAM', '自投', '保加利亚', 'T3', '东欧', 'EU', 'WAM-GB', 'gb', 'enable', 'android', 'GooglePlay', null, null, null, 1, null, 0, 2, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

What You Expected?

解决该bug

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

Code of Conduct

liugddx commented 9 months ago

Let me see.

hnwkz commented 8 months ago

Let me see. 查到啥问题了没？随机出现这个问题，难搞

dengd1937 commented 7 months ago

@hnwkz 找到问题了吗？我也遇到相同的问题，后续你是怎么解决的啊

hnwkz commented 7 months ago

@hnwkz 找到问题了吗？我也遇到相同的问题，后续你是怎么解决的啊

没解决，一直有这个bug，出现了就重新建表，替换

yuanyuan8983 commented 6 months ago

https://github.com/apache/doris/pull/32961

drunbility commented 4 months ago

生产碰到同样的问题，经验证改成写时合并可规避这个报错