【Dameng】Failed to batch delete undo log

[hufalong]

Dameng8 + seata2.2.0.
GlobalTransactional After the method is successfully executed, the table deletion message fails.

The following error message is displayed

{"logId":"19810668618915840","rid":"-","span":"-","time":"20250224160031.463","clz":"org.apache.seata.rm.datasource.AsyncWorker","line":187,"msg":"Failed to batch delete undo log; dm.jdbc.driver.DMException[M= line 1, column 28, nearby [context] has error: \nSyntax error]","thread":"AsyncWorker_1_2_2","level":"ERROR","host":"192.164.12.178","sn":"icc-finance-service","cost":0,"cause":"dm.jdbc.driver.DMException: line 1, column 28, nearby [context] has error: \nSyntax error\n\tat dm.jdbc.driver.DBError.throwException(SourceFile:738)\n\tat dm.jdbc.a.a.y.r(SourceFile:623)\n\tat dm.jdbc.a.a.f.r(SourceFile:138)\n\tat dm.jdbc.a.a.y.z(SourceFile:555)\n\tat dm.jdbc.a.a.y.L(SourceFile:536)\n\tat dm.jdbc.a.a.a(SourceFile:269)\n\tat dm.jdbc.a.a.a(SourceFile:792)\n\tat dm.jdbc.driver.DmdbPreparedStatement.prepareSql(SourceFile:321)\n\tat dm.jdbc.driver.DmdbPreparedStatement.allocateHandle(SourceFile:246)\n\tat dm.jdbc.driver.DmdbPreparedStatement.<init>(SourceFile:148)\n\tat dm.jdbc.driver.DmdbPreparedStatement.<init>(SourceFile:198)\n\tat dm.jdbc.driver.DmdbConnection.do_prepareStatement(SourceFile:793)\n\tat dm.jdbc.driver.DmdbConnection.do_prepareStatement(SourceFile:779)\n\tat dm.jdbc.driver.DmdbConnection.prepareStatement(SourceFile:1413)\n\tat com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:327)\n\tat com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)\n\tat org.apache.seata.rm.datasource.undo.AbstractUndoLogManager.batchDeleteUndoLog(AbstractUndoLogManager.java:167)\n\tat org.apache.seata.rm.datasource.AsyncWorker.deleteUndoLog(AsyncWorker.java:182)\n\tat org.apache.seata.rm.datasource.AsyncWorker.dealWithGroupedContexts(AsyncWorker.java:162)\n\tat java.base/java.util.HashMap.forEach(HashMap.java:1421)\n\tat org.apache.seata.rm.datasource.AsyncWorker.doBranchCommit(AsyncWorker.java:125)\n\tat org.apache.seata.rm.datasource.AsyncWorker.doBranchCommitSafely(AsyncWorker.java:107)\n\tat com.alibaba.ttl.TtlRunnable.run(TtlRunnable.java:60)\n\tat java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)\n\tat java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)\n\tat java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)\n\tat io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)\n\tat java.base/java.lang.Thread.run(Thread.java:840)\n"}

Cause of the problem
dameng db context keywords

Environment:

• JDK version(e.g. java -version):17
• Seata client/server version: 2.2.0
• Database version: Dameng8

[jsbxyyx]

需要转义处理
Need to escape processing

[funky-eyes]

#7010