MariaDB MaxScale /var/log/maxscale/maxscale.log Thu Aug 15 20:12:27 2019 ---------------------------------------------------------------------------- 2019-08-15 20:12:27 notice : syslog logging is enabled. 2019-08-15 20:12:27 notice : maxlog logging is enabled. 2019-08-15 20:12:27 notice : The logging of informational messages has been enabled. 2019-08-15 20:12:27 notice : Using up to 7.05GiB of memory for query classifier cache 2019-08-15 20:12:27 notice : The collection of SQLite memory allocation statistics turned off. 2019-08-15 20:12:27 notice : Threading mode of SQLite set to Multi-thread. 2019-08-15 20:12:27 notice : MariaDB MaxScale 2.4.1 started (Commit: 8ce6a679bef8c73b156d3687af7d6eac3c8f46bc) 2019-08-15 20:12:27 notice : MaxScale is running in process 19998 2019-08-15 20:12:27 notice : Configuration file: /etc/clustrix_karma197_rwsplit.cnf 2019-08-15 20:12:27 notice : Log directory: /var/log/maxscale 2019-08-15 20:12:27 notice : Data directory: /var/lib/maxscale 2019-08-15 20:12:27 notice : Module directory: /usr/lib64/maxscale 2019-08-15 20:12:27 notice : Service cache: /var/cache/maxscale 2019-08-15 20:12:27 notice : No query classifier specified, using default 'qc_sqlite'. 2019-08-15 20:12:27 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2019-08-15 20:12:27 info : qc_sqlite loaded. 2019-08-15 20:12:27 notice : Query classification results are cached and reused. Memory used per thread: 451.20MiB 2019-08-15 20:12:27 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 20:12:27 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 20:12:27 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 20:12:27 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 20:12:27 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 20:12:27 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 20:12:27 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 20:12:27 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 20:12:27 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 20:12:27 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 20:12:27 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 20:12:27 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 20:12:27 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 20:12:27 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 20:12:27 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 20:12:27 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 20:12:27 notice : Loading /etc/clustrix_karma197_rwsplit.cnf. 2019-08-15 20:12:27 notice : /etc/clustrix_karma197_rwsplit.cnf.d does not exist, not reading. 2019-08-15 20:12:27 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2019-08-15 20:12:27 notice : [readwritesplit] Initializing statement-based read/write split router module. 2019-08-15 20:12:27 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so 2019-08-15 20:12:27 info : Specifying durations without a suffix denoting the unit is strongly discouraged as it will be deprecated in the future: max_retry_interval=500. Use the suffixes 'h' (hour), 'm' (minute), 's' (second) or 'ms' (milliseconds). 2019-08-15 20:12:27 notice : Loaded module MariaDBBackend: V2.0.0 from /usr/lib64/maxscale/libmariadbbackend.so 2019-08-15 20:12:27 notice : [clustrixmon] Initialise the MariaDB Clustrix Monitor module. 2019-08-15 20:12:27 notice : Loaded module clustrixmon: V1.0.0 from /usr/lib64/maxscale/libclustrixmon.so 2019-08-15 20:12:27 info : Specifying durations without a suffix denoting the unit is strongly discouraged as it will be deprecated in the future: monitor_interval=10000. Use the suffixes 'h' (hour), 'm' (minute), 's' (second) or 'ms' (milliseconds). 2019-08-15 20:12:27 info : Specifying durations without a suffix denoting the unit is strongly discouraged as it will be deprecated in the future: monitor_interval=10000. Use the suffixes 'h' (hour), 'm' (minute), 's' (second) or 'ms' (milliseconds). 2019-08-15 20:12:27 notice : Loaded module mariadbbackendauth: V1.0.0 from /usr/lib64/maxscale/libmariadbbackendauth.so 2019-08-15 20:12:27 notice : [clustrixmon] sqlite3 database /var/lib/maxscale/Cluster-Monitor/clustrix_nodes-v1.db open/created and initialized. 2019-08-15 20:12:27 notice : Loaded module mariadbauth: V1.1.0 from /usr/lib64/maxscale/libmariadbauth.so 2019-08-15 20:12:27 notice : [clustrixmon] sqlite3 database /var/lib/maxscale/Cluster-Monitor1/clustrix_nodes-v1.db open/created and initialized. 2019-08-15 20:12:27 info : In-memory sqlite database successfully opened for thread 140161596634880. 2019-08-15 20:12:27 info : In-memory sqlite database successfully opened for thread 140161588242176. 2019-08-15 20:12:27 info : In-memory sqlite database successfully opened for thread 140161579849472. 2019-08-15 20:12:27 info : In-memory sqlite database successfully opened for thread 140161571456768. 2019-08-15 20:12:27 info : In-memory sqlite database successfully opened for thread 140161358755584. 2019-08-15 20:12:27 info : In-memory sqlite database successfully opened for thread 140161350362880. 2019-08-15 20:12:27 info : In-memory sqlite database successfully opened for thread 140161341970176. 2019-08-15 20:12:27 info : In-memory sqlite database successfully opened for thread 140161333577472. 2019-08-15 20:12:27 info : In-memory sqlite database successfully opened for thread 140161325184768. 2019-08-15 20:12:27 info : In-memory sqlite database successfully opened for thread 140161316792064. 2019-08-15 20:12:27 info : In-memory sqlite database successfully opened for thread 140161308399360. 2019-08-15 20:12:27 info : In-memory sqlite database successfully opened for thread 140160754775808. 2019-08-15 20:12:27 info : In-memory sqlite database successfully opened for thread 140160746383104. 2019-08-15 20:12:27 info : In-memory sqlite database successfully opened for thread 140160737990400. 2019-08-15 20:12:27 info : In-memory sqlite database successfully opened for thread 140160729597696. 2019-08-15 20:12:27 info : In-memory sqlite database successfully opened for thread 140160721204992. 2019-08-15 20:12:27 notice : Started REST API on [127.0.0.1]:8989 2019-08-15 20:12:27 notice : MaxScale started with 16 worker threads, each with a stack size of 8388608 bytes. 2019-08-15 20:12:27 notice : Starting a total of 3 services... 2019-08-15 20:12:27 notice : Encrypted password file /var/lib/maxscale/.secrets can't be accessed (No such file or directory). Password encryption is not used. 2019-08-15 20:12:27 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:12:27 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', 'localhost', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:12:27 notice : [MariaDBAuth] [Read-Write-Service_rwsrvc] No users were loaded but 'inject_service_user' is enabled. Enabling service credentials for authentication until database users have been successfully loaded. 2019-08-15 20:12:27 notice : Listening for connections at [::]:4008 2019-08-15 20:12:27 notice : Service 'Read-Write-Service_rwsrvc' started (1/3) 2019-08-15 20:12:27 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:12:27 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', 'localhost', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:12:27 notice : Listening for connections at [::]:4007 2019-08-15 20:12:27 notice : Service 'Read-Write-Service1' started (2/3) 2019-08-15 20:12:27 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:12:27 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', 'localhost', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:12:27 notice : Listening for connections at [::]:4006 2019-08-15 20:12:27 notice : Service 'Read-Write-Service' started (3/3) 2019-08-15 20:12:27 notice : Loaded server states from journal file: /var/lib/maxscale/Cluster-Monitor1/monitor.dat 2019-08-15 20:12:27 notice : [clustrixmon] Cluster-Monitor1: Monitoring Clustrix cluster state using node 10.2.15.40:3306. 2019-08-15 20:12:27 warning: Authenticator module 'mysqlbackendauth' has been deprecated, use 'mariadbbackendauth' instead. 2019-08-15 20:12:27 notice : Created server '@@Cluster-Monitor1:node-1' at 10.2.15.40:3306 2019-08-15 20:12:27 info : [clustrixmon] Updated Clustrix node in bookkeeping: 1, '10.2.15.40', 3306, 3581. 2019-08-15 20:12:27 notice : Created server '@@Cluster-Monitor1:node-3' at 10.2.12.218:3306 2019-08-15 20:12:27 info : [clustrixmon] Updated Clustrix node in bookkeeping: 3, '10.2.12.218', 3306, 3581. 2019-08-15 20:12:27 notice : Created server '@@Cluster-Monitor1:node-2' at 10.2.15.75:3306 2019-08-15 20:12:27 info : [clustrixmon] Updated Clustrix node in bookkeeping: 2, '10.2.15.75', 3306, 3581. 2019-08-15 20:12:27 notice : Loaded server states from journal file: /var/lib/maxscale/Cluster-Monitor/monitor.dat 2019-08-15 20:12:27 notice : [clustrixmon] Cluster-Monitor: Monitoring Clustrix cluster state using node 10.2.13.91:3306. 2019-08-15 20:12:27 notice : Created server '@@Cluster-Monitor:node-1' at 10.2.13.91:3306 2019-08-15 20:12:27 info : [clustrixmon] Updated Clustrix node in bookkeeping: 1, '10.2.13.91', 3306, 3581. 2019-08-15 20:12:27 notice : Created server '@@Cluster-Monitor:node-2' at 10.2.15.89:3306 2019-08-15 20:12:27 info : [clustrixmon] Updated Clustrix node in bookkeeping: 2, '10.2.15.89', 3306, 3581. 2019-08-15 20:12:27 notice : Created server '@@Cluster-Monitor:node-3' at 10.2.15.180:3306 2019-08-15 20:12:27 info : [clustrixmon] Updated Clustrix node in bookkeeping: 3, '10.2.15.180', 3306, 3581. 2019-08-15 20:13:38 info : Accept authentication from 'admin', using password. Request: /v1/servers/MBS/set 2019-08-15 20:13:38 info : Accept authentication from 'admin', using password. Request: /v1/servers/MBS2/set 2019-08-15 20:13:54 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-08-15 20:13:54 info : Accept authentication from 'admin', using password. Request: /v1/monitors/Cluster-Monitor 2019-08-15 20:13:54 info : Accept authentication from 'admin', using password. Request: /v1/monitors/Cluster-Monitor1 2019-08-15 20:14:15 notice : (2) Server '@@Cluster-Monitor:node-1' version: 5.0.45-clustrix-fredonyer-16045 2019-08-15 20:14:15 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 20:14:15 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 20:14:15 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 20:14:15 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 20:14:15 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : (2) [readwritesplit] Servers and router connection counts: 2019-08-15 20:14:15 info : (2) [readwritesplit] current operations : 0 in [10.2.13.91]:3306 Master, Running 2019-08-15 20:14:15 info : (2) [readwritesplit] current operations : 0 in [10.2.15.89]:3306 Master, Running 2019-08-15 20:14:15 info : (2) [readwritesplit] current operations : 0 in [10.2.15.180]:3306 Master, Running 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : (2) [readwritesplit] Connected to '@@Cluster-Monitor:node-1' 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : (2) [readwritesplit] Selected Master: @@Cluster-Monitor:node-1 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : (2) Started Read-Write-Service client session [2] for 'maxscale' from ::ffff:127.0.0.1 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 20:14:15 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 20, type: QUERY_TYPE_GSYSVAR_WRITE, stmt: SET SQL_MODE='' 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : (2) [readwritesplit] Session write, routing to all servers. 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : (2) [readwritesplit] Route query to master: @@Cluster-Monitor:node-1 [10.2.13.91]:3306 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : (2) Connected to '@@Cluster-Monitor:node-1' with thread id 97281 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : (2) [readwritesplit] Reply complete, last reply from @@Cluster-Monitor:node-1 2019-08-15 20:14:15 notice : (1) Server 'MBS' version: 10.2.12 2.4.1-maxscale 2019-08-15 20:14:15 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 73, type: QUERY_TYPE_USERVAR_WRITE, stmt: SET @roles_are_available=(SELECT 1 FROM mysql.roles_mapping LIMIT 1) 2019-08-15 20:14:15 info : (2) [readwritesplit] Session write, routing to all servers. 2019-08-15 20:14:15 info : (2) [readwritesplit] Route query to master: @@Cluster-Monitor:node-1 [10.2.13.91]:3306 2019-08-15 20:14:15 info : (2) [readwritesplit] Reply complete, last reply from @@Cluster-Monitor:node-1 2019-08-15 20:14:15 info : (2) [readwritesplit] Session command no. 2 failed: #HY000: [8192] Relation not found: "mysql"."roles_mapping" 2019-08-15 20:14:15 warning: (1) [MariaDBAuth] The user for service 'Read-Write-Service_rwsrvc' might be missing the SELECT grant on `mysql.roles_mapping` or `mysql.user`. Use of default roles is disabled until the missing privileges are added. Error was: [8192] Relation not found: "mysql"."roles_mapping" 2019-08-15 20:14:15 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 14, type: QUERY_TYPE_SESSION_WRITE, stmt: USE mysql 2019-08-15 20:14:15 info : (2) [readwritesplit] Session write, routing to all servers. 2019-08-15 20:14:15 info : (2) [readwritesplit] Route query to master: @@Cluster-Monitor:node-1 [10.2.13.91]:3306 2019-08-15 20:14:15 info : (2) [readwritesplit] Reply complete, last reply from @@Cluster-Monitor:node-1 2019-08-15 20:14:15 info : (2) [readwritesplit] Session command no. 3 failed: #42000: [11267] No such database: "mysql" 2019-08-15 20:14:15 error : (1) [MariaDBAuth] Failed to load users from server 'MBS': [11267] No such database: "mysql" 2019-08-15 20:14:15 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 19, type: QUERY_TYPE_SHOW_DATABASES, stmt: SHOW DATABASES 2019-08-15 20:14:15 info : (2) [readwritesplit] Route query to master: @@Cluster-Monitor:node-1 [10.2.13.91]:3306 < 2019-08-15 20:14:15 info : (2) [readwritesplit] Reply complete, last reply from @@Cluster-Monitor:node-1 2019-08-15 20:14:15 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x01) COM_QUIT, plen: 5, type: QUERY_TYPE_SESSION_WRITE, stmt: 2019-08-15 20:14:15 info : (2) [readwritesplit] Session write, routing to all servers. 2019-08-15 20:14:15 info : (1) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : (2) [readwritesplit] Route query to master: @@Cluster-Monitor:node-1 [10.2.13.91]:3306 2019-08-15 20:14:15 info : (1) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', 'localhost', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 notice : (1) [MariaDBAuth] [Read-Write-Service_rwsrvc] No users were loaded but 'inject_service_user' is enabled. Enabling service credentials for authentication until database users have been successfully loaded. 2019-08-15 20:14:15 info : Stopped Read-Write-Service client session [2] 2019-08-15 20:14:15 warning: (1) [MariaDBAuth] Read-Write-Service_rwsrvc: login attempt for user 'maxscale'@[::ffff:10.2.14.197]:55498, authentication failed. Unknown database: test 2019-08-15 20:14:15 info : Stopped Read-Write-Service_rwsrvc client session [1] 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 20:14:15 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD')