ORA-00900 事务释放异常

应用开发者专区
#1

Preparing: INSERT INTO BusinFlowParams ( request_no, order_no, busi_content, tohis_flag ) VALUES ( ?, ?, ?, ? ) - [com.cairh.cpe.common.mapper.BusinFlowParamsMapper.insert.debug:137] Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36
2024-01-11 15:29:09.896 DEBUG [10.115.144.135->10.115.144.137][cpe-products-auditcenter-backend][][nykCUf][][http-nio-31000-exec-18] : ==> Parameters: 202401111526230040000(String), 0(Integer), {“activity_name”:“建行一码通”,“inform”:“0”,“update_datetime”:“2024-01-11 15:29:09”,“original_id_address”:“山西省稷山县西社镇范家****”,“face_score”:"",“user_gender”:“2”,“video_speech_id”:“1”,“original_id_enddate”:“30001231”,“id_card_info”:{“birthday”:“19571103”,“id_begindate”:“20060606”,“file_82_modify_flag”:“0”},“alternative_address”:“山西省!~”,“user_base_info”:{“work_unit”:"",“address”:“CHN!~140000!~140800!~140824!~西社镇”,“dishonest_record”:“0”,“choose_branch_reason”:"",“initial_address”:"",“choose_profession_reason”:"",“profession_code”:“57”,“age”:66},“mobile_location”:“山西运城”,“finish_node”:“theStart,audit,review”,“activiti_continue_double_flag”:“0”}(String), 0(String) - [com.cairh.cpe.common.mapper.BusinFlowParamsMapper.insert.debug:137] Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36
2024-01-11 15:29:09.899 DEBUG [10.115.144.135->10.115.144.137][cpe-products-auditcenter-backend][][nykCUf][][http-nio-31000-exec-18] : [202401111529090040000]结束---------更改businFlowParams，申请编号【202401111526230040000】 - [c.c.cpe.businflow.service.impl.BusinRequestFlowServiceImpl.saveContentMapParams:376] Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36
2024-01-11 15:29:09.899 DEBUG [10.115.144.135->10.115.144.137][cpe-products-auditcenter-backend][][nykCUf][][http-nio-31000-exec-18] : acquired connection for command (EXISTS) and params [wskh_ac_lock_submitParamsByOperator_202401111526230040000] from slot NodeSource [slot=0, addr=null, redisClient=null, redirect=null, entry=null] using node 10.115.144.146/10.115.144.146:6379… RedisConnection@1223380785 [redisClient=[addr=redis://10.115.144.146:6379], channel=[id: 0x781526e3, L:/10.115.144.137:33298 - R:10.115.144.146/10.115.144.146:6379], currentCommand=null, usage=1] - [org.redisson.command.RedisExecutor.sendCommand:587] Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36
2024-01-11 15:29:09.900 DEBUG [][][][][][redisson-netty-2-24] : connection released for command (EXISTS) and params [wskh_ac_lock_submitParamsByOperator_202401111526230040000] from slot NodeSource [slot=0, addr=null, redisClient=null, redirect=null, entry=null] using connection RedisConnection@1223380785 [redisClient=[addr=redis://10.115.144.146:6379], channel=[id: 0x781526e3, L:/10.115.144.137:33298 - R:10.115.144.146/10.115.144.146:6379], currentCommand=CommandData [promise=java.util.concurrent.CompletableFuture@20634238[Completed normally], command=(EXISTS), params=[wskh_ac_lock_submitParamsByOperator_202401111526230040000], codec=org.redisson.client.codec.StringCodec], usage=0] - [org.redisson.command.RedisExecutor.releaseConnection:622]
2024-01-11 15:29:09.900 DEBUG [10.115.144.135->10.115.144.137][cpe-products-auditcenter-backend][][nykCUf][][http-nio-31000-exec-18] : acquired connection for command (HEXISTS) and params [wskh_ac_lock_submitParamsByOperator_202401111526230040000, d2366ef3-d782-45ed-a82e-989f68193579:293945] from slot NodeSource [slot=0, addr=null, redisClient=null, redirect=null, entry=null] using node 10.115.144.146/10.115.144.146:6379… RedisConnection@1910632357 [redisClient=[addr=redis://10.115.144.146:6379], channel=[id: 0xccffd991, L:/10.115.144.137:47606 - R:10.115.144.146/10.115.144.146:6379], currentCommand=null, usage=1] - [org.redisson.command.RedisExecutor.sendCommand:587] Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36
2024-01-11 15:29:09.901 DEBUG [][][][][][redisson-netty-2-10] : connection released for command (HEXISTS) and params [wskh_ac_lock_submitParamsByOperator_202401111526230040000, d2366ef3-d782-45ed-a82e-989f68193579:293945] from slot NodeSource [slot=0, addr=null, redisClient=null, redirect=null, entry=null] using connection RedisConnection@1910632357 [redisClient=[addr=redis://10.115.144.146:6379], channel=[id: 0xccffd991, L:/10.115.144.137:47606 - R:10.115.144.146/10.115.144.146:6379], currentCommand=CommandData [promise=java.util.concurrent.CompletableFuture@17cd94db[Completed normally], command=(HEXISTS), params=[wskh_ac_lock_submitParamsByOperator_202401111526230040000, d2366ef3-d782-45ed-a82e-989f68193579:293945], codec=org.redisson.client.codec.LongCodec], usage=0] - [org.redisson.command.RedisExecutor.releaseConnection:622]
2024-01-11 15:29:09.902 DEBUG [][][][][][redisson-netty-2-23] : connection released for command null and params null from slot NodeSource [slot=null, addr=null, redisClient=null, redirect=null, entry=MasterSlaveEntry [masterEntry=[freeSubscribeConnectionsAmount=1, freeSubscribeConnectionsCounter=value:7:queue:0, freeConnectionsAmount=5, freeConnectionsCounter=value:8:queue:0, freezeReason=null, client=[addr=redis://10.115.144.146:6379], nodeType=MASTER, firstFail=0]]] using connection RedisConnection@1622906499 [redisClient=[addr=redis://10.115.144.146:6379], channel=[id: 0xd94fec31, L:/10.115.144.137:33296 - R:10.115.144.146/10.115.144.146:6379], currentCommand=null, usage=0] - [org.redisson.command.RedisExecutor.releaseConnection:622]
2024-01-11 15:29:09.902 DEBUG [10.115.144.135->10.115.144.137][cpe-products-auditcenter-backend][][nykCUf][][http-nio-31000-exec-18] : Releasing transaction savepoint - [org.springframework.jdbc.support.JdbcTransactionManager.processCommit:733] Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36
2024-01-11 15:29:09.909 DEBUG [10.115.144.135->10.115.144.137][cpe-products-auditcenter-backend][][nykCUf][][http-nio-31000-exec-18] : Could not explicitly release JDBC savepoint - [o.s.jdbc.datasource.JdbcTransactionObjectSupport.releaseSavepoint:194] Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36 java.sql.SQLException: ORA-00900: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'RELEASE SAVEPOINT SAVEPOINT_1’ at line 1
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2191) ~[oceanbase-client-2.4.0.jar:na]
com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: ORA-00900: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'RELEASE SAVEPOINT SAVEPOINT_1’ at line 1

#3

您好，您提的这个技术问题牵涉到OceanBase企业版范围内的功能细节。针对此类问题，开源社区的运营同学无法提供相应解答。麻烦您通过以下方式寻求帮助：
1.如您所在的企业客户已签署OceanBase企业版销售合同，请您联系客户经理；
2.如您所在的企业客户尚未签署OceanBase企业版销售合同，您可通过OceanBase官网商务咨询页面留下您的联系方式，OceanBase企业版的业务顾问会在一个工作日内与您联系。
https://www.oceanbase.com/contactus?fromPage=https%3A%2F%2Fwww.oceanbase.com%2Fsoftwarecenter-enterprise&dataSources=softwarecenter-enterprise_footercontact_d2022