Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-2093

cleartablelock is allowed during mcsapi transaction but it breaks with what(): Error rolling back BRM and cannot be restarted

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Icebox
    • Component/s: mcsapi, mcsimport
    • Labels:
      None
    • Environment:
      single server

      Description

      cleartablelock is allowed during mcsapi transaction but it breaks with what(): Error rolling back BRM and cannot be restarted

      note: the same is not observed with cpimport as cleartablelock is rejected during cpimport activities with error" Rollback error: Unable to grab lock; Lock not found or still in use.Table lock xxx for table xx.yy is not cleared."

      /usr/local/mariadb/columnstore/tools/mcsimport/mcsimport mytest lineitem  tests/tests_2019-01-17--16-44-30_LOAD_DATA_IN_FILE/features/cpimportLineitem/lineitem.tbl  -c Columnstore.xml -d "|"
      

      from CS Module

      [root@pm1 ~]# /usr/local/mariadb/columnstore/bin/viewtablelock
       There is 1 table lock
       
        Table            LockID  Process  PID    Session  Txn   CreationTime              State    DBRoots
        mytest.lineitem  51      mcsapi   11786  73608    7599  Fri Jan 18 15:57:28 2019  LOADING  1
      [root@pm1 ~]# /usr/local/mariadb/columnstore/bin/cleartablelock  51
      Rolling back and clearing table lock for table mytest.lineitem; table lock 51
       
      Sending rollback request to PM1...
      Successful rollback response from PM1
      Sending cleanup request to PM1...
      Successful cleanup response from PM1
       
      Table lock 51 for table mytest.lineitem is cleared.
      [root@pm1 ~]#
      
      

      /usr/local/mariadb/columnstore/tools/mcsimport/mcsimport mytest lineitem  tests/tests_2019-01-17--16-44-30_LOAD_DATA_IN_FILE/features/cpimportLineitem/lineitem.tbl  -c Columnstore.xml -d "|"
      Error during mcsapi bulk operation:  Failed to read from a compressed data file.
      terminate called after throwing an instance of 'mcsapi::ColumnStoreServerError'
        what():  Error rolling back BRM
      Aborted
      
      

      
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            winstone Zdravelina Sokolovska (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.