Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2.12
-
None
-
VM CentOS 7.4 ;MemTotal: 16G ; 2CPUs
Description
Deadlock after consecutive tpc-ds query execute
how to repeat:
1. load tpc-ds schema -attached file tpcds.sql
2 .load 1G data ; *note: a smallest data set and querying over is not to performance test
3. start one by one query execution -attached file tpc-ds_query_set.sql
it appear query hanging after ~90 queries were run
note2 : the hanging query does no cause the problem ; after killing and rerun only that query is does not stick
note3: added mysqld stack trace in the attachment
query_id exec_time[ms]
|
query1 5476
|
query2 129025
|
query3 155
|
query4 217666
|
query5 Error with rollup and order by
|
query6 3489
|
query7 33725
|
query8 275440
|
query9 26337
|
query10 47695
|
query11 154767
|
query12 2379
|
query13 5956
|
query14 Error
|
query15 14324
|
query16 67279
|
query17 4752
|
query18 Error
|
query19 676
|
query20 4323
|
query21 38041
|
query22 Error with rollup and order by
|
query23 792367
|
query24 19976
|
query25 4011
|
query26 20594
|
query27 Error with rollup and order by
|
query28 19348
|
query29 3875
|
query30 2762
|
query31 106008
|
query32 72
|
query33 43687
|
query34 40095
|
query35 49031
|
query36 Error with rollup and order by
|
query37 12902
|
query38 57946
|
query39 148487
|
query40 1104
|
query41 2006
|
query42 503
|
query43 35719
|
query44 6617
|
query45 8411
|
query46 46820
|
query47 145513
|
query48 11424
|
query49 789
|
query50 2656
|
query51 Error full outer join
|
query52 554
|
query53 1422
|
query54 99968
|
query55 588
|
query56 3025
|
query57 46472
|
query58 55214
|
query59 77638
|
query60 10213
|
query61 8544
|
query62 15741
|
query63 1439
|
query64 4611
|
query65 54447
|
query66 26477
|
query67 Error with rollup and order by
|
query68 48090
|
query69 49079
|
query70 Error with rollup and order by
|
query71 49355
|
query72 2952775
|
query73 39728
|
query74 149570
|
query75 12586
|
query76 6001
|
query77 Error with rollup and order by
|
query78 202969
|
query79 44942
|
query80 Error with rollup and order by
|
query81 4732
|
query82 12757
|
query83 7409
|
query84 20888
|
query85 1445
|
query86 Error with rollup and order by
|
query87 Error except
|
query88 314646
|
query89 2832
|
query90 18334
|
query91 1446
|
query92 70
|
query93 3119
|
MariaDB [foo]> show processlist ;
|
ERROR 2006 (HY000): MySQL server has gone away
|
No connection. Trying to reconnect...
|
Connection id: 160
|
Current database: foo
|
+-----+-------------+-----------------------+---------+---------+-------+--------------------------+---------------------------- --------------------------------------------------------------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+-----+-------------+-----------------------+---------+---------+-------+--------------------------+---------------------------- --------------------------------------------------------------------------+----------+
|
| 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 1 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |
|
| 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |
|
| 157 | root | 192.168.107.244:57366 | tpcds_1 | Query | 62673 | Sending data | with ws_wh as
|
(select ws1.ws_order_number,ws1.ws_warehouse_sk wh1,ws2.ws_warehouse_sk wh2
|
from web_ | 0.000 |
|
| 160 | root | localhost | foo | Query | 0 | init | show processlist | 0.000 |
|
+-----+-------------+-----------------------+---------+---------+-------+--------------------------+---------------------------- --------------------------------------------------------------------------+----------+
|
7 rows in set (0.00 sec)
|