search

taosdata / TDengine

High-performance, scalable time-series database designed for Industrial IoT (IIoT) scenarios
https://tdengine.com
GNU Affero General Public License v3.0
23.19k stars 4.84k forks source link

influxdb row protocol writing encounter " Unexpected generic error in query " #16539

Closed zhou-hao closed 3 months ago

zhou-hao commented 2 years ago

TDengine版本: docker 3.0.0.1

使用influxdb方式写入数据后，其他查询正常，时间窗口聚合查询报错，过一会后再查询又正常。 正常sql：

select last(`_ts`) _ts,count(`int_p`) `c1` from `table` where `did` = 'test' and `_ts` >= 1661945467762 and `_ts` <= 1661961599883 order by _ts desc

出错sql：

select last(`_ts`) _ts,count(`int_p`) `c1` from `device_properties_t_IqbDsTk8` where `did` = 'test' and `_ts` >= 1661945467762 and `_ts` <= 1661961599883 interval(1d) order by _ts desc

日志:

08/31 19:32:34.874149 00000067 MND ERROR stb:1.jetlinks.device_properties_t_IqbDsTk8, failed to retrieve meta since Table does not exist
08/31 19:32:34.874200 00000067 MND ERROR msg:0x7fb9180034e0, failed to process since Table does not exist, app:(nil) type:table-meta, gtid:0x0:0x689023aca7b95fa8
08/31 19:32:34.877556 00000110 QRY ERROR get table device_properties_t_IqbDsTk8 meta failed cause of Table does not exist
08/31 19:32:34.882038 00000069 MND trans:15, is proposed and post sem
08/31 19:32:34.886201 00000069 MND trans:15, is proposed and post sem
08/31 11:32:34.940547 00000035 TAOS_ADAPTER info "| 204 |  554.031882ms |      172.18.0.1 | POST | /influxdb/v1/write?db=jetlinks " sessionID=146 model=web
ize:4.00 Kb, sortComparInit
Get/Release pages:0/0, flushToDisk:0.00 Kb (0 Pages), loadFromDisk:0.00 Kb (0 Pages), avgPageSize:-nan Kb
Paged buffer closed, total:0.00 Kb (0 Pages), inmem size:0.00 Kb (0 Pages), file size:0.00 Kb, page size:4.00 Kb, sortComparInit
Get/Release pages:0/0, flushToDisk:0.00 Kb (0 Pages), loadFromDisk:0.00 Kb (0 Pages), avgPageSize:-nan Kb
Paged buffer closed, total:0.00 Kb (0 Pages), inmem size:0.00 Kb (0 Pages), file size:0.00 Kb, page size:4.00 Kb, sortComparInit
Get/Release pages:0/0, flushToDisk:0.00 Kb (0 Pages), loadFromDisk:0.00 Kb (0 Pages), avgPageSize:-nan Kb
Paged buffer closed, total:0.00 Kb (0 Pages), inmem size:0.00 Kb (0 Pages), file size:0.00 Kb, page size:4.00 Kb, sortComparInit
Get/Release pages:0/0, flushToDisk:0.00 Kb (0 Pages), loadFromDisk:0.00 Kb (0 Pages), avgPageSize:-nan Kb
Paged buffer closed, total:0.00 Kb (0 Pages), inmem size:0.00 Kb (0 Pages), file size:0.00 Kb, page size:4.00 Kb, sortComparInit
Get/Release pages:0/0, flushToDisk:0.00 Kb (0 Pages), loadFromDisk:0.00 Kb (0 Pages), avgPageSize:-nan Kb
Paged buffer closed, total:0.00 Kb (0 Pages), inmem size:0.00 Kb (0 Pages), file size:0.00 Kb, page size:4.00 Kb, sortComparInit
Get/Release pages:0/0, flushToDisk:0.00 Kb (0 Pages), loadFromDisk:0.00 Kb (0 Pages), avgPageSize:-nan Kb
Paged buffer closed, total:0.00 Kb (0 Pages), inmem size:0.00 Kb (0 Pages), file size:0.00 Kb, page size:4.00 Kb, sortComparInit
Get/Release pages:0/0, flushToDisk:0.00 Kb (0 Pages), loadFromDisk:0.00 Kb (0 Pages), avgPageSize:-nan Kb
Paged buffer closed, total:0.00 Kb (0 Pages), inmem size:0.00 Kb (0 Pages), file size:0.00 Kb, page size:4.00 Kb, sortComparInit
Get/Release pages:0/0, flushToDisk:0.00 Kb (0 Pages), loadFromDisk:0.00 Kb (0 Pages), avgPageSize:-nan Kb
Paged buffer closed, total:0.00 Kb (0 Pages), inmem size:0.00 Kb (0 Pages), file size:0.00 Kb, page size:4.44 Kb, sortComparInit
Get/Release pages:0/0, flushToDisk:0.00 Kb (0 Pages), loadFromDisk:0.00 Kb (0 Pages), avgPageSize:-nan Kb
Paged buffer closed, total:0.00 Kb (0 Pages), inmem size:0.00 Kb (0 Pages), file size:0.00 Kb, page size:4.44 Kb, sortComparInit
Get/Release pages:0/0, flushToDisk:0.00 Kb (0 Pages), loadFromDisk:0.00 Kb (0 Pages), avgPageSize:-nan Kb
Paged buffer closed, total:0.00 Kb (0 Pages), inmem size:0.00 Kb (0 Pages), file size:0.00 Kb, page size:4.00 Kb, sortComparInit
Get/Release pages:0/0, flushToDisk:0.00 Kb (0 Pages), loadFromDisk:0.00 Kb (0 Pages), avgPageSize:-nan Kb
Paged buffer closed, total:0.00 Kb (0 Pages), inmem size:0.00 Kb (0 Pages), file size:0.00 Kb, page size:4.00 Kb, sortComparInit
Get/Release pages:0/0, flushToDisk:0.00 Kb (0 Pages), loadFromDisk:0.00 Kb (0 Pages), avgPageSize:-nan Kb
Paged buffer closed, total:0.00 Kb (0 Pages), inmem size:0.00 Kb (0 Pages), file size:0.00 Kb, page size:4.00 Kb, sortComparInit
Get/Release pages:0/0, flushToDisk:0.00 Kb (0 Pages), loadFromDisk:0.00 Kb (0 Pages), avgPageSize:-nan Kb
Paged buffer closed, total:0.00 Kb (0 Pages), inmem size:0.00 Kb (0 Pages), file size:0.00 Kb, page size:4.00 Kb, sortComparInit
Get/Release pages:0/0, flushToDisk:0.00 Kb (0 Pages), loadFromDisk:0.00 Kb (0 Pages), avgPageSize:-nan Kb
Paged buffer closed, total:0.00 Kb (0 Pages), inmem size:0.00 Kb (0 Pages), file size:0.00 Kb, page size:4.00 Kb, sortComparInit
Get/Release pages:0/0, flushToDisk:0.00 Kb (0 Pages), loadFromDisk:0.00 Kb (0 Pages), avgPageSize:-nan Kb
Paged buffer closed, total:0.00 Kb (0 Pages), inmem size:0.00 Kb (0 Pages), file size:0.00 Kb, page size:4.00 Kb, sortComparInit
Get/Release pages:0/0, flushToDisk:0.00 Kb (0 Pages), loadFromDisk:0.00 Kb (0 Pages), avgPageSize:-nan Kb
Paged buffer closed, total:0.00 Kb (0 Pages), inmem size:0.00 Kb (0 Pages), file size:0.00 Kb, page size:4.00 Kb, sortComparInit
Get/Release pages:0/0, flushToDisk:0.00 Kb (0 Pages), loadFromDisk:0.00 Kb (0 Pages), avgPageSize:-nan Kb
Paged buffer closed, total:0.00 Kb (0 Pages), inmem size:0.00 Kb (0 Pages), file size:0.00 Kb, page size:4.44 Kb, sortComparInit
08/31 11:32:35.221546 00000035 TAOS_ADAPTER info "| 200 |  136.255097ms |      172.18.0.1 | POST | /rest/sql/jetlinks " model=web sessionID=147
08/31 11:32:35.713018 00000035 TAOS_ADAPTER info "| 200 |   94.483769ms |      172.18.0.1 | POST | /rest/sql/jetlinks " model=web sessionID=148
08/31 11:32:35.881377 00000035 TAOS_ADAPTER info "| 200 |   24.869015ms |      172.18.0.1 | POST | /rest/sql/jetlinks " model=web sessionID=149
Get/Release pages:0/0, flushToDisk:0.00 Kb (0 Pages), loadFromDisk:0.00 K08/31 19:32:35.916289 00000103 QRY ERROR empty node
08/31 19:32:35.924182 00000103 QRY ERROR empty node
08/31 11:32:35.926240 00000035 TAOS_ADAPTER info "| 200 |   18.227747ms |      172.18.0.1 | POST | /rest/sql/jetlinks " model=web sessionID=150
08/31 11:32:35.946602 00000035 TAOS_ADAPTER info "| 200 |   37.865997ms |      172.18.0.1 | POST | /rest/sql/jetlinks " model=web sessionID=151
08/31 11:32:35.988916 00000035 TAOS_ADAPTER info "| 200 |   10.595198ms |      172.18.0.1 | POST | /rest/sql/jetlinks " model=web sessionID=152
08/31 11:32:36.018741 00000035 TAOS_ADAPTER info "| 200 |   14.516245ms |      172.18.0.1 | POST | /rest/sql/jetlinks " model=web sessionID=153
08/31 19:32:36.043502 00000103 QRY ERROR QID:0x5db023acac415ca0,TID:0xf0,EID:0 qCreateExecTask failed, code:80000704 - Unexpected generic error in query
08/31 11:32:36.047633 00000035 TAOS_ADAPTER info "| 200 |   15.695408ms |      172.18.0.1 | POST | /rest/sql/jetlinks " sessionID=154 model=web
08/31 11:33:14.279933 00000035 TAOS_ADAPTER info "| 200 |    20.02978ms |      172.18.0.1 | POST | /rest/sql/jetlinks " sessionID=155 model=web
08/31 11:33:17.674576 00000035 TAOS_ADAPTER info "| 200 |   16.585514ms |      172.18.0.1 | POST | /rest/sql/jetlinks " model=web sessionID=156
tuotuopz01 commented 2 years ago

6043-6049 在安全组中tcp和udp都得开放才行。。。

zhou-hao commented 2 years ago

单机运行的。 重点是：等待一会就正常了。 普通查询一直正常。只有 使用了PARTITION BY或  interval就会出现这个错误。

yu285 commented 2 years ago

可以远程吗？ 可以添加 微信 15652223354，我们排查下

yu285 commented 3 months ago

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

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