MariaDB MaxScale /data/clustrix/log/maxscale.log Thu Aug 8 00:08:03 2019 ----------------------------------------------------------------------------- 2019-08-08 00:08:03 notice : syslog logging is enabled. 2019-08-08 00:08:03 notice : maxlog logging is enabled. 2019-08-08 00:08:03 notice : The logging of informational messages has been enabled. 2019-08-08 00:08:03 notice : Using up to 7.05GiB of memory for query classifier cache 2019-08-08 00:08:03 notice : The collection of SQLite memory allocation statistics turned off. 2019-08-08 00:08:03 notice : Threading mode of SQLite set to Multi-thread. 2019-08-08 00:08:03 notice : MariaDB MaxScale 2.4.1 started (Commit: 658aae6b6c77774c34d0f52c03f63edc2d44969e) 2019-08-08 00:08:03 notice : MaxScale is running in process 5037 2019-08-08 00:08:03 notice : Configuration file: /etc/clustrix_karma108_trxreplay.cnf 2019-08-08 00:08:03 notice : Log directory: /data/clustrix/log 2019-08-08 00:08:03 notice : Data directory: /var/lib/maxscale 2019-08-08 00:08:03 notice : Module directory: /usr/lib64/maxscale 2019-08-08 00:08:03 notice : Service cache: /var/cache/maxscale 2019-08-08 00:08:03 notice : No query classifier specified, using default 'qc_sqlite'. 2019-08-08 00:08:03 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2019-08-08 00:08:03 info : qc_sqlite loaded. 2019-08-08 00:08:03 notice : Query classification results are cached and reused. Memory used per thread: 451.20MiB 2019-08-08 00:08:03 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-08 00:08:03 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-08 00:08:03 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-08 00:08:03 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-08 00:08:03 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-08 00:08:03 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-08 00:08:03 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-08 00:08:03 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-08 00:08:03 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-08 00:08:03 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-08 00:08:03 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-08 00:08:03 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-08 00:08:03 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-08 00:08:03 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-08 00:08:03 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-08 00:08:03 info : Epoll instance for listening sockets added to worker epoll instance. 2019-08-08 00:08:03 notice : Loading /etc/clustrix_karma108_trxreplay.cnf. 2019-08-08 00:08:03 notice : /etc/clustrix_karma108_trxreplay.cnf.d does not exist, not reading. 2019-08-08 00:08:03 info : [maxscaled] Initialise MaxScaled Protocol module. 2019-08-08 00:08:03 notice : Loaded module maxscaled: V2.0.0 from /usr/lib64/maxscale/libmaxscaled.so 2019-08-08 00:08:03 warning: [cli] THE 'cli' MODULE AND 'maxadmin' ARE DEPRECATED: Use 'maxctrl' instead 2019-08-08 00:08:03 notice : Loaded module cli: V1.0.0 from /usr/lib64/maxscale/libcli.so 2019-08-08 00:08:03 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2019-08-08 00:08:03 notice : [readwritesplit] Initializing statement-based read/write split router module. 2019-08-08 00:08:03 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so 2019-08-08 00:08:03 notice : [clustrixmon] Initialise the MariaDB Clustrix Monitor module. 2019-08-08 00:08:03 notice : Loaded module clustrixmon: V1.0.0 from /usr/lib64/maxscale/libclustrixmon.so 2019-08-08 00:08:03 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-08 00:08:03 notice : Loaded module mariadbbackend: V2.0.0 from /usr/lib64/maxscale/libmariadbbackend.so 2019-08-08 00:08:03 notice : Loaded module mariadbbackendauth: V1.0.0 from /usr/lib64/maxscale/libmariadbbackendauth.so 2019-08-08 00:08:03 notice : [clustrixmon] sqlite3 database /var/lib/maxscale/Clustrix/clustrix_nodes-v1.db open/created and initialized. 2019-08-08 00:08:03 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-08 00:08:03 notice : Loaded module mariadbauth: V1.1.0 from /usr/lib64/maxscale/libmariadbauth.so 2019-08-08 00:08:03 notice : Loaded module MaxAdminAuth: V2.1.0 from /usr/lib64/maxscale/libmaxadminauth.so 2019-08-08 00:08:03 info : In-memory sqlite database successfully opened for thread 139967656834816. 2019-08-08 00:08:03 info : In-memory sqlite database successfully opened for thread 139967648442112. 2019-08-08 00:08:03 info : In-memory sqlite database successfully opened for thread 139967640049408. 2019-08-08 00:08:03 info : In-memory sqlite database successfully opened for thread 139967631656704. 2019-08-08 00:08:03 info : In-memory sqlite database successfully opened for thread 139967414138624. 2019-08-08 00:08:03 info : In-memory sqlite database successfully opened for thread 139967405745920. 2019-08-08 00:08:03 info : In-memory sqlite database successfully opened for thread 139967397353216. 2019-08-08 00:08:03 info : In-memory sqlite database successfully opened for thread 139967388960512. 2019-08-08 00:08:03 info : In-memory sqlite database successfully opened for thread 139967380567808. 2019-08-08 00:08:03 info : In-memory sqlite database successfully opened for thread 139967372175104. 2019-08-08 00:08:03 info : In-memory sqlite database successfully opened for thread 139967363782400. 2019-08-08 00:08:03 info : In-memory sqlite database successfully opened for thread 139966810158848. 2019-08-08 00:08:03 info : In-memory sqlite database successfully opened for thread 139966801766144. 2019-08-08 00:08:03 info : In-memory sqlite database successfully opened for thread 139966793373440. 2019-08-08 00:08:03 info : In-memory sqlite database successfully opened for thread 139966784980736. 2019-08-08 00:08:03 info : In-memory sqlite database successfully opened for thread 139966776588032. 2019-08-08 00:08:03 notice : Started REST API on [127.0.0.1]:8989 2019-08-08 00:08:03 notice : MaxScale started with 16 worker threads, each with a stack size of 8388608 bytes. 2019-08-08 00:08:03 notice : Starting a total of 2 services... 2019-08-08 00:08:03 notice : Encrypted password file /var/lib/maxscale/.secrets can't be accessed (No such file or directory). Password encryption is not used. 2019-08-08 00:08:03 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', '%', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-08 00:08:03 info : [MariaDBAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale', 'localhost', NULL, 1, '697AF2143D0F44D572158FD26F4461783A2FEC65') 2019-08-08 00:08:03 notice : Listening for connections at [::]:6008 2019-08-08 00:08:03 notice : Service 'RCR' started (1/2) 2019-08-08 00:08:03 notice : Listening for connections at [/var/run/maxscale/maxadmin.sock]:0 2019-08-08 00:08:03 notice : Service 'MaxAdmin-Service' started (2/2) 2019-08-08 00:08:03 notice : Loaded server states from journal file: /var/lib/maxscale/Clustrix/monitor.dat 2019-08-08 00:08:03 notice : [clustrixmon] Clustrix: Monitoring Clustrix cluster state using node 10.2.13.91:3306. 2019-08-08 00:08:03 warning: Authenticator module 'mysqlbackendauth' has been deprecated, use 'mariadbbackendauth' instead. 2019-08-08 00:08:03 notice : Created server '@@Clustrix:node-1' at 10.2.13.91:3306 2019-08-08 00:08:03 info : [clustrixmon] Updated Clustrix node in bookkeeping: 1, '10.2.13.91', 3306, 3581. 2019-08-08 00:08:03 notice : Created server '@@Clustrix:node-3' at 10.2.15.89:3306 2019-08-08 00:08:03 info : [clustrixmon] Updated Clustrix node in bookkeeping: 3, '10.2.15.89', 3306, 3581. 2019-08-08 00:08:03 notice : Created server '@@Clustrix:node-2' at 10.2.15.180:3306 2019-08-08 00:08:03 info : [clustrixmon] Updated Clustrix node in bookkeeping: 2, '10.2.15.180', 3306, 3581. 2019-08-08 00:08:03 notice : Created server '@@Clustrix:node-4' at 10.2.14.119:3306 2019-08-08 00:08:03 info : [clustrixmon] Updated Clustrix node in bookkeeping: 4, '10.2.14.119', 3306, 3581. 2019-08-08 00:09:04 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-08-08 00:09:04 info : Accept authentication from 'admin', using password. Request: /v1/monitors/Clustrix 2019-08-08 00:10:47 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-08-08 00:10:47 info : Accept authentication from 'admin', using password. Request: /v1/monitors/Clustrix 2019-08-08 00:10:56 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-08-08 00:10:56 info : Accept authentication from 'admin', using password. Request: /v1/monitors/Clustrix 2019-08-08 00:11:43 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-08-08 00:11:43 info : Accept authentication from 'admin', using password. Request: /v1/monitors/Clustrix 2019-08-08 00:11:43 notice : [clustrixmon] Clustrix: Node 4 (10.2.14.119) has been SOFTFAILed. Turning ON 'Being Drained'. 2019-08-08 00:11:50 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-08-08 00:11:50 info : Accept authentication from 'admin', using password. Request: /v1/monitors/Clustrix 2019-08-08 00:12:07 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-08-08 00:12:07 info : Accept authentication from 'admin', using password. Request: /v1/monitors/Clustrix 2019-08-08 00:12:19 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-08-08 00:12:19 info : Accept authentication from 'admin', using password. Request: /v1/monitors/Clustrix 2019-08-08 00:13:12 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-08-08 00:13:12 info : Accept authentication from 'admin', using password. Request: /v1/monitors/Clustrix 2019-08-08 00:14:21 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-08-08 00:14:21 info : Accept authentication from 'admin', using password. Request: /v1/monitors/Clustrix