Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
1.4.3, 2.0.0
-
None
-
Ubuntu 14.04
Description
After a server restart. Maxcale wont start properly and crash when trying to connect to database:
MariaDB Corporation MaxScale /var/log/maxscale/maxscale1.log Wed May 4 13:08:37 2016
-----------------------------------------------------------------------
2016-05-04 13:08:37 notice : Configuration file: /etc/maxscale.cnf
2016-05-04 13:08:37 notice : Log directory: /var/log/maxscale
2016-05-04 13:08:37 notice : Data directory: /var/lib/maxscale
2016-05-04 13:08:37 notice : Module directory: /usr/lib/x86_64-linux-gnu/maxscale
2016-05-04 13:08:37 notice : Service cache: /var/cache/maxscale
2016-05-04 13:08:37 notice : Initialise CLI router module V1.0.0.
2016-05-04 13:08:37 notice : Loaded module cli: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libcli.so
2016-05-04 13:08:37 notice : Initialise readconnroute router module V1.1.0.
2016-05-04 13:08:37 notice : Loaded module readconnroute: V1.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libreadconnroute.so
2016-05-04 13:08:37 notice : Initialise the MySQL Galera Monitor module V2.0.0.
2016-05-04 13:08:37 notice : Loaded module galeramon: V2.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libgaleramon.so
2016-05-04 13:08:37 warning: Monitor 'Galera Monitor' is missing the 'monitor_interval' parameter, using default value of 10000 milliseconds.
2016-05-04 13:08:37 notice : Encrypted password file /var/lib/maxscale/.secrets can't be accessed (No such file or directory). Password encryption is not used.
2016-05-04 13:08:37 notice : No query classifier specified, using default 'qc_mysqlembedded'.
2016-05-04 13:08:37 notice : Loaded module qc_mysqlembedded: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libqc_mysqlembedded.so
2016-05-04 13:08:37 notice : qc_mysqlembedded loaded.
2016-05-04 13:08:37 notice : Query classifier initialized.
2016-05-04 13:08:37 notice : MariaDB Corporation MaxScale 1.4.3 (C) MariaDB Corporation Ab 2013-2015
2016-05-04 13:08:37 notice : MaxScale is running in process 2681
2016-05-04 13:08:37 warning: Galera Service: User 'maxscale' is missing SELECT privileges on mysql.tables_priv table. Database name will be ignored in authentication. MySQL error message: SELECT command denied to user 'maxscale'@'10.8.0.1' for table 'tables_priv'
2016-05-04 13:08:37 error : Failed to retrieve users: SELECT command denied to user 'maxscale'@'10.8.0.1' for table 'tables_priv'
2016-05-04 13:08:37 error : Galera Service: Unable to load database grant information, MaxScale authentication will proceed without including database permissions. See earlier error messages for user 'maxscale' for more information.
2016-05-04 13:08:37 notice : Loading users from [mysql.user] without access to [mysql.db] for service [Galera Service]. MaxScale Authentication with DBname on connect will not consider database grants.
2016-05-04 13:08:37 error : Failed to obtain address for host ::1, Address family for hostname not supported
2016-05-04 13:08:37 warning: Failed to add user root@::1 for service [Galera Service]. This user will be unavailable via MaxScale.
2016-05-04 13:08:37 warning: Duplicate MySQL user found for service [Galera Service]: root@127.0.0.1
2016-05-04 13:08:37 notice : Loaded 6 MySQL Users for service [Galera Service].
2016-05-04 13:08:37 notice : Loaded module MySQLClient: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libMySQLClient.so
2016-05-04 13:08:37 notice : Listening MySQL connections at 0.0.0.0:3306
2016-05-04 13:08:37 error : Failed to bind to UNIX Domain socket '/var/run/mysqld/mysqld.sock': 2, No such file or directory
2016-05-04 13:08:37 error : Unable to start to listen port 0 for MySQLClient Galera Service.
2016-05-04 13:08:37 notice : Loaded module maxscaled: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmaxscaled.so
2016-05-04 13:08:37 notice : Listening maxscale connections at localhost:6603
2016-05-04 13:08:37 notice : Started MaxScale log flusher.
2016-05-04 13:08:37 notice : MaxScale started with 4 server threads.
2016-05-04 13:08:37 notice : Server changed state: server1[10.8.0.2:3306]: new_slave
2016-05-04 13:08:37 notice : Server changed state: server2[10.8.0.3:3306]: new_slave
2016-05-04 13:08:37 notice : Server changed state: server3[10.8.0.4:3306]: new_master
2016-05-04 13:08:37 notice : Server changed state: server4[10.8.0.5:3306]: new_slave
2016-05-04 13:10:41 error : Fatal: MaxScale 1.4.3 received fatal signal 11. Attempting backtrace.
2016-05-04 13:10:41 error : Commit ID: c2706bab69d1f3b5f1f3ec70f78b1a4803788fec System name: Linux Release string: Ubuntu 14.04.4 LTS Embedded library version: (null)
2016-05-04 13:10:41 error : /usr/bin/maxscale() [0x403c20]
2016-05-04 13:10:41 error : /lib/x86_64-linux-gnu/libpthread.so.0(+0x10340) [0x7fb0da08b340]
2016-05-04 13:10:41 error : /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(atomic_add+0x12) [0x7fb0da51c7f3]
2016-05-04 13:10:41 error : /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(mysql_users_fetch+0x33) [0x7fb0da526944]
2016-05-04 13:10:41 error : /usr/lib/x86_64-linux-gnu/maxscale/libMySQLClient.so(gw_find_mysql_user_password_sha1+0x1b7) [0x7fb0d0192535]
2016-05-04 13:10:41 error : /usr/lib/x86_64-linux-gnu/maxscale/libMySQLClient.so(gw_check_mysql_scramble_data+0x15b) [0x7fb0d0193ed9]
2016-05-04 13:10:41 error : /usr/lib/x86_64-linux-gnu/maxscale/libMySQLClient.so(+0x9132) [0x7fb0d0194132]
2016-05-04 13:10:41 error : /usr/lib/x86_64-linux-gnu/maxscale/libMySQLClient.so(mysql_auth_authenticate+0x139) [0x7fb0d0193834]
2016-05-04 13:10:41 error : /usr/lib/x86_64-linux-gnu/maxscale/libMySQLClient.so(+0x32fe) [0x7fb0d018e2fe]
2016-05-04 13:10:41 error : /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(+0x45c31) [0x7fb0da53dc31]
2016-05-04 13:10:41 error : /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(poll_waitevents+0x69c) [0x7fb0da53d415]
2016-05-04 13:10:41 error : /usr/bin/maxscale(worker_thread_main+0x2a) [0x404ea7]
2016-05-04 13:10:41 error : /lib/x86_64-linux-gnu/libpthread.so.0(+0x8182) [0x7fb0da083182]
2016-05-04 13:10:41 error : /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7fb0d99d447d]
Attachments
Issue Links
- relates to
-
MXS-711 All service ports use the same user data
- Closed