Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

cn crash in vesion 3.2.11 with share-data #52457

Open
zxb2503 opened this issue Oct 30, 2024 · 1 comment
Open

cn crash in vesion 3.2.11 with share-data #52457

zxb2503 opened this issue Oct 30, 2024 · 1 comment
Labels
type/bug Something isn't working

Comments

@zxb2503
Copy link

zxb2503 commented Oct 30, 2024

The CN node crashed, and the error message in the cn.out file is as follows:

3.2.11 RELEASE (build 10a5f0e)
query_id:00309fe9-95f4-11ef-bc72-347379bf5eb6, fragment_instance:00309fe9-95f4-11ef-bc72-347379bf5eb8
tracker:process consumption: 74679110296
tracker:query_pool consumption: 502184
tracker:query_pool/connector_scan consumption: 17432576
tracker:load consumption: 0
tracker:metadata consumption: 144876403
tracker:tablet_metadata consumption: 147118
tracker:rowset_metadata consumption: 0
tracker:segment_metadata consumption: 15580533
tracker:column_metadata consumption: 129148752
tracker:tablet_schema consumption: 147118
tracker:segment_zonemap consumption: 6443088
tracker:short_key_index consumption: 4073365
tracker:column_zonemap_index consumption: 15795424
tracker:ordinal_index consumption: 57356528
tracker:bitmap_index consumption: 0
tracker:bloom_filter_index consumption: 0
tracker:compaction consumption: 0
tracker:schema_change consumption: 0
tracker:column_pool consumption: 0
tracker:page_cache consumption: 65763382608
tracker:update consumption: 0
tracker:chunk_allocator consumption: 1097365752
tracker:clone consumption: 0
tracker:consistency consumption: 0
tracker:datacache consumption: 3382828646
tracker:replication consumption: 0
*** Aborted at 1730206067 (unix time) try "date -d @1730206067" if you are using GNU date ***
PC: @          0x544467c starrocks::SegmentIterator::_finish_late_materialization()
*** SIGSEGV (@0x0) received by PID 40546 (TID 0x2b3e81acc700) from PID 0; stack trace: ***
    @          0x6bc4c82 google::(anonymous namespace)::FailureSignalHandler()
    @     0x2b3e26c1c2cb os::Linux::chained_handler()
    @     0x2b3e26c20d5c JVM_handle_linux_signal
    @     0x2b3e26c13c68 signalHandler()
    @     0x2b3e27306630 (unknown)
    @          0x544467c starrocks::SegmentIterator::_finish_late_materialization()
    @          0x544f11c starrocks::SegmentIterator::_do_get_next()
    @          0x5450e40 starrocks::SegmentIterator::do_get_next()
    @          0x54bd153 starrocks::ProjectionIterator::do_get_next()
    @          0x5a9a593 starrocks::TimedChunkIterator::do_get_next()
    @          0x550235c starrocks::UnionIterator::do_get_next()
    @          0x55c720e starrocks::lake::TabletReader::do_get_next()
    @          0x5f1e48c starrocks::connector::LakeDataSource::get_next()
    @          0x39cbc5a starrocks::pipeline::ConnectorChunkSource::_read_chunk()
    @          0x3cee1ca starrocks::pipeline::ChunkSource::buffer_next_batch_chunks_blocking()
    @          0x39bdd9e _ZZN9starrocks8pipeline12ScanOperator18_trigger_next_scanEPNS_12RuntimeStateEiENKUlvE_clEv
    @          0x3acd011 starrocks::workgroup::ScanExecutor::worker_thread()
    @          0x305409c starrocks::ThreadPool::dispatch_thread()
    @          0x304d5aa starrocks::Thread::supervise_thread()
    @     0x2b3e272feea5 start_thread
    @     0x2b3e27f3996d __clone
    @                0x0 (unknown)
Java HotSpot(TM) 64-Bit Server VM warning: Attempt to deallocate stack guard pages failed.Java HotSpot(TM) 64-Bit Server VM warning: Attempt to deallocate stack guard pages failed.

query_id:00309fe9-95f4-11ef-bc72-347379bf5eb6

select count(*) as totalNum from (select SUM(c_jyje_r) as col0 from y606dox0.wzn_hz_nyr where c_hznyr >= '2024-09-29 00:00:00' AND c_hznyr <= '2024-10-28 23:59:59' AND c_hznyr >= '2024-01-01 00:00:00' AND c_hznyr <= '2024-10-28 23:59:59' ) as count_table

CREATE TABLE `wzn_hz_nyr` (
  `c_hznyr` date NOT NULL COMMENT "汇总日期",
  `rks_r` varchar(65533) NULL COMMENT "当日入库数",
  `jhs_r` varchar(65533) NULL COMMENT "当日激活数",
  `rks_m` varchar(65533) NULL COMMENT "当月入库数",
  `jhs_m` varchar(65533) NULL COMMENT "当月激活数",
  `rks_lj` varchar(65533) NULL COMMENT "累计入库数",
  `jhs_lj` varchar(65533) NULL COMMENT "累计激活数",
  `c_jyshh_r` varchar(65533) NULL COMMENT "当日交易商户数",
  `c_jybs_r` varchar(65533) NULL COMMENT "当日交易笔数",
  `c_jyje_r` varchar(65533) NULL COMMENT "当日交易金额",
  `c_jyshh_m` varchar(65533) NULL COMMENT "当月交易商户数",
  `c_jybs_m` varchar(65533) NULL COMMENT "当月交易笔数",
  `c_jyje_m` varchar(65533) NULL COMMENT "当月交易金额",
  `c_jyshh_lj` varchar(65533) NULL COMMENT "累计交易商户数",
  `c_jybs_lj` varchar(65533) NULL COMMENT "累计交易笔数",
  `c_jyje_lj` varchar(65533) NULL COMMENT "累计交易金额",
  `smbs_r` varchar(65533) NULL COMMENT "当日扫码交易笔数",
  `smje_r` varchar(65533) NULL COMMENT "当日扫码交易金额",
  `smdjkbs_r` varchar(65533) NULL COMMENT "当日扫码贷记卡交易笔数",
  `smdjkje_r` varchar(65533) NULL COMMENT "当日扫码贷记卡交易金额",
  `smbs_m` varchar(65533) NULL COMMENT "当月扫码交易笔数",
  `smje_m` varchar(65533) NULL COMMENT "当月扫码交易金额",
  `smdjkbs_m` varchar(65533) NULL COMMENT "当月扫码贷记卡交易笔数",
  `smdjkje_m` varchar(65533) NULL COMMENT "当月扫码贷记卡交易金额",
  `smbs_lj` varchar(65533) NULL COMMENT "累计扫码交易笔数",
  `smje_lj` varchar(65533) NULL COMMENT "累计扫码交易金额",
  `smdjkbs_lj` varchar(65533) NULL COMMENT "累计扫码贷记卡交易笔数",
  `smdjkje_lj` varchar(65533) NULL COMMENT "累计扫码贷记卡交易金额",
  `xzshs_r` varchar(65533) NULL COMMENT "当日新增商户数",
  `xzshs_m` varchar(65533) NULL COMMENT "当月新增商户数",
  `xzshs_lj` varchar(65533) NULL COMMENT "累计新增商户数",
  `xzshs_r_v2` varchar(65533) NULL COMMENT "当日新增商户数处理",
  `djkbs_r` decimal(20, 2) NULL COMMENT "当日贷记卡交易笔数",
  `djkje_r` decimal(20, 2) NULL COMMENT "当日贷记卡交易金额",
  `djkbs_lj` decimal(20, 2) NULL COMMENT "累计贷记卡交易笔数",
  `djkje_lj` decimal(20, 2) NULL COMMENT "累计贷记卡交易金额"
) ENGINE=OLAP 
DUPLICATE KEY(`c_hznyr`)
COMMENT "微智能按日汇总"
DISTRIBUTED BY HASH(`c_hznyr`) BUCKETS 2 
PROPERTIES (
"replication_num" = "3",
"datacache.enable" = "true",
"storage_volume" = "hdfs_volume",
"enable_async_write_back" = "false",
"enable_persistent_index" = "false",
"compression" = "LZ4"
); 

select count(*) from y606dox0.wzn_hz_nyr;
+----------+
| count(*) |
+----------+
|      103 |
+----------+

StarRocks version (Required)

select current_version();
+-------------------+
| current_version() |
+-------------------+
| 3.2.11-10a5f0e |
+-------------------+

@zxb2503 zxb2503 added the type/bug Something isn't working label Oct 30, 2024
@tracymacding
Copy link
Contributor

3.2.11 RELEASE (build 10a5f0e) not 3.1.12

@zxb2503 zxb2503 changed the title cn crash in vesion 3.1.12 with share-data cn crash in vesion 3.2.11 with share-data Oct 30, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants