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

MCS Replication setup failure - mysqld failed to restart

    XMLWordPrintable

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

          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.