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

mysqld hung and stopsystem stop it

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Not a Bug
    • 1.0.1
    • Icebox
    • MariaDB Server
    • None
    • 2016-19, 2016-20

    Description

      mscadmin> getsoft
      getsoftwareinfo Fri Jul 1 20:21:02 2016

      Name : mariadb-columnstore-platform
      Version : 1.0
      Release : 1
      Architecture: x86_64
      Install Date: Fri 24 Jun 2016 07:28:00 PM UTC

      I was executing an LDI for a 10g lineitem InnoDB table. It ran over night and did not finished. I used the stopsystem to stop the system. ColumnStore admin console showed everything and up and normal, but when I tried to start the MySQL client, I got:

      [root@ip-172-30-0-214 dbt3]# mcsmysql testdb
      ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/local/mariadb/columnstore/mysql/lib/mysql/mysql.sock' (2 "No such file or directory")

      The /usr/local/mariadb/columnstore/mysql/lib/mysql directory was empty and the mysql.sock file does not exist.
      root 3067 1 0 04:06 ? 00:00:00 /bin/sh /usr/local/mariadb/columnstore/mysql//bin/mysqld_safe --datadir=/usr/local/mariadb/columnstore/mysql/db --pid-file=/usr/local/mariadb/columnstore/mysql/db/ip-172-30-0-214.pid --ledir=/usr/local/mariadb/columnstore/mysql//sbin
      mysql 3247 3067 18 04:06 ? 02:55:18 /usr/local/mariadb/columnstore/mysql//sbin/mysqld --basedir=/usr/local/mariadb/columnstore/mysql/ --datadir=/usr/local/mariadb/columnstore/mysql/db --plugin-dir=/usr/local/mariadb/columnstore/mysql/lib64/mysql/plugin --user=mysql --log-error=/usr/local/mariadb/columnstore/mysql/db/ip-172-30-0-214.err --pid-file=/usr/local/mariadb/columnstore/mysql/db/ip-172-30-0-214.pid --socket=/usr/local/mariadb/columnstore/mysql/lib/mysql/mysql.sock --port=3306

      I used kill -9 to kill the two mysqld processed and restarted ColumnStore again. ColumnStore is now operational.

      Attachments

        Activity

          People

            dthompson David Thompson (Inactive)
            dleeyh Daniel Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.