MariaDB MaxScale /var/log/maxscale/maxscale.log Mon Sep 12 10:12:01 2022 ---------------------------------------------------------------------------- 2022-09-12 10:12:01 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2022-09-12 10:12:01 notice : The logging of info messages has been enabled. 2022-09-12 10:12:01 notice : Using up to 507.27MiB of memory for query classifier cache 2022-09-12 10:12:01 notice : syslog logging is disabled. 2022-09-12 10:12:01 notice : maxlog logging is enabled. 2022-09-12 10:12:01 notice : Host: 'mdbci-8ykq536a-1662968056-maxscale-000' OS: Linux@3.10.0-1160.76.1.el7.x86_64, #1 SMP Tue Jul 26 14:15:37 UTC 2022, x86_64 with 4 processor cores (4 available). 2022-09-12 10:12:01 notice : Total usable main memory: 3.3GiB (3.3GiB available). 2022-09-12 10:12:01 notice : MariaDB MaxScale 22.08.2 started (Commit: 2c23e5b843d03745ac4ce6a282fe0c837a569a53) 2022-09-12 10:12:01 notice : MaxScale is running in process 27094 2022-09-12 10:12:01 notice : Configuration file: /etc/maxscale.cnf 2022-09-12 10:12:01 notice : Log directory: /var/log/maxscale 2022-09-12 10:12:01 notice : Data directory: /var/lib/maxscale 2022-09-12 10:12:01 notice : Module directory: /usr/lib64/maxscale 2022-09-12 10:12:01 notice : Service cache: /var/cache/maxscale 2022-09-12 10:12:01 notice : Working directory: /var/log/maxscale 2022-09-12 10:12:01 notice : Module 'qc_sqlite' loaded from '/usr/lib64/maxscale/libqc_sqlite.so'. 2022-09-12 10:12:01 info : qc_sqlite loaded. 2022-09-12 10:12:01 notice : Query classification results are cached and reused. Memory used per thread: 126.82MiB 2022-09-12 10:12:01 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2022-09-12 10:12:01 info : Epoll instance for listening sockets added to worker epoll instance. 2022-09-12 10:12:01 info : Epoll instance for listening sockets added to worker epoll instance. 2022-09-12 10:12:01 info : Epoll instance for listening sockets added to worker epoll instance. 2022-09-12 10:12:01 info : Epoll instance for listening sockets added to worker epoll instance. 2022-09-12 10:12:01 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139982877632256. 2022-09-12 10:12:01 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139982869239552. 2022-09-12 10:12:01 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139982860846848. 2022-09-12 10:12:01 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139982647850752. 2022-09-12 10:12:01 notice : MaxScale started with 4 worker threads. 2022-09-12 10:12:01 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139983085739136. 2022-09-12 10:12:01 info : No 'auto_tune' parameters specified, no auto tuning will be performed. 2022-09-12 10:12:01 notice : /etc/maxscale.cnf.d does not exist, not reading. 2022-09-12 10:12:01 warning: monitor module 'mysqlmon' has been deprecated, use 'mariadbmon' instead. 2022-09-12 10:12:01 notice : Module 'mariadbmon' loaded from '/usr/lib64/maxscale/libmariadbmon.so'. 2022-09-12 10:12:01 notice : Module 'readwritesplit' loaded from '/usr/lib64/maxscale/libreadwritesplit.so'. 2022-09-12 10:12:01 notice : Using HS256 for JWT signatures 2022-09-12 10:12:01 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-09-12 10:12:01 notice : Started REST API on [127.0.0.1]:8989 2022-09-12 10:12:01 notice : 'server3' sent version string '10.8.4-MariaDB-log'. Detected type: 'MariaDB', version: 10.8.4. 2022-09-12 10:12:01 notice : 'server1' sent version string '10.8.4-MariaDB-log'. Detected type: 'MariaDB', version: 10.8.4. 2022-09-12 10:12:01 notice : 'server4' sent version string '10.8.4-MariaDB-log'. Detected type: 'MariaDB', version: 10.8.4. 2022-09-12 10:12:01 notice : 'server2' sent version string '10.8.4-MariaDB-log'. Detected type: 'MariaDB', version: 10.8.4. 2022-09-12 10:12:01 notice : Server 'server3' charset: latin1 2022-09-12 10:12:01 notice : Server 'server1' charset: latin1 2022-09-12 10:12:01 notice : Server 'server4' charset: latin1 2022-09-12 10:12:01 notice : Server 'server2' charset: latin1 2022-09-12 10:12:01 notice : [mariadbmon] Selecting new master server. 2022-09-12 10:12:01 notice : [mariadbmon] Setting 'server1' as master. 2022-09-12 10:12:01 notice : Server changed state: server1[10.128.0.54:3306]: master_up. [Down] -> [Master, Running] 2022-09-12 10:12:01 notice : Server changed state: server2[10.128.0.49:3306]: slave_up. [Down] -> [Slave, Running] 2022-09-12 10:12:01 notice : Server changed state: server3[10.128.0.12:3306]: slave_up. [Down] -> [Slave, Running] 2022-09-12 10:12:01 notice : Server changed state: server4[10.128.0.11:3306]: slave_up. [Down] -> [Slave, Running] 2022-09-12 10:12:01 notice : Starting a total of 1 services... 2022-09-12 10:12:01 notice : (RW-Split-Listener); Listening for connections at [::]:4006 2022-09-12 10:12:01 notice : Service 'RW-Split-Router' started (1/1) 2022-09-12 10:12:01 info : Accept authentication from 'admin', using password. Request: /v1/maxscale/debug/monitor_wait 2022-09-12 10:12:01 notice : Read 17 user@host entries from 'server1' for service 'RW-Split-Router'. 2022-09-12 10:12:01 info : (1) Found matching user 'skysql'@'%' for client 'skysql'@'::ffff:10.128.0.2' with sufficient privileges. 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); Target connection counts: 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); current operations : 0 in server1 Master, Running 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); current operations : 0 in server2 Slave, Running 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); current operations : 0 in server3 Slave, Running 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); current operations : 0 in server4 Slave, Running 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); Connected to 'server1' 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); Selected Master: server1 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); Connected to 'server2' 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); Selected Slave: server2 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); Connected to 'server3' 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); Selected Slave: server3 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); Connected to 'server4' 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); Selected Slave: server4 2022-09-12 10:12:01 info : (1) Started RW-Split-Router client session [1] for 'skysql' from ::ffff:10.128.0.2 2022-09-12 10:12:01 info : (1) Connected to 'server1' with thread id 14928 2022-09-12 10:12:01 info : (1) Connected to 'server3' with thread id 1493 2022-09-12 10:12:01 info : (1) Connected to 'server2' with thread id 1497 2022-09-12 10:12:01 info : (1) Authentication to 'server1' succeeded. 2022-09-12 10:12:01 info : (1) Connected to 'server4' with thread id 1487 2022-09-12 10:12:01 info : (1) Authentication to 'server3' succeeded. 2022-09-12 10:12:01 info : (1) Authentication to 'server2' succeeded. 2022-09-12 10:12:01 info : (1) Authentication to 'server4' succeeded. --- Default test --- --- Executing SELECT SLEEP --- 2022-09-12 10:12:01 info : (1) (RW-Split-Router); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); Session write, routing to all servers. 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); Route query to master: server1 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); Route query to slave: server2 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); Route query to slave: server3 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); Route query to slave: server4 2022-09-12 10:12:01 info : (1) [readwritesplit] (RW-Split-Router); Will return response from 'server1' to the client 2022-09-12 10:12:02 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 = 28800' 2022-09-12 10:12:02 info : Variables have changed on 'server3', next check in 10 seconds: 'session_track_system_variables = autocommit,character_set_client,character_set_connection,character_set_results,time_zone', 'wait_timeout = 28800' 2022-09-12 10:12:02 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 = 28800' 2022-09-12 10:12:02 info : Variables have changed on 'server4', next check in 10 seconds: 'session_track_system_variables = autocommit,character_set_client,character_set_connection,character_set_results,time_zone', 'wait_timeout = 28800' --- Blocking all nodes --- 2022-09-12 10:12:05 info : Accept authentication from 'admin', using password. Request: /v1/maxscale/debug/monitor_wait 2022-09-12 10:12:08 error : Monitor was unable to connect to server server4[10.128.0.11:3306] : 'Can't connect to server on '10.128.0.11' (115)' 2022-09-12 10:12:08 error : Monitor was unable to connect to server server3[10.128.0.12:3306] : 'Can't connect to server on '10.128.0.12' (115)' 2022-09-12 10:12:08 error : Monitor was unable to connect to server server2[10.128.0.49:3306] : 'Can't connect to server on '10.128.0.49' (115)' 2022-09-12 10:12:08 error : Monitor was unable to connect to server server1[10.128.0.54:3306] : 'Can't connect to server on '10.128.0.54' (115)' 2022-09-12 10:12:08 notice : Server changed state: server1[10.128.0.54:3306]: master_down. [Master, Running] -> [Down] 2022-09-12 10:12:08 notice : Server changed state: server2[10.128.0.49:3306]: slave_down. [Slave, Running] -> [Down] 2022-09-12 10:12:08 notice : Server changed state: server3[10.128.0.12:3306]: slave_down. [Slave, Running] -> [Down] 2022-09-12 10:12:08 notice : Server changed state: server4[10.128.0.11:3306]: slave_down. [Slave, Running] -> [Down] 2022-09-12 10:12:08 info : (1) [readwritesplit] (RW-Split-Router); Master 'server1' failed: #HY000: Lost connection to backend server: connection closed by peer (server1: Generated event) 2022-09-12 10:12:08 info : (1) [readwritesplit] (RW-Split-Router); Slave 'server2' failed: #HY000: Lost connection to backend server: connection closed by peer (server2: Generated event) 2022-09-12 10:12:08 info : (1) [readwritesplit] (RW-Split-Router); Slave 'server3' failed: #HY000: Lost connection to backend server: connection closed by peer (server3: Generated event) 2022-09-12 10:12:08 info : (1) [readwritesplit] (RW-Split-Router); Slave 'server4' failed: #HY000: Lost connection to backend server: connection closed by peer (server4: Generated event) 2022-09-12 10:12:08 info : Accept authentication from 'admin', using password. Request: /v1/maxscale/debug/monitor_wait 2022-09-12 10:12:09 info : (1) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:12:09 info : (1) [readwritesplit] Session write, routing to all servers. 2022-09-12 10:12:09 info : (1) [readwritesplit] No connections available for session command 2022-09-12 10:12:09 info : (1) [readwritesplit] Attempting to create a connection 2022-09-12 10:12:09 info : (1) [readwritesplit] Delaying routing: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:12:10 info : (1) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:12:10 info : (1) [readwritesplit] Session write, routing to all servers. 2022-09-12 10:12:10 info : (1) [readwritesplit] No connections available for session command 2022-09-12 10:12:10 info : (1) [readwritesplit] Attempting to create a connection 2022-09-12 10:12:10 info : (1) [readwritesplit] Delaying routing: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:12:11 info : (1) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:12:11 info : (1) [readwritesplit] Session write, routing to all servers. 2022-09-12 10:12:11 info : (1) [readwritesplit] No connections available for session command 2022-09-12 10:12:11 info : (1) [readwritesplit] Attempting to create a connection 2022-09-12 10:12:11 info : (1) [readwritesplit] Delaying routing: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:12:12 info : (1) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:12:12 info : (1) [readwritesplit] Session write, routing to all servers. 2022-09-12 10:12:12 info : (1) [readwritesplit] No connections available for session command 2022-09-12 10:12:12 info : (1) [readwritesplit] Attempting to create a connection 2022-09-12 10:12:12 info : (1) [readwritesplit] Delaying routing: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:12:13 info : (1) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:12:13 info : (1) [readwritesplit] Session write, routing to all servers. 2022-09-12 10:12:13 info : (1) [readwritesplit] No connections available for session command 2022-09-12 10:12:13 info : (1) [readwritesplit] Attempting to create a connection 2022-09-12 10:12:13 info : (1) [readwritesplit] Delaying routing: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:12:14 info : (1) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:12:14 info : (1) [readwritesplit] Session write, routing to all servers. 2022-09-12 10:12:14 info : (1) [readwritesplit] No connections available for session command 2022-09-12 10:12:14 info : (1) [readwritesplit] Attempting to create a connection 2022-09-12 10:12:14 info : (1) [readwritesplit] Delaying routing: SET @a=(SELECT SLEEP(10)) --- Unblocking all nodes --- 2022-09-12 10:12:14 info : Accept authentication from 'admin', using password. Request: /v1/maxscale/debug/monitor_wait 2022-09-12 10:12:14 notice : Server changed state: server1[10.128.0.54:3306]: master_up. [Down] -> [Master, Running] 2022-09-12 10:12:14 notice : Server changed state: server2[10.128.0.49:3306]: slave_up. [Down] -> [Slave, Running] 2022-09-12 10:12:14 notice : Server changed state: server3[10.128.0.12:3306]: slave_up. [Down] -> [Slave, Running] 2022-09-12 10:12:14 notice : Server changed state: server4[10.128.0.11:3306]: slave_up. [Down] -> [Slave, Running] 2022-09-12 10:12:14 info : Accept authentication from 'admin', using password. Request: /v1/maxscale/debug/monitor_wait 2022-09-12 10:12:15 info : (1) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:12:15 info : (1) [readwritesplit] Session write, routing to all servers. 2022-09-12 10:12:15 info : (1) [readwritesplit] No connections available for session command 2022-09-12 10:12:15 info : (1) [readwritesplit] Attempting to create a connection 2022-09-12 10:12:15 info : (1) [readwritesplit] Connected to 'server1' 2022-09-12 10:12:15 info : (1) [readwritesplit] Chose 'server1' as master due to session write 2022-09-12 10:12:15 info : (1) (server1); Storing COM_QUERY while in state 'Handshaking': SET @a=(SELECT SLEEP(10)) 2022-09-12 10:12:15 info : (1) [readwritesplit] Route query to master: server1 2022-09-12 10:12:15 info : (1) [readwritesplit] Will return response from 'server1' to the client 2022-09-12 10:12:15 info : (1) Connected to 'server1' with thread id 14930 2022-09-12 10:12:15 info : (1) Authentication to 'server1' succeeded. 2022-09-12 10:12:25 info : (1) [readwritesplit] (RW-Split-Router); Reply complete from 'server1' (OK: 0 warnings) 2022-09-12 10:12:25 info : (1) [MariaDBProtocol] (RW-Split-Router); Added COM_QUERY to history with ID 1: SET @a=(SELECT SLEEP(10)) (result: OK) --- Executing SELECT 1 --- 2022-09-12 10:12:25 info : (1) (RW-Split-Router); > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 13, type: QUERY_TYPE_READ, stmt: SELECT 1 2022-09-12 10:12:25 info : (1) [readwritesplit] (RW-Split-Router); Connected to 'server2' 2022-09-12 10:12:25 info : (1) [readwritesplit] (RW-Split-Router); Route query to slave: server2 < 2022-09-12 10:12:25 info : (1) (server2); Storing COM_QUERY while in state 'Handshaking': SELECT 1 2022-09-12 10:12:25 info : (1) Connected to 'server2' with thread id 1499 2022-09-12 10:12:25 info : (1) Authentication to 'server2' succeeded. 2022-09-12 10:12:25 info : (1) Execute COM_QUERY 1 on 'server2': SET @a=(SELECT SLEEP(10)) 2022-09-12 10:12:35 info : (1) Reply to 1 complete 2022-09-12 10:12:35 info : (1) [readwritesplit] (RW-Split-Router); Reply complete from 'server2' (Resultset: 1 rows in 57B) --- Inside a transaction --- 2022-09-12 10:12:35 info : (1) (RW-Split-Router); > Autocommit: [enabled], trx is [not open], cmd: (0x01) COM_QUIT, plen: 5, type: QUERY_TYPE_SESSION_WRITE, stmt: 2022-09-12 10:12:35 info : (1) [readwritesplit] (RW-Split-Router); Session write, routing to all servers. 2022-09-12 10:12:35 info : (1) [readwritesplit] (RW-Split-Router); Route query to master: server1 2022-09-12 10:12:35 info : (1) [readwritesplit] (RW-Split-Router); Route query to slave: server2 2022-09-12 10:12:35 info : Stopped RW-Split-Router client session [1] 2022-09-12 10:12:35 info : (2) Found matching user 'skysql'@'%' for client 'skysql'@'::ffff:10.128.0.2' with sufficient privileges. 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Target connection counts: 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); current operations : 0 in server1 Master, Running 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); current operations : 0 in server2 Slave, Running 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); current operations : 0 in server3 Slave, Running 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); current operations : 0 in server4 Slave, Running 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Connected to 'server1' 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Selected Master: server1 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Connected to 'server2' 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Selected Slave: server2 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Connected to 'server3' 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Selected Slave: server3 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Connected to 'server4' 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Selected Slave: server4 2022-09-12 10:12:35 info : (2) Started RW-Split-Router client session [2] for 'skysql' from ::ffff:10.128.0.2 2022-09-12 10:12:35 info : (2) (RW-Split-Router); > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 22, type: QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Route query to master: server1 < 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Transaction starting on 'server1' 2022-09-12 10:12:35 info : (2) (server1); Storing COM_QUERY while in state 'Handshaking': START TRANSACTION 2022-09-12 10:12:35 info : (2) Connected to 'server3' with thread id 1495 2022-09-12 10:12:35 info : (2) Connected to 'server1' with thread id 14931 2022-09-12 10:12:35 info : (2) Connected to 'server2' with thread id 1500 2022-09-12 10:12:35 info : (2) Authentication to 'server3' succeeded. 2022-09-12 10:12:35 info : (2) Connected to 'server4' with thread id 1489 2022-09-12 10:12:35 info : (2) Authentication to 'server2' succeeded. 2022-09-12 10:12:35 info : (2) Authentication to 'server1' succeeded. 2022-09-12 10:12:35 info : (2) Authentication to 'server4' succeeded. 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Adding COM_QUERY to trx: START TRANSACTION 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Reply complete from 'server1' (OK: 0 warnings) --- Executing SELECT SLEEP --- 2022-09-12 10:12:35 info : (2) (RW-Split-Router); > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Session write, routing to all servers. 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Route query to master: server1 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Route query to slave: server2 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Route query to slave: server3 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Route query to slave: server4 2022-09-12 10:12:35 info : (2) [readwritesplit] (RW-Split-Router); Will return response from 'server1' to the client --- Blocking all nodes --- 2022-09-12 10:12:38 info : Accept authentication from 'admin', using password. Request: /v1/maxscale/debug/monitor_wait 2022-09-12 10:12:41 error : Monitor was unable to connect to server server3[10.128.0.12:3306] : 'Can't connect to server on '10.128.0.12' (115)' 2022-09-12 10:12:41 error : Monitor was unable to connect to server server1[10.128.0.54:3306] : 'Can't connect to server on '10.128.0.54' (115)' 2022-09-12 10:12:41 error : Monitor was unable to connect to server server2[10.128.0.49:3306] : 'Can't connect to server on '10.128.0.49' (115)' 2022-09-12 10:12:41 error : Monitor was unable to connect to server server4[10.128.0.11:3306] : 'Can't connect to server on '10.128.0.11' (115)' 2022-09-12 10:12:41 notice : Server changed state: server1[10.128.0.54:3306]: master_down. [Master, Running] -> [Down] 2022-09-12 10:12:41 notice : Server changed state: server2[10.128.0.49:3306]: slave_down. [Slave, Running] -> [Down] 2022-09-12 10:12:41 notice : Server changed state: server3[10.128.0.12:3306]: slave_down. [Slave, Running] -> [Down] 2022-09-12 10:12:41 notice : Server changed state: server4[10.128.0.11:3306]: slave_down. [Slave, Running] -> [Down] 2022-09-12 10:12:41 info : (2) [readwritesplit] (RW-Split-Router); Master 'server1' failed: #HY000: Lost connection to backend server: connection closed by peer (server1: Generated event) 2022-09-12 10:12:41 info : (2) [readwritesplit] (RW-Split-Router); Starting transaction replay 1. Replay has been ongoing for 0 seconds. 2022-09-12 10:12:41 info : (2) [readwritesplit] (RW-Split-Router); Replaying COM_QUERY: START TRANSACTION 2022-09-12 10:12:41 info : (2) [readwritesplit] (RW-Split-Router); Slave 'server2' failed: #HY000: Lost connection to backend server: connection closed by peer (server2: Generated event) 2022-09-12 10:12:41 info : (2) [readwritesplit] (RW-Split-Router); Slave 'server3' failed: #HY000: Lost connection to backend server: connection closed by peer (server3: Generated event) 2022-09-12 10:12:41 info : (2) [readwritesplit] (RW-Split-Router); Slave 'server4' failed: #HY000: Lost connection to backend server: connection closed by peer (server4: Generated event) 2022-09-12 10:12:41 info : Accept authentication from 'admin', using password. Request: /v1/maxscale/debug/monitor_wait 2022-09-12 10:12:42 info : (2) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 22, type: QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION 2022-09-12 10:12:42 info : (2) [readwritesplit] Delaying routing: START TRANSACTION 2022-09-12 10:12:43 info : (2) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 22, type: QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION 2022-09-12 10:12:43 info : (2) [readwritesplit] Delaying routing: START TRANSACTION 2022-09-12 10:12:44 info : (2) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 22, type: QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION 2022-09-12 10:12:44 info : (2) [readwritesplit] Delaying routing: START TRANSACTION 2022-09-12 10:12:45 info : (2) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 22, type: QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION 2022-09-12 10:12:45 info : (2) [readwritesplit] Delaying routing: START TRANSACTION 2022-09-12 10:12:46 info : (2) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 22, type: QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION 2022-09-12 10:12:46 info : (2) [readwritesplit] Delaying routing: START TRANSACTION 2022-09-12 10:12:47 info : (2) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 22, type: QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION 2022-09-12 10:12:47 info : (2) [readwritesplit] Delaying routing: START TRANSACTION 2022-09-12 10:12:48 info : (2) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 22, type: QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION 2022-09-12 10:12:48 info : (2) [readwritesplit] Delaying routing: START TRANSACTION 2022-09-12 10:12:49 info : (2) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 22, type: QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION 2022-09-12 10:12:49 info : (2) [readwritesplit] Delaying routing: START TRANSACTION --- Unblocking all nodes --- 2022-09-12 10:12:49 notice : Server changed state: server1[10.128.0.54:3306]: master_up. [Down] -> [Master, Running] 2022-09-12 10:12:49 notice : Server changed state: server2[10.128.0.49:3306]: slave_up. [Down] -> [Slave, Running] 2022-09-12 10:12:49 notice : Server changed state: server3[10.128.0.12:3306]: slave_up. [Down] -> [Slave, Running] 2022-09-12 10:12:49 notice : Server changed state: server4[10.128.0.11:3306]: slave_up. [Down] -> [Slave, Running] 2022-09-12 10:12:49 info : Accept authentication from 'admin', using password. Request: /v1/maxscale/debug/monitor_wait 2022-09-12 10:12:50 info : Accept authentication from 'admin', using password. Request: /v1/maxscale/debug/monitor_wait 2022-09-12 10:12:50 info : (2) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 22, type: QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION 2022-09-12 10:12:50 info : (2) [readwritesplit] Connected to 'server1' 2022-09-12 10:12:50 info : (2) [readwritesplit] Route query to master: server1 < 2022-09-12 10:12:50 info : (2) [readwritesplit] Transaction starting on 'server1' 2022-09-12 10:12:50 info : (2) (server1); Storing COM_QUERY while in state 'Handshaking': START TRANSACTION 2022-09-12 10:12:50 info : (2) Connected to 'server1' with thread id 14933 2022-09-12 10:12:50 info : (2) Authentication to 'server1' succeeded. 2022-09-12 10:12:50 info : (2) [readwritesplit] (RW-Split-Router); Adding COM_QUERY to trx: START TRANSACTION 2022-09-12 10:12:50 info : (2) [readwritesplit] (RW-Split-Router); Reply complete from 'server1' (OK: 0 warnings) 2022-09-12 10:12:50 info : (2) [readwritesplit] (RW-Split-Router); Checksums match, replay successful. Replay took 9 seconds. 2022-09-12 10:12:50 info : (2) [readwritesplit] (RW-Split-Router); Resuming execution: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:12:50 info : (2) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:12:50 info : (2) [readwritesplit] Session write, routing to all servers. 2022-09-12 10:12:50 info : (2) [readwritesplit] Route query to master: server1 2022-09-12 10:12:50 info : (2) [readwritesplit] Will return response from 'server1' to the client 2022-09-12 10:13:00 info : (2) [readwritesplit] (RW-Split-Router); Adding COM_QUERY to trx: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:00 info : (2) [readwritesplit] (RW-Split-Router); Reply complete from 'server1' (OK: 0 warnings) 2022-09-12 10:13:00 info : (2) [MariaDBProtocol] (RW-Split-Router); Added COM_QUERY to history with ID 1: SET @a=(SELECT SLEEP(10)) (result: OK) --- Executing SELECT 1 --- 2022-09-12 10:13:00 info : (2) (RW-Split-Router); > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 13, type: QUERY_TYPE_READ, stmt: SELECT 1 2022-09-12 10:13:00 info : (2) [readwritesplit] (RW-Split-Router); Route query to master: server1 < 2022-09-12 10:13:00 info : (2) [readwritesplit] (RW-Split-Router); Adding COM_QUERY to trx: SELECT 1 2022-09-12 10:13:00 info : (2) [readwritesplit] (RW-Split-Router); Reply complete from 'server1' (Resultset: 1 rows in 57B) 2022-09-12 10:13:00 info : (2) (RW-Split-Router); > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 11, type: QUERY_TYPE_COMMIT, stmt: COMMIT 2022-09-12 10:13:00 info : (2) [readwritesplit] (RW-Split-Router); Route query to master: server1 < 2022-09-12 10:13:00 info : (2) [readwritesplit] (RW-Split-Router); Adding COM_QUERY to trx: COMMIT 2022-09-12 10:13:00 info : (2) [readwritesplit] (RW-Split-Router); Reply complete from 'server1' (OK: 0 warnings) 2022-09-12 10:13:00 info : (2) [readwritesplit] (RW-Split-Router); Transaction complete on 'server1' --- Inside a read-only transaction --- 2022-09-12 10:13:00 info : (2) (RW-Split-Router); > Autocommit: [enabled], trx is [not open], cmd: (0x01) COM_QUIT, plen: 5, type: QUERY_TYPE_SESSION_WRITE, stmt: 2022-09-12 10:13:00 info : (2) [readwritesplit] (RW-Split-Router); Session write, routing to all servers. 2022-09-12 10:13:00 info : (2) [readwritesplit] (RW-Split-Router); Route query to master: server1 2022-09-12 10:13:00 info : Stopped RW-Split-Router client session [2] 2022-09-12 10:13:00 info : (3) Found matching user 'skysql'@'%' for client 'skysql'@'::ffff:10.128.0.2' with sufficient privileges. 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Target connection counts: 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); current operations : 0 in server1 Master, Running 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); current operations : 0 in server2 Slave, Running 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); current operations : 0 in server3 Slave, Running 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); current operations : 0 in server4 Slave, Running 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Connected to 'server1' 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Selected Master: server1 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Connected to 'server2' 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Selected Slave: server2 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Connected to 'server3' 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Selected Slave: server3 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Connected to 'server4' 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Selected Slave: server4 2022-09-12 10:13:00 info : (3) Started RW-Split-Router client session [3] for 'skysql' from ::ffff:10.128.0.2 2022-09-12 10:13:00 info : (3) (RW-Split-Router); > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 32, type: QUERY_TYPE_READ|QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION READ ONLY 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Route query to slave: server2 < 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Transaction starting on 'server2' 2022-09-12 10:13:00 info : (3) (server2); Storing COM_QUERY while in state 'Handshaking': START TRANSACTION READ ONLY 2022-09-12 10:13:00 info : (3) Connected to 'server1' with thread id 14934 2022-09-12 10:13:00 info : (3) Connected to 'server2' with thread id 1502 2022-09-12 10:13:00 info : (3) Connected to 'server3' with thread id 1497 2022-09-12 10:13:00 info : (3) Authentication to 'server1' succeeded. 2022-09-12 10:13:00 info : (3) Authentication to 'server2' succeeded. 2022-09-12 10:13:00 info : (3) Connected to 'server4' with thread id 1491 2022-09-12 10:13:00 info : (3) Authentication to 'server3' succeeded. 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Adding COM_QUERY to trx: START TRANSACTION READ ONLY 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Reply complete from 'server2' (OK: 0 warnings) 2022-09-12 10:13:00 info : (3) Authentication to 'server4' succeeded. --- Executing SELECT SLEEP --- 2022-09-12 10:13:00 info : (3) (RW-Split-Router); > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Session write, routing to all servers. 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Route query to master: server1 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Route query to slave: server2 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Route query to slave: server3 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Route query to slave: server4 2022-09-12 10:13:00 info : (3) [readwritesplit] (RW-Split-Router); Will return response from 'server2' to the client --- Blocking all nodes --- 2022-09-12 10:13:03 info : Accept authentication from 'admin', using password. Request: /v1/maxscale/debug/monitor_wait 2022-09-12 10:13:06 error : Monitor was unable to connect to server server4[10.128.0.11:3306] : 'Can't connect to server on '10.128.0.11' (115)' 2022-09-12 10:13:06 error : Monitor was unable to connect to server server2[10.128.0.49:3306] : 'Can't connect to server on '10.128.0.49' (115)' 2022-09-12 10:13:06 error : Monitor was unable to connect to server server1[10.128.0.54:3306] : 'Can't connect to server on '10.128.0.54' (115)' 2022-09-12 10:13:06 error : Monitor was unable to connect to server server3[10.128.0.12:3306] : 'Can't connect to server on '10.128.0.12' (115)' 2022-09-12 10:13:06 notice : Server changed state: server1[10.128.0.54:3306]: master_down. [Master, Running] -> [Down] 2022-09-12 10:13:06 notice : Server changed state: server2[10.128.0.49:3306]: slave_down. [Slave, Running] -> [Down] 2022-09-12 10:13:06 notice : Server changed state: server3[10.128.0.12:3306]: slave_down. [Slave, Running] -> [Down] 2022-09-12 10:13:06 notice : Server changed state: server4[10.128.0.11:3306]: slave_down. [Slave, Running] -> [Down] 2022-09-12 10:13:06 info : (3) [readwritesplit] (RW-Split-Router); Master 'server1' failed: #HY000: Lost connection to backend server: connection closed by peer (server1: Generated event) 2022-09-12 10:13:06 info : (3) [readwritesplit] (RW-Split-Router); Slave 'server2' failed: #HY000: Lost connection to backend server: connection closed by peer (server2: Generated event) 2022-09-12 10:13:06 info : (3) [readwritesplit] (RW-Split-Router); Starting transaction replay 1. Replay has been ongoing for 0 seconds. 2022-09-12 10:13:06 info : (3) [readwritesplit] (RW-Split-Router); Replaying COM_QUERY: START TRANSACTION READ ONLY 2022-09-12 10:13:06 info : (3) [readwritesplit] (RW-Split-Router); Slave 'server3' failed: #HY000: Lost connection to backend server: connection closed by peer (server3: Generated event) 2022-09-12 10:13:06 info : (3) [readwritesplit] (RW-Split-Router); Slave 'server4' failed: #HY000: Lost connection to backend server: connection closed by peer (server4: Generated event) 2022-09-12 10:13:06 info : Accept authentication from 'admin', using password. Request: /v1/maxscale/debug/monitor_wait 2022-09-12 10:13:07 info : (3) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 32, type: QUERY_TYPE_READ|QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION READ ONLY 2022-09-12 10:13:07 info : (3) [readwritesplit] Was supposed to route to slave but finding suitable one failed. 2022-09-12 10:13:07 info : (3) [readwritesplit] Delaying routing: START TRANSACTION READ ONLY 2022-09-12 10:13:08 info : (3) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 32, type: QUERY_TYPE_READ|QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION READ ONLY 2022-09-12 10:13:08 info : (3) [readwritesplit] Was supposed to route to slave but finding suitable one failed. 2022-09-12 10:13:08 info : (3) [readwritesplit] Delaying routing: START TRANSACTION READ ONLY 2022-09-12 10:13:09 info : (3) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 32, type: QUERY_TYPE_READ|QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION READ ONLY 2022-09-12 10:13:09 info : (3) [readwritesplit] Was supposed to route to slave but finding suitable one failed. 2022-09-12 10:13:09 info : (3) [readwritesplit] Delaying routing: START TRANSACTION READ ONLY 2022-09-12 10:13:10 info : (3) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 32, type: QUERY_TYPE_READ|QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION READ ONLY 2022-09-12 10:13:10 info : (3) [readwritesplit] Was supposed to route to slave but finding suitable one failed. 2022-09-12 10:13:10 info : (3) [readwritesplit] Delaying routing: START TRANSACTION READ ONLY 2022-09-12 10:13:11 info : (3) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 32, type: QUERY_TYPE_READ|QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION READ ONLY 2022-09-12 10:13:11 info : (3) [readwritesplit] Was supposed to route to slave but finding suitable one failed. 2022-09-12 10:13:11 info : (3) [readwritesplit] Delaying routing: START TRANSACTION READ ONLY 2022-09-12 10:13:12 info : (3) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 32, type: QUERY_TYPE_READ|QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION READ ONLY 2022-09-12 10:13:12 info : (3) [readwritesplit] Was supposed to route to slave but finding suitable one failed. 2022-09-12 10:13:12 info : (3) [readwritesplit] Delaying routing: START TRANSACTION READ ONLY --- Unblocking all nodes --- 2022-09-12 10:13:13 info : Accept authentication from 'admin', using password. Request: /v1/maxscale/debug/monitor_wait 2022-09-12 10:13:13 notice : Server changed state: server1[10.128.0.54:3306]: master_up. [Down] -> [Master, Running] 2022-09-12 10:13:13 notice : Server changed state: server2[10.128.0.49:3306]: slave_up. [Down] -> [Slave, Running] 2022-09-12 10:13:13 notice : Server changed state: server3[10.128.0.12:3306]: slave_up. [Down] -> [Slave, Running] 2022-09-12 10:13:13 notice : Server changed state: server4[10.128.0.11:3306]: slave_up. [Down] -> [Slave, Running] 2022-09-12 10:13:13 info : Accept authentication from 'admin', using password. Request: /v1/maxscale/debug/monitor_wait 2022-09-12 10:13:13 info : (3) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 32, type: QUERY_TYPE_READ|QUERY_TYPE_BEGIN_TRX, stmt: START TRANSACTION READ ONLY 2022-09-12 10:13:13 info : (3) [readwritesplit] Connected to 'server2' 2022-09-12 10:13:13 info : (3) [readwritesplit] Route query to slave: server2 < 2022-09-12 10:13:13 info : (3) [readwritesplit] Transaction starting on 'server2' 2022-09-12 10:13:13 info : (3) (server2); Storing COM_QUERY while in state 'Handshaking': START TRANSACTION READ ONLY 2022-09-12 10:13:13 info : (3) Connected to 'server2' with thread id 1504 2022-09-12 10:13:13 info : (3) Authentication to 'server2' succeeded. 2022-09-12 10:13:13 info : (3) [readwritesplit] (RW-Split-Router); Adding COM_QUERY to trx: START TRANSACTION READ ONLY 2022-09-12 10:13:13 info : (3) [readwritesplit] (RW-Split-Router); Reply complete from 'server2' (OK: 0 warnings) 2022-09-12 10:13:13 info : (3) [readwritesplit] (RW-Split-Router); Checksums match, replay successful. Replay took 7 seconds. 2022-09-12 10:13:13 info : (3) [readwritesplit] (RW-Split-Router); Resuming execution: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:13 info : (3) > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:13 info : (3) [readwritesplit] Session write, routing to all servers. 2022-09-12 10:13:13 info : (3) [readwritesplit] Route query to slave: server2 2022-09-12 10:13:13 info : (3) [readwritesplit] Will return response from 'server2' to the client 2022-09-12 10:13:23 info : (3) [readwritesplit] (RW-Split-Router); Adding COM_QUERY to trx: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:23 info : (3) [readwritesplit] (RW-Split-Router); Reply complete from 'server2' (OK: 0 warnings) 2022-09-12 10:13:23 info : (3) [MariaDBProtocol] (RW-Split-Router); Added COM_QUERY to history with ID 1: SET @a=(SELECT SLEEP(10)) (result: OK) --- Executing SELECT 1 --- 2022-09-12 10:13:23 info : (3) (RW-Split-Router); > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 13, type: QUERY_TYPE_READ, stmt: SELECT 1 2022-09-12 10:13:23 info : (3) [readwritesplit] (RW-Split-Router); Route query to slave: server2 < 2022-09-12 10:13:23 info : (3) [readwritesplit] (RW-Split-Router); Adding COM_QUERY to trx: SELECT 1 2022-09-12 10:13:23 info : (3) [readwritesplit] (RW-Split-Router); Reply complete from 'server2' (Resultset: 1 rows in 57B) 2022-09-12 10:13:23 info : (3) (RW-Split-Router); > Autocommit: [enabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 11, type: QUERY_TYPE_COMMIT, stmt: COMMIT 2022-09-12 10:13:23 info : (3) [readwritesplit] (RW-Split-Router); Route query to slave: server2 < 2022-09-12 10:13:23 info : (3) [readwritesplit] (RW-Split-Router); Adding COM_QUERY to trx: COMMIT 2022-09-12 10:13:23 info : (3) [readwritesplit] (RW-Split-Router); Reply complete from 'server2' (OK: 0 warnings) 2022-09-12 10:13:23 info : (3) [readwritesplit] (RW-Split-Router); Transaction complete on 'server2' --- Autocommit disabled --- 2022-09-12 10:13:24 info : (3) (RW-Split-Router); > Autocommit: [enabled], trx is [not open], cmd: (0x01) COM_QUIT, plen: 5, type: QUERY_TYPE_SESSION_WRITE, stmt: 2022-09-12 10:13:24 info : (3) [readwritesplit] (RW-Split-Router); Session write, routing to all servers. 2022-09-12 10:13:24 info : (3) [readwritesplit] (RW-Split-Router); Route query to slave: server2 2022-09-12 10:13:24 info : Stopped RW-Split-Router client session [3] 2022-09-12 10:13:24 info : (4) Found matching user 'skysql'@'%' for client 'skysql'@'::ffff:10.128.0.2' with sufficient privileges. 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Target connection counts: 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); current operations : 0 in server1 Master, Running 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); current operations : 0 in server2 Slave, Running 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); current operations : 0 in server3 Slave, Running 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); current operations : 0 in server4 Slave, Running 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Connected to 'server1' 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Selected Master: server1 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Connected to 'server2' 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Selected Slave: server2 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Connected to 'server3' 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Selected Slave: server3 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Connected to 'server4' 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Selected Slave: server4 2022-09-12 10:13:24 info : (4) Started RW-Split-Router client session [4] for 'skysql' from ::ffff:10.128.0.2 2022-09-12 10:13:24 info : (4) (RW-Split-Router); > Autocommit: [disabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 21, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_BEGIN_TRX|QUERY_TYPE_DISABLE_AUTOCOMMIT, stmt: SET autocommit=0 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Session write, routing to all servers. 2022-09-12 10:13:24 info : (4) (server1); Storing COM_QUERY while in state 'Handshaking': SET autocommit=0 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Route query to master: server1 2022-09-12 10:13:24 info : (4) (server2); Storing COM_QUERY while in state 'Handshaking': SET autocommit=0 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Route query to slave: server2 2022-09-12 10:13:24 info : (4) (server3); Storing COM_QUERY while in state 'Handshaking': SET autocommit=0 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Route query to slave: server3 2022-09-12 10:13:24 info : (4) (server4); Storing COM_QUERY while in state 'Handshaking': SET autocommit=0 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Route query to slave: server4 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Will return response from 'server1' to the client 2022-09-12 10:13:24 info : (4) Connected to 'server3' with thread id 1499 2022-09-12 10:13:24 info : (4) Connected to 'server1' with thread id 14936 2022-09-12 10:13:24 info : (4) Connected to 'server2' with thread id 1505 2022-09-12 10:13:24 info : (4) Connected to 'server4' with thread id 1493 2022-09-12 10:13:24 info : (4) Authentication to 'server3' succeeded. 2022-09-12 10:13:24 info : (4) Authentication to 'server1' succeeded. 2022-09-12 10:13:24 info : (4) Authentication to 'server2' succeeded. 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Reply complete from 'server3', discarding it. 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Reply complete from 'server1' (OK: 0 warnings) 2022-09-12 10:13:24 info : (4) [MariaDBProtocol] (RW-Split-Router); Added COM_QUERY to history with ID 1: SET autocommit=0 (result: OK) 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Reply complete from 'server2', discarding it. 2022-09-12 10:13:24 info : (4) Authentication to 'server4' succeeded. 2022-09-12 10:13:24 info : (4) Execute COM_QUERY 1 on 'server4': SET autocommit=0 2022-09-12 10:13:24 info : (4) Reply to 1 complete 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Reply complete from 'server4', discarding it. --- Executing SELECT SLEEP --- 2022-09-12 10:13:24 info : (4) (RW-Split-Router); > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Session write, routing to all servers. 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Route query to master: server1 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Route query to slave: server2 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Route query to slave: server3 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Route query to slave: server4 2022-09-12 10:13:24 info : (4) [readwritesplit] (RW-Split-Router); Will return response from 'server1' to the client --- Blocking all nodes --- 2022-09-12 10:13:28 info : Accept authentication from 'admin', using password. Request: /v1/maxscale/debug/monitor_wait 2022-09-12 10:13:30 error : Monitor was unable to connect to server server3[10.128.0.12:3306] : 'Can't connect to server on '10.128.0.12' (115)' 2022-09-12 10:13:30 error : Monitor was unable to connect to server server1[10.128.0.54:3306] : 'Can't connect to server on '10.128.0.54' (115)' 2022-09-12 10:13:30 error : Monitor was unable to connect to server server2[10.128.0.49:3306] : 'Can't connect to server on '10.128.0.49' (115)' 2022-09-12 10:13:30 notice : Server changed state: server1[10.128.0.54:3306]: master_down. [Master, Running] -> [Down] 2022-09-12 10:13:30 notice : Server changed state: server2[10.128.0.49:3306]: slave_down. [Slave, Running] -> [Down] 2022-09-12 10:13:30 notice : Server changed state: server3[10.128.0.12:3306]: slave_down. [Slave, Running] -> [Down] 2022-09-12 10:13:30 info : (4) [readwritesplit] (RW-Split-Router); Master 'server1' failed: #HY000: Lost connection to backend server: connection closed by peer (server1: Generated event) 2022-09-12 10:13:30 info : (4) [readwritesplit] (RW-Split-Router); Starting transaction replay 1. Replay has been ongoing for 0 seconds. 2022-09-12 10:13:30 info : (4) [readwritesplit] (RW-Split-Router); Retrying interrupted query: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:30 info : (4) [readwritesplit] (RW-Split-Router); Slave 'server2' failed: #HY000: Lost connection to backend server: connection closed by peer (server2: Generated event) 2022-09-12 10:13:30 info : (4) [readwritesplit] (RW-Split-Router); Slave 'server3' failed: #HY000: Lost connection to backend server: connection closed by peer (server3: Generated event) 2022-09-12 10:13:30 info : Accept authentication from 'admin', using password. Request: /v1/maxscale/debug/monitor_wait 2022-09-12 10:13:31 info : (4) > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:31 info : (4) [readwritesplit] Session write, routing to all servers. 2022-09-12 10:13:31 info : (4) [readwritesplit] Route query to slave: server4 2022-09-12 10:13:31 info : (4) [readwritesplit] Will return response from 'server4' to the client 2022-09-12 10:13:34 info : (4) [readwritesplit] (RW-Split-Router); Reply complete from 'server4', discarding it. 2022-09-12 10:13:35 error : Monitor was unable to connect to server server4[10.128.0.11:3306] : 'Can't connect to server on '10.128.0.11' (115)' 2022-09-12 10:13:35 notice : Server changed state: server4[10.128.0.11:3306]: slave_down. [Slave, Running] -> [Down] 2022-09-12 10:13:35 info : (4) [readwritesplit] (RW-Split-Router); Slave 'server4' failed: #HY000: Lost connection to backend server: connection closed by peer (server4: Generated event) 2022-09-12 10:13:35 info : (4) [readwritesplit] (RW-Split-Router); Re-routing failed read after server 'server4' failed 2022-09-12 10:13:36 info : (4) > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:36 info : (4) [readwritesplit] Session write, routing to all servers. 2022-09-12 10:13:36 info : (4) [readwritesplit] No connections available for session command 2022-09-12 10:13:36 info : (4) [readwritesplit] Attempting to create a connection 2022-09-12 10:13:36 info : (4) [readwritesplit] Delaying routing: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:37 info : (4) > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:37 info : (4) [readwritesplit] Session write, routing to all servers. 2022-09-12 10:13:37 info : (4) [readwritesplit] No connections available for session command 2022-09-12 10:13:37 info : (4) [readwritesplit] Attempting to create a connection 2022-09-12 10:13:37 info : (4) [readwritesplit] Delaying routing: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:38 info : (4) > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:38 info : (4) [readwritesplit] Session write, routing to all servers. 2022-09-12 10:13:38 info : (4) [readwritesplit] No connections available for session command 2022-09-12 10:13:38 info : (4) [readwritesplit] Attempting to create a connection 2022-09-12 10:13:38 info : (4) [readwritesplit] Delaying routing: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:39 info : (4) > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:39 info : (4) [readwritesplit] Session write, routing to all servers. 2022-09-12 10:13:39 info : (4) [readwritesplit] No connections available for session command 2022-09-12 10:13:39 info : (4) [readwritesplit] Attempting to create a connection 2022-09-12 10:13:39 info : (4) [readwritesplit] Delaying routing: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:40 warning: [mariadbmon] The current master server 'server1' is no longer valid because it has been down over 5 (failcount) monitor updates and it does not have any running slaves, but there is no valid alternative to swap to. 2022-09-12 10:13:40 info : (4) > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:40 info : (4) [readwritesplit] Session write, routing to all servers. 2022-09-12 10:13:40 info : (4) [readwritesplit] No connections available for session command 2022-09-12 10:13:40 info : (4) [readwritesplit] Attempting to create a connection 2022-09-12 10:13:40 info : (4) [readwritesplit] Delaying routing: SET @a=(SELECT SLEEP(10)) --- Unblocking all nodes --- 2022-09-12 10:13:41 info : Accept authentication from 'admin', using password. Request: /v1/maxscale/debug/monitor_wait 2022-09-12 10:13:41 notice : Server changed state: server4[10.128.0.11:3306]: slave_up. [Down] -> [Slave, Running] 2022-09-12 10:13:41 info : Accept authentication from 'admin', using password. Request: /v1/maxscale/debug/monitor_wait 2022-09-12 10:13:41 notice : Server changed state: server1[10.128.0.54:3306]: master_up. [Down] -> [Master, Running] 2022-09-12 10:13:41 notice : Server changed state: server2[10.128.0.49:3306]: slave_up. [Down] -> [Slave, Running] 2022-09-12 10:13:41 notice : Server changed state: server3[10.128.0.12:3306]: slave_up. [Down] -> [Slave, Running] 2022-09-12 10:13:41 info : (4) > Autocommit: [disabled], trx is [open], cmd: (0x03) COM_QUERY, plen: 30, type: QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_USERVAR_WRITE, stmt: SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:41 info : (4) [readwritesplit] Session write, routing to all servers. 2022-09-12 10:13:41 info : (4) [readwritesplit] No connections available for session command 2022-09-12 10:13:41 info : (4) [readwritesplit] Attempting to create a connection 2022-09-12 10:13:41 info : (4) [readwritesplit] Connected to 'server1' 2022-09-12 10:13:41 info : (4) [readwritesplit] Chose 'server1' as master due to session write 2022-09-12 10:13:41 info : (4) (server1); Storing COM_QUERY while in state 'Handshaking': SET @a=(SELECT SLEEP(10)) 2022-09-12 10:13:41 info : (4) [readwritesplit] Route query to master: server1 2022-09-12 10:13:41 info : (4) [readwritesplit] Will return response from 'server1' to the client 2022-09-12 10:13:41 error : (4) [readwritesplit] debug assert at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/routing/readwritesplit/rwsplit_route_stmt.cc:617 failed: Trx target is server4 when m_sescmd_replier is server1 while trx is open (!trx_is_open() || m_trx.target() == m_sescmd_replier) debug assert at /home/timofey_turenko_mariadb_com/MaxScale/server/modules/routing/readwritesplit/rwsplit_route_stmt.cc:617 failed: Trx target is server4 when m_sescmd_replier is server1 while trx is open (!trx_is_open() || m_trx.target() == m_sescmd_replier) alert : MaxScale 22.08.2 received fatal signal 6. Commit ID: 2c23e5b843d03745ac4ce6a282fe0c837a569a53 System name: Linux Release string: Red Hat Enterprise Linux Server release 7.9 (Maipo) 2022-09-12 10:13:41 alert : (4) MaxScale 22.08.2 received fatal signal 6. Commit ID: 2c23e5b843d03745ac4ce6a282fe0c837a569a53 System name: Linux Release string: Red Hat Enterprise Linux Server release 7.9 (Maipo) 2022-09-12 10:13:41 alert : (4) Statement currently being classified: none/unknown 2022-09-12 10:13:41 alert : (4) DCB: 0x7f5038019770 Session: 4 Service: RW-Split-Router 2022-09-12 10:13:41 notice : (4) For a more detailed stacktrace, install GDB and add 'debug=gdb-stacktrace' under the [maxscale] section. /lib64/libpthread.so.0(raise+0x2b): ??:? /usr/lib64/maxscale/libreadwritesplit.so(_ZN14RWSplitSession19route_session_writeEP5GWBUFhj+0xad8): server/modules/routing/readwritesplit/rwsplit_route_stmt.cc:617 (discriminator 18) /usr/lib64/maxscale/libreadwritesplit.so(_ZN14RWSplitSession20handle_target_is_allEON8maxscale6BufferERKNS_11RoutingPlanE+0xb8): server/modules/routing/readwritesplit/rwsplit_route_stmt.cc:157 /usr/lib64/maxscale/libreadwritesplit.so(_ZN14RWSplitSession10route_stmtEON8maxscale6BufferERKNS_11RoutingPlanE+0x220): server/modules/routing/readwritesplit/rwsplit_route_stmt.cc:325 /usr/lib64/maxscale/libreadwritesplit.so(_ZN14RWSplitSession11route_queryEON8maxscale6BufferE+0x1bc): server/modules/routing/readwritesplit/rwsplitsession.cc:132 /usr/lib64/maxscale/libreadwritesplit.so(+0xc552c): server/modules/routing/readwritesplit/rwsplit_route_stmt.cc:76 /usr/lib64/maxscale/libreadwritesplit.so(+0xca257): /opt/rh/devtoolset-9/root/usr/include/c++/9/bits/std_function.h:287 /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZNKSt8functionIFbP5GWBUFEEclES1_+0x49): /opt/rh/devtoolset-9/root/usr/include/c++/9/bits/std_function.h:689 /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x6ca3e3): server/core/session.cc:613 /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x6d06b6): /opt/rh/devtoolset-9/root/usr/include/c++/9/bits/std_function.h:287 /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZNKSt8functionIFbN7maxbase6Worker8Callable6ActionEEEclES3_+0x48): /opt/rh/devtoolset-9/root/usr/include/c++/9/bits/std_function.h:689 /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker22DCallFunctorWithCancel7do_callENS0_8Callable6ActionE+0x24): maxutils/maxbase/include/maxbase/worker.hh:1089 /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker5DCall4callENS0_8Callable6ActionE+0x2b): maxutils/maxbase/include/maxbase/worker.hh:928 /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker4tickEv+0x2cf): maxutils/maxbase/src/worker.cc:1225 /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker15DelegatingTimerIS0_E4tickEv+0x66): maxutils/maxbase/include/maxbase/worker.hh:469 (discriminator 4) /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase11WorkerTimer18handle_poll_eventsEPNS_6WorkerEjNS_8Pollable7ContextE+0x1b1): maxutils/maxbase/src/worker.cc:327 /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker14deliver_eventsEmNSt6chrono10time_pointINS1_3_V212steady_clockENS1_8durationIlSt5ratioILl1ELl1000000000EEEEEEPNS_8PollableEjNSA_7ContextE+0x1b4): maxutils/maxbase/src/worker.cc:1041 /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker15poll_waiteventsEv+0x647): maxutils/maxbase/src/worker.cc:1168 /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker3runEPNS_9SemaphoreE+0x129): maxutils/maxbase/src/worker.cc:820 /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZN7maxbase6Worker11thread_mainEPS0_PNS_9SemaphoreE+0x23): maxutils/maxbase/src/worker.cc:933 /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZSt13__invoke_implIvPFvPN7maxbase6WorkerEPNS0_9SemaphoreEEJS2_S4_EET_St14__invoke_otherOT0_DpOT1_+0x4d): /opt/rh/devtoolset-9/root/usr/include/c++/9/bits/invoke.h:60 /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZSt8__invokeIPFvPN7maxbase6WorkerEPNS0_9SemaphoreEEJS2_S4_EENSt15__invoke_resultIT_JDpT0_EE4typeEOS8_DpOS9_+0x4f): /opt/rh/devtoolset-9/root/usr/include/c++/9/bits/invoke.h:96 /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZNSt6thread8_InvokerISt5tupleIJPFvPN7maxbase6WorkerEPNS2_9SemaphoreEES4_S6_EEE9_M_invokeIJLm0ELm1ELm2EEEEvSt12_Index_tupleIJXspT_EEE+0x5f): /opt/rh/devtoolset-9/root/usr/include/c++/9/thread:244 /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZNSt6thread8_InvokerISt5tupleIJPFvPN7maxbase6WorkerEPNS2_9SemaphoreEES4_S6_EEEclEv+0x18): /opt/rh/devtoolset-9/root/usr/include/c++/9/thread:252 /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(_ZNSt6thread11_State_implINS_8_InvokerISt5tupleIJPFvPN7maxbase6WorkerEPNS3_9SemaphoreEES5_S7_EEEEE6_M_runEv+0x1c): /opt/rh/devtoolset-9/root/usr/include/c++/9/thread:195 /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(+0x85d6f0): thread48.o:? /lib64/libpthread.so.0(+0x7ea5): pthread_create.c:? /lib64/libc.so.6(clone+0x6d): ??:? alert : Writing core dump. --- Executing SELECT 1 ---