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

MCS Replication setup failure - mysqld failed to restart

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.1.1
    • 1.1.2
    • MariaDB Server
    • None
    • Amazon EC2 AMI 1um / 2pm with replication enabled
    • 2017-22

    Description

      Testing latest build of 1.1.1. Doing a postConfigure Install of a 1um / 2pm system will Replication enabled.

      The postConfigure install failed with the Replication failure:

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

      System Catalog Successfully Created

      Run MariaDB ColumnStore Replication Setup..
      ERROR: Error return in running the MariaDB ColumnStore Master replication, check /tmp/master-rep*.logs on um1

      MariaDB ColumnStore Install Failed

      Checking UM module logs and /tmp script log files pointed to a problem where mysqld failed to restart this this process, which caused the Replication to fail.

      [mariadb-user@ip-172-30-0-135 columnstore]$ mcsmysql
      ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/home/mariadb-user/mariadb/columnstore/mysql/lib/mysql/mysql.soc' (2)
      [mariadb-user@ip-172-30-0-135 columnstore]$ ps -ef | grep mysql
      mariadb+ 4210 1 0 19:20 ? 00:00:00 /bin/sh /home/mariadb-user/mariadb/columnstore/mysql//bin/mysqld_safe --datadir=/home/mariadb-user/mariadb/columnstore/mysql/db --pid-file=/home/mariadb-user/mariadb/columnstore/mysql/db/ip-172-30-0-135.pid --ledir=/home/mariadb-user/mariadb/columnstore/mysql//bin
      mariadb+ 4395 4210 0 19:20 ? 00:00:00 /home/mariadb-user/mariadb/columnstore/mysql//bin/mysqld --basedir=/home/mariadb-user/mariadb/columnstore/mysql/ --datadir=/home/mariadb-user/mariadb/columnstore/mysql/db --plugin-dir=/home/mariadb-user/mariadb/columnstore/mysql/lib/plugin --log-error=/home/mariadb-user/mariadb/columnstore/mysql/db/ip-172-30-0-135.err --pid-file=/home/mariadb-user/mariadb/columnstore/mysql/db/ip-172-30-0-135.pid --socket=/home/mariadb-user/mariadb/columnstore/mysql/lib/mysql/mysql.sock --port=3306
      mariadb+ 7701 7618 0 19:29 pts/0 00:00:00 grep --color=auto mysql
      [mariadb-user@ip-172-30-0-135 columnstore]$ ll /home/mariadb-user/mariadb/columnstore/mysql/lib/mysql/mysql.sock
      ls: cannot access /home/mariadb-user/mariadb/columnstore/mysql/lib/mysql/mysql.sock: No such file or directory

      tmp]$ cat actionMysqlCalpont.log
      Shutting down MySQL.............................. ERROR!
      ERROR! Failed to stop running server, so refusing to try to start.

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          David Hill (Inactive) made transition -
          Open In Progress
          2d 18h 36m 1
          David Hill (Inactive) made transition -
          In Progress In Review
          9h 21m 1
          Ben Thompson (Inactive) made transition -
          In Review In Testing
          18h 20m 1
          Daniel Lee (Inactive) made transition -
          In Testing Closed
          1d 23h 22m 1

          People

            dleeyh Daniel Lee (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.