MariaDB MaxScale /var/log/maxscale/maxscale.log Mon Dec 12 13:19:53 2022 ---------------------------------------------------------------------------- 2022-12-12 13:19:53 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2022-12-12 13:19:53 notice : The logging of info messages has been enabled. 2022-12-12 13:19:53 notice : Using up to 1.2GiB of memory for query classifier cache 2022-12-12 13:19:53 notice : syslog logging is disabled. 2022-12-12 13:19:53 notice : maxlog logging is enabled. 2022-12-12 13:19:53 notice : Host: 'mxsactive' OS: Linux@3.10.0-693.17.1.el7.x86_64, #1 SMP Thu Jan 25 20:13:58 UTC 2018, x86_64 with 2 processor cores (2.00 available). 2022-12-12 13:19:53 notice : Total main memory: 8.01GiB (8.01GiB usable). 2022-12-12 13:19:53 notice : MariaDB MaxScale 22.08.3 started (Commit: 2949f820a7d9de38d7fd51909f66d561627d1eed) 2022-12-12 13:19:53 notice : MaxScale is running in process 1407 2022-12-12 13:19:53 notice : Configuration file: /etc/maxscale.cnf 2022-12-12 13:19:53 notice : Log directory: /var/log/maxscale 2022-12-12 13:19:53 notice : Data directory: /var/lib/maxscale 2022-12-12 13:19:53 notice : Module directory: /usr/lib64/maxscale 2022-12-12 13:19:53 notice : Service cache: /var/cache/maxscale 2022-12-12 13:19:53 notice : Working directory: /var/log/maxscale 2022-12-12 13:19:53 notice : Module 'qc_sqlite' loaded from '/usr/lib64/maxscale/libqc_sqlite.so'. 2022-12-12 13:19:53 info : qc_sqlite loaded. 2022-12-12 13:19:53 notice : Query classification results are cached and reused. Memory used per thread: 615.43MiB 2022-12-12 13:19:53 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2022-12-12 13:19:53 info : Epoll instance for listening sockets added to worker epoll instance. 2022-12-12 13:19:53 info : Epoll instance for listening sockets added to worker epoll instance. 2022-12-12 13:19:53 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139971184523008. 2022-12-12 13:19:53 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139971105126144. 2022-12-12 13:19:53 notice : MaxScale started with 2 worker threads. 2022-12-12 13:19:53 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139971362397312. 2022-12-12 13:19:53 info : No 'auto_tune' parameters specified, no auto tuning will be performed. 2022-12-12 13:19:53 notice : Module 'mariadbmon' loaded from '/usr/lib64/maxscale/libmariadbmon.so'. 2022-12-12 13:19:53 notice : Module 'readconnroute' loaded from '/usr/lib64/maxscale/libreadconnroute.so'. 2022-12-12 13:19:53 notice : Module 'readwritesplit' loaded from '/usr/lib64/maxscale/libreadwritesplit.so'. 2022-12-12 13:19:53 notice : Using HS256 for JWT signatures 2022-12-12 13:19:53 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-12-12 13:19:53 notice : Started REST API on [127.0.0.1]:8989 2022-12-12 13:19:53 warning: Discarding journal file '/var/lib/maxscale/MariaDB-Monitor_journal.json'. File is for MaxScale version 60404. Current MaxScale version is 220803. 2022-12-12 13:19:53 notice : 'server2' sent version string '10.6.9-5-MariaDB-enterprise-log'. Detected type: 'MariaDB', version: 10.6.9. 2022-12-12 13:19:53 notice : 'server1' sent version string '10.6.9-5-MariaDB-enterprise-log'. Detected type: 'MariaDB', version: 10.6.9. 2022-12-12 13:19:53 notice : Server 'server2' charset: latin1 2022-12-12 13:19:53 notice : Server 'server1' charset: latin1 2022-12-12 13:19:53 notice : [mariadbmon] Selecting new master server. 2022-12-12 13:19:53 notice : [mariadbmon] Setting 'server1' as master. 2022-12-12 13:19:53 notice : Server changed state: server1[192.168.254.19:3306]: master_up. [Down] -> [Master, Running] 2022-12-12 13:19:53 notice : Server changed state: server2[192.168.254.25:3306]: slave_up. [Down] -> [Slave, Running] 2022-12-12 13:19:53 notice : Starting a total of 3 services... 2022-12-12 13:19:53 notice : (ReadOnlySlaveListener); Listening for connections at [0.0.0.0]:4406 2022-12-12 13:19:53 notice : Service 'ReadOnlySlaveService' started (1/3) 2022-12-12 13:19:53 notice : (ReadWriteMasterListener); Listening for connections at [0.0.0.0]:4405 2022-12-12 13:19:53 notice : Service 'ReadWriteMasterService' started (2/3) 2022-12-12 13:19:53 notice : (ReadWriteSplitListener); Listening for connections at [0.0.0.0]:4404 2022-12-12 13:19:53 notice : Service 'ReadWriteSplitService' started (3/3) 2022-12-12 13:19:54 notice : Read 8 user@host entries from 'server1' for service 'ReadWriteMasterService'. 2022-12-12 13:19:54 notice : Read 8 user@host entries from 'server1' for service 'ReadWriteSplitService'. 2022-12-12 13:19:54 notice : Read 8 user@host entries from 'server1' for service 'ReadOnlySlaveService'. 2022-12-12 13:19:58 info : Variables have changed on 'server1', next check in 10 seconds: 'session_track_system_variables = autocommit,character_set_client,character_set_connection,character_set_results,time_zone', 'wait_timeout = 120' 2022-12-12 13:19:58 info : Variables have changed on 'server2', next check in 10 seconds: 'session_track_system_variables = autocommit,character_set_client,character_set_connection,character_set_results,time_zone', 'wait_timeout = 120' 2022-12-12 13:21:33 info : (1) Found matching user 'allen'@'%' for client 'allen'@'192.168.254.1' with sufficient privileges. 2022-12-12 13:21:33 info : (1) [readwritesplit] (ReadWriteSplitService); Target connection counts: 2022-12-12 13:21:33 info : (1) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server1 Master, Running 2022-12-12 13:21:33 info : (1) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server2 Slave, Running 2022-12-12 13:21:33 info : (1) [readwritesplit] (ReadWriteSplitService); Connected to 'server1' 2022-12-12 13:21:33 info : (1) [readwritesplit] (ReadWriteSplitService); Selected Master: server1 2022-12-12 13:21:33 info : (1) [readwritesplit] (ReadWriteSplitService); Connected to 'server2' 2022-12-12 13:21:33 info : (1) [readwritesplit] (ReadWriteSplitService); Selected Slave: server2 2022-12-12 13:21:33 info : (1) Started ReadWriteSplitService client session [1] for 'allen' from 192.168.254.1 2022-12-12 13:21:33 info : (1) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 13:21:33 info : (1) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 13:21:33 info : (1) (server2); Storing COM_QUERY while in state 'Handshaking': SELECT @@tx_isolation 2022-12-12 13:21:33 info : (1) Connected to 'server1' with thread id 3367 2022-12-12 13:21:33 info : (1) Connected to 'server2' with thread id 11580 2022-12-12 13:21:33 info : (1) Authentication to 'server1' succeeded. 2022-12-12 13:21:33 info : (1) Authentication to 'server2' succeeded. 2022-12-12 13:21:33 info : (1) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 13:21:33 info : (1) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 13, type: QUERY_TYPE_READ, stmt: select 1 2022-12-12 13:21:33 info : (1) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 13:21:33 info : (1) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 49B) 2022-12-12 13:21:33 info : (1) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x01) COM_QUIT, plen: 5, type: QUERY_TYPE_SESSION_WRITE, stmt: 2022-12-12 13:21:33 info : (1) [readwritesplit] (ReadWriteSplitService); Session write, routing to all servers. 2022-12-12 13:21:33 info : (1) [readwritesplit] (ReadWriteSplitService); Route query to master: server1 2022-12-12 13:21:33 info : (1) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 2022-12-12 13:21:33 info : (1) Stopped ReadWriteSplitService client session [1] 2022-12-12 13:21:33 info : (2) Found matching user 'allen'@'%' for client 'allen'@'192.168.254.1' with sufficient privileges. 2022-12-12 13:21:33 info : (2) [readwritesplit] (ReadWriteSplitService); Target connection counts: 2022-12-12 13:21:33 info : (2) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server1 Master, Running 2022-12-12 13:21:33 info : (2) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server2 Slave, Running 2022-12-12 13:21:33 info : (2) [readwritesplit] (ReadWriteSplitService); Connected to 'server1' 2022-12-12 13:21:33 info : (2) [readwritesplit] (ReadWriteSplitService); Selected Master: server1 2022-12-12 13:21:33 info : (2) [readwritesplit] (ReadWriteSplitService); Connected to 'server2' 2022-12-12 13:21:33 info : (2) [readwritesplit] (ReadWriteSplitService); Selected Slave: server2 2022-12-12 13:21:33 info : (2) Started ReadWriteSplitService client session [2] for 'allen' from 192.168.254.1 2022-12-12 13:21:33 info : (2) Connected to 'server1' with thread id 3368 2022-12-12 13:21:33 info : (2) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 13:21:33 info : (2) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 13:21:33 info : (2) (server2); Storing COM_QUERY while in state 'Handshaking': SELECT @@tx_isolation 2022-12-12 13:21:33 info : (2) Connected to 'server2' with thread id 11581 2022-12-12 13:21:33 info : (2) Authentication to 'server1' succeeded. 2022-12-12 13:21:33 info : (2) Authentication to 'server2' succeeded. 2022-12-12 13:21:33 info : (2) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 13:21:33 info : (2) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 13:21:33 info : (2) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 13:21:33 info : (2) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 13:21:33 info : (2) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 13:21:33 info : (2) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 13:21:33 info : (2) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 13:21:33 info : (2) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 58, type: QUERY_TYPE_READ, stmt: select sleep(300), SUBJECT from STP_APP_MAIL_POLLER; 2022-12-12 13:21:33 info : (2) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 13:23:33 info : (2) [readwritesplit] (ReadWriteSplitService); Master 'server1' failed: #HY000: Lost connection to backend server: network error (server1: 104, Connection reset by peer) 2022-12-12 13:23:33 error : (2) [readwritesplit] (ReadWriteSplitService); Lost connection to the master server, closing session. Lost connection to master server while connection was idle. Connection has been idle for 120 seconds. Error caused by: #HY000: Lost connection to backend server: network error (server1: 104, Connection reset by peer). Last close reason: . Lasterror: 2022-12-12 13:23:33 info : (2) Stopped ReadWriteSplitService client session [2] 2022-12-12 13:52:14 info : (3) Found matching user 'allen'@'%' for client 'allen'@'192.168.254.1' with sufficient privileges. 2022-12-12 13:52:14 info : (3) [readwritesplit] (ReadWriteSplitService); Target connection counts: 2022-12-12 13:52:14 info : (3) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server1 Master, Running 2022-12-12 13:52:14 info : (3) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server2 Slave, Running 2022-12-12 13:52:14 info : (3) [readwritesplit] (ReadWriteSplitService); Connected to 'server1' 2022-12-12 13:52:14 info : (3) [readwritesplit] (ReadWriteSplitService); Selected Master: server1 2022-12-12 13:52:14 info : (3) [readwritesplit] (ReadWriteSplitService); Connected to 'server2' 2022-12-12 13:52:14 info : (3) [readwritesplit] (ReadWriteSplitService); Selected Slave: server2 2022-12-12 13:52:14 info : (3) Started ReadWriteSplitService client session [3] for 'allen' from 192.168.254.1 2022-12-12 13:52:14 info : (3) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 13:52:14 info : (3) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 13:52:14 info : (3) (server2); Storing COM_QUERY while in state 'Handshaking': SELECT @@tx_isolation 2022-12-12 13:52:14 info : (3) Connected to 'server1' with thread id 3369 2022-12-12 13:52:14 info : (3) Connected to 'server2' with thread id 13393 2022-12-12 13:52:14 info : (3) Authentication to 'server1' succeeded. 2022-12-12 13:52:14 info : (3) Authentication to 'server2' succeeded. 2022-12-12 13:52:14 info : (3) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 13:52:14 info : (3) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 13, type: QUERY_TYPE_READ, stmt: select 1 2022-12-12 13:52:14 info : (3) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 13:52:14 info : (3) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 49B) 2022-12-12 13:52:14 info : (3) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x01) COM_QUIT, plen: 5, type: QUERY_TYPE_SESSION_WRITE, stmt: 2022-12-12 13:52:14 info : (3) [readwritesplit] (ReadWriteSplitService); Session write, routing to all servers. 2022-12-12 13:52:14 info : (3) [readwritesplit] (ReadWriteSplitService); Route query to master: server1 2022-12-12 13:52:14 info : (3) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 2022-12-12 13:52:14 info : (3) Stopped ReadWriteSplitService client session [3] 2022-12-12 13:52:14 info : (4) Found matching user 'allen'@'%' for client 'allen'@'192.168.254.1' with sufficient privileges. 2022-12-12 13:52:14 info : (4) [readwritesplit] (ReadWriteSplitService); Target connection counts: 2022-12-12 13:52:14 info : (4) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server1 Master, Running 2022-12-12 13:52:14 info : (4) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server2 Slave, Running 2022-12-12 13:52:14 info : (4) [readwritesplit] (ReadWriteSplitService); Connected to 'server1' 2022-12-12 13:52:14 info : (4) [readwritesplit] (ReadWriteSplitService); Selected Master: server1 2022-12-12 13:52:14 info : (4) [readwritesplit] (ReadWriteSplitService); Connected to 'server2' 2022-12-12 13:52:14 info : (4) [readwritesplit] (ReadWriteSplitService); Selected Slave: server2 2022-12-12 13:52:14 info : (4) Started ReadWriteSplitService client session [4] for 'allen' from 192.168.254.1 2022-12-12 13:52:14 info : (4) Connected to 'server1' with thread id 3370 2022-12-12 13:52:14 info : (4) Connected to 'server2' with thread id 13394 2022-12-12 13:52:14 info : (4) Authentication to 'server2' succeeded. 2022-12-12 13:52:14 info : (4) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 13:52:14 info : (4) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 13:52:14 info : (4) Authentication to 'server1' succeeded. 2022-12-12 13:52:14 info : (4) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 13:52:14 info : (4) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 13:52:14 info : (4) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 13:52:14 info : (4) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 13:52:14 info : (4) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 13:52:14 info : (4) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 13:52:14 info : (4) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 13:52:14 info : (4) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 58, type: QUERY_TYPE_READ, stmt: select sleep(300), SUBJECT from STP_APP_MAIL_POLLER; 2022-12-12 13:52:14 info : (4) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 13:54:14 info : (4) [readwritesplit] (ReadWriteSplitService); Slave 'server2' failed: #HY000: Lost connection to backend server: connection closed by peer (server2) 2022-12-12 13:54:14 info : (4) [readwritesplit] (ReadWriteSplitService); Re-routing failed read after server 'server2' failed 2022-12-12 13:54:14 info : (4) [readwritesplit] (ReadWriteSplitService); Master 'server1' failed: #HY000: Lost connection to backend server: network error (server1: 104, Connection reset by peer) 2022-12-12 13:54:14 error : (4) [readwritesplit] (ReadWriteSplitService); Lost connection to the master server, closing session. Lost connection to master server while connection was idle. Connection has been idle for 120 seconds. Error caused by: #HY000: Lost connection to backend server: network error (server1: 104, Connection reset by peer). Last close reason: . Lasterror: 2022-12-12 13:54:14 info : (4) Stopped ReadWriteSplitService client session [4] 2022-12-12 13:55:24 info : (5) Found matching user 'allen'@'%' for client 'allen'@'192.168.254.1' with sufficient privileges. 2022-12-12 13:55:24 info : (5) [readwritesplit] (ReadWriteSplitService); Target connection counts: 2022-12-12 13:55:24 info : (5) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server1 Master, Running 2022-12-12 13:55:24 info : (5) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server2 Slave, Running 2022-12-12 13:55:24 info : (5) [readwritesplit] (ReadWriteSplitService); Connected to 'server1' 2022-12-12 13:55:24 info : (5) [readwritesplit] (ReadWriteSplitService); Selected Master: server1 2022-12-12 13:55:24 info : (5) [readwritesplit] (ReadWriteSplitService); Connected to 'server2' 2022-12-12 13:55:24 info : (5) [readwritesplit] (ReadWriteSplitService); Selected Slave: server2 2022-12-12 13:55:24 info : (5) Started ReadWriteSplitService client session [5] for 'allen' from 192.168.254.1 2022-12-12 13:55:24 info : (5) Connected to 'server2' with thread id 13584 2022-12-12 13:55:24 info : (5) Connected to 'server1' with thread id 3450 2022-12-12 13:55:24 info : (5) Authentication to 'server2' succeeded. 2022-12-12 13:55:24 info : (5) Authentication to 'server1' succeeded. 2022-12-12 13:55:24 info : (5) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 13:55:24 info : (5) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 13:55:24 info : (5) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 13:55:24 info : (5) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 13, type: QUERY_TYPE_READ, stmt: select 1 2022-12-12 13:55:24 info : (5) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 13:55:24 info : (5) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 49B) 2022-12-12 13:55:24 info : (5) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x01) COM_QUIT, plen: 5, type: QUERY_TYPE_SESSION_WRITE, stmt: 2022-12-12 13:55:24 info : (5) [readwritesplit] (ReadWriteSplitService); Session write, routing to all servers. 2022-12-12 13:55:24 info : (5) [readwritesplit] (ReadWriteSplitService); Route query to master: server1 2022-12-12 13:55:24 info : (5) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 2022-12-12 13:55:24 info : (5) Stopped ReadWriteSplitService client session [5] 2022-12-12 13:55:24 info : (6) Found matching user 'allen'@'%' for client 'allen'@'192.168.254.1' with sufficient privileges. 2022-12-12 13:55:24 info : (6) [readwritesplit] (ReadWriteSplitService); Target connection counts: 2022-12-12 13:55:24 info : (6) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server1 Master, Running 2022-12-12 13:55:24 info : (6) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server2 Slave, Running 2022-12-12 13:55:24 info : (6) [readwritesplit] (ReadWriteSplitService); Connected to 'server1' 2022-12-12 13:55:24 info : (6) [readwritesplit] (ReadWriteSplitService); Selected Master: server1 2022-12-12 13:55:24 info : (6) [readwritesplit] (ReadWriteSplitService); Connected to 'server2' 2022-12-12 13:55:24 info : (6) [readwritesplit] (ReadWriteSplitService); Selected Slave: server2 2022-12-12 13:55:24 info : (6) Started ReadWriteSplitService client session [6] for 'allen' from 192.168.254.1 2022-12-12 13:55:24 info : (6) Connected to 'server1' with thread id 3451 2022-12-12 13:55:24 info : (6) Authentication to 'server1' succeeded. 2022-12-12 13:55:24 info : (6) Connected to 'server2' with thread id 13585 2022-12-12 13:55:24 info : (6) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 13:55:24 info : (6) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 13:55:24 info : (6) (server2); Storing COM_QUERY while in state 'Authenticating': SELECT @@tx_isolation 2022-12-12 13:55:24 info : (6) Authentication to 'server2' succeeded. 2022-12-12 13:55:24 info : (6) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 13:55:24 info : (6) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 13:55:24 info : (6) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 13:55:24 info : (6) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 13:55:24 info : (6) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 13:55:24 info : (6) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 13:55:24 info : (6) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 13:55:24 info : (6) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 58, type: QUERY_TYPE_READ, stmt: select sleep(300), SUBJECT from STP_APP_MAIL_POLLER; 2022-12-12 13:55:24 info : (6) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 13:57:24 info : (6) [readwritesplit] (ReadWriteSplitService); Master 'server1' failed: #HY000: Lost connection to backend server: network error (server1: 104, Connection reset by peer) 2022-12-12 13:57:24 error : (6) [readwritesplit] (ReadWriteSplitService); Lost connection to the master server, closing session. Lost connection to master server while connection was idle. Connection has been idle for 120 seconds. Error caused by: #HY000: Lost connection to backend server: network error (server1: 104, Connection reset by peer). Last close reason: . Lasterror: 2022-12-12 13:57:24 info : (6) Stopped ReadWriteSplitService client session [6] 2022-12-12 14:14:48 info : (7) Found matching user 'allen'@'%' for client 'allen'@'192.168.254.1' with sufficient privileges. 2022-12-12 14:14:48 info : (7) [readwritesplit] (ReadWriteSplitService); Target connection counts: 2022-12-12 14:14:48 info : (7) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server1 Master, Running 2022-12-12 14:14:48 info : (7) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server2 Slave, Running 2022-12-12 14:14:48 info : (7) [readwritesplit] (ReadWriteSplitService); Connected to 'server1' 2022-12-12 14:14:48 info : (7) [readwritesplit] (ReadWriteSplitService); Selected Master: server1 2022-12-12 14:14:48 info : (7) [readwritesplit] (ReadWriteSplitService); Connected to 'server2' 2022-12-12 14:14:48 info : (7) [readwritesplit] (ReadWriteSplitService); Selected Slave: server2 2022-12-12 14:14:48 info : (7) Started ReadWriteSplitService client session [7] for 'allen' from 192.168.254.1 2022-12-12 14:14:48 info : (7) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 14:14:48 info : (7) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 14:14:48 info : (7) (server2); Storing COM_QUERY while in state 'Handshaking': SELECT @@tx_isolation 2022-12-12 14:14:48 info : (7) Connected to 'server1' with thread id 4029 2022-12-12 14:14:48 info : (7) Connected to 'server2' with thread id 14729 2022-12-12 14:14:48 info : (7) Authentication to 'server1' succeeded. 2022-12-12 14:14:48 info : (7) Authentication to 'server2' succeeded. 2022-12-12 14:14:48 info : (7) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 14:14:48 info : (7) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 13, type: QUERY_TYPE_READ, stmt: select 1 2022-12-12 14:14:48 info : (7) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 14:14:48 info : (7) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 49B) 2022-12-12 14:14:48 info : (7) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x01) COM_QUIT, plen: 5, type: QUERY_TYPE_SESSION_WRITE, stmt: 2022-12-12 14:14:48 info : (7) [readwritesplit] (ReadWriteSplitService); Session write, routing to all servers. 2022-12-12 14:14:48 info : (7) [readwritesplit] (ReadWriteSplitService); Route query to master: server1 2022-12-12 14:14:48 info : (7) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 2022-12-12 14:14:48 info : (7) Stopped ReadWriteSplitService client session [7] 2022-12-12 14:14:48 info : (8) Found matching user 'allen'@'%' for client 'allen'@'192.168.254.1' with sufficient privileges. 2022-12-12 14:14:48 info : (8) [readwritesplit] (ReadWriteSplitService); Target connection counts: 2022-12-12 14:14:48 info : (8) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server1 Master, Running 2022-12-12 14:14:48 info : (8) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server2 Slave, Running 2022-12-12 14:14:48 info : (8) [readwritesplit] (ReadWriteSplitService); Connected to 'server1' 2022-12-12 14:14:48 info : (8) [readwritesplit] (ReadWriteSplitService); Selected Master: server1 2022-12-12 14:14:48 info : (8) [readwritesplit] (ReadWriteSplitService); Connected to 'server2' 2022-12-12 14:14:48 info : (8) [readwritesplit] (ReadWriteSplitService); Selected Slave: server2 2022-12-12 14:14:48 info : (8) Started ReadWriteSplitService client session [8] for 'allen' from 192.168.254.1 2022-12-12 14:14:48 info : (8) Connected to 'server1' with thread id 4030 2022-12-12 14:14:48 info : (8) Connected to 'server2' with thread id 14730 2022-12-12 14:14:48 info : (8) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 14:14:48 info : (8) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 14:14:48 info : (8) (server2); Storing COM_QUERY while in state 'Authenticating': SELECT @@tx_isolation 2022-12-12 14:14:48 info : (8) Authentication to 'server1' succeeded. 2022-12-12 14:14:48 info : (8) Authentication to 'server2' succeeded. 2022-12-12 14:14:48 info : (8) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 14:14:48 info : (8) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 14:14:48 info : (8) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 14:14:48 info : (8) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 14:14:48 info : (8) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 14:14:48 info : (8) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 14:14:48 info : (8) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 14:14:48 info : (8) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 58, type: QUERY_TYPE_READ, stmt: select sleep(300), SUBJECT from STP_APP_MAIL_POLLER; 2022-12-12 14:14:48 info : (8) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 14:15:59 info : (8) [readwritesplit] (ReadWriteSplitService); Master 'server1' failed: #HY000: Lost connection to backend server: connection closed by peer (server1) 2022-12-12 14:15:59 error : (8) [readwritesplit] (ReadWriteSplitService); Lost connection to the master server, closing session. Lost connection to master server while connection was idle. Connection has been idle for 71 seconds. Error caused by: #HY000: Lost connection to backend server: connection closed by peer (server1). Last close reason: . Last error: 2022-12-12 14:15:59 info : (8) Stopped ReadWriteSplitService client session [8] 2022-12-12 14:18:29 info : (9) Found matching user 'allen'@'%' for client 'allen'@'192.168.254.1' with sufficient privileges. 2022-12-12 14:18:29 info : (9) [readwritesplit] (ReadWriteSplitService); Target connection counts: 2022-12-12 14:18:29 info : (9) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server1 Master, Running 2022-12-12 14:18:29 info : (9) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server2 Slave, Running 2022-12-12 14:18:29 info : (9) [readwritesplit] (ReadWriteSplitService); Connected to 'server1' 2022-12-12 14:18:29 info : (9) [readwritesplit] (ReadWriteSplitService); Selected Master: server1 2022-12-12 14:18:29 info : (9) [readwritesplit] (ReadWriteSplitService); Connected to 'server2' 2022-12-12 14:18:29 info : (9) [readwritesplit] (ReadWriteSplitService); Selected Slave: server2 2022-12-12 14:18:29 info : (9) Started ReadWriteSplitService client session [9] for 'allen' from 192.168.254.1 2022-12-12 14:18:29 info : (9) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 14:18:29 info : (9) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 14:18:29 info : (9) (server2); Storing COM_QUERY while in state 'Handshaking': SELECT @@tx_isolation 2022-12-12 14:18:29 info : (9) Connected to 'server1' with thread id 4141 2022-12-12 14:18:29 info : (9) Connected to 'server2' with thread id 14949 2022-12-12 14:18:29 info : (9) Authentication to 'server1' succeeded. 2022-12-12 14:18:29 info : (9) Authentication to 'server2' succeeded. 2022-12-12 14:18:29 info : (9) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 14:18:29 info : (9) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 13, type: QUERY_TYPE_READ, stmt: select 1 2022-12-12 14:18:29 info : (9) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 14:18:29 info : (9) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 49B) 2022-12-12 14:18:29 info : (9) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x01) COM_QUIT, plen: 5, type: QUERY_TYPE_SESSION_WRITE, stmt: 2022-12-12 14:18:29 info : (9) [readwritesplit] (ReadWriteSplitService); Session write, routing to all servers. 2022-12-12 14:18:29 info : (9) [readwritesplit] (ReadWriteSplitService); Route query to master: server1 2022-12-12 14:18:29 info : (9) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 2022-12-12 14:18:29 info : (9) Stopped ReadWriteSplitService client session [9] 2022-12-12 14:18:29 info : (10) Found matching user 'allen'@'%' for client 'allen'@'192.168.254.1' with sufficient privileges. 2022-12-12 14:18:29 info : (10) [readwritesplit] (ReadWriteSplitService); Target connection counts: 2022-12-12 14:18:29 info : (10) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server1 Master, Running 2022-12-12 14:18:29 info : (10) [readwritesplit] (ReadWriteSplitService); current operations : 0 in server2 Slave, Running 2022-12-12 14:18:29 info : (10) [readwritesplit] (ReadWriteSplitService); Connected to 'server1' 2022-12-12 14:18:29 info : (10) [readwritesplit] (ReadWriteSplitService); Selected Master: server1 2022-12-12 14:18:29 info : (10) [readwritesplit] (ReadWriteSplitService); Connected to 'server2' 2022-12-12 14:18:29 info : (10) [readwritesplit] (ReadWriteSplitService); Selected Slave: server2 2022-12-12 14:18:29 info : (10) Started ReadWriteSplitService client session [10] for 'allen' from 192.168.254.1 2022-12-12 14:18:29 info : (10) Connected to 'server1' with thread id 4142 2022-12-12 14:18:29 info : (10) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 14:18:29 info : (10) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 14:18:29 info : (10) (server2); Storing COM_QUERY while in state 'Handshaking': SELECT @@tx_isolation 2022-12-12 14:18:29 info : (10) Authentication to 'server1' succeeded. 2022-12-12 14:18:29 info : (10) Connected to 'server2' with thread id 14950 2022-12-12 14:18:29 info : (10) Authentication to 'server2' succeeded. 2022-12-12 14:18:29 info : (10) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 14:18:29 info : (10) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 14:18:29 info : (10) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 14:18:29 info : (10) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 14:18:29 info : (10) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 26, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: SELECT @@tx_isolation 2022-12-12 14:18:29 info : (10) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 14:18:29 info : (10) [readwritesplit] (ReadWriteSplitService); Reply complete from 'server2' (Resultset: 1 rows in 76B) 2022-12-12 14:18:29 info : (10) (ReadWriteSplitService); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 58, type: QUERY_TYPE_READ, stmt: select sleep(300), SUBJECT from STP_APP_MAIL_POLLER; 2022-12-12 14:18:29 info : (10) [readwritesplit] (ReadWriteSplitService); Route query to slave: server2 < 2022-12-12 14:20:29 info : (10) [readwritesplit] (ReadWriteSplitService); Master 'server1' failed: #HY000: Lost connection to backend server: network error (server1: 104, Connection reset by peer) 2022-12-12 14:20:29 error : (10) [readwritesplit] (ReadWriteSplitService); Lost connection to the master server, closing session. Lost connection to master server while connection was idle. Connection has been idle for 120 seconds. Error caused by: #HY000: Lost connection to backend server: network error (server1: 104, Connection reset by peer). Last close reason: . Last error: 2022-12-12 14:20:29 info : (10) Stopped ReadWriteSplitService client session [10] 2022-12-12 14:33:52 info : (11) Found matching user 'allen'@'%' for client 'allen'@'192.168.254.1' with sufficient privileges. 2022-12-12 14:33:52 info : (11) [readconnroute] (ReadOnlySlaveService); New session for server server2. Connections : 1 2022-12-12 14:33:52 info : (11) Started ReadOnlySlaveService client session [11] for 'allen' from 192.168.254.1 2022-12-12 14:33:52 info : (11) [readconnroute] (ReadOnlySlaveService); Routed [COM_QUERY] to 'server2' SELECT @@tx_isolation 2022-12-12 14:33:52 info : (11) (server2); Storing COM_QUERY while in state 'Handshaking': SELECT @@tx_isolation 2022-12-12 14:33:52 info : (11) Connected to 'server2' with thread id 15861 2022-12-12 14:33:52 info : (11) Authentication to 'server2' succeeded. 2022-12-12 14:33:52 info : (11) [readconnroute] (ReadOnlySlaveService); Routed [COM_QUERY] to 'server2' select 1 2022-12-12 14:33:52 info : (11) [readconnroute] (ReadOnlySlaveService); Routed [COM_QUIT] to 'server2' 2022-12-12 14:33:52 info : (11) Stopped ReadOnlySlaveService client session [11] 2022-12-12 14:33:52 info : (12) Found matching user 'allen'@'%' for client 'allen'@'192.168.254.1' with sufficient privileges. 2022-12-12 14:33:52 info : (12) [readconnroute] (ReadOnlySlaveService); New session for server server2. Connections : 1 2022-12-12 14:33:52 info : (12) Started ReadOnlySlaveService client session [12] for 'allen' from 192.168.254.1 2022-12-12 14:33:52 info : (12) [readconnroute] (ReadOnlySlaveService); Routed [COM_QUERY] to 'server2' SELECT @@tx_isolation 2022-12-12 14:33:52 info : (12) (server2); Storing COM_QUERY while in state 'Handshaking': SELECT @@tx_isolation 2022-12-12 14:33:52 info : (12) Connected to 'server2' with thread id 15862 2022-12-12 14:33:52 info : (12) Authentication to 'server2' succeeded. 2022-12-12 14:33:52 info : (12) [readconnroute] (ReadOnlySlaveService); Routed [COM_QUERY] to 'server2' SELECT @@tx_isolation 2022-12-12 14:33:52 info : (12) [readconnroute] (ReadOnlySlaveService); Routed [COM_QUERY] to 'server2' SELECT @@tx_isolation 2022-12-12 14:33:52 info : (12) [readconnroute] (ReadOnlySlaveService); Routed [COM_QUERY] to 'server2' select sleep(300), SUBJECT from STP_APP_MAIL_POLLER; 2022-12-12 15:02:07 info : (12) Stopped ReadOnlySlaveService client session [12]