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

DMLProc rollback took 10 minutes when there are 0 tables to rollback, non-root install

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • None
    • N/A
    • N/A
    • None
    • amazon EC2 centos 7 - 2um/1pm with local query

    Description

      started with um1 Active on a 2um/1pm system with local query set. Non-root install using local disk.

      1. stopped instance um1
      2. um2 was failed over and made the Active UM. DMLProc gets restarted during this process so it cam run the rollback and the DMLProc will show BUSY_INIT during this process.
      3. DMLproc showed BUSY_INIT for than 10 minutes and logs showed rollback didn't complete.

      Component Status Last Status Change
      ------------ -------------------------- ------------------------
      System BUSY_INIT Mon Oct 23 15:53:50 2017

      Module um1 AUTO_DISABLED/DEGRADED Mon Oct 23 15:53:31 2017
      Module um2 ACTIVE Mon Oct 23 15:53:51 2017
      Module pm1 ACTIVE Mon Oct 23 15:44:58 2017

      Active Parent OAM Performance Module is 'pm1'
      Primary Front-End MariaDB ColumnStore Module is 'um2'
      Local Query Feature is enabled
      MariaDB ColumnStore Replication Feature is enabled

      MariaDB ColumnStore Process statuses

      Process Module Status Last Status Change Process ID
      ------------------ ------ --------------- ------------------------ ----------
      ProcessMonitor um1 AUTO_OFFLINE Mon Oct 23 15:53:31 2017
      ServerMonitor um1 AUTO_OFFLINE Mon Oct 23 15:53:31 2017
      DBRMWorkerNode um1 AUTO_OFFLINE Mon Oct 23 15:53:31 2017
      ExeMgr um1 AUTO_OFFLINE Mon Oct 23 15:53:31 2017
      DDLProc um1 AUTO_OFFLINE Mon Oct 23 15:53:31 2017
      DMLProc um1 AUTO_OFFLINE Mon Oct 23 15:53:31 2017
      mysqld um1 AUTO_OFFLINE Mon Oct 23 15:53:31 2017

      ProcessMonitor um2 ACTIVE Mon Oct 23 15:44:36 2017 11625
      ServerMonitor um2 ACTIVE Mon Oct 23 15:44:51 2017 12081
      DBRMWorkerNode um2 ACTIVE Mon Oct 23 15:44:53 2017 12107
      ExeMgr um2 ACTIVE Mon Oct 23 15:53:35 2017 13973
      DDLProc um2 ACTIVE Mon Oct 23 15:53:44 2017 14013
      DMLProc um2 BUSY_INIT Mon Oct 23 15:53:50 2017 14026
      mysqld um2 ACTIVE Mon Oct 23 15:54:00 2017 13022

      ProcessMonitor pm1 ACTIVE Mon Oct 23 15:44:27 2017 6913
      ProcessManager pm1 ACTIVE Mon Oct 23 15:44:33 2017 7069
      DBRMControllerNode pm1 ACTIVE Mon Oct 23 15:44:43 2017 7803
      ServerMonitor pm1 ACTIVE Mon Oct 23 15:44:45 2017 7835
      DBRMWorkerNode pm1 ACTIVE Mon Oct 23 15:44:45 2017 7888
      DecomSvr pm1 ACTIVE Mon Oct 23 15:44:49 2017 8070
      PrimProc pm1 ACTIVE Mon Oct 23 15:44:51 2017 8166
      ExeMgr pm1 ACTIVE Mon Oct 23 15:53:39 2017 24025
      WriteEngineServer pm1 ACTIVE Mon Oct 23 15:44:59 2017 8579
      mysqld pm1 ACTIVE Mon Oct 23 15:48:26 2017 15057

      Active Alarm Counts: Critical = 1, Major = 1, Minor = 0, Warning = 0, Info = 0

      Oct 23 15:53:46 ip-172-30-0-152 DMLProc[14026]: 46.224661 |0|0|0| I 20 CAL0002: DMLProc starts rollbackAll.
      Oct 23 15:53:46 ip-172-30-0-152 DMLProc[14026]: 46.235930 |0|0|0| I 20 CAL0002: DMLProc will rollback 0 tables.
      Oct 23 15:53:47 ip-172-30-0-152 ProcessMonitor[11625]: 47.193851 |0|0|0| I 18 CAL0000: MSG RECEIVED: Start All process request...
      Oct 23 15:53:47 ip-172-30-0-152 ProcessMonitor[11625]: 47.240041 |0|0|0| I 18 CAL0000: STARTALL: ACK back to ProcMgr, return status = 0

      Oct 23 16:03:35 ip-172-30-0-152 DMLProc[14026]: 35.587322 |0|0|0| I 20 CAL0002: DMLProc finished rollbackAll.

      Attachments

        Activity

          People

            toddstoffel Todd Stoffel (Inactive)
            hill David Hill (Inactive)
            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.