【详述】
INSERT INTO
FILES(
“path” = “s3://xxx/”,
“format” = “parquet”,
“aws.s3.access_key” = “xx”,
“aws.s3.secret_key” = “xx”,
“aws.s3.region” = “cn-northwest-1”,
“compression” = “gzip”,
“max_file_size” = “1MB”
)
SELECT * FROM xxx.t_amzdb_campaigns_product;
【是否存算分离】是
【StarRocks版本】3.2
【集群规模】3fe（1 follower+2observer）+3be
query_mem_limit在集群中为默认值0。
报错信息：
insert failed: Memory of Query99674ff1-b4e1-11ee-aeae-96c6d7afe7df exceed limit. read and decompress page Used: 4295112688, Limit: 4294967296. Mem usage has exceed the limit of single query,
You can change the limit by set session variable query_mem_limit.
2024-01-17 10:40:16,320 INFO (thrift-server-pool-16523|18265) [QueryRuntimeProfile.finishAllInstances():212] unfinished instances: [99674ff1-b4e1-11ee-aeae-96c6d7afe7e0, 99674ff1-b4e1-11ee-aeae-96c6d7afe7e2]
2024-01-17 10:40:16,320 WARN (thrift-server-pool-16491|18231) [StmtExecutor.handleDMLStmt():2124] failed to handle stmt [INSERT INTO FILES(
“path” = “s3://xxx/”, “format” = “parquet”, “aws.s3.access_key” = xxx “aws.s3.secret_key” = “xxx”, “aws.s3.region” = “cn-northwest-1”, “compression” = “gzip”, “max_file_size” = “256MB” ) SELECT * FROM xxx.t_amzdb_campaigns_product_ad_report_v2] label: insert_99674ff1-b4e1-11ee-aeae-96c6d7afe7df
com.starrocks.common.DdlException: Memory of Query99674ff1-b4e1-11ee-aeae-96c6d7afe7df exceed limit. read and decompress page Used: 4295112688, Limit: 4294967296. Mem usage has exceed the limit of single query,
You can change the limit by set session variable query_mem_limit.
at com.starrocks.common.ErrorReport.reportDdlException(ErrorReport.java:99) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:1978) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDMLStmtWithProfile(StmtExecutor.java:1709) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:659) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.proxyExecute(ConnectProcessor.java:784) ~[starrocks-fe.jar:?]
at com.starrocks.service.FrontendServiceImpl.forward(FrontendServiceImpl.java:1248) ~[starrocks-fe.jar:?]
at com.starrocks.thrift.FrontendService$Processor$forward.getResult(FrontendService.java:3976) ~[starrocks-fe.jar:?]
at com.starrocks.thrift.FrontendService$Processor$forward.getResult(FrontendService.java:3956) ~[starrocks-fe.jar:?]
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38) ~[libthrift-0.13.0.jar:0.13.0]
at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:38) ~[libthrift-0.13.0.jar:0.13.0]
at com.starrocks.common.SRTThreadPoolServer$WorkerProcess.run(SRTThreadPoolServer.java:311) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
at java.lang.Thread.run(Thread.java:829) ~[?:?]
2024-01-17 10:40:16,320 WARN (thrift-server-pool-16491|18231) [StmtExecutor.handleDMLStmt():2149] errors when abort txn
java.lang.NullPointerException: null
at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:2142) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDMLStmtWithProfile(StmtExecutor.java:1709) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:659) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.proxyExecute(ConnectProcessor.java:784) ~[starrocks-fe.jar:?]
at com.starrocks.service.FrontendServiceImpl.forward(FrontendServiceImpl.java:1248) ~[starrocks-fe.jar:?]
at com.starrocks.thrift.FrontendService$Processor$forward.getResult(FrontendService.java:3976) ~[starrocks-fe.jar:?]
at com.starrocks.thrift.FrontendService$Processor$forward.getResult(FrontendService.java:3956) ~[starrocks-fe.jar:?]
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38) ~[libthrift-0.13.0.jar:0.13.0]
at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:38) ~[libthrift-0.13.0.jar:0.13.0]
at com.starrocks.common.SRTThreadPoolServer$WorkerProcess.run(SRTThreadPoolServer.java:311) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worke
Object not found when checking action[INSERT] on TABLE table_function_catalog.table_function_db.table_function_table, message: cannot find catalog: table_function_catalog
2024-01-17 10:54:53,425 ERROR (starrocks-mysql-nio-pool-11|17957) [MetadataMgr.getOptionalMetadata():152] Failed to get table_function_catalog catalog