MariaDB MaxScale /var/log/maxscale/maxscale.log Tue Jul 9 16:17:43 2019 ---------------------------------------------------------------------------- 2019-07-09 16:17:43 notice : syslog logging is enabled. 2019-07-09 16:17:43 notice : maxlog logging is enabled. 2019-07-09 16:17:43 notice : The logging of informational messages has been enabled. 2019-07-09 16:17:43 notice : Using up to 1.17GiB of memory for query classifier cache 2019-07-09 16:17:43 notice : Working directory: /var/log/maxscale 2019-07-09 16:17:43 notice : The collection of SQLite memory allocation statistics turned off. 2019-07-09 16:17:43 notice : Threading mode of SQLite set to Multi-thread. 2019-07-09 16:17:43 notice : MariaDB MaxScale 2.3.9 started (Commit: 66d6ce6fa598a43b20af052ef6c9f637a3279fa1) 2019-07-09 16:17:43 notice : MaxScale is running in process 619 2019-07-09 16:17:43 notice : Configuration file: /etc/maxscale.cnf 2019-07-09 16:17:43 notice : Log directory: /var/log/maxscale 2019-07-09 16:17:43 notice : Data directory: /var/lib/maxscale 2019-07-09 16:17:43 notice : Module directory: /usr/lib/x86_64-linux-gnu/maxscale 2019-07-09 16:17:43 notice : Service cache: /var/cache/maxscale 2019-07-09 16:17:43 notice : No query classifier specified, using default 'qc_sqlite'. 2019-07-09 16:17:43 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libqc_sqlite.so 2019-07-09 16:17:43 info : qc_sqlite loaded. 2019-07-09 16:17:43 notice : Query classification results are cached and reused. Memory used per thread: 149.76MiB 2019-07-09 16:17:43 info : Epoll instance for listening sockets added to worker epoll instance. 2019-07-09 16:17:43 info : Epoll instance for listening sockets added to worker epoll instance. 2019-07-09 16:17:43 info : Epoll instance for listening sockets added to worker epoll instance. 2019-07-09 16:17:43 info : Epoll instance for listening sockets added to worker epoll instance. 2019-07-09 16:17:43 info : Epoll instance for listening sockets added to worker epoll instance. 2019-07-09 16:17:43 info : Epoll instance for listening sockets added to worker epoll instance. 2019-07-09 16:17:43 info : Epoll instance for listening sockets added to worker epoll instance. 2019-07-09 16:17:43 info : Epoll instance for listening sockets added to worker epoll instance. 2019-07-09 16:17:43 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2019-07-09 16:17:43 notice : Loading /etc/maxscale.cnf. 2019-07-09 16:17:43 notice : /etc/maxscale.cnf.d does not exist, not reading. 2019-07-09 16:17:43 notice : Runtime configuration changes have been done to MaxScale. Loading persisted configuration files and applying them on top of the main configuration file. These changes can override the values of the main configuration file: To revert them, remove all the files in '/var/lib/maxscale/maxscale.cnf.d'. ... 2019-07-09 16:17:43 notice : Loading /var/lib/maxscale/maxscale.cnf.d/global-options.cnf. 2019-07-09 16:17:43 info : Initialise MaxScaled Protocol module. 2019-07-09 16:17:43 notice : Loaded module maxscaled: V2.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmaxscaled.so 2019-07-09 16:17:43 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbclient.so 2019-07-09 16:17:43 warning: THE 'cli' MODULE AND 'maxadmin' ARE DEPRECATED: Use 'maxctrl' instead 2019-07-09 16:17:43 notice : Loaded module cli: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libcli.so 2019-07-09 16:17:43 notice : Initializing statement-based read/write split router module. 2019-07-09 16:17:43 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libreadwritesplit.so 2019-07-09 16:17:43 notice : Initialise the MySQL Galera Monitor module. 2019-07-09 16:17:43 notice : Loaded module galeramon: V2.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libgaleramon.so 2019-07-09 16:17:43 notice : Loaded module MariaDBBackend: V2.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbbackend.so 2019-07-09 16:17:43 notice : Loaded module MySQLBackendAuth: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmysqlbackendauth.so 2019-07-09 16:17:43 notice : Loaded module MaxAdminAuth: V2.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmaxadminauth.so 2019-07-09 16:17:43 notice : Loaded module MySQLAuth: V1.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmysqlauth.so 2019-07-09 16:17:43 info : In-memory sqlite database successfully opened for thread 139659272853248. 2019-07-09 16:17:43 notice : Housekeeper thread started. 2019-07-09 16:17:43 notice : Encrypted password file /var/lib/maxscale/.secrets can't be accessed (No such file or directory). Password encryption is not used. 2019-07-09 16:17:43 notice : Loaded server states from journal file: /var/lib/maxscale/Galera-Monitor/monitor.dat 2019-07-09 16:17:43 notice : Starting a total of 2 services... 2019-07-09 16:17:43 notice : Listening for connections at [/var/run/maxscale/maxadmin.sock]:0 with protocol MaxScale Admin 2019-07-09 16:17:43 info : Started session [1] for MaxAdmin-Service service 2019-07-09 16:17:43 notice : Service 'MaxAdmin-Service' started (1/2) ... 2019-07-09 16:17:43 notice : [Read-Write-Service] Loaded 310 MySQL users for listener Read-Write-Listener. 2019-07-09 16:17:43 notice : Listening for connections at [::]:3306 with protocol MySQL 2019-07-09 16:17:43 info : Started session [2] for Read-Write-Service service 2019-07-09 16:17:43 notice : Service 'Read-Write-Service' started (2/2) 2019-07-09 16:17:43 info : In-memory sqlite database successfully opened for thread 139659183126272. ... 2019-07-09 16:17:43 info : In-memory sqlite database successfully opened for thread 139659174733568. ... 2019-07-09 16:17:43 info : In-memory sqlite database successfully opened for thread 139659166340864. ... 2019-07-09 16:17:43 info : In-memory sqlite database successfully opened for thread 139659157948160. ... 2019-07-09 16:17:43 info : In-memory sqlite database successfully opened for thread 139659149555456. ... 2019-07-09 16:17:43 info : In-memory sqlite database successfully opened for thread 139659141162752. ... 2019-07-09 16:17:43 info : In-memory sqlite database successfully opened for thread 139659132770048. ... 2019-07-09 16:17:44 notice : Started REST API on [127.0.0.1]:8989 2019-07-09 16:17:44 notice : MaxScale started with 8 worker threads, each with a stack size of 8388608 bytes. 2019-07-09 16:17:44 info : In-memory sqlite database successfully opened for thread 139659447853184. ... 2019-07-09 16:17:44 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:17:44 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:17:45 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:17:46 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:17:47 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:17:47 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:17:47 info : Accept authentication from 'admin', using password. Request: /v1/monitors/Galera-Monitor 2019-07-09 16:17:48 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:17:48 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:17:50 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:17:51 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:17:52 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:17:52 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:17:53 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:17:54 info : Accept authentication from 'admin', using password. Request: /v1/monitors 2019-07-09 16:17:55 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:17:55 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:17:55 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:17:56 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:17:56 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:17:57 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:17:58 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:17:58 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:17:58 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:17:59 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:17:59 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:00 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:01 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:02 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:02 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:03 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:03 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:03 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:03 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:03 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:04 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:05 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:05 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:05 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:05 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:06 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:07 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:07 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:08 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:08 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:08 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:08 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:09 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:10 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:10 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:11 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:11 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:13 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:13 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:13 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:13 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:14 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:14 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:15 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:17 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:17 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:18 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:18 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:19 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:20 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:21 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:22 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:23 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:23 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:23 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:23 info : Accept authentication from 'admin', using password. Request: /v1/monitors 2019-07-09 16:18:25 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:25 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:25 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:26 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:27 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:27 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:28 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:28 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:28 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:29 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:30 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:31 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:31 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:32 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:32 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:32 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:32 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:33 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:34 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:35 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:35 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:35 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:36 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:37 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:38 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:38 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:38 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:38 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:39 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:39 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:40 info : Servers and router connection counts: ... 2019-07-09 16:18:40 info : Started Read-Write-Service client session [3] for 'user' from ::ffff:172.16.1.1 2019-07-09 16:18:40 info : (3) Sending proxy-protocol header 'PROXY TCP6 ::ffff:172.16.1.1 ::ffff:192.168.1.254 44885 3306 ' to backend back1. 2019-07-09 16:18:40 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 35, type: QUERY_TYPE_GSYSVAR_WRITE, stmt: SET SESSION SQL_AUTO_IS_NULL=0 2019-07-09 16:18:40 info : (3) Session write, routing to all servers. 2019-07-09 16:18:40 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:18:40 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:18:40 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:18:40 info : (3) Sending proxy-protocol header 'PROXY TCP6 ::ffff:172.16.1.1 ::ffff:192.168.1.254 44885 3306 ' to backend back3. 2019-07-09 16:18:40 info : (3) Sending proxy-protocol header 'PROXY TCP6 ::ffff:172.16.1.1 ::ffff:192.168.1.254 44885 3306 ' to backend back2. 2019-07-09 16:18:40 info : (3) Connected to 'back1' with thread id 430671 2019-07-09 16:18:40 info : (3) Connected to 'back3' with thread id 444406 2019-07-09 16:18:40 info : (3) Connected to 'back2' with thread id 444924 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back1 2019-07-09 16:18:40 info : (3) Storing query (len: 21 cmd: 3), expecting 2 replies to current command 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back3 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back2 2019-07-09 16:18:40 info : (3) >>> Routing stored queries 2019-07-09 16:18:40 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 21, type: QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_ENABLE_AUTOCOMMIT|QUERY_TYPE_COMMIT, stmt: SET autocommit=1 2019-07-09 16:18:40 info : (3) Session write, routing to all servers. 2019-07-09 16:18:40 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:18:40 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:18:40 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:18:40 info : (3) <<< Stored queries routed 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back1 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back2 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back3 2019-07-09 16:18:40 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 21, type: QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_ENABLE_AUTOCOMMIT|QUERY_TYPE_COMMIT, stmt: SET autocommit=1 2019-07-09 16:18:40 info : (3) Session write, routing to all servers. 2019-07-09 16:18:40 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:18:40 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:18:40 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back1 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back3 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back2 2019-07-09 16:18:40 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 59, type: QUERY_TYPE_GSYSVAR_WRITE, stmt: SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 2019-07-09 16:18:40 info : (3) Session write, routing to all servers. 2019-07-09 16:18:40 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:18:40 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:18:40 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back1 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back3 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back2 2019-07-09 16:18:40 info : Servers and router connection counts: 2019-07-09 16:18:40 info : current operations : 0 in [10.10.10.1]:3306 RUNNING MASTER 2019-07-09 16:18:40 info : current operations : 0 in [10.10.10.2]:3306 RUNNING SLAVE 2019-07-09 16:18:40 info : current operations : 0 in [10.10.10.3]:3306 RUNNING SLAVE 2019-07-09 16:18:40 info : Selected Master: back1 2019-07-09 16:18:40 info : Selected Slave: back2 2019-07-09 16:18:40 info : Selected Slave: back3 2019-07-09 16:18:40 info : Started Read-Write-Service client session [4] for 'cdr' from ::ffff:172.16.1.1 2019-07-09 16:18:40 info : (4) Sending proxy-protocol header 'PROXY TCP6 ::ffff:172.16.1.1 ::ffff:192.168.1.254 44886 3306 ' to backend back1. 2019-07-09 16:18:40 info : (4) Connected to 'back1' with thread id 430672 2019-07-09 16:18:40 info : (4) Sending proxy-protocol header 'PROXY TCP6 ::ffff:172.16.1.1 ::ffff:192.168.1.254 44886 3306 ' to backend back3. 2019-07-09 16:18:40 info : (4) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 35, type: QUERY_TYPE_GSYSVAR_WRITE, stmt: SET SESSION SQL_AUTO_IS_NULL=0 2019-07-09 16:18:40 info : (4) Session write, routing to all servers. 2019-07-09 16:18:40 info : (4) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:18:40 info : (4) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:18:40 info : (4) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:18:40 info : (4) Sending proxy-protocol header 'PROXY TCP6 ::ffff:172.16.1.1 ::ffff:192.168.1.254 44886 3306 ' to backend back2. 2019-07-09 16:18:40 info : (4) Reply complete, last reply from back1 2019-07-09 16:18:40 info : (4) Connected to 'back3' with thread id 444407 2019-07-09 16:18:40 info : (4) Connected to 'back2' with thread id 444925 2019-07-09 16:18:40 info : (4) Storing query (len: 21 cmd: 3), expecting 2 replies to current command 2019-07-09 16:18:40 info : (4) Reply complete, last reply from back3 2019-07-09 16:18:40 info : (4) Reply complete, last reply from back2 2019-07-09 16:18:40 info : (4) >>> Routing stored queries 2019-07-09 16:18:40 info : (4) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 21, type: QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_ENABLE_AUTOCOMMIT|QUERY_TYPE_COMMIT, stmt: SET autocommit=1 2019-07-09 16:18:40 info : (4) Session write, routing to all servers. 2019-07-09 16:18:40 info : (4) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:18:40 info : (4) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:18:40 info : (4) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:18:40 info : (4) <<< Stored queries routed 2019-07-09 16:18:40 info : (4) Reply complete, last reply from back1 2019-07-09 16:18:40 info : (4) Reply complete, last reply from back3 2019-07-09 16:18:40 info : (4) Reply complete, last reply from back2 2019-07-09 16:18:40 info : (4) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 21, type: QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_ENABLE_AUTOCOMMIT|QUERY_TYPE_COMMIT, stmt: SET autocommit=1 2019-07-09 16:18:40 info : (4) Session write, routing to all servers. 2019-07-09 16:18:40 info : (4) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:18:40 info : (4) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:18:40 info : (4) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:18:40 info : (4) Reply complete, last reply from back1 2019-07-09 16:18:40 info : (4) Reply complete, last reply from back2 2019-07-09 16:18:40 info : (4) Storing query (len: 59 cmd: 3), expecting 1 replies to current command 2019-07-09 16:18:40 info : (4) Reply complete, last reply from back3 2019-07-09 16:18:40 info : (4) >>> Routing stored queries 2019-07-09 16:18:40 info : (4) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 59, type: QUERY_TYPE_GSYSVAR_WRITE, stmt: SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 2019-07-09 16:18:40 info : (4) Session write, routing to all servers. 2019-07-09 16:18:40 info : (4) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:18:40 info : (4) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:18:40 info : (4) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:18:40 info : (4) <<< Stored queries routed 2019-07-09 16:18:40 info : (4) Reply complete, last reply from back1 2019-07-09 16:18:40 info : (4) Reply complete, last reply from back3 2019-07-09 16:18:40 info : (4) Reply complete, last reply from back2 2019-07-09 16:18:40 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:40 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 21, type: QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_ENABLE_AUTOCOMMIT|QUERY_TYPE_COMMIT, stmt: SET autocommit=1 2019-07-09 16:18:40 info : (3) Session write, routing to all servers. 2019-07-09 16:18:40 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:18:40 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:18:40 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back1 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back2 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back3 2019-07-09 16:18:40 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 59, type: QUERY_TYPE_GSYSVAR_WRITE, stmt: SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 2019-07-09 16:18:40 info : (3) Session write, routing to all servers. 2019-07-09 16:18:40 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:18:40 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:18:40 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back1 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back2 2019-07-09 16:18:40 info : (3) Storing query (len: 95 cmd: 16), expecting 1 replies to current command 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back3 2019-07-09 16:18:40 info : (3) >>> Routing stored queries 2019-07-09 16:18:40 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 95, type: QUERY_TYPE_READ|QUERY_TYPE_PREPARE_STMT, stmt: SELECT * FROM sip_buddies_mgw WHERE name LIKE ? AND callbackextension LIKE ? ORDER BY name 2019-07-09 16:18:40 info : (3) Session write, routing to all servers. 2019-07-09 16:18:40 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:18:40 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:18:40 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:18:40 info : (3) <<< Stored queries routed 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back1 2019-07-09 16:18:40 info : (3) PS response for back1: 7 -> 1 2019-07-09 16:18:40 info : (3) PS ID 1 maps to internal ID 7 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back2 2019-07-09 16:18:40 info : (3) PS response for back2: 7 -> 1 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back3 2019-07-09 16:18:40 info : (3) PS response for back3: 7 -> 1 2019-07-09 16:18:40 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x17) COM_STMT_EXECUTE, plen: 24, type: QUERY_TYPE_EXEC_STMT, stmt: ID: 1 2019-07-09 16:18:40 info : (3) Route query to master: back1 [10.10.10.1]:3306 < 2019-07-09 16:18:40 info : (3) COM_STMT_EXECUTE on back1: [10.10.10.1]:3306 2019-07-09 16:18:40 info : (3) Reply complete, last reply from back1 2019-07-09 16:18:40 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 1 2019-07-09 16:18:40 info : (3) Session write, routing to all servers. 2019-07-09 16:18:40 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:18:40 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:18:40 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:18:40 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:41 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:41 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:41 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:42 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:43 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:43 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:43 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:44 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:44 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:45 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:47 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:47 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:48 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:48 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:50 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:51 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:52 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:53 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:53 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:54 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:54 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:54 info : Accept authentication from 'admin', using password. Request: /v1/monitors 2019-07-09 16:18:55 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:55 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:56 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:57 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:57 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:57 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:58 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:59 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:18:59 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:18:59 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:01 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:01 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:01 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:01 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:02 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:02 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:03 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:03 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:03 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:04 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:05 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:05 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:06 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:06 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:07 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:07 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:08 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:08 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:08 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:09 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:09 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:10 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:11 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:11 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:11 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:13 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:13 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:13 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:13 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:14 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:15 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:16 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:17 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:18 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:18 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:19 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:19 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:19:20 info : Accept authentication from 'admin', using password. Request: /v1/servers 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 21, type: QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_ENABLE_AUTOCOMMIT|QUERY_TYPE_COMMIT, stmt: SET autocommit=1 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) Storing query (len: 59 cmd: 3), expecting 1 replies to current command 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) >>> Routing stored queries 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 59, type: QUERY_TYPE_GSYSVAR_WRITE, stmt: SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) <<< Stored queries routed 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 62, type: QUERY_TYPE_READ|QUERY_TYPE_PREPARE_STMT, stmt: SELECT * FROM sip_buddies_mgw WHERE name = ? AND host = ? 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) PS response for back1: 11 -> 2 2019-07-09 16:19:21 info : (3) PS ID 2 maps to internal ID 11 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) PS response for back2: 11 -> 2 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) PS response for back3: 11 -> 2 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x17) COM_STMT_EXECUTE, plen: 44, type: QUERY_TYPE_EXEC_STMT, stmt: ID: 2 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 < 2019-07-09 16:19:21 info : (3) COM_STMT_EXECUTE on back1: [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 2 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 21, type: QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_ENABLE_AUTOCOMMIT|QUERY_TYPE_COMMIT, stmt: SET autocommit=1 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 59, type: QUERY_TYPE_GSYSVAR_WRITE, stmt: SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 3719, type: QUERY_TYPE_READ|QUERY_TYPE_USERVAR_WRITE|QUERY_TYPE_USERVAR_READ|QUERY_TYPE_PREPARE_STMT, stmt: SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, CASE DATA_TYPE WHEN 'bit' THEN @dt:= IF(NUMERIC_PRECISION=1,(-7), (-2)) WHEN 'tinyint' THEN @dt:=(-6) WHEN 'smallint' THEN @dt:=5 WHEN 'year' THEN @dt:= 5 WHEN 'mediumint' THEN @dt:=4 WHEN 'int' THEN @dt:=4 WHEN 'bigint' THEN @dt:=(-5) WHEN 'blob' THEN @dt:=(-4) WHEN 'tinyblob' THEN @dt:=(-4) WHEN 'mediumblob' THEN @dt:=(-4) WHEN 'longblob' THEN @dt:=(-4) WHEN 'decimal' THEN @dt:=3 WHEN 'float' THEN @dt:=IF(NUMERIC_SCALE IS NULL,7, 3) WHEN 'double' THEN @dt:=IF(NUMERIC_SCALE IS NULL,8, 3) WHEN 'binary' THEN @dt:=(-2) WHEN 'varbinary' THEN @dt:=(-3) WHEN 'text' THEN @dt:=(-10) WHEN 'tinytext' THEN @dt:=(-10) WHEN 'mediumtext' THEN @dt:=(-10) WHEN 'longtext' THEN @dt:=(-10) WHEN 'char' THEN @dt:=(-8) WHEN 'enum' THEN @dt:=(-8) WHEN 'set' THEN @dt:=(-8) WHEN 'varchar' THEN @dt:=(-9) WHEN 'date' THEN @dt:=91 WHEN 'time' THEN @dt:=92 WHEN 'datetime' THEN @dt:=93 WHEN 'timestamp' THEN 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) PS response for back1: 15 -> 3 2019-07-09 16:19:21 info : (3) PS ID 3 maps to internal ID 15 2019-07-09 16:19:21 info : (3) Storing query (len: 9 cmd: 19), expecting 2 replies to current command 2019-07-09 16:19:21 info : (3) Storing query (len: 3719 cmd: 16), expecting 2 replies to current command 2019-07-09 16:19:21 info : (3) Storing query (len: 14 cmd: 17), expecting 2 replies to current command 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) PS response for back2: 15 -> 3 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) PS response for back3: 15 -> 3 2019-07-09 16:19:21 info : (3) >>> Routing stored queries 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 3 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) <<< Stored queries routed 2019-07-09 16:19:21 info : (3) >>> Routing stored queries 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 3719, type: QUERY_TYPE_READ|QUERY_TYPE_USERVAR_WRITE|QUERY_TYPE_USERVAR_READ|QUERY_TYPE_PREPARE_STMT, stmt: SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, CASE DATA_TYPE WHEN 'bit' THEN @dt:= IF(NUMERIC_PRECISION=1,(-7), (-2)) WHEN 'tinyint' THEN @dt:=(-6) WHEN 'smallint' THEN @dt:=5 WHEN 'year' THEN @dt:= 5 WHEN 'mediumint' THEN @dt:=4 WHEN 'int' THEN @dt:=4 WHEN 'bigint' THEN @dt:=(-5) WHEN 'blob' THEN @dt:=(-4) WHEN 'tinyblob' THEN @dt:=(-4) WHEN 'mediumblob' THEN @dt:=(-4) WHEN 'longblob' THEN @dt:=(-4) WHEN 'decimal' THEN @dt:=3 WHEN 'float' THEN @dt:=IF(NUMERIC_SCALE IS NULL,7, 3) WHEN 'double' THEN @dt:=IF(NUMERIC_SCALE IS NULL,8, 3) WHEN 'binary' THEN @dt:=(-2) WHEN 'varbinary' THEN @dt:=(-3) WHEN 'text' THEN @dt:=(-10) WHEN 'tinytext' THEN @dt:=(-10) WHEN 'mediumtext' THEN @dt:=(-10) WHEN 'longtext' THEN @dt:=(-10) WHEN 'char' THEN @dt:=(-8) WHEN 'enum' THEN @dt:=(-8) WHEN 'set' THEN @dt:=(-8) WHEN 'varchar' THEN @dt:=(-9) WHEN 'date' THEN @dt:=91 WHEN 'time' THEN @dt:=92 WHEN 'datetime' THEN @dt:=93 WHEN 'timestamp' THEN 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) <<< Stored queries routed 2019-07-09 16:19:21 info : (3) >>> Routing stored queries 2019-07-09 16:19:21 info : (3) Storing query (len: 14 cmd: 17), expecting 3 replies to current command 2019-07-09 16:19:21 info : (3) <<< Stored queries routed 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) PS response for back2: 17 -> 4 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) PS response for back1: 17 -> 4 2019-07-09 16:19:21 info : (3) PS ID 4 maps to internal ID 17 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) PS response for back3: 17 -> 4 2019-07-09 16:19:21 info : (3) >>> Routing stored queries 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x17) COM_STMT_EXECUTE, plen: 14, type: QUERY_TYPE_EXEC_STMT, stmt: ID: 4294967295 2019-07-09 16:19:21 warning: (3) Client requests unknown prepared statement ID '4294967295' that does not map to an internal ID 2019-07-09 16:19:21 warning: (3) Using unknown prepared statement with ID 0 2019-07-09 16:19:21 error : (3) Could not find valid server for target type TARGET_MASTER, closing connection. 2019-07-09 16:19:21 info : (3) <<< Stored queries routed 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 4 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 13, type: QUERY_TYPE_READ|QUERY_TYPE_PREPARE_STMT, stmt: select 1 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) PS response for back1: 19 -> 5 2019-07-09 16:19:21 info : (3) PS ID 5 maps to internal ID 19 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) PS response for back2: 19 -> 5 2019-07-09 16:19:21 info : (3) Storing query (len: 14 cmd: 17), expecting 1 replies to current command 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) PS response for back3: 19 -> 5 2019-07-09 16:19:21 info : (3) >>> Routing stored queries 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x17) COM_STMT_EXECUTE, plen: 14, type: QUERY_TYPE_EXEC_STMT, stmt: ID: 5 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 < 2019-07-09 16:19:21 info : (3) COM_STMT_EXECUTE on back1: [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) <<< Stored queries routed 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 5 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 3719, type: QUERY_TYPE_READ|QUERY_TYPE_USERVAR_WRITE|QUERY_TYPE_USERVAR_READ|QUERY_TYPE_PREPARE_STMT, stmt: SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, CASE DATA_TYPE WHEN 'bit' THEN @dt:= IF(NUMERIC_PRECISION=1,(-7), (-2)) WHEN 'tinyint' THEN @dt:=(-6) WHEN 'smallint' THEN @dt:=5 WHEN 'year' THEN @dt:= 5 WHEN 'mediumint' THEN @dt:=4 WHEN 'int' THEN @dt:=4 WHEN 'bigint' THEN @dt:=(-5) WHEN 'blob' THEN @dt:=(-4) WHEN 'tinyblob' THEN @dt:=(-4) WHEN 'mediumblob' THEN @dt:=(-4) WHEN 'longblob' THEN @dt:=(-4) WHEN 'decimal' THEN @dt:=3 WHEN 'float' THEN @dt:=IF(NUMERIC_SCALE IS NULL,7, 3) WHEN 'double' THEN @dt:=IF(NUMERIC_SCALE IS NULL,8, 3) WHEN 'binary' THEN @dt:=(-2) WHEN 'varbinary' THEN @dt:=(-3) WHEN 'text' THEN @dt:=(-10) WHEN 'tinytext' THEN @dt:=(-10) WHEN 'mediumtext' THEN @dt:=(-10) WHEN 'longtext' THEN @dt:=(-10) WHEN 'char' THEN @dt:=(-8) WHEN 'enum' THEN @dt:=(-8) WHEN 'set' THEN @dt:=(-8) WHEN 'varchar' THEN @dt:=(-9) WHEN 'date' THEN @dt:=91 WHEN 'time' THEN @dt:=92 WHEN 'datetime' THEN @dt:=93 WHEN 'timestamp' THEN 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) PS response for back3: 21 -> 6 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) PS response for back2: 21 -> 6 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) PS response for back1: 21 -> 6 2019-07-09 16:19:21 info : (3) PS ID 6 maps to internal ID 21 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 6 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 3719, type: QUERY_TYPE_READ|QUERY_TYPE_USERVAR_WRITE|QUERY_TYPE_USERVAR_READ|QUERY_TYPE_PREPARE_STMT, stmt: SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, CASE DATA_TYPE WHEN 'bit' THEN @dt:= IF(NUMERIC_PRECISION=1,(-7), (-2)) WHEN 'tinyint' THEN @dt:=(-6) WHEN 'smallint' THEN @dt:=5 WHEN 'year' THEN @dt:= 5 WHEN 'mediumint' THEN @dt:=4 WHEN 'int' THEN @dt:=4 WHEN 'bigint' THEN @dt:=(-5) WHEN 'blob' THEN @dt:=(-4) WHEN 'tinyblob' THEN @dt:=(-4) WHEN 'mediumblob' THEN @dt:=(-4) WHEN 'longblob' THEN @dt:=(-4) WHEN 'decimal' THEN @dt:=3 WHEN 'float' THEN @dt:=IF(NUMERIC_SCALE IS NULL,7, 3) WHEN 'double' THEN @dt:=IF(NUMERIC_SCALE IS NULL,8, 3) WHEN 'binary' THEN @dt:=(-2) WHEN 'varbinary' THEN @dt:=(-3) WHEN 'text' THEN @dt:=(-10) WHEN 'tinytext' THEN @dt:=(-10) WHEN 'mediumtext' THEN @dt:=(-10) WHEN 'longtext' THEN @dt:=(-10) WHEN 'char' THEN @dt:=(-8) WHEN 'enum' THEN @dt:=(-8) WHEN 'set' THEN @dt:=(-8) WHEN 'varchar' THEN @dt:=(-9) WHEN 'date' THEN @dt:=91 WHEN 'time' THEN @dt:=92 WHEN 'datetime' THEN @dt:=93 WHEN 'timestamp' THEN 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Storing query (len: 14 cmd: 17), expecting 3 replies to current command 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) PS response for back3: 23 -> 7 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) PS response for back2: 23 -> 7 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) PS response for back1: 23 -> 7 2019-07-09 16:19:21 info : (3) PS ID 7 maps to internal ID 23 2019-07-09 16:19:21 info : (3) >>> Routing stored queries 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x17) COM_STMT_EXECUTE, plen: 14, type: QUERY_TYPE_EXEC_STMT, stmt: ID: 4294967295 2019-07-09 16:19:21 warning: (3) Client requests unknown prepared statement ID '4294967295' that does not map to an internal ID 2019-07-09 16:19:21 warning: (3) Using unknown prepared statement with ID 0 2019-07-09 16:19:21 error : (3) Could not find valid server for target type TARGET_MASTER, closing connection. 2019-07-09 16:19:21 info : (3) <<< Stored queries routed 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 21, type: QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_ENABLE_AUTOCOMMIT|QUERY_TYPE_COMMIT, stmt: SET autocommit=1 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Storing query (len: 59 cmd: 3), expecting 3 replies to current command 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) >>> Routing stored queries 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 59, type: QUERY_TYPE_GSYSVAR_WRITE, stmt: SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) <<< Stored queries routed 2019-07-09 16:19:21 info : (3) Storing query (len: 45 cmd: 16), expecting 3 replies to current command 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) >>> Routing stored queries 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 45, type: QUERY_TYPE_WRITE|QUERY_TYPE_PREPARE_STMT, stmt: UPDATE sip_buddies_mgw SET WHERE name=? 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) <<< Stored queries routed 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) Session command no. 26 failed: #42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE name=?' at line 1 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) Storing query (len: 9 cmd: 19), expecting 1 replies to current command 2019-07-09 16:19:21 info : (3) Storing query (len: 9 cmd: 19), expecting 1 replies to current command 2019-07-09 16:19:21 info : (3) Storing query (len: 13 cmd: 16), expecting 1 replies to current command 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) >>> Routing stored queries 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 131072 2019-07-09 16:19:21 warning: (3) Client requests unknown prepared statement ID '131072' that does not map to an internal ID 2019-07-09 16:19:21 warning: (3) Using unknown prepared statement with ID 0 2019-07-09 16:19:21 warning: (3) Client requests unknown prepared statement ID '131072' that does not map to an internal ID 2019-07-09 16:19:21 warning: (3) Closing unknown prepared statement with ID 0 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) <<< Stored queries routed 2019-07-09 16:19:21 info : (3) >>> Routing stored queries 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 0 2019-07-09 16:19:21 warning: (3) Client requests unknown prepared statement ID '0' that does not map to an internal ID 2019-07-09 16:19:21 warning: (3) Using unknown prepared statement with ID 0 2019-07-09 16:19:21 warning: (3) Client requests unknown prepared statement ID '0' that does not map to an internal ID 2019-07-09 16:19:21 warning: (3) Closing unknown prepared statement with ID 0 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) <<< Stored queries routed 2019-07-09 16:19:21 info : (3) >>> Routing stored queries 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 13, type: QUERY_TYPE_READ|QUERY_TYPE_PREPARE_STMT, stmt: select 1 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) <<< Stored queries routed 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) PS response for back1: 29 -> 9 2019-07-09 16:19:21 info : (3) PS ID 9 maps to internal ID 29 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) PS response for back3: 29 -> 9 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) PS response for back2: 29 -> 9 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x17) COM_STMT_EXECUTE, plen: 14, type: QUERY_TYPE_EXEC_STMT, stmt: ID: 9 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 < 2019-07-09 16:19:21 info : (3) COM_STMT_EXECUTE on back1: [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 9 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 45, type: QUERY_TYPE_WRITE|QUERY_TYPE_PREPARE_STMT, stmt: UPDATE sip_buddies_mgw SET WHERE name=? 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) Session command no. 31 failed: #42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE name=?' at line 1 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 0 2019-07-09 16:19:21 warning: (3) Client requests unknown prepared statement ID '0' that does not map to an internal ID 2019-07-09 16:19:21 warning: (3) Using unknown prepared statement with ID 0 2019-07-09 16:19:21 warning: (3) Client requests unknown prepared statement ID '0' that does not map to an internal ID 2019-07-09 16:19:21 warning: (3) Closing unknown prepared statement with ID 0 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 0 2019-07-09 16:19:21 warning: (3) Client requests unknown prepared statement ID '0' that does not map to an internal ID 2019-07-09 16:19:21 warning: (3) Using unknown prepared statement with ID 0 2019-07-09 16:19:21 warning: (3) Client requests unknown prepared statement ID '0' that does not map to an internal ID (subsequent similar messages suppressed for 10000 milliseconds) 2019-07-09 16:19:21 warning: (3) Closing unknown prepared statement with ID 0 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 21, type: QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_ENABLE_AUTOCOMMIT|QUERY_TYPE_COMMIT, stmt: SET autocommit=1 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 59, type: QUERY_TYPE_GSYSVAR_WRITE, stmt: SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 3719, type: QUERY_TYPE_READ|QUERY_TYPE_USERVAR_WRITE|QUERY_TYPE_USERVAR_READ|QUERY_TYPE_PREPARE_STMT, stmt: SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, CASE DATA_TYPE WHEN 'bit' THEN @dt:= IF(NUMERIC_PRECISION=1,(-7), (-2)) WHEN 'tinyint' THEN @dt:=(-6) WHEN 'smallint' THEN @dt:=5 WHEN 'year' THEN @dt:= 5 WHEN 'mediumint' THEN @dt:=4 WHEN 'int' THEN @dt:=4 WHEN 'bigint' THEN @dt:=(-5) WHEN 'blob' THEN @dt:=(-4) WHEN 'tinyblob' THEN @dt:=(-4) WHEN 'mediumblob' THEN @dt:=(-4) WHEN 'longblob' THEN @dt:=(-4) WHEN 'decimal' THEN @dt:=3 WHEN 'float' THEN @dt:=IF(NUMERIC_SCALE IS NULL,7, 3) WHEN 'double' THEN @dt:=IF(NUMERIC_SCALE IS NULL,8, 3) WHEN 'binary' THEN @dt:=(-2) WHEN 'varbinary' THEN @dt:=(-3) WHEN 'text' THEN @dt:=(-10) WHEN 'tinytext' THEN @dt:=(-10) WHEN 'mediumtext' THEN @dt:=(-10) WHEN 'longtext' THEN @dt:=(-10) WHEN 'char' THEN @dt:=(-8) WHEN 'enum' THEN @dt:=(-8) WHEN 'set' THEN @dt:=(-8) WHEN 'varchar' THEN @dt:=(-9) WHEN 'date' THEN @dt:=91 WHEN 'time' THEN @dt:=92 WHEN 'datetime' THEN @dt:=93 WHEN 'timestamp' THEN 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) PS response for back3: 36 -> 11 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) PS response for back2: 36 -> 11 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) PS response for back1: 36 -> 11 2019-07-09 16:19:21 info : (3) PS ID 11 maps to internal ID 36 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 11 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 3719, type: QUERY_TYPE_READ|QUERY_TYPE_USERVAR_WRITE|QUERY_TYPE_USERVAR_READ|QUERY_TYPE_PREPARE_STMT, stmt: SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, CASE DATA_TYPE WHEN 'bit' THEN @dt:= IF(NUMERIC_PRECISION=1,(-7), (-2)) WHEN 'tinyint' THEN @dt:=(-6) WHEN 'smallint' THEN @dt:=5 WHEN 'year' THEN @dt:= 5 WHEN 'mediumint' THEN @dt:=4 WHEN 'int' THEN @dt:=4 WHEN 'bigint' THEN @dt:=(-5) WHEN 'blob' THEN @dt:=(-4) WHEN 'tinyblob' THEN @dt:=(-4) WHEN 'mediumblob' THEN @dt:=(-4) WHEN 'longblob' THEN @dt:=(-4) WHEN 'decimal' THEN @dt:=3 WHEN 'float' THEN @dt:=IF(NUMERIC_SCALE IS NULL,7, 3) WHEN 'double' THEN @dt:=IF(NUMERIC_SCALE IS NULL,8, 3) WHEN 'binary' THEN @dt:=(-2) WHEN 'varbinary' THEN @dt:=(-3) WHEN 'text' THEN @dt:=(-10) WHEN 'tinytext' THEN @dt:=(-10) WHEN 'mediumtext' THEN @dt:=(-10) WHEN 'longtext' THEN @dt:=(-10) WHEN 'char' THEN @dt:=(-8) WHEN 'enum' THEN @dt:=(-8) WHEN 'set' THEN @dt:=(-8) WHEN 'varchar' THEN @dt:=(-9) WHEN 'date' THEN @dt:=91 WHEN 'time' THEN @dt:=92 WHEN 'datetime' THEN @dt:=93 WHEN 'timestamp' THEN 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Storing query (len: 14 cmd: 17), expecting 3 replies to current command 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) PS response for back2: 38 -> 12 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) PS response for back1: 38 -> 12 2019-07-09 16:19:21 info : (3) PS ID 12 maps to internal ID 38 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) PS response for back3: 38 -> 12 2019-07-09 16:19:21 info : (3) >>> Routing stored queries 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x17) COM_STMT_EXECUTE, plen: 14, type: QUERY_TYPE_EXEC_STMT, stmt: ID: 4294967295 2019-07-09 16:19:21 warning: (3) Using unknown prepared statement with ID 0 2019-07-09 16:19:21 error : (3) Could not find valid server for target type TARGET_MASTER, closing connection. 2019-07-09 16:19:21 info : (3) <<< Stored queries routed 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 12 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 13, type: QUERY_TYPE_READ|QUERY_TYPE_PREPARE_STMT, stmt: select 1 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) PS response for back1: 40 -> 13 2019-07-09 16:19:21 info : (3) PS ID 13 maps to internal ID 40 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) PS response for back2: 40 -> 13 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) PS response for back3: 40 -> 13 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x17) COM_STMT_EXECUTE, plen: 14, type: QUERY_TYPE_EXEC_STMT, stmt: ID: 13 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 < 2019-07-09 16:19:21 info : (3) COM_STMT_EXECUTE on back1: [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 13 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 3719, type: QUERY_TYPE_READ|QUERY_TYPE_USERVAR_WRITE|QUERY_TYPE_USERVAR_READ|QUERY_TYPE_PREPARE_STMT, stmt: SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, CASE DATA_TYPE WHEN 'bit' THEN @dt:= IF(NUMERIC_PRECISION=1,(-7), (-2)) WHEN 'tinyint' THEN @dt:=(-6) WHEN 'smallint' THEN @dt:=5 WHEN 'year' THEN @dt:= 5 WHEN 'mediumint' THEN @dt:=4 WHEN 'int' THEN @dt:=4 WHEN 'bigint' THEN @dt:=(-5) WHEN 'blob' THEN @dt:=(-4) WHEN 'tinyblob' THEN @dt:=(-4) WHEN 'mediumblob' THEN @dt:=(-4) WHEN 'longblob' THEN @dt:=(-4) WHEN 'decimal' THEN @dt:=3 WHEN 'float' THEN @dt:=IF(NUMERIC_SCALE IS NULL,7, 3) WHEN 'double' THEN @dt:=IF(NUMERIC_SCALE IS NULL,8, 3) WHEN 'binary' THEN @dt:=(-2) WHEN 'varbinary' THEN @dt:=(-3) WHEN 'text' THEN @dt:=(-10) WHEN 'tinytext' THEN @dt:=(-10) WHEN 'mediumtext' THEN @dt:=(-10) WHEN 'longtext' THEN @dt:=(-10) WHEN 'char' THEN @dt:=(-8) WHEN 'enum' THEN @dt:=(-8) WHEN 'set' THEN @dt:=(-8) WHEN 'varchar' THEN @dt:=(-9) WHEN 'date' THEN @dt:=91 WHEN 'time' THEN @dt:=92 WHEN 'datetime' THEN @dt:=93 WHEN 'timestamp' THEN 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) PS response for back3: 42 -> 14 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) PS response for back1: 42 -> 14 2019-07-09 16:19:21 info : (3) PS ID 14 maps to internal ID 42 2019-07-09 16:19:21 info : (3) Storing query (len: 9 cmd: 19), expecting 1 replies to current command 2019-07-09 16:19:21 info : (3) Storing query (len: 3719 cmd: 16), expecting 1 replies to current command 2019-07-09 16:19:21 info : (3) Storing query (len: 14 cmd: 17), expecting 1 replies to current command 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) PS response for back2: 42 -> 14 2019-07-09 16:19:21 info : (3) >>> Routing stored queries 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 14 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) <<< Stored queries routed 2019-07-09 16:19:21 info : (3) >>> Routing stored queries 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 3719, type: QUERY_TYPE_READ|QUERY_TYPE_USERVAR_WRITE|QUERY_TYPE_USERVAR_READ|QUERY_TYPE_PREPARE_STMT, stmt: SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, CASE DATA_TYPE WHEN 'bit' THEN @dt:= IF(NUMERIC_PRECISION=1,(-7), (-2)) WHEN 'tinyint' THEN @dt:=(-6) WHEN 'smallint' THEN @dt:=5 WHEN 'year' THEN @dt:= 5 WHEN 'mediumint' THEN @dt:=4 WHEN 'int' THEN @dt:=4 WHEN 'bigint' THEN @dt:=(-5) WHEN 'blob' THEN @dt:=(-4) WHEN 'tinyblob' THEN @dt:=(-4) WHEN 'mediumblob' THEN @dt:=(-4) WHEN 'longblob' THEN @dt:=(-4) WHEN 'decimal' THEN @dt:=3 WHEN 'float' THEN @dt:=IF(NUMERIC_SCALE IS NULL,7, 3) WHEN 'double' THEN @dt:=IF(NUMERIC_SCALE IS NULL,8, 3) WHEN 'binary' THEN @dt:=(-2) WHEN 'varbinary' THEN @dt:=(-3) WHEN 'text' THEN @dt:=(-10) WHEN 'tinytext' THEN @dt:=(-10) WHEN 'mediumtext' THEN @dt:=(-10) WHEN 'longtext' THEN @dt:=(-10) WHEN 'char' THEN @dt:=(-8) WHEN 'enum' THEN @dt:=(-8) WHEN 'set' THEN @dt:=(-8) WHEN 'varchar' THEN @dt:=(-9) WHEN 'date' THEN @dt:=91 WHEN 'time' THEN @dt:=92 WHEN 'datetime' THEN @dt:=93 WHEN 'timestamp' THEN 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) <<< Stored queries routed 2019-07-09 16:19:21 info : (3) >>> Routing stored queries 2019-07-09 16:19:21 info : (3) Storing query (len: 14 cmd: 17), expecting 3 replies to current command 2019-07-09 16:19:21 info : (3) <<< Stored queries routed 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) PS response for back3: 44 -> 15 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) PS response for back1: 44 -> 15 2019-07-09 16:19:21 info : (3) PS ID 15 maps to internal ID 44 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) PS response for back2: 44 -> 15 2019-07-09 16:19:21 info : (3) >>> Routing stored queries 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x17) COM_STMT_EXECUTE, plen: 14, type: QUERY_TYPE_EXEC_STMT, stmt: ID: 4294967295 2019-07-09 16:19:21 warning: (3) Using unknown prepared statement with ID 0 2019-07-09 16:19:21 error : (3) Could not find valid server for target type TARGET_MASTER, closing connection. 2019-07-09 16:19:21 info : (3) <<< Stored queries routed 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 21, type: QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_ENABLE_AUTOCOMMIT|QUERY_TYPE_COMMIT, stmt: SET autocommit=1 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 59, type: QUERY_TYPE_GSYSVAR_WRITE, stmt: SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 45, type: QUERY_TYPE_WRITE|QUERY_TYPE_PREPARE_STMT, stmt: UPDATE sip_buddies_mgw SET WHERE name=? 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) Session command no. 47 failed: #42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE name=?' at line 1 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 0 2019-07-09 16:19:21 warning: (3) Using unknown prepared statement with ID 0 2019-07-09 16:19:21 warning: (3) Closing unknown prepared statement with ID 0 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 0 2019-07-09 16:19:21 warning: (3) Using unknown prepared statement with ID 0 (subsequent similar messages suppressed for 10000 milliseconds) 2019-07-09 16:19:21 warning: (3) Closing unknown prepared statement with ID 0 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 13, type: QUERY_TYPE_READ|QUERY_TYPE_PREPARE_STMT, stmt: select 1 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) PS response for back1: 50 -> 17 2019-07-09 16:19:21 info : (3) PS ID 17 maps to internal ID 50 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) PS response for back3: 50 -> 17 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) PS response for back2: 50 -> 17 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x17) COM_STMT_EXECUTE, plen: 14, type: QUERY_TYPE_EXEC_STMT, stmt: ID: 17 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 < 2019-07-09 16:19:21 info : (3) COM_STMT_EXECUTE on back1: [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 17 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 warning: (3) Router session exceeded session command history limit. Server reconnection is disabled and only servers with consistent session state are used for the duration ofthe session. To disable this warning and the session command history, add `disable_sescmd_history=true` to service 'Read-Write-Service'. To increase the limit (currently 50), add `max_sescmd_history` to the same service and increase the value. 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 45, type: QUERY_TYPE_WRITE|QUERY_TYPE_PREPARE_STMT, stmt: UPDATE sip_buddies_mgw SET WHERE name=? 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back1 2019-07-09 16:19:21 info : (3) Session command no. 52 failed: #42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE name=?' at line 1 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back2 2019-07-09 16:19:21 info : (3) Reply complete, last reply from back3 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 0 2019-07-09 16:19:21 warning: (3) Closing unknown prepared statement with ID 0 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:19:21 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 0 2019-07-09 16:19:21 warning: (3) Closing unknown prepared statement with ID 0 2019-07-09 16:19:21 info : (3) Session write, routing to all servers. 2019-07-09 16:19:21 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:19:21 info : (3) Route query to slave: back3 [10.10.10.3]:3306 ... 2019-07-09 16:20:54 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2019-07-09 16:20:54 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 21, type: QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_ENABLE_AUTOCOMMIT|QUERY_TYPE_COMMIT, stmt: SET autocommit=1 2019-07-09 16:20:54 info : (3) Session write, routing to all servers. 2019-07-09 16:20:54 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (3) Reply complete, last reply from back1 2019-07-09 16:20:54 info : (3) Reply complete, last reply from back3 2019-07-09 16:20:54 info : (3) Storing query (len: 59 cmd: 3), expecting 1 replies to current command 2019-07-09 16:20:54 info : (3) Reply complete, last reply from back2 2019-07-09 16:20:54 info : (3) >>> Routing stored queries 2019-07-09 16:20:54 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 59, type: QUERY_TYPE_GSYSVAR_WRITE, stmt: SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 2019-07-09 16:20:54 info : (3) Session write, routing to all servers. 2019-07-09 16:20:54 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (3) <<< Stored queries routed 2019-07-09 16:20:54 info : (3) Reply complete, last reply from back3 2019-07-09 16:20:54 info : (3) Reply complete, last reply from back1 2019-07-09 16:20:54 info : (3) Reply complete, last reply from back2 2019-07-09 16:20:54 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 3719, type: QUERY_TYPE_READ|QUERY_TYPE_USERVAR_WRITE|QUERY_TYPE_USERVAR_READ|QUERY_TYPE_PREPARE_STMT, stmt: SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, CASE DATA_TYPE WHEN 'bit' THEN @dt:= IF(NUMERIC_PRECISION=1,(-7), (-2)) WHEN 'tinyint' THEN @dt:=(-6) WHEN 'smallint' THEN @dt:=5 WHEN 'year' THEN @dt:= 5 WHEN 'mediumint' THEN @dt:=4 WHEN 'int' THEN @dt:=4 WHEN 'bigint' THEN @dt:=(-5) WHEN 'blob' THEN @dt:=(-4) WHEN 'tinyblob' THEN @dt:=(-4) WHEN 'mediumblob' THEN @dt:=(-4) WHEN 'longblob' THEN @dt:=(-4) WHEN 'decimal' THEN @dt:=3 WHEN 'float' THEN @dt:=IF(NUMERIC_SCALE IS NULL,7, 3) WHEN 'double' THEN @dt:=IF(NUMERIC_SCALE IS NULL,8, 3) WHEN 'binary' THEN @dt:=(-2) WHEN 'varbinary' THEN @dt:=(-3) WHEN 'text' THEN @dt:=(-10) WHEN 'tinytext' THEN @dt:=(-10) WHEN 'mediumtext' THEN @dt:=(-10) WHEN 'longtext' THEN @dt:=(-10) WHEN 'char' THEN @dt:=(-8) WHEN 'enum' THEN @dt:=(-8) WHEN 'set' THEN @dt:=(-8) WHEN 'varchar' THEN @dt:=(-9) WHEN 'date' THEN @dt:=91 WHEN 'time' THEN @dt:=92 WHEN 'datetime' THEN @dt:=93 WHEN 'timestamp' THEN 2019-07-09 16:20:54 info : (3) Session write, routing to all servers. 2019-07-09 16:20:54 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (3) Reply complete, last reply from back3 2019-07-09 16:20:54 info : (3) PS response for back3: 57 -> 19 2019-07-09 16:20:54 info : (3) Reply complete, last reply from back1 2019-07-09 16:20:54 info : (3) PS response for back1: 57 -> 19 2019-07-09 16:20:54 info : (3) PS ID 19 maps to internal ID 57 2019-07-09 16:20:54 info : (3) Reply complete, last reply from back2 2019-07-09 16:20:54 info : (3) PS response for back2: 57 -> 19 2019-07-09 16:20:54 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 19 2019-07-09 16:20:54 info : (3) Session write, routing to all servers. 2019-07-09 16:20:54 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 3719, type: QUERY_TYPE_READ|QUERY_TYPE_USERVAR_WRITE|QUERY_TYPE_USERVAR_READ|QUERY_TYPE_PREPARE_STMT, stmt: SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, CASE DATA_TYPE WHEN 'bit' THEN @dt:= IF(NUMERIC_PRECISION=1,(-7), (-2)) WHEN 'tinyint' THEN @dt:=(-6) WHEN 'smallint' THEN @dt:=5 WHEN 'year' THEN @dt:= 5 WHEN 'mediumint' THEN @dt:=4 WHEN 'int' THEN @dt:=4 WHEN 'bigint' THEN @dt:=(-5) WHEN 'blob' THEN @dt:=(-4) WHEN 'tinyblob' THEN @dt:=(-4) WHEN 'mediumblob' THEN @dt:=(-4) WHEN 'longblob' THEN @dt:=(-4) WHEN 'decimal' THEN @dt:=3 WHEN 'float' THEN @dt:=IF(NUMERIC_SCALE IS NULL,7, 3) WHEN 'double' THEN @dt:=IF(NUMERIC_SCALE IS NULL,8, 3) WHEN 'binary' THEN @dt:=(-2) WHEN 'varbinary' THEN @dt:=(-3) WHEN 'text' THEN @dt:=(-10) WHEN 'tinytext' THEN @dt:=(-10) WHEN 'mediumtext' THEN @dt:=(-10) WHEN 'longtext' THEN @dt:=(-10) WHEN 'char' THEN @dt:=(-8) WHEN 'enum' THEN @dt:=(-8) WHEN 'set' THEN @dt:=(-8) WHEN 'varchar' THEN @dt:=(-9) WHEN 'date' THEN @dt:=91 WHEN 'time' THEN @dt:=92 WHEN 'datetime' THEN @dt:=93 WHEN 'timestamp' THEN 2019-07-09 16:20:54 info : (3) Session write, routing to all servers. 2019-07-09 16:20:54 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (3) Storing query (len: 14 cmd: 17), expecting 3 replies to current command 2019-07-09 16:20:54 info : (3) Reply complete, last reply from back3 2019-07-09 16:20:54 info : (3) PS response for back3: 59 -> 20 2019-07-09 16:20:54 info : (3) Reply complete, last reply from back2 2019-07-09 16:20:54 info : (3) PS response for back2: 59 -> 20 2019-07-09 16:20:54 info : (3) Reply complete, last reply from back1 2019-07-09 16:20:54 info : (3) PS response for back1: 59 -> 20 2019-07-09 16:20:54 info : (3) PS ID 20 maps to internal ID 59 2019-07-09 16:20:54 info : (3) >>> Routing stored queries 2019-07-09 16:20:54 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x17) COM_STMT_EXECUTE, plen: 14, type: QUERY_TYPE_EXEC_STMT, stmt: ID: 4294967295 2019-07-09 16:20:54 warning: (3) Client requests unknown prepared statement ID '4294967295' that does not map to an internal ID 2019-07-09 16:20:54 warning: (3) Using unknown prepared statement with ID 0 2019-07-09 16:20:54 error : (3) Could not find valid server for target type TARGET_MASTER, closing connection. 2019-07-09 16:20:54 info : (3) <<< Stored queries routed 2019-07-09 16:20:54 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 4294967295 2019-07-09 16:20:54 warning: (3) Client requests unknown prepared statement ID '4294967295' that does not map to an internal ID 2019-07-09 16:20:54 warning: (3) Using unknown prepared statement with ID 0 2019-07-09 16:20:54 warning: (3) Client requests unknown prepared statement ID '4294967295' that does not map to an internal ID 2019-07-09 16:20:54 warning: (3) Closing unknown prepared statement with ID 0 2019-07-09 16:20:54 info : (3) Session write, routing to all servers. 2019-07-09 16:20:54 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 13, type: QUERY_TYPE_READ|QUERY_TYPE_PREPARE_STMT, stmt: select 1 2019-07-09 16:20:54 info : (3) Session write, routing to all servers. 2019-07-09 16:20:54 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (3) Reply complete, last reply from back1 2019-07-09 16:20:54 info : (3) PS response for back1: 61 -> 21 2019-07-09 16:20:54 info : (3) PS ID 21 maps to internal ID 61 2019-07-09 16:20:54 info : (3) Reply complete, last reply from back2 2019-07-09 16:20:54 info : (3) PS response for back2: 61 -> 21 2019-07-09 16:20:54 info : (3) Reply complete, last reply from back3 2019-07-09 16:20:54 info : (3) PS response for back3: 61 -> 21 2019-07-09 16:20:54 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 308700516 2019-07-09 16:20:54 warning: (3) Client requests unknown prepared statement ID '308700516' that does not map to an internal ID 2019-07-09 16:20:54 warning: (3) Using unknown prepared statement with ID 0 2019-07-09 16:20:54 warning: (3) Client requests unknown prepared statement ID '308700516' that does not map to an internal ID 2019-07-09 16:20:54 warning: (3) Closing unknown prepared statement with ID 0 2019-07-09 16:20:54 info : (3) Session write, routing to all servers. 2019-07-09 16:20:54 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 0 2019-07-09 16:20:54 warning: (3) Client requests unknown prepared statement ID '0' that does not map to an internal ID 2019-07-09 16:20:54 warning: (3) Using unknown prepared statement with ID 0 2019-07-09 16:20:54 warning: (3) Client requests unknown prepared statement ID '0' that does not map to an internal ID 2019-07-09 16:20:54 warning: (3) Closing unknown prepared statement with ID 0 2019-07-09 16:20:54 info : (3) Session write, routing to all servers. 2019-07-09 16:20:54 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 15 2019-07-09 16:20:54 info : (3) Session write, routing to all servers. 2019-07-09 16:20:54 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 4294967295 2019-07-09 16:20:54 warning: (3) Client requests unknown prepared statement ID '4294967295' that does not map to an internal ID 2019-07-09 16:20:54 warning: (3) Using unknown prepared statement with ID 0 2019-07-09 16:20:54 warning: (3) Client requests unknown prepared statement ID '4294967295' that does not map to an internal ID 2019-07-09 16:20:54 warning: (3) Closing unknown prepared statement with ID 0 2019-07-09 16:20:54 info : (3) Session write, routing to all servers. 2019-07-09 16:20:54 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (3) > Autocommit: [enabled], trx is [not open], cmd: (0x01) COM_QUIT, plen: 5, type: QUERY_TYPE_SESSION_WRITE, stmt: 2019-07-09 16:20:54 info : (3) Session write, routing to all servers. 2019-07-09 16:20:54 info : (3) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (3) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : Stopped Read-Write-Service client session [3] 2019-07-09 16:20:54 info : Servers and router connection counts: 2019-07-09 16:20:54 info : current operations : 0 in [10.10.10.1]:3306 RUNNING MASTER 2019-07-09 16:20:54 info : current operations : 0 in [10.10.10.2]:3306 RUNNING SLAVE 2019-07-09 16:20:54 info : current operations : 0 in [10.10.10.3]:3306 RUNNING SLAVE 2019-07-09 16:20:54 info : Selected Master: back1 2019-07-09 16:20:54 info : Selected Slave: back2 2019-07-09 16:20:54 info : Selected Slave: back3 2019-07-09 16:20:54 info : Started Read-Write-Service client session [5] for 'user' from ::ffff:172.16.1.1 2019-07-09 16:20:54 info : (5) Sending proxy-protocol header 'PROXY TCP6 ::ffff:172.16.1.1 ::ffff:192.168.1.254 44890 3306 ' to backend back1. 2019-07-09 16:20:54 info : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 35, type: QUERY_TYPE_GSYSVAR_WRITE, stmt: SET SESSION SQL_AUTO_IS_NULL=0 2019-07-09 16:20:54 info : (5) Session write, routing to all servers. 2019-07-09 16:20:54 info : (5) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (5) Sending proxy-protocol header 'PROXY TCP6 ::ffff:172.16.1.1 ::ffff:192.168.1.254 44890 3306 ' to backend back3. 2019-07-09 16:20:54 info : (5) Connected to 'back1' with thread id 430770 2019-07-09 16:20:54 info : (5) Sending proxy-protocol header 'PROXY TCP6 ::ffff:172.16.1.1 ::ffff:192.168.1.254 44890 3306 ' to backend back2. 2019-07-09 16:20:54 info : (5) Connected to 'back2' with thread id 445027 2019-07-09 16:20:54 info : (5) Connected to 'back3' with thread id 444460 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back1 2019-07-09 16:20:54 info : (5) Storing query (len: 21 cmd: 3), expecting 2 replies to current command 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back2 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back3 2019-07-09 16:20:54 info : (5) >>> Routing stored queries 2019-07-09 16:20:54 info : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 21, type: QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_ENABLE_AUTOCOMMIT|QUERY_TYPE_COMMIT, stmt: SET autocommit=1 2019-07-09 16:20:54 info : (5) Session write, routing to all servers. 2019-07-09 16:20:54 info : (5) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (5) <<< Stored queries routed 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back1 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back2 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back3 2019-07-09 16:20:54 info : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 3719, type: QUERY_TYPE_READ|QUERY_TYPE_USERVAR_WRITE|QUERY_TYPE_USERVAR_READ|QUERY_TYPE_PREPARE_STMT, stmt: SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, CASE DATA_TYPE WHEN 'bit' THEN @dt:= IF(NUMERIC_PRECISION=1,(-7), (-2)) WHEN 'tinyint' THEN @dt:=(-6) WHEN 'smallint' THEN @dt:=5 WHEN 'year' THEN @dt:= 5 WHEN 'mediumint' THEN @dt:=4 WHEN 'int' THEN @dt:=4 WHEN 'bigint' THEN @dt:=(-5) WHEN 'blob' THEN @dt:=(-4) WHEN 'tinyblob' THEN @dt:=(-4) WHEN 'mediumblob' THEN @dt:=(-4) WHEN 'longblob' THEN @dt:=(-4) WHEN 'decimal' THEN @dt:=3 WHEN 'float' THEN @dt:=IF(NUMERIC_SCALE IS NULL,7, 3) WHEN 'double' THEN @dt:=IF(NUMERIC_SCALE IS NULL,8, 3) WHEN 'binary' THEN @dt:=(-2) WHEN 'varbinary' THEN @dt:=(-3) WHEN 'text' THEN @dt:=(-10) WHEN 'tinytext' THEN @dt:=(-10) WHEN 'mediumtext' THEN @dt:=(-10) WHEN 'longtext' THEN @dt:=(-10) WHEN 'char' THEN @dt:=(-8) WHEN 'enum' THEN @dt:=(-8) WHEN 'set' THEN @dt:=(-8) WHEN 'varchar' THEN @dt:=(-9) WHEN 'date' THEN @dt:=91 WHEN 'time' THEN @dt:=92 WHEN 'datetime' THEN @dt:=93 WHEN 'timestamp' THEN 2019-07-09 16:20:54 info : (5) Session write, routing to all servers. 2019-07-09 16:20:54 info : (5) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back1 2019-07-09 16:20:54 info : (5) PS response for back1: 3 -> 1 2019-07-09 16:20:54 info : (5) PS ID 1 maps to internal ID 3 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back2 2019-07-09 16:20:54 info : (5) PS response for back2: 3 -> 1 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back3 2019-07-09 16:20:54 info : (5) PS response for back3: 3 -> 1 2019-07-09 16:20:54 info : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 1 2019-07-09 16:20:54 info : (5) Session write, routing to all servers. 2019-07-09 16:20:54 info : (5) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 3719, type: QUERY_TYPE_READ|QUERY_TYPE_USERVAR_WRITE|QUERY_TYPE_USERVAR_READ|QUERY_TYPE_PREPARE_STMT, stmt: SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, CASE DATA_TYPE WHEN 'bit' THEN @dt:= IF(NUMERIC_PRECISION=1,(-7), (-2)) WHEN 'tinyint' THEN @dt:=(-6) WHEN 'smallint' THEN @dt:=5 WHEN 'year' THEN @dt:= 5 WHEN 'mediumint' THEN @dt:=4 WHEN 'int' THEN @dt:=4 WHEN 'bigint' THEN @dt:=(-5) WHEN 'blob' THEN @dt:=(-4) WHEN 'tinyblob' THEN @dt:=(-4) WHEN 'mediumblob' THEN @dt:=(-4) WHEN 'longblob' THEN @dt:=(-4) WHEN 'decimal' THEN @dt:=3 WHEN 'float' THEN @dt:=IF(NUMERIC_SCALE IS NULL,7, 3) WHEN 'double' THEN @dt:=IF(NUMERIC_SCALE IS NULL,8, 3) WHEN 'binary' THEN @dt:=(-2) WHEN 'varbinary' THEN @dt:=(-3) WHEN 'text' THEN @dt:=(-10) WHEN 'tinytext' THEN @dt:=(-10) WHEN 'mediumtext' THEN @dt:=(-10) WHEN 'longtext' THEN @dt:=(-10) WHEN 'char' THEN @dt:=(-8) WHEN 'enum' THEN @dt:=(-8) WHEN 'set' THEN @dt:=(-8) WHEN 'varchar' THEN @dt:=(-9) WHEN 'date' THEN @dt:=91 WHEN 'time' THEN @dt:=92 WHEN 'datetime' THEN @dt:=93 WHEN 'timestamp' THEN 2019-07-09 16:20:54 info : (5) Session write, routing to all servers. 2019-07-09 16:20:54 info : (5) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (5) Storing query (len: 14 cmd: 17), expecting 3 replies to current command 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back1 2019-07-09 16:20:54 info : (5) PS response for back1: 5 -> 2 2019-07-09 16:20:54 info : (5) PS ID 2 maps to internal ID 5 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back3 2019-07-09 16:20:54 info : (5) PS response for back3: 5 -> 2 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back2 2019-07-09 16:20:54 info : (5) PS response for back2: 5 -> 2 2019-07-09 16:20:54 info : (5) >>> Routing stored queries 2019-07-09 16:20:54 info : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x17) COM_STMT_EXECUTE, plen: 14, type: QUERY_TYPE_EXEC_STMT, stmt: ID: 4294967295 2019-07-09 16:20:54 warning: (5) Client requests unknown prepared statement ID '4294967295' that does not map to an internal ID (subsequent similar messages suppressed for 10000 milliseconds) 2019-07-09 16:20:54 warning: (5) Using unknown prepared statement with ID 0 2019-07-09 16:20:54 error : (5) Could not find valid server for target type TARGET_MASTER, closing connection. 2019-07-09 16:20:54 info : (5) <<< Stored queries routed 2019-07-09 16:20:54 info : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 21, type: QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_ENABLE_AUTOCOMMIT|QUERY_TYPE_COMMIT, stmt: SET autocommit=1 2019-07-09 16:20:54 info : (5) Session write, routing to all servers. 2019-07-09 16:20:54 info : (5) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back1 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back2 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back3 2019-07-09 16:20:54 info : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 59, type: QUERY_TYPE_GSYSVAR_WRITE, stmt: SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 2019-07-09 16:20:54 info : (5) Session write, routing to all servers. 2019-07-09 16:20:54 info : (5) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back1 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back3 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back2 2019-07-09 16:20:54 info : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 45, type: QUERY_TYPE_WRITE|QUERY_TYPE_PREPARE_STMT, stmt: UPDATE sip_buddies_mgw SET WHERE name=? 2019-07-09 16:20:54 info : (5) Session write, routing to all servers. 2019-07-09 16:20:54 info : (5) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back1 2019-07-09 16:20:54 info : (5) Session command no. 8 failed: #42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE name=?' at line 1 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back2 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back3 2019-07-09 16:20:54 info : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 0 2019-07-09 16:20:54 warning: (5) Using unknown prepared statement with ID 0 2019-07-09 16:20:54 warning: (5) Closing unknown prepared statement with ID 0 2019-07-09 16:20:54 info : (5) Session write, routing to all servers. 2019-07-09 16:20:54 info : (5) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 0 2019-07-09 16:20:54 warning: (5) Using unknown prepared statement with ID 0 2019-07-09 16:20:54 warning: (5) Closing unknown prepared statement with ID 0 2019-07-09 16:20:54 info : (5) Session write, routing to all servers. 2019-07-09 16:20:54 info : (5) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 13, type: QUERY_TYPE_READ|QUERY_TYPE_PREPARE_STMT, stmt: select 1 2019-07-09 16:20:54 info : (5) Session write, routing to all servers. 2019-07-09 16:20:54 info : (5) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back1 2019-07-09 16:20:54 info : (5) PS response for back1: 11 -> 4 2019-07-09 16:20:54 info : (5) PS ID 4 maps to internal ID 11 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back2 2019-07-09 16:20:54 info : (5) PS response for back2: 11 -> 4 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back3 2019-07-09 16:20:54 info : (5) PS response for back3: 11 -> 4 2019-07-09 16:20:54 info : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x17) COM_STMT_EXECUTE, plen: 14, type: QUERY_TYPE_EXEC_STMT, stmt: ID: 4 2019-07-09 16:20:54 info : (5) Route query to master: back1 [10.10.10.1]:3306 < 2019-07-09 16:20:54 info : (5) COM_STMT_EXECUTE on back1: [10.10.10.1]:3306 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back1 2019-07-09 16:20:54 info : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 4 2019-07-09 16:20:54 info : (5) Session write, routing to all servers. 2019-07-09 16:20:54 info : (5) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x16) COM_STMT_PREPARE, plen: 45, type: QUERY_TYPE_WRITE|QUERY_TYPE_PREPARE_STMT, stmt: UPDATE sip_buddies_mgw SET WHERE name=? 2019-07-09 16:20:54 info : (5) Session write, routing to all servers. 2019-07-09 16:20:54 info : (5) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back1 2019-07-09 16:20:54 info : (5) Session command no. 13 failed: #42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE name=?' at line 1 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back3 2019-07-09 16:20:54 info : (5) Reply complete, last reply from back2 2019-07-09 16:20:54 info : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 0 2019-07-09 16:20:54 warning: (5) Using unknown prepared statement with ID 0 2019-07-09 16:20:54 warning: (5) Closing unknown prepared statement with ID 0 2019-07-09 16:20:54 info : (5) Session write, routing to all servers. 2019-07-09 16:20:54 info : (5) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:54 info : (5) > Autocommit: [enabled], trx is [not open], cmd: (0x19) COM_STMT_CLOSE, plen: 9, type: QUERY_TYPE_WRITE, stmt: ID: 0 2019-07-09 16:20:54 warning: (5) Using unknown prepared statement with ID 0 (subsequent similar messages suppressed for 10000 milliseconds) 2019-07-09 16:20:54 warning: (5) Closing unknown prepared statement with ID 0 2019-07-09 16:20:54 info : (5) Session write, routing to all servers. 2019-07-09 16:20:54 info : (5) Route query to master: back1 [10.10.10.1]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back2 [10.10.10.2]:3306 2019-07-09 16:20:54 info : (5) Route query to slave: back3 [10.10.10.3]:3306 2019-07-09 16:20:55 info : Accept authentication from 'admin', using password. Request: /v1/monitors ... 2019-07-09 16:21:56 info : Accept authentication from 'admin', using password. Request: /v1/servers