2021/01/21 11:49:52 start maxscale called info : MaxScale will be run in the terminal process. 2021-01-21 11:49:52 notice : syslog logging is enabled. 2021-01-21 11:49:52 notice : maxlog logging is enabled. 2021-01-21 11:49:52 notice : The collection of SQLite memory allocation statistics turned off. 2021-01-21 11:49:52 notice : Threading mode of SQLite set to Multi-thread. 2021-01-21 11:49:52 notice : Worker message queue size: 1MiB 2021-01-21 11:49:52 warning: users_refresh_time: Specifying durations without a suffix denoting the unit has been deprecated: 0. Use the suffixes 'h' (hour), 'm' (minute) 's' (second) or 'ms' (milliseconds). 2021-01-21 11:49:52 notice : Using up to 2.2GiB of memory for query classifier cache 2021-01-21 11:49:52 notice : Running OS: Linux@4.19.150+, #1 SMP Sat Oct 24 07:57:26 PDT 2020, x86_64 with 4 processor cores. 2021-01-21 11:49:52 notice : Total usable main memory: 14.68GiB. 2021-01-21 11:49:52 notice : MariaDB MaxScale 2.5.6 started (Commit: fddc0526ee79ac9a87f7a7170f3204263240ab57) Configuration file : /etc/maxscale-cfg/maxscale.cnf Log directory : /var/log/maxscale Data directory : /var/lib/maxscale Module directory : /usr/lib64/maxscale Service cache : /var/cache/maxscale 2021-01-21 11:49:52 notice : MaxScale is running in process 57 2021-01-21 11:49:52 notice : Configuration file: /etc/maxscale-cfg/maxscale.cnf 2021-01-21 11:49:52 notice : Log directory: /var/log/maxscale 2021-01-21 11:49:52 notice : Data directory: /var/lib/maxscale 2021-01-21 11:49:52 notice : Module directory: /usr/lib64/maxscale 2021-01-21 11:49:52 notice : Service cache: /var/cache/maxscale 2021-01-21 11:49:52 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2021-01-21 11:49:52 notice : Query classification results are cached and reused. Memory used per thread: 563.88MiB 2021-01-21 11:49:52 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2021-01-21 11:49:52 notice : MaxScale started with 4 worker threads, each with a stack size of 8388608 bytes. 2021-01-21 11:49:52 notice : Loading /etc/maxscale-cfg/maxscale.cnf. 2021-01-21 11:49:52 notice : /etc/maxscale-cfg/maxscale.cnf.d does not exist, not reading. 2021-01-21 11:49:52 notice : Loaded module mariadbclient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2021-01-21 11:49:52 notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so 2021-01-21 11:49:52 notice : Loaded module xpandmon: V1.0.0 from /usr/lib64/maxscale/libxpandmon.so 2021-01-21 11:49:52 notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so 2021-01-21 11:49:52 notice : [xpandmon] sqlite3 database /var/lib/maxscale/Xpand-Monitor/xpand_nodes-v1.db open/created and initialized. 2021-01-21 11:49:52 notice : (Read-Only-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so 2021-01-21 11:49:52 warning: The MaxScale GUI is enabled but encryption for the REST API is not enabled, the GUI will not be enabled. Configure `admin_ssl_key` and `admin_ssl_cert` to enable HTTPS or add `admin_secure_gui=false` to allow use of the GUI without encryption. 2021-01-21 11:49:52 notice : Started REST API on [0.0.0.0]:8989 2021-01-21 11:49:52 warning: [mariadbmon] Tried to find a master but no valid master server found. 2021-01-21 11:49:52 warning: [mariadbmon] Tried to find a master but no valid master server found. 2021-01-21 11:49:52 notice : [xpandmon] Xpand-Monitor: Monitoring Xpand cluster state using node j1-mxp-0.j1-mxp:3308. 2021-01-21 11:49:52 notice : Created server '@@Xpand-Monitor:node-1' at 10.32.3.99:3308 2021-01-21 11:49:52 notice : Created server '@@Xpand-Monitor:node-3' at 10.32.0.164:3308 2021-01-21 11:49:52 notice : Created server '@@Xpand-Monitor:node-2' at 10.32.0.132:3308 2021-01-21 11:49:52 warning: [xpandmon] Xpand-Monitor: Health check round had not completed when next tick arrived. 2021-01-21 11:49:54 notice : Starting a total of 2 services... 2021-01-21 11:49:54 notice : (Xpand-Read-Only-Listener) Listening for connections at [0.0.0.0]:4010 2021-01-21 11:49:54 warning: Service 'Xpand-Read-Only-Service' has a listener but no servers 2021-01-21 11:49:54 notice : Service 'Xpand-Read-Only-Service' started (1/2) 2021-01-21 11:49:54 notice : (Read-Only-Listener) Listening for connections at [0.0.0.0]:4008 2021-01-21 11:49:54 warning: Service 'Read-Only-Service' has a listener but no servers 2021-01-21 11:49:54 notice : Service 'Read-Only-Service' started (2/2) 2021-01-21 11:49:55 notice : Server '@@Xpand-Monitor:node-1' version: 5.0.45-Xpand-5.3.13 2021-01-21 11:49:55 warning: Service user 'skysql_maxscale' of service 'Xpand-Read-Only-Service' does not have 'SHOW DATABASES' or a similar global privilege on '@@Xpand-Monitor:node-1'. This may cause authentication errors on clients logging in to a specific database. 2021-01-21 11:49:55 notice : Read 58 user@host entries from '@@Xpand-Monitor:node-1' for service 'Xpand-Read-Only-Service'. 2021-01-21 11:49:55 warning: Authentication failed for 'skysql_admin', using password. Request: GET /v1/maxscale 2021-01-21 11:49:58 notice : Create network user 'skysql_admin' OK 2021-01-21 11:49:58 notice : Deleted network user 'admin' OK 2021-01-21 11:49:58 notice : Value of passive changed to false 2021-01-21 11:49:58 notice : Added '10.32.0.164' to 'Clustrix-Monitor' 2021-01-21 11:49:58 notice : Added '10.32.0.164' to 'Read-Only-Service' 2021-01-21 11:49:58 notice : Server '10.32.0.164' version: 10.5.8-5-MariaDB-enterprise-log 2021-01-21 11:49:58 notice : [mariadbmon] Selecting new master server. 2021-01-21 11:49:58 notice : [mariadbmon] Setting '10.32.0.164' as master. 2021-01-21 11:49:58 notice : Server changed state: 10.32.0.164[10.32.0.164:3306]: master_up. [Down] -> [Master, Slave of External Server, Running] 2021-01-21 11:49:58 notice : Added '10.32.3.99' to 'Clustrix-Monitor' 2021-01-21 11:49:58 notice : Added '10.32.3.99' to 'Read-Only-Service' 2021-01-21 11:49:58 notice : Server '10.32.3.99' version: 10.5.8-5-MariaDB-enterprise-log 2021-01-21 11:49:58 notice : Server '10.32.0.164' charset: utf8 2021-01-21 11:49:58 warning: [mariadbmon] Attempted to find a replacement for the current master server '10.32.0.164' because it has started replicating from another server in the cluster, but '10.32.0.164' is still the best master server. 2021-01-21 11:49:58 notice : Server changed state: 10.32.3.99[10.32.3.99:3306]: slave_up. [Down] -> [Relay Master, Slave, Slave of External Server, Running] 2021-01-21 11:49:58 notice : Added '10.32.0.132' to 'Clustrix-Monitor' 2021-01-21 11:49:58 notice : Added '10.32.0.132' to 'Read-Only-Service' 2021-01-21 11:49:58 notice : Server '10.32.3.99' charset: utf8 2021-01-21 11:49:58 notice : Server '10.32.0.132' version: 10.5.8-5-MariaDB-enterprise-log 2021-01-21 11:49:58 warning: [mariadbmon] Attempted to find a replacement for the current master server '10.32.0.164' because it has started replicating from another server in the cluster, but '10.32.0.164' is still the best master server. 2021-01-21 11:49:58 notice : Server changed state: 10.32.0.132[10.32.0.132:3306]: slave_up. [Down] -> [Relay Master, Slave, Running] 2021-01-21 11:49:59 warning: Using old user account query due to insufficient privileges. To avoid this warning, give the service user of 'Read-Only-Service' access to the 'mysql.procs_priv'-table. 2021-01-21 11:49:59 notice : Read 22 user@host entries from '10.32.0.164' for service 'Read-Only-Service'. 2021-01-21 11:53:35 warning: [xpandmon] Xpand-Monitor: Health check round had not completed when next tick arrived. 2021-01-21 11:53:36 error : Monitor timed out when connecting to server 10.32.0.132[10.32.0.132:3306] : '' 2021-01-21 11:53:36 notice : Server changed state: 10.32.0.132[10.32.0.132:3306]: slave_down. [Relay Master, Slave, Running] -> [Down] 2021-01-21 11:53:37 warning: [xpandmon] Xpand-Monitor: Health check round had not completed when next tick arrived. 2021-01-21 11:53:39 warning: [xpandmon] Xpand-Monitor: Health check round had not completed when next tick arrived. 2021-01-21 11:53:41 warning: [xpandmon] Xpand-Monitor: Health check round had not completed when next tick arrived. 2021-01-21 11:53:45 warning: [xpandmon] Xpand-Monitor: Health check round had not completed when next tick arrived. 2021-01-21 11:53:47 warning: [xpandmon] Xpand-Monitor: Health check round had not completed when next tick arrived. 2021-01-21 11:53:50 warning: [xpandmon] Xpand-Monitor: Health check round had not completed when next tick arrived. 2021-01-21 11:53:52 warning: [xpandmon] Xpand-Monitor: Health check round had not completed when next tick arrived. 2021-01-21 11:53:54 notice : Added '10.32.0.133' to 'Clustrix-Monitor' 2021-01-21 11:53:54 notice : Added '10.32.0.133' to 'Read-Only-Service' 2021-01-21 11:53:56 warning: [xpandmon] Xpand-Monitor: Health check round had not completed when next tick arrived. 2021-01-21 11:53:57 warning: [mariadbmon] The current master server '10.32.0.164' is no longer valid because it has started replicating from another server in the cluster, but there is no valid alternative to swap to. 2021-01-21 11:53:58 warning: [xpandmon] Xpand-Monitor: Health check round had not completed when next tick arrived. 2021-01-21 11:54:00 warning: [xpandmon] Xpand-Monitor: Health check round had not completed when next tick arrived. 2021-01-21 11:54:00 notice : Server '10.32.0.133' version: 10.5.8-5-MariaDB-enterprise-log 2021-01-21 11:54:02 warning: [xpandmon] Xpand-Monitor: Health check round had not completed when next tick arrived. 2021-01-21 11:54:03 warning: [mariadbmon] Attempted to find a replacement for the current master server '10.32.0.164' because it has started replicating from another server in the cluster, but '10.32.0.164' is still the best master server. 2021-01-21 11:54:03 warning: [mariadbmon] '10.32.0.132' is not a valid master candidate because it's down. 2021-01-21 11:54:03 notice : Server changed state: 10.32.0.133[10.32.0.133:3306]: slave_up. [Down] -> [Relay Master, Slave, Running] 2021-01-21 11:54:34 notice : Removed '10.32.0.132' from 'Clustrix-Monitor' 2021-01-21 11:54:34 notice : Removed '10.32.0.132' from 'Read-Only-Service' 2021-01-21 11:54:34 notice : Server '10.32.0.133' charset: utf8 2021-01-21 11:54:34 warning: [mariadbmon] Attempted to find a replacement for the current master server '10.32.0.164' because it has started replicating from another server in the cluster, but '10.32.0.164' is still the best master server. 2021-01-21 11:54:34 notice : Destroyed server '10.32.0.132' at 10.32.0.132:3306