search

sttts / docker-galera-mariadb-10.0

Apache License 2.0
9 stars 114 forks source link

Health check fails & sql: no rows in result set #2

Closed trompx closed 9 years ago

trompx commented 9 years ago

Hello,

I tried installing the galera cluster but when launching the app from marathon, the seed container does not run and fails the health check.

Here is the full container log I get :

+ '[' -z 3240fd7as9f8798 ']'
++ awk '{print $1;}'
++ sha256sum
++ echo 3240fd7as9f8798
+ CLUSTERCHECK_PASSWORD=62d50cf100bcbb8755a85f9936df32a9a39b1830171d25e59de17cb56e9d10da
+ QCOMM=
+ CLUSTER_NAME=cluster
+ MYSQL_MODE_ARGS=

+ case "$1" in
+ '[' '!' -f /var/lib/mysql/skip-cluster-bootstrapping ']'
+ MYSQL_MODE_ARGS+=' --wsrep-new-cluster'
+ shift 1
+ echo 'Starting seed node'
Starting seed node
+ set +e -m
+ trap shutdown TERM INT
+ wait 13
+ /mysqld.sh --console --wsrep-new-cluster --wsrep_cluster_name=cluster --wsrep_cluster_address=gcomm:// --wsrep_sst_auth=xtrabackup:3240fd7as9f8798 -
-default-time-zone=+00:00
+ /bin/galera-healthcheck -password=62d50cf100bcbb8755a85f9936df32a9a39b1830171d25e59de17cb56e9d10da -pidfile=/var/run/galera-healthcheck.pid -user cl
ustercheck
/usr/sbin/mysqld
Docker startscript:  Get the GTID positon
Warning: World-writable config file '/etc/mysql/conf.d/galera.cnf' is ignored
Warning: World-writable config file '/etc/mysql/conf.d/utf8.cnf' is ignored
150523 23:55:16 [Note] mysqld (mysqld 10.0.19-MariaDB-1~trusty-wsrep-log) starting as process 13 ...
150523 23:55:16 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150523 23:55:16 [Note] InnoDB: The InnoDB memory heap is disabled
150523 23:55:16 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150523 23:55:16 [Note] InnoDB: Memory barrier is not used
150523 23:55:16 [Note] InnoDB: Compressed tables use zlib 1.2.8
150523 23:55:16 [Note] InnoDB: Using Linux native AIO
150523 23:55:16 [Note] InnoDB: Not using CPU crc32 instructions
150523 23:55:16 [Note] InnoDB: Initializing buffer pool, size = 256.0M
150523 23:55:16 [Note] InnoDB: Completed initialization of buffer pool
150523 23:55:16 [Note] InnoDB: Highest supported file format is Barracuda.
150523 23:55:16 [Note] InnoDB: 128 rollback segment(s) are active.
150523 23:55:16 [Note] InnoDB: Waiting for purge to start
150523 23:55:17 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.23-72.1 started; log sequence number 1617737
150523 23:55:17 [Note] Plugin 'FEEDBACK' is disabled.
150523 23:55:17 [Note] Server socket created on IP: '127.0.0.1'.
150523 23:55:17 [Note] Event Scheduler: Loaded 0 events
150523 23:55:17 [Note] WSREP: Read nil XID from storage engines, skipping position init
150523 23:55:17 [Note] WSREP: wsrep_load(): loading provider library 'none'
150523 23:55:17 [Note] Reading of all Master_info entries succeded
150523 23:55:17 [Note] Added new Master_info '' to hash table
150523 23:55:17 [Note] mysqld: ready for connections.
Version: '10.0.19-MariaDB-1~trusty-wsrep-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution, wsrep_25.10.r4144
[2015-05-23 23:55:17.333973718 +0000 UTC] - sql: no rows in result set
[2015-05-23 23:55:22.34961456 +0000 UTC] - sql: no rows in result set
[2015-05-23 23:55:27.371263946 +0000 UTC] - sql: no rows in result set
[2015-05-23 23:55:32.389584766 +0000 UTC] - sql: no rows in result set
[2015-05-23 23:55:37.409353486 +0000 UTC] - sql: no rows in result set
[2015-05-23 23:55:42.428997966 +0000 UTC] - sql: no rows in result set
[2015-05-23 23:55:47.449266737 +0000 UTC] - sql: no rows in result set
[2015-05-23 23:55:52.469563612 +0000 UTC] - sql: no rows in result set
[2015-05-23 23:55:57.489875467 +0000 UTC] - sql: no rows in result set
[2015-05-23 23:56:02.508766406 +0000 UTC] - sql: no rows in result set
[2015-05-23 23:56:07.530814593 +0000 UTC] - sql: no rows in result set
[2015-05-23 23:56:12.550585241 +0000 UTC] - sql: no rows in result set
[2015-05-23 23:56:17.569638784 +0000 UTC] - sql: no rows in result set
++ shutdown
++ echo Shutting down
Shutting down
++ test -s /var/run/mysql/mysqld.pid
+ RC=143
+ test -s /var/run/galera-healthcheck.pid
++ cat /var/run/galera-healthcheck.pid
+ kill 12
+ exit 143

Any idea why I get the sql: no rows in result set ?

Thank you

trompx commented 9 years ago

Close with pull request https://github.com/sttts/docker-galera-mariadb-10.0/pull/3