【详述】在mysql客户端或者Dbeaver执行delete语句：delete from stock_age_fin where dt >= ‘2000-01-01’ ，SR返回来异常信息：ERROR 1064 (HY000): A error occurred: errorCode=62 errorMessage:method request time out, please check ‘onceTalkTimeout’ property. current value is:300000(MILLISECONDS) correlationId:2693181 timeout with bound channel =>[id: 0x5a4e513c, L:/172.26.17.150:58438 - R:/172.26.12.169:8060]
stock_age_fin 表的分区字段为dt字段，并且表的总数据量只有105万。
建表语句：
CREATE TABLE if NOT EXISTS bi.stock_age_fin_div (
sku string COMMENT ‘sku’,
……
row_random double COMMENT ‘记录随机数’,
dt date COMMENT ‘日期’
)ENGINE=OLAP
DUPLICATE KEY(sku)
PARTITION BY date_trunc(‘day’,dt)
DISTRIBUTED BY HASH(dept_name)
PROPERTIES (
“replication_num” = “1”
);
【是否存算分离】是
【StarRocks版本】3.1.2
【集群规模】3fe（1 follower+2observer）+7be
【机器信息】每个节点为 32C+128G
【联系方式】社区群17-浮萍居士，邮箱：343734301@qq.com
【附件】
-fe.log 信息：2023-11-21 14:16:49,354 INFO (starrocks-mysql-nio-pool-703|102364) [DatabaseTransactionMgr.abortTransaction():1228] transaction:[TransactionState. txn_id: 27534, label: delete_581a819a-b4bc-4995-b708-91fb573aed81, db id: 59653, table id list: 164981, callback id: 187045, coordinator: FE: 172.26.17.150, transaction status: ABORTED, error replicas num: 0, replica ids: , prepare time: 1700547109320, commit time: -1, finish time: 1700547409351, total cost: 300031ms, reason: A error occurred: errorCode=62 errorMessage:method request time out, please check ‘onceTalkTimeout’ property. current value is:300000(MILLISECONDS) correlationId:2693181 timeout with bound channel =>[id: 0x5a4e513c, L:/172.26.17.150:58438 - R:/172.26.12.169:8060]] successfully rollback
com.starrocks.common.DdlException: A error occurred: errorCode=62 errorMessage:method request time out, please check ‘onceTalkTimeout’ property. current value is:300000(MILLISECONDS) correlationId:2693181 timeout with bound channel =>[id: 0x5a4e513c, L:/172.26.17.150:58438 - R:/172.26.12.169:8060]
2023-11-21 14:16:49,354 INFO (starrocks-mysql-nio-pool-703|102364) [StmtExecutor.execute():654] execute Exception, sql: delete from stock_age_fin where dt >= ‘2020-01-01’, error: A error occurred: errorCode=62 errorMessage:method request time out, please check ‘onceTalkTimeout’ property. current value is:300000(MILLISECONDS) correlationId:2693181 timeout with bound channel =>[id: 0x5a4e513c, L:/172.26.17.150:58438 - R:/172.26.12.169:8060]
cn节点的cn.INFO.log.20231115-173533 日志文件无报错信息
附件为cn节点用pstack打印的堆栈信息be.pstack (237.4 KB)
补充说明：
我们搭建的是社区版本，没有StarRocksManager，目前也还还没搭Prometheus+Grafana监控
FE节点的JVM是默认的8G
JAVA_OPTS="-Dlog4j2.formatMsgNoLookups=true -Xmx8192m -XX:+UseMembar -XX:SurvivorRatio=8 -XX:MaxTenuringThreshold=7 -XX:+PrintGCDateStamps -XX:+PrintGCDetails -XX:+UseConcMark
SweepGC -XX:+UseParNewGC -XX:+CMSClassUnloadingEnabled -XX:-CMSParallelRemarkEnabled -XX:CMSInitiatingOccupancyFraction=80 -XX:SoftRefLRUPolicyMSPerMB=0 -Xloggc:${LOG_DIR}/fe.
gc.log.$DATE -XX:+PrintConcurrentLocks"