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

Backup/restore test500 needs to wait until mcs online before making any query

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 23.10.1
    • N/A
    • regression suite
    • None

    Description

      tes500 results diff.
      < after_restore_lineitem_count: 6001215
      < after_restore_sum_quantity: 153078795.00
      \ No newline at end of file

      > after_restore_lineitem_count:
      > after_restore_sum_quantity:

      more checks need to happen here to know columnstore is online before querying .

      Attachments

        Activity

          susil.behera Susil Behera added a comment -

          Local run on a rockylinux 8 single node MCS setup has passed.

          susil.behera Susil Behera added a comment - Local run on a rockylinux 8 single node MCS setup has passed.
          susil.behera Susil Behera added a comment -

          In some setups like on GCP we may need to wait until mcssystemready. This change needs to be done in the following script.

          — a/mysql/queries/nightly/scripts/oamCommands.sh
          +++ b/mysql/queries/nightly/scripts/oamCommands.sh
          @@ -43,6 +43,7 @@ startSystem() {
          systemctl start mcs-storagemanager
          systemctl start mariadb-columnstore
          systemctl start mariadb
          + until [[ $(mariadb -N -e 'SELECT mcssystemready()') == 1 ]]; do sleep 30; done

          susil.behera Susil Behera added a comment - In some setups like on GCP we may need to wait until mcssystemready. This change needs to be done in the following script. — a/mysql/queries/nightly/scripts/oamCommands.sh +++ b/mysql/queries/nightly/scripts/oamCommands.sh @@ -43,6 +43,7 @@ startSystem() { systemctl start mcs-storagemanager systemctl start mariadb-columnstore systemctl start mariadb + until [[ $(mariadb -N -e 'SELECT mcssystemready()') == 1 ]]; do sleep 30; done

          That's diagnostic, that can be helpful if we face test500 instability

          leonid.fedorov Leonid Fedorov added a comment - That's diagnostic, that can be helpful if we face test500 instability

          People

            kirill.perov@mariadb.com Kirill Perov (Inactive)
            susil.behera Susil Behera
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.