Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Should clean the memory usage of MemTracker when a hashJoin query ends #34571

Closed
wshwsh12 opened this issue May 11, 2022 · 0 comments · Fixed by #34569
Closed

Should clean the memory usage of MemTracker when a hashJoin query ends #34571

wshwsh12 opened this issue May 11, 2022 · 0 comments · Fixed by #34569
Labels
severity/major sig/execution SIG execution type/bug This issue is a bug.

Comments

@wshwsh12
Copy link
Contributor

wshwsh12 commented May 11, 2022

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

conn-1:

        drop table if exists t;
        create table t (a int);
        drop table if exists ta;
        create table ta (b int);
        insert into t values (1);
        insert into ta values (11);
        drop table if exists session_info;
        create table session_info(id int, connection_id int);
        insert into session_info values (1, 1);
        select * from t, ta;


conn-2:
        select * from information_schema.processlist where command='Sleep';

2. What did you expect to see? (Required)

tidb> select * from information_schema.processlist where command='Sleep';
+-----+------+-----------------+------+---------+------+------------+------+------------------------------------------------------------------+------+------+----------+
| ID  | USER | HOST            | DB   | COMMAND | TIME | STATE      | INFO | DIGEST                                                           | MEM  | DISK | TxnStart |
+-----+------+-----------------+------+---------+------+------------+------+------------------------------------------------------------------+------+------+----------+
| 403 | root | 127.0.0.1:51398 | test | Sleep   |    3 | autocommit | NULL | f6d4ca2ed2b282163cf06ad3a1c36996c1d2ebc999f4ac453057a8de6acd7f96 |    0 |    0 |          |
+-----+------+-----------------+------+---------+------+------------+------+------------------------------------------------------------------+------+------+----------+
1 row in set (0.00 sec)

3. What did you see instead (Required)

tidb> select * from information_schema.processlist where command='Sleep';
+-----+------+-----------------+------+---------+------+------------+------+------------------------------------------------------------------+------+------+----------+
| ID  | USER | HOST            | DB   | COMMAND | TIME | STATE      | INFO | DIGEST                                                           | MEM  | DISK | TxnStart |
+-----+------+-----------------+------+---------+------+------------+------+------------------------------------------------------------------+------+------+----------+
| 403 | root | 127.0.0.1:49459 | test | Sleep   |    3 | autocommit | NULL | f6d4ca2ed2b282163cf06ad3a1c36996c1d2ebc999f4ac453057a8de6acd7f96 | 1176 |    0 |          |
+-----+------+-----------------+------+---------+------+------------+------+------------------------------------------------------------------+------+------+----------+

4. What is your TiDB version? (Required)

Only master
introduced by d63a5fd

@wshwsh12 wshwsh12 added type/bug This issue is a bug. sig/execution SIG execution severity/major labels May 11, 2022
@ti-chi-bot ti-chi-bot added may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.0 labels May 11, 2022
@wshwsh12 wshwsh12 removed may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. may-affects-6.0 labels May 11, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
severity/major sig/execution SIG execution type/bug This issue is a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants