暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

conn=131184 requested min_memory over 90 percent of total available memory not supported

原创 lscomeon 2022-12-08
544


oceanbase zone 调整 resource pool 规格时报错

conn=131184 requested min_memory over 90 percent of total available memory not supported

场景为规格由大调小,由于资源被使用,无法收回,导致调整失败


2022-12-08 20:04:30.386  WARN 2279 --- [pool-manual-subtask-executor25,38928fe34a104438,5fa6fb11d747] c.a.o.c.t.engine.runner.RunnerFactory    : Execute task failed, subtask=SubtaskInstanceEntity{id=4572738, name=Alter resource pool, state=FAILED, operation=RETRY, className=com.alipay.ocp.service.task.business.tenant.AlterResourcePoolTask, seriesId=1, startTime=2022-12-08T20:04:30.194+08:00, endTime=2022-12-08T20:04:30.385+08:00}

com.alipay.ocp.core.obsdk.exception.OceanBaseException: (conn=131184) requested min_memory over 90 percent of total available memory not supported
	at com.alipay.ocp.core.obsdk.connector.ConnectTemplate.customizeException(ConnectTemplate.java:377) ~[ocp-core-3.3.4-20221018.jar!/:3.3.4-20221018]
	at com.alipay.ocp.core.obsdk.connector.ConnectTemplate.customizeException(ConnectTemplate.java:369) ~[ocp-core-3.3.4-20221018.jar!/:3.3.4-20221018]
	at com.alipay.ocp.core.obsdk.connector.ConnectTemplate.customizeException(ConnectTemplate.java:364) ~[ocp-core-3.3.4-20221018.jar!/:3.3.4-20221018]
	at com.alipay.ocp.core.obsdk.connector.ConnectTemplate.updateInner(ConnectTemplate.java:236) ~[ocp-core-3.3.4-20221018.jar!/:3.3.4-20221018]
	at com.alipay.ocp.core.obsdk.connector.ConnectTemplate.update(ConnectTemplate.java:205) ~[ocp-core-3.3.4-20221018.jar!/:3.3.4-20221018]
	at com.alipay.ocp.core.obsdk.operator.resource.MysqlResourceOperator.modifyResourcePoolUnitConfig(MysqlResourceOperator.java:295) ~[ocp-core-3.3.4-20221018.jar!/:3.3.4-20221018]
	at com.alipay.ocp.service.operation.ob.tenant.ResourcePoolService.modifyResourcePool(ResourcePoolService.java:331) ~[ocp-service-3.3.4-20221018.jar!/:3.3.4-20221018]
	at com.alipay.ocp.service.task.business.tenant.AlterResourcePoolTask.run(AlterResourcePoolTask.java:51) ~[ocp-service-3.3.4-20221018.jar!/:3.3.4-20221018]
	at com.alipay.ocp.core.task.runtime.Subtask.retry(Subtask.java:49) ~[ocp-core-3.3.4-20221018.jar!/:3.3.4-20221018]
	at com.alipay.ocp.core.metadb.task.model.SubtaskInstanceEntity.retry(SubtaskInstanceEntity.java:237) ~[ocp-core-3.3.4-202
21018.jar!/:3.3.4-20221018]
	at com.alipay.ocp.core.task.engine.runner.JavaTaskRunner.doExecute(JavaTaskRunner.java:30) ~[ocp-core-3.3.4-20221018.jar!/:3.3.4-20221018]
	at com.alipay.ocp.core.task.engine.runner.JavaTaskRunner.run(JavaTaskRunner.java:20) ~[ocp-core-3.3.4-20221018.jar!/:3.3.4-20221018]
	at com.alipay.ocp.core.task.engine.runner.RunnerFactory.doRun(RunnerFactory.java:118) ~[ocp-core-3.3.4-20221018.jar!/:3.3.4-20221018]
	at com.alipay.ocp.core.task.engine.runner.RunnerFactory.redirectOutputIfNotSysSchedule(RunnerFactory.java:190) ~[ocp-core-3.3.4-20221018.jar!/:3.3.4-20221018]
	at com.alipay.ocp.core.task.engine.runner.RunnerFactory.run(RunnerFactory.java:107) ~[ocp-core-3.3.4-20221018.jar!/:3.3.4-20221018]
	at com.alipay.ocp.core.task.engine.coordinator.worker.subtask.ReadySubtaskWorker.lambda$submitTask$3(ReadySubtaskWorker.java:122) ~[ocp-core-3.3.4-20221018.jar!/:3.3.4-20221018]
	at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_312]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_312]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_312]
	at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_312]
Caused by: java.sql.SQLFeatureNotSupportedException: (conn=131184) requested min_memory over 90 percent of total available memory not supported
	at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:100) ~[oceanbase-client-2.2.7.jar!/:na]
	at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:200) ~[oceanbase-client-2.2.7.jar!/:na]
	at com.oceanbase.jdbc.OceanBaseStatement.executeExceptionEpilogue(OceanBaseStatement.java:304) ~[oceanbase-client-2.2.7.jar!/:na]
	at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternal(JDBC4PreparedStatement.java:238) ~[oceanbase-client-2.2.7.jar!/:na]
	at com.oceanbase.jdbc.JDBC4PreparedStatement.execute(JDBC4PreparedStatement.java:158) ~[oceanbase-client-2.2.7.jar!/:na]

	at com.oceanbase.jdbc.JDBC4PreparedStatement.executeUpdate(JDBC4PreparedStatement.java:190) ~[oceanbase-client-2.2.7.jar!/:na]
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:255) ~[druid-1.2.8.jar!/:1.2.8]
	at org.springframework.jdbc.core.JdbcTemplate.lambda$update$0(JdbcTemplate.java:867) ~[spring-jdbc-5.2.4.RELEASE.jar!/:5.2.4.RELEASE]
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617) ~[spring-jdbc-5.2.4.RELEASE.jar!/:5.2.4.RELEASE]
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:862) ~[spring-jdbc-5.2.4.RELEASE.jar!/:5.2.4.RELEASE]
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:917) ~[spring-jdbc-5.2.4.RELEASE.jar!/:5.2.4.RELEASE]
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:927) ~[spring-jdbc-5.2.4.RELEASE.jar!/:5.2.4.RELEASE]
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论