MariaDB MaxScale  /data/clustrix/log/maxscale.log  Fri Aug 26 17:50:57 2022
-----------------------------------------------------------------------------
2022-08-26 17:50:57   notice : The systemd watchdog is Enabled. Internal timeout = 30s
2022-08-26 17:50:57   notice : Worker message queue size: 1MiB
2022-08-26 17:50:57   notice : The logging of info messages has been enabled.
2022-08-26 17:50:57   notice : Using up to 7.05GiB of memory for query classifier cache
2022-08-26 17:50:57   notice : syslog logging is enabled.
2022-08-26 17:50:57   notice : maxlog logging is enabled.
2022-08-26 17:50:57   notice : Host: 'karma195.colo.sproutsys.com' OS: Linux@3.10.0-1160.76.1.el7.x86_64, #1 SMP Wed Aug 10 16:21:17 UTC 2022, x86_64 with 16 processor cores.
2022-08-26 17:50:57   notice : Total usable main memory: 47GiB.
2022-08-26 17:50:57   notice : MariaDB MaxScale 6.2.4 started (Commit: 6e1317be296490366b7bf11b8e9b1864acc365d6)
2022-08-26 17:50:57   notice : MaxScale is running in process 9883
2022-08-26 17:50:57   notice : Configuration file: /etc/maxscale.cnf
2022-08-26 17:50:57   notice : Log directory: /data/clustrix/log
2022-08-26 17:50:57   notice : Data directory: /var/lib/maxscale
2022-08-26 17:50:57   notice : Module directory: /usr/lib64/maxscale
2022-08-26 17:50:57   notice : Service cache: /var/cache/maxscale
2022-08-26 17:50:57   notice : Working directory: /data/clustrix/log
2022-08-26 17:50:57   notice : Module 'qc_sqlite' loaded from '/usr/lib64/maxscale/libqc_sqlite.so'.
2022-08-26 17:50:57   info   : qc_sqlite loaded.
2022-08-26 17:50:57   notice : Query classification results are cached and reused. Memory used per thread: 451.2MiB
2022-08-26 17:50:57   notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext.
2022-08-26 17:50:57   info   : Epoll instance for listening sockets added to worker epoll instance.
2022-08-26 17:50:57   info   : Epoll instance for listening sockets added to worker epoll instance.
2022-08-26 17:50:57   info   : Epoll instance for listening sockets added to worker epoll instance.
2022-08-26 17:50:57   info   : Epoll instance for listening sockets added to worker epoll instance.
2022-08-26 17:50:57   info   : Epoll instance for listening sockets added to worker epoll instance.
2022-08-26 17:50:57   info   : Epoll instance for listening sockets added to worker epoll instance.
2022-08-26 17:50:57   info   : Epoll instance for listening sockets added to worker epoll instance.
2022-08-26 17:50:57   info   : Epoll instance for listening sockets added to worker epoll instance.
2022-08-26 17:50:57   info   : Epoll instance for listening sockets added to worker epoll instance.
2022-08-26 17:50:57   info   : Epoll instance for listening sockets added to worker epoll instance.
2022-08-26 17:50:57   info   : Epoll instance for listening sockets added to worker epoll instance.
2022-08-26 17:50:57   info   : Epoll instance for listening sockets added to worker epoll instance.
2022-08-26 17:50:57   info   : Epoll instance for listening sockets added to worker epoll instance.
2022-08-26 17:50:57   info   : Epoll instance for listening sockets added to worker epoll instance.
2022-08-26 17:50:57   info   : Epoll instance for listening sockets added to worker epoll instance.
2022-08-26 17:50:57   info   : Epoll instance for listening sockets added to worker epoll instance.
2022-08-26 17:50:57   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140405510145792.
2022-08-26 17:50:57   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140405433693952.
2022-08-26 17:50:57   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140405425301248.
2022-08-26 17:50:57   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140405416908544.
2022-08-26 17:50:57   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140405408515840.
2022-08-26 17:50:57   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140405400123136.
2022-08-26 17:50:57   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140405391730432.
2022-08-26 17:50:57   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140405383337728.
2022-08-26 17:50:57   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140404896823040.
2022-08-26 17:50:57   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140404888430336.
2022-08-26 17:50:57   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140404880037632.
2022-08-26 17:50:57   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140404871644928.
2022-08-26 17:50:57   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140404863252224.
2022-08-26 17:50:57   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140404854859520.
2022-08-26 17:50:57   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140404846466816.
2022-08-26 17:50:57   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140404359952128.
2022-08-26 17:50:57   notice : MaxScale started with 16 worker threads.
2022-08-26 17:50:57   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140405811298112.
2022-08-26 17:50:57   notice : Loading /etc/maxscale.cnf.
2022-08-26 17:50:57   notice : /etc/maxscale.cnf.d does not exist, not reading.
2022-08-26 17:50:57   notice : Module 'readconnroute' loaded from '/usr/lib64/maxscale/libreadconnroute.so'.
2022-08-26 17:50:57   notice : Module 'xpandmon' loaded from '/usr/lib64/maxscale/libxpandmon.so'.
2022-08-26 17:50:57   notice : [xpandmon] sqlite3 database /var/lib/maxscale/Backend-Monitor/xpand_nodes-v1.db open/created and initialized.
2022-08-26 17:50:57   notice : [xpandmon] Backend-Monitor: Monitoring Xpand cluster state using node karma194.colo.sproutsys.com:3306.
2022-08-26 17:50:57   notice : Created server '@@Backend-Monitor:node-1' at 10.2.13.94:3306
2022-08-26 17:50:57   info   : [xpandmon] Updated Xpand node in bookkeeping: 1, '10.2.13.94', 3306, 3581.
2022-08-26 17:50:57   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.
2022-08-26 17:50:57   notice : Started REST API on [127.0.0.1]:8989
2022-08-26 17:50:57   warning: [xpandmon] Backend-Monitor: Health check round had not completed when next tick arrived.
2022-08-26 17:50:57   notice : Starting a total of 1 services...
2022-08-26 17:50:57   notice : (Read-Only-Listener); Listening for connections at [0.0.0.0]:3306
2022-08-26 17:50:57   warning: Service 'Read-Only-Service' has a listener but no servers
2022-08-26 17:50:57   notice : Service 'Read-Only-Service' started (1/1)
2022-08-26 17:50:58   notice : '@@Backend-Monitor:node-1' sent version string '5.0.45-Xpand-6.0.5'. Detected type: 'Xpand', version: 5.0.45.
2022-08-26 17:50:58   notice : Read 8 user@host entries from '@@Backend-Monitor:node-1' for service 'Read-Only-Service'.
2022-08-26 17:51:05   info   : (1) Found matching user 't1'@'10.2.14.193' for client 't1'@'10.2.14.193' with sufficient privileges.
2022-08-26 17:51:05   info   : (1) [readconnroute] (Read-Only-Service); New session for server @@Backend-Monitor:node-1. Connections : 1
2022-08-26 17:51:05   info   : (1) Started Read-Only-Service client session [1] for 't1' from 10.2.14.193
2022-08-26 17:51:05   info   : (1) Connected to '@@Backend-Monitor:node-1' with thread id 52225
2022-08-26 17:51:05   info   : (1) [readconnroute] (Read-Only-Service); Routed [COM_QUERY] to '@@Backend-Monitor:node-1' select @@version_comment limit 1
2022-08-26 17:51:05   info   : (1) (@@Backend-Monitor:node-1); Storing COM_QUERY while in state 'Authenticating': select @@version_comment limit 1
2022-08-26 17:51:05   error  : (1) Authentication to '@@Backend-Monitor:node-1' failed: 1045, #HY000: [39936] Access denied: for user 't1'@'' (using password: YES)
2022-08-26 17:51:05   info   : (1) [readconnroute] (Read-Only-Service); Server '@@Backend-Monitor:node-1' failed
2022-08-26 17:51:05   info   : Stopped Read-Only-Service client session [1]
2022-08-26 17:51:05   info   : Read 8 user@host entries from '@@Backend-Monitor:node-1' for service 'Read-Only-Service'. The data was identical to existing user data.
2022-08-26 17:52:27   info   : (2) Found matching user 't1'@'10.2.14.193' for client 't1'@'10.2.14.193' with sufficient privileges.
2022-08-26 17:52:27   info   : (2) [readconnroute] (Read-Only-Service); New session for server @@Backend-Monitor:node-1. Connections : 1
2022-08-26 17:52:27   info   : (2) Started Read-Only-Service client session [2] for 't1' from 10.2.14.193
2022-08-26 17:52:27   info   : (2) [readconnroute] (Read-Only-Service); Routed [COM_QUERY] to '@@Backend-Monitor:node-1' show databases
2022-08-26 17:52:27   info   : (2) (@@Backend-Monitor:node-1); Storing COM_QUERY while in state 'Handshaking': show databases
2022-08-26 17:52:27   info   : (2) Connected to '@@Backend-Monitor:node-1' with thread id 54273
2022-08-26 17:52:27   error  : (2) Authentication to '@@Backend-Monitor:node-1' failed: 1045, #HY000: [39936] Access denied: for user 't1'@'' (using password: YES)
2022-08-26 17:52:27   info   : (2) [readconnroute] (Read-Only-Service); Server '@@Backend-Monitor:node-1' failed
2022-08-26 17:52:27   info   : Stopped Read-Only-Service client session [2]
2022-08-26 17:52:27   info   : Read 8 user@host entries from '@@Backend-Monitor:node-1' for service 'Read-Only-Service'. The data was identical to existing user data.