Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
-
None
Description
I was loading data into Cassandra, and tried to select from it at the same time. I got the following:
MariaDB [test]> show processlist;
|
+----+------+-----------------+------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+----+------+-----------------+------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| 1 | root | localhost | dbt3 | Sleep | 1983 | | NULL | 0.000 |
|
| 2 | root | localhost:38568 | dbt3 | Query | 326 | reading file | LOAD DATA INFILE '/home/ubuntu/dbt3-1.9/s1-cassandra/lineitem.tbl' into table lineitem fields termin | 14.660 |
|
| 3 | root | localhost:38587 | dbt3 | Query | 144 | Waiting for table level lock | select * from lineitem limit 1 | 0.000 |
|
| 4 | root | localhost:38590 | test | Query | 0 | NULL | show processlist | 0.000 |
|
+----+------+-----------------+------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+----------+
|
Is the engine too strict on locking?
Attachments
Issue Links
- is part of
-
MDEV-431 Cassandra storage engine
- Closed