MariaDB MaxScale /data/clustrix/log/maxscale.log Wed Aug 7 22:31:47 2019 ----------------------------------------------------------------------------- 2019-08-07 22:31:47 notice : syslog logging is enabled. 2019-08-07 22:31:47 notice : maxlog logging is enabled. 2019-08-07 22:31:47 notice : The logging of informational messages has been enabled. 2019-08-07 22:31:47 notice : Using up to 7.05GiB of memory for query classifier cache 2019-08-07 22:31:47 notice : The collection of SQLite memory allocation statistics turned off. 2019-08-07 22:31:47 notice : Threading mode of SQLite set to Multi-thread. 2019-08-07 22:31:47 notice : MariaDB MaxScale 2.4.1 started (Commit: 658aae6b6c77774c34d0f52c03f63edc2d44969e) 2019-08-07 22:31:47 notice : MaxScale is running in process 4770 2019-08-07 22:31:47 notice : Configuration file: /etc/clustrix_karma108_trxreplay.cnf 2019-08-07 22:31:47 notice : Log directory: /data/clustrix/log 2019-08-07 22:31:47 notice : Data directory: /var/lib/maxscale 2019-08-07 22:31:47 notice : Module directory: /usr/lib64/maxscale 2019-08-07 22:31:47 notice : Service cache: /var/cache/maxscale 2019-08-07 22:31:47 notice : No query classifier specified, using default 'qc_sqlite'. 2019-08-07 22:31:47 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2019-08-07 22:31:47 info : qc_sqlite loaded. 2019-08-07 22:31:47 notice : Query classification results are cached and reused. Memory used per thread: 451.20MiB 2019-08-07 22:31:47 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-07 22:31:47 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-07 22:31:47 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-07 22:31:47 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-07 22:31:47 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-07 22:31:47 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-07 22:31:47 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-07 22:31:47 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-07 22:31:47 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-07 22:31:47 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-07 22:31:47 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-07 22:31:47 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-07 22:31:47 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-07 22:31:47 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-07 22:31:47 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-07 22:31:47 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-07 22:31:47 notice : Loading /etc/clustrix_karma108_trxreplay.cnf. 2019-08-07 22:31:47 notice : /etc/clustrix_karma108_trxreplay.cnf.d does not exist, not reading. 2019-08-07 22:31:47 info : [maxscaled] Initialise MaxScaled Protocol module. 2019-08-07 22:31:47 notice : Loaded module maxscaled: V2.0.0 from /usr/lib64/maxscale/libmaxscaled.so 2019-08-07 22:31:47 warning: [cli] THE 'cli' MODULE AND 'maxadmin' ARE DEPRECATED: Use 'maxctrl' instead 2019-08-07 22:31:47 notice : Loaded module cli: V1.0.0 from /usr/lib64/maxscale/libcli.so 2019-08-07 22:31:47 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2019-08-07 22:31:47 notice : [readwritesplit] Initializing statement-based read/write split router module. 2019-08-07 22:31:47 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so 2019-08-07 22:31:47 notice : [clustrixmon] Initialise the MariaDB Clustrix Monitor module. 2019-08-07 22:31:47 notice : Loaded module clustrixmon: V1.0.0 from /usr/lib64/maxscale/libclustrixmon.so 2019-08-07 22:31:47 info : Specifying durations without a suffix denoting the unit is strongly discouraged as it will be deprecated in the future: cluster_monitor_interval=10000. Use the suffixes 'h' (hour), 'm' (minute), 's' (second) or 'ms' (milliseconds). 2019-08-07 22:31:47 notice : Loaded module mariadbbackend: V2.0.0 from /usr/lib64/maxscale/libmariadbbackend.so 2019-08-07 22:31:47 notice : Loaded module mariadbbackendauth: V1.0.0 from /usr/lib64/maxscale/libmariadbbackendauth.so 2019-08-07 22:31:47 notice : [clustrixmon] sqlite3 database /var/lib/maxscale/Clustrix/clustrix_nodes-v1.db open/created and initialized. 2019-08-07 22:31:47 warning: cluster_monitor_interval: Specifying durations without a suffix denoting the unit has been deprecated: 10000. Use the suffixes 'h' (hour), 'm' (minute) 's' (second) or 'ms' (milliseconds). 2019-08-07 22:31:47 notice : Loaded module mariadbauth: V1.1.0 from /usr/lib64/maxscale/libmariadbauth.so 2019-08-07 22:31:47 notice : Loaded module MaxAdminAuth: V2.1.0 from /usr/lib64/maxscale/libmaxadminauth.so 2019-08-07 22:31:47 info : In-memory sqlite database successfully opened for thread 140453219370752. 2019-08-07 22:31:47 info : In-memory sqlite database successfully opened for thread 140453210978048. 2019-08-07 22:31:47 info : In-memory sqlite database successfully opened for thread 140453202585344. 2019-08-07 22:31:47 info : In-memory sqlite database successfully opened for thread 140453194192640. 2019-08-07 22:31:47 info : In-memory sqlite database successfully opened for thread 140453185799936. 2019-08-07 22:31:47 info : In-memory sqlite database successfully opened for thread 140453177407232. 2019-08-07 22:31:47 info : In-memory sqlite database successfully opened for thread 140453169014528. 2019-08-07 22:31:47 info : In-memory sqlite database successfully opened for thread 140453160621824. 2019-08-07 22:31:47 info : In-memory sqlite database successfully opened for thread 140452678334208. 2019-08-07 22:31:47 info : In-memory sqlite database successfully opened for thread 140452669941504. 2019-08-07 22:31:47 info : In-memory sqlite database successfully opened for thread 140452661548800. 2019-08-07 22:31:47 info : In-memory sqlite database successfully opened for thread 140452653156096. 2019-08-07 22:31:47 info : In-memory sqlite database successfully opened for thread 140452644763392. 2019-08-07 22:31:47 info : In-memory sqlite database successfully opened for thread 140452636370688. 2019-08-07 22:31:47 info : In-memory sqlite database successfully opened for thread 140452627977984. 2019-08-07 22:31:47 info : In-memory sqlite database successfully opened for thread 140452074354432. 2019-08-07 22:31:47 notice : Started REST API on [127.0.0.1]:8989 2019-08-07 22:31:47 notice : MaxScale started with 16 worker threads, each with a stack size of 8388608 bytes. 2019-08-07 22:31:47 notice : Starting a total of 2 services... 2019-08-07 22:31:47 notice : Encrypted password file /var/lib/maxscale/.secrets can't be accessed (No such file or directory). Password encryption is not used. 2019-08-07 22:31:47 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:47 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', 'localhost', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:47 notice : Listening for connections at [::]:6008 2019-08-07 22:31:47 notice : Service 'RCR' started (1/2) 2019-08-07 22:31:47 notice : Listening for connections at [/var/run/maxscale/maxadmin.sock]:0 2019-08-07 22:31:47 notice : Service 'MaxAdmin-Service' started (2/2) 2019-08-07 22:31:47 notice : Loaded server states from journal file: /var/lib/maxscale/Clustrix/monitor.dat 2019-08-07 22:31:47 notice : [clustrixmon] Clustrix: Monitoring Clustrix cluster state using node 10.2.13.91:3306. 2019-08-07 22:31:47 warning: Authenticator module 'mysqlbackendauth' has been deprecated, use 'mariadbbackendauth' instead. 2019-08-07 22:31:47 notice : Created server '@@Clustrix:node-1' at 10.2.13.91:3306 2019-08-07 22:31:47 info : [clustrixmon] Updated Clustrix node in bookkeeping: 1, '10.2.13.91', 3306, 3581. 2019-08-07 22:31:47 notice : Created server '@@Clustrix:node-3' at 10.2.15.89:3306 2019-08-07 22:31:47 info : [clustrixmon] Updated Clustrix node in bookkeeping: 3, '10.2.15.89', 3306, 3581. 2019-08-07 22:31:47 notice : Created server '@@Clustrix:node-2' at 10.2.15.180:3306 2019-08-07 22:31:47 info : [clustrixmon] Updated Clustrix node in bookkeeping: 2, '10.2.15.180', 3306, 3581. 2019-08-07 22:31:47 notice : Created server '@@Clustrix:node-4' at 10.2.14.119:3306 2019-08-07 22:31:47 info : [clustrixmon] Updated Clustrix node in bookkeeping: 4, '10.2.14.119', 3306, 3581. 2019-08-07 22:31:54 notice : (1) Server '@@Clustrix:node-1' version: 5.0.45-clustrix-fredonyer-16045 2019-08-07 22:31:54 info : (1) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : (1) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '%', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : (1) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '%', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-07 22:31:54 info : (1) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : (1) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : (1) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : (1) [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '%', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '%', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '%', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '%', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : (1) [readwritesplit] Servers and all MaxScale connection counts: 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : (1) [readwritesplit] MaxScale connections : 0 in [10.2.13.91]:3306 Master, Running 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : (1) [readwritesplit] MaxScale connections : 0 in [10.2.15.89]:3306 Master, Running 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '%', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : (1) [readwritesplit] MaxScale connections : 0 in [10.2.15.180]:3306 Master, Running 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '%', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-07 22:31:54 info : (1) [readwritesplit] MaxScale connections : 0 in [10.2.14.119]:3306 Master, Running 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : (1) [readwritesplit] Connected to '@@Clustrix:node-1' 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '%', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-07 22:31:54 info : (1) [readwritesplit] Selected Master: @@Clustrix:node-1 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '%', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '%', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-07 22:31:54 info : (1) Started RCR client session [1] for 'maxscale' from ::ffff:10.2.13.184 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '%', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : (1) Connected to '@@Clustrix:node-1' with thread id 8193 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '%', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '%', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : (1) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 37, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: select @@version_comment limit 1 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : (1) [readwritesplit] Route query to master: @@Clustrix:node-1 [10.2.13.91]:3306 < 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '%', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '%', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '%', NULL, 0, NULL) 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-07 22:31:54 info : (1) [readwritesplit] Reply complete, last reply from @@Clustrix:node-1 2019-08-07 22:32:01 info : (1) > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 33, type: QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_BEGIN_TRX|QUERY_TYPE_DISABLE_AUTOCOMMIT, stmt: set session autocommit=false 2019-08-07 22:32:01 info : (1) [readwritesplit] Session write, routing to all servers. 2019-08-07 22:32:01 info : (1) [readwritesplit] Route query to master: @@Clustrix:node-1 [10.2.13.91]:3306 2019-08-07 22:32:01 info : (1) [readwritesplit] Reply complete, last reply from @@Clustrix:node-1 2019-08-07 22:32:05 info : (1) > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:05 info : (1) [readwritesplit] Route query to master: @@Clustrix:node-1 [10.2.13.91]:3306 < 2019-08-07 22:32:05 info : (1) [readwritesplit] Adding to trx: begin 2019-08-07 22:32:05 info : (1) [readwritesplit] Reply complete, last reply from @@Clustrix:node-1 2019-08-07 22:32:08 info : (1) > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 22, type: QUERY_TYPE_READ, stmt: SELECT DATABASE() 2019-08-07 22:32:08 info : (1) [readwritesplit] Route query to master: @@Clustrix:node-1 [10.2.13.91]:3306 < 2019-08-07 22:32:08 info : (1) [readwritesplit] Adding to trx: SELECT DATABASE() 2019-08-07 22:32:08 info : (1) [readwritesplit] Reply complete, last reply from @@Clustrix:node-1 2019-08-07 22:32:08 info : (1) > Autocommit: [disabled], trx is [open], cmd: (0x02) COM_INIT_DB, plen: 9, type: QUERY_TYPE_SESSION_WRITE, stmt: 2019-08-07 22:32:08 info : (1) [readwritesplit] Session write, routing to all servers. 2019-08-07 22:32:08 info : (1) [readwritesplit] Route query to master: @@Clustrix:node-1 [10.2.13.91]:3306 2019-08-07 22:32:08 info : (1) [readwritesplit] Reply complete, last reply from @@Clustrix:node-1 2019-08-07 22:32:08 info : (1) > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 19, type: QUERY_TYPE_SHOW_DATABASES, stmt: show databases 2019-08-07 22:32:08 info : (1) [readwritesplit] Route query to master: @@Clustrix:node-1 [10.2.13.91]:3306 < 2019-08-07 22:32:08 info : (1) [readwritesplit] Adding to trx: show databases 2019-08-07 22:32:08 info : (1) [readwritesplit] Reply complete, last reply from @@Clustrix:node-1 2019-08-07 22:32:08 info : (1) > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 16, type: QUERY_TYPE_SHOW_TABLES, stmt: show tables 2019-08-07 22:32:08 info : (1) [readwritesplit] Route query to master: @@Clustrix:node-1 [10.2.13.91]:3306 < 2019-08-07 22:32:08 info : (1) [readwritesplit] Adding to trx: show tables 2019-08-07 22:32:08 info : (1) [readwritesplit] Reply complete, last reply from @@Clustrix:node-1 2019-08-07 22:32:08 info : (1) > Autocommit: [disabled], trx is [open], cmd: (0x04) COM_FIELD_LIST, plen: 8, type: , stmt: 2019-08-07 22:32:08 info : (1) [readwritesplit] Route query to master: @@Clustrix:node-1 [10.2.13.91]:3306 < 2019-08-07 22:32:08 info : (1) [readwritesplit] Adding to trx: 2019-08-07 22:32:08 info : (1) [readwritesplit] Reply complete, last reply from @@Clustrix:node-1 2019-08-07 22:32:08 info : (1) > Autocommit: [disabled], trx is [open], cmd: (0x04) COM_FIELD_LIST, plen: 8, type: , stmt: 2019-08-07 22:32:08 info : (1) [readwritesplit] Route query to master: @@Clustrix:node-1 [10.2.13.91]:3306 < 2019-08-07 22:32:08 info : (1) [readwritesplit] Adding to trx: 2019-08-07 22:32:08 info : (1) [readwritesplit] Reply complete, last reply from @@Clustrix:node-1 2019-08-07 22:32:08 info : (1) > Autocommit: [disabled], trx is [open], cmd: (0x04) COM_FIELD_LIST, plen: 8, type: , stmt: 2019-08-07 22:32:08 info : (1) [readwritesplit] Route query to master: @@Clustrix:node-1 [10.2.13.91]:3306 < 2019-08-07 22:32:08 info : (1) [readwritesplit] Adding to trx: 2019-08-07 22:32:08 info : (1) [readwritesplit] Reply complete, last reply from @@Clustrix:node-1 2019-08-07 22:32:12 info : (1) > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_WRITE, stmt: insert into t2 values (9) 2019-08-07 22:32:12 info : (1) [readwritesplit] Route query to master: @@Clustrix:node-1 [10.2.13.91]:3306 < 2019-08-07 22:32:12 info : (1) [readwritesplit] Adding to trx: insert into t2 values (9) 2019-08-07 22:32:12 info : (1) [readwritesplit] Reply complete, last reply from @@Clustrix:node-1 2019-08-07 22:32:36 info : (1) [readwritesplit] Master '@@Clustrix:node-1' failed: #HY000: Lost connection to backend server. 2019-08-07 22:32:36 info : (1) [readwritesplit] Starting transaction replay 1 2019-08-07 22:32:36 info : (1) [readwritesplit] Replaying: begin 2019-08-07 22:32:37 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:37 info : [readwritesplit] Connected to '@@Clustrix:node-1' 2019-08-07 22:32:37 info : [readwritesplit] Queuing query until '@@Clustrix:node-1' completes session command 2019-08-07 22:32:37 info : (1) [readwritesplit] Master '@@Clustrix:node-1' failed: #HY000: Lost connection to backend server. 2019-08-07 22:32:37 info : (1) [readwritesplit] Starting transaction replay 2 2019-08-07 22:32:37 info : (1) [readwritesplit] Replaying: begin 2019-08-07 22:32:38 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:38 info : [readwritesplit] Connected to '@@Clustrix:node-1' 2019-08-07 22:32:38 info : [readwritesplit] Queuing query until '@@Clustrix:node-1' completes session command 2019-08-07 22:32:38 info : (1) [readwritesplit] Master '@@Clustrix:node-1' failed: #HY000: Lost connection to backend server. 2019-08-07 22:32:38 info : (1) [readwritesplit] Starting transaction replay 3 2019-08-07 22:32:38 info : (1) [readwritesplit] Replaying: begin 2019-08-07 22:32:39 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:39 info : [readwritesplit] Connected to '@@Clustrix:node-1' 2019-08-07 22:32:39 info : [readwritesplit] Queuing query until '@@Clustrix:node-1' completes session command 2019-08-07 22:32:39 info : (1) [readwritesplit] Master '@@Clustrix:node-1' failed: #HY000: Lost connection to backend server. 2019-08-07 22:32:39 info : (1) [readwritesplit] Starting transaction replay 4 2019-08-07 22:32:39 info : (1) [readwritesplit] Replaying: begin 2019-08-07 22:32:39 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.13.91:3306: Can't connect to MySQL server on '10.2.13.91' (115) 2019-08-07 22:32:39 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.13.91:3306: Can't connect to MySQL server on '10.2.13.91' (115) 2019-08-07 22:32:39 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.180:3306: Can't connect to MySQL server on '10.2.15.180' (115) 2019-08-07 22:32:39 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.89:3306: Can't connect to MySQL server on '10.2.15.89' (115) 2019-08-07 22:32:39 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.14.119:3306: Can't connect to MySQL server on '10.2.14.119' (115) 2019-08-07 22:32:39 notice : [clustrixmon] Attempting to find a Clustrix bootstrap node from one of the nodes used during the previous run of MaxScale. 2019-08-07 22:32:39 error : [clustrixmon] Clustrix: Could not connect to any server or no server that could be connected to was part of the quorum. 2019-08-07 22:32:39 info : [clustrixmon] Deleted Clustrix node 1 from bookkeeping. 2019-08-07 22:32:39 info : [clustrixmon] Deleted Clustrix node 2 from bookkeeping. 2019-08-07 22:32:39 info : [clustrixmon] Deleted Clustrix node 3 from bookkeeping. 2019-08-07 22:32:39 info : [clustrixmon] Deleted Clustrix node 4 from bookkeeping. 2019-08-07 22:32:40 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:40 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:41 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:41 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:42 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.13.91:3306: Can't connect to MySQL server on '10.2.13.91' (115) 2019-08-07 22:32:42 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.180:3306: Can't connect to MySQL server on '10.2.15.180' (115) 2019-08-07 22:32:42 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.89:3306: Can't connect to MySQL server on '10.2.15.89' (115) 2019-08-07 22:32:42 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.14.119:3306: Can't connect to MySQL server on '10.2.14.119' (115) 2019-08-07 22:32:42 notice : [clustrixmon] Attempting to find a Clustrix bootstrap node from one of the nodes used during the previous run of MaxScale. 2019-08-07 22:32:42 error : [clustrixmon] Clustrix: Could not connect to any server or no server that could be connected to was part of the quorum. 2019-08-07 22:32:42 notice : Server changed state: Bootstrap1-karma108[10.2.13.91:3306]: master_down. [Master, Running] -> [Down] 2019-08-07 22:32:42 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:42 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:42 info : (1) [readwritesplit] New query received while transaction replay is active: insert into t2 values (9) 2019-08-07 22:32:43 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:43 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:44 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.13.91:3306: Can't connect to MySQL server on '10.2.13.91' (115) 2019-08-07 22:32:44 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.180:3306: Can't connect to MySQL server on '10.2.15.180' (115) 2019-08-07 22:32:44 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.89:3306: Can't connect to MySQL server on '10.2.15.89' (115) 2019-08-07 22:32:44 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.14.119:3306: Can't connect to MySQL server on '10.2.14.119' (115) 2019-08-07 22:32:44 notice : [clustrixmon] Attempting to find a Clustrix bootstrap node from one of the nodes used during the previous run of MaxScale. 2019-08-07 22:32:44 error : [clustrixmon] Clustrix: Could not connect to any server or no server that could be connected to was part of the quorum. 2019-08-07 22:32:44 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:44 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:45 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:45 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:46 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.13.91:3306: Can't connect to MySQL server on '10.2.13.91' (115) 2019-08-07 22:32:46 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.180:3306: Can't connect to MySQL server on '10.2.15.180' (115) 2019-08-07 22:32:46 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.89:3306: Can't connect to MySQL server on '10.2.15.89' (115) 2019-08-07 22:32:46 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.14.119:3306: Can't connect to MySQL server on '10.2.14.119' (115) 2019-08-07 22:32:46 notice : [clustrixmon] Attempting to find a Clustrix bootstrap node from one of the nodes used during the previous run of MaxScale. 2019-08-07 22:32:46 error : [clustrixmon] Clustrix: Could not connect to any server or no server that could be connected to was part of the quorum. 2019-08-07 22:32:46 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:46 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:47 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:47 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:48 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.13.91:3306: Can't connect to MySQL server on '10.2.13.91' (115) 2019-08-07 22:32:48 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.180:3306: Can't connect to MySQL server on '10.2.15.180' (115) 2019-08-07 22:32:48 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.89:3306: Can't connect to MySQL server on '10.2.15.89' (115) 2019-08-07 22:32:48 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.14.119:3306: Can't connect to MySQL server on '10.2.14.119' (115) 2019-08-07 22:32:48 notice : [clustrixmon] Attempting to find a Clustrix bootstrap node from one of the nodes used during the previous run of MaxScale. 2019-08-07 22:32:48 error : [clustrixmon] Clustrix: Could not connect to any server or no server that could be connected to was part of the quorum. 2019-08-07 22:32:48 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:48 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:49 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:49 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:50 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:50 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:50 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.13.91:3306: Can't connect to MySQL server on '10.2.13.91' (115) 2019-08-07 22:32:50 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.180:3306: Can't connect to MySQL server on '10.2.15.180' (115) 2019-08-07 22:32:50 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.89:3306: Can't connect to MySQL server on '10.2.15.89' (115) 2019-08-07 22:32:50 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.14.119:3306: Can't connect to MySQL server on '10.2.14.119' (115) 2019-08-07 22:32:50 notice : [clustrixmon] Attempting to find a Clustrix bootstrap node from one of the nodes used during the previous run of MaxScale. 2019-08-07 22:32:50 error : [clustrixmon] Clustrix: Could not connect to any server or no server that could be connected to was part of the quorum. 2019-08-07 22:32:51 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:51 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:52 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:52 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:52 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.13.91:3306: Can't connect to MySQL server on '10.2.13.91' (115) 2019-08-07 22:32:52 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.180:3306: Can't connect to MySQL server on '10.2.15.180' (115) 2019-08-07 22:32:52 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.89:3306: Can't connect to MySQL server on '10.2.15.89' (115) 2019-08-07 22:32:52 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.14.119:3306: Can't connect to MySQL server on '10.2.14.119' (115) 2019-08-07 22:32:52 notice : [clustrixmon] Attempting to find a Clustrix bootstrap node from one of the nodes used during the previous run of MaxScale. 2019-08-07 22:32:52 error : [clustrixmon] Clustrix: Could not connect to any server or no server that could be connected to was part of the quorum. 2019-08-07 22:32:53 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:53 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:54 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:54 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:54 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.13.91:3306: Can't connect to MySQL server on '10.2.13.91' (115) 2019-08-07 22:32:54 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.180:3306: Can't connect to MySQL server on '10.2.15.180' (115) 2019-08-07 22:32:54 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.89:3306: Can't connect to MySQL server on '10.2.15.89' (115) 2019-08-07 22:32:54 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.14.119:3306: Can't connect to MySQL server on '10.2.14.119' (115) 2019-08-07 22:32:54 notice : [clustrixmon] Attempting to find a Clustrix bootstrap node from one of the nodes used during the previous run of MaxScale. 2019-08-07 22:32:54 error : [clustrixmon] Clustrix: Could not connect to any server or no server that could be connected to was part of the quorum. 2019-08-07 22:32:55 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:55 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:56 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:56 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:56 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.13.91:3306: Can't connect to MySQL server on '10.2.13.91' (115) 2019-08-07 22:32:56 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.180:3306: Can't connect to MySQL server on '10.2.15.180' (115) 2019-08-07 22:32:56 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.89:3306: Can't connect to MySQL server on '10.2.15.89' (115) 2019-08-07 22:32:56 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.14.119:3306: Can't connect to MySQL server on '10.2.14.119' (115) 2019-08-07 22:32:56 notice : [clustrixmon] Attempting to find a Clustrix bootstrap node from one of the nodes used during the previous run of MaxScale. 2019-08-07 22:32:56 error : [clustrixmon] Clustrix: Could not connect to any server or no server that could be connected to was part of the quorum. 2019-08-07 22:32:57 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:57 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:58 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:58 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:32:58 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.13.91:3306: Can't connect to MySQL server on '10.2.13.91' (115) 2019-08-07 22:32:58 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.180:3306: Can't connect to MySQL server on '10.2.15.180' (115) 2019-08-07 22:32:58 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.89:3306: Can't connect to MySQL server on '10.2.15.89' (115) 2019-08-07 22:32:58 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.14.119:3306: Can't connect to MySQL server on '10.2.14.119' (115) 2019-08-07 22:32:58 notice : [clustrixmon] Attempting to find a Clustrix bootstrap node from one of the nodes used during the previous run of MaxScale. 2019-08-07 22:32:58 error : [clustrixmon] Clustrix: Could not connect to any server or no server that could be connected to was part of the quorum. 2019-08-07 22:32:59 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:32:59 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:33:00 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:33:00 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:33:00 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.13.91:3306: Can't connect to MySQL server on '10.2.13.91' (115) 2019-08-07 22:33:00 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.180:3306: Can't connect to MySQL server on '10.2.15.180' (115) 2019-08-07 22:33:00 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.89:3306: Can't connect to MySQL server on '10.2.15.89' (115) 2019-08-07 22:33:00 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.14.119:3306: Can't connect to MySQL server on '10.2.14.119' (115) 2019-08-07 22:33:00 notice : [clustrixmon] Attempting to find a Clustrix bootstrap node from one of the nodes used during the previous run of MaxScale. 2019-08-07 22:33:00 error : [clustrixmon] Clustrix: Could not connect to any server or no server that could be connected to was part of the quorum. 2019-08-07 22:33:01 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:33:01 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:33:02 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:33:02 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:33:03 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.13.91:3306: Can't connect to MySQL server on '10.2.13.91' (115) 2019-08-07 22:33:03 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.180:3306: Can't connect to MySQL server on '10.2.15.180' (115) 2019-08-07 22:33:03 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.15.89:3306: Can't connect to MySQL server on '10.2.15.89' (115) 2019-08-07 22:33:03 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.14.119:3306: Can't connect to MySQL server on '10.2.14.119' (115) 2019-08-07 22:33:03 notice : [clustrixmon] Attempting to find a Clustrix bootstrap node from one of the nodes used during the previous run of MaxScale. 2019-08-07 22:33:03 error : [clustrixmon] Clustrix: Could not connect to any server or no server that could be connected to was part of the quorum. 2019-08-07 22:33:03 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:33:03 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:33:04 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:33:04 info : [readwritesplit] Delaying routing: begin 2019-08-07 22:33:05 notice : [clustrixmon] Clustrix: Monitoring Clustrix cluster state using node 10.2.13.91:3306. 2019-08-07 22:33:05 info : [clustrixmon] Updated Clustrix node in bookkeeping: 1, '10.2.13.91', 3306, 3581. 2019-08-07 22:33:05 info : [clustrixmon] Updated Clustrix node in bookkeeping: 2, '10.2.15.180', 3306, 3581. 2019-08-07 22:33:05 info : [clustrixmon] Updated Clustrix node in bookkeeping: 3, '10.2.15.89', 3306, 3581. 2019-08-07 22:33:05 info : [clustrixmon] Updated Clustrix node in bookkeeping: 4, '10.2.14.119', 3306, 3581. 2019-08-07 22:33:05 info : > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-07 22:33:05 info : [readwritesplit] Connected to '@@Clustrix:node-1' 2019-08-07 22:33:05 info : [readwritesplit] Queuing query until '@@Clustrix:node-1' completes session command 2019-08-07 22:33:05 info : (1) Connected to '@@Clustrix:node-1' with thread id 3073 2019-08-07 22:33:05 info : (1) [readwritesplit] Reply complete, last reply from @@Clustrix:node-1 2019-08-07 22:33:05 info : (1) [readwritesplit] 1 session commands left on '@@Clustrix:node-1' 2019-08-07 22:33:05 info : (1) [readwritesplit] Reply complete, last reply from @@Clustrix:node-1 2019-08-07 22:33:05 info : (1) [readwritesplit] >>> Routing stored queries 2019-08-07 22:33:05 info : (1) [readwritesplit] New query received while transaction replay is active: insert into t2 values (9) 2019-08-07 22:33:05 info : (1) [readwritesplit] <<< Stored queries routed 2019-08-07 22:33:07 notice : Server changed state: Bootstrap1-karma108[10.2.13.91:3306]: master_up. [Down] -> [Master, Running]