文档建议反馈控制台
首页
学习
活动
专区
圈层
工具
MCP广场
文章/答案/技术大牛
发布
社区首页 >问答首页 >TDengine错误(8000000b)：无法建立连接

问TDengine错误(8000000b)：无法建立连接
EN

Stack Overflow用户
提问于 2021-07-22 17:38:55
回答 1查看 78关注 0票数 0

enter image description here我正在学习在myBatis项目中使用taos JDBC，当我使用TDengine提供的演示时。我遇到了这个问题，无法建立连接。sql:insert into db1.t1(ts,temperature) values (now,23.23)在调用execute this sql命令时引发异常。我试着在服务器上运行命令行中的sql，没问题。当在我的windows客户端上运行时，它失败了。运行环境服务器: ubuntu 18.4客户端: window x64 taos-taos驱动程序:2.0.32

日志信息

代码语言：javascript
复制
2021-07-22 16:00:48.116 DEBUG 16276 --- [           main] c.t.e.m.m.T.dropSuperTable               : ==>  Preparing: drop table if exists temperature 
2021-07-22 16:00:48.130 DEBUG 16276 --- [           main] c.t.e.m.m.T.dropSuperTable               : ==> Parameters: 
2021-07-22 16:00:48.139 DEBUG 16276 --- [           main] c.t.e.m.m.T.dropSuperTable               : <==    Updates: 0
2021-07-22 16:00:48.140 DEBUG 16276 --- [           main] c.t.e.m.m.T.createSuperTable             : ==>  Preparing: CREATE TABLE if not exists temperature(ts timestamp, temperature float) tags(location nchar(64), tbIndex int) 
2021-07-22 16:00:48.141 DEBUG 16276 --- [           main] c.t.e.m.m.T.createSuperTable             : ==> Parameters: 
2021-07-22 16:00:48.161 DEBUG 16276 --- [           main] c.t.e.m.m.T.createSuperTable             : <==    Updates: 0
2021-07-22 16:00:48.163 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-22 16:00:48.164 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t0(String), 杭州(String), 0(Integer)
2021-07-22 16:00:48.226 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-22 16:00:48.227 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-22 16:00:48.228 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t1(String), 深圳(String), 1(Integer)
2021-07-22 16:00:48.242 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-22 16:00:48.243 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-22 16:00:48.243 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t2(String), 上海(String), 2(Integer)
2021-07-22 16:00:48.265 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-22 16:00:48.266 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-22 16:00:48.266 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t3(String), 上海(String), 3(Integer)
2021-07-22 16:00:48.286 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-22 16:00:48.287 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-22 16:00:48.287 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t4(String), 深圳(String), 4(Integer)
2021-07-22 16:00:48.301 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-22 16:00:48.302 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-22 16:00:48.302 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t5(String), 北京(String), 5(Integer)
2021-07-22 16:00:48.323 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-22 16:00:48.324 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-22 16:00:48.324 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t6(String), 杭州(String), 6(Integer)
2021-07-22 16:00:48.339 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-22 16:00:48.340 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-22 16:00:48.341 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t7(String), 深圳(String), 7(Integer)
2021-07-22 16:00:48.360 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-22 16:00:48.361 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-22 16:00:48.361 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t8(String), 深圳(String), 8(Integer)
2021-07-22 16:00:48.375 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-22 16:00:48.376 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-22 16:00:48.376 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t9(String), 北京(String), 9(Integer)
2021-07-22 16:00:48.403 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-22 16:00:48.423 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.insertOne    : ==>  Preparing: insert into t0(ts, temperature) values(?, ?) 
2021-07-22 16:00:48.423 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.insertOne    : ==> Parameters: 2020-11-11 00:00:00.0(Timestamp), 3.1568499(Float)
2021-07-22 16:00:57.045 DEBUG 16276 --- [           main] c.t.e.m.m.T.dropSuperTable               : ==>  Preparing: drop table if exists temperature 
2021-07-22 16:00:57.045 DEBUG 16276 --- [           main] c.t.e.m.m.T.dropSuperTable               : ==> Parameters: 
2021-07-22 16:00:57.071 DEBUG 16276 --- [           main] c.t.e.m.m.T.dropSuperTable               : <==    Updates: 0

org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: java.sql.SQLException: TDengine ERROR (8000000b): Unable to establish connection
### The error may exist in com/taosdata/example/mybatisplusdemo/mapper/TemperatureMapper.java (best guess)
### The error may involve com.taosdata.example.mybatisplusdemo.mapper.TemperatureMapper.insertOne-Inline
### The error occurred while setting parameters
### SQL: insert into t0(ts, temperature) values(?, ?)
### Cause: java.sql.SQLException: TDengine ERROR (8000000b): Unable to establish connection

    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:199)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
    at com.sun.proxy.$Proxy63.insert(Unknown Source)
    at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)
    at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:58)
    at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:62)
    at com.sun.proxy.$Proxy78.insertOne(Unknown Source)
    at com.taosdata.example.mybatisplusdemo.mapper.TemperatureMapperTest.before(TemperatureMapperTest.java:49)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
    at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24)
    at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)
    at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
    at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)
    at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)
    at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:251)
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97)
    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
    at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
    at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
    at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:190)
    at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
    at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
    at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)
    at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:221)
    at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54)
Caused by: java.sql.SQLException: TDengine ERROR (8000000b): Unable to establish connection
    at com.taosdata.jdbc.TSDBError.createSQLException(TSDBError.java:73)
    at com.taosdata.jdbc.TSDBJNIConnector.executeQuery(TSDBJNIConnector.java:123)
    at com.taosdata.jdbc.TSDBStatement.execute(TSDBStatement.java:85)
    at com.taosdata.jdbc.TSDBPreparedStatement.execute(TSDBPreparedStatement.java:266)
    at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
    at com.sun.proxy.$Proxy89.execute(Unknown Source)
    at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
    at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
    at com.sun.proxy.$Proxy88.update(Unknown Source)
    at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doUpdate(MybatisSimpleExecutor.java:54)
    at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
    at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
    ... 41 more

enter image description here

database
mybatis
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2021-07-23 13:14:26

我已经在我的pc上尝试过这个演示。它工作正常。

代码语言：javascript
复制
unable to establish connection

此异常总是由网络问题引起。但是从你的日志信息来看，似乎你可以访问TDengine.It很难说是什么导致了这一点。

我建议您可以打开debug标志，并尝试弄清楚那里发生了什么。

您可以按照以下步骤调试TDengine并读取调试日志，这通常非常有用。对于windows

代码语言：javascript
复制
{TDengine_home}/cfg/tao.cfg

添加"debugFlag 135"，然后再次运行演示代码并读取客户端登录信息

代码语言：javascript
复制
{TDengine_home}/log/taoslog.*

找到您的sql，您就可以找到错误

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：

https://stackoverflow.com/questions/68482579

复制
相关文章

相似问题

领券

腾讯云开发者

扫码关注腾讯云开发者

扫码关注腾讯云开发者

领取腾讯云代金券

热门产品

热门推荐

更多推荐

Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有 

深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 粤公网安备44030502008569号

腾讯云计算（北京）有限责任公司 京ICP证150476号 |  京ICP备11018762号

问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档