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

Mariadb columnstore System is given in ACTIVE Status nevertheless many cs processes are not active and sql returns internal errors

    XMLWordPrintable

    Details

      Description

      Mariadb columnstore System is given in ACTIVE Status nevertheless many cs processes are not active and sql returns internal errors

      expected : mcsadmin getsystemstatus returns ACTIVE Status for columnstore System
      when all cs functionality is active , respectively the expected mcs processes on columnstore Modules are Active.

      how to repeat :
      Problem was observed in 1UM-2PMs cs installation with enabled local query .System was functional , then reboot the UM module ;
      check the MariaDB columnstore status with the mcsadmin utility – it's returned Active
      but when it was performed from the UM even simple math sql statement or try to create table with engine columnstore are returned Errors

      [root@cps ~]#  mcsadmin getsystemstatus
       
      WARNING: running on non Parent OAM Module, can't make configuration changes in this session.
               Access Console from 'pm1' if you need to make changes.
       
      getsystemstatus   Wed Apr 24 12:40:42 2019
       
      System columnstore-1
       
      System and Module statuses
       
      Component     Status                       Last Status Change
      ------------  --------------------------   ------------------------
      System        ACTIVE                       Wed Apr 24 12:19:19 2019
       
      Module um1    ACTIVE                       Wed Apr 24 12:19:19 2019
      Module pm1    ACTIVE                       Wed Apr 24 12:19:19 2019
      Module pm2    ACTIVE                       Wed Apr 24 12:19:20 2019
       
      Active Parent OAM Performance Module is 'pm1'
      Local Query Feature is enabled
      MariaDB ColumnStore Replication Feature is enabled
      MariaDB ColumnStore set for Distributed Install
       
      
      

      MariaDB [(none)]> select 16200 * 8 ;
      ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'infinidb_vtable'
      
      

      MariaDB [(none)]> create table a1.a1 ( a int) engine columnstore ;
      ERROR 1815 (HY000): Internal error: Lost connection to DDLProc
      
      

      get detailed information with mcsadmin about the system status
      it's seen that those are many cs processes in AUTO_OFFLINE state but the entire system status is wrongly considered Active

      [root@cps ~]# mcsadmin getsystemi;
       
      WARNING: running on non Parent OAM Module, can't make configuration changes in this session.
               Access Console from 'pm1' if you need to make changes.
       
      getsysteminfo   Wed Apr 24 12:39:08 2019
       
      System columnstore-1
       
      System and Module statuses
       
      Component     Status                       Last Status Change
      ------------  --------------------------   ------------------------
      System        ACTIVE                       Wed Apr 24 12:19:19 2019
       
      Module um1    ACTIVE                       Wed Apr 24 12:19:19 2019
      Module pm1    ACTIVE                       Wed Apr 24 12:19:19 2019
      Module pm2    ACTIVE                       Wed Apr 24 12:19:20 2019
       
      Active Parent OAM Performance Module is 'pm1'
      Local Query Feature is enabled
      MariaDB ColumnStore Replication Feature is enabled
      MariaDB ColumnStore set for Distributed Install
       
       
      MariaDB ColumnStore Process statuses
       
      Process             Module    Status            Last Status Change        Process ID
      ------------------  ------    ---------------   ------------------------  ----------
      ProcessMonitor      um1       ACTIVE            Wed Apr 24 12:18:20 2019        5836
      ServerMonitor       um1       AUTO_OFFLINE      Wed Apr 24 12:16:04 2019
      DBRMWorkerNode      um1       ACTIVE            Wed Apr 24 12:18:36 2019        6090
      ExeMgr              um1       ACTIVE            Wed Apr 24 12:19:07 2019        6313
      DDLProc             um1       AUTO_OFFLINE      Wed Apr 24 12:16:04 2019
      DMLProc             um1       AUTO_OFFLINE      Wed Apr 24 12:16:04 2019
      mysqld              um1       ACTIVE            Wed Apr 24 12:19:19 2019        6571
       
      ProcessMonitor      pm1       ACTIVE            Mon Apr 22 13:10:43 2019       18256
      ProcessManager      pm1       ACTIVE            Mon Apr 22 13:10:49 2019       18399
      DBRMControllerNode  pm1       ACTIVE            Wed Apr 24 12:18:33 2019         753
      ServerMonitor       pm1       ACTIVE            Mon Apr 22 13:11:44 2019       20176
      DBRMWorkerNode      pm1       ACTIVE            Wed Apr 24 12:18:40 2019         923
      PrimProc            pm1       ACTIVE            Wed Apr 24 12:18:49 2019        1063
      ExeMgr              pm1       MAN_OFFLINE       Wed Apr 24 12:13:42 2019
      WriteEngineServer   pm1       ACTIVE            Wed Apr 24 12:19:02 2019        1324
      mysqld              pm1       ACTIVE            Wed Apr 24 12:19:19 2019        1770
       
      ProcessMonitor      pm2       ACTIVE            Mon Apr 22 13:11:35 2019       28401
      ProcessManager      pm2       HOT_STANDBY       Mon Apr 22 13:11:36 2019       28515
      DBRMControllerNode  pm2       COLD_STANDBY      Wed Apr 24 12:18:32 2019
      ServerMonitor       pm2       ACTIVE            Mon Apr 22 13:11:53 2019       28902
      DBRMWorkerNode      pm2       ACTIVE            Wed Apr 24 12:18:45 2019       25533
      PrimProc            pm2       ACTIVE            Wed Apr 24 12:18:53 2019       25619
      ExeMgr              pm2       MAN_OFFLINE       Wed Apr 24 12:13:42 2019
      WriteEngineServer   pm2       ACTIVE            Wed Apr 24 12:19:03 2019       25747
      mysqld              pm2       ACTIVE            Wed Apr 24 12:19:20 2019       26074
       
      Active Alarm Counts: Critical = 0, Major = 3, Minor = 2, Warning = 0, Info = 0
       
      
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            winstone Zdravelina Sokolovska (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.