V-2.3.0 KINGBASE V8 UNDO_LOG_SEQ.nextval ERROR

[dongshanghua]

============== Sql Start ==============
Execute SQL : insert into undo_log (id, branch_id, xid, context, rollback_info , log_status, log_created, log_modified) values (UNDO_LOG_SEQ.nextval, 724994675160649728, '192.168.1.6:8091:724994674795745280', 'serializer=jackson&compressorType=NONE&map=', x'7B2240636C617373223A226F72672E6170616368652E73656174612E726D2E64617461736F757263652E756E646F2E4272616E6368556E646F4C6F67222C22786964223A223139322E3136382E312E363A383039313A373234393934363734373935373435323830222C226272616E63684964223A3732343939343637353136303634393732382C2273716C556E646F4C6F6773223A5B226A6176612E7574696C2E41727261794C697374222C5B7B2240636C617373223A226F72672E6170616368652E73656174612E726D2E64617461736F757263652E756E646F2E53514C556E646F4C6F67222C2273716C54797065223A22555044415445222C227461626C654E616D65223A2274625F73746F72616765222C226265666F7265496D616765223A7B2240636C617373223A226F72672E6170616368652E73656174612E726D2E64617461736F757263652E73716C2E7374727563742E5461626C655265636F726473222C227461626C654E616D65223A2254425F53544F52414745222C22726F7773223A5B226A6176612E7574696C2E41727261794C697374222C5B7B2240636C617373223A226F72672E6170616368652E73656174612E726D2E64617461736F757263652E73716C2E7374727563742E526F77222C226669656C6473223A5B226A6176612E7574696C2E41727261794C697374222C5B7B2240636C617373223A226F72672E6170616368652E73656174612E726D2E64617461736F757263652E73716C2E7374727563742E4669656C64222C226E616D65223A22636F6D6D6F646974795F636F6465222C226B657954797065223A224E554C4C222C2274797065223A31322C2276616C7565223A2270726F647563742D31227D2C7B2240636C617373223A226F72672E6170616368652E73656174612E726D2E64617461736F757263652E73716C2E7374727563742E4669656C64222C226E616D65223A22636F756E74222C226B657954797065223A224E554C4C222C2274797065223A342C2276616C7565223A393939393939397D2C7B2240636C617373223A226F72672E6170616368652E73656174612E726D2E64617461736F757263652E73716C2E7374727563742E4669656C64222C226E616D65223A226964222C226B657954797065223A225052494D4152595F4B4559222C2274797065223A31322C2276616C7565223A2231227D5D5D7D5D5D7D2C226166746572496D616765223A7B2240636C617373223A226F72672E6170616368652E73656174612E726D2E64617461736F757263652E73716C2E7374727563742E5461626C655265636F726473222C227461626C654E616D65223A2254425F53544F52414745222C22726F7773223A5B226A6176612E7574696C2E41727261794C697374222C5B7B2240636C617373223A226F72672E6170616368652E73656174612E726D2E64617461736F757263652E73716C2E7374727563742E526F77222C226669656C6473223A5B226A6176612E7574696C2E41727261794C697374222C5B7B2240636C617373223A226F72672E6170616368652E73656174612E726D2E64617461736F757263652E73716C2E7374727563742E4669656C64222C226E616D65223A22636F6D6D6F646974795F636F6465222C226B657954797065223A224E554C4C222C2274797065223A31322C2276616C7565223A2270726F647563742D31227D2C7B2240636C617373223A226F72672E6170616368652E73656174612E726D2E64617461736F757263652E73716C2E7374727563742E4669656C64222C226E616D65223A22636F756E74222C226B657954797065223A224E554C4C222C2274797065223A342C2276616C7565223A393939393739397D2C7B2240636C617373223A226F72672E6170616368652E73656174612E726D2E64617461736F757263652E73716C2E7374727563742E4669656C64222C226E616D65223A226964222C226B657954797065223A225052494D4152595F4B4559222C2274797065223A31322C2276616C7565223A2231227D5D5D7D5D5D7D7D5D5D7D' , 0, sysdate, sysdate)
Execute Time: 0ms
============== Sql End ==============

2025-10-24 14:30:00.313 ERROR 31472 --- [ XNIO-1 task-2] o.a.seata.rm.datasource.ConnectionProxy : process connectionProxy commit error: ERROR: 缺少表 “UNDO_LOG_SEQ” 的 FROM 子句或目标关系条目
Position: 112 At Line: 1, Line Position: 112

com.kingbase8.util.KSQLException: ERROR: 缺少表 “UNDO_LOG_SEQ” 的 FROM 子句或目标关系条目
Position: 112 At Line: 1, Line Position: 112
at com.kingbase8.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:3553) ~[kingbase-8.6.0.jar:V008R006C008B0020PSC001]
at com.kingbase8.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2995) ~[kingbase-8.6.0.jar:V008R006C008B0020PSC001]
at com.kingbase8.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407) ~[kingbase-8.6.0.jar:V008R006C008B0020PSC001]
at com.kingbase8.jdbc.KbStatement.executeInternal_(KbStatement.java:781) ~[kingbase-8.6.0.jar:V008R006C008B0020PSC001]
at com.kingbase8.jdbc.KbStatement.execute(KbStatement.java:673) ~[kingbase-8.6.0.jar:V008R006C008B0020PSC001]
at com.kingbase8.jdbc.KbPreparedStatement.executeWithFlags(KbPreparedStatement.java:286) ~[kingbase-8.6.0.jar:V008R006C008B0020PSC001]
at com.kingbase8.jdbc.KbPreparedStatement.executeUpdate(KbPreparedStatement.java:216) ~[kingbase-8.6.0.jar:V008R006C008B0020PSC001]
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:3254) ~[druid-1.2.23.jar:na]
at com.alibaba.druid.filter.FilterAdapter.preparedStatement_executeUpdate(FilterAdapter.java:1075) ~[druid-1.2.23.jar:na]

[dongshanghua]

SELECT nextval('UNDO_LOG_SEQ');

[yougecn]

-- Generate ID using sequence and trigger
CREATE SEQUENCE UNDO_LOG_SEQ START WITH 1 INCREMENT BY 1;
少创建了序列 UNDO_LOG_SEQ