MariaDB MaxScale /var/log/maxscale/maxscale.log Thu Aug 15 06:09:00 2019 ---------------------------------------------------------------------------- 2019-08-15 06:09:00 notice : syslog logging is enabled. 2019-08-15 06:09:00 notice : maxlog logging is enabled. 2019-08-15 06:09:00 notice : The logging of informational messages has been enabled. 2019-08-15 06:09:00 notice : Using up to 7.05GiB of memory for query classifier cache 2019-08-15 06:09:00 notice : The collection of SQLite memory allocation statistics turned off. 2019-08-15 06:09:00 notice : Threading mode of SQLite set to Multi-thread. 2019-08-15 06:09:00 notice : MariaDB MaxScale 2.4.1 started (Commit: 8ce6a679bef8c73b156d3687af7d6eac3c8f46bc) 2019-08-15 06:09:00 notice : MaxScale is running in process 18308 2019-08-15 06:09:00 notice : Configuration file: /etc/clustrix_karma197_rwsplit.cnf 2019-08-15 06:09:00 notice : Log directory: /var/log/maxscale 2019-08-15 06:09:00 notice : Data directory: /var/lib/maxscale 2019-08-15 06:09:00 notice : Module directory: /usr/lib64/maxscale 2019-08-15 06:09:00 notice : Service cache: /var/cache/maxscale 2019-08-15 06:09:00 notice : No query classifier specified, using default 'qc_sqlite'. 2019-08-15 06:09:00 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2019-08-15 06:09:00 info : qc_sqlite loaded. 2019-08-15 06:09:00 notice : Query classification results are cached and reused. Memory used per thread: 451.20MiB 2019-08-15 06:09:00 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 06:09:00 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 06:09:00 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 06:09:00 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 06:09:00 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 06:09:00 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 06:09:00 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 06:09:00 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 06:09:00 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 06:09:00 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 06:09:00 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 06:09:00 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 06:09:00 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 06:09:00 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 06:09:00 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 06:09:00 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-15 06:09:00 notice : Loading /etc/clustrix_karma197_rwsplit.cnf. 2019-08-15 06:09:00 notice : /etc/clustrix_karma197_rwsplit.cnf.d does not exist, not reading. 2019-08-15 06:09:00 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2019-08-15 06:09:00 notice : [readwritesplit] Initializing statement-based read/write split router module. 2019-08-15 06:09:00 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so 2019-08-15 06:09:00 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 06:09:00 notice : Loaded module MariaDBBackend: V2.0.0 from /usr/lib64/maxscale/libmariadbbackend.so 2019-08-15 06:09:00 notice : [clustrixmon] Initialise the MariaDB Clustrix Monitor module. 2019-08-15 06:09:00 notice : Loaded module clustrixmon: V1.0.0 from /usr/lib64/maxscale/libclustrixmon.so 2019-08-15 06:09:00 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 06:09:00 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 06:09:00 notice : Loaded module mariadbbackendauth: V1.0.0 from /usr/lib64/maxscale/libmariadbbackendauth.so 2019-08-15 06:09:00 notice : [clustrixmon] sqlite3 database /var/lib/maxscale/Cluster-Monitor/clustrix_nodes-v1.db open/created and initialized. 2019-08-15 06:09:00 notice : Loaded module mariadbauth: V1.1.0 from /usr/lib64/maxscale/libmariadbauth.so 2019-08-15 06:09:00 notice : [clustrixmon] sqlite3 database /var/lib/maxscale/Cluster-Monitor1/clustrix_nodes-v1.db open/created and initialized. 2019-08-15 06:09:00 info : In-memory sqlite database successfully opened for thread 139778129594112. 2019-08-15 06:09:00 info : In-memory sqlite database successfully opened for thread 139778121201408. 2019-08-15 06:09:00 info : In-memory sqlite database successfully opened for thread 139778112808704. 2019-08-15 06:09:00 info : In-memory sqlite database successfully opened for thread 139777898706688. 2019-08-15 06:09:00 info : In-memory sqlite database successfully opened for thread 139777890313984. 2019-08-15 06:09:00 info : In-memory sqlite database successfully opened for thread 139777881921280. 2019-08-15 06:09:00 info : In-memory sqlite database successfully opened for thread 139777873528576. 2019-08-15 06:09:00 info : In-memory sqlite database successfully opened for thread 139777865135872. 2019-08-15 06:09:00 info : In-memory sqlite database successfully opened for thread 139777856743168. 2019-08-15 06:09:00 info : In-memory sqlite database successfully opened for thread 139777848350464. 2019-08-15 06:09:00 info : In-memory sqlite database successfully opened for thread 139777361835776. 2019-08-15 06:09:00 info : In-memory sqlite database successfully opened for thread 139777353443072. 2019-08-15 06:09:00 info : In-memory sqlite database successfully opened for thread 139777345050368. 2019-08-15 06:09:00 info : In-memory sqlite database successfully opened for thread 139777336657664. 2019-08-15 06:09:00 info : In-memory sqlite database successfully opened for thread 139777328264960. 2019-08-15 06:09:00 info : In-memory sqlite database successfully opened for thread 139777319872256. 2019-08-15 06:09:00 notice : Started REST API on [127.0.0.1]:8989 2019-08-15 06:09:00 notice : MaxScale started with 16 worker threads, each with a stack size of 8388608 bytes. 2019-08-15 06:09:00 notice : Starting a total of 3 services... 2019-08-15 06:09:00 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 06:09:00 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:00 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', 'localhost', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:00 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 06:09:00 notice : Listening for connections at [::]:4008 2019-08-15 06:09:00 notice : Service 'Read-Write-Service_rwsrvc' started (1/3) 2019-08-15 06:09:00 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:00 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', 'localhost', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:00 notice : Listening for connections at [::]:4007 2019-08-15 06:09:00 notice : Service 'Read-Write-Service1' started (2/3) 2019-08-15 06:09:00 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:00 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', 'localhost', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:00 notice : Listening for connections at [::]:4006 2019-08-15 06:09:00 notice : Service 'Read-Write-Service' started (3/3) 2019-08-15 06:09:00 warning: Journal file was created 115040 seconds ago. Maximum journal age is 28800 seconds. 2019-08-15 06:09:00 warning: Removing stale journal file for monitor 'Cluster-Monitor1'. 2019-08-15 06:09:00 notice : [clustrixmon] Cluster-Monitor1: Monitoring Clustrix cluster state using node 10.2.15.40:3306. 2019-08-15 06:09:00 warning: Authenticator module 'mysqlbackendauth' has been deprecated, use 'mariadbbackendauth' instead. 2019-08-15 06:09:00 notice : Created server '@@Cluster-Monitor1:node-1' at 10.2.15.40:3306 2019-08-15 06:09:00 info : [clustrixmon] Updated Clustrix node in bookkeeping: 1, '10.2.15.40', 3306, 3581. 2019-08-15 06:09:00 notice : Created server '@@Cluster-Monitor1:node-3' at 10.2.12.218:3306 2019-08-15 06:09:00 info : [clustrixmon] Updated Clustrix node in bookkeeping: 3, '10.2.12.218', 3306, 3581. 2019-08-15 06:09:00 notice : Created server '@@Cluster-Monitor1:node-2' at 10.2.15.75:3306 2019-08-15 06:09:00 info : [clustrixmon] Updated Clustrix node in bookkeeping: 2, '10.2.15.75', 3306, 3581. 2019-08-15 06:09:00 warning: Journal file was created 115040 seconds ago. Maximum journal age is 28800 seconds. 2019-08-15 06:09:00 warning: Removing stale journal file for monitor 'Cluster-Monitor'. 2019-08-15 06:09:00 notice : Server changed state: BS4[10.2.15.40:3306]: new_master. [Running] -> [Master, Running] 2019-08-15 06:09:00 notice : [clustrixmon] Cluster-Monitor: Monitoring Clustrix cluster state using node 10.2.13.91:3306. 2019-08-15 06:09:00 notice : Created server '@@Cluster-Monitor:node-1' at 10.2.13.91:3306 2019-08-15 06:09:00 info : [clustrixmon] Updated Clustrix node in bookkeeping: 1, '10.2.13.91', 3306, 3581. 2019-08-15 06:09:00 notice : Created server '@@Cluster-Monitor:node-3' at 10.2.15.180:3306 2019-08-15 06:09:00 info : [clustrixmon] Updated Clustrix node in bookkeeping: 3, '10.2.15.180', 3306, 3581. 2019-08-15 06:09:00 notice : Created server '@@Cluster-Monitor:node-2' at 10.2.15.89:3306 2019-08-15 06:09:00 info : [clustrixmon] Updated Clustrix node in bookkeeping: 2, '10.2.15.89', 3306, 3581. 2019-08-15 06:09:00 notice : Server changed state: BS1[10.2.13.91:3306]: new_master. [Running] -> [Master, Running] 2019-08-15 06:09:14 notice : (2) Server '@@Cluster-Monitor:node-1' version: 5.0.45-clustrix-fredonyer-16045 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 06:09:14 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 06:09:14 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 06:09:14 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 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 06:09:14 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : (2) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 06:09:14 info : (2) [readwritesplit] Servers and router connection counts: 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 06:09:14 info : (2) [readwritesplit] current operations : 0 in [10.2.13.91]:3306 Master, Running 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 06:09:14 info : (2) [readwritesplit] current operations : 0 in [10.2.15.180]:3306 Master, Running 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 06:09:14 info : (2) [readwritesplit] current operations : 0 in [10.2.15.89]:3306 Master, Running 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : (2) [readwritesplit] Connected to '@@Cluster-Monitor:node-1' 2019-08-15 06:09:14 info : (2) [readwritesplit] Selected Master: @@Cluster-Monitor:node-1 2019-08-15 06:09:14 info : (2) Started Read-Write-Service client session [2] for 'maxscale' from ::ffff:127.0.0.1 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 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 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : (2) [readwritesplit] Session write, routing to all servers. 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : (2) [readwritesplit] Route query to master: @@Cluster-Monitor:node-1 [10.2.13.91]:3306 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : (2) Connected to '@@Cluster-Monitor:node-1' with thread id 72705 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : (2) [readwritesplit] Reply complete, last reply from @@Cluster-Monitor:node-1 2019-08-15 06:09:14 notice : (1) Server 'MBS' version: 10.2.12 2.4.1-maxscale 2019-08-15 06:09:14 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 06:09:14 info : (2) [readwritesplit] Session write, routing to all servers. 2019-08-15 06:09:14 info : (2) [readwritesplit] Route query to master: @@Cluster-Monitor:node-1 [10.2.13.91]:3306 2019-08-15 06:09:14 info : (2) [readwritesplit] Reply complete, last reply from @@Cluster-Monitor:node-1 2019-08-15 06:09:14 info : (2) [readwritesplit] Session command no. 2 failed: #HY000: [8192] Relation not found: "mysql"."roles_mapping" 2019-08-15 06:09:14 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 06:09:14 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 06:09:14 info : (2) [readwritesplit] Session write, routing to all servers. 2019-08-15 06:09:14 info : (2) [readwritesplit] Route query to master: @@Cluster-Monitor:node-1 [10.2.13.91]:3306 2019-08-15 06:09:14 info : (2) [readwritesplit] Reply complete, last reply from @@Cluster-Monitor:node-1 2019-08-15 06:09:14 info : (2) [readwritesplit] Session command no. 3 failed: #42000: [11267] No such database: "mysql" 2019-08-15 06:09:14 error : (1) [MariaDBAuth] Failed to load users from server 'MBS': [11267] No such database: "mysql" 2019-08-15 06:09:14 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 06:09:14 info : (2) [readwritesplit] Route query to master: @@Cluster-Monitor:node-1 [10.2.13.91]:3306 < 2019-08-15 06:09:14 info : (2) [readwritesplit] Reply complete, last reply from @@Cluster-Monitor:node-1 2019-08-15 06:09:14 info : (1) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : (2) > Autocommit: [enabled], trx is [not open], cmd: (0x01) COM_QUIT, plen: 5, type: QUERY_TYPE_SESSION_WRITE, stmt: 2019-08-15 06:09:14 info : (2) [readwritesplit] Session write, routing to all servers. 2019-08-15 06:09:14 info : (1) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', 'localhost', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 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 06:09:14 info : (2) [readwritesplit] Route query to master: @@Cluster-Monitor:node-1 [10.2.13.91]:3306 2019-08-15 06:09:14 warning: (1) [MariaDBAuth] Read-Write-Service_rwsrvc: login attempt for user 'maxscale'@[::ffff:10.2.14.197]:37542, authentication failed. Unknown database: test 2019-08-15 06:09:14 info : Stopped Read-Write-Service client session [2] 2019-08-15 06:09:14 info : Stopped Read-Write-Service_rwsrvc client session [1] 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', '*', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:09:14 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale2', '%', 'system', 1, '7C5EBD39998B76824363C7F00CD3648CFEBB4CFD') 2019-08-15 06:13:04 info : (4) [readwritesplit] Servers and router connection counts: 2019-08-15 06:13:04 info : (4) [readwritesplit] current operations : 0 in [10.2.13.91]:3306 Master, Running 2019-08-15 06:13:04 info : (4) [readwritesplit] current operations : 0 in [10.2.15.180]:3306 Master, Running 2019-08-15 06:13:04 info : (4) [readwritesplit] current operations : 0 in [10.2.15.89]:3306 Master, Running 2019-08-15 06:13:04 info : (4) [readwritesplit] Connected to '@@Cluster-Monitor:node-1' 2019-08-15 06:13:04 info : (4) [readwritesplit] Selected Master: @@Cluster-Monitor:node-1 2019-08-15 06:13:04 info : (4) Started Read-Write-Service client session [4] for 'maxscale' from ::ffff:127.0.0.1 2019-08-15 06:13:04 info : (4) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 20, type: QUERY_TYPE_GSYSVAR_WRITE, stmt: SET SQL_MODE='' 2019-08-15 06:13:04 info : (4) [readwritesplit] Session write, routing to all servers. 2019-08-15 06:13:04 info : (4) [readwritesplit] Route query to master: @@Cluster-Monitor:node-1 [10.2.13.91]:3306 2019-08-15 06:13:04 info : (4) Connected to '@@Cluster-Monitor:node-1' with thread id 74753 2019-08-15 06:13:04 info : (4) [readwritesplit] Reply complete, last reply from @@Cluster-Monitor:node-1 2019-08-15 06:13:04 info : (4) > 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 06:13:04 info : (4) [readwritesplit] Session write, routing to all servers. 2019-08-15 06:13:04 info : (4) [readwritesplit] Route query to master: @@Cluster-Monitor:node-1 [10.2.13.91]:3306 2019-08-15 06:13:04 info : (4) [readwritesplit] Reply complete, last reply from @@Cluster-Monitor:node-1 2019-08-15 06:13:04 info : (4) [readwritesplit] Session command no. 2 failed: #HY000: [8192] Relation not found: "mysql"."roles_mapping" 2019-08-15 06:13:04 info : (4) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 14, type: QUERY_TYPE_SESSION_WRITE, stmt: USE mysql 2019-08-15 06:13:04 info : (4) [readwritesplit] Session write, routing to all servers. 2019-08-15 06:13:04 info : (4) [readwritesplit] Route query to master: @@Cluster-Monitor:node-1 [10.2.13.91]:3306 2019-08-15 06:13:04 info : (4) [readwritesplit] Reply complete, last reply from @@Cluster-Monitor:node-1 2019-08-15 06:13:04 info : (4) [readwritesplit] Session command no. 3 failed: #42000: [11267] No such database: "mysql" 2019-08-15 06:13:04 error : (3) [MariaDBAuth] Failed to load users from server 'MBS': [11267] No such database: "mysql" 2019-08-15 06:13:04 info : (4) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 19, type: QUERY_TYPE_SHOW_DATABASES, stmt: SHOW DATABASES 2019-08-15 06:13:04 info : (4) [readwritesplit] Route query to master: @@Cluster-Monitor:node-1 [10.2.13.91]:3306 < 2019-08-15 06:13:04 info : (4) [readwritesplit] Reply complete, last reply from @@Cluster-Monitor:node-1 2019-08-15 06:13:04 info : (3) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:13:04 info : (3) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', 'localhost', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-15 06:13:04 notice : (3) [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 06:13:04 info : (4) > Autocommit: [enabled], trx is [not open], cmd: (0x01) COM_QUIT, plen: 5, type: QUERY_TYPE_SESSION_WRITE, stmt: 2019-08-15 06:13:04 info : (4) [readwritesplit] Session write, routing to all servers. 2019-08-15 06:13:04 info : (4) [readwritesplit] Route query to master: @@Cluster-Monitor:node-1 [10.2.13.91]:3306 2019-08-15 06:13:04 warning: (3) [MariaDBAuth] Read-Write-Service_rwsrvc: login attempt for user 'maxscale'@[::ffff:10.2.14.197]:38730, authentication failed. Unknown database: test 2019-08-15 06:13:04 info : Stopped Read-Write-Service_rwsrvc client session [3] 2019-08-15 06:13:04 info : Stopped Read-Write-Service client session [4]