MariaDB MaxScale /data/clustrix/log/maxscale.log Mon Aug 29 23:21:28 2022 ----------------------------------------------------------------------------- 2022-08-29 23:21:28 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2022-08-29 23:21:28 notice : The logging of info messages has been enabled. 2022-08-29 23:21:28 notice : Using up to 7.05GiB of memory for query classifier cache 2022-08-29 23:21:28 notice : syslog logging is disabled. 2022-08-29 23:21:28 notice : maxlog logging is enabled. 2022-08-29 23:21:28 notice : Host: 'karma075.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 (16 available). 2022-08-29 23:21:28 notice : Total usable main memory: 47GiB (47GiB available). 2022-08-29 23:21:28 notice : MariaDB MaxScale 22.08.1 started (Commit: 3911cd7d3e79c2652857d63cafe9687a0578be67) 2022-08-29 23:21:28 notice : MaxScale is running in process 529 2022-08-29 23:21:28 notice : Configuration file: /etc/maxscale.cnf 2022-08-29 23:21:28 notice : Log directory: /data/clustrix/log 2022-08-29 23:21:28 notice : Data directory: /var/lib/maxscale 2022-08-29 23:21:28 notice : Module directory: /usr/lib64/maxscale 2022-08-29 23:21:28 notice : Service cache: /var/cache/maxscale 2022-08-29 23:21:28 notice : Working directory: /data/clustrix/log 2022-08-29 23:21:28 notice : Module 'qc_sqlite' loaded from '/usr/lib64/maxscale/libqc_sqlite.so'. 2022-08-29 23:21:28 info : qc_sqlite loaded. 2022-08-29 23:21:28 notice : Query classification results are cached and reused. Memory used per thread: 451.2MiB 2022-08-29 23:21:28 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2022-08-29 23:21:28 info : Epoll instance for listening sockets added to worker epoll instance. 2022-08-29 23:21:28 info : Epoll instance for listening sockets added to worker epoll instance. 2022-08-29 23:21:28 info : Epoll instance for listening sockets added to worker epoll instance. 2022-08-29 23:21:28 info : Epoll instance for listening sockets added to worker epoll instance. 2022-08-29 23:21:28 info : Epoll instance for listening sockets added to worker epoll instance. 2022-08-29 23:21:28 info : Epoll instance for listening sockets added to worker epoll instance. 2022-08-29 23:21:28 info : Epoll instance for listening sockets added to worker epoll instance. 2022-08-29 23:21:28 info : Epoll instance for listening sockets added to worker epoll instance. 2022-08-29 23:21:28 info : Epoll instance for listening sockets added to worker epoll instance. 2022-08-29 23:21:28 info : Epoll instance for listening sockets added to worker epoll instance. 2022-08-29 23:21:28 info : Epoll instance for listening sockets added to worker epoll instance. 2022-08-29 23:21:28 info : Epoll instance for listening sockets added to worker epoll instance. 2022-08-29 23:21:28 info : Epoll instance for listening sockets added to worker epoll instance. 2022-08-29 23:21:28 info : Epoll instance for listening sockets added to worker epoll instance. 2022-08-29 23:21:28 info : Epoll instance for listening sockets added to worker epoll instance. 2022-08-29 23:21:28 info : Epoll instance for listening sockets added to worker epoll instance. 2022-08-29 23:21:28 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140112642332416. 2022-08-29 23:21:28 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140112633939712. 2022-08-29 23:21:28 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140112625547008. 2022-08-29 23:21:28 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140112617154304. 2022-08-29 23:21:28 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140112608761600. 2022-08-29 23:21:28 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140112600368896. 2022-08-29 23:21:28 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140112591976192. 2022-08-29 23:21:28 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140112583583488. 2022-08-29 23:21:28 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140112100849408. 2022-08-29 23:21:28 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140112092456704. 2022-08-29 23:21:28 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140112084064000. 2022-08-29 23:21:28 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140112075671296. 2022-08-29 23:21:28 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140112067278592. 2022-08-29 23:21:28 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140112058885888. 2022-08-29 23:21:28 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140112050493184. 2022-08-29 23:21:28 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140111496869632. 2022-08-29 23:21:28 notice : MaxScale started with 16 worker threads. 2022-08-29 23:21:28 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140112948251776. 2022-08-29 23:21:28 info : No 'auto_tune' parameters specified, no auto tuning will be performed. 2022-08-29 23:21:28 notice : Module 'xpandmon' loaded from '/usr/lib64/maxscale/libxpandmon.so'. 2022-08-29 23:21:28 notice : Module 'readconnroute' loaded from '/usr/lib64/maxscale/libreadconnroute.so'. 2022-08-29 23:21:28 notice : [xpandmon] sqlite3 database /var/lib/maxscale/Backend-Monitor/xpand_nodes-v1.db open/created and initialized. 2022-08-29 23:21:28 notice : [xpandmon] Backend-Monitor: Monitoring Xpand cluster state using node karma060.colo.sproutsys.com:3306. 2022-08-29 23:21:28 notice : Created server '@@Backend-Monitor:node-1' at 10.2.15.149:3306 2022-08-29 23:21:28 info : [xpandmon] Updated Xpand node in bookkeeping: 1, '10.2.15.149', 3306, 3581. 2022-08-29 23:21:28 notice : Using HS256 for JWT signatures 2022-08-29 23:21:28 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-29 23:21:28 notice : Started REST API on [127.0.0.1]:8989 2022-08-29 23:21:28 warning: [xpandmon] Backend-Monitor: Health check round had not completed when next tick arrived. 2022-08-29 23:21:28 notice : Starting a total of 1 services... 2022-08-29 23:21:28 notice : (Read-Only-Listener); Listening for connections at [0.0.0.0]:3306 2022-08-29 23:21:28 warning: Service 'Read-Only-Service' has a listener but no servers 2022-08-29 23:21:28 notice : Service 'Read-Only-Service' started (1/1) 2022-08-29 23:21:29 error : Failed to query server '@@Backend-Monitor:node-1' for user account info. Connection to [10.2.15.149]:3306 failed. Error 1045: [38912] Access denied: for user 'maxscale'@'karma075.colo.sproutsys.com' (using password: YES) 2022-08-29 23:21:30 error : Failed to query server '@@Backend-Monitor:node-1' for user account info. Connection to [10.2.15.149]:3306 failed. Error 1045: [38912] Access denied: for user 'maxscale'@'karma075.colo.sproutsys.com' (using password: YES) 2022-08-29 23:21:31 error : Failed to query server '@@Backend-Monitor:node-1' for user account info. Connection to [10.2.15.149]:3306 failed. Error 1045: [38912] Access denied: for user 'maxscale'@'karma075.colo.sproutsys.com' (using password: YES) 2022-08-29 23:21:32 error : Failed to query server '@@Backend-Monitor:node-1' for user account info. Connection to [10.2.15.149]:3306 failed. Error 1045: [38912] Access denied: for user 'maxscale'@'karma075.colo.sproutsys.com' (using password: YES) 2022-08-29 23:21:33 error : Failed to query server '@@Backend-Monitor:node-1' for user account info. Connection to [10.2.15.149]:3306 failed. Error 1045: [38912] Access denied: for user 'maxscale'@'karma075.colo.sproutsys.com' (using password: YES) 2022-08-29 23:21:34 error : Failed to query server '@@Backend-Monitor:node-1' for user account info. Connection to [10.2.15.149]:3306 failed. Error 1045: [38912] Access denied: for user 'maxscale'@'karma075.colo.sproutsys.com' (using password: YES) 2022-08-29 23:21:35 error : Failed to query server '@@Backend-Monitor:node-1' for user account info. Connection to [10.2.15.149]:3306 failed. Error 1045: [38912] Access denied: for user 'maxscale'@'karma075.colo.sproutsys.com' (using password: YES) 2022-08-29 23:21:36 error : Failed to query server '@@Backend-Monitor:node-1' for user account info. Connection to [10.2.15.149]:3306 failed. Error 1045: [38912] Access denied: for user 'maxscale'@'karma075.colo.sproutsys.com' (using password: YES) 2022-08-29 23:21:37 error : Failed to query server '@@Backend-Monitor:node-1' for user account info. Connection to [10.2.15.149]:3306 failed. Error 1045: [38912] Access denied: for user 'maxscale'@'karma075.colo.sproutsys.com' (using password: YES) 2022-08-29 23:21:38 error : Failed to query server '@@Backend-Monitor:node-1' for user account info. Connection to [10.2.15.149]:3306 failed. Error 1045: [38912] Access denied: for user 'maxscale'@'karma075.colo.sproutsys.com' (using password: YES) 2022-08-29 23:21:45 info : Waiting for worker 0x7a5530. 2022-08-29 23:21:45 info : Worker 0x7a5530 received shutdown message. 2022-08-29 23:21:45 info : Worker 0x7a5530 has shut down. 2022-08-29 23:21:45 info : Waited for worker 0x7a5530. 2022-08-29 23:21:45 info : Worker 0x6ab330 received shutdown message. 2022-08-29 23:21:45 info : Worker 0x6ab330 has shut down. 2022-08-29 23:21:45 info : Worker 0x6abf40 received shutdown message. 2022-08-29 23:21:45 info : Worker 0x6b15b0 received shutdown message. 2022-08-29 23:21:45 info : Worker 0x6ae3a0 received shutdown message. 2022-08-29 23:21:45 info : Worker 0x6b44e0 received shutdown message. 2022-08-29 23:21:45 info : Worker 0x6aefb0 received shutdown message. 2022-08-29 23:21:45 info : Worker 0x6abf40 has shut down. 2022-08-29 23:21:45 info : Worker 0x6b15b0 has shut down. 2022-08-29 23:21:45 info : Worker 0x6b20c0 received shutdown message. 2022-08-29 23:21:45 info : Worker 0x6ae3a0 has shut down. 2022-08-29 23:21:45 info : Worker 0x6b2cc0 received shutdown message. 2022-08-29 23:21:45 info : Worker 0x6b07d0 received shutdown message. 2022-08-29 23:21:45 info : Worker 0x6b5d00 received shutdown message. 2022-08-29 23:21:45 info : Worker 0x6b50f0 received shutdown message. 2022-08-29 23:21:45 info : Worker 0x6b2cc0 has shut down. 2022-08-29 23:21:45 info : Worker 0x6aa9a0 received shutdown message. 2022-08-29 23:21:45 info : Worker 0x6b07d0 has shut down. 2022-08-29 23:21:45 info : Worker 0x6b5d00 has shut down. 2022-08-29 23:21:45 info : Worker 0x6b44e0 has shut down. 2022-08-29 23:21:45 info : Worker 0x6afbc0 received shutdown message. 2022-08-29 23:21:45 info : Worker 0x6acb50 received shutdown message. 2022-08-29 23:21:45 info : Worker 0x6aefb0 has shut down. 2022-08-29 23:21:45 info : Worker 0x6b20c0 has shut down. 2022-08-29 23:21:45 info : Worker 0x6ad7c0 received shutdown message. 2022-08-29 23:21:45 info : Worker 0x6b38d0 received shutdown message. 2022-08-29 23:21:45 info : Worker 0x6b50f0 has shut down. 2022-08-29 23:21:45 info : Worker 0x6aa9a0 has shut down. 2022-08-29 23:21:45 info : Worker 0x6afbc0 has shut down. 2022-08-29 23:21:45 info : Worker 0x6acb50 has shut down. 2022-08-29 23:21:45 info : Worker 0x6ad7c0 has shut down. 2022-08-29 23:21:45 info : Worker 0x6b38d0 has shut down. 2022-08-29 23:21:45 info : Worker 0x7fff44757020 received shutdown message. 2022-08-29 23:21:45 info : Worker 0x7fff44757020 has shut down. 2022-08-29 23:21:45 notice : MaxScale is shutting down. 2022-08-29 23:21:45 notice : Stopped MaxScale REST API 2022-08-29 23:21:45 info : Waiting for worker 0x6aa9a0. 2022-08-29 23:21:45 info : Waited for worker 0x6aa9a0. 2022-08-29 23:21:45 info : Waiting for worker 0x6ab330. 2022-08-29 23:21:45 info : Waited for worker 0x6ab330. 2022-08-29 23:21:45 info : Waiting for worker 0x6abf40. 2022-08-29 23:21:45 info : Waited for worker 0x6abf40. 2022-08-29 23:21:45 info : Waiting for worker 0x6acb50. 2022-08-29 23:21:45 info : Waited for worker 0x6acb50. 2022-08-29 23:21:45 info : Waiting for worker 0x6ad7c0. 2022-08-29 23:21:45 info : Waited for worker 0x6ad7c0. 2022-08-29 23:21:45 info : Waiting for worker 0x6ae3a0. 2022-08-29 23:21:45 info : Waited for worker 0x6ae3a0. 2022-08-29 23:21:45 info : Waiting for worker 0x6aefb0. 2022-08-29 23:21:45 info : Waited for worker 0x6aefb0. 2022-08-29 23:21:45 info : Waiting for worker 0x6afbc0. 2022-08-29 23:21:45 info : Waited for worker 0x6afbc0. 2022-08-29 23:21:45 info : Waiting for worker 0x6b07d0. 2022-08-29 23:21:45 info : Waited for worker 0x6b07d0. 2022-08-29 23:21:45 info : Waiting for worker 0x6b15b0. 2022-08-29 23:21:45 info : Waited for worker 0x6b15b0. 2022-08-29 23:21:45 info : Waiting for worker 0x6b20c0. 2022-08-29 23:21:45 info : Waited for worker 0x6b20c0. 2022-08-29 23:21:45 info : Waiting for worker 0x6b2cc0. 2022-08-29 23:21:45 info : Waited for worker 0x6b2cc0. 2022-08-29 23:21:45 info : Waiting for worker 0x6b38d0. 2022-08-29 23:21:45 info : Waited for worker 0x6b38d0. 2022-08-29 23:21:45 info : Waiting for worker 0x6b44e0. 2022-08-29 23:21:45 info : Waited for worker 0x6b44e0. 2022-08-29 23:21:45 info : Waiting for worker 0x6b50f0. 2022-08-29 23:21:45 info : Waited for worker 0x6b50f0. 2022-08-29 23:21:45 info : Waiting for worker 0x6b5d00. 2022-08-29 23:21:45 info : Waited for worker 0x6b5d00. 2022-08-29 23:21:45 notice : All workers have shut down. 2022-08-29 23:21:45 info : Destroying 'Read-Only-Service' 2022-08-29 23:21:45 info : Destroying 'Read-Only-Listener' 2022-08-29 23:21:45 notice : MaxScale shutdown completed. 2022-08-29 23:21:45 notice : MaxScale received signal SIGTERM. Exiting. 2022-08-29 23:21:45 MariaDB MaxScale is shut down. ----------------------------------------------------