niaucz commented on issue #29499:
URL:
https://github.com/apache/shardingsphere/issues/29499#issuecomment-1868191877
@RaigorJiang
```
INSERT INTO nx_data ( id, point_guid, tag, `value`, `timestamp` ) VALUES (
?, ?, ?, ?, ? )
```
```
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7930cce1]
was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@297833448 wrapping
org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection@422d4e38]
will not be managed by Spring
==> Preparing: INSERT INTO nx_data ( id, point_guid, tag, `value`,
`timestamp` ) VALUES ( ?, ?, ?, ?, ? )
Closing non transactional SqlSession
[org.apache.ibatis.session.defaults.DefaultSqlSession@7930cce1]
2023-12-23T11:32:30.075+08:00 ERROR 16284 --- [ scheduling-1]
o.s.s.s.TaskUtils$LoggingErrorHandler : Unexpected error occurred in
scheduled task
org.mybatis.spring.MyBatisSystemException: null
at
org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:97)
~[mybatis-spring-2.1.1.jar:2.1.1]
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
~[mybatis-spring-2.1.1.jar:2.1.1]
at jdk.proxy2/jdk.proxy2.$Proxy76.insert(Unknown Source) ~[na:na]
at
org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
~[mybatis-spring-2.1.1.jar:2.1.1]
at
com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:59)
~[mybatis-plus-core-3.5.4.1.jar:3.5.4.1]
at
com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:152)
~[mybatis-plus-core-3.5.4.1.jar:3.5.4.1]
at
com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
~[mybatis-plus-core-3.5.4.1.jar:3.5.4.1]
at jdk.proxy2/jdk.proxy2.$Proxy80.insert(Unknown Source) ~[na:na]
at xxxxx.xxxxx.xxxxx.config.TestTask.myMethod(TestTask.java:42)
~[classes/:na]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:na]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
~[na:na]
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na]
at
org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
~[spring-context-6.0.13.jar:6.0.13]
at
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
~[spring-context-6.0.13.jar:6.0.13]
at
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
~[na:na]
at
java.base/java.util.concurrent.FutureTask.runAndReset$$$capture(FutureTask.java:305)
~[na:na]
at
java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java) ~[na:na]
at
java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
~[na:na]
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
~[na:na]
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
~[na:na]
at java.base/java.lang.Thread.run(Thread.java:833) ~[na:na]
Caused by: org.apache.ibatis.executor.ExecutorException: Error preparing
statement. Cause:
org.apache.shardingsphere.infra.exception.TableNotExistsException: Table or
view `nx_data` does not exist.
at
org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:99)
~[mybatis-3.5.13.jar:3.5.13]
at
org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:60)
~[mybatis-3.5.13.jar:3.5.13]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:na]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
~[na:na]
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na]
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
~[mybatis-3.5.13.jar:3.5.13]
at
com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106)
~[mybatis-plus-extension-3.5.4.1.jar:3.5.4.1]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
~[mybatis-3.5.13.jar:3.5.13]
at jdk.proxy2/jdk.proxy2.$Proxy116.prepare(Unknown Source) ~[na:na]
at
org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:90)
~[mybatis-3.5.13.jar:3.5.13]
at
org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)
~[mybatis-3.5.13.jar:3.5.13]
at
org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
~[mybatis-3.5.13.jar:3.5.13]
at
org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
~[mybatis-3.5.13.jar:3.5.13]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:na]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
~[na:na]
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na]
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
~[mybatis-3.5.13.jar:3.5.13]
at
com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106)
~[mybatis-plus-extension-3.5.4.1.jar:3.5.4.1]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
~[mybatis-3.5.13.jar:3.5.13]
at jdk.proxy2/jdk.proxy2.$Proxy115.update(Unknown Source) ~[na:na]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
~[mybatis-3.5.13.jar:3.5.13]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
~[mybatis-3.5.13.jar:3.5.13]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:na]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
~[na:na]
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na]
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
~[mybatis-spring-2.1.1.jar:2.1.1]
... 20 common frames omitted
Caused by:
org.apache.shardingsphere.infra.exception.TableNotExistsException: Table or
view `nx_data` does not exist.
at
org.apache.shardingsphere.infra.binder.segment.from.impl.SimpleTableSegmentBinder.lambda$checkTableExists$4(SimpleTableSegmentBinder.java:146)
~[shardingsphere-infra-binder-5.4.1.jar:5.4.1]
at
org.apache.shardingsphere.infra.exception.core.ShardingSpherePreconditions.checkState(ShardingSpherePreconditions.java:41)
~[shardingsphere-infra-exception-core-5.4.1.jar:5.4.1]
at
org.apache.shardingsphere.infra.binder.segment.from.impl.SimpleTableSegmentBinder.checkTableExists(SimpleTableSegmentBinder.java:143)
~[shardingsphere-infra-binder-5.4.1.jar:5.4.1]
at
org.apache.shardingsphere.infra.binder.segment.from.impl.SimpleTableSegmentBinder.bind(SimpleTableSegmentBinder.java:82)
~[shardingsphere-infra-binder-5.4.1.jar:5.4.1]
at
org.apache.shardingsphere.infra.binder.statement.dml.InsertStatementBinder.lambda$bind$0(InsertStatementBinder.java:58)
~[shardingsphere-infra-binder-5.4.1.jar:5.4.1]
at java.base/java.util.Optional.ifPresent(Optional.java:178) ~[na:na]
at
org.apache.shardingsphere.infra.binder.statement.dml.InsertStatementBinder.bind(InsertStatementBinder.java:58)
~[shardingsphere-infra-binder-5.4.1.jar:5.4.1]
at
org.apache.shardingsphere.infra.binder.statement.dml.InsertStatementBinder.bind(InsertStatementBinder.java:48)
~[shardingsphere-infra-binder-5.4.1.jar:5.4.1]
at
org.apache.shardingsphere.infra.binder.engine.SQLBindEngine.bindDMLStatement(SQLBindEngine.java:103)
~[shardingsphere-infra-binder-5.4.1.jar:5.4.1]
at
org.apache.shardingsphere.infra.binder.engine.SQLBindEngine.bind(SQLBindEngine.java:80)
~[shardingsphere-infra-binder-5.4.1.jar:5.4.1]
at
org.apache.shardingsphere.infra.binder.engine.SQLBindEngine.bind(SQLBindEngine.java:71)
~[shardingsphere-infra-binder-5.4.1.jar:5.4.1]
at
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:202)
~[shardingsphere-jdbc-core-5.4.1.jar:5.4.1]
at
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:167)
~[shardingsphere-jdbc-core-5.4.1.jar:5.4.1]
at
org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection.prepareStatement(ShardingSphereConnection.java:83)
~[shardingsphere-jdbc-core-5.4.1.jar:5.4.1]
at
com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:328)
~[HikariCP-5.1.0.jar:na]
at
com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
~[HikariCP-5.1.0.jar:na]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:na]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
~[na:na]
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na]
at
org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogger.java:53)
~[mybatis-3.5.13.jar:3.5.13]
at jdk.proxy3/jdk.proxy3.$Proxy121.prepareStatement(Unknown Source)
~[na:na]
at
org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:88)
~[mybatis-3.5.13.jar:3.5.13]
at
org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:90)
~[mybatis-3.5.13.jar:3.5.13]
... 48 common frames omitted
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
