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

command not found logged during install_calpont_mysql.sh

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 1.1.3
    • None
    • installation
    • None
    • Ubuntu16 repo install

    Description

      During new server install from the Ubuntu16 repository, the /tmp/mysql_install.log has line

      /usr/local/mariadb/columnstore/mysql/install_calpont_mysql.sh: line 27: rows: command not found
      

      This is because /usr/local/mariadb/columnstore/mysql/install_calpont_mysql.sh has line

      `rows` bigint,
      

      https://github.com/mariadb-corporation/mariadb-columnstore-engine/blob/1.1-merge-up/dbcon/mysql/install_calpont_mysql.sh#L99

      Attachments

        Issue Links

          Activity

            I think this error happens when a MariaDB server library is installed on the server. so check to see if this package is installed and if so, You will need to remove before installing and configuring Columnstore

            mariadb-libs

            hill David Hill (Inactive) added a comment - I think this error happens when a MariaDB server library is installed on the server. so check to see if this package is installed and if so, You will need to remove before installing and configuring Columnstore mariadb-libs
            sasha Sasha V added a comment -

            This error happens during fresh install of the new server. I verified that the error also affected 1.1.1 server install. As a result of this bug, the infinidb_querystats.querystats table is missing:

            Server version: 10.2.10-MariaDB-log Columnstore 1.1.1-1
             
            MariaDB [infinidb_querystats]> show tables;
            +-------------------------------+
            | Tables_in_infinidb_querystats |
            +-------------------------------+
            | priority                      |
            | user_priority                 |
            +-------------------------------+
            

            This is because of the use of the --force switch on the line

            $installdir/mysql/bin/mysql --defaults-extra-file=$df --force --user=root mysql 2>/tmp/mysql_install.log <<EOD
            

            https://github.com/mariadb-corporation/mariadb-columnstore-engine/blob/1.1-merge-up/dbcon/mysql/install_calpont_mysql.sh#L27

            To create the querystats table, I placed the CREATE TABLE command (that must have the backquoted `rows` line) into a querystats.sql file that was executed from the modified script install_calpont_mysql.sh.

            sasha Sasha V added a comment - This error happens during fresh install of the new server. I verified that the error also affected 1.1.1 server install. As a result of this bug, the infinidb_querystats.querystats table is missing: Server version: 10.2.10-MariaDB-log Columnstore 1.1.1-1   MariaDB [infinidb_querystats]> show tables; +-------------------------------+ | Tables_in_infinidb_querystats | +-------------------------------+ | priority | | user_priority | +-------------------------------+ This is because of the use of the --force switch on the line $installdir/mysql/bin/mysql --defaults-extra-file=$df --force --user=root mysql 2>/tmp/mysql_install.log <<EOD https://github.com/mariadb-corporation/mariadb-columnstore-engine/blob/1.1-merge-up/dbcon/mysql/install_calpont_mysql.sh#L27 To create the querystats table, I placed the CREATE TABLE command (that must have the backquoted `rows` line) into a querystats.sql file that was executed from the modified script install_calpont_mysql.sh .
            deepvoice Damon added a comment - - edited

            Happening on a fresh install of 1.1.2-1. Loaded from the full version tar - Centos 7
            Can someone post their work-around?

            deepvoice Damon added a comment - - edited Happening on a fresh install of 1.1.2-1. Loaded from the full version tar - Centos 7 Can someone post their work-around?
            sasha Sasha V added a comment - - edited

            I replaced in-place the file /usr/local/mariadb/columnstore/mysql/install_calpont_mysql.sh with two attached files:

            /usr/local/mariadb/columnstore/mysql/install_calpont_mysql.sh
            /usr/local/mariadb/columnstore/mysql/calpont_mysql.sql
            

            then, re-run the postConfigure.

            sasha Sasha V added a comment - - edited I replaced in-place the file /usr/local/mariadb/columnstore/mysql/install_calpont_mysql.sh with two attached files: /usr/local/mariadb/columnstore/mysql/install_calpont_mysql.sh /usr/local/mariadb/columnstore/mysql/calpont_mysql.sql then, re-run the postConfigure.

            the problem seems to be fixed on dev 1.1.7

            winstone Zdravelina Sokolovska (Inactive) added a comment - - edited the problem seems to be fixed on dev 1.1.7

            People

              Unassigned Unassigned
              sasha Sasha V
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.