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

After rollback() an active transaction is reported by mcsadmin shutdownSystem

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.1.2
    • 1.1.3
    • None
    • None
    • Remote data streaming to MariaDB ColumnStore server
    • 2017-25

    Description

      On a node A, I build the basic_bulk_insert from mariadb-columnstore-api-columnstore-1.1.2 example. Node A has a file /usr/local/mariadb/columnstore/etc/Columnstore.xml from node B that runs MariaDB ColumnStore 1.1.2. The example successfully writes to the test.t1 table
      (and the ColumnStore system reports no active transactions upon a shutdown).

      I modifed the basic_bulk_insert.cpp by replacing the line
      bulk->commit();
      with
      bulk->rollback();

      After executing modified basic_bulk_insert, the MariaDB ColumnStore reports an active transaction upon a shutdown attempt:

      mcsadmin shutdown y
      shutdownsystem   Wed Dec 13 13:15:52 2017
       
      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]:
      

      There is no errors in /var/log/mariadb/columnstore/err.log. The output of the command

      /usr/local/mariadb/columnstore/bin/dbrmctl status
      OK.
      

      Attachments

        Issue Links

          Activity

            People

              dthompson David Thompson (Inactive)
              sasha Sasha V
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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