aricy opened a new issue, #29108: URL: https://github.com/apache/doris/issues/29108
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 2.0.3 ### What's Wrong? sql console return: ERROR 1105 (HY000): RpcException, msg: io.grpc.StatusRuntimeException: UNAVAILABLE: Network closed for unknown reason doris-be logs: W1226 08:31:55.998432 30693 schema_change.cpp:1006] failed to alter tablet. base_tablet=15870.2001713714.3c4dcc2fdcdbd5d1-806e8d2cafed10b8, drop new_tablet=47387.392511397.464cc389dd223d4d-b04487f2c39707bc W1226 08:31:55.998462 30693 task_worker_pool.cpp:1790] failed to alter tablet|signature=47387|base_tablet_id=15870|new_tablet_id=47387|error=[E-100]fail to create hard link. from=/data04/data/228/15870/2001713714/02000000000595c3934485ab29a4af5539d548f244a753a5_0.dat, to=/data01/data/21/47387/392511397/020000000001fe85e6443cec7dcd2140bdb216a04cd0b0ba_0.dat, errno=18 0# doris::BetaRowset::link_files_to(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, doris::RowsetId, unsigned long, std::set<int, std::less<int>, std::allocator<int> >*) at /root/src/doris-2.0/be/src/common/status.h:354 1# doris::BetaRowsetWriter::add_rowset(std::shared_ptr<doris::Rowset>) at /root/src/doris-2.0/be/src/common/status.h:442 2# doris::BetaRowsetWriter::add_rowset_for_linked_schema_change(std::shared_ptr<doris::Rowset>) at /var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/shared_ptr_base.h:701 3# doris::LinkedSchemaChange::process(std::shared_ptr<doris::RowsetReader>, doris::RowsetWriter*, std::shared_ptr<doris::Tablet>, std::shared_ptr<doris::Tablet>, std::shared_ptr<doris::TabletSchema>) at /var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/shared_ptr_base.h:701 4# doris::SchemaChangeHandler::_convert_historical_rowsets(doris::SchemaChangeHandler::SchemaChangeParams const&) at /root/src/doris-2.0/be/src/common/status.h:354 5# doris::SchemaChangeHandler::_do_process_alter_tablet_v2(doris::TAlterTabletReqV2 const&) at /root/src/doris-2.0/be/src/olap/schema_change.cpp:0 6# doris::SchemaChangeHandler::process_alter_tablet_v2(doris::TAlterTabletReqV2 const&) at /root/src/doris-2.0/be/src/olap/schema_change.cpp:670 7# doris::EngineAlterTabletTask::execute() at /root/src/doris-2.0/be/src/common/status.h:354 8# doris::StorageEngine::execute_task(doris::EngineTask*) at /root/src/doris-2.0/be/src/common/status.h:442 9# doris::AlterTableTaskPool::_alter_tablet(doris::TAgentTaskRequest const&, long, doris::TTaskType::type, doris::TFinishTaskRequest*) at /root/src/doris-2.0/be/src/common/status.h:354 10# doris::AlterTableTaskPool::_alter_tablet_worker_thread_callback() at /root/src/doris-2.0/be/src/agent/task_worker_pool.cpp:1733 11# doris::ThreadPool::dispatch_thread() at /root/src/doris-2.0/be/src/util/threadpool.cpp:0 12# doris::Thread::supervise_thread(void*) at /var/local/ldb-toolchain/bin/../usr/include/pthread.h:562 13# start_thread 14# __clone W1226 08:31:58.100711 29560 thread_mem_tracker_mgr.h:182] malloc or new large memory: 4294967296, in query or load: 84b195d97f8c4a48-8f8db95af8c72b98, this is just a warning, not prevent memory alloc, stacktrace: 0# doris::ThreadMemTrackerMgr::consume(long, bool) at /var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/basic_string.h:187 1# malloc at /root/src/doris-2.0/be/src/runtime/thread_context.h:0 2# Allocator<false, false, false>::alloc_impl(unsigned long, unsigned long) at /root/src/doris-2.0/be/src/vec/common/allocator.h:123 3# doris::vectorized::ColumnString::insert_range_from(doris::vectorized::IColumn const&, unsigned long, unsigned long) at /root/src/doris-2.0/be/src/vec/common/pod_array.h:128 4# doris::vectorized::ColumnNullable::insert_range_from(doris::vectorized::IColumn const&, unsigned long, unsigned long) at /root/src/doris-2.0/be/src/vec/common/cow.h:194 5# doris::ExecNode::do_projections(doris::vectorized::Block*, doris::vectorized::Block*) at /root/src/doris-2.0/be/src/vec/common/cow.h:132 6# doris::ExecNode::get_next_after_projects(doris::RuntimeState*, doris::vectorized::Block*, bool*, std::function<doris::Status (doris::RuntimeState*, doris::vectorized::Block*, bool*)> const&, bool) at /var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/unique_ptr.h:360 7# doris::pipeline::SourceOperator<doris::pipeline::AnalyticSourceOperatorBuilder>::get_block(doris::RuntimeState*, doris::vectorized::Block*, doris::pipeline::SourceState&) at /var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/std_function.h:244 8# doris::pipeline::PipelineTask::execute(bool*) at /root/src/doris-2.0/be/src/common/ status.h:442 9# doris::pipeline::TaskScheduler::_do_work(unsigned long) at /root/src/doris-2.0/be/src/common/status.h:354 10# doris::ThreadPool::dispatch_thread() at /root/src/doris-2.0/be/src/util/threadpool.cpp:0 11# doris::Thread::supervise_thread(void*) at /var/local/ldb-toolchain/bin/../usr/include/pthread.h:562 12# start_thread 13# __clone sql statement: SELECT partner_code AS partner_code, app_name AS app_name, event_type AS event_type, event_id AS event_id, DATE_FORMAT(event_occur_time_date, '%Y-%m-%d 00:00:00') AS event_occur_time_date, COUNT(final_score) AS `cnt_final_score`, (count(final_score)-(lag(count(final_score), 1, 0) over (partition by partner_code, app_name, event_type, event_id order by DATE_FORMAT(event_occur_time_date, '%Y-%m-%d 00:00:00'))))/(lag(count(final_score), 1, 0) over (partition by partner_code, app_name, event_type, event_id order by DATE_FORMAT(event_occur_time_date, '%Y-%m-%d 00:00:00'))) AS `(count(final_score)-(lag(count(final_sco...` FROM db.table WHERE event_occur_time_date >= STR_TO_DATE('2023-12-22 00:00:00.000000', '%Y-%m-%d %H:%i:%s.%f') AND event_occur_time_date < STR_TO_DATE('2023-12-25 00:00:00.000000', '%Y-%m-%d %H:%i:%s.%f') GROUP BY partner_code, app_name, event_type, event_id, DATE_FORMAT(event_occur_time_date, '%Y-%m-%d 00:00:00') ORDER BY `cnt_final_score` DESC LIMIT 1000; ### What You Expected? fix the 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 - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
