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

mcssystemready() is returning inaccurate value

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 6.4.1
    • None
    • None

    Description

      [root@mcs1 /]# mariadb -e "SELECT mcssystemready()"
      +------------------+
      | mcssystemready() |
      +------------------+
      |                1 |
      +------------------+
      [root@mcs1 /]# mariadb -e "SELECT * FROM test.t1"
      +------+
      | id   |
      +------+
      |   99 |
      |   77 |
      +------+
      [root@mcs1 /]# mcsShutdown
      {
        "timestamp": "2022-04-28 19:10:59.906225",
        "mcs1": {
          "timestamp": "2022-04-28 19:11:09.419228"
        },
        "mcs2": {
          "timestamp": "2022-04-28 19:11:12.840278"
        },
        "mcs3": {
          "timestamp": "2022-04-28 19:11:16.240289"
        }
      }
      [root@mcs1 /]# mariadb -e "SELECT mcssystemready()"
      +------------------+
      | mcssystemready() |
      +------------------+
      |                1 |
      +------------------+
      [root@mcs1 /]# mariadb -e "SELECT * FROM test.t1"
      ERROR 1815 (HY000) at line 1: Internal error: DBRM is not responding. Cannot accept queries
      

      Attachments

        Issue Links

          Activity

            toddstoffel Todd Stoffel (Inactive) created issue -
            toddstoffel Todd Stoffel (Inactive) made changes -
            Field Original Value New Value
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Assignee Ben Thompson [ ben.thompson ]
            toddstoffel Todd Stoffel (Inactive) made changes -
            Fix Version/s 6.4.1 [ 26046 ]
            toddstoffel Todd Stoffel (Inactive) made changes -
            Attachment mariadb-error.log [ 63392 ]
            ben.thompson Ben Thompson (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            ben.thompson Ben Thompson (Inactive) made changes -
            Assignee Ben Thompson [ ben.thompson ] David Hall [ david.hall ]
            Status In Progress [ 3 ] In Review [ 10002 ]

            Ok.. i will ignore for the API Key issue.

            David.Hall please review and lets move to test

            alexey.vorovich alexey vorovich (Inactive) added a comment - Ok.. i will ignore for the API Key issue. David.Hall please review and lets move to test
            alexey.vorovich alexey vorovich (Inactive) made changes -

            QA: The function works correctly if Columnstore is up but not yet ready. It returns true (when it should be false) if columnstore is down or in the very early stages of being started. This patch should fix it to work in all cases.

            David.Hall David Hall (Inactive) added a comment - QA: The function works correctly if Columnstore is up but not yet ready. It returns true (when it should be false) if columnstore is down or in the very early stages of being started. This patch should fix it to work in all cases.
            David.Hall David Hall (Inactive) made changes -
            Status In Review [ 10002 ] In Testing [ 10301 ]
            David.Hall David Hall (Inactive) made changes -
            Assignee David Hall [ david.hall ] Daniel Lee [ dleeyh ]

            Build verified: Drone #4472

            In a script to check for mcssystemready() return value before and after mcsShutdown and mcsStart. Repeated the test many times and returned values were correct.

            dleeyh Daniel Lee (Inactive) added a comment - Build verified: Drone #4472 In a script to check for mcssystemready() return value before and after mcsShutdown and mcsStart. Repeated the test many times and returned values were correct.
            dleeyh Daniel Lee (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status In Testing [ 10301 ] Closed [ 6 ]

            People

              dleeyh Daniel Lee (Inactive)
              toddstoffel Todd Stoffel (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.