Hi Mingyu Chen, Doris version is 1.2.1 The error details attached below Exception in thread "main" java.sql.SQLException: errCode = 2, detailMessage = Process has no memory available, cancel top memory usage query: query memory tracker <Query#Id=921830595f8401c-81a1452c7b9f3dfd> consumption 309.01 MB, backend 10.0.12.192 process memory used 3.59 GB exceed limit 3.88 GB or sys mem available 8.57 GB less than low water mark 1.55 GB. Execute again after enough memory, details see be.INFO. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2439) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1365) at DorisJdbc.main(DorisJdbc.java:20)
I executed different queries in parallelly and then got this error. Thanks On Thu, Mar 2, 2023 at 7:15 AM Mingyu Chen <morning...@163.com> wrote: > > The resource queue will be available in version 2.1, Q2 this year. > > > > Process has no memory available > > > This is there any more infornation about this error? and what is your Doris > version? > > > > > -- > > 此致！Best Regards > 陈明雨 Mingyu Chen > > Email: > morning...@apache.org > > > > > > At 2023-03-02 01:02:32, "Joice Jacob" <joicejacob1...@gmail.com> wrote: > >Hi everyone, > >I'm facing a java.sql.SQLException error with the following message: > >errCode = 2, detailMessage = Process has no memory available, cancel > >top memory usage query. I understand that this means my query is using > >too much memory, but I'm not sure how to fix it. Can anyone help me > >understand why this is happening and suggest some solutions? > > > >I was reading about the 2023 development roadmap for Apache Doris, and > >I noticed they're planning to add a resource queue feature. I think > >this means that queries will be put in a queue if there aren't enough > >resources available to execute them. Does anyone know more about this > >feature and how it works? Also, does anyone know in which version of > >Apache Doris this feature will be available? > > > >Thanks in advance for your help > > > >Joice Jacob > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: dev-unsubscr...@doris.apache.org > >For additional commands, e-mail: dev-h...@doris.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@doris.apache.org For additional commands, e-mail: dev-h...@doris.apache.org
