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

            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

            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.

            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.

            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.