Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
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