Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-10897

Blocked drop table operations cause strange issues

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 2.6, 2.7
    • None
    • sql
    • None

    Description

      Reproduce steps to get a blocked drop table operation:

      1.Create a table and put some data to a node with persistence enabled. 
      2.Do a select query targeting on the table which runs long time. 
      3.Drop the table before the select query end. 
      Then u will see drop table operation blocks until the select query end.

      A strange issue cause by blocked drop table operations:

      1.Do another drop table operation when there is a blocked drop table operation.This operation will also block.

      2.Try to recreate the table with same name.Then you can see "table 
      already exists" exception. 

      3.Try to drop the table again,then you can see 
      "Table doesn't exist" exception. 

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            1371549332@qq.com JiajunYang
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated: