MariaDB MaxScale /var/log/maxscale/maxscale.log Wed Aug 28 11:51:30 2019 ---------------------------------------------------------------------------- 2019-08-28 11:51:30 notice : (mxb_log_set_syslog_enabled): syslog logging is enabled. 2019-08-28 11:51:30 notice : (mxb_log_set_maxlog_enabled): maxlog logging is enabled. 2019-08-28 11:51:30 warning: (handle_global_item): Number of threads set to 4, which is greater than the number of processors available: 2 2019-08-28 11:51:30 notice : (mxb_log_set_priority_enabled): The logging of informational messages has been enabled. 2019-08-28 11:51:30 notice : (config_load_global): Using up to 1.07GiB of memory for query classifier cache 2019-08-28 11:51:30 notice : (init_sqlite3): The collection of SQLite memory allocation statistics turned off. 2019-08-28 11:51:30 notice : (init_sqlite3): Threading mode of SQLite set to Multi-thread. 2019-08-28 11:51:30 notice : (main): MariaDB MaxScale 2.4.1 started (Commit: 658aae6b6c77774c34d0f52c03f63edc2d44969e) 2019-08-28 11:51:30 notice : (main): MaxScale is running in process 13024 2019-08-28 11:51:30 notice : (main): Configuration file: /etc/maxscale.cnf 2019-08-28 11:51:30 notice : (main): Log directory: /var/log/maxscale 2019-08-28 11:51:30 notice : (main): Data directory: /var/lib/maxscale 2019-08-28 11:51:30 notice : (main): Module directory: /usr/lib64/maxscale 2019-08-28 11:51:30 notice : (main): Service cache: /var/cache/maxscale 2019-08-28 11:51:30 notice : (qc_setup): No query classifier specified, using default 'qc_sqlite'. 2019-08-28 11:51:30 notice : (load_module): Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2019-08-28 11:51:30 info : (qc_load): qc_sqlite loaded. 2019-08-28 11:51:30 notice : (qc_setup): Query classification results are cached and reused. Memory used per thread: 273.67MiB 2019-08-28 11:51:30 info : (create): Epoll instance for listening sockets added to worker epoll instance. 2019-08-28 11:51:30 info : (create): Epoll instance for listening sockets added to worker epoll instance. 2019-08-28 11:51:30 info : (create): Epoll instance for listening sockets added to worker epoll instance. 2019-08-28 11:51:30 info : (create): Epoll instance for listening sockets added to worker epoll instance. 2019-08-28 11:51:30 notice : (config_load_single_file): Loading /etc/maxscale.cnf. 2019-08-28 11:51:30 notice : (is_directory): /etc/maxscale.cnf.d does not exist, not reading. 2019-08-28 11:51:30 info : [maxscaled] (mxs_get_module_object): Initialise MaxScaled Protocol module. 2019-08-28 11:51:30 notice : (load_module): Loaded module maxscaled: V2.0.0 from /usr/lib64/maxscale/libmaxscaled.so 2019-08-28 11:51:30 warning: [cli] (mxs_get_module_object): THE 'cli' MODULE AND 'maxadmin' ARE DEPRECATED: Use 'maxctrl' instead 2019-08-28 11:51:30 notice : (load_module): Loaded module cli: V1.0.0 from /usr/lib64/maxscale/libcli.so 2019-08-28 11:51:30 warning: (mxs_module_get_effective_name): Protocol module 'mysqlclient' has been deprecated, use 'mariadbclient' instead. 2019-08-28 11:51:30 notice : (load_module): Loaded module mariadbclient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2019-08-28 11:51:30 notice : [readconnroute] (mxs_get_module_object): Initialise readconnroute router module. 2019-08-28 11:51:30 notice : (load_module): Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so 2019-08-28 11:51:30 notice : [readwritesplit] (mxs_get_module_object): Initializing statement-based read/write split router module. 2019-08-28 11:51:30 notice : (load_module): Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so 2019-08-28 11:51:30 notice : [clustrixmon] (mxs_get_module_object): Initialise the MariaDB Clustrix Monitor module. 2019-08-28 11:51:30 notice : (load_module): Loaded module clustrixmon: V1.0.0 from /usr/lib64/maxscale/libclustrixmon.so 2019-08-28 11:51:30 warning: (mxs_module_get_effective_name): Protocol module 'mysqlbackend' has been deprecated, use 'mariadbbackend' instead. 2019-08-28 11:51:30 notice : (load_module): Loaded module mariadbbackend: V2.0.0 from /usr/lib64/maxscale/libmariadbbackend.so 2019-08-28 11:51:30 notice : (load_module): Loaded module mariadbbackendauth: V1.0.0 from /usr/lib64/maxscale/libmariadbbackendauth.so 2019-08-28 11:51:30 notice : [clustrixmon] (open_or_create_db): sqlite3 database /var/lib/maxscale/Clustrix-Monitor/clustrix_nodes-v1.db open/created and initialized. 2019-08-28 11:51:30 notice : (load_module): Loaded module mariadbauth: V1.1.0 from /usr/lib64/maxscale/libmariadbauth.so 2019-08-28 11:51:30 notice : (load_module): Loaded module MaxAdminAuth: V2.1.0 from /usr/lib64/maxscale/libmaxadminauth.so 2019-08-28 11:51:30 info : (qc_sqlite_thread_init): In-memory sqlite database successfully opened for thread 140146133120768. 2019-08-28 11:51:30 info : (qc_sqlite_thread_init): In-memory sqlite database successfully opened for thread 140146124728064. 2019-08-28 11:51:30 info : (qc_sqlite_thread_init): In-memory sqlite database successfully opened for thread 140146116335360. 2019-08-28 11:51:30 info : (qc_sqlite_thread_init): In-memory sqlite database successfully opened for thread 140146107942656. 2019-08-28 11:51:30 notice : (main): Started REST API on [127.0.0.1]:8989 2019-08-28 11:51:30 notice : (main): MaxScale started with 4 worker threads, each with a stack size of 8388608 bytes. 2019-08-28 11:51:30 notice : (service_launch_all): Starting a total of 3 services... 2019-08-28 11:51:30 notice : (secrets_readKeys): Encrypted password file /var/lib/maxscale/.secrets can't be accessed (No such file or directory). Password encryption is not used. 2019-08-28 11:51:30 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxskysql', '%', NULL, 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:30 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxskysql', 'localhost', NULL, 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:30 notice : (listen): Listening for connections at [::]:4008 2019-08-28 11:51:30 notice : (service_launch_all): Service 'RCR' started (1/3) 2019-08-28 11:51:30 notice : (listen): Listening for connections at [/var/run/maxscale/maxadmin.sock]:0 2019-08-28 11:51:30 notice : (service_launch_all): Service 'CLI' started (2/3) 2019-08-28 11:51:30 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxskysql', '%', NULL, 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:30 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxskysql', 'localhost', NULL, 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:30 notice : (listen): Listening for connections at [::]:4006 2019-08-28 11:51:30 notice : (service_launch_all): Service 'RWS' started (3/3) 2019-08-28 11:51:30 notice : (load_server_journal): Loaded server states from journal file: /var/lib/maxscale/Clustrix-Monitor/monitor.dat 2019-08-28 11:51:30 notice : [clustrixmon] (choose_hub): Clustrix-Monitor: Monitoring Clustrix cluster state using node 10.13.117.74:3306. 2019-08-28 11:51:30 warning: (mxs_module_get_effective_name): Authenticator module 'mysqlbackendauth' has been deprecated, use 'mariadbbackendauth' instead. 2019-08-28 11:51:30 notice : (runtime_create_server): Created server '@@Clustrix-Monitor:node-1' at 10.13.117.74:3306 2019-08-28 11:51:30 info : [clustrixmon] (persist): Updated Clustrix node in bookkeeping: 1, '10.13.117.74', 3306, 3581. 2019-08-28 11:51:30 notice : (runtime_create_server): Created server '@@Clustrix-Monitor:node-2' at 10.34.126.45:3306 2019-08-28 11:51:30 info : [clustrixmon] (persist): Updated Clustrix node in bookkeeping: 2, '10.34.126.45', 3306, 3581. 2019-08-28 11:51:30 notice : (runtime_create_server): Created server '@@Clustrix-Monitor:node-3' at 10.37.59.101:3306 2019-08-28 11:51:30 info : [clustrixmon] (persist): Updated Clustrix node in bookkeeping: 3, '10.37.59.101', 3306, 3581. 2019-08-28 11:51:30 notice : (runtime_create_server): Created server '@@Clustrix-Monitor:node-4' at 10.38.7.194:3306 2019-08-28 11:51:30 info : [clustrixmon] (persist): Updated Clustrix node in bookkeeping: 4, '10.38.7.194', 3306, 3581. 2019-08-28 11:51:39 notice : (1) (set_version): Server '@@Clustrix-Monitor:node-1' version: 5.0.45-clustrix-9.1.4 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('', '%', '*', 1, NULL) 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('skysql', '%', '*', 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('repl', '%', '*', 1, 'A424E797037BF97C19A2E88CF7891C5C2038C039') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('repl', 'localhost', '*', 1, 'A424E797037BF97C19A2E88CF7891C5C2038C039') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('', '%', '*', 1, NULL) 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('skysql', '%', '*', 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('repl', '%', '*', 1, 'A424E797037BF97C19A2E88CF7891C5C2038C039') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('repl', 'localhost', '*', 1, 'A424E797037BF97C19A2E88CF7891C5C2038C039') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('skysql', 'localhost', '*', 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxskysql', '%', '*', 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:39 info : (1) [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-28 11:51:39 info : (1) [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-08-28 11:51:39 info : (1) [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-08-28 11:51:39 info : (1) [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-28 11:51:39 info : (1) [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-28 11:51:39 info : (1) [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('', '%', '*', 1, NULL) 2019-08-28 11:51:39 info : (1) [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('skysql', '%', '*', 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:39 info : (1) [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('repl', '%', '*', 1, 'A424E797037BF97C19A2E88CF7891C5C2038C039') 2019-08-28 11:51:39 info : (1) [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('repl', 'localhost', '*', 1, 'A424E797037BF97C19A2E88CF7891C5C2038C039') 2019-08-28 11:51:39 info : (1) [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('skysql', 'localhost', '*', 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:39 info : (1) [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxskysql', '%', '*', 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:39 info : (1) [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxskysql', 'localhost', '*', 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:39 info : (1) [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxuser', '%', '*', 1, '5EDBD32E469DAE0CE10E6999C3899DEFCB9F12E0') 2019-08-28 11:51:39 info : (1) [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxuser', 'localhost', '*', 1, '5EDBD32E469DAE0CE10E6999C3899DEFCB9F12E0') 2019-08-28 11:51:39 info : (1) [readwritesplit] (log_server_connections): Servers and all MaxScale connection counts: 2019-08-28 11:51:39 info : (1) [readwritesplit] (log_server_connections): MaxScale connections : 0 in [10.13.117.74]:3306 Master, Running 2019-08-28 11:51:39 info : (1) [readwritesplit] (log_server_connections): MaxScale connections : 0 in [10.34.126.45]:3306 Master, Running 2019-08-28 11:51:39 info : (1) [readwritesplit] (log_server_connections): MaxScale connections : 0 in [10.37.59.101]:3306 Master, Running 2019-08-28 11:51:39 info : (1) [readwritesplit] (log_server_connections): MaxScale connections : 0 in [10.38.7.194]:3306 Master, Running 2019-08-28 11:51:39 info : (1) [readwritesplit] (prepare_connection): Connected to '@@Clustrix-Monitor:node-1' 2019-08-28 11:51:39 info : (1) [readwritesplit] (open_connections): Selected Master: @@Clustrix-Monitor:node-1 2019-08-28 11:51:39 info : (1) (session_start): Started RWS client session [1] for 'skysql' from ::ffff:127.0.0.1 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxskysql', 'localhost', '*', 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxuser', '%', '*', 1, '5EDBD32E469DAE0CE10E6999C3899DEFCB9F12E0') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxuser', 'localhost', '*', 1, '5EDBD32E469DAE0CE10E6999C3899DEFCB9F12E0') 2019-08-28 11:51:39 info : (1) (gw_decode_mysql_server_handshake): Connected to '@@Clustrix-Monitor:node-1' with thread id 61441 2019-08-28 11:51:39 notice : (1) [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:51:39 info : (1) (log_transaction_status): > 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-28 11:51:39 info : (1) [readwritesplit] (handle_got_target): Route query to master: @@Clustrix-Monitor:node-1 [10.13.117.74]:3306 < 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('', '%', '*', 1, NULL) 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('skysql', '%', '*', 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('repl', '%', '*', 1, 'A424E797037BF97C19A2E88CF7891C5C2038C039') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('repl', 'localhost', '*', 1, 'A424E797037BF97C19A2E88CF7891C5C2038C039') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('skysql', 'localhost', '*', 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxskysql', '%', '*', 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxskysql', 'localhost', '*', 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxuser', '%', '*', 1, '5EDBD32E469DAE0CE10E6999C3899DEFCB9F12E0') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxuser', 'localhost', '*', 1, '5EDBD32E469DAE0CE10E6999C3899DEFCB9F12E0') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('skysql', 'localhost', '*', 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxskysql', '%', '*', 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:39 notice : (1) [readwritesplit] (clientReply): RWSplitSession::clientReply() 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxskysql', 'localhost', '*', 1, '85058F5DEAD82AE3507664C2C11BDA7B1827B80D') 2019-08-28 11:51:39 info : (1) [readwritesplit] (clientReply): Reply complete, last reply from @@Clustrix-Monitor:node-1 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxuser', '%', '*', 1, '5EDBD32E469DAE0CE10E6999C3899DEFCB9F12E0') 2019-08-28 11:51:39 info : [MariaDBAuth] (add_mysql_user): Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxuser', 'localhost', '*', 1, '5EDBD32E469DAE0CE10E6999C3899DEFCB9F12E0') 2019-08-28 11:51:42 notice : (1) [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:51:42 info : (1) (log_transaction_status): > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 22, type: QUERY_TYPE_READ, stmt: SELECT DATABASE() 2019-08-28 11:51:42 info : (1) [readwritesplit] (handle_got_target): Route query to master: @@Clustrix-Monitor:node-1 [10.13.117.74]:3306 < 2019-08-28 11:51:42 notice : (1) [readwritesplit] (clientReply): RWSplitSession::clientReply() 2019-08-28 11:51:42 info : (1) [readwritesplit] (clientReply): Reply complete, last reply from @@Clustrix-Monitor:node-1 2019-08-28 11:51:42 notice : (1) [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:51:42 info : (1) (log_transaction_status): > Autocommit: [enabled], trx is [not open], cmd: (0x02) COM_INIT_DB, plen: 9, type: QUERY_TYPE_SESSION_WRITE, stmt: 2019-08-28 11:51:42 info : (1) [readwritesplit] (route_session_write): Session write, routing to all servers. 2019-08-28 11:51:42 info : (1) [readwritesplit] (route_session_write): Route query to master: @@Clustrix-Monitor:node-1 [10.13.117.74]:3306 2019-08-28 11:51:42 notice : (1) [readwritesplit] (clientReply): RWSplitSession::clientReply() 2019-08-28 11:51:42 info : (1) [readwritesplit] (clientReply): Reply complete, last reply from @@Clustrix-Monitor:node-1 2019-08-28 11:51:42 notice : (1) [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:51:42 info : (1) (log_transaction_status): > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 19, type: QUERY_TYPE_SHOW_DATABASES, stmt: show databases 2019-08-28 11:51:42 info : (1) [readwritesplit] (handle_got_target): Route query to master: @@Clustrix-Monitor:node-1 [10.13.117.74]:3306 < 2019-08-28 11:51:42 notice : (1) [readwritesplit] (clientReply): RWSplitSession::clientReply() 2019-08-28 11:51:42 info : (1) [readwritesplit] (clientReply): Reply complete, last reply from @@Clustrix-Monitor:node-1 2019-08-28 11:51:42 notice : (1) [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:51:42 info : (1) (log_transaction_status): > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 16, type: QUERY_TYPE_SHOW_TABLES, stmt: show tables 2019-08-28 11:51:42 info : (1) [readwritesplit] (handle_got_target): Route query to master: @@Clustrix-Monitor:node-1 [10.13.117.74]:3306 < 2019-08-28 11:51:43 notice : (1) [readwritesplit] (clientReply): RWSplitSession::clientReply() 2019-08-28 11:51:43 info : (1) [readwritesplit] (clientReply): Reply complete, last reply from @@Clustrix-Monitor:node-1 2019-08-28 11:51:43 notice : (1) [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:51:43 info : (1) (log_transaction_status): > Autocommit: [enabled], trx is [not open], cmd: (0x04) COM_FIELD_LIST, plen: 17, type: , stmt: 2019-08-28 11:51:43 info : (1) [readwritesplit] (handle_got_target): Route query to master: @@Clustrix-Monitor:node-1 [10.13.117.74]:3306 < 2019-08-28 11:51:43 notice : (1) [readwritesplit] (clientReply): RWSplitSession::clientReply() 2019-08-28 11:51:43 info : (1) [readwritesplit] (clientReply): Reply complete, last reply from @@Clustrix-Monitor:node-1 2019-08-28 11:51:43 notice : (1) [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:51:43 info : (1) (log_transaction_status): > Autocommit: [enabled], trx is [not open], cmd: (0x04) COM_FIELD_LIST, plen: 8, type: , stmt: 2019-08-28 11:51:43 info : (1) [readwritesplit] (handle_got_target): Route query to master: @@Clustrix-Monitor:node-1 [10.13.117.74]:3306 < 2019-08-28 11:51:43 notice : (1) [readwritesplit] (clientReply): RWSplitSession::clientReply() 2019-08-28 11:51:43 info : (1) [readwritesplit] (clientReply): Reply complete, last reply from @@Clustrix-Monitor:node-1 2019-08-28 11:51:49 notice : (1) [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:51:49 info : (1) (log_transaction_status): > 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-28 11:51:49 info : (1) [readwritesplit] (route_session_write): Session write, routing to all servers. 2019-08-28 11:51:49 info : (1) [readwritesplit] (route_session_write): Route query to master: @@Clustrix-Monitor:node-1 [10.13.117.74]:3306 2019-08-28 11:51:49 notice : (1) [readwritesplit] (clientReply): RWSplitSession::clientReply() 2019-08-28 11:51:49 info : (1) [readwritesplit] (clientReply): Reply complete, last reply from @@Clustrix-Monitor:node-1 2019-08-28 11:51:51 notice : (1) [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:51:51 info : (1) (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:51:51 info : (1) [readwritesplit] (handle_got_target): Route query to master: @@Clustrix-Monitor:node-1 [10.13.117.74]:3306 < 2019-08-28 11:51:51 notice : (1) [readwritesplit] (clientReply): RWSplitSession::clientReply() 2019-08-28 11:51:51 info : (1) [readwritesplit] (add_stmt): Adding to trx: begin 2019-08-28 11:51:51 info : (1) [readwritesplit] (clientReply): Reply complete, last reply from @@Clustrix-Monitor:node-1 2019-08-28 11:51:54 notice : (1) [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:51:54 info : (1) (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_WRITE, stmt: insert into t2 values (9) 2019-08-28 11:51:54 info : (1) [readwritesplit] (handle_got_target): Route query to master: @@Clustrix-Monitor:node-1 [10.13.117.74]:3306 < 2019-08-28 11:51:54 notice : (1) [readwritesplit] (clientReply): RWSplitSession::clientReply() 2019-08-28 11:51:54 info : (1) [readwritesplit] (add_stmt): Adding to trx: insert into t2 values (9) 2019-08-28 11:51:54 info : (1) [readwritesplit] (clientReply): Reply complete, last reply from @@Clustrix-Monitor:node-1 2019-08-28 11:52:01 notice : (1) [readwritesplit] (handleError): RWSplitSesison::handleError() 2019-08-28 11:52:01 info : (1) [readwritesplit] (handleError): Master '@@Clustrix-Monitor:node-1' failed: #HY000: Lost connection to backend server. 2019-08-28 11:52:01 info : (1) [readwritesplit] (start_trx_replay): Starting transaction replay 1 2019-08-28 11:52:01 info : (1) [readwritesplit] (start_trx_replay): Replaying: begin 2019-08-28 11:52:02 notice : [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:02 info : (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:52:02 info : [readwritesplit] (prepare_connection): Connected to '@@Clustrix-Monitor:node-1' 2019-08-28 11:52:02 info : [readwritesplit] (route_single_stmt): Queuing query until '@@Clustrix-Monitor:node-1' completes session command 2019-08-28 11:52:02 notice : (1) [readwritesplit] (handleError): RWSplitSesison::handleError() 2019-08-28 11:52:02 info : (1) [readwritesplit] (handleError): Master '@@Clustrix-Monitor:node-1' failed: #HY000: Lost connection to backend server. 2019-08-28 11:52:02 notice : (1) [readwritesplit] (handleError): REPLAY IS ACTIVE 2019-08-28 11:52:02 info : (1) [readwritesplit] (start_trx_replay): Starting transaction replay 2 2019-08-28 11:52:02 info : (1) [readwritesplit] (start_trx_replay): Replaying: begin 2019-08-28 11:52:03 notice : [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:03 info : (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:52:03 info : [readwritesplit] (prepare_connection): Connected to '@@Clustrix-Monitor:node-1' 2019-08-28 11:52:03 info : [readwritesplit] (route_single_stmt): Queuing query until '@@Clustrix-Monitor:node-1' completes session command 2019-08-28 11:52:03 notice : (1) [readwritesplit] (handleError): RWSplitSesison::handleError() 2019-08-28 11:52:03 info : (1) [readwritesplit] (handleError): Master '@@Clustrix-Monitor:node-1' failed: #HY000: Lost connection to backend server. 2019-08-28 11:52:03 notice : (1) [readwritesplit] (handleError): REPLAY IS ACTIVE 2019-08-28 11:52:03 info : (1) [readwritesplit] (start_trx_replay): Starting transaction replay 3 2019-08-28 11:52:03 info : (1) [readwritesplit] (start_trx_replay): Replaying: begin 2019-08-28 11:52:04 notice : [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:04 info : (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:52:04 info : [readwritesplit] (prepare_connection): Connected to '@@Clustrix-Monitor:node-1' 2019-08-28 11:52:04 info : [readwritesplit] (route_single_stmt): Queuing query until '@@Clustrix-Monitor:node-1' completes session command 2019-08-28 11:52:04 notice : (1) [readwritesplit] (handleError): RWSplitSesison::handleError() 2019-08-28 11:52:04 info : (1) [readwritesplit] (handleError): Master '@@Clustrix-Monitor:node-1' failed: #HY000: Lost connection to backend server. 2019-08-28 11:52:04 notice : (1) [readwritesplit] (handleError): REPLAY IS ACTIVE 2019-08-28 11:52:04 info : (1) [readwritesplit] (start_trx_replay): Starting transaction replay 4 2019-08-28 11:52:04 info : (1) [readwritesplit] (start_trx_replay): Replaying: begin 2019-08-28 11:52:05 info : [clustrixmon] (unpersist): Deleted Clustrix node 1 from bookkeeping. 2019-08-28 11:52:05 info : [clustrixmon] (unpersist): Deleted Clustrix node 2 from bookkeeping. 2019-08-28 11:52:05 info : [clustrixmon] (unpersist): Deleted Clustrix node 3 from bookkeeping. 2019-08-28 11:52:05 info : [clustrixmon] (unpersist): Deleted Clustrix node 4 from bookkeeping. 2019-08-28 11:52:05 notice : [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:05 info : (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:52:05 info : [readwritesplit] (route_single_stmt): Delaying routing: begin 2019-08-28 11:52:06 notice : [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:06 info : (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:52:06 info : [readwritesplit] (route_single_stmt): Delaying routing: begin 2019-08-28 11:52:07 notice : [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:07 info : (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:52:07 info : [readwritesplit] (route_single_stmt): Delaying routing: begin 2019-08-28 11:52:07 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.13.117.74:3306: Can't connect to MySQL server on '10.13.117.74' (115) 2019-08-28 11:52:07 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.13.117.74:3306: Can't connect to MySQL server on '10.13.117.74' (115) 2019-08-28 11:52:07 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.34.126.45:3306: Can't connect to MySQL server on '10.34.126.45' (115) 2019-08-28 11:52:07 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.37.59.101:3306: Can't connect to MySQL server on '10.37.59.101' (115) 2019-08-28 11:52:07 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.38.7.194:3306: Can't connect to MySQL server on '10.38.7.194' (115) 2019-08-28 11:52:07 notice : [clustrixmon] (refresh_using_persisted_nodes): Attempting to find a Clustrix bootstrap node from one of the nodes used during the previous run of MaxScale. 2019-08-28 11:52:07 error : [clustrixmon] (choose_hub): Clustrix-Monitor: Could not connect to any server or no server that could be connected to was part of the quorum. 2019-08-28 11:52:07 notice : (log_state_change): Server changed state: clustrix_server1[10.13.117.74:3306]: master_down. [Master, Running] -> [Down] 2019-08-28 11:52:07 notice : (log_state_change): Server changed state: clustrix_server2[10.34.126.45:3306]: master_down. [Master, Running] -> [Down] 2019-08-28 11:52:07 notice : (log_state_change): Server changed state: clustrix_server3[10.37.59.101:3306]: master_down. [Master, Running] -> [Down] 2019-08-28 11:52:07 notice : (log_state_change): Server changed state: clustrix_server4[10.38.7.194:3306]: master_down. [Master, Running] -> [Down] 2019-08-28 11:52:08 notice : [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:08 info : (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:52:08 info : [readwritesplit] (route_single_stmt): Delaying routing: begin 2019-08-28 11:52:09 notice : [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:09 info : (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:52:09 info : [readwritesplit] (route_single_stmt): Delaying routing: begin 2019-08-28 11:52:09 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.13.117.74:3306: Can't connect to MySQL server on '10.13.117.74' (115) 2019-08-28 11:52:09 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.34.126.45:3306: Can't connect to MySQL server on '10.34.126.45' (115) 2019-08-28 11:52:09 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.37.59.101:3306: Can't connect to MySQL server on '10.37.59.101' (115) 2019-08-28 11:52:09 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.38.7.194:3306: Can't connect to MySQL server on '10.38.7.194' (115) 2019-08-28 11:52:09 notice : [clustrixmon] (refresh_using_persisted_nodes): Attempting to find a Clustrix bootstrap node from one of the nodes used during the previous run of MaxScale. 2019-08-28 11:52:09 error : [clustrixmon] (choose_hub): Clustrix-Monitor: Could not connect to any server or no server that could be connected to was part of the quorum. 2019-08-28 11:52:10 notice : [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:10 info : (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:52:10 info : [readwritesplit] (route_single_stmt): Delaying routing: begin 2019-08-28 11:52:11 notice : [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:11 info : (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:52:11 info : [readwritesplit] (route_single_stmt): Delaying routing: begin 2019-08-28 11:52:11 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.13.117.74:3306: Can't connect to MySQL server on '10.13.117.74' (115) 2019-08-28 11:52:11 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.34.126.45:3306: Can't connect to MySQL server on '10.34.126.45' (115) 2019-08-28 11:52:11 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.37.59.101:3306: Can't connect to MySQL server on '10.37.59.101' (115) 2019-08-28 11:52:11 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.38.7.194:3306: Can't connect to MySQL server on '10.38.7.194' (115) 2019-08-28 11:52:11 notice : [clustrixmon] (refresh_using_persisted_nodes): Attempting to find a Clustrix bootstrap node from one of the nodes used during the previous run of MaxScale. 2019-08-28 11:52:11 error : [clustrixmon] (choose_hub): Clustrix-Monitor: Could not connect to any server or no server that could be connected to was part of the quorum. 2019-08-28 11:52:12 notice : [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:12 info : (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:52:12 info : [readwritesplit] (route_single_stmt): Delaying routing: begin 2019-08-28 11:52:13 notice : [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:13 info : (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:52:13 info : [readwritesplit] (route_single_stmt): Delaying routing: begin 2019-08-28 11:52:13 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.13.117.74:3306: Can't connect to MySQL server on '10.13.117.74' (115) 2019-08-28 11:52:13 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.34.126.45:3306: Can't connect to MySQL server on '10.34.126.45' (115) 2019-08-28 11:52:13 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.37.59.101:3306: Can't connect to MySQL server on '10.37.59.101' (115) 2019-08-28 11:52:13 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.38.7.194:3306: Can't connect to MySQL server on '10.38.7.194' (115) 2019-08-28 11:52:13 notice : [clustrixmon] (refresh_using_persisted_nodes): Attempting to find a Clustrix bootstrap node from one of the nodes used during the previous run of MaxScale. 2019-08-28 11:52:13 error : [clustrixmon] (choose_hub): Clustrix-Monitor: Could not connect to any server or no server that could be connected to was part of the quorum. 2019-08-28 11:52:14 notice : [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:14 info : (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:52:14 info : [readwritesplit] (route_single_stmt): Delaying routing: begin 2019-08-28 11:52:15 notice : [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:15 info : (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:52:15 info : [readwritesplit] (route_single_stmt): Delaying routing: begin 2019-08-28 11:52:16 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.13.117.74:3306: Can't connect to MySQL server on '10.13.117.74' (115) 2019-08-28 11:52:16 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.34.126.45:3306: Can't connect to MySQL server on '10.34.126.45' (115) 2019-08-28 11:52:16 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.37.59.101:3306: Can't connect to MySQL server on '10.37.59.101' (115) 2019-08-28 11:52:16 error : [clustrixmon] (ping_or_connect_to_hub): Clustrix-Monitor: Could either not ping or create connection to 10.38.7.194:3306: Can't connect to MySQL server on '10.38.7.194' (115) 2019-08-28 11:52:16 notice : [clustrixmon] (refresh_using_persisted_nodes): Attempting to find a Clustrix bootstrap node from one of the nodes used during the previous run of MaxScale. 2019-08-28 11:52:16 error : [clustrixmon] (choose_hub): Clustrix-Monitor: Could not connect to any server or no server that could be connected to was part of the quorum. 2019-08-28 11:52:16 notice : [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:16 info : (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:52:16 info : [readwritesplit] (route_single_stmt): Delaying routing: begin 2019-08-28 11:52:17 notice : [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:17 info : (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:52:17 info : [readwritesplit] (route_single_stmt): Delaying routing: begin 2019-08-28 11:52:18 notice : [clustrixmon] (choose_hub): Clustrix-Monitor: Monitoring Clustrix cluster state using node 10.13.117.74:3306. 2019-08-28 11:52:18 info : [clustrixmon] (persist): Updated Clustrix node in bookkeeping: 1, '10.13.117.74', 3306, 3581. 2019-08-28 11:52:18 info : [clustrixmon] (persist): Updated Clustrix node in bookkeeping: 2, '10.34.126.45', 3306, 3581. 2019-08-28 11:52:18 info : [clustrixmon] (persist): Updated Clustrix node in bookkeeping: 3, '10.37.59.101', 3306, 3581. 2019-08-28 11:52:18 info : [clustrixmon] (persist): Updated Clustrix node in bookkeeping: 4, '10.38.7.194', 3306, 3581. 2019-08-28 11:52:18 notice : [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:18 info : (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:52:18 info : [readwritesplit] (prepare_connection): Connected to '@@Clustrix-Monitor:node-1' 2019-08-28 11:52:18 info : [readwritesplit] (route_single_stmt): Queuing query until '@@Clustrix-Monitor:node-1' completes session command 2019-08-28 11:52:18 info : (1) (gw_decode_mysql_server_handshake): Connected to '@@Clustrix-Monitor:node-1' with thread id 2049 2019-08-28 11:52:18 notice : (1) [readwritesplit] (clientReply): RWSplitSession::clientReply() 2019-08-28 11:52:18 info : (1) [readwritesplit] (clientReply): Reply complete, last reply from @@Clustrix-Monitor:node-1 2019-08-28 11:52:18 info : (1) [readwritesplit] (clientReply): 1 session commands left on '@@Clustrix-Monitor:node-1' 2019-08-28 11:52:18 notice : (1) [readwritesplit] (clientReply): RWSplitSession::clientReply() 2019-08-28 11:52:18 info : (1) [readwritesplit] (clientReply): Reply complete, last reply from @@Clustrix-Monitor:node-1 2019-08-28 11:52:18 info : (1) [readwritesplit] (route_stored_query): >>> Routing stored queries 2019-08-28 11:52:18 notice : (1) [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:18 info : (1) (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 10, type: QUERY_TYPE_BEGIN_TRX, stmt: begin 2019-08-28 11:52:18 info : (1) [readwritesplit] (handle_got_target): Route query to master: @@Clustrix-Monitor:node-1 [10.13.117.74]:3306 < 2019-08-28 11:52:18 info : (1) [readwritesplit] (route_stored_query): <<< Stored queries routed 2019-08-28 11:52:18 notice : (1) [readwritesplit] (clientReply): RWSplitSession::clientReply() 2019-08-28 11:52:18 info : (1) [readwritesplit] (add_stmt): Adding to trx: begin 2019-08-28 11:52:18 info : (1) [readwritesplit] (clientReply): Reply complete, last reply from @@Clustrix-Monitor:node-1 2019-08-28 11:52:18 info : (1) [readwritesplit] (trx_replay_next_stmt): Replaying: insert into t2 values (9) 2019-08-28 11:52:18 notice : [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:18 info : (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_WRITE, stmt: insert into t2 values (9) 2019-08-28 11:52:18 info : [readwritesplit] (handle_got_target): Route query to master: @@Clustrix-Monitor:node-1 [10.13.117.74]:3306 < 2019-08-28 11:52:18 notice : (1) [readwritesplit] (clientReply): RWSplitSession::clientReply() 2019-08-28 11:52:18 info : (1) [readwritesplit] (add_stmt): Adding to trx: insert into t2 values (9) 2019-08-28 11:52:18 info : (1) [readwritesplit] (clientReply): Reply complete, last reply from @@Clustrix-Monitor:node-1 2019-08-28 11:52:18 info : (1) [readwritesplit] (trx_replay_next_stmt): Checksums match, replay successful. 2019-08-28 11:52:20 notice : (log_state_change): Server changed state: clustrix_server1[10.13.117.74:3306]: master_up. [Down] -> [Master, Running] 2019-08-28 11:52:20 notice : (log_state_change): Server changed state: clustrix_server2[10.34.126.45:3306]: master_up. [Down] -> [Master, Running] 2019-08-28 11:52:20 notice : (log_state_change): Server changed state: clustrix_server3[10.37.59.101:3306]: master_up. [Down] -> [Master, Running] 2019-08-28 11:52:20 notice : (log_state_change): Server changed state: clustrix_server4[10.38.7.194:3306]: master_up. [Down] -> [Master, Running] 2019-08-28 11:52:25 notice : (1) [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:25 info : (1) (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_WRITE, stmt: insert into t2 values (9) 2019-08-28 11:52:25 info : (1) [readwritesplit] (handle_got_target): Route query to master: @@Clustrix-Monitor:node-1 [10.13.117.74]:3306 < 2019-08-28 11:52:25 notice : (1) [readwritesplit] (clientReply): RWSplitSession::clientReply() 2019-08-28 11:52:25 info : (1) [readwritesplit] (add_stmt): Adding to trx: insert into t2 values (9) 2019-08-28 11:52:25 info : (1) [readwritesplit] (clientReply): Reply complete, last reply from @@Clustrix-Monitor:node-1 2019-08-28 11:52:28 notice : (1) [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:28 info : (1) (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 11, type: QUERY_TYPE_COMMIT, stmt: commit 2019-08-28 11:52:28 info : (1) [readwritesplit] (handle_got_target): Route query to master: @@Clustrix-Monitor:node-1 [10.13.117.74]:3306 < 2019-08-28 11:52:28 notice : (1) [readwritesplit] (clientReply): RWSplitSession::clientReply() 2019-08-28 11:52:28 info : (1) [readwritesplit] (add_stmt): Adding to trx: commit 2019-08-28 11:52:28 info : (1) [readwritesplit] (clientReply): Reply complete, last reply from @@Clustrix-Monitor:node-1 2019-08-28 11:52:28 info : (1) [readwritesplit] (clientReply): Transaction complete 2019-08-28 11:52:29 notice : (1) [readwritesplit] (routeQuery): RWSplitSession::routeQuery() 2019-08-28 11:52:29 info : (1) (log_transaction_status): > Autocommit: [disabled], trx is [open], cmd: (0x01) COM_QUIT, plen: 5, type: QUERY_TYPE_SESSION_WRITE, stmt: 2019-08-28 11:52:29 info : (1) [readwritesplit] (route_session_write): Session write, routing to all servers. 2019-08-28 11:52:29 info : (1) [readwritesplit] (route_session_write): Route query to master: @@Clustrix-Monitor:node-1 [10.13.117.74]:3306 2019-08-28 11:52:29 info : (session_free): Stopped RWS client session [1]