MariaDB MaxScale /var/log/maxscale/maxscale.log Thu Jan 18 12:01:48 2018 ---------------------------------------------------------------------------- 2018-01-18 12:01:48 notice : Working directory: /var/log/maxscale 2018-01-18 12:01:48 notice : MariaDB MaxScale 2.2.1 started 2018-01-18 12:01:48 notice : MaxScale is running in process 27965 2018-01-18 12:01:48 notice : Configuration file: /etc/maxscale.cnf 2018-01-18 12:01:48 notice : Log directory: /var/log/maxscale 2018-01-18 12:01:48 notice : Data directory: /var/lib/maxscale 2018-01-18 12:01:48 notice : Module directory: /usr/local/lib/maxscale 2018-01-18 12:01:48 notice : Service cache: /var/cache/maxscale 2018-01-18 12:01:48 notice : Loading /etc/maxscale.cnf. 2018-01-18 12:01:48 notice : The logging of informational messages has been enabled. 2018-01-18 12:01:48 notice : The logging of debug messages has been enabled. 2018-01-18 12:01:48 notice : /etc/maxscale.cnf.d does not exist, not reading. 2018-01-18 12:01:48 notice : [cli] Initialise CLI router module 2018-01-18 12:01:48 notice : Loaded module cli: V1.0.0 from /usr/local/lib/maxscale/libcli.so 2018-01-18 12:01:48 notice : [readwritesplit] Initializing statement-based read/write split router module. 2018-01-18 12:01:48 notice : Loaded module readwritesplit: V1.1.0 from /usr/local/lib/maxscale/libreadwritesplit.so 2018-01-18 12:01:48 notice : [readconnroute] Initialise readconnroute router module. 2018-01-18 12:01:48 notice : Loaded module readconnroute: V1.1.0 from /usr/local/lib/maxscale/libreadconnroute.so 2018-01-18 12:01:48 notice : [mariadbmon] Initialise the MySQL Monitor module. 2018-01-18 12:01:48 notice : Loaded module mariadbmon: V1.5.0 from /usr/local/lib/maxscale/libmariadbmon.so 2018-01-18 12:01:48 notice : Loaded module MariaDBBackend: V2.0.0 from /usr/local/lib/maxscale/libmariadbbackend.so 2018-01-18 12:01:48 notice : Loaded module MySQLBackendAuth: V1.0.0 from /usr/local/lib/maxscale/libmysqlbackendauth.so 2018-01-18 12:01:48 info : [maxscaled] Initialise MaxScaled Protocol module. 2018-01-18 12:01:48 notice : Loaded module maxscaled: V2.0.0 from /usr/local/lib/maxscale/libmaxscaled.so 2018-01-18 12:01:48 notice : Loaded module MaxAdminAuth: V2.1.0 from /usr/local/lib/maxscale/libmaxadminauth.so 2018-01-18 12:01:48 notice : Loaded module MariaDBClient: V1.1.0 from /usr/local/lib/maxscale/libmariadbclient.so 2018-01-18 12:01:48 notice : Loaded module MySQLAuth: V1.1.0 from /usr/local/lib/maxscale/libmysqlauth.so 2018-01-18 12:01:48 notice : Monitor 'MariaDB-Monitor' is missing the 'journal_max_age' parameter, using default value of 28800 seconds. 2018-01-18 12:01:48 notice : Monitor 'MariaDB-Monitor' is missing the 'script_timeout' parameter, using default value of 90 seconds. 2018-01-18 12:01:48 notice : No query classifier specified, using default 'qc_sqlite'. 2018-01-18 12:01:48 notice : Loaded module qc_sqlite: V1.0.0 from /usr/local/lib/maxscale/libqc_sqlite.so 2018-01-18 12:01:48 info : qc_sqlite loaded. 2018-01-18 12:01:48 info : Epoll instance for listening sockets added to worker epoll instance. 2018-01-18 12:01:48 notice : Encrypted password file /var/lib/maxscale/.secrets can't be accessed (No such file or directory). Password encryption is not used. 2018-01-18 12:01:48 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('repl', '172.17.0.9', NULL, 0, 'A424E797037BF97C19A2E88CF7891C5C2038C039') 2018-01-18 12:01:48 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxuser', '172.17.0.4', NULL, 1, '5EDBD32E469DAE0CE10E6999C3899DEFCB9F12E0') 2018-01-18 12:01:48 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxuser', '172.17.0.10', NULL, 1, '5EDBD32E469DAE0CE10E6999C3899DEFCB9F12E0') 2018-01-18 12:01:48 notice : [MySQLAuth] [Read-Only-Service] Loaded 3 MySQL users for listener Read-Only-Listener. 2018-01-18 12:01:48 notice : Listening for connections at [0.0.0.0]:4008 with protocol MySQL 2018-01-18 12:01:48 info : Started session [1] for Read-Only-Service service 2018-01-18 12:01:48 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('repl', '172.17.0.9', NULL, 0, 'A424E797037BF97C19A2E88CF7891C5C2038C039') 2018-01-18 12:01:48 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxuser', '172.17.0.4', NULL, 1, '5EDBD32E469DAE0CE10E6999C3899DEFCB9F12E0') 2018-01-18 12:01:48 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxuser', '172.17.0.10', NULL, 1, '5EDBD32E469DAE0CE10E6999C3899DEFCB9F12E0') 2018-01-18 12:01:48 notice : [MySQLAuth] [Read-Write-Service] Loaded 3 MySQL users for listener Read-Write-Listener. 2018-01-18 12:01:48 notice : Listening for connections at [0.0.0.0]:4006 with protocol MySQL 2018-01-18 12:01:48 info : Started session [2] for Read-Write-Service service 2018-01-18 12:01:48 notice : Listening for connections at [0.0.0.0]:6603 with protocol MaxScale Admin 2018-01-18 12:01:48 info : Started session [3] for MaxAdmin-Service service 2018-01-18 12:01:48 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 4397960784144. 2018-01-18 12:01:48 notice : Started REST API on [127.0.0.1]:8989 2018-01-18 12:01:48 notice : MaxScale started with 1 worker threads, each with a stack size of 8388608 bytes. 2018-01-18 12:01:48 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 4397988563808. 2018-01-18 12:01:48 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('repl', '172.17.0.9', NULL, 0, 'A424E797037BF97C19A2E88CF7891C5C2038C039') 2018-01-18 12:01:48 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxuser', '172.17.0.4', NULL, 1, '5EDBD32E469DAE0CE10E6999C3899DEFCB9F12E0') 2018-01-18 12:01:48 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxuser', '172.17.0.10', NULL, 1, '5EDBD32E469DAE0CE10E6999C3899DEFCB9F12E0') 2018-01-18 12:01:48 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('repl', '172.17.0.9', NULL, 0, 'A424E797037BF97C19A2E88CF7891C5C2038C039') 2018-01-18 12:01:48 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxuser', '172.17.0.4', NULL, 1, '5EDBD32E469DAE0CE10E6999C3899DEFCB9F12E0') 2018-01-18 12:01:48 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxuser', '172.17.0.10', NULL, 1, '5EDBD32E469DAE0CE10E6999C3899DEFCB9F12E0') 2018-01-18 12:01:48 notice : Started MaxScale log flusher. 2018-01-18 12:01:48 error : Failed to read journal file: Expected 671088640 bytes, read 40 bytes. 2018-01-18 12:01:48 notice : Server changed state: server1[172.17.0.8:3306]: new_master. [Running] -> [Master, Running] 2018-01-18 12:01:48 notice : Server changed state: server2[172.17.0.9:3306]: new_slave. [Running] -> [Slave, Running] 2018-01-18 12:01:48 notice : [mariadbmon] A Master Server is now available: 172.17.0.8:3306 1846,1 Bot