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

Columnstore System Status remains Active and any Alarms are not set if mcs become not write capable

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • None
    • Icebox
    • writeengine
    • None
    • GKE

    Description

      Columnstore System Status remains Active if mcs become not write capable

      that issue was observed with DBAAS Columnstore SingleNode deployment
      Columnstore System started to return Errors when try to insert data , but that problem is not
      detected in mcsadmin System Status and any Alarms are not set

      s$ mariadb --host=sky0001379.mdb0001293.test.skysql.net     --port=5001 --user=DB00002091   --password='xxxxxx'  --ssl=1 -e "create database abc ; create table abc.abc ( a int , b varchar(64)) engine columnstore ;")
       
      $ mariadb --host=sky0001379.mdb0001293.test.skysql.net     --port=5001 --user=DB00002091   --password='xxxxxxxx'  --ssl=1 -e "insert into abc.abc values (1,'aa'),(2,'bbb'), (3,'cccc'); "
      ERROR 1815 (HY000) at line 1: Internal error: CAL0001: Insert Failed:  Error occured when calling makeJobList
      

      from the Columnstore PM Pod : columnstore System is in Active Status , any Alarms are set

      [root@expmcs0001-mdb-cs-single-0 /]# mcsadmin getsystemi
      getsysteminfo   Mon Jan  6 11:35:43 2020
       
      System columnstore-1
       
      System and Module statuses
       
      Component     Status                       Last Status Change
      ------------  --------------------------   ------------------------
      System        ACTIVE                       Thu Jan  2 12:48:21 2020
       
      Module pm1    ACTIVE                       Thu Jan  2 11:32:54 2020
       
       
      MariaDB ColumnStore Process statuses
       
      Process             Module    Status            Last Status Change        Process ID
      ------------------  ------    ---------------   ------------------------  ----------
      ProcessMonitor      pm1       ACTIVE            Thu Jan  2 11:32:06 2020         101
      ProcessManager      pm1       ACTIVE            Thu Jan  2 11:32:13 2020         208
      StorageManager      pm1       ACTIVE            Thu Jan  2 12:07:18 2020       13702
      DBRMControllerNode  pm1       ACTIVE            Thu Jan  2 12:47:59 2020       26541
      ServerMonitor       pm1       ACTIVE            Thu Jan  2 11:32:35 2020         780
      DBRMWorkerNode      pm1       ACTIVE            Thu Jan  2 11:32:36 2020         801
      PrimProc            pm1       ACTIVE            Thu Jan  2 11:32:40 2020         891
      ExeMgr              pm1       ACTIVE            Thu Jan  2 11:32:44 2020         962
      WriteEngineServer   pm1       ACTIVE            Thu Jan  2 12:11:01 2020       16610
      DDLProc             pm1       ACTIVE            Thu Jan  2 12:48:09 2020       26681
      DMLProc             pm1       ACTIVE            Thu Jan  2 12:48:20 2020       26799
      mysqld              pm1       ACTIVE            Thu Jan  2 11:32:14 2020         511
       
      Active Alarm Counts: Critical = 0, Major = 0, Minor = 0, Warning = 0, Info = 0
      

      Attachments

        1. columnstoreSupportReport.columnstore-1-all.tar.gz
          164 kB
          Zdravelina Sokolovska
        2. core.editem.7z
          395 kB
          Zdravelina Sokolovska

        Issue Links

          Activity

            People

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