【TDengine 使用环境】
测试
【TDengine 版本】
3.3.6.3
【操作系统以及版本】
【部署方式】非容器部署
【集群节点数】
1
【集群副本数】
1
【描述业务影响】
TDengine批量报错报错,报错日志如下:
2025-12-29 10:28:23,854 [saveExecutor-56] ERROR c.i.i.t.b.d.task.DeviceCommLogTask - 保存tdengine失败:org.springframework.jdbc.UncategorizedSQLException:
Error updating database. Cause: java.sql.SQLException: TDengine ERROR (0x80000138): Internal error
The error may exist in class path resource [tdengineMapper/DeviceHistoryMapper.xml]
The error may involve defaultParameterMap
The error occurred while setting parameters
SQL: INSERT INTO device_comm_log_13989 USING device_comm_log TAGS ( ? ) VALUES ( ?, ?, ?, ?, ?, ?, ? )
Cause: java.sql.SQLException: TDengine ERROR (0x80000138): Internal error
; uncategorized SQLException; SQL state ; error code [-2147483336]; TDengine ERROR (0x80000138): Internal error; nested exception is java.sql.SQLException: TDengine ERROR (0x80000138): Internal error
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
at jdk.proxy2/jdk.proxy2.$Proxy141.insert(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:59)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
at jdk.proxy2/jdk.proxy2.$Proxy196.insertBatch(Unknown Source)
at com.iflytek.iot.thing.broker.device.service.impl.DeviceHistoryServiceTdImpl.addList(DeviceHistoryServiceTdImpl.java:43)
at com.iflytek.iot.thing.broker.device.service.impl.DeviceHistoryServiceTdImpl$$FastClassBySpringCGLIB$$1ea36bce.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:692)
at com.iflytek.iot.thing.broker.device.service.impl.DeviceHistoryServiceTdImpl$$EnhancerBySpringCGLIB$$ff02fc0b.addList()
at com.iflytek.iot.thing.broker.device.task.DeviceCommLogTask.lambda$saveCommLog$3(DeviceCommLogTask.java:130)
at org.apache.skywalking.apm.toolkit.trace.RunnableWrapper.run(RunnableWrapper.java:34)
at com.alibaba.ttl.TtlRunnable.run(TtlRunnable.java:55)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: java.sql.SQLException: TDengine ERROR (0x80000138): Internal error
at com.taosdata.jdbc.TSDBError.createSQLException(TSDBError.java:95)
at com.taosdata.jdbc.TSDBJNIConnector.executeQuery(TSDBJNIConnector.java:240)
at com.taosdata.jdbc.TSDBStatement.executeImpl(TSDBStatement.java:178)
at com.taosdata.jdbc.TSDBStatement.execute(TSDBStatement.java:164)
at com.taosdata.jdbc.TSDBStatement.execute(TSDBStatement.java:143)
at com.taosdata.jdbc.TSDBPreparedStatement.execute(TSDBPreparedStatement.java:178)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)
at jdk.proxy2/jdk.proxy2.$Proxy241.update(Unknown Source)
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
at jdk.proxy2/jdk.proxy2.$Proxy240.update(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
… 23 more
