oceanbase兼容性

OceanBase
#1

Caused by: org.springframework.transaction.TransactionSystemException: Could not commit JDBC transaction; nested exception is com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Transaction rollbacked at org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:332) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:534) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:305) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) … 89 common frames omitted Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Transaction rollbacked at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:123) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ConnectionImpl.commit(ConnectionImpl.java:805) at com.alibaba.druid.filter.FilterChainImpl.connection_commit(FilterChainImpl.java:199) at com.alibaba.druid.filter.stat.StatFilter.connection_commit(StatFilter.java:267) at com.alibaba.druid.filter.FilterChainImpl.connection_commit(FilterChainImpl.java:194) at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.commit(ConnectionProxyImpl.java:123) at com.alibaba.druid.pool.DruidPooledConnection.commit(DruidPooledConnection.java:749) at org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:329) … 98 common frames omitted

在mysql环境没问题、切换成oceanbase就会报错、请问这个报错跟oceanbase数据库有关系么

微信图片_20210926135943.png (23079 KB)

#2

请问下是什么操作导致的这个报错呢？OB环境背景是怎样的？

#3

导入文件

#4

麻烦发一下业务租户资源规格

#5

用下面SQL



select t1.name resource_pool_name, t2.`name` unit_config_name, t2.max_cpu, t2.min_cpu, round(t2.max_memory/1024/1024/1024) max_mem_gb, round(t2.min_memory/1024/1024/1024) min_mem_gb, t3.unit_id, t3.zone, concat(t3.svr_ip,':',t3.`svr_port`) observer,t4.tenant_id, t4.tenant_name



from __all_resource_pool t1 join __all_unit_config t2 on (t1.unit_config_id=t2.unit_config_id)



join __all_unit t3 on (t1.`resource_pool_id` = t3.`resource_pool_id`)



left join __all_tenant t4 on (t1.tenant_id=t4.tenant_id)



order by t1.`resource_pool_id`, t2.`unit_config_id`, t3.unit_id



;