Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 1.0.4
    • 1.0.5
    • ?
    • None
    • amazon ec2 centos 7
      virtualbox cento7
    • 2016-22, 2016-23

    Description

      Was planning on setting up out Amazon AMI to be a non-root install and continued to get errors when I tried to launch. Then tried to run on regular centos7 VM, and get the same error. The same binary package works as root user install

      Will test to see of problem happens on other OSs

      The issue is postConfigure fails at starting up the system, single serve install

      Log files point to an messaging error were a procmon thread isnt servicing the API request to get/set status. And this procmon and provmgr reports failures cauings the system not to start

      Starting MariaDB Columnstore Database Platform

      MariaDB Columnstore Database Platform Starting, please wait ... FAILED

      ERROR: MariaDB Columnstore Process failed to start, check log files in /var/log/mariadb/columnstore

      Nov 11 14:16:46 centos7 oamcpp[729]: 46.839496 |0|0|0| E 08 CAL0000: getSystemStatus: final exception: API Failure return in getSystemStatus write API
      Nov 11 14:16:46 centos7 oamcpp[729]: 46.839584 |0|0|0| E 08 CAL0000: getSystemStatus: write exception: InetStreamSocket::connect: connect() error: Connection refused to: InetStre

      Nov 8 03:31:27 centos7 messagequeue[4076]: 27.538974 |0|0|0| W 31 CAL0071: InetStreamSocket::read: timeout during readToMagic: socket read error: Success; InetStreamSocket: sd:

      Attachments

        Activity

          Tried a 2 node combined install, local disk on centos 7. Everything goes well until starting up the cluster. The script fails because the rsync command is using the root user rather than my test user mcs:

          3:33]
          ----- Starting MariaDB Columnstore on local server -----

          MariaDB Columnstore successfully started

          MariaDB Columnstore Database Platform Starting, please wait ....... DONE

          Run MariaDB Columnstore Replication Setup.. ERROR: Error return in running the MariaDB Columnstore Master DB Distribute, check /tmp/master-dist.logs on pm1

          MariaDB Columnstore Install Failed

          [3:33]
          log file is:

          [3:33]
          rsync -vopgr -e ssh --exclude=mysql/ --exclude=test/ --exclude=infinidb_vtable/ --exclude=infinidb_querystats/ --exclude=calpontsys/ --include=/ --include=/* --exclude=* /home/mcs/mariadb/columnstore/mysql/db/ root@172.21.21.3:/home/mcs/mariadb/columnstore/mysql/db/
          ESC]0;mcs@centos7:~^GESC[?1034h[mcs@centos7 ~]$ rsync -vopgr -e ssh --exclude=mysql/ --exclude=test/ --exclude=infinidb_vtable/ --exclude=infinidb_querystats/ --exclude=calpontsys/ --include=/ - ^M-include=/* --exclude=* /home/mcs/mariadb/columnstore/mysql/db/ root@172.21.21.3:/home/mcs/mariadb/columnstore/mysql/db/
          root@172.21.21.3's password:
          Permission denied, please try again.^M
          root@172.21.21.3's password: FAILED: Invalid password

          [3:33]
          i.e. it is incorrectly trying to use root rather than my mcs user

          dthompson David Thompson (Inactive) added a comment - Tried a 2 node combined install, local disk on centos 7. Everything goes well until starting up the cluster. The script fails because the rsync command is using the root user rather than my test user mcs: 3:33] ----- Starting MariaDB Columnstore on local server ----- MariaDB Columnstore successfully started MariaDB Columnstore Database Platform Starting, please wait ....... DONE Run MariaDB Columnstore Replication Setup.. ERROR: Error return in running the MariaDB Columnstore Master DB Distribute, check /tmp/master-dist.logs on pm1 MariaDB Columnstore Install Failed [3:33] log file is: [3:33] rsync -vopgr -e ssh --exclude=mysql/ --exclude=test/ --exclude=infinidb_vtable/ --exclude=infinidb_querystats/ --exclude=calpontsys/ --include= / --include= /* --exclude=* /home/mcs/mariadb/columnstore/mysql/db/ root@172.21.21.3:/home/mcs/mariadb/columnstore/mysql/db/ ESC]0;mcs@centos7:~^GESC[?1034h [mcs@centos7 ~] $ rsync -vopgr -e ssh --exclude=mysql/ --exclude=test/ --exclude=infinidb_vtable/ --exclude=infinidb_querystats/ --exclude=calpontsys/ --include= / - ^M-include= /* --exclude=* /home/mcs/mariadb/columnstore/mysql/db/ root@172.21.21.3:/home/mcs/mariadb/columnstore/mysql/db/ root@172.21.21.3's password: Permission denied, please try again.^M root@172.21.21.3's password: FAILED: Invalid password [3:33] i.e. it is incorrectly trying to use root rather than my mcs user
          dthompson David Thompson (Inactive) added a comment - - edited

          also pre-uninstall fails with errors because it assumes /usr/local install. Changing the prefix variable fixes that.

          dthompson David Thompson (Inactive) added a comment - - edited also pre-uninstall fails with errors because it assumes /usr/local install. Changing the prefix variable fixes that.

          The pre-uninstall works just like the post-install, you have to pass it the install dir path

          ./mariadb/columnstore/bin/pre-uninstall --installdir=$HOME/mariadb/columnstore

          hill David Hill (Inactive) added a comment - The pre-uninstall works just like the post-install, you have to pass it the install dir path ./mariadb/columnstore/bin/pre-uninstall --installdir=$HOME/mariadb/columnstore

          fixed the mysql-rep setup issue.... Fix is in the mcol-61 repo, which is for the amazona AMI feature... So the there MCOL-404 non-root install fixes will be checked into develop when the MCOL-61 is checked into root...

          But did competed a non-root multi-node combo install, but still more testing will be done before passing on to review and test

          MariaDB Columnstore Database Platform Starting, please wait ....... DONE

          Run MariaDB Columnstore Replication Setup.. DONE

          MariaDB Columnstore Install Successfully Completed, System is Active

          Enter the following command to define MariaDB Columnstore Alias Commands

          . /home/centos/mariadb/columnstore/bin/columnstoreAlias

          Enter 'mcsmysql' to access the MariaDB Columnstore SQL console
          Enter 'mcsadmin' to access the MariaDB Columnstore Admin console

          hill David Hill (Inactive) added a comment - fixed the mysql-rep setup issue.... Fix is in the mcol-61 repo, which is for the amazona AMI feature... So the there MCOL-404 non-root install fixes will be checked into develop when the MCOL-61 is checked into root... But did competed a non-root multi-node combo install, but still more testing will be done before passing on to review and test MariaDB Columnstore Database Platform Starting, please wait ....... DONE Run MariaDB Columnstore Replication Setup.. DONE MariaDB Columnstore Install Successfully Completed, System is Active Enter the following command to define MariaDB Columnstore Alias Commands . /home/centos/mariadb/columnstore/bin/columnstoreAlias Enter 'mcsmysql' to access the MariaDB Columnstore SQL console Enter 'mcsadmin' to access the MariaDB Columnstore Admin console

          development branch has been updated with fixes for the non-root multi-node install.
          Some came in during the merge of mcol-61 branch and others were made after the fact..

          commit 9ce117f521cf8335ebcbc17ddd1b2445b42f8c2a
          Author: David Hill <david.hill@mariadb.com>
          Date: Sun Nov 20 22:47:54 2016 +0000

          MCOL-61, ami install

          oam/oamcpp/liboamcpp.cpp | 24 ++++-
          oamapps/postConfigure/postConfigure.cpp | 165 ++++++++++++++++++---------------
          2 files changed, 109 insertions, 80 deletions

          commit 591ff9326fecada2f9e299ef5fa013a875749592
          Author: David Hill <david.hill@mariadb.com>
          Date: Sun Nov 20 17:52:57 2016 +0000

          mcol-404

          oamapps/postConfigure/postConfigure.cpp | 37 +++++++++++++++-------------------
          1 file changed, 16 insertions, 21 deletions

          commit 02a5624cb34674d1fc1f526f574c191187438c36
          Author: David Hill <david.hill@mariadb.com>
          Date: Sun Nov 20 16:29:42 2016 +0000

          MCOL-404 AND MCOL-61

          oam/install_scripts/master-rep-columnstore.sh | 7 ++-
          oam/install_scripts/slave-rep-columnstore.sh | 7 ++-
          oamapps/postConfigure/postConfigure.cpp | 72 +++++++++-------------------
          3 files changed, 32 insertions, 54 deletions

          commit 90706f1c93cb86604ecd6c1d5a3e8ef917d99ed5
          Merge: 90ea3e2 3affcd4
          Author: David Hill <david.hill@mariadb.com>
          Date: Sun Nov 20 01:42:29 2016 +0000

          Merge branch 'mcol-61' into develop

          hill David Hill (Inactive) added a comment - development branch has been updated with fixes for the non-root multi-node install. Some came in during the merge of mcol-61 branch and others were made after the fact.. commit 9ce117f521cf8335ebcbc17ddd1b2445b42f8c2a Author: David Hill <david.hill@mariadb.com> Date: Sun Nov 20 22:47:54 2016 +0000 MCOL-61 , ami install oam/oamcpp/liboamcpp.cpp | 24 ++++- oamapps/postConfigure/postConfigure.cpp | 165 ++++++++++++++++++--------------- 2 files changed, 109 insertions , 80 deletions commit 591ff9326fecada2f9e299ef5fa013a875749592 Author: David Hill <david.hill@mariadb.com> Date: Sun Nov 20 17:52:57 2016 +0000 mcol-404 oamapps/postConfigure/postConfigure.cpp | 37 +++++++++++++++------------------- 1 file changed, 16 insertions , 21 deletions commit 02a5624cb34674d1fc1f526f574c191187438c36 Author: David Hill <david.hill@mariadb.com> Date: Sun Nov 20 16:29:42 2016 +0000 MCOL-404 AND MCOL-61 oam/install_scripts/master-rep-columnstore.sh | 7 ++- oam/install_scripts/slave-rep-columnstore.sh | 7 ++- oamapps/postConfigure/postConfigure.cpp | 72 +++++++++------------------- 3 files changed, 32 insertions , 54 deletions commit 90706f1c93cb86604ecd6c1d5a3e8ef917d99ed5 Merge: 90ea3e2 3affcd4 Author: David Hill <david.hill@mariadb.com> Date: Sun Nov 20 01:42:29 2016 +0000 Merge branch 'mcol-61' into develop

          People

            dthompson David Thompson (Inactive)
            hill David Hill (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.