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:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
