You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/12/14 10:40:45 UTC
[GitHub] [doris] gojumprope opened a new issue, #15081: [Bug] Urgent. Unable to Query if we drop old backend and add a new backend
gojumprope opened a new issue, #15081:
URL: https://github.com/apache/doris/issues/15081
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
### Version
frontend: doris-1.2.0-rc04-Unknown
backend: doris-1.2.0-rc04-Unknown
Variable_name |Value |
---------------------------------+--------------------------------------+
partition_prune_algorithm_version|2 |
version |5.7.37 |
version_comment |Doris version doris-1.2.0-rc04-Unknown|
### What's Wrong?
similar issue from https://github.com/apache/doris/issues/13075
but this case if we drop old backend and add a new backend, we cannot query the table.
### What You Expected?
table data auto link with new backend and unlink with the old one, and able to query the table without error. Please fix this as soon as possible, if not we cannot query at all. Or anyone can tells if there is a temporary fix?
### How to Reproduce?
ALTER SYSTEM DROPP BACKEND "aa.aa.aa.aa:9050";
ALTER SYSTEM ADD BACKEND "bb.bb.bb.bb:9050";
select * from table_15_minute;
SQL Error [1105] [HY000]: errCode = 2, detailMessage = 841741 have no queryable replicas. err: 841742's backend 11001 does not exist or not alive
show tablet 841741;
SHOW PROC '/dbs/11002/833548/partitions/841740/833549/841741';
ReplicaId|BackendId|Version|LstSuccessVersion|LstFailedVersion|LstFailedTime|SchemaHash|LocalDataSize|RemoteDataSize|RowCount|State |IsBad|VersionCount|PathHash|MetaUrl |CompactionStatus |
---------+---------+-------+-----------------+----------------+-------------+----------+-------------+--------------+--------+------+-----+------------+--------+---------------------------------------+-----------------------------------------------------+
841742 |11001 |2 |2 |-1 | |-1 |0 |0 |0 |NORMAL|false|-1 |-1 |http://0.0.0.0:0/api/meta/header/841741|http://0.0.0.0:0/api/compaction/show?tablet_id=841741|
show backends;
BackendId|Cluster |IP |HeartbeatPort|BePort|HttpPort|BrpcPort|LastStartTime |LastHeartbeat |Alive|SystemDecommissioned|ClusterDecommissioned|TabletNum|DataUsedCapacity|AvailCapacity|TotalCapacity|UsedPct|MaxDiskUsedPct|RemoteUsedCapacity|Tag |ErrMsg|Version |Status |HeartbeatFailureCounter|NodeRole|
---------+---------------+-------------+-------------+------+--------+--------+-------------------+-------------------+-----+--------------------+---------------------+---------+----------------+-------------+-------------+-------+--------------+------------------+------------------------+------+------------------------+-----------------------------------------------------------------------------------------------------------------------------+-----------------------+--------+
1340074 |default_cluster|bb.bb.bb.bb|9050 |9060 |8040 |8060 |2022-12-14 10:22:50|2022-12-14 10:33:21|true |false |false |36 |0.000 |255.528 GB |466.288 GB |45.20 %|45.20 % |0.000 |{"location" : "default"}| |doris-1.2.0-rc04-Unknown|{"lastSuccessReportTabletsTime":"2022-12-14 10:32:23","lastStreamLoadTime":-1,"isQueryDisabled":false,"isLoadDisabled":false}|0 |mix |
1340075 |default_cluster|cc.cc.cc.cc|9050 |9060 |8040 |8060 |2022-12-14 10:24:00|2022-12-14 10:33:21|true |false |false |47 |0.000 |359.228 GB |467.272 GB |23.12 %|23.12 % |0.000 |{"location" : "default"}| |doris-1.2.0-rc04-Unknown|{"lastSuccessReportTabletsTime":"2022-12-14 10:32:27","lastStreamLoadTime":-1,"isQueryDisabled":false,"isLoadDisabled":false}|0 |mix |
### Anything Else?
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org