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

viewtablelock does not shows active locking though shutdownSystem command says there is one.

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 1.2.5
    • Icebox
    • None
    • None

    Description

      When running `shutdownsystem` command, it shows `There are active transactions being processed`, but when checking viewtablelock, it shows there is nothing.

      [root@host ~]# /usr/local/mariadb/columnstore/bin/viewtablelock
      No tables are locked in the database.
       
      mcsadmin> shutdownsystem y
      shutdownsystem Tue Jan 25 23:49:38 2022
       
      This command stops the processing of applications on all Modules within the MariaDB ColumnStore System
       
      Checking for active transactions
       
      There are active transactions being processed
      Your options are:
      Cancel -- Cancel the shutdown request
      Wait -- Wait for write operations to end and then shutdown
      Force -- Force a shutdown
      What would you like to do: [Cancel]:
      

      And of course, show processlist and `mcsadmin getActiveSQLStatements` show nothing is running.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              allen.lee@mariadb.com Allen Lee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.