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 2021/04/27 06:48:47 UTC
[GitHub] [incubator-doris] caiconghui opened a new issue #5711: [Bug] Drop olap table when olap table's state is not normal introduce problem when user recover table
caiconghui opened a new issue #5711:
URL: https://github.com/apache/incubator-doris/issues/5711
**Describe the bug**
when olap table's state is not normal, it means some operations on table is on going, but if we drop table without check, it may cause problem when we recover table, for example, if we drop olap table when olap table is under alter operation, and then revover it , we may see that table is always SCHEMA_CHANGE and cause memory leak for that alter tablet may stay in memory.
**To Reproduce**
Steps to reproduce the behavior:
1. create a olap table
2. add column from olap table
3. drop table
4. after a while, revover table
mysql> alter table test3 add column tt3 int;
ERROR 1064 (HY000): errCode = 2, detailMessage = Table[test3]'s state is not NORMAL. Do not allow doing ALTER ops
mysql>
mysql> show tablet from test3;
+----------+-----------+-----------+------------+---------+---------------------+-------------------+-----------------------+------------------+----------------------+---------------+----------+----------+--------+-------------------------+--------------+------------------+--------------+----------------------+-----------------------------------------------------------+-------------------------------------------------------------------------------------+
| TabletId | ReplicaId | BackendId | SchemaHash | Version | VersionHash | LstSuccessVersion | LstSuccessVersionHash | LstFailedVersion | LstFailedVersionHash | LstFailedTime | DataSize | RowCount | State | LstConsistencyCheckTime | CheckVersion | CheckVersionHash | VersionCount | PathHash | MetaUrl | CompactionStatus |
+----------+-----------+-----------+------------+---------+---------------------+-------------------+-----------------------+------------------+----------------------+---------------+----------+----------+--------+-------------------------+--------------+------------------+--------------+----------------------+-----------------------------------------------------------+-------------------------------------------------------------------------------------+
| 15014 | 15015 | 10003 | 1941393283 | 3 | 1775851936448869264 | 3 | 1775851936448869264 | -1 | 0 | NULL | 637 | 3 | NORMAL | NULL | -1 | -1 | 1 | -5868617767367913971 | http://10.231.57.96:8040/api/meta/header/15014/1941393283 | http://10.231.57.96:8040/api/compaction/show?tablet_id=15014&schema_hash=1941393283 |
| 15033 | 15034 | 10003 | 481215067 | 1 | 0 | 1 | 0 | -1 | 0 | NULL | 0 | 0 | ALTER | NULL | -1 | -1 | 1 | -5868617767367913971 | http://10.231.57.96:8040/api/meta/header/15033/481215067 | http://10.231.57.96:8040/api/compaction/show?tablet_id=15033&schema_hash=481215067 |
+----------+-----------+-----------+------------+---------+---------------------+-------------------+-----------------------+------------------+----------------------+---------------+----------+----------+--------+-------------------------+--------------+------------------+--------------+----------------------+-----------------------------------------------------------+-------------------------------------------------------------------------------------+
2 rows in set (0.01 sec)
**Expected behavior**
the table is normal when recovered
**Screenshots**
If applicable, add screenshots to help explain your problem.
**Desktop (please complete the following information):**
- OS: [e.g. iOS]
- Browser [e.g. chrome, safari]
- Version [e.g. 22]
**Smartphone (please complete the following information):**
- Device: [e.g. iPhone6]
- OS: [e.g. iOS8.1]
- Browser [e.g. stock browser, safari]
- Version [e.g. 22]
**Additional context**
Add any other context about the problem here.
--
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.
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
[GitHub] [incubator-doris] morningman closed issue #5711: [Bug] Drop olap table when olap table's state is not normal may introduce problem when user recover table
Posted by GitBox <gi...@apache.org>.
morningman closed issue #5711:
URL: https://github.com/apache/incubator-doris/issues/5711
--
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.
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