----------------------------------------------------------------------- MariaDB Corporation MaxScale /var/log/maxscale/maxscale1.log Thu Apr 21 12:06:05 2016 ----------------------------------------------------------------------- 2016-04-21 12:06:05 notice : Configuration file: /etc/maxscale.cnf 2016-04-21 12:06:05 notice : Log directory: /var/log/maxscale 2016-04-21 12:06:05 notice : Data directory: /var/lib/maxscale 2016-04-21 12:06:05 notice : Module directory: /usr/lib/x86_64-linux-gnu/maxscale 2016-04-21 12:06:05 notice : Service cache: /var/cache/maxscale 2016-04-21 12:06:05 warning: Number of threads set to 4 which is greater than the number of processors available: 2 2016-04-21 12:06:05 notice : The logging of informational messages has been enabled. 2016-04-21 12:06:05 notice : The logging of debug messages has been enabled. 2016-04-21 12:06:05 notice : The logging of notice messages has been enabled. 2016-04-21 12:06:05 notice : Initialise CLI router module V1.0.0. 2016-04-21 12:06:05 notice : Loaded module cli: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libcli.so 2016-04-21 12:06:05 notice : Initializing statemend-based read/write split router module. 2016-04-21 12:06:05 notice : Loaded module readwritesplit: V1.0.2 from /usr/lib/x86_64-linux-gnu/maxscale/libreadwritesplit.so 2016-04-21 12:06:05 notice : Initialise readconnroute router module V1.1.0. 2016-04-21 12:06:05 notice : Loaded module readconnroute: V1.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libreadconnroute.so 2016-04-21 12:06:05 notice : Initialise the MySQL Monitor module V1.4.0. 2016-04-21 12:06:05 notice : Loaded module mysqlmon: V1.4.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmysqlmon.so 2016-04-21 12:06:05 notice : Encrypted password file /var/lib/maxscale/.secrets can't be accessed (No such file or directory). Password encryption is not used. 2016-04-21 12:06:05 notice : No query classifier specified, using default 'qc_mysqlembedded'. 2016-04-21 12:06:05 notice : Loaded module qc_mysqlembedded: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libqc_mysqlembedded.so 2016-04-21 12:06:05 notice : qc_mysqlembedded loaded. 2016-04-21 12:06:05 notice : Query classifier initialized. 2016-04-21 12:06:05 notice : MariaDB Corporation MaxScale 1.4.1 (C) MariaDB Corporation Ab 2013-2015 2016-04-21 12:06:05 notice : MaxScale is running in process 17052 2016-04-21 12:06:05 info : Notification service feedback is not enabled. 2016-04-21 12:06:05 error : Read-Only Service: Error: Failed to query from mysql.user table. MySQL error message: Unknown column 'password' in 'field list' 2016-04-21 12:06:05 debug : Loading data from backend database [10.0.3.26:3306] for service [Read-Only Service] 2016-04-21 12:06:05 error : Loading users for service [Read-Only Service] encountered error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'B' at line 1]. 2016-04-21 12:06:05 error : Unable to load users for service Read-Only Service listening at 0.0.0.0:4008. 2016-04-21 12:06:05 notice : Failed to start service Read-Only Service, retrying in 10 seconds. 2016-04-21 12:06:05 error : Failed to start service 'Read-Only Service'. 2016-04-21 12:06:05 error : Read-Write Service: Error: Failed to query from mysql.user table. MySQL error message: Unknown column 'password' in 'field list' 2016-04-21 12:06:05 debug : Loading data from backend database [10.0.3.26:3306] for service [Read-Write Service] 2016-04-21 12:06:05 error : Loading users for service [Read-Write Service] encountered error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'B' at line 1]. 2016-04-21 12:06:05 error : Unable to load users for service Read-Write Service listening at 0.0.0.0:3306. 2016-04-21 12:06:05 notice : Failed to start service Read-Write Service, retrying in 10 seconds. 2016-04-21 12:06:05 error : Failed to start service 'Read-Write Service'. 2016-04-21 12:06:05 info : Initialise MaxScaled Protocol module. 2016-04-21 12:06:05 notice : Loaded module maxscaled: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmaxscaled.so 2016-04-21 12:06:05 notice : Listening maxscale connections at 0.0.0.0:6603 2016-04-21 12:06:05 debug : 139709717424000 [poll_add_dcb] Added dcb 0x10e34a0 in state DCB_STATE_LISTENING to poll set. 2016-04-21 12:06:05 info : Started session [0] for MaxAdmin Service service 2016-04-21 12:06:05 notice : Started MaxScale log flusher. 2016-04-21 12:06:05 notice : MaxScale started with 4 server threads. 2016-04-21 12:06:05 notice : Server changed state: acs-sql-101[10.0.3.27:3306]: new_slave 2016-04-21 12:06:05 notice : Server changed state: acs-sql-201[10.0.3.26:3306]: new_master 2016-04-21 12:06:05 notice : A Master Server is now available: 10.0.3.26:3306 2016-04-21 12:06:15 debug : Dbusers : Loading data from backend database with Master role [10.0.3.26:3306] for service [Read-Only Service] 2016-04-21 12:06:15 error : Loading users for service [Read-Only Service] encountered error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'B' at line 1]. 2016-04-21 12:06:15 error : Unable to load users for service Read-Only Service listening at 0.0.0.0:4008. 2016-04-21 12:06:15 notice : Failed to start service Read-Only Service, retrying in 20 seconds. 2016-04-21 12:06:15 debug : Dbusers : Loading data from backend database with Master role [10.0.3.26:3306] for service [Read-Write Service] 2016-04-21 12:06:15 error : Loading users for service [Read-Write Service] encountered error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'B' at line 1]. 2016-04-21 12:06:15 error : Unable to load users for service Read-Write Service listening at 0.0.0.0:3306. 2016-04-21 12:06:15 notice : Failed to start service Read-Write Service, retrying in 20 seconds.