TDengine icon indicating copy to clipboard operation
TDengine copied to clipboard

Published 20 hours ago • verified publisher icon taosdata

DB error: Unable to establish connection（3.0.0.1）

Open GitBaymin opened this issue 2 years ago • 1 comments

集群节点情况

虚拟机3.10.0-327.el7.x86_64，16核，可用内存14G，机械盘 客户端和服务端版本：3.0.0.1 三个节点，两个database，每个database只有一个超表（两个超表的存储周期不一样，所以放在两个database中）

taos> show databases;
              name              |
=================================
 information_schema             |
 performance_schema             |
 oper_log                       |
 api_log                        |
Query OK, 4 rows in database (0.002847s)

其中一个超表①目前是42个子表，每个子表数据量不超过100，另一个超表②是3个子表，总数据量是7

问题

超表①无法count，但是超表①的子表又可以count

超表②及其子表均可以count，并且其他客户端命令均正常。

taos> show dnodes;
     id      |            endpoint            | vnodes | support_vnodes |   status   |       create_time       |              note              |
=================================================================================================================================================
           1 | node24:6030                    |      1 |             32 | ready      | 2022-08-28 20:16:52.352 |                                |
           2 | node25:6030                    |      2 |             32 | ready      | 2022-08-28 20:18:23.411 |                                |
           3 | node26:6030                    |      1 |             16 | ready      | 2022-08-28 20:18:23.434 |                                |
Query OK, 3 rows in database (0.004292s)

之前使用2.4.x.x版本测试的时候没有出现过该问题。

# 超表无法查询
taos> select count(*) from api_log.s_api_log;

DB error: Unable to establish connection (2.481355s)
# 子表可以查询
taos> select count(*) from api_log.api_log_20220912_100013093100100000;
       count(*)        |
========================
                    48 |
Query OK, 1 rows in database (0.003815s)

报错日志

                new log file                      
==================================================
09/15 09:01:49.904450 00101134 UTL fail to load apoll url
09/15 09:01:49.904644 00101134 UTL load from cfg file /etc/taos/taos.cfg success
09/15 09:01:49.904661 00101134 UTL failed to load env file: .env
09/15 09:01:49.904683 00101134 UTL load from env variables cfg success
09/15 09:01:49.904815 00101134 UTL                      global config
09/15 09:01:49.904822 00101134 UTL =================================================================
09/15 09:01:49.904831 00101134 UTL cfg_file     firstEp                  node24:6030
09/15 09:01:49.904837 00101134 UTL default      secondEp                 node26:6030
09/15 09:01:49.904842 00101134 UTL cfg_file     fqdn                     node26
09/15 09:01:49.904847 00101134 UTL cfg_file     serverPort               6030
09/15 09:01:49.904852 00101134 UTL default      tempDir                  /tmp
09/15 09:01:49.904857 00101134 UTL default      minimalTmpDirGB          1.00
09/15 09:01:49.904877 00101134 UTL default      shellActivityTimer       3
09/15 09:01:49.904881 00101134 UTL default      compressMsgSize          -1
09/15 09:01:49.904886 00101134 UTL default      compressColData          -1
09/15 09:01:49.904890 00101134 UTL default      queryPolicy              1
09/15 09:01:49.904895 00101134 UTL default      querySmaOptimize         0
09/15 09:01:49.904899 00101134 UTL default      smlChildTableName        
09/15 09:01:49.904904 00101134 UTL default      smlTagName               _tag_null
09/15 09:01:49.904908 00101134 UTL default      smlDataFormat            1
09/15 09:01:49.904913 00101134 UTL default      configDir                /etc/taos
09/15 09:01:49.904918 00101134 UTL default      scriptDir                /etc/taos
09/15 09:01:49.904922 00101134 UTL cfg_file     logDir                   /iot/taos/log
09/15 09:01:49.904927 00101134 UTL default      minimalLogDirGB          1.00
09/15 09:01:49.904932 00101134 UTL default      numOfLogLines            10000000
09/15 09:01:49.904936 00101134 UTL default      asyncLog                 1
09/15 09:01:49.904941 00101134 UTL default      logKeepDays              0
09/15 09:01:49.904945 00101134 UTL default      debugFlag                0
09/15 09:01:49.904949 00101134 UTL default      simDebugFlag             143
09/15 09:01:49.904954 00101134 UTL default      tmrDebugFlag             131
09/15 09:01:49.904958 00101134 UTL default      uDebugFlag               131
09/15 09:01:49.904962 00101134 UTL default      rpcDebugFlag             131
09/15 09:01:49.904966 00101134 UTL default      jniDebugFlag             131
09/15 09:01:49.904970 00101134 UTL default      qDebugFlag               131
09/15 09:01:49.904974 00101134 UTL default      cDebugFlag               131
09/15 09:01:49.904978 00101134 UTL default      timezone                 Asia/Shanghai (CST, +0800)
09/15 09:01:49.904983 00101134 UTL default      locale                   zh_CN.UTF-8
09/15 09:01:49.904988 00101134 UTL default      charset                  UTF-8
09/15 09:01:49.904992 00101134 UTL default      enableCoreFile           1
09/15 09:01:49.904997 00101134 UTL default      numOfCores               8.00
09/15 09:01:49.905002 00101134 UTL default      openMax                  20480
09/15 09:01:49.905007 00101134 UTL default      streamMax                16
09/15 09:01:49.905011 00101134 UTL default      pageSizeKB               4
09/15 09:01:49.905015 00101134 UTL default      totalMemoryKB            7995716
09/15 09:01:49.905020 00101134 UTL default      os sysname               Linux
09/15 09:01:49.905024 00101134 UTL default      os nodename              node26
09/15 09:01:49.905029 00101134 UTL default      os release               3.10.0-327.el7.x86_64
09/15 09:01:49.905033 00101134 UTL default      os version               #1 SMP Thu Oct 29 17:29:29 EDT 2015
09/15 09:01:49.905038 00101134 UTL default      os machine               x86_64
09/15 09:01:49.905042 00101134 UTL default      version                  3.0.0.1
09/15 09:01:49.905047 00101134 UTL default      compatible_version       3.0.0.0
09/15 09:01:49.905051 00101134 UTL default      gitinfo                  aca3d913544676c1c89c0ec732d89aed9554ea1f
09/15 09:01:49.905061 00101134 UTL default      buildinfo                Built at 2022-08-23 10:05
09/15 09:01:49.905065 00101134 UTL =================================================================
09/15 09:01:49.908222 00101136 QRY catalog update thread started
09/15 09:01:49.908279 00101134 QRY scheduler 0x6666336237343432 initizlized, maxJob:1000
09/15 09:01:58.912297 00101136 QRY CTG:0x7f7f5af3e450 start to remove db from cache, dbFName:information_schema, dbId:0x0
09/15 09:01:58.912362 00101136 QRY CTG:0x7f7f5af3e450 db removed from cache, dbFName:information_schema, dbId:0x0
09/15 09:02:04.121858 00101141 RPC WARN TSC conn 0x7f7f38001c70 read error:ECONNRESET, ref:1
09/15 09:02:04.122052 00101141 RPC WARN TSC conn 0x7f7f38000910 read error:EOF, ref:2
09/15 09:02:04.122133 00101142 RPC WARN TSC conn 0x7f7f30000910 read error:ECONNRESET, ref:1
09/15 09:02:04.122166 00101144 RPC WARN TSC conn 0x7f7f20000910 read error:EOF, ref:1
09/15 09:02:04.122162 00101143 RPC WARN TSC conn 0x7f7f2c000910 read error:EOF, ref:1
09/15 09:02:04.122209 00101145 RPC WARN TSC conn 0x7f7f10000910 read error:EOF, ref:1
09/15 09:02:04.122276 00101146 RPC WARN TSC conn 0x7f7f14000910 read error:EOF, ref:1
09/15 09:02:04.122296 00101147 RPC WARN TSC conn 0x7f7f08000910 read error:EOF, ref:2
09/15 09:02:04.122313 00101148 RPC WARN TSC conn 0x7f7f0c000910 read error:EOF, ref:1
09/15 09:02:04.122458 00101138 TSC ERROR 0x4 rsp msg:link-broken, code:Conn is broken rspLen:0, elapsed time:2478 ms, reqId:0x879b0eaac1ab000a
09/15 09:02:04.122455 00101137 TSC ERROR 0x4 rsp msg:query-rsp, code:Conn is broken rspLen:0, elapsed time:2478 ms, reqId:0x879b0eaac1ab000a
09/15 09:02:04.122866 00101143 RPC ERROR TSC conn 0x7f7f2c000910 failed to connect server:connection refused
09/15 09:02:04.122887 00101144 RPC ERROR TSC conn 0x7f7f20000910 failed to connect server:connection refused
09/15 09:02:04.122912 00101140 QRY ERROR hb rsp error:Unable to establish connection
09/15 09:02:04.122937 00101140 QRY ERROR hb rsp error:Unable to establish connection
09/15 09:02:04.122942 00101145 RPC ERROR TSC conn 0x7f7f10000910 failed to connect server:connection refused
09/15 09:02:04.122963 00101139 TSC ERROR 0x4 rsp msg:query-rsp, code:Unable to establish connection rspLen:0, elapsed time:2479 ms, reqId:0x879b0eaac1ab000a
09/15 09:02:04.123353 00101146 RPC ERROR TSC conn 0x7f7f14000910 failed to connect server:connection refused
09/15 09:02:04.123402 00101140 QRY ERROR hb rsp error:Unable to establish connection
09/15 09:02:04.123489 00101147 RPC ERROR TSC conn 0x7f7f08001c70 failed to connect server:connection refused
09/15 09:02:04.123524 00101138 TSC ERROR 0x4 rsp msg:query-rsp, code:Unable to establish connection rspLen:0, elapsed time:2479 ms, reqId:0x879b0eaac1ab000a
09/15 09:02:04.123799 00101141 RPC ERROR TSC conn 0x7f7f38001c70 failed to connect server:connection refused
09/15 09:02:04.123802 00101148 RPC ERROR TSC conn 0x7f7f0c000910 failed to connect server:connection refused
09/15 09:02:04.123841 00101140 TSC ERROR 0x4 rsp msg:query-rsp, code:Unable to establish connection rspLen:0, elapsed time:2480 ms, reqId:0x879b0eaac1ab000a
09/15 09:02:04.123854 00101139 QRY ERROR hb rsp error:Unable to establish connection
09/15 09:02:04.124091 00101141 RPC ERROR TSC conn 0x7f7f38001c70 failed to connect server:connection refused
09/15 09:02:04.124116 00101138 QRY ERROR hb rsp error:Unable to establish connection
09/15 09:02:04.124229 00101142 RPC ERROR TSC conn 0x7f7f30000910 failed to connect server:connection refused
09/15 09:02:04.124262 00101139 TSC ERROR 0x4 rsp msg:query-rsp, code:Unable to establish connection rspLen:0, elapsed time:2480 ms, reqId:0x879b0eaac1ab000a
09/15 09:02:04.124579 00101143 RPC ERROR TSC conn 0x7f7f2c000910 failed to connect server:connection refused
09/15 09:02:04.124618 00101144 RPC ERROR TSC conn 0x7f7f20000910 failed to connect server:connection refused
09/15 09:02:04.124644 00101138 QRY ERROR hb rsp error:Unable to establish connection
09/15 09:02:04.124650 00101138 TSC ERROR 0x4 rsp msg:query-rsp, code:Unable to establish connection rspLen:0, elapsed time:2481 ms, reqId:0x879b0eaac1ab000a
09/15 09:02:04.124659 00101138 QRY ERROR QID:0x879b0eaac1ab000a,TID:0x4,EID:5 task failed and no more retry, code:Unable to establish connection
09/15 09:02:04.137391 00101141 RPC ERROR TSC conn 0x7f7f38001c70 failed to connect server:connection refused
09/15 09:02:04.137658 00101142 RPC ERROR TSC conn 0x7f7f30000910 failed to connect server:connection refused
09/15 09:02:04.152711 00101141 RPC ERROR TSC conn 0x7f7f38001c70 failed to connect server:connection refused
09/15 09:02:04.152785 00101137 TSC ERROR time diff: 1663203724s is too big
09/15 09:02:04.153034 00101142 RPC ERROR TSC conn 0x7f7f30000910 failed to connect server:connection refused
09/15 09:02:04.153075 00101139 TSC ERROR time diff: 1663203724s is too big
09/15 09:02:25.915827 00101136 QRY CTG:0x7f7f5af3e450 start to remove db from cache, dbFName:information_schema, dbId:0x0
09/15 09:02:25.915925 00101136 QRY CTG:0x7f7f5af3e450 db removed from cache, dbFName:information_schema, dbId:0x0
09/15 11:01:45.384074 00101145 RPC WARN TSC conn 0x7f7f10000910 read error:ECONNRESET, ref:1
09/15 11:01:45.384130 00101148 RPC WARN TSC conn 0x7f7f0c0009b0 read error:EOF, ref:1
09/15 11:01:45.384177 00101141 RPC WARN TSC conn 0x7f7f38001c70 read error:EOF, ref:1
09/15 11:01:45.384185 00101147 RPC WARN TSC conn 0x7f7f08001c70 read error:EOF, ref:1
09/15 11:01:45.384223 00101144 RPC WARN TSC conn 0x7f7f20000910 read error:ECONNRESET, ref:1
09/15 11:01:45.384229 00101142 RPC WARN TSC conn 0x7f7f30000910 read error:EOF, ref:1
09/15 11:01:45.384275 00101146 RPC WARN TSC conn 0x7f7f14000960 read error:EOF, ref:1
09/15 11:01:45.384421 00101143 RPC WARN TSC conn 0x7f7f2c001cc0 read error:EOF, ref:1
09/15 11:01:45.399538 00101144 RPC ERROR TSC conn 0x7f7f20000910 failed to connect server:connection refused
09/15 11:01:45.399579 00101145 RPC ERROR TSC conn 0x7f7f10000910 failed to connect server:connection refused
09/15 11:01:45.414969 00101144 RPC ERROR TSC conn 0x7f7f20000910 failed to connect server:connection refused
09/15 11:01:45.414988 00101145 RPC ERROR TSC conn 0x7f7f10000910 failed to connect server:connection refused
09/15 11:01:45.415006 00101140 TSC ERROR time diff: 1663210905s is too big
09/15 11:01:45.415023 00101139 TSC ERROR time diff: 1663210905s is too big

GitBaymin avatar Sep 15 '22 03:09 GitBaymin

可以更新至 3.0.1.1 ，做了一些调整，底层有变化

yu285 avatar Sep 16 '22 14:09 yu285

3.0早期版本的bug 都已经都修复了，但是3.0.2.5 之前可能与现在的最新版（3.3.0.0）并不兼容，所以无法直接升级。因此建议重新部署一下最新的 3.3.0.0 ，后续升级都很方便，直接安装最新版软件即可。

开源版支持操作系统范围：https://docs.taosdata.com/reference/support-platform/

yu285 avatar May 13 '24 11:05 yu285