Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-530

Cassandra SE: Locking is incorrect

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      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

            Activity

              People

              • Assignee:
                psergey Sergei Petrunia
                Reporter:
                psergey Sergei Petrunia
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: