测试环境的数据库无法删除

【TDengine 使用环境】
测试环境

【TDengine 版本】

taos version: 3.4.1.0.community

【部署方式】非容器部署

【集群节点数】三节点

【集群副本数】单一

【描述业务影响】无法删除数据库

【问题复现路径/shan】
测试环境有个问题问一下,测试环境的数据库异常,移除了 损坏的 /data/taos/vnode/vnode29
和 /data/taos/vnode/vnode30 然后集群能启动了,不过现在想删除数据库报错,无法删除

【资源配置】

【报错完整截图】(不要大段的粘贴报错代码,论坛直接看报错代码不直观)

数据目录是不能手动去操作的。这样将数据库都搞坏了。

重新部署吧,将整个数据目录全部删除了,重新启动 taosd服务。但这样数据也全丢失了。

但是数据库当时都无法启动集群了,没有移动掉这个,集群无法启动你说怎么办

当当时一直在报错,无法启动集群

这个是一个 info,不是错误啊。

现在手动删除了 数据目录后,集群肯定被破坏了,无法使用了。

重新部署吧。

那个是异常前的操作,后面报错:
05/14 09:19:09.285950 00027497 C UTL FATAL pgno:14987265 exceeds dbFileSize:64480.
05/14 09:19:09.285955 00027497 C UTL FATAL tAssert at file … tdbPager.c:851 exit:1

ata/log/taos/taosdlog.1
[root@taos taos]# tail -200 /data/log/taos/taosdlog.0
05/14 09:19:09.284029 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1152
05/14 09:19:09.284041 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1153
05/14 09:19:09.284044 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1154
05/14 09:19:09.284068 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1155
05/14 09:19:09.284071 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1156
05/14 09:19:09.284083 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1157
05/14 09:19:09.284094 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1158
05/14 09:19:09.284104 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1159
05/14 09:19:09.284115 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1160
05/14 09:19:09.284126 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1161
05/14 09:19:09.284137 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1162
05/14 09:19:09.284147 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1163
05/14 09:19:09.284158 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1164
05/14 09:19:09.284168 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1165
05/14 09:19:09.284179 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1166
05/14 09:19:09.284189 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1167
05/14 09:19:09.284200 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1168
05/14 09:19:09.284210 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1169
05/14 09:19:09.284221 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1170
05/14 09:19:09.284231 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1171
05/14 09:19:09.284241 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1172
05/14 09:19:09.284252 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1173
05/14 09:19:09.284262 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1174
05/14 09:19:09.284272 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1175
05/14 09:19:09.284283 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1176
05/14 09:19:09.284293 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1177
05/14 09:19:09.284304 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1178
05/14 09:19:09.284314 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1179
05/14 09:19:09.284324 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1180
05/14 09:19:09.284335 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1181
05/14 09:19:09.284345 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1182
05/14 09:19:09.284355 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1183
05/14 09:19:09.284366 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1184
05/14 09:19:09.284376 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1185
05/14 09:19:09.284386 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1186
05/14 09:19:09.284397 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1187
05/14 09:19:09.284407 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1188
05/14 09:19:09.284417 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1189
05/14 09:19:09.284428 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1190
05/14 09:19:09.284438 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1191
05/14 09:19:09.284448 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1192
05/14 09:19:09.284459 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1193
05/14 09:19:09.284470 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1194
05/14 09:19:09.284480 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1195
05/14 09:19:09.284491 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1196
05/14 09:19:09.284501 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1197
05/14 09:19:09.284511 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1198
05/14 09:19:09.284522 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1199
05/14 09:19:09.284532 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1200
05/14 09:19:09.284542 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1201
05/14 09:19:09.284553 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1202
05/14 09:19:09.284574 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1203
05/14 09:19:09.284594 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1204
05/14 09:19:09.284621 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1205
05/14 09:19:09.284641 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1206
05/14 09:19:09.284644 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1207
05/14 09:19:09.284664 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1208
05/14 09:19:09.284674 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1209
05/14 09:19:09.284685 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1210
05/14 09:19:09.284695 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1211
05/14 09:19:09.284705 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1212
05/14 09:19:09.284716 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1213
05/14 09:19:09.284726 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1214
05/14 09:19:09.284736 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1215
05/14 09:19:09.284746 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1216
05/14 09:19:09.284760 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1217
05/14 09:19:09.284772 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1218
05/14 09:19:09.284775 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1219
05/14 09:19:09.284795 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1220
05/14 09:19:09.284798 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1221
05/14 09:19:09.284818 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1222
05/14 09:19:09.284828 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1223
05/14 09:19:09.284872 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1224
05/14 09:19:09.284887 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1225
05/14 09:19:09.284908 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1226
05/14 09:19:09.284927 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1227
05/14 09:19:09.284938 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1228
05/14 09:19:09.284948 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1229
05/14 09:19:09.284958 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1230
05/14 09:19:09.284969 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1231
05/14 09:19:09.284979 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1232
05/14 09:19:09.284989 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1233
05/14 09:19:09.284999 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1234
05/14 09:19:09.285009 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1235
05/14 09:19:09.285020 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1236
05/14 09:19:09.285030 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1237
05/14 09:19:09.285042 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1238
05/14 09:19:09.285048 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1239
05/14 09:19:09.285070 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1240
05/14 09:19:09.285073 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1241
05/14 09:19:09.285090 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1242
05/14 09:19:09.285093 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1243
05/14 09:19:09.285118 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1244
05/14 09:19:09.285120 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1245
05/14 09:19:09.285131 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1246
05/14 09:19:09.285141 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1247
05/14 09:19:09.285151 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1248
05/14 09:19:09.285161 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1249
05/14 09:19:09.285172 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1250
05/14 09:19:09.285182 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1251
05/14 09:19:09.285192 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1252
05/14 09:19:09.285206 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1253
05/14 09:19:09.285217 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1254
05/14 09:19:09.285227 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1255
05/14 09:19:09.285237 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1256
05/14 09:19:09.285254 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1257
05/14 09:19:09.285264 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1258
05/14 09:19:09.285274 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1259
05/14 09:19:09.285285 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1260
05/14 09:19:09.285295 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1261
05/14 09:19:09.285305 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1262
05/14 09:19:09.285315 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1263
05/14 09:19:09.285326 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1264
05/14 09:19:09.285336 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1265
05/14 09:19:09.285353 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1266
05/14 09:19:09.285364 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1267
05/14 09:19:09.285385 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1268
05/14 09:19:09.285380 00027497 C MTA INFO vgId:29, index:11385478, child table is created, tb:t_rawdata_0000C489987654 uid:5000439586850477238 suid:7624917482615090993
05/14 09:19:09.285387 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1269
05/14 09:19:09.285388 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1270
05/14 09:19:09.285396 00027497 C VND INFO vgId:29, ignore trim req during restoring. ver:11385479
05/14 09:19:09.285408 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1271
05/14 09:19:09.285419 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1272
05/14 09:19:09.285429 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1273
05/14 09:19:09.285439 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1274
05/14 09:19:09.285450 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1275
05/14 09:19:09.285460 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1276
05/14 09:19:09.285470 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1277
05/14 09:19:09.285482 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1278
05/14 09:19:09.285485 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1279
05/14 09:19:09.285507 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1280
05/14 09:19:09.285510 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1281
05/14 09:19:09.285523 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1282
05/14 09:19:09.285535 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1283
05/14 09:19:09.285549 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1284
05/14 09:19:09.285547 00027497 C MTA INFO vgId:29, index:11385480, child table is created, tb:t_rawdata_0000c489987654 uid:5000439588484712121 suid:7624917482615090993
05/14 09:19:09.285552 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1285
05/14 09:19:09.285622 00027497 C MTA INFO vgId:29, index:11385481, child table is created, tb:t_data_2053670159201939490_0000c489987654 uid:5000439588486809921 suid:9085913691723484035
05/14 09:19:09.285661 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1286
05/14 09:19:09.285662 00027497 C VND INFO vgId:29, ignore trim req during restoring. ver:11385487
05/14 09:19:09.285665 00027497 C VND INFO vgId:29, ignore trim req during restoring. ver:11385488
05/14 09:19:09.285667 00027497 C VND INFO vgId:29, ignore trim req during restoring. ver:11385489
05/14 09:19:09.285669 00027497 C VND INFO vgId:29, ignore trim req during restoring. ver:11385490
05/14 09:19:09.285675 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1287
05/14 09:19:09.285688 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1288
05/14 09:19:09.285708 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1289
05/14 09:19:09.285711 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1290
05/14 09:19:09.285797 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1291
05/14 09:19:09.285807 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1292
05/14 09:19:09.285810 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1293
05/14 09:19:09.285812 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1294
05/14 09:19:09.285814 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1295
05/14 09:19:09.285816 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1296
05/14 09:19:09.285818 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1297
05/14 09:19:09.285820 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1298
05/14 09:19:09.285822 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1299
05/14 09:19:09.285824 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1300
05/14 09:19:09.285826 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1301
05/14 09:19:09.285841 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1302
05/14 09:19:09.285853 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1303
05/14 09:19:09.285865 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1304
05/14 09:19:09.285867 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1305
05/14 09:19:09.285889 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1306
05/14 09:19:09.285892 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1307
05/14 09:19:09.285910 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1308
05/14 09:19:09.285922 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1309
05/14 09:19:09.285925 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1310
05/14 09:19:09.285946 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1311
05/14 09:19:09.285948 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1312
05/14 09:19:09.285950 00027497 C UTL FATAL pgno:14987265 exceeds dbFileSize:64480.
05/14 09:19:09.285955 00027497 C UTL FATAL tAssert at file /data/release/main/TDinternal/community/source/libs/tdb/src/db/tdbPager.c:851 exit:1
05/14 09:19:09.285969 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1313
05/14 09:19:09.285972 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1314
05/14 09:19:09.285992 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1315
05/14 09:19:09.285995 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1316
05/14 09:19:09.286016 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1317
05/14 09:19:09.286018 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1318
05/14 09:19:09.286038 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1319
05/14 09:19:09.286041 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1320
05/14 09:19:09.286085 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1321
05/14 09:19:09.286093 00027497 C UTL FATAL obtained 14 stack frames
05/14 09:19:09.286095 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1322
05/14 09:19:09.286095 00027497 C UTL FATAL frame:0, /usr/local/taos/bin/taosd() [0x1136df9]
05/14 09:19:09.286097 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1323
05/14 09:19:09.286097 00027497 C UTL FATAL frame:1, /usr/local/taos/bin/taosd() [0xda7ee6]
05/14 09:19:09.286099 00027497 C UTL FATAL frame:2, /usr/local/taos/bin/taosd() [0xdabf2a]
05/14 09:19:09.286099 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1324
05/14 09:19:09.286101 00027497 C UTL FATAL frame:3, /usr/local/taos/bin/taosd() [0xdacf77]
05/14 09:19:09.286101 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1325
05/14 09:19:09.286102 00027497 C UTL FATAL frame:4, /usr/local/taos/bin/taosd() [0xdafef0]
05/14 09:19:09.286103 00027497 C UTL FATAL frame:5, /usr/local/taos/bin/taosd() [0xdb0609]
05/14 09:19:09.286104 00027497 C UTL FATAL frame:6, /usr/local/taos/bin/taosd() [0x63d1ad]
05/14 09:19:09.286104 00027588 C VND INFO vgId:44, ignore trim req during restoring. ver:1326
05/14 09:19:09.286105 00027497 C UTL FATAL frame:7, /usr/local/taos/bin/taosd() [0x6420b9]
05/14 09:19:09.286107 00027497 C UTL FATAL frame:8, /usr/local/taos/bin/taosd() [0x64dffb]
05/14 09:19:09.286108 00027497 C UTL FATAL frame:9, /usr/local/taos/bin/taosd() [0x6011ef]
05/14 09:19:09.286109 00027497 C UTL FATAL frame:10, /usr/local/taos/bin/taosd() [0x604fc2]
05/14 09:19:09.286110 00027497 C UTL FATAL frame:11, /usr/local/taos/bin/taosd() [0x1152c5b]
05/14 09:19:09.286111 00027497 C UTL FATAL frame:12, /lib64/libpthread.so.0(+0x82de) [0x7fe8b0ca02de]
05/14 09:19:09.286112 00027497 C UTL FATAL frame:13, /lib64/libc.so.6(clone+0x43) [0x7fe8afc94a63]
[root@taos taos]#

不要纠结了,目前集群肯定是不正常了。只能重新部署。

现在整库都100 多G ,数据迁移都困难

已经移除了 的库就不正常,移除后启动集群其他库还是能用