SqlExceptionHelper: - SQL Error: 6220 SQL sequence illegal

OceanBase 技术问题
#1

ERROR 6220 (HY000) : SQL sequence illegal OceanBase错误码：6220 错误原因：SQL 语句顺序不合法。
排除 update sql 外键不合法，实际是什么东西不合法？

09:08:45,935 node1@server1 pool-1-thread-17 WARN xxxProcess: - Start Tp4Import
09:08:46,004 node1@server1 pool-1-thread-17 WARN StatefulPersistenceContext: - HHH000179: Narrowing proxy to class com.qqqmodel.Test - this operation breaks ==
09:08:46,022 node1@server1 pool-1-thread-17 ERROR BatchingBatch: - HHH000315: Exception executing batch [java.sql.BatchUpdateException: SQL sequence illegal
[10.67.98.90:2882] [2025-07-07 09:08:46.021389] [YB420A43625A-00062F0715BF9AD3-0-0]], SQL: update table_xxx set Status=?, StatusTs=?, PeriodId=? where ConfirmId=?
09:08:46,022 node1@server1 pool-1-thread-17 WARN SqlExceptionHelper: - SQL Error: 6220, SQLState: HY000
09:08:46,022 node1@server1 pool-1-thread-17 ERROR SqlExceptionHelper: - SQL sequence illegal
[10.67.98.90:2882] [2025-07-07 09:08:46.021389] [YB420A43625A-00062F0715BF9AD3-0-0]
09:08:46,022 node1@server1 pool-1-thread-17 ERROR xxxProcess: -
javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute batch
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) ~[hibernate-core-5.6.7.Final.jar:5.6.7.Final]
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) ~[hibernate-core-5.6.7.Final.jar:5.6.7.Final]
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188) ~[hibernate-core-5.6.7.Final.jar:5.6.7.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1411) ~[hibernate-core-5.6.7.Final.jar:5.6.7.Final]
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1394) ~[hibernate-core-5.6.7.Final.jar:5.6.7.Final]
at com.bbbmodel.common.util.HibernateUtil.flush(HibernateUtil.java:508) ~[classes/:?]
at com.bbbmodel.common.util.HibernateUtil.flush(HibernateUtil.java:503) ~[classes/:?]

#3

ob的版本是多少。麻烦安装下面的方法获取一下相关日志
1）设置trace信息
SET ob_enable_show_trace=‘ON’;

2）执行sql。

3）获取上个命令的trace
select last_trace_id();

4）获取trace对应的节点
select query_sql,svr_ip from gv$ob_sql_audit where trace_id=‘第三步获取的trace信息’；

5）取对应的svr_ip节点 过滤日志
grep “第三步获取的trace信息” observer.log*
grep “第三步获取的trace信息” rootservice.log*

6）提供日志信息即可。

#4

事务顺序有问题吧，检查一下逻辑