MariaDB MaxScale /data/clustrix/log/maxscale.log Wed May 1 20:01:40 2019 ----------------------------------------------------------------------------- 2019-05-01 20:01:40 notice : syslog logging is enabled. 2019-05-01 20:01:40 notice : maxlog logging is enabled. 2019-05-01 20:01:40 notice : The logging of informational messages has been enabled. 2019-05-01 20:01:40 notice : Using up to 7.05GiB of memory for query classifier cache 2019-05-01 20:01:40 notice : The collection of SQLite memory allocation statistics turned off. 2019-05-01 20:01:40 notice : Threading mode of SQLite set to Multi-thread. 2019-05-01 20:01:40 notice : MariaDB MaxScale 2.3.7 started (Commit: 820ff756a76bdd28301a0bd072eb959cba7c35bc) 2019-05-01 20:01:40 notice : MaxScale is running in process 3703 2019-05-01 20:01:40 notice : Configuration file: /etc/clustrix_karma016_ssl_encrpwd.cnf 2019-05-01 20:01:40 notice : Log directory: /data/clustrix/log 2019-05-01 20:01:40 notice : Data directory: /var/lib/maxscale 2019-05-01 20:01:40 notice : Module directory: /usr/lib64/maxscale 2019-05-01 20:01:40 notice : Service cache: /var/cache/maxscale 2019-05-01 20:01:40 notice : No query classifier specified, using default 'qc_sqlite'. 2019-05-01 20:01:40 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2019-05-01 20:01:40 info : qc_sqlite loaded. 2019-05-01 20:01:40 notice : Query classification results are cached and reused. Memory used per thread: 451.20MiB 2019-05-01 20:01:40 info : Epoll instance for listening sockets added to worker epoll instance. 2019-05-01 20:01:40 info : Epoll instance for listening sockets added to worker epoll instance. 2019-05-01 20:01:40 info : Epoll instance for listening sockets added to worker epoll instance. 2019-05-01 20:01:40 info : Epoll instance for listening sockets added to worker epoll instance. 2019-05-01 20:01:40 info : Epoll instance for listening sockets added to worker epoll instance. 2019-05-01 20:01:40 info : Epoll instance for listening sockets added to worker epoll instance. 2019-05-01 20:01:40 info : Epoll instance for listening sockets added to worker epoll instance. 2019-05-01 20:01:40 info : Epoll instance for listening sockets added to worker epoll instance. 2019-05-01 20:01:40 info : Epoll instance for listening sockets added to worker epoll instance. 2019-05-01 20:01:40 info : Epoll instance for listening sockets added to worker epoll instance. 2019-05-01 20:01:40 info : Epoll instance for listening sockets added to worker epoll instance. 2019-05-01 20:01:40 info : Epoll instance for listening sockets added to worker epoll instance. 2019-05-01 20:01:40 info : Epoll instance for listening sockets added to worker epoll instance. 2019-05-01 20:01:40 info : Epoll instance for listening sockets added to worker epoll instance. 2019-05-01 20:01:40 info : Epoll instance for listening sockets added to worker epoll instance. 2019-05-01 20:01:40 info : Epoll instance for listening sockets added to worker epoll instance. 2019-05-01 20:01:40 notice : Loading /etc/clustrix_karma016_ssl_encrpwd.cnf. 2019-05-01 20:01:40 notice : /etc/clustrix_karma016_ssl_encrpwd.cnf.d does not exist, not reading. 2019-05-01 20:01:40 info : [maxscaled] Initialise MaxScaled Protocol module. 2019-05-01 20:01:40 notice : Loaded module maxscaled: V2.0.0 from /usr/lib64/maxscale/libmaxscaled.so 2019-05-01 20:01:40 warning: [cli] THE 'cli' MODULE AND 'maxadmin' ARE DEPRECATED: Use 'maxctrl' instead 2019-05-01 20:01:40 notice : Loaded module cli: V1.0.0 from /usr/lib64/maxscale/libcli.so 2019-05-01 20:01:40 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2019-05-01 20:01:40 notice : [readconnroute] Initialise readconnroute router module. 2019-05-01 20:01:40 notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so 2019-05-01 20:01:40 notice : [clustrixmon] Initialise the MariaDB Clustrix Monitor module. 2019-05-01 20:01:40 notice : Loaded module clustrixmon: V1.0.0 from /usr/lib64/maxscale/libclustrixmon.so 2019-05-01 20:01:40 notice : Loaded module mariadbbackend: V2.0.0 from /usr/lib64/maxscale/libmariadbbackend.so 2019-05-01 20:01:40 notice : Loaded module MySQLBackendAuth: V1.0.0 from /usr/lib64/maxscale/libmysqlbackendauth.so 2019-05-01 20:01:40 notice : [clustrixmon] sqlite3 database /var/lib/maxscale/Clustrix/clustrix_nodes-1.db open/created and initialized. 2019-05-01 20:01:40 notice : Loaded module MySQLAuth: V1.1.0 from /usr/lib64/maxscale/libmysqlauth.so 2019-05-01 20:01:40 notice : Loaded module MaxAdminAuth: V2.1.0 from /usr/lib64/maxscale/libmaxadminauth.so 2019-05-01 20:01:40 notice : Loaded server states from journal file: /var/lib/maxscale/Clustrix/monitor.dat 2019-05-01 20:01:40 notice : Using encrypted passwords. Encryption key: '/var/lib/maxscale/.secrets'. 2019-05-01 20:01:40 error : [clustrixmon] Clustrix: Could either not ping or create connection to 10.2.13.97:3306: Can't connect to MySQL server on '10.2.13.97' (115) 2019-05-01 20:01:40 notice : [clustrixmon] Attempting to find a Clustrix bootstrap node from one of the nodes used during the previous run of MaxScale. 2019-05-01 20:01:40 notice : [clustrixmon] Trying to find out cluster nodes from 10.2.15.19:3306. 2019-05-01 20:01:40 notice : Created server '@@Clustrix:node-5' at 10.2.15.19:3306 2019-05-01 20:01:40 info : [clustrixmon] Updated Clustrix node in bookkeeping: 5, '10.2.15.19', 3306, 3581. 2019-05-01 20:01:40 notice : Created server '@@Clustrix:node-4' at 10.2.15.144:3306 2019-05-01 20:01:40 info : [clustrixmon] Updated Clustrix node in bookkeeping: 4, '10.2.15.144', 3306, 3581. 2019-05-01 20:01:40 notice : Created server '@@Clustrix:node-3' at 10.2.15.126:3306 2019-05-01 20:01:40 info : [clustrixmon] Updated Clustrix node in bookkeeping: 3, '10.2.15.126', 3306, 3581. 2019-05-01 20:01:40 notice : [clustrixmon] Cluster nodes refreshed. 2019-05-01 20:01:40 notice : [clustrixmon] Clustrix: Monitoring Clustrix cluster state using node 10.2.15.126:3306. 2019-05-01 20:01:40 info : In-memory sqlite database successfully opened for thread 140382505428736. 2019-05-01 20:01:40 info : In-memory sqlite database successfully opened for thread 140382497036032. 2019-05-01 20:01:40 info : In-memory sqlite database successfully opened for thread 140382281135872. 2019-05-01 20:01:40 notice : Server changed state: Bootstrap1-karma197[10.2.13.97:3306]: server_down. [Running] -> [Down] 2019-05-01 20:01:40 info : In-memory sqlite database successfully opened for thread 140382272743168. 2019-05-01 20:01:40 info : In-memory sqlite database successfully opened for thread 140382264350464. 2019-05-01 20:01:40 info : In-memory sqlite database successfully opened for thread 140382255957760. 2019-05-01 20:01:40 info : In-memory sqlite database successfully opened for thread 140382247565056. 2019-05-01 20:01:40 info : In-memory sqlite database successfully opened for thread 140382239172352. 2019-05-01 20:01:40 info : In-memory sqlite database successfully opened for thread 140382230779648. 2019-05-01 20:01:40 info : In-memory sqlite database successfully opened for thread 140381744264960. 2019-05-01 20:01:40 info : In-memory sqlite database successfully opened for thread 140381735872256. 2019-05-01 20:01:40 info : In-memory sqlite database successfully opened for thread 140381727479552. 2019-05-01 20:01:40 info : In-memory sqlite database successfully opened for thread 140381719086848. 2019-05-01 20:01:40 info : In-memory sqlite database successfully opened for thread 140381710694144. 2019-05-01 20:01:40 info : In-memory sqlite database successfully opened for thread 140381702301440. 2019-05-01 20:01:40 info : In-memory sqlite database successfully opened for thread 140381693908736. 2019-05-01 20:01:40 notice : Started REST API on [127.0.0.1]:8989 2019-05-01 20:01:40 notice : MaxScale started with 16 worker threads, each with a stack size of 8388608 bytes. 2019-05-01 20:01:40 notice : Starting a total of 2 services... 2019-05-01 20:01:40 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('mysql_slave', '', NULL, 0, NULL) 2019-05-01 20:01:40 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clustrix_ui', '127.0.0.1', NULL, 0, '46A23F3EF4B5568CD0D6951239A0345A78DDF61A') 2019-05-01 20:01:40 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_support', '127.0.0.1', NULL, 0, NULL) 2019-05-01 20:01:40 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_maint', '127.0.0.1', NULL, 0, '845EE408D4B27C5C5A9751D7786FDA7E89B2C02E') 2019-05-01 20:01:40 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clx_view_definer', '127.0.0.1', NULL, 0, NULL) 2019-05-01 20:01:40 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clxd', 'localhost', '*', 0, NULL) 2019-05-01 20:01:40 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clxd', 'localhost', 'clustrix_dbi', 1, NULL) 2019-05-01 20:01:40 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clxd', 'localhost', 'clustrix_statd', 1, NULL) 2019-05-01 20:01:40 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clxd', 'localhost', 'information_schema', 1, NULL) 2019-05-01 20:01:40 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clxd', 'localhost', 'system', 1, NULL) 2019-05-01 20:01:40 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clxm', 'localhost', '*', 0, NULL) 2019-05-01 20:01:40 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('clxm', 'localhost', 'system', 1, NULL) 2019-05-01 20:01:40 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', '*', 0, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-05-01 20:01:40 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-05-01 20:01:40 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-05-01 20:01:40 info : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', 'system', 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-05-01 20:01:40 notice : [MySQLAuth] [RCR] Loaded 16 MySQL users for listener RCR-Listener. 2019-05-01 20:01:40 notice : Listening for connections at [::]:6008 2019-05-01 20:01:40 notice : Service 'RCR' started (1/2) 2019-05-01 20:01:40 notice : Listening for connections at [/var/run/maxscale/maxadmin.sock]:0 2019-05-01 20:01:40 notice : Service 'MaxAdmin-Service' started (2/2) 2019-05-01 20:01:47 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-05-01 20:01:47 info : Accept authentication from 'admin', using password. Request: /v1/monitors/Clustrix