[Bug] 查询报错failed to initialize storage reader #31299
Description
Search before asking
- I had searched in the issues and found no similar issues.
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::allocatordoris::vectorized::IteratorRowRef >) 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::allocatordoris::vectorized::IteratorRowRef >) 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_ptrdoris::RowsetReader, std::allocator<std::shared_ptrdoris::RowsetReader > >&) 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_ptrdoris::vectorized::VScanner) 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_ptrdoris::vectorized::VScanner) 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?
- Yes I am willing to submit a PR!
Code of Conduct
- I agree to follow this project's Code of Conduct