An open-source big data platform designed and optimized for the Internet of Things (IoT).

Last update: Jul 1, 2022

Overview

English | 简体中文 We are hiring, check here

What is TDengine？

TDengine is an open-sourced big data platform under GNU AGPL v3.0, designed and optimized for the Internet of Things (IoT), Connected Cars, Industrial IoT, and IT Infrastructure and Application Monitoring. Besides the 10x faster time-series database, it provides caching, stream computing, message queuing and other functionalities to reduce the complexity and cost of development and operation.

10x Faster on Insert/Query Speeds: Through the innovative design on storage, on a single-core machine, over 20K requests can be processed, millions of data points can be ingested, and over 10 million data points can be retrieved in a second. It is 10 times faster than other databases.
1/5 Hardware/Cloud Service Costs: Compared with typical big data solutions, less than 1/5 of computing resources are required. Via column-based storage and tuned compression algorithms for different data types, less than 1/10 of storage space is needed.
Full Stack for Time-Series Data: By integrating a database with message queuing, caching, and stream computing features together, it is no longer necessary to integrate Kafka/Redis/HBase/Spark or other software. It makes the system architecture much simpler and more robust.
Powerful Data Analysis: Whether it is 10 years or one minute ago, data can be queried just by specifying the time range. Data can be aggregated over time, multiple time streams or both. Ad Hoc queries or analyses can be executed via TDengine shell, Python, R or Matlab.
Seamless Integration with Other Tools: Telegraf, Grafana, Matlab, R, and other tools can be integrated with TDengine without a line of code. MQTT, OPC, Hadoop, Spark, and many others will be integrated soon.
Zero Management, No Learning Curve: It takes only seconds to download, install, and run it successfully; there are no other dependencies. Automatic partitioning on tables or DBs. Standard SQL is used, with C/C++, Python, JDBC, Go and RESTful connectors.

Documentation

For user manual, system design and architecture, engineering blogs, refer to TDengine Documentation(中文版请点击这里) for details. The documentation from our website can also be downloaded locally from documentation/tdenginedocs-en or documentation/tdenginedocs-cn.

Building

At the moment, TDengine only supports building and running on Linux systems. You can choose to install from packages or from the source code. This quick guide is for installation from the source only.

To build TDengine, use CMake 3.0.2 or higher versions in the project directory.

Install build dependencies

Ubuntu 16.04 and above & Debian:

sudo apt-get install -y gcc cmake build-essential git

Ubuntu 14.04:

sudo apt-get install -y gcc cmake3 build-essential git binutils-2.26
export PATH=/usr/lib/binutils-2.26/bin:$PATH

To compile and package the JDBC driver source code, you should have a Java jdk-8 or higher and Apache Maven 2.7 or higher installed. To install openjdk-8:

sudo apt-get install -y openjdk-8-jdk

To install Apache Maven:

sudo apt-get install -y  maven

Install build dependencies for taos-tools

We provide a few useful tools such as taosBenchmark (was named taosdemo) and taosdump. They were part of TDengine. From TDengine 2.4.0.0, taosBenchmark and taosdump were not released together with TDengine. By default, TDengine compiling does not include taos-tools. You can use 'cmake .. -DBUILD_TOOLS=true' to make them be compiled with TDengine.

To build the taos-tools on Ubuntu/Debian, the following packages need to be installed.

sudo apt install libjansson-dev libsnappy-dev liblzma-dev libz-dev pkg-config

CentOS 7:

sudo yum install epel-release
sudo yum update
sudo yum install -y gcc gcc-c++ make cmake3 git
sudo ln -sf /usr/bin/cmake3 /usr/bin/cmake

To install openjdk-8:

sudo yum install -y java-1.8.0-openjdk

To install Apache Maven:

sudo yum install -y maven

CentOS 8 & Fedora:

sudo dnf install -y gcc gcc-c++ make cmake epel-release git

To install openjdk-8:

sudo dnf install -y java-1.8.0-openjdk

To install Apache Maven:

sudo dnf install -y maven

Install build dependencies for taos-tools

To build the taos-tools on CentOS, the following packages need to be installed.

sudo yum install zlib-devel xz-devel snappy-devel jansson-devel pkgconfig libatomic

Note: Since snappy lacks pkg-config support (refer to link), it lead a cmake prompt libsnappy not found. But snappy will works well.

Setup golang environment

TDengine includes few components developed by Go language. Please refer to golang.org official documentation for golang environment setup.

Please use version 1.14+. For the user in China, we recommend using a proxy to accelerate package downloading.

go env -w GO111MODULE=on
go env -w GOPROXY=https://goproxy.cn,direct

Get the source codes

First of all, you may clone the source codes from github:

git clone https://github.com/taosdata/TDengine.git
cd TDengine

The connectors for go & grafana and some tools have been moved to separated repositories, so you should run this command in the TDengine directory to install them:

git submodule update --init --recursive

You can modify the file ~/.gitconfig to use ssh protocol instead of https for better download speed. You need to upload ssh public key to GitHub first. Please refer to GitHub official documentation for detail.

[url "[email protected]:"]
    insteadOf = https://github.com/

Build TDengine

On Linux platform

mkdir debug && cd debug
cmake .. && cmake --build .

Note TDengine 2.3.x.0 and later use a component named 'taosAdapter' to play http daemon role by default instead of the http daemon embedded in the early version of TDengine. The taosAdapter is programmed by go language. If you pull TDengine source code to the latest from an existing codebase, please execute 'git submodule update --init --recursive' to pull taosAdapter source code. Please install go language version 1.14 or above for compiling taosAdapter. If you meet difficulties regarding 'go mod', especially you are from China, you can use a proxy to solve the problem.

go env -w GO111MODULE=on
go env -w GOPROXY=https://goproxy.cn,direct

The embedded http daemon still be built from TDengine source code by default. Or you can use the following command to choose to build taosAdapter.

cmake .. -DBUILD_HTTP=false

You can use Jemalloc as memory allocator instead of glibc:

apt install autoconf
cmake .. -DJEMALLOC_ENABLED=true

TDengine build script can detect the host machine's architecture on X86-64, X86, arm64, arm32 and mips64 platform. You can also specify CPUTYPE option like aarch64 or aarch32 too if the detection result is not correct:

aarch64:

cmake .. -DCPUTYPE=aarch64 && cmake --build .

aarch32:

cmake .. -DCPUTYPE=aarch32 && cmake --build .

mips64:

cmake .. -DCPUTYPE=mips64 && cmake --build .

On Windows platform

If you use the Visual Studio 2013, please open a command window by executing "cmd.exe". Please specify "amd64" for 64 bits Windows or specify "x86" is for 32 bits Windows when you execute vcvarsall.bat.

cmake .. -G "NMake Makefiles" nmake">

mkdir debug && cd debug
"C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\vcvarsall.bat" < amd64 | x86 >
cmake .. -G "NMake Makefiles"
nmake

If you use the Visual Studio 2019 or 2017:

please open a command window by executing "cmd.exe". Please specify "x64" for 64 bits Windows or specify "x86" is for 32 bits Windows when you execute vcvarsall.bat.

cmake .. -G "NMake Makefiles" nmake">

mkdir debug && cd debug
"c:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Auxiliary\Build\vcvarsall.bat" < x64 | x86 >
cmake .. -G "NMake Makefiles"
nmake

Or, you can simply open a command window by clicking Windows Start -> "Visual Studio < 2019 | 2017 >" folder -> "x64 Native Tools Command Prompt for VS < 2019 | 2017 >" or "x86 Native Tools Command Prompt for VS < 2019 | 2017 >" depends what architecture your Windows is, then execute commands as follows:

mkdir debug && cd debug
cmake .. -G "NMake Makefiles"
nmake

On Mac OS X platform

Please install XCode command line tools and cmake. Verified with XCode 11.4+ on Catalina and Big Sur.

mkdir debug && cd debug
cmake .. && cmake --build .

Installing

After building successfully, TDengine can be installed by: (On Windows platform, the following command should be nmake install)

sudo make install

Users can find more information about directories installed on the system in the directory and files section. Since version 2.0, installing from source code will also configure service management for TDengine. Users can also choose to install from packages for it.

To start the service after installation, in a terminal, use:

sudo systemctl start taosd

Then users can use the TDengine shell to connect the TDengine server. In a terminal, use:

taos

If TDengine shell connects the server successfully, welcome messages and version info are printed. Otherwise, an error message is shown.

Install TDengine by apt-get

If you use Debian or Ubuntu system, you can use 'apt-get' command to intall TDengine from official repository. Please use following commands to setup:

wget -qO - http://repos.taosdata.com/tdengine.key | sudo apt-key add -
echo "deb [arch=amd64] http://repos.taosdata.com/tdengine-stable stable main" | sudo tee /etc/apt/sources.list.d/tdengine-stable.list
[Optional] echo "deb [arch=amd64] http://repos.taosdata.com/tdengine-beta beta main" | sudo tee /etc/apt/sources.list.d/tdengine-beta.list
sudo apt-get update
apt-cache policy tdengine
sudo apt-get install tdengine

Quick Run

If you don't want to run TDengine as a service, you can run it in current shell. For example, to quickly start a TDengine server after building, run the command below in terminal: (We take Linux as an example, command on Windows will be taosd.exe)

./build/bin/taosd -c test/cfg

In another terminal, use the TDengine shell to connect the server:

./build/bin/taos -c test/cfg

option "-c test/cfg" specifies the system configuration file directory.

Try TDengine

It is easy to run SQL commands from TDengine shell which is the same as other SQL databases.

create database db;
use db;
create table t (ts timestamp, a int);
insert into t values ('2019-07-15 00:00:00', 1);
insert into t values ('2019-07-15 01:00:00', 2);
select * from t;
drop database db;

Developing with TDengine

Official Connectors

TDengine provides abundant developing tools for users to develop on TDengine. Follow the links below to find your desired connectors and relevant documentation.

Third Party Connectors

The TDengine community has also kindly built some of their own connectors! Follow the links below to find the source code for them.

How to run the test cases and how to add a new test case?

TDengine's test framework and all test cases are fully open source. Please refer to this document for how to run test and develop new test case.

TDengine Roadmap

Support event-driven stream computing
Support user defined functions
Support MQTT connection
Support OPC connection
Support Hadoop, Spark connections
Support Tableau and other BI tools

Contribute to TDengine

Please follow the contribution guidelines to contribute to the project.

Join TDengine WeChat Group

Add WeChat “tdengine” to join the group，you can communicate with other users.

User List

If you are using TDengine and feel it helps or you'd like to do some contributions, please add your company to user list and let us know your needs.

Issues

DB error: Unable to establish connection, when windows client(v2.0.5.1) connect to server

General Questions

基础环境

服务端：使用docker的TDEngine2.0.5.1镜像部署；运行在rancher2.1.13平台，目前6030-6041的UDP端口已开，其中6030/6035/6040是txp端口；客户端： Linux：配置了hostname与hosts后，使用2.0.5.1的客户端，可以正常访问； Windows：配置了hosts后，使用2.0.5.1客户端，切换数据库与数据库操作异常，显示DB error: Unable to establish connection。

服务端运行结果

客户端运行结果

客户端日志

taoslog.0.txt
help wanted question

opened by Maciue 42
利用jdbc demo创建表结构失败

Successfully executed: create table if not exists t48998 using mt tags(48998) Successfully executed: create table if not exists t48999 using mt tags(48999) java.sql.SQLException: TDengine Error: more dnodes are needed at com.taosdata.jdbc.TSDBJNIConnector.executeQuery(TSDBJNIConnector.java:130) at com.taosdata.jdbc.TSDBStatement.executeUpdate(TSDBStatement.java:69) at TSDBSyncSample.doCreateDbAndTable(TSDBSyncSample.java:117) at TSDBSyncSample.main(TSDBSyncSample.java:50) Failed to execute SQL: create table if not exists t49000 using mt tags(49000)
enhancement help wanted

opened by 59471032 29

TDengine ERROR (8000000b): Unable to establish connection

Bug Description 直接运行demo里面的mybatisplus-demo，TemperatureMapperTest.testSelectList，报错，建表语句正常执行，但是插入数据报错

To Reproduce Steps to reproduce the behavior: 直接运行demo

Expected Behavior 希望可以解决这个问题

Screenshots

2021-07-21 18:00:48.116 DEBUG 16276 --- [           main] c.t.e.m.m.T.dropSuperTable               : ==>  Preparing: drop table if exists temperature 
2021-07-21 18:00:48.130 DEBUG 16276 --- [           main] c.t.e.m.m.T.dropSuperTable               : ==> Parameters: 
2021-07-21 18:00:48.139 DEBUG 16276 --- [           main] c.t.e.m.m.T.dropSuperTable               : <==    Updates: 0
2021-07-21 18: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-21 18:00:48.141 DEBUG 16276 --- [           main] c.t.e.m.m.T.createSuperTable             : ==> Parameters: 
2021-07-21 18:00:48.161 DEBUG 16276 --- [           main] c.t.e.m.m.T.createSuperTable             : <==    Updates: 0
2021-07-21 18:00:48.163 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-21 18:00:48.164 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t0(String), 杭州(String), 0(Integer)
2021-07-21 18:00:48.226 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-21 18:00:48.227 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-21 18:00:48.228 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t1(String), 深圳(String), 1(Integer)
2021-07-21 18:00:48.242 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-21 18:00:48.243 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-21 18:00:48.243 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t2(String), 上海(String), 2(Integer)
2021-07-21 18:00:48.265 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-21 18:00:48.266 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-21 18:00:48.266 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t3(String), 上海(String), 3(Integer)
2021-07-21 18:00:48.286 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-21 18:00:48.287 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-21 18:00:48.287 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t4(String), 深圳(String), 4(Integer)
2021-07-21 18:00:48.301 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-21 18:00:48.302 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-21 18:00:48.302 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t5(String), 北京(String), 5(Integer)
2021-07-21 18:00:48.323 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-21 18:00:48.324 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-21 18:00:48.324 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t6(String), 杭州(String), 6(Integer)
2021-07-21 18:00:48.339 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-21 18:00:48.340 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-21 18:00:48.341 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t7(String), 深圳(String), 7(Integer)
2021-07-21 18:00:48.360 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-21 18:00:48.361 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-21 18:00:48.361 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t8(String), 深圳(String), 8(Integer)
2021-07-21 18:00:48.375 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-21 18:00:48.376 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==>  Preparing: create table ? using temperature tags( ?, ?) 
2021-07-21 18:00:48.376 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : ==> Parameters: t9(String), 北京(String), 9(Integer)
2021-07-21 18:00:48.403 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.createTable  : <==    Updates: 0
2021-07-21 18:00:48.423 DEBUG 16276 --- [           main] c.t.e.m.m.TemperatureMapper.insertOne    : ==>  Preparing: insert into t0(ts, temperature) values(?, ?) 
2021-07-21 18: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-21 18:00:57.045 DEBUG 16276 --- [           main] c.t.e.m.m.T.dropSuperTable               : ==>  Preparing: drop table if exists temperature 
2021-07-21 18:00:57.045 DEBUG 16276 --- [           main] c.t.e.m.m.T.dropSuperTable               : ==> Parameters: 
2021-07-21 18: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

Environment (please complete the following information):

OS: 服务端 ubuntu 20.02
Memory, CPU, current Disk Space 1CPU,4G
TDengine Version 服务端版本：2.1.3.2 taos-jdbcdriver版本：2.0.32

bug

opened by fengqiangboy 28

IDEA connect to TDengine failed

数据库出不来还报错错误信息： java.sql.SQLException: ERROR (2315): unknown taos type in tdengine at com.taosdata.jdbc.TSDBError.createSQLException(TSDBError.java:70) at com.taosdata.jdbc.TSDBError.createSQLException(TSDBError.java:57) at com.taosdata.jdbc.TSDBConstants.taosType2JdbcType(TSDBConstants.java:128) at com.taosdata.jdbc.TSDBResultSetMetaData.getColumnType(TSDBResultSetMetaData.java:154) in RemoteResultSetMetaDataImpl.getFixedColumnType(RemoteResultSetMetaDataImpl.java:105)
help wanted

opened by POPIWEN0209 24
Taosdemo.go reported "Unable to establish connection"

装机环境: TDEngine server: ubuntu TDEngine client： win10

运行Taosdemo.go时，能成功创建数据库和表，但执行插入数据时，报错“Unable to establish connection”。日志已附上。 taoslog.zip

从log中可以看到，在执行sql insert command的时候，是向“user-OptiPlex-3020:6030”发送消息（这是不对的，我并没有配置这个FQDN，这应该是导致这个问题的原因），而执行drop/create db操作时，是向“tdengine:6030”发送消息（tdengine是我配置的FQDN）。

FQDN已配置

opened by HedyLni 24
python package install was failed
I found two error when i was installed connector of python.

Error 1:

The error show installation path pip install src/connector/python/python3/ with documentation from link https://www.taosdata.com/en/documentation/connector/#Python-Connector .

But the actually path is pip install src/connector/python/windows/python3/ from github project.

Error 2:

The installation with python was failedwhen i use pip install that shows successfully installed.

But i use the command import taos, it shows error below.

help wanted
opened by Laurel-rao 24
Unable to establish connection by Windows Client to Linux Server

linux和windows都是用的最新版本2.0.2.1版本，Java客户使用的jar包版本2.0.4. 发布到linux服务器是没有问题的，但是在windows本地运行就是出现错误：TDengine Error: Unable to establish connection。

客户端本地日志：客户端日志.txt

服务端日志：服务端日志.txt

opened by zhangzl0119 22
jdbcTemplate+Hikari+taos-jdbcdriver2.0.7 DESCRIBE meters java.sql.SQLException: this operation is NOT supported currently!
Bug Description 使用jdbcTemplate执行sql “DESCRIBE meters”，报错 this operation is NOT supported currently!

Environment

jdbcTemplate+Hikari+taos-jdbcdriver2.0.7

TDengine Version [2.0.7]

异常堆栈 Caused by: org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [DESCRIBE meters]; SQL state [null]; error code [0]; this operation is NOT supported currently!; nested exception is java.sql.SQLException: this operation is NOT supported currently! at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1443) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:462) at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:490) at org.jetlinks.community.standalone.JetLinksApplication.lambda$run$0(JetLinksApplication.java:63) at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:786) ... 5 common frames omitted Caused by: java.sql.SQLException: this operation is NOT supported currently! at com.taosdata.jdbc.TSDBStatement.getWarnings(TSDBStatement.java:137) at com.zaxxer.hikari.pool.HikariProxyStatement.getWarnings(HikariProxyStatement.java) at org.springframework.jdbc.core.JdbcTemplate.handleWarnings(JdbcTemplate.java:1408) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:377) ... 10 common frames omitted
bug
opened by duanbt 21
V2.0.4.0 , client driver exception：tscUtil.c:427: tscFreeSqlObj: Assertion `ref >= 0' failed.

使用C#调研客户端驱动，秒级写入数据，运行一会儿后就报错，导致程序崩溃。 win10内异常如下：

Centos7中报错如下：

程序执行的插入语句类似这种： insert into th_ys_dd_scyx_func_cs using taghistory tags ('ys.dd.scyx_func-cs') values ('2020-09-30 14:51:20','0.25829825',1,'0.40759492') th_ys_dd_scyx_tag using taghistory tags ('ys.dd.scyx_tag') values ('2020-09-30 14:51:20','0.25829825',1,'0.40759492') th_ys_dd_scyx_var using taghistory tags ('ys.dd.scyx_var') values ('2020-09-30 14:51:20','0.411905',1,'0.40789968') th_ys_dd_scyx_func_s using taghistory tags ('ys.dd.scyx_func-s') values ('2020-09-30 14:51:20','25.829824',1,'40.75949')

超级表定义如下： create table if not exists TagHistory (time timestamp, Value binary(20), Qualitie TINYINT, PreValue binary(20)) tags (Tagid nchar(100))
bug

opened by rennner 21
v2.0.3，DB error: Unable to resolve FQDN when client connect to server in docker.
使用win10安装2.0.3 cli，centos7安装2.0.3版 docker image， docker run -d --name taos2.0 -v /home/docker/taos2.0:/var/lib/taos -p 6030-6042:6030-6042 -p 6030-6042:6030-6042/udp tdengine/tdengine

win10 cmd执行： taos -h centos7的ip show users
提示无法解析fqdn

确认防火墙已关闭。

new log file

================================================== 09/08 10:59:09.811000 0x00005098 UTL localEp is: DESKTOP-1VKVP30:6030 09/08 10:59:09.811000 0x00005098 UTL timezone not configured, use default 09/08 10:59:09.869000 0x00005098 UTL locale not configured, set to default:Chinese_China.936 09/08 10:59:09.869000 0x00005098 UTL charset not configured, set to default:cp936 09/08 10:59:09.869000 0x00005098 UTL taos config & system info: 09/08 10:59:09.869000 0x00005098 UTL ================================== 09/08 10:59:09.869000 0x00005098 UTL firstEp: DESKTOP-xxx:6030 09/08 10:59:09.869000 0x00005098 UTL secondEp: DESKTOP-xxx:6030 09/08 10:59:09.869000 0x00005098 UTL fqdn: DESKTOP-xxx 09/08 10:59:09.869000 0x00005098 UTL serverPort: 6030 09/08 10:59:09.869000 0x00005098 UTL configDir: C:/TDengine/cfg 09/08 10:59:09.869000 0x00005098 UTL logDir: C:/TDengine/log 09/08 10:59:09.869000 0x00005098 UTL scriptDir: C:/TDengine/script 09/08 10:59:09.869000 0x00005098 UTL arbitrator:
09/08 10:59:09.869000 0x00005098 UTL numOfThreadsPerCore: 1.000000 09/08 10:59:09.869000 0x00005098 UTL rpcTimer: 1000(ms) 09/08 10:59:09.869000 0x00005098 UTL rpcMaxTime: 600(s) 09/08 10:59:09.869000 0x00005098 UTL shellActivityTimer: 3(s) 09/08 10:59:09.869000 0x00005098 UTL tableMetaKeepTimer: 7200(s) 09/08 10:59:09.869000 0x00005098 UTL compressMsgSize: -1 09/08 10:59:09.869000 0x00005098 UTL maxSQLLength: 65480(byte) 09/08 10:59:09.869000 0x00005098 UTL maxNumOfOrderedRes: 100000 09/08 10:59:09.869000 0x00005098 UTL timezone: not configured 09/08 10:59:09.869000 0x00005098 UTL locale: Chinese_China.936 09/08 10:59:09.869000 0x00005098 UTL charset: cp936 09/08 10:59:09.869000 0x00005098 UTL numOfLogLines: 10000000 09/08 10:59:09.869000 0x00005098 UTL asyncLog: 1 09/08 10:59:09.869000 0x00005098 UTL debugFlag: 0 09/08 10:59:09.869000 0x00005098 UTL rpcDebugFlag: 131 09/08 10:59:09.869000 0x00005098 UTL tmrDebugFlag: 131 09/08 10:59:09.869000 0x00005098 UTL cDebugFlag: 131 09/08 10:59:09.869000 0x00005098 UTL jniDebugFlag: 131 09/08 10:59:09.869000 0x00005098 UTL odbcDebugFlag: 131 09/08 10:59:09.869000 0x00005098 UTL uDebugFlag: 131 09/08 10:59:09.869000 0x00005098 UTL qDebugFlag: 131 09/08 10:59:09.869000 0x00005098 UTL tsdbDebugFlag: 131 09/08 10:59:09.869000 0x00005098 UTL gitinfo: community 09/08 10:59:09.869000 0x00005098 UTL gitinfoOfInternal: internal 09/08 10:59:09.869000 0x00005098 UTL buildinfo: Built at 2020-09-05 22:14:00 09/08 10:59:09.869000 0x00005098 UTL version: 2.0.3.0 09/08 10:59:09.869000 0x00005098 UTL maxBinaryDisplayWidth: 30 09/08 10:59:13.640000 0x00003d48 UTL ERROR failed get the ip address, fqdn:06cbe93d9a0a, code:11001, reason:不知道这样的主机。 09/08 10:59:13.640000 0x00003d48 RPC ERROR TSC, failed to resolve FQDN:06cbe93d9a0a 09/08 10:59:13.640000 0x00003d48 RPC ERROR TSC 000001E6CEC18E20, failed to set up connection(Unable to resolve FQDN) 09/08 10:59:13.740000 0x000023d8 TSC ERROR 000001E6CEC1E300 add into queued async res, code:Syntax errr in SQL 09/08 10:59:17.400000 0x00003d48 UTL ERROR failed get the ip address, fqdn:06cbe93d9a0a, code:11001, reason:不知道这样的主机。 09/08 10:59:17.400000 0x00003d48 RPC ERROR TSC, failed to resolve FQDN:06cbe93d9a0a 09/08 10:59:17.400000 0x00003d48 RPC ERROR TSC 000001E6CEC18E20, failed to set up connection(Unable to resolve FQDN)
help wanted question
opened by rennner 21
TDengine Error: more dnodes are needed

create到第49000个表的时候报错 TDengine Error: more dnodes are needed

空间充足

另一个问题我也看了, 我vim /etc/taos/taos.cfg 看了有什么配置可以改的改了长得像的 maxTables ,没有用请问该改什么配置? 只能加核吗我们大概需要二百个表(二百万个设备)
help wanted question

opened by hiei17 20
Unable to start the taosd service

taos启动报错，无法连接 虚拟机崩溃，虚拟机回滚后，启动taos报错：ERROR failed to lock file:/root/data/dnode/.running ret:-1[Resource temporarily unavailable], database may be running, quit 详细sudo ./taosd 启动日志： 06/25 13:56:15.589227 00092429 DND start to initialize TDengine 06/25 13:56:15.589484 00092429 DND step:dnode-tfile is initialized 06/25 13:56:15.589518 00092429 DND step:dnode-rpc is initialized 06/25 13:56:15.589538 00092429 UTL localEp is: tdengine01:6030 06/25 13:56:15.592408 00092429 UTL WARN timezone not configured, set to system default: (CST, +0800) 06/25 13:56:15.592533 00092429 UTL WARN locale not configured, set to system default:en_US.UTF-8 06/25 13:56:15.592568 00092429 UTL WARN charset not configured, set to system default:UTF-8 06/25 13:56:15.592638 00092429 UTL check global cfg completed 06/25 13:56:15.592655 00092429 UTL ================================== 06/25 13:56:15.592665 00092429 UTL config & system info: 06/25 13:56:15.592673 00092429 UTL ================================== 06/25 13:56:15.592682 00092429 UTL firstEp: tdengine01:6030 06/25 13:56:15.592690 00092429 UTL secondEp: tdengine01:6030 06/25 13:56:15.592698 00092429 UTL fqdn: tdengine01 06/25 13:56:15.592706 00092429 UTL serverPort: 6030 06/25 13:56:15.592714 00092429 UTL configDir: /etc/taos 06/25 13:56:15.592722 00092429 UTL logDir: /var/log/taos 06/25 13:56:15.592729 00092429 UTL scriptDir: /etc/taos 06/25 13:56:15.592738 00092429 UTL arbitrator:
06/25 13:56:15.592746 00092429 UTL numOfThreadsPerCore: 1.000000 06/25 13:56:15.592770 00092429 UTL numOfCommitThreads: 4 06/25 13:56:15.592795 00092429 UTL ratioOfQueryCores: 1.000000 06/25 13:56:15.592806 00092429 UTL maxNumOfDistinctRes: 10000000 06/25 13:56:15.592814 00092429 UTL numOfMnodes: 3 06/25 13:56:15.592822 00092429 UTL vnodeBak: 1 06/25 13:56:15.592830 00092429 UTL telemetryReporting: 1 06/25 13:56:15.592838 00092429 UTL balance: 1 06/25 13:56:15.592846 00092429 UTL balanceInterval: 300 06/25 13:56:15.592853 00092429 UTL role: 0 06/25 13:56:15.592861 00092429 UTL maxTmrCtrl: 512 06/25 13:56:15.592869 00092429 UTL monitorInterval: 30(s) 06/25 13:56:15.592877 00092429 UTL offlineThreshold: 864000(s) 06/25 13:56:15.592885 00092429 UTL rpcTimer: 300(ms) 06/25 13:56:15.592893 00092429 UTL rpcMaxTime: 600(s) 06/25 13:56:15.592947 00092429 UTL rpcForceTcp: 0 06/25 13:56:15.592964 00092429 UTL statusInterval: 1(s) 06/25 13:56:15.592973 00092429 UTL shellActivityTimer: 3(s) 06/25 13:56:15.592981 00092429 UTL minSlidingTime: 10(ms) 06/25 13:56:15.592989 00092429 UTL minIntervalTime: 1(ms) 06/25 13:56:15.592996 00092429 UTL maxStreamCompDelay: 20000(ms) 06/25 13:56:15.593004 00092429 UTL maxFirstStreamCompDelay:10000(ms) 06/25 13:56:15.593012 00092429 UTL retryStreamCompDelay: 10000(ms) 06/25 13:56:15.593019 00092429 UTL streamCompDelayRatio: 0.100000 06/25 13:56:15.593031 00092429 UTL maxVgroupsPerDb: 0 06/25 13:56:15.593038 00092429 UTL maxTablesPerVnode: 1000000 06/25 13:56:15.593046 00092429 UTL minTablesPerVnode: 1000 06/25 13:56:15.593054 00092429 UTL tableIncStepPerVnode: 1000 06/25 13:56:15.593062 00092429 UTL cache: 16(Mb) 06/25 13:56:15.593070 00092429 UTL blocks: 6 06/25 13:56:15.593077 00092429 UTL days: 10 06/25 13:56:15.593085 00092429 UTL keep: 3650 06/25 13:56:15.593093 00092429 UTL minRows: 100 06/25 13:56:15.593101 00092429 UTL maxRows: 4096 06/25 13:56:15.593109 00092429 UTL precision: 0 06/25 13:56:15.593116 00092429 UTL comp: 2 06/25 13:56:15.593124 00092429 UTL walLevel: 1 06/25 13:56:15.593131 00092429 UTL fsync: 3000 06/25 13:56:15.593139 00092429 UTL replica: 1 06/25 13:56:15.593147 00092429 UTL partitions: 4 06/25 13:56:15.593154 00092429 UTL quorum: 1 06/25 13:56:15.593170 00092429 UTL update: 0 06/25 13:56:15.593179 00092429 UTL cachelast: 0 06/25 13:56:15.593186 00092429 UTL compressMsgSize: 524288 06/25 13:56:15.593194 00092429 UTL maxSQLLength: 1048576(byte) 06/25 13:56:15.593201 00092429 UTL maxWildCardsLength: 100(byte) 06/25 13:56:15.593209 00092429 UTL maxNumOfOrderedRes: 1000000 06/25 13:56:15.593217 00092429 UTL queryBufferSize: -1(byte) 06/25 13:56:15.593225 00092429 UTL retrieveBlockingModel: 0 06/25 13:56:15.593233 00092429 UTL keepColumnName: 0 06/25 13:56:15.593240 00092429 UTL timezone: (CST, +0800) 06/25 13:56:15.593249 00092429 UTL locale: en_US.UTF-8 06/25 13:56:15.593256 00092429 UTL charset: UTF-8 06/25 13:56:15.593264 00092429 UTL maxShellConns: 50000 06/25 13:56:15.593272 00092429 UTL maxConnections: 5000 06/25 13:56:15.593279 00092429 UTL minimalLogDirGB: 1.000000(GB) 06/25 13:56:15.593288 00092429 UTL minimalTmpDirGB: 1.000000(GB) 06/25 13:56:15.593297 00092429 UTL minimalDataDirGB: 2.000000(GB) 06/25 13:56:15.593306 00092429 UTL mnodeEqualVnodeNum: 4 06/25 13:56:15.593313 00092429 UTL flowctrl: 1 06/25 13:56:15.593320 00092429 UTL slaveQuery: 1 06/25 13:56:15.593328 00092429 UTL adjustMaster: 1 06/25 13:56:15.593336 00092429 UTL http: 1 06/25 13:56:15.593349 00092429 UTL mqtt: 0 06/25 13:56:15.593358 00092429 UTL monitor: 1 06/25 13:56:15.593365 00092429 UTL stream: 1 06/25 13:56:15.593373 00092429 UTL topicBinaryLen: 16000 06/25 13:56:15.593380 00092429 UTL httpEnableRecordSql: 0 06/25 13:56:15.593388 00092429 UTL telegrafUseFieldNum: 0 06/25 13:56:15.593396 00092429 UTL httpMaxThreads: 4 06/25 13:56:15.593403 00092429 UTL restfulRowLimit: 10240 06/25 13:56:15.593411 00092429 UTL httpDbNameMandatory: 0 06/25 13:56:15.593419 00092429 UTL httpKeepAlive: 30000 06/25 13:56:15.593427 00092429 UTL numOfLogLines: 10000000 06/25 13:56:15.593435 00092429 UTL logKeepDays: 0 06/25 13:56:15.593442 00092429 UTL asyncLog: 1 06/25 13:56:15.593450 00092429 UTL debugFlag: 0 06/25 13:56:15.593457 00092429 UTL mDebugFlag: 131 06/25 13:56:15.593465 00092429 UTL dDebugFlag: 135 06/25 13:56:15.593473 00092429 UTL sDebugFlag: 135 06/25 13:56:15.593556 00092429 UTL wDebugFlag: 135 06/25 13:56:15.593578 00092429 UTL sdbDebugFlag: 131 06/25 13:56:15.593592 00092429 UTL rpcDebugFlag: 131 06/25 13:56:15.593607 00092429 UTL tmrDebugFlag: 131 06/25 13:56:15.593620 00092429 UTL cDebugFlag: 131 06/25 13:56:15.593634 00092429 UTL jniDebugFlag: 131 06/25 13:56:15.593647 00092429 UTL odbcDebugFlag: 131 06/25 13:56:15.593661 00092429 UTL uDebugFlag: 131 06/25 13:56:15.593675 00092429 UTL httpDebugFlag: 131 06/25 13:56:15.593689 00092429 UTL mqttDebugFlag: 131 06/25 13:56:15.593703 00092429 UTL monDebugFlag: 131 06/25 13:56:15.593717 00092429 UTL qDebugFlag: 131 06/25 13:56:15.593730 00092429 UTL vDebugFlag: 135 06/25 13:56:15.593744 00092429 UTL tsdbDebugFlag: 131 06/25 13:56:15.593757 00092429 UTL cqDebugFlag: 131 06/25 13:56:15.593771 00092429 UTL enableRecordSql: 0 06/25 13:56:15.593785 00092429 UTL enableCoreFile: 0 06/25 13:56:15.593799 00092429 UTL gitinfo: 238545f71370b3b75db5ba653b2f06fa81faa894 06/25 13:56:15.593814 00092429 UTL gitinfoOfInternal: NULL 06/25 13:56:15.593827 00092429 UTL buildinfo: Built at 2021-12-16 16:23 06/25 13:56:15.593841 00092429 UTL version: 2.2.2.10 06/25 13:56:15.593855 00092429 UTL maxBinaryDisplayWidth: 30 06/25 13:56:15.593870 00092429 UTL tempDir: /tmp/ 06/25 13:56:15.593891 00092429 UTL clientMerge: 0 06/25 13:56:15.593905 00092429 UTL deadLockKillQuery: 1 06/25 13:56:15.593922 00092429 UTL os pageSize: 4096(KB) 06/25 13:56:15.593937 00092429 UTL os openMax: 1024 06/25 13:56:15.593951 00092429 UTL os streamMax: 16 06/25 13:56:15.593965 00092429 UTL os numOfCores: 8 06/25 13:56:15.593978 00092429 UTL os totalMemory: 21019(MB) 06/25 13:56:15.593997 00092429 UTL os sysname: Linux 06/25 13:56:15.594011 00092429 UTL os nodename: tdengine01 06/25 13:56:15.594025 00092429 UTL os release: 3.10.0-1127.el7.x86_64 06/25 13:56:15.594039 00092429 UTL os version: #1 SMP Tue Mar 31 23:36:51 UTC 2020 06/25 13:56:15.594054 00092429 UTL os machine: x86_64 06/25 13:56:15.594069 00092429 UTL dataDir: /root/data 06/25 13:56:15.594084 00092429 UTL ================================== 06/25 13:56:15.594146 00092429 DND step:dnode-globalcfg is initialized 06/25 13:56:15.594246 00092429 TFS disk /root/data is mounted to tier level 0 id 0 06/25 13:56:15.594376 00092429 UTL ================================== 06/25 13:56:15.594431 00092429 UTL os totalDisk: 50.120117(GB) 06/25 13:56:15.594448 00092429 UTL os usedDisk: 37.829266(GB) 06/25 13:56:15.594457 00092429 UTL os availDisk: 12.290852(GB) 06/25 13:56:15.594465 00092429 UTL ================================== 06/25 13:56:15.594480 00092429 DND dnode storage is initialized at /root/data/dnode 06/25 13:56:15.594489 00092429 DND step:dnode-storage is initialized 06/25 13:56:15.594559 00092429 DND read file /root/data/dnode/dnodeCfg.json successed 06/25 13:56:15.594594 00092429 DND dnodeId is set to 3, clusterId is set to 2895feea-c410-4237-adaf-01c91ce21619 06/25 13:56:15.596974 00092429 DND successed to write /root/data/dnode/dnodeCfg.json 06/25 13:56:15.597031 00092429 DND dnode cfg is initialized 06/25 13:56:15.597043 00092429 DND step:dnode-cfg is initialized 06/25 13:56:15.597189 00092429 DND read file /root/data/dnode/dnodeEps.json successed 06/25 13:56:15.597273 00092429 DND dnode eps is initialized 06/25 13:56:15.597284 00092429 DND step:dnode-eps is initialized 06/25 13:56:15.597346 00092429 DND read file /root/data/dnode/mnodeEpSet.json successed 06/25 13:56:15.597359 00092429 DND print minfos, mnodeNum:3 inUse:0 06/25 13:56:15.597367 00092429 DND mnode index:1, tdengine01:6030 06/25 13:56:15.597373 00092429 DND mnode index:4, rabbitmq-node1:6030 06/25 13:56:15.597379 00092429 DND mnode index:2, tdengine02:6030 06/25 13:56:15.597408 00092429 DND print minfos, mnodeNum:3 inUse:0 06/25 13:56:15.597425 00092429 DND mnode index:1, tdengine01:6030 06/25 13:56:15.597432 00092429 DND mnode index:4, rabbitmq-node1:6030 06/25 13:56:15.597439 00092429 DND mnode index:2, tdengine02:6030 06/25 13:56:15.597445 00092429 DND dnode minfos is initialized 06/25 13:56:15.597452 00092429 DND step:dnode-minfos is initialized 06/25 13:56:15.597530 00092429 WAL wal module is initialized, rsetId:3 06/25 13:56:15.597541 00092429 DND step:dnode-wal is initialized 06/25 13:56:15.597671 00092429 DND step:dnode-sync is initialized 06/25 13:56:15.597832 00092429 DND dnode check is initialized 06/25 13:56:15.597856 00092429 DND step:dnode-check is initialized 06/25 13:56:15.597873 00092429 UTL worker:vquery is initialized, min:8 max:8 06/25 13:56:15.597886 00092429 UTL worker:vfetch is initialized, min:4 max:4 06/25 13:56:15.597894 00092429 DND step:dnode-vread is initialized 06/25 13:56:15.597903 00092429 DND dnode vwrite is initialized, max worker 8 06/25 13:56:15.597910 00092429 DND step:dnode-vwrite is initialized 06/25 13:56:15.597976 00092429 DND step:vnode-backup is initialized 06/25 13:56:15.598028 00092429 DND step:vnode-worker is initialized 06/25 13:56:15.598042 00092429 DND step:vnode-write is initialized 06/25 13:56:15.598052 00092429 DND step:vnode-read is initialized 06/25 13:56:15.598062 00092429 DND step:vnode-hash is initialized 06/25 13:56:15.598184 00092429 DND step:tsdb-queue is initialized 06/25 13:56:15.598202 00092429 UTL worker:vmgmt is initialized, min:1 max:1 06/25 13:56:15.598926 00092429 DND dnode vmgmt is initialized 06/25 13:56:15.599082 00092429 DND step:dnode-vmgmt is initialized 06/25 13:56:15.599157 00092429 DND step:dnode-mread is initialized 06/25 13:56:15.599206 00092429 DND step:dnode-mwrite is initialized 06/25 13:56:15.599228 00092429 DND step:dnode-mpeer is initialized 06/25 13:56:15.607176 00092429 DND dnode inter-dnodes rpc client is initialized 06/25 13:56:15.607318 00092429 DND step:dnode-client is initialized 06/25 13:56:15.608300 00092429 DND dnode inter-dnodes RPC server is initialized 06/25 13:56:15.613039 00092429 DND step:dnode-server is initialized 06/25 13:56:15.613175 00092429 DND start 8 threads to open 21 vnodes 06/25 13:56:15.651690 00092449 VND vgId:12, load vnode cfg successfully, replcia:3 06/25 13:56:15.656449 00092449 VND vgId:12, dnode:4, rabbitmq-node1:6040 06/25 13:56:15.656470 00092449 VND vgId:12, dnode:3, tdengine02:6040 06/25 13:56:15.656479 00092449 VND vgId:12, dnode:1, tdengine01:6040 06/25 13:56:15.650298 00092450 VND vgId:13, load vnode cfg successfully, replcia:3 06/25 13:56:15.657424 00092450 VND vgId:13, dnode:1, tdengine01:6040 06/25 13:56:15.657443 00092450 VND vgId:13, dnode:3, tdengine02:6040 06/25 13:56:15.657452 00092450 VND vgId:13, dnode:4, rabbitmq-node1:6040 06/25 13:56:15.661492 00092447 VND vgId:10, load vnode cfg successfully, replcia:3 06/25 13:56:15.661986 00092447 VND vgId:10, dnode:4, rabbitmq-node1:6040 06/25 13:56:15.662005 00092447 VND vgId:10, dnode:3, tdengine02:6040 06/25 13:56:15.662013 00092447 VND vgId:10, dnode:1, tdengine01:6040 06/25 13:56:15.661009 00092448 VND vgId:11, load vnode cfg successfully, replcia:3 06/25 13:56:15.662090 00092448 VND vgId:11, dnode:1, tdengine01:6040 06/25 13:56:15.663061 00092448 VND vgId:11, dnode:3, tdengine02:6040 06/25 13:56:15.663081 00092448 VND vgId:11, dnode:4, rabbitmq-node1:6040 06/25 13:56:15.675466 00092449 VND vgId:12, read /root/data/vnode/vnode12/version.json successfully, fver:48049323 06/25 13:56:15.675588 00092448 VND vgId:11, read /root/data/vnode/vnode11/version.json successfully, fver:17496556 06/25 13:56:15.675621 00092447 VND vgId:10, read /root/data/vnode/vnode10/version.json successfully, fver:30760689 06/25 13:56:15.676510 00092450 VND vgId:13, read /root/data/vnode/vnode13/version.json successfully, fver:327809459 06/25 13:56:15.679527 00092452 VND vgId:15, load vnode cfg successfully, replcia:3 06/25 13:56:15.684346 00092452 VND vgId:15, dnode:1, tdengine01:6040 06/25 13:56:15.684363 00092452 VND vgId:15, dnode:3, tdengine02:6040 06/25 13:56:15.684371 00092452 VND vgId:15, dnode:4, rabbitmq-node1:6040 06/25 13:56:15.680241 00092451 VND vgId:14, load vnode cfg successfully, replcia:3 06/25 13:56:15.685149 00092451 VND vgId:14, dnode:3, tdengine02:6040 06/25 13:56:15.685166 00092451 VND vgId:14, dnode:4, rabbitmq-node1:6040 06/25 13:56:15.685174 00092451 VND vgId:14, dnode:1, tdengine01:6040 06/25 13:56:15.683314 00092454 VND vgId:17, load vnode cfg successfully, replcia:3 06/25 13:56:15.688727 00092454 VND vgId:17, dnode:1, tdengine01:6040 06/25 13:56:15.688771 00092454 VND vgId:17, dnode:3, tdengine02:6040 06/25 13:56:15.688780 00092454 VND vgId:17, dnode:4, rabbitmq-node1:6040 06/25 13:56:15.689240 00092451 VND vgId:14, read /root/data/vnode/vnode14/version.json successfully, fver:258963107 06/25 13:56:15.689249 00092452 VND vgId:15, read /root/data/vnode/vnode15/version.json successfully, fver:22377513 06/25 13:56:15.692600 00092454 VND vgId:17, read /root/data/vnode/vnode17/version.json successfully, fver:6511388 06/25 13:56:15.698577 00092453 VND vgId:16, load vnode cfg successfully, replcia:3 06/25 13:56:15.707684 00092453 VND vgId:16, dnode:4, rabbitmq-node1:6040 06/25 13:56:15.707710 00092453 VND vgId:16, dnode:3, tdengine02:6040 06/25 13:56:15.707720 00092453 VND vgId:16, dnode:1, tdengine01:6040 06/25 13:56:15.711108 00092453 VND vgId:16, read /root/data/vnode/vnode16/version.json successfully, fver:12053582 06/25 13:56:16.291358 00092454 VND vgId:17, sync role changed from offline to unsynced 06/25 13:56:16.291422 00092454 QRY vgId:17, set querymgmt reopen 06/25 13:56:16.293540 00092454 VND vgId:4, load vnode cfg successfully, replcia:3 06/25 13:56:16.293711 00092454 VND vgId:4, dnode:4, rabbitmq-node1:6040 06/25 13:56:16.293725 00092454 VND vgId:4, dnode:3, tdengine02:6040 06/25 13:56:16.293733 00092454 VND vgId:4, dnode:1, tdengine01:6040 06/25 13:56:16.294464 00092454 VND vgId:4, read /root/data/vnode/vnode4/version.json successfully, fver:230507923 06/25 13:56:16.390018 00092453 VND vgId:16, sync role changed from offline to unsynced 06/25 13:56:16.390097 00092453 QRY vgId:16, set querymgmt reopen 06/25 13:56:16.398871 00092453 VND vgId:3, load vnode cfg successfully, replcia:3 06/25 13:56:16.398927 00092453 VND vgId:3, dnode:3, tdengine02:6040 06/25 13:56:16.398938 00092453 VND vgId:3, dnode:1, tdengine01:6040 06/25 13:56:16.398945 00092453 VND vgId:3, dnode:4, rabbitmq-node1:6040 06/25 13:56:16.402528 00092453 VND vgId:3, read /root/data/vnode/vnode3/version.json successfully, fver:2 06/25 13:56:16.402950 00092452 VND vgId:15, sync role changed from offline to unsynced 06/25 13:56:16.403001 00092452 QRY vgId:15, set querymgmt reopen 06/25 13:56:16.412389 00092452 VND vgId:29, load vnode cfg successfully, replcia:1 06/25 13:56:16.412451 00092452 VND vgId:29, dnode:3, tdengine02:6040 06/25 13:56:16.416653 00092452 VND ERROR vgId:29, failed to read /root/data/vnode/vnode29/version.json, content is null 06/25 13:56:16.418593 00092452 VND ERROR vgId:29, failed to read file version, generate it from data file 06/25 13:56:16.517695 00092453 VND vgId:3, sync role changed from offline to unsynced 06/25 13:56:16.517755 00092453 QRY vgId:3, set querymgmt reopen 06/25 13:56:16.541004 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:16.558980 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:16.562590 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:16.664595 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:16.738239 00092447 VND vgId:10, sync role changed from offline to unsynced 06/25 13:56:16.738361 00092447 QRY vgId:10, set querymgmt reopen 06/25 13:56:16.738570 00092447 VND vgId:18, load vnode cfg successfully, replcia:3 06/25 13:56:16.740404 00092447 VND vgId:18, dnode:3, tdengine02:6040 06/25 13:56:16.740442 00092447 VND vgId:18, dnode:4, rabbitmq-node1:6040 06/25 13:56:16.740457 00092447 VND vgId:18, dnode:1, tdengine01:6040 06/25 13:56:16.740530 00092447 VND vgId:18, read /root/data/vnode/vnode18/version.json successfully, fver:3493334 06/25 13:56:16.760680 00092450 VND vgId:13, sync role changed from offline to unsynced 06/25 13:56:16.760830 00092450 QRY vgId:13, set querymgmt reopen 06/25 13:56:16.777768 00092450 VND vgId:23, load vnode cfg successfully, replcia:1 06/25 13:56:16.777923 00092450 VND vgId:23, dnode:3, tdengine02:6040 06/25 13:56:16.779011 00092450 VND ERROR vgId:23, failed to read /root/data/vnode/vnode23/version.json, content is null 06/25 13:56:16.781568 00092450 VND ERROR vgId:23, failed to read file version, generate it from data file 06/25 13:56:16.857970 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:16.861130 00092449 VND vgId:12, sync role changed from offline to unsynced 06/25 13:56:16.861212 00092449 QRY vgId:12, set querymgmt reopen 06/25 13:56:16.874918 00092449 VND vgId:20, load vnode cfg successfully, replcia:1 06/25 13:56:16.874986 00092449 VND vgId:20, dnode:3, tdengine02:6040 06/25 13:56:16.875031 00092449 VND ERROR vgId:20, failed to read /root/data/vnode/vnode20/version.json, content is null 06/25 13:56:16.875052 00092449 VND ERROR vgId:20, failed to read file version, generate it from data file 06/25 13:56:16.883527 00092451 VND vgId:14, sync role changed from offline to unsynced 06/25 13:56:16.883685 00092451 QRY vgId:14, set querymgmt reopen 06/25 13:56:16.897810 00092451 VND vgId:26, load vnode cfg successfully, replcia:1 06/25 13:56:16.897880 00092451 VND vgId:26, dnode:3, tdengine02:6040 06/25 13:56:16.897934 00092451 VND ERROR vgId:26, failed to read /root/data/vnode/vnode26/version.json, content is null 06/25 13:56:16.897958 00092451 VND ERROR vgId:26, failed to read file version, generate it from data file 06/25 13:56:16.902022 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:16.991102 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:16.995761 00092448 VND vgId:11, sync role changed from offline to unsynced 06/25 13:56:16.995855 00092448 QRY vgId:11, set querymgmt reopen 06/25 13:56:17.009425 00092448 VND vgId:19, load vnode cfg successfully, replcia:3 06/25 13:56:17.009489 00092448 VND vgId:19, dnode:1, tdengine01:6040 06/25 13:56:17.009499 00092448 VND vgId:19, dnode:3, tdengine02:6040 06/25 13:56:17.009507 00092448 VND vgId:19, dnode:4, rabbitmq-node1:6040 06/25 13:56:17.011089 00092448 VND vgId:19, read /root/data/vnode/vnode19/version.json successfully, fver:9798238 06/25 13:56:17.030704 00092454 VND vgId:4, sync role changed from offline to unsynced 06/25 13:56:17.030872 00092454 QRY vgId:4, set querymgmt reopen 06/25 13:56:17.035001 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:17.127497 00092447 VND vgId:18, sync role changed from offline to unsynced 06/25 13:56:17.127678 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:17.127732 00092447 QRY vgId:18, set querymgmt reopen 06/25 13:56:17.142317 00092447 VND vgId:5, load vnode cfg successfully, replcia:3 06/25 13:56:17.142386 00092447 VND vgId:5, dnode:3, tdengine02:6040 06/25 13:56:17.142397 00092447 VND vgId:5, dnode:4, rabbitmq-node1:6040 06/25 13:56:17.142405 00092447 VND vgId:5, dnode:1, tdengine01:6040 06/25 13:56:17.143257 00092447 VND vgId:5, read /root/data/vnode/vnode5/version.json successfully, fver:209547396 06/25 13:56:17.188532 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:17.321521 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:17.432026 00092448 VND vgId:19, sync role changed from offline to unsynced 06/25 13:56:17.432109 00092448 QRY vgId:19, set querymgmt reopen 06/25 13:56:17.440107 00092448 VND vgId:6, load vnode cfg successfully, replcia:3 06/25 13:56:17.440221 00092448 VND vgId:6, dnode:3, tdengine02:6040 06/25 13:56:17.440238 00092448 VND vgId:6, dnode:4, rabbitmq-node1:6040 06/25 13:56:17.440246 00092448 VND vgId:6, dnode:1, tdengine01:6040 06/25 13:56:17.440711 00092448 VND vgId:6, read /root/data/vnode/vnode6/version.json successfully, fver:245484275 06/25 13:56:17.551062 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:17.566316 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:17.575453 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:17.631742 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:17.682041 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:17.797513 00092452 VND ERROR vgId:29, failed to open sync, replica:1 reason:Invalid Sync Configuration 06/25 13:56:17.798208 00092452 QRY vgId:29, set querymgmt closed, wait for all queries cancelled 06/25 13:56:17.798676 00092452 DND ERROR vgId:29, failed to open vnode by thread:5 06/25 13:56:17.813524 00092447 VND vgId:5, sync role changed from offline to unsynced 06/25 13:56:17.813633 00092447 QRY vgId:5, set querymgmt reopen 06/25 13:56:17.841524 00092451 VND ERROR vgId:26, failed to open sync, replica:1 reason:Invalid Sync Configuration 06/25 13:56:17.841625 00092451 QRY vgId:26, set querymgmt closed, wait for all queries cancelled 06/25 13:56:17.841656 00092451 DND ERROR vgId:26, failed to open vnode by thread:4 06/25 13:56:17.841870 00092451 VND vgId:9, load vnode cfg successfully, replcia:3 06/25 13:56:17.841904 00092451 VND vgId:9, dnode:1, tdengine01:6040 06/25 13:56:17.841919 00092451 VND vgId:9, dnode:3, tdengine02:6040 06/25 13:56:17.841932 00092451 VND vgId:9, dnode:4, rabbitmq-node1:6040 06/25 13:56:17.841976 00092451 VND vgId:9, read /root/data/vnode/vnode9/version.json successfully, fver:33796033 06/25 13:56:17.847305 00092448 VND vgId:6, sync role changed from offline to unsynced 06/25 13:56:17.847423 00092448 QRY vgId:6, set querymgmt reopen 06/25 13:56:17.863063 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:17.873655 00092450 VND ERROR vgId:23, failed to open sync, replica:1 reason:Invalid Sync Configuration 06/25 13:56:17.873761 00092450 QRY vgId:23, set querymgmt closed, wait for all queries cancelled 06/25 13:56:17.873792 00092450 DND ERROR vgId:23, failed to open vnode by thread:3 06/25 13:56:17.873975 00092450 VND vgId:8, load vnode cfg successfully, replcia:3 06/25 13:56:17.874009 00092450 VND vgId:8, dnode:4, rabbitmq-node1:6040 06/25 13:56:17.874025 00092450 VND vgId:8, dnode:3, tdengine02:6040 06/25 13:56:17.874038 00092450 VND vgId:8, dnode:1, tdengine01:6040 06/25 13:56:17.874082 00092450 VND vgId:8, read /root/data/vnode/vnode8/version.json successfully, fver:153299521 06/25 13:56:17.914819 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:17.966089 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:17.975555 00092449 VND ERROR vgId:20, failed to open sync, replica:1 reason:Invalid Sync Configuration 06/25 13:56:17.975672 00092449 QRY vgId:20, set querymgmt closed, wait for all queries cancelled 06/25 13:56:17.975703 00092449 DND ERROR vgId:20, failed to open vnode by thread:2 06/25 13:56:17.975894 00092449 VND vgId:7, load vnode cfg successfully, replcia:3 06/25 13:56:17.975926 00092449 VND vgId:7, dnode:4, rabbitmq-node1:6040 06/25 13:56:17.975941 00092449 VND vgId:7, dnode:3, tdengine02:6040 06/25 13:56:17.975955 00092449 VND vgId:7, dnode:1, tdengine01:6040 06/25 13:56:17.975999 00092449 VND vgId:7, read /root/data/vnode/vnode7/version.json successfully, fver:259085902 06/25 13:56:17.982164 00092451 VND vgId:9, sync role changed from offline to unsynced 06/25 13:56:17.982266 00092451 QRY vgId:9, set querymgmt reopen 06/25 13:56:17.994052 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:18.018359 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:18.041643 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:18.099977 00092449 VND vgId:7, sync role changed from offline to unsynced 06/25 13:56:18.100230 00092449 QRY vgId:7, set querymgmt reopen 06/25 13:56:18.134807 00092450 VND vgId:8, sync role changed from offline to unsynced 06/25 13:56:18.135903 00092450 QRY vgId:8, set querymgmt reopen 06/25 13:56:18.136173 00092429 DND there are total vnodes:21, opened:17 06/25 13:56:18.136219 00092429 DND ERROR there are total vnodes:21, failed:4 06/25 13:56:18.136274 00092429 QRY vgId:3, set querymgmt closed, wait for all queries cancelled 06/25 13:56:18.136373 00092429 QRY vgId:4, set querymgmt closed, wait for all queries cancelled 06/25 13:56:18.136469 00092429 QRY vgId:5, set querymgmt closed, wait for all queries cancelled 06/25 13:56:18.136566 00092429 QRY vgId:6, set querymgmt closed, wait for all queries cancelled 06/25 13:56:18.136621 00092430 UTL ERROR failed to connect socket, ip:0x33e8a8c0, port:6040(connect host error) 06/25 13:56:18.136727 00092429 QRY vgId:7, set querymgmt closed, wait for all queries cancelled 06/25 13:56:18.136816 00092429 QRY vgId:8, set querymgmt closed, wait for all queries cancelled 06/25 13:56:18.136886 00092429 QRY vgId:9, set querymgmt closed, wait for all queries cancelled 06/25 13:56:18.136957 00092429 QRY vgId:10, set querymgmt closed, wait for all queries cancelled 06/25 13:56:18.137038 00092429 QRY vgId:11, set querymgmt closed, wait for all queries cancelled 06/25 13:56:18.137109 00092429 QRY vgId:12, set querymgmt closed, wait for all queries cancelled 06/25 13:56:18.137182 00092429 QRY vgId:13, set querymgmt closed, wait for all queries cancelled 06/25 13:56:18.137305 00092429 QRY vgId:14, set querymgmt closed, wait for all queries cancelled 06/25 13:56:18.137398 00092429 QRY vgId:15, set querymgmt closed, wait for all queries cancelled 06/25 13:56:18.137474 00092429 QRY vgId:16, set querymgmt closed, wait for all queries cancelled 06/25 13:56:18.137554 00092429 QRY vgId:17, set querymgmt closed, wait for all queries cancelled 06/25 13:56:18.137626 00092429 QRY vgId:18, set querymgmt closed, wait for all queries cancelled 06/25 13:56:18.137699 00092429 QRY vgId:19, set querymgmt closed, wait for all queries cancelled 06/25 13:56:18.137774 00092429 DND total vnodes:17 are all closed 06/25 13:56:18.306794 00092436 UTL cache:qhandle_29 will be cleaned up 06/25 13:56:18.317769 00092436 WAL vgId:29, wal:0x7f05b0484870 file:/root/data/vnode/vnode29/wal/wal1, it is removed 06/25 13:56:18.613864 00092429 DND inter-dnodes RPC server is closed 06/25 13:56:18.821414 00092436 UTL cache:qhandle_26 will be cleaned up 06/25 13:56:18.835741 00092436 WAL vgId:26, wal:0x7f05b4532110 file:/root/data/vnode/vnode26/wal/wal1, it is removed 06/25 13:56:19.114563 00092429 DND dnode inter-dnodes rpc client is closed 06/25 13:56:19.114822 00092429 UTL worker:vmgmt is closed 06/25 13:56:19.339968 00092436 UTL cache:qhandle_23 will be cleaned up 06/25 13:56:19.351937 00092436 WAL vgId:23, wal:0x7f05cc567f40 file:/root/data/vnode/vnode23/wal/wal1, it is removed 06/25 13:56:19.806887 00092436 UTL cache:qhandle_20 will be cleaned up 06/25 13:56:19.821441 00092436 WAL vgId:20, wal:0x7f05c4569130 file:/root/data/vnode/vnode20/wal/wal1, it is removed 06/25 13:56:20.324871 00092436 UTL cache:qhandle_3 will be cleaned up 06/25 13:56:20.325328 00092436 WAL vgId:3, wal:0x7f05ac0bc640 file:/root/data/vnode/vnode3/wal/wal1, it is removed 06/25 13:56:20.827634 00092436 UTL cache:qhandle_4 will be cleaned up 06/25 13:56:20.829812 00092436 WAL vgId:4, wal:0x7f05b81e5cd0 file:/root/data/vnode/vnode4/wal/wal1, it is removed 06/25 13:56:21.332439 00092436 UTL cache:qhandle_5 will be cleaned up 06/25 13:56:21.334704 00092436 WAL vgId:5, wal:0x7f05bc328860 file:/root/data/vnode/vnode5/wal/wal1, it is removed 06/25 13:56:21.839955 00092436 UTL cache:qhandle_6 will be cleaned up 06/25 13:56:21.842273 00092436 WAL vgId:6, wal:0x7f05c0338f60 file:/root/data/vnode/vnode6/wal/wal1, it is removed 06/25 13:56:22.300294 00092436 UTL cache:qhandle_7 will be cleaned up 06/25 13:56:22.303819 00092436 WAL vgId:7, wal:0x7f05c46ab820 file:/root/data/vnode/vnode7/wal/wal1, it is removed 06/25 13:56:22.815213 00092436 UTL cache:qhandle_8 will be cleaned up 06/25 13:56:22.817585 00092436 WAL vgId:8, wal:0x7f05cc6aa6f0 file:/root/data/vnode/vnode8/wal/wal1, it is removed 06/25 13:56:23.319536 00092436 UTL cache:qhandle_9 will be cleaned up 06/25 13:56:23.322148 00092436 WAL vgId:9, wal:0x7f05b46748b0 file:/root/data/vnode/vnode9/wal/wal1, it is removed 06/25 13:56:23.824939 00092436 UTL cache:qhandle_10 will be cleaned up 06/25 13:56:23.827348 00092436 WAL vgId:10, wal:0x7f05bc12b010 file:/root/data/vnode/vnode10/wal/wal1, it is removed 06/25 13:56:24.329285 00092436 UTL cache:qhandle_11 will be cleaned up 06/25 13:56:24.331620 00092436 WAL vgId:11, wal:0x7f05c013b850 file:/root/data/vnode/vnode11/wal/wal1, it is removed 06/25 13:56:24.836353 00092436 UTL cache:qhandle_12 will be cleaned up 06/25 13:56:24.838330 00092436 WAL vgId:12, wal:0x7f05c412c260 file:/root/data/vnode/vnode12/wal/wal1, it is removed 06/25 13:56:25.343826 00092436 UTL cache:qhandle_13 will be cleaned up 06/25 13:56:25.346002 00092436 WAL vgId:13, wal:0x7f05cc12b0e0 file:/root/data/vnode/vnode13/wal/wal1, it is removed 06/25 13:56:25.848561 00092436 UTL cache:qhandle_14 will be cleaned up 06/25 13:56:25.850842 00092436 WAL vgId:14, wal:0x7f05b412b8a0 file:/root/data/vnode/vnode14/wal/wal1, it is removed 06/25 13:56:26.305552 00092436 UTL cache:qhandle_15 will be cleaned up 06/25 13:56:26.307988 00092436 WAL vgId:15, wal:0x7f05b00c1f80 file:/root/data/vnode/vnode15/wal/wal1, it is removed 06/25 13:56:26.809856 00092436 UTL cache:qhandle_16 will be cleaned up 06/25 13:56:26.811166 00092436 WAL vgId:16, wal:0x7f05ac0a2b70 file:/root/data/vnode/vnode16/wal/wal1, it is removed 06/25 13:56:27.313181 00092436 UTL cache:qhandle_17 will be cleaned up 06/25 13:56:27.314491 00092436 WAL vgId:17, wal:0x7f05b80a29f0 file:/root/data/vnode/vnode17/wal/wal1, it is removed 06/25 13:56:27.816469 00092436 UTL cache:qhandle_18 will be cleaned up 06/25 13:56:27.818164 00092436 WAL vgId:18, wal:0x7f05bc1e59f0 file:/root/data/vnode/vnode18/wal/wal1, it is removed 06/25 13:56:28.320889 00092436 UTL cache:qhandle_19 will be cleaned up 06/25 13:56:28.321948 00092436 WAL vgId:19, wal:0x7f05c01f5c20 file:/root/data/vnode/vnode19/wal/wal1, it is removed 06/25 13:56:28.324046 00092429 DND dnode vwrite is closed 06/25 13:56:28.324730 00092429 UTL worker:vfetch is closed 06/25 13:56:28.328470 00092429 UTL worker:vquery is closed 06/25 13:56:28.604365 00092429 WAL wal module is cleaned up 06/25 13:56:28.604513 00092429 DND Failed to start TDengine, please check the log at:/var/log/taos
help wanted question

opened by Struggle-hard-nan 0

Releases(ver-2.6.0.6)

ver-2.6.0.6(Jun 25, 2022)

Release Notes

from：release/ver-2.6.0.4 to：release/ver-2.6.0.6

FIX BUGS: fix: multi groupby calc key error (#14052) fix: offset optimization order by desc calc skip block error(#14027) fix: Remove install warning for red hat (#14019) fix: added upstream check to avoid crash (#13894) fix: fixed group by col_proj_function des error on client (#13821) fix: taosdump incorrect count when dump in (#13815) fix: super table info not removed after dropped by another client (#13666) fix: fixed related query error caused by tag mismatch (#13308)

ENHANCEMENTS: enh:change master/slave to leader/follower (#14190) feat: added bitwise operations (#13306) feat: support case sensitive and CN names of db, stable, column, tags and so on (#13866)
Source code(tar.gz)
Source code(zip)
ver-2.4.0.30(Jun 25, 2022)

Release Notes

from：release/ver-2.4.0.26 to：release/ver-2.4.0.30

FIX BUGS: fix: multi groupby calc key error (#14081) fix: fixed offset optimization calc skipBlock error (#14029) fix: Remove install warning for red hat (#14018) fix: added upstream check to avoid crash (#13892) fix: crash caused by group by and order by des (#13827) fix: taosdump incorrect count when dump in (#13816) fix: super table info not removed after dropped by another client (#13665)

ENHANCEMENTS: feat: support case sensitive or CN names of db, stable, table, column and tag (#14110) enh: change master/slave to leader/follower (#14194) feat: added bitwise operations (#12263)
Source code(tar.gz)
Source code(zip)
ver-2.6.0.4(Jun 10, 2022)

Release Notes

from：release/ver-2.6.0.1 to：release/ver-2.6.0.4

FIX BUGS: TDengine fix: remove some case-insensitive checkings (#13664) fix: pSql->subStates maybe free by recreate (#13614) fix: inserting data from multi files is not supported (#13522) fix: schemaless support blank comma equal sign mark (#13409) fix: batch create table bug (#13385) fix: mixed operator output num calc error (#13293) fix: line protocol support n and fixed error (#13301) fix: delete empty super table core (#13328)
Source code(tar.gz)
Source code(zip)
ver-2.4.0.26(Jun 10, 2022)

Release Notes

from：release/ver-2.4.0.25 to：release/ver-2.4.0.26

FIX BUGS: TDengine fix: remove some case-insensitive checkings (#13667) fix: pSql->subStates maybe free by recreate (#13615) fix: inserting data from multi files is not supported (#13521) fix: schemaless support tag value have comma blank euqal sign (#13411) fix: batch create table bug (#13385) fix: mixed operator column calc output size error (#13295) fix: line protocol sync from develop (#13300)
Source code(tar.gz)
Source code(zip)
ver-2.6.0.1(May 31, 2022)

Release Notes

from：release/ver-2.6.0.0 to：release/ver-2.6.0.1

FIX BUGS: TDengine fix: link taosBenchmark in /usr/bin (#13205)
Source code(tar.gz)
Source code(zip)
ver-2.4.0.25(May 31, 2022)

Release Notes

from：release/ver-2.4.0.24 to：release/ver-2.4.0.25

FIX BUGS: TDengine fix: link taosBenchmark in /usr/bin (#13205)
Source code(tar.gz)
Source code(zip)
ver-2.6.0.0(May 30, 2022)

Release Notes

FIX BUGS: Bugs fixed on 2.4 have been merged into 2.6. In addition, there are some bugs that are only fixed on 2.6. fix: cannot insert data when the keep value of the database is 365000 and precision is ns（#8331） fix: when the diff/csum mix with tag columns, and the super table is operated, the limit result returns an exception fix: disallow order by tbname for temp table (#12023) fix: make least-squares buffer large enough to hold json result (#12207) fix: default subquery order by ts with interval (#12526) fix: taosbenchmark -c does not take effect fix: When using taosBenchmark for multi-thread-query, some query threads are missing fix: driver-go can not convert ts column correctly when using default taosd httpd fix: order by column check error (#12152) fix: hivemq extension broken with recent TDengine (#12204) fix: alias name not equal if tsKeepOriginalColumnName is seted (#10855) doc: add super table select note (#12174)

NEW FEATURES / ENHANCEMENTS: Timestamp format shortcut (#10818) Restrict like to be followed only by strings (#9761) Add hyperloglog function (#10743) TaosAdapter supports remote_read and remote_write (#9495) Add a new interface to support bulk pulling Parse block data and handle null value (#10353) Add Histogram function (#10119) Add time related functions (#10352) Add string function lower, upper, ltrim, rtrim, and subst (#9982) Add time window related keywords (#10654) Add Tail/Head function (#10451) Add stateCount function (#10615) Add stateDuration function (#10615) Add unique function (#10317) Diff function supports ignore negative (#9387) Add mode function (#10351) Add elapsed function (#8727) Add cast functions in SQL (#8834) Support math functions (#8204) (connector,query,insert,other,tools,taosAdapter):deal with escape character (#9747) Add cumulative sum/moving average/sample function (#7998) Support rcf3339 format timestamp in tag (#10756)
Source code(tar.gz)
Source code(zip)
ver-2.4.0.24(May 28, 2022)

Release Notes from：release/ver-2.4.0.20 to：release/ver-2.4.0.24

FIX BUGS: TDengine fix: mkdir with newly added tiered storage (#13013) fix: check return value from meta hashmap (#12690) fix: taoskeeper shell script (#773) fix: fixed a heap buffer overflow bug (#12915) fix: ignore Ref is not there to save true error (#12858) fix: stddev order by desc supported and bsearch order by desc supported (#12826) fix: default subquery order by ts with interval (#12529)
Source code(tar.gz)
Source code(zip)
ver-2.4.0.20(May 15, 2022)

Release Notes from：release/ver-2.4.0.18 to：release/ver-2.4.0.20

FIX BUGS: TDengine fix: reverseCopy not support timestamp datatype (#12340) fix: group by with proj query can not work well (#12288) fix: apply function offset/forward step error when session + order by ts desc (#12271) fix: make least-squares buffer large enough to hold json result (#12205) fix: backport last expr fix from develop branch (#12140) fix: disallow order by tbname for temp table (#12021) fix: fixed a query coredump in Windows (#11945) fix: update copoyright info (#12308)

ENHANCEMENTS: TDengine refactor: V2.4 move TSZ to main repo (#12236)
Source code(tar.gz)
Source code(zip)
ver-2.4.0.18(Apr 27, 2022)

Release Notes from：release/ver-2.4.0.16 to：release/ver-2.4.0.18 FIX BUGS: TDengine [TS-1390]: fix 'invalid handle' error in associated queries（#11709） [TS-1384]: enhance verify condition（#11344） [TS-1409]: print taos_connect failed reason befor exiting（#11414） [TS-1397]: fix that column conditions worked bad on 32-bit Windows（#11325） taosTools [TS-1427]: move taosBenchmark out from deb/rpm（#11474）

ENHANCEMENTS: TDengine [TS-899]: group by multi columns（#11665） [TD-14977]: TDinsight.sh --offline mode support (#11725)

NEW FEATURES: [TS-1210]: added Bitwise AND feature（#11110）
Source code(tar.gz)
Source code(zip)
ver-2.4.0.16(Apr 9, 2022)

Release Notes from：release/ver-2.4.0.14 to：release/ver-2.4.0.16

FIX BUGS: TDengine [TS-510]: fix missing last_row results (#11265) [TS-1381]: fixed a schemaless insert error (#11237) [TS-1387]: fixed a coredump (#11233) [TS-1383]: Add configurable option of tcpConnTimeout (#11229) [TS-1368]: del old MD5 func (#11150) [TS-1379]: fix show vnodes with 0 vnode (#11131) [TS-1363]: Mutex is not initialized (#11053) [TS-1366]: fix unsigned bug with show create table (#11011)

ENHANCEMENTS: TDengine [TS-1292]: add time offset (#11154) taosTools [TS-1302]: taosdump loose mode (#11239)
Source code(tar.gz)
Source code(zip)
ver-2.4.0.14(Mar 26, 2022)

Release Notes from：release/ver-2.4.0.12 to：release/ver-2.4.0.14

FIX BUGS: TDengine [TD-14273]: export a few lacked interfaces for windows (#10952) [TS-1352]: fix default numOfMnodes from 3 to 1 (#10937) [TS-1318]: used merge sort to sort vgId and updated a test case [TD-14228]: fix maxvnodes.sim error, Set configuration parameters explicitly (#10923) [TD-13414]: fix taos shell coredump when scalar function arithmetic operation has bool operands [TS-1195]: fix stop send the completion warning at the end (#10821) [TS-1278]: fix isNull parameter with cols merge [TD-13875]: common json now can be inserted [TS-207]: fixed child table or normal table order by [TD-13918]: strings are compared without comparing lengths [TD-14055]: adjust the method of obtaining values (#10958) taosTools [TD-14009]: taosdump testcases uncertain for 2.4 (#10716)

ENHANCEMENTS: TDengine [TD-14044]: (taosAdapter) record http sql (#10905) [TS-922]: Turn off auto balance (#10824) [TD-13970]: timestamp format shortcut [TS-1324]: fix dataDir & logDir log output taosTools [TD-14141]: update taostools for 2.4 (#10949) [TD-13928]: improve user experience for taosbenchmark (#10737)
Source code(tar.gz)
Source code(zip)
ver-2.4.0.12(Mar 11, 2022)

Release Notes from：release/ver-2.4.0.10 to：release/ver-2.4.0.12

FIX BUGS: TDengine [TS-1311]: fix mnode crash casued by flowctrl/slaveQuery not match (#10697) [TS-1306]: fix endless loop with utf-8 replacement character (#10682) [TS-1304]: fixed incorrect results due to a parsing error [TS-1289]: fixed incorrect create stable rebuild statment [TD-13882]: fix ERROR output when monitor start first time [TS-1286]: validate empry ep in show vnodes command [TS-1233]: fixed coredump when timestamp collection excessed threshold [TD-13815]: update taosAdapter version (#10529) [TS-1285]: fix alter timestamp tag precision issue [TS-1215]: fix memcpy with real length of data on DESC [TS-1230]: taosdump case remove -B (#10641) [TS-1254]: fix keepColumnName with signle column

ENHANCEMENTS: TDengine [TS-1258]: fix show create with normal & stable to uppercase
Source code(tar.gz)
Source code(zip)
ver-2.4.0.10(Feb 28, 2022)

Release Notes from：release/ver-2.4.0.7 to：release/ver-2.4.0.10

FIX BUGS: TDengine [TD-13300]: docker stop takes 10 seconds (#10274) [TS-1189]: fixed 'show users' bug (#10272) [TS-1186]: tbname crash with interp (#10247) taosTools [TS-1216]: taosdump normal tbl count (#10359) [TD-13452]: arm32 taos-tools compilation(2.4) (#10243)

ENHANCEMENTS: TDengine [TS-1223]: check vnode dnodes num when create db and alter db replica (#10362) taosTools [TD-13592]: the time unit of query results is changed from MS to US to improve the accuracy of statistical information and reduce errors (#10335)

NEW FEATURES: [TS-1220]: The new TSZ compression algorithm provides richer compression functions for floating point data types (#10332) [TD-12131]: Added Golang RESTful interface. You can request or write data by using the Go Restfuf API.
Source code(tar.gz)
Source code(zip)
ver-2.4.0.7(Feb 14, 2022)

Release Notes from：release/ver-2.4.0.5 to：release/ver-2.4.0.7

FIX BUGS: [TS-1166]: update taosTools to 1.3.0 (#10141) [TD-13342]: fix CI test failed when taosadapter.toml is missing (#10110) [TD-13353]: fix CI failed cases of JDBC (#10123) [TS-822]: fixed compilation error on Windows

ENHANCEMENTS:

NEW FEATURES: [TS-1152]: taosdump deps builtin (#10126) [TS-822]: optimized print style of data with double type

DOCS:

TEST: [TD-13292]:move testcase to system-test directory
Source code(tar.gz)
Source code(zip)
ver-2.4.0.5(Jan 28, 2022)

Source code(tar.gz)
Source code(zip)
ver-2.4.0.4(Jan 24, 2022)

Source code(tar.gz)
Source code(zip)
ver-2.4.0.0(Dec 24, 2021)
New Features/Enhancements

Multiple tables can be inserted concurrently in batch mode by JDBC using parameter binding API

New component TDinsight is released for system administrator to monitor the status of TDengine cluster through Grafana dashboards

New component taosAdapter, as a HTTP proxy for TDengine, is released to replace old httpd module embedded in TDengine, the interface is kept as same; more important, taosAdapter can support multiple kinds of data collection agents, like statsd, collectd, tcollector, etc; the data generated or collected by multiple kinds of exportors can be written to TDengine through taosAdapter.

OpenTSDB writing protocols, including telnet and JSON, are supported by taosAdapter.

DataX Reader and Writer for TDengine are released, for user to easily migrate from OpenTSDB to TDengine and from TDengine to TDengine.

Client SDK (taosc) and all connectors in other languages (Java, Go, etc) can connect to multiple TDengine simultaneously.

Tag of JSON type can be used.

Regular expression filtering can be used against tag names and values of tags in binary type.

Multiple scalar functions, ceil, floor, round, etc, are added.

Configuration can be dynamically adjusted through JDBC and Go connector.

The interpolation query of the precision timestamp has been enhanced.

Performance Improvements

Pre-calculation module is redesigned with new storage architecture. The performance improvement is huge in case of querying against massive data, especially in case the data size is tens or hundereds of millions of tuples, the improvement may be 100 times in some cases in which pre-calculation is triggered. However, the improvement is not very obvious if the data size is not big.

Automatic compression mechanism is introduced for table metadata. The metadata may be restructured according to the data distribution and status of data blocks and the process of restructuring is triggered automatically and it is very fast. Even the system startup speed can be improved by this mechanism.

Optimization is done for the aggregation and interpolation of grouping query, the performance of some cases can be doubled up.

Source code(tar.gz)
Source code(zip)
ver-2.2.2.0(Nov 18, 2021)

FromBranch:release/ver-2.2.1.3 ToBranch: release/ver-2.2.2.0 FIX BUGS: [TD-10904]: arch linux and alpine and gcc11 (#8632) [TD-10823]: fixed taosdemo memory leak. (#8604) [TD-10776]: Handle the case where the data is filtered inside the doGetDataBlock function. [TD-10776]: solve the problem that hashIntervalAgg function triggers assert when the return result of sub query is filtered. [TD-10823]: after calling taos_stmt_execute, clean up the cache of multi-table inserts. [TD-10691]: fixed coredump when 'file' contained in non-insertion SQL

ENHANCEMENTS:

NEW FEATURES:

DOCS: [TD-10852]: remove grafana plugin in releases [ci skip] (#8542)

TEST: [TD-6137]:add test case for udf to support all query ways
Source code(tar.gz)
Source code(zip)
ver-2.0.22.0(Nov 18, 2021)

FromBranch:release/ver-2.0.21.3 ToBranch: release/ver-2.0.22.0 FIX BUGS: [TS-544]:use tagSchema of super table [TS-605]: fix comp display with _block_dist() [TS-550]: memset one more byte [TS-550]: fixed a stack overflow bug

ENHANCEMENTS: [TS-657]: use warning log level instead of error with not support show types

NEW FEATURES:

DOCS:

TEST:
Source code(tar.gz)
Source code(zip)
ver-2.3.2.0(Nov 18, 2021)

FromBranch:release/ver-2.3.1.0 ToBranch: release/ver-2.3.2.0 FIX BUGS: [TD-11070]: cmake jemalloc script. (#8697) [TD-10896]: use taosa insteadof blm3 (#8679) [TD-10873]: Fixed the problem that SMnodeMsg may still be used by dnodeMWriteQ thread after it is released by sdbWorker thread. [TD-10896]: use taosa instead of blm3 (#8656) [TD-10904]: support Arch Linux compile (#8618) [TD-10896]: replace blm3 with taosadapter (#8605) [TD-10828]: fix PyPI taospy connector failed for master branch (#8571) [TD-10873]: Handle the problem that debug printing may refer to the released pointer. [TD-10863]: blm3 service on centos7 (#8565) [TD-10859]: [schemaless] Fix line Protocol support escape characters [TD-10758]:call tag_project to set tag values inside single table multi-ouput functions [TD-10758]:order by tags not supported with diff/derivate/csum/mavg [TD-10804]:fix paramter descrption error

ENHANCEMENTS: [TD-10773]: add user configurable option smlChildTableName to specify child table name instead using ID in tag field.

NEW FEATURES: [TD-3340]:nodejs support unsigned type (#8548)

DOCS: [TD-5197]: publish libtaos-rs as official Rust connector (#8593)

TEST:
Source code(tar.gz)
Source code(zip)
ver-2.3.1.0(Nov 3, 2021)

FromBranch:release/ver-2.3.0.0 ToBranch: release/ver-2.3.1.0

FIX BUGS: [TS-498]: alter keep alive time in restful pool (#8503) [TD-10824-D]: compacting in 2 abnormally if vnode has no meta/data [TD-10700]: fixed tag/column name length 64 issue [TD-10691]: fixed coredump when 'file' contained in non-insertion SQL [TS-522]: fix JDBC-RESTful didn't change wasNull after getString (#8470) [TD-10700]: fixed tag/column name length 64 issue [TS-471]: fixed that queries in timezone with DST were incorrect [TD-10700]: add test cases [TD-10700]: fixed alter tag modify tag lengh clause when escape characters applied [TD-10700]: fixed schemaless table name length 192 issue [TD-10770]: fix python connector tests and examples error in case of new schemaless api (#8458) [TD-10732]: snapcraft blm3 build issue. (#8379) [TS-441]: add windows unicode support [TS-509]:Repeated single quotes error. (#8445) [TS-198]: support usb dongle. [TD-10771]: fix invalid syntax error for python2 (#8430) [TS-361]: fixed count of query was incorrect when 'like' was used [TD-10735]:use different cumsum type for signed/unsigned/double input type [TS-378]: fix tsCompressBoolImp log error [TS-336]:don't need return -1,when update sql done [TD-10710]: taosdump exit if mix input. (#8327) [TS-336]:fix sql execute error in idea (#8326) [TD-8315]: unused value in path src/tsdb/src/tsdbRead.c [TD-10706]:csum and mavg only support group by tbname [TD-10683]:set TSTD_MAX_KEEP to 36500 and set MIN_TS_KEY to take into account DELETE account in TKEY [TS-478]: insert status can use , or whitespace as separator in values [TD-10628]:close query ResultSet (#8293) [TS-468]: add io_read_rate, io_write_rate [TD-10690]: pickup httpd and make install failed. (#8310) [TD-10578]: taosdemo rest interface slow. (#8229) [TD-6045]: taosdump multiple stb. (#8308) [TD-6045]: taosdump multiple stb. (#8295) [TD-10676]:log database io_read/io_write value abnormal [TD-10639]: add test cases; [TD-10639]: allow OpenTSDB telnet line protocol metric value contain space inside double quote for string types [TD-10639]: allow influxDB line protocol column value contain space/comma inside double quote [TD-6662]: fixed bug in subscription to normal table with ts limitation [TS-414]: pCol->len logic fix for partial update of columns [TS-401]: fixed bug that update didn't work in some conditions

ENHANCEMENTS: [TD-10700]: fixed uppercase tag in escape quote issue [TD-10700]: add test case for JSON protocol inserting keywords/special character [TD-10700]: add test case for telnet protocol inserting keywords/special character [TD-10700]: add test case for line protocol inserting keywords/special character [TD-10700]: add test case for modify column length [TD-10700]: The escape char backstick can be used for both tag name and column name [TS-493-M]: postpone cache last to query time [TD-10700]: The escape char backstick can be used for both tag name and column name [TD-10700]: add tag name escape sim test cases [TD-10700]: add column name escape sim test cases [TD-10700]: The escape char backstick can be used for both tag name and column name [TD-10642]: [schemaless] add affected lines and msg buffer for receiving error message. [TD-10642]: [schemaless] modified python connector to accomandate API change [TD-10642]: [schemaless] add affected lines and msg buffer for receiving error message. [TS-385]: support flush wal by walFlushSize

NEW FEATURES: [TD-10751]: jdbc support schemaless insert (#8511) [TD-10401]: support datax tdenginewriter migrate opentsdb data (#8411) [TD-6117]:Multi-level aggregate query optimization

DOCS: [TD-10852]: remove grafana plugin in releases [ci skip] (#8543) [TD-5892]: officially document the PyPI python connector [ci skip] (#8459) [TD-10743]: ports rearrange

TEST: [TD-6124]: finish influxdb and opentsdbschemaless test [TD-6672]: finish tests/pytest/query/queryDiffColsTagsAndOr.py [TD-10551]: add taosdemo testcase that it provides define timestamp column with stmt in sample.csv [TD-10551]: add taosdemo testcase that it provides define timestamp column in sample.csv '[TD-6677]:add testcase of the tag type supporting json format' [TS-443]: update test case [TD-10703]:nested query interval [TD-5898]:add taosdump case of mixed usage of -D [TD-5898]:add taosdump case about usage of -D [TS-444]: add test case for union all [TS-440]: add test case for max data length
Source code(tar.gz)
Source code(zip)
ver-2.0.21.3(Nov 3, 2021)

FromBranch:release/ver-2.0.21.2 ToBranch: release/ver-2.0.21.3

FIX BUGS: [TS-441]: add windows unicode support [TS-499]: optimization for OOM during query [TS-378]: fix tsCompressBoolImp log error

ENHANCEMENTS:

NEW FEATURES:

DOCS:

TEST:
Source code(tar.gz)
Source code(zip)
ver-2.2.1.3(Nov 3, 2021)

FromBranch:release/ver-2.2.1.1 ToBranch: release/ver-2.2.1.3 FIX BUGS: [TD-10824]: compacting in 2 abnormally if vnode has no meta/data [TS-441]: add windows unicode support [TS-378]: fix tsCompressBoolImp log error [TS-478]: insert status can use , or whitespace as separator in values [TS-468]: add io_read_rate, io_write_rate [TD-6045]: taosdump multiple stb. (#8308) [TD-10676]:log database io_read/io_write value abnormal [TS-401]: fixed bug that update didn't work in some conditions

ENHANCEMENTS: [TS-493-M]: postpone cache last to query time

NEW FEATURES:

DOCS:

TEST: [TD-10703]:nested query interval [TS-444]: add test case for union all
Source code(tar.gz)
Source code(zip)
ver-2.2.1.1(Oct 21, 2021)

Release Notes from ver-2.2.0.5 to ver-2.2.1.1

FIX BUGS: [TD-10533]:add return value to pass windows compilation [TD-6662]: fixed bug in subscription to normal table with ts limitation [TS-414]: pCol->len logic fix for partial update of columns [TD-10484]: B is not defined error. (#8186) [TD-10530]: taosdump infinite loop (#8146) [TS-413]: not support group by with _block_disk query [TD-10480]: taosdemo check -P argument. (#8093) [TS-401]: fixed bug that update didn't work in some conditions

ENHANCEMENTS:

NEW FEATURES:

DOCS:

TEST: [TS-440]: add test case for max data length [TD-10515]: add testcases for TD-10515 [TS-402]: add test case for update option equals 2 [TD-10459]:modify parameters of keep from 365 to 36500 [TD-6137]: Supplement UDF test cases, and record 21 bugs
Source code(tar.gz)
Source code(zip)
ver-2.0.21.1(Oct 21, 2021)

Release Notes From: release/ver-2.0.21.0

To: release/ver-2.0.21.1

FIX BUGS: [TS-401]: fixed bug that update didn't work in some conditions

ENHANCEMENTS:

NEW FEATURES:

DOCS:

TEST: [TD-10459]:modify parameters of keep from 365 to 36500
Source code(tar.gz)
Source code(zip)
ver-2.3.0.0(Oct 15, 2021)

Release Notes From: release/ver-2.2.0.5 To: release/ver-2.3.0.0

new features： [TD-10456] taosdemo support restful interface insert to stable [TD-10439] taosdemo support timestamp tags [TD-10418] taosdemo support in cmdline mode, datatype binary and nchar with customized width [TD-6631] GO connector support STMT interface [TD-6561] support regular expressions "not match" filter for tags [TD-2581] support 'OR' join query conditions between columns [TD-6103] support for the apercentile function [TD-5894] long query block data writes [TD-5729] add sub query's state and obj_id in result of show queries [TD-4352] add compression for meta data in tsdb [TD-3048] complementing unimplemented methods of Python connectors [TD-6127] allow two clusters to be connected at the same time [TD-2573] support three new query functions: ceil, floor, round [TD-6124] support for OpenTSDB writing protocols [TD-5635] support schemaless protocols [TD-10538] taosdemo support insert data from csv flie, including timestamp

bugs/stability： [TD-6280] taosdump -P abnormal work when Specify the port number [TD-7515] taos -D filedir to crash [TD-6679] in the HTTP module the memory that has been released is used [TD-6663] force TCP transmission through configuration parameters [TD-6662] unable to filter data in "where" clause while subscribe a normal table [TD-6306] taosdump --all-database did not work as expected [TD-6133] GO connector refactor

performance： [TD-6563] optimize the query performance during query execution [TD-5623] support column level data compress in transport

user experience enhancement： [TD-6479] improve taosdump -D passing parameters to it can direct follow the parameters [TD-10397] taosdump support show version [TD-6688] go connector not show error: invalid column/tag name [TD-6420] TDengine server support apt install
Source code(tar.gz)
Source code(zip)
ver-2.2.0.5(Sep 27, 2021)

From: release/ver-2.2.0.2

To: release/ver-2.2.0.5 FIX BUGS: [TD-6030]:update grafana plugin 3.0.0 branch. (#8070) [TD-6280]: taosdump -P determine input. (#8058) [TD-6473]: taosdump verify input arguments. (#8049) [TD-7790]: taosdump stb dump memory leak. (#8047) [TD-10416]: taosdump if no any arguments given. (#8023) [TD-5229]: Fix a small-probability bug [TS-357]: NULL column in a row was specially processed [TS-343]: fixed crash bug

ENHANCEMENTS:

NEW FEATURES:

DOCS:

TEST: [TS-381]: update valgrind suppressions file [TD-10414]:query condition between must use and [TD-6586]: add 1 testcase for TD-6586 [TD-6633]:modify python file
Source code(tar.gz)
Source code(zip)
ver-2.0.21.0(Sep 27, 2021)

From: release/ver-2.0.20.1

To: release/ver-2.0.20.16

FIX BUGS: [TS-357]: NULL column in a row was specially processed [TS-343]: fixed crash bug [TS-144]: fix table missing issue caused by hash rcount overflow

ENHANCEMENTS:

NEW FEATURES:

DOCS:

TEST: [TD-6633]:modify python file
Source code(tar.gz)
Source code(zip)
ver-2.2.0.2(Sep 27, 2021)

From: release/ver-2.2.0.1

To: release/ver-2.2.0.2 Release Notes

FIX BUGS: [TS-345]: fix install_clien.sh for Darwin installing script (#7898) [TD-6586]: fix binary/nchar convertion error in python connector (#7914) [TS-346]: [taosdump] support unsigned data export (#7912) [TS-144]: fix table missing issue caused by hash rcount overflow [TD-5852]: taosdemo data generation race. (#7708)

ENHANCEMENTS:

NEW FEATURES:

DOCS:

TEST: [TD-6635]:modify python file about ts = 1600000** [TD-6633]:modify python file [TS-337]: add test case for interp function returns empty result
Source code(tar.gz)
Source code(zip)