为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述
【背景】做过哪些操作？
【业务影响】
【是否存算分离】否
【StarRocks版本】3.2.6
【集群规模】1fe 1be
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】社区群15 Hpp
【附件】
SQLException: (conn=43267) auto increment allocate failed, err msg:
建表语句：
CREATE TABLE
std_api_jstqm_trd_sys_sale_order_detail_f (__id bigint(20) NOT NULL AUTO_INCREMENT ,data_source varchar(1048576) NULL ,company varchar(1048576) NULL ,sale_order_id varchar(1048576) NULL ,sale_order_detail_id varchar(1048576) NULL ,so_sale_order_id varchar(1048576) NULL ,so_sale_order_detail_id varchar(1048576) NULL ,order_type varchar(1048576) NULL ,order_source varchar(1048576) NULL ,order_status varchar(1048576) NULL ,document_status varchar(1048576) NULL,dept_code varchar(1048576) NULL ,dept_name varchar(1048576) NULL ,distributor_code varchar(1048576) NULL ,distributor_name varchar(1048576) NULL ,supplier_code varchar(1048576) NULL ,supplier_name varchar(1048576) NULL ,warehouse_code varchar(1048576) NULL ,warehouse_name varchar(1048576) NULL ,channel varchar(1048576) NULL ,shop_code varchar(1048576) NULL ,shop_name varchar(1048576) NULL ,salesman_code varchar(1048576) NULL ,salesman_name varchar(1048576) NULL ,buyer_id varchar(1048576) NULL ,buyer_name varchar(1048576) NULL ,telephone varchar(1048576) NULL ,express_company_code varchar(1048576) NULL ,express_company_name varchar(1048576) NULL ,express_number varchar(1048576) NULL ,receive_province varchar(1048576) NULL ,receive_city varchar(1048576) NULL ,receive_district varchar(1048576) NULL ,receive_address varchar(1048576) NULL ,product_id varchar(1048576) NULL ,spec_id varchar(1048576) NULL ,suite_code varchar(1048576) NULL ,suite_name varchar(1048576) NULL ,suite_spec_code varchar(1048576) NULL ,suite_spec_name varchar(1048576) NULL ,product_code varchar(1048576) NULL ,product_name varchar(1048576) NULL ,spec_code varchar(1048576) NULL ,spec_name varchar(1048576) NULL ,sale_num double NULL ,sale_price double NULL ,sale_amount double NULL ,sale_discount double NULL ,sale_post double NULL ,sale_weight double NULL ,is_gift varchar(1048576) NULL ,product_status varchar(1048576) NULL ,order_time datetime NULL ,pay_time datetime NULL ,order_sure_time datetime NULL ,send_time datetime NULL ,flag varchar(1048576) NULL ,label varchar(1048576) NULL ,remark varchar(1048576) NULL ,dt varchar(1048576) NULL ) ENGINE=OLAPPRIMARY KEY(
__id)DISTRIBUTED BY HASH(
__id)PROPERTIES (
“replication_num” = “1”,
“in_memory” = “false”,
“enable_persistent_index” = “true”,
“replicated_storage” = “true”,
“fast_schema_evolution” = “true”,
“compression” = “LZ4”
);
be.WARING
/build/starrocks/be/src/exec/spillable_chunks_sorter_full_sort.cpp:47 _spiller->spill(state, chunk_st.value(), io_executor(), spill::ResourceMemTrackerGuard(tls_mem_tracker, state->query_ctx()->weak_from_this(), _spiller->weak_from_this()))
/build/starrocks/be/src/exec/pipeline/sort/partition_sort_sink_operator.cpp:65 _chunks_sorter->update(state, materialize_chunk.value())
/build/starrocks/be/src/exec/pipeline/sort/spillable_partition_sort_sink_operator.cpp:54 PartitionSortSinkOperator::push_chunk(state, chunk)
W0712 15:08:35.263808 770 pipeline_driver.cpp:755] fragment_id 6db8a030-401d-11ef-9a48-0242b1141b40 driver query_id=6db8a030-401d-11ef-9a48-0242b1141b3e fragment_id=6db8a030-401d-11ef-9a48-0242b1141b40 driver=driver_39_15, status=RUNNING, operator-chain: [exchange_source_39_0x7f4ab7f58b90(O) -> spillable_local_sort_sink_40_0x7f4ab7f59a90(X)] cancels operator spillable_local_sort_sink_40_0x7f4ab7f59a90(X) with finished error runtime state is cancelled
W0712 15:18:36.250602 1047 utils.cpp:126] Fail to report to master. host=woxiaoya-node00, port=9020, code=OK
W0712 15:18:36.250654 1047 task_worker_pool.cpp:807] Fail to report resource_usage to woxiaoya-node00:9020, err=-1
W0712 15:18:51.373255 976 query_context.cpp:645] Retrying ReportExecStatus: No more data to read.
W0712 15:18:58.537500 1047 utils.cpp:126] Fail to report to master. host=woxiaoya-node00, port=9020, code=OK
W0712 15:18:58.537542 1047 task_worker_pool.cpp:807] Fail to report resource_usage to woxiaoya-node00:9020, err=-1
W0712 15:19:13.308571 1047 utils.cpp:126] Fail to report to master. host=woxiaoya-node00, port=9020, code=OK
W0712 15:19:13.308632 1047 task_worker_pool.cpp:807] Fail to report resource_usage to woxiaoya-node00:9020, err=-1
W0712 15:19:22.637382 976 query_context.cpp:645] Retrying ReportExecStatus: No more data to read.
W0712 15:19:44.157557 1047 utils.cpp:126] Fail to report to master. host=woxiaoya-node00, port=9020, code=OK
W0712 15:19:44.157608 1047 task_worker_pool.cpp:807] Fail to report resource_usage to woxiaoya-node00:9020, err=-1
W0712 15:19:45.951489 1046 utils.cpp:126] Fail to report to master. host=woxiaoya-node00, port=9020, code=OK
W0712 15:19:45.951534 1046 task_worker_pool.cpp:758] Fail to report workgroup to woxiaoya-node00:9020, err=-1
W0712 15:19:50.157271 1047 utils.cpp:120] Fail to report to master: THRIFT_EAGAIN (timed out)
W0712 15:19:50.157330 1047 task_worker_pool.cpp:807] Fail to report resource_usage to woxiaoya-node00:9020, err=-1
W0712 15:19:50.951251 1043 utils.cpp:120] Fail to report to master: THRIFT_EAGAIN (timed out)
W0712 15:19:50.951304 1043 task_worker_pool.cpp:613] Fail to report task to woxiaoya-node00:9020, err=-1
W0712 15:19:51.840436 764 thrift_rpc_helper.cpp:86] call frontend service failed, address=TNetworkAddress(hostname=woxiaoya-node00, port=9020), reason=THRIFT_EAGAIN (timed out)
W0712 15:19:52.386456 764 pipeline_driver.cpp:353] push_chunk returns not ok status Internal error: auto increment allocate failed, err msg:
/build/starrocks/be/src/exec/tablet_sink.cpp:767 StorageEngine::instance()->get_next_increment_id_interval(table_id, null_rows, ids)
/build/starrocks/be/src/exec/tablet_sink.cpp:707 _fill_auto_increment_id_internal(chunk, slot, _schema->table_id())
/build/starrocks/be/src/exec/tablet_sink.cpp:587 _fill_auto_increment_id(chunk)
W0712 15:19:52.386543 764 pipeline_driver_executor.cpp:170] [Driver] Process error, query_id=e6827368-401e-11ef-9a48-0242b1141b3e, instance_id=e6827368-401e-11ef-9a48-0242b1141b3f, status=Internal error: auto increment allocate failed, err msg:
/build/starrocks/be/src/exec/tablet_sink.cpp:767 StorageEngine::instance()->get_next_increment_id_interval(table_id, null_rows, ids)
/build/starrocks/be/src/exec/tablet_sink.cpp:707 _fill_auto_increment_id_internal(chunk, slot, _schema->table_id())
/build/starrocks/be/src/exec/tablet_sink.cpp:587 _fill_auto_increment_id(chunk)
W0712 15:19:52.750032 764 tablet_sink_sender.cpp:248] close channel failed. channel_name=NodeChannel[10004], load_info=load_id=e6827368-401e-11ef-9a48-0242b1141b3e, txn_id: 866451, parallel=1, compress_type=2, error_msg=Cancelled by pipeline engine
写入语句：
insert sql (31.1 KB)