MariaDB MaxScale /var/log/maxscale/maxscale.log Wed Nov 23 11:10:19 2022 ---------------------------------------------------------------------------- 2022-11-23 11:10:19 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2022-11-23 11:10:19 notice : Using up to 426.88MiB of memory for query classifier cache 2022-11-23 11:10:19 notice : syslog logging is disabled. 2022-11-23 11:10:19 notice : maxlog logging is enabled. 2022-11-23 11:10:19 notice : Host: 'ekycdb1' OS: Linux@3.10.0-1062.el7.x86_64, #1 SMP Thu Jul 18 20:25:13 UTC 2019, x86_64 with 2 processor cores (2.00 available). 2022-11-23 11:10:19 notice : Total main memory: 2.78GiB (2.78GiB usable). 2022-11-23 11:10:19 notice : MariaDB MaxScale 22.08.2 started (Commit: d6662b78821027046876bedd0d2b687908fef091) 2022-11-23 11:10:19 notice : MaxScale is running in process 32173 2022-11-23 11:10:19 notice : Configuration file: /etc/maxscale.cnf 2022-11-23 11:10:19 notice : Log directory: /var/log/maxscale 2022-11-23 11:10:19 notice : Data directory: /var/lib/maxscale 2022-11-23 11:10:19 notice : Module directory: /usr/lib64/maxscale 2022-11-23 11:10:19 notice : Service cache: /var/cache/maxscale 2022-11-23 11:10:19 notice : Working directory: /var/log/maxscale 2022-11-23 11:10:19 notice : Module 'qc_sqlite' loaded from '/usr/lib64/maxscale/libqc_sqlite.so'. 2022-11-23 11:10:19 notice : Query classification results are cached and reused. Memory used per thread: 213.44MiB 2022-11-23 11:10:19 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2022-11-23 11:10:19 notice : MaxScale started with 2 worker threads. 2022-11-23 11:10:19 notice : Module 'galeramon' loaded from '/usr/lib64/maxscale/libgaleramon.so'. 2022-11-23 11:10:19 notice : Module 'readwritesplit' loaded from '/usr/lib64/maxscale/libreadwritesplit.so'. 2022-11-23 11:10:19 notice : Using HS256 for JWT signatures 2022-11-23 11:10:19 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-11-23 11:10:19 notice : Started REST API on [127.0.0.1]:8989 2022-11-23 11:10:19 error : [MariaDB-Monitor] Failed to connect to server 'server1' ([10.0.2.14]:33063) when checking monitor user credentials and permissions. 2022-11-23 11:10:19 error : [MariaDB-Monitor] Failed to connect to server 'server2' ([10.0.2.15]:33063) when checking monitor user credentials and permissions. 2022-11-23 11:10:19 error : [MariaDB-Monitor] Failed to connect to server 'server3' ([10.0.2.16]:33063) when checking monitor user credentials and permissions. 2022-11-23 11:10:19 error : Failed to start monitor. See earlier errors for more information. 2022-11-23 11:10:19 error : Failed to start monitor 'MariaDB-Monitor'. 2022-11-23 11:10:19 notice : Starting a total of 1 services... 2022-11-23 11:10:19 notice : (Read-Write-Listener); Listening for connections at [0.0.0.0]:4006 2022-11-23 11:10:19 notice : Service 'Read-Write-Service' started (1/1) 2022-11-23 11:12:57 notice : MaxScale is shutting down. 2022-11-23 11:12:57 notice : Stopped MaxScale REST API 2022-11-23 11:12:57 notice : All workers have shut down. 2022-11-23 11:12:57 notice : MaxScale shutdown completed. 2022-11-23 11:12:57 notice : MaxScale received signal SIGTERM. Exiting. 2022-11-23 11:12:57 MariaDB MaxScale is shut down. ---------------------------------------------------- MariaDB MaxScale /var/log/maxscale/maxscale.log Wed Nov 23 11:14:41 2022 ---------------------------------------------------------------------------- 2022-11-23 11:14:41 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2022-11-23 11:14:41 notice : Using up to 426.88MiB of memory for query classifier cache 2022-11-23 11:14:41 notice : syslog logging is disabled. 2022-11-23 11:14:41 notice : maxlog logging is enabled. 2022-11-23 11:14:41 notice : Host: 'ekycdb1' OS: Linux@3.10.0-1062.el7.x86_64, #1 SMP Thu Jul 18 20:25:13 UTC 2019, x86_64 with 2 processor cores (2.00 available). 2022-11-23 11:14:41 notice : Total main memory: 2.78GiB (2.78GiB usable). 2022-11-23 11:14:41 notice : MariaDB MaxScale 22.08.2 started (Commit: d6662b78821027046876bedd0d2b687908fef091) 2022-11-23 11:14:41 notice : MaxScale is running in process 32351 2022-11-23 11:14:41 notice : Configuration file: /etc/maxscale.cnf 2022-11-23 11:14:41 notice : Log directory: /var/log/maxscale 2022-11-23 11:14:41 notice : Data directory: /var/lib/maxscale 2022-11-23 11:14:41 notice : Module directory: /usr/lib64/maxscale 2022-11-23 11:14:41 notice : Service cache: /var/cache/maxscale 2022-11-23 11:14:41 notice : Working directory: /var/log/maxscale 2022-11-23 11:14:41 notice : Module 'qc_sqlite' loaded from '/usr/lib64/maxscale/libqc_sqlite.so'. 2022-11-23 11:14:41 notice : Query classification results are cached and reused. Memory used per thread: 213.44MiB 2022-11-23 11:14:41 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2022-11-23 11:14:41 notice : MaxScale started with 2 worker threads. 2022-11-23 11:14:41 notice : Module 'galeramon' loaded from '/usr/lib64/maxscale/libgaleramon.so'. 2022-11-23 11:14:41 notice : Module 'readwritesplit' loaded from '/usr/lib64/maxscale/libreadwritesplit.so'. 2022-11-23 11:14:41 notice : Using HS256 for JWT signatures 2022-11-23 11:14:41 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-11-23 11:14:41 notice : Started REST API on [127.0.0.1]:8989 2022-11-23 11:14:41 error : [Galera-Monitor] Failed to connect to server 'server1' ([10.0.2.14]:33063) when checking monitor user credentials and permissions. 2022-11-23 11:14:41 error : [Galera-Monitor] Failed to connect to server 'server2' ([10.0.2.15]:33063) when checking monitor user credentials and permissions. 2022-11-23 11:14:41 error : [Galera-Monitor] Failed to connect to server 'server3' ([10.0.2.16]:33063) when checking monitor user credentials and permissions. 2022-11-23 11:14:41 error : Failed to start monitor. See earlier errors for more information. 2022-11-23 11:14:41 error : Failed to start monitor 'Galera-Monitor'. 2022-11-23 11:14:41 notice : Starting a total of 1 services... 2022-11-23 11:14:41 notice : (Read-Write-Listener); Listening for connections at [0.0.0.0]:4006 2022-11-23 11:14:41 notice : Service 'Read-Write-Service' started (1/1) 2022-11-23 11:20:42 notice : MaxScale is shutting down. 2022-11-23 11:20:42 notice : Stopped MaxScale REST API 2022-11-23 11:20:42 notice : All workers have shut down. 2022-11-23 11:20:42 notice : MaxScale shutdown completed. 2022-11-23 11:20:42 notice : MaxScale received signal SIGTERM. Exiting. 2022-11-23 11:20:42 MariaDB MaxScale is shut down. ---------------------------------------------------- MariaDB MaxScale /var/log/maxscale/maxscale.log Wed Nov 23 11:21:28 2022 ---------------------------------------------------------------------------- 2022-11-23 11:21:28 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2022-11-23 11:21:28 notice : Using up to 426.88MiB of memory for query classifier cache 2022-11-23 11:21:28 notice : syslog logging is disabled. 2022-11-23 11:21:28 notice : maxlog logging is enabled. 2022-11-23 11:21:28 notice : Host: 'ekycdb1' OS: Linux@3.10.0-1062.el7.x86_64, #1 SMP Thu Jul 18 20:25:13 UTC 2019, x86_64 with 2 processor cores (2.00 available). 2022-11-23 11:21:28 notice : Total main memory: 2.78GiB (2.78GiB usable). 2022-11-23 11:21:28 notice : MariaDB MaxScale 22.08.2 started (Commit: d6662b78821027046876bedd0d2b687908fef091) 2022-11-23 11:21:28 notice : MaxScale is running in process 32500 2022-11-23 11:21:28 notice : Configuration file: /etc/maxscale.cnf 2022-11-23 11:21:28 notice : Log directory: /var/log/maxscale 2022-11-23 11:21:28 notice : Data directory: /var/lib/maxscale 2022-11-23 11:21:28 notice : Module directory: /usr/lib64/maxscale 2022-11-23 11:21:28 notice : Service cache: /var/cache/maxscale 2022-11-23 11:21:28 notice : Working directory: /var/log/maxscale 2022-11-23 11:21:28 notice : Module 'qc_sqlite' loaded from '/usr/lib64/maxscale/libqc_sqlite.so'. 2022-11-23 11:21:28 notice : Query classification results are cached and reused. Memory used per thread: 213.44MiB 2022-11-23 11:21:28 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2022-11-23 11:21:28 notice : MaxScale started with 2 worker threads. 2022-11-23 11:21:28 notice : Module 'galeramon' loaded from '/usr/lib64/maxscale/libgaleramon.so'. 2022-11-23 11:21:28 notice : Module 'readwritesplit' loaded from '/usr/lib64/maxscale/libreadwritesplit.so'. 2022-11-23 11:21:28 notice : Using HS256 for JWT signatures 2022-11-23 11: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-11-23 11:21:28 notice : Started REST API on [127.0.0.1]:8989 2022-11-23 11:21:28 error : [Galera-Monitor] Failed to connect to server 'server1' ([10.0.2.14]:33063) when checking monitor user credentials and permissions. 2022-11-23 11:21:28 error : [Galera-Monitor] Failed to connect to server 'server2' ([10.0.2.15]:33063) when checking monitor user credentials and permissions. 2022-11-23 11:21:28 error : [Galera-Monitor] Failed to connect to server 'server3' ([10.0.2.16]:33063) when checking monitor user credentials and permissions. 2022-11-23 11:21:28 error : Failed to start monitor. See earlier errors for more information. 2022-11-23 11:21:28 error : Failed to start monitor 'Galera-Monitor'. 2022-11-23 11:21:29 notice : Starting a total of 1 services... 2022-11-23 11:21:29 notice : (Read-Write-Listener); Listening for connections at [0.0.0.0]:4006 2022-11-23 11:21:29 notice : Service 'Read-Write-Service' started (1/1) 2022-11-23 11:24:48 notice : MaxScale is shutting down. 2022-11-23 11:24:48 notice : Stopped MaxScale REST API 2022-11-23 11:24:48 notice : All workers have shut down. 2022-11-23 11:24:48 notice : MaxScale shutdown completed. 2022-11-23 11:24:48 notice : MaxScale received signal SIGTERM. Exiting. 2022-11-23 11:24:48 MariaDB MaxScale is shut down. ---------------------------------------------------- MariaDB MaxScale /var/log/maxscale/maxscale.log Wed Nov 23 11:25:12 2022 ---------------------------------------------------------------------------- 2022-11-23 11:25:12 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2022-11-23 11:25:12 notice : Using up to 426.88MiB of memory for query classifier cache 2022-11-23 11:25:12 notice : syslog logging is disabled. 2022-11-23 11:25:12 notice : maxlog logging is enabled. 2022-11-23 11:25:12 notice : Host: 'ekycdb1' OS: Linux@3.10.0-1062.el7.x86_64, #1 SMP Thu Jul 18 20:25:13 UTC 2019, x86_64 with 2 processor cores (2.00 available). 2022-11-23 11:25:12 notice : Total main memory: 2.78GiB (2.78GiB usable). 2022-11-23 11:25:12 notice : MariaDB MaxScale 22.08.2 started (Commit: d6662b78821027046876bedd0d2b687908fef091) 2022-11-23 11:25:12 notice : MaxScale is running in process 32594 2022-11-23 11:25:12 notice : Configuration file: /etc/maxscale.cnf 2022-11-23 11:25:12 notice : Log directory: /var/log/maxscale 2022-11-23 11:25:12 notice : Data directory: /var/lib/maxscale 2022-11-23 11:25:12 notice : Module directory: /usr/lib64/maxscale 2022-11-23 11:25:12 notice : Service cache: /var/cache/maxscale 2022-11-23 11:25:12 notice : Working directory: /var/log/maxscale 2022-11-23 11:25:12 notice : Module 'qc_sqlite' loaded from '/usr/lib64/maxscale/libqc_sqlite.so'. 2022-11-23 11:25:12 notice : Query classification results are cached and reused. Memory used per thread: 213.44MiB 2022-11-23 11:25:12 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2022-11-23 11:25:12 notice : MaxScale started with 2 worker threads. 2022-11-23 11:25:12 notice : Module 'galeramon' loaded from '/usr/lib64/maxscale/libgaleramon.so'. 2022-11-23 11:25:12 notice : Module 'readwritesplit' loaded from '/usr/lib64/maxscale/libreadwritesplit.so'. 2022-11-23 11:25:12 notice : Using HS256 for JWT signatures 2022-11-23 11:25:12 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-11-23 11:25:12 notice : Started REST API on [127.0.0.1]:8989 2022-11-23 11:25:12 error : [Galera-Monitor] Failed to connect to server 'server1' ([10.0.2.14]:33063) when checking monitor user credentials and permissions. 2022-11-23 11:25:12 error : [Galera-Monitor] Failed to connect to server 'server2' ([10.0.2.15]:33063) when checking monitor user credentials and permissions. 2022-11-23 11:25:12 error : [Galera-Monitor] Failed to connect to server 'server3' ([10.0.2.16]:33063) when checking monitor user credentials and permissions. 2022-11-23 11:25:12 error : Failed to start monitor. See earlier errors for more information. 2022-11-23 11:25:12 error : Failed to start monitor 'Galera-Monitor'. 2022-11-23 11:25:12 notice : Starting a total of 1 services... 2022-11-23 11:25:12 notice : (Read-Write-Listener); Listening for connections at [0.0.0.0]:4006 2022-11-23 11:25:12 notice : Service 'Read-Write-Service' started (1/1) 2022-11-23 11:25:26 notice : MaxScale is shutting down. 2022-11-23 11:25:26 notice : Stopped MaxScale REST API 2022-11-23 11:25:26 notice : All workers have shut down. 2022-11-23 11:25:26 notice : MaxScale shutdown completed. 2022-11-23 11:25:26 notice : MaxScale received signal SIGTERM. Exiting. 2022-11-23 11:25:26 MariaDB MaxScale is shut down. ---------------------------------------------------- MariaDB MaxScale /var/log/maxscale/maxscale.log Wed Nov 23 11:27:14 2022 ---------------------------------------------------------------------------- 2022-11-23 11:27:14 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2022-11-23 11:27:14 notice : Using up to 426.88MiB of memory for query classifier cache 2022-11-23 11:27:14 notice : syslog logging is disabled. 2022-11-23 11:27:14 notice : maxlog logging is enabled. 2022-11-23 11:27:14 notice : Host: 'ekycdb1' OS: Linux@3.10.0-1062.el7.x86_64, #1 SMP Thu Jul 18 20:25:13 UTC 2019, x86_64 with 2 processor cores (2.00 available). 2022-11-23 11:27:14 notice : Total main memory: 2.78GiB (2.78GiB usable). 2022-11-23 11:27:14 notice : MariaDB MaxScale 22.08.2 started (Commit: d6662b78821027046876bedd0d2b687908fef091) 2022-11-23 11:27:14 notice : MaxScale is running in process 32695 2022-11-23 11:27:14 notice : Configuration file: /etc/maxscale.cnf 2022-11-23 11:27:14 notice : Log directory: /var/log/maxscale 2022-11-23 11:27:14 notice : Data directory: /var/lib/maxscale 2022-11-23 11:27:14 notice : Module directory: /usr/lib64/maxscale 2022-11-23 11:27:14 notice : Service cache: /var/cache/maxscale 2022-11-23 11:27:14 notice : Working directory: /var/log/maxscale 2022-11-23 11:27:14 notice : Module 'qc_sqlite' loaded from '/usr/lib64/maxscale/libqc_sqlite.so'. 2022-11-23 11:27:14 notice : Query classification results are cached and reused. Memory used per thread: 213.44MiB 2022-11-23 11:27:14 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2022-11-23 11:27:14 notice : MaxScale started with 2 worker threads. 2022-11-23 11:27:14 notice : Module 'galeramon' loaded from '/usr/lib64/maxscale/libgaleramon.so'. 2022-11-23 11:27:14 notice : Module 'readwritesplit' loaded from '/usr/lib64/maxscale/libreadwritesplit.so'. 2022-11-23 11:27:14 notice : Using HS256 for JWT signatures 2022-11-23 11:27:14 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-11-23 11:27:14 notice : Started REST API on [127.0.0.1]:8989 2022-11-23 11:27:14 error : [Galera-Monitor] Failed to connect to server 'server1' ([10.0.2.14]:33063) when checking monitor user credentials and permissions. 2022-11-23 11:27:14 error : [Galera-Monitor] Failed to connect to server 'server2' ([10.0.2.15]:33063) when checking monitor user credentials and permissions. 2022-11-23 11:27:14 error : [Galera-Monitor] Failed to connect to server 'server3' ([10.0.2.16]:33063) when checking monitor user credentials and permissions. 2022-11-23 11:27:14 error : Failed to start monitor. See earlier errors for more information. 2022-11-23 11:27:14 error : Failed to start monitor 'Galera-Monitor'. 2022-11-23 11:27:14 notice : Starting a total of 1 services... 2022-11-23 11:27:14 notice : (Read-Write-Listener); Listening for connections at [0.0.0.0]:4006 2022-11-23 11:27:14 notice : Service 'Read-Write-Service' started (1/1) 2022-11-23 14:01:19 notice : MaxScale is shutting down. 2022-11-23 14:01:19 notice : Stopped MaxScale REST API 2022-11-23 14:01:19 notice : All workers have shut down. 2022-11-23 14:01:19 notice : MaxScale shutdown completed. 2022-11-23 14:01:19 notice : MaxScale received signal SIGTERM. Exiting. 2022-11-23 14:01:19 MariaDB MaxScale is shut down. ---------------------------------------------------- MariaDB MaxScale /var/log/maxscale/maxscale.log Wed Nov 23 15:22:38 2022 ---------------------------------------------------------------------------- 2022-11-23 15:22:38 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2022-11-23 15:22:38 notice : Using up to 426.88MiB of memory for query classifier cache 2022-11-23 15:22:38 notice : syslog logging is disabled. 2022-11-23 15:22:38 notice : maxlog logging is enabled. 2022-11-23 15:22:38 notice : Host: 'ekycdb1' OS: Linux@3.10.0-1062.el7.x86_64, #1 SMP Thu Jul 18 20:25:13 UTC 2019, x86_64 with 2 processor cores (2.00 available). 2022-11-23 15:22:38 notice : Total main memory: 2.78GiB (2.78GiB usable). 2022-11-23 15:22:38 notice : MariaDB MaxScale 22.08.2 started (Commit: d6662b78821027046876bedd0d2b687908fef091) 2022-11-23 15:22:38 notice : MaxScale is running in process 3642 2022-11-23 15:22:38 notice : Configuration file: /etc/maxscale.cnf 2022-11-23 15:22:38 notice : Log directory: /var/log/maxscale 2022-11-23 15:22:38 notice : Data directory: /var/lib/maxscale 2022-11-23 15:22:38 notice : Module directory: /usr/lib64/maxscale 2022-11-23 15:22:38 notice : Service cache: /var/cache/maxscale 2022-11-23 15:22:38 notice : Working directory: /var/log/maxscale 2022-11-23 15:22:38 notice : Module 'qc_sqlite' loaded from '/usr/lib64/maxscale/libqc_sqlite.so'. 2022-11-23 15:22:38 notice : Query classification results are cached and reused. Memory used per thread: 213.44MiB 2022-11-23 15:22:38 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2022-11-23 15:22:38 notice : MaxScale started with 2 worker threads. 2022-11-23 15:22:38 notice : Module 'galeramon' loaded from '/usr/lib64/maxscale/libgaleramon.so'. 2022-11-23 15:22:38 notice : Module 'readwritesplit' loaded from '/usr/lib64/maxscale/libreadwritesplit.so'. 2022-11-23 15:22:38 notice : Using HS256 for JWT signatures 2022-11-23 15:22:38 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-11-23 15:22:38 notice : Started REST API on [127.0.0.1]:8989 2022-11-23 15:22:38 notice : Server changed state: server1[10.0.2.14:33063]: server_down. [Down] -> [Auth Error, Down] 2022-11-23 15:22:38 notice : Server changed state: server2[10.0.2.15:33063]: server_down. [Down] -> [Auth Error, Down] 2022-11-23 15:22:38 notice : Server changed state: server3[10.0.2.16:33063]: server_down. [Down] -> [Auth Error, Down] 2022-11-23 15:22:38 notice : Starting a total of 1 services... 2022-11-23 15:22:38 notice : (Read-Write-Listener); Listening for connections at [0.0.0.0]:4006 2022-11-23 15:22:38 notice : Service 'Read-Write-Service' started (1/1)