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

multi-node install fails, mysqld didnt startup in time

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 1.0.13, 1.1.3
    • None
    • None
    • 2017-25, 2018-01, 2018-02, 2018-03

    Description

      multi-node install fails, mysqld didnt startup in time. Timeout is 30 seconds, needs to be increased to 60. Had same issue in 1.1.2..

      also the binary installer script timed out after increase to 60 seconds, so that timeout will need to be changed...

      pm1

      debug1: Sending command: /home/mariadb-user/mariadb/columnstore/bin/module_installer.sh --module=um --port=3306 --installdir=/home/mariadb-user/mariadb/columnstore
      Setup rc.local on Module
      Run Upgrade on my.cnf on Module
      Run Mysql Port update on my.cnf on Module
      Run post-mysqld-install
      Run post-mysql-install
      debug1: client_input_channel_req: channel 0 rtype exit-status reply 0
      debug1: client_input_channel_req: channel 0 rtype eow@openssh.com reply 0
      ERROR: post-mysql-install failed: check /tmp/post-mysql-install.log
      debug1: channel 0: free: client-session, nchannels 1
      Transferred: sent 3016, received 3044 bytes, in 51.9 seconds
      Bytes per second: sent 58.1, received 58.7
      debug1: Exit status 1

      um1

      ll /tmp/post-mysql-install.log
      rw-rw-r- 1 mariadb-user mariadb-user 285 Dec 12 16:16 /tmp/post-mysql-install.log

      [mariadb-user@ip-172-30-0-111 ~]$ cat /tmp/post-mysql-install.log
      Starting MySQL.............................. ERROR!
      checking for engine columnstore...
      ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/home/mariadb-user/mariadb/columnstore/mysql/lib/mysql/mysql.sock' (2 "No such file or directory")
      columnstore doesn't exist

      ll /home/mariadb-user/mariadb/columnstore/mysql/lib/mysql/mysql.sock
      srwxrwxrwx 1 mariadb-user mariadb-user 0 Dec 12 16:17 /home/mariadb-user/mariadb/columnstore/mysql/lib/mysql/mysql.sock

      mariadb+ 13119 1 0 16:15 ? 00:00:00 /bin/sh /home/mariadb-user/mariadb/columnstore/mysql//bin/mysqld_safe --datadir
      mariadb+ 13425 13119 5 16:16 ? 00:00:07 /home/mariadb-user/mariadb/columnstore/mysql//bin/mysqld --basedir=/home/mariad
      root 13454 1188 0 16:18 ? 00:00:00 sshd: mariadb-user [priv]
      mariadb+ 13456 13454 0 16:18 ? 00:00:00 sshd: mariadb-user@pts/0
      mariadb+ 13457 13456 0 16:18 pts/0 00:00:00 -bash
      mariadb+ 13479 13457 0 16:19 pts/0 00:00:00 ps -ef
      [mariadb-user@ip-172-30-0-111 ~]$ mcsmysql
      Welcome to the MariaDB monitor. Commands end with ; or \g.
      Your MariaDB connection id is 3
      Server version: 10.1.29-MariaDB Columnstore 1.0.12-1

      Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

      MariaDB [(none)]>

      cat ip-172-30-0-111.us-west-2.compute.internal.err
      171212 16:15:49 mysqld_safe Starting mysqld daemon with databases from /home/mariadb-user/mariadb/columnstore/mysql/db
      2017-12-12 16:16:42 140486689269888 [Note] /home/mariadb-user/mariadb/columnstore/mysql//bin/mysqld (mysqld 10.1.29-MariaDB) starting as process 13425 ...
      2017-12-12 16:16:48 140486689269888 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

      2017-12-12 16:16:48 140486689269888 [Note] InnoDB: Using mutexes to ref count buffer pool pages
      2017-12-12 16:16:48 140486689269888 [Note] InnoDB: The InnoDB memory heap is disabled
      2017-12-12 16:16:48 140486689269888 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2017-12-12 16:16:48 140486689269888 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
      2017-12-12 16:16:48 140486689269888 [Note] InnoDB: Compressed tables use zlib 1.2.7
      2017-12-12 16:16:48 140486689269888 [Note] InnoDB: Using Linux native AIO
      2017-12-12 16:16:48 140486689269888 [Note] InnoDB: Using SSE crc32 instructions
      2017-12-12 16:16:48 140486689269888 [Note] InnoDB: Initializing buffer pool, size = 128.0M
      2017-12-12 16:16:48 140486689269888 [Note] InnoDB: Completed initialization of buffer pool
      2017-12-12 16:16:48 140486689269888 [Note] InnoDB: Highest supported file format is Barracuda.
      2017-12-12 16:16:51 140486689269888 [Note] InnoDB: 128 rollback segment(s) are active.
      2017-12-12 16:16:51 140486689269888 [Note] InnoDB: Waiting for purge to start
      2017-12-12 16:16:51 140486689269888 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 1616717
      2017-12-12 16:17:04 140485477783296 [Note] InnoDB: Dumping buffer pool(s) not yet started
      2017-12-12 16:17:04 140486689269888 [Note] Plugin 'FEEDBACK' is disabled.
      2017-12-12 16:17:04 140486689269888 [Note] Server socket created on IP: '::'.
      2017-12-12 16:17:04 140486689269888 [Note] /home/mariadb-user/mariadb/columnstore/mysql//bin/mysqld: ready for connections.
      Version: '10.1.29-MariaDB' socket: '/home/mariadb-user/mariadb/columnstore/mysql/lib/mysql/mysql.sock' port: 3306 Columnstore 1.0.12-1

      Attachments

        Activity

          People

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