{"log":"2025-10-30 04:09:42 info : (41586) [MariaDBProtocol] Connection attributes: _client_name=mysqlnd _server_host=192.168.3.23:53306 \n","stream":"stdout","time":"2025-10-30T04:09:42.581636294Z"} {"log":"2025-10-30 04:09:42 info : (41586) Found matching user 'atlas_prod'@'%' for client 'atlas_prod'@'172.26.64.1' with sufficient privileges.\n","stream":"stdout","time":"2025-10-30T04:09:42.581658997Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Target connection counts:\n","stream":"stdout","time":"2025-10-30T04:09:42.581664437Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); current operations : 0 in \u0009server1 Slave, Synced, Running\n","stream":"stdout","time":"2025-10-30T04:09:42.581668876Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); current operations : 0 in \u0009server2 Master, Synced, Running\n","stream":"stdout","time":"2025-10-30T04:09:42.581673865Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); current operations : 0 in \u0009server3 Slave, Synced, Running\n","stream":"stdout","time":"2025-10-30T04:09:42.581678604Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Connected to 'server2'\n","stream":"stdout","time":"2025-10-30T04:09:42.581712548Z"} {"log":"2025-10-30 04:09:42 info : (41586) (server2); Storing COM_QUERY while in state 'Handshaking', 1 packet(s) queued: SET @@session.session_track_system_variables = CASE @@session.session_track_system_variables WHEN '*' TH… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Selected Primary: server2\n","stream":"stdout","time":"2025-10-30T04:09:42.581725041Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Connected to 'server1'\n","stream":"stdout","time":"2025-10-30T04:09:42.581749807Z"} {"log":"2025-10-30 04:09:42 info : (41586) (server1); Storing COM_QUERY while in state 'Handshaking', 1 packet(s) queued: SET @@session.session_track_system_variables = CASE @@session.session_track_system_variables WHEN '*' TH… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Selected Replica: server1\n","stream":"stdout","time":"2025-10-30T04:09:42.58175655Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Connected to 'server3'\n","stream":"stdout","time":"2025-10-30T04:09:42.581787739Z"} {"log":"2025-10-30 04:09:42 info : (41586) (server3); Storing COM_QUERY while in state 'Handshaking', 1 packet(s) queued: SET @@session.session_track_system_variables = CASE @@session.session_track_system_variables WHEN '*' TH… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Selected Replica: server3\n","stream":"stdout","time":"2025-10-30T04:09:42.581797106Z"} {"log":"2025-10-30 04:09:42 info : (41586) Started GaleraService client session [41586] for 'atlas_prod' from 172.26.64.1 on 'Worker-00'\n","stream":"stdout","time":"2025-10-30T04:09:42.581804681Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [not open], cmd: (0x3) COM_QUERY, plen: 22, type: sql::TYPE_SESSION_WRITE, stmt: SET sql_mode = ''\n","stream":"stdout","time":"2… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Session write, routing to all servers.\n","stream":"stdout","time":"2025-10-30T04:09:42.581896944Z"} {"log":"2025-10-30 04:09:42 info : (41586) (server1); Storing COM_QUERY while in state 'Handshaking', 2 packet(s) queued: SET sql_mode = ''\n","stream":"stdout","time":"2025-10-30T04:09:42.581899228Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to replica: server1\n","stream":"stdout","time":"2025-10-30T04:09:42.581901312Z"} {"log":"2025-10-30 04:09:42 info : (41586) (server2); Storing COM_QUERY while in state 'Handshaking', 2 packet(s) queued: SET sql_mode = ''\n","stream":"stdout","time":"2025-10-30T04:09:42.581903276Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2\n","stream":"stdout","time":"2025-10-30T04:09:42.581905179Z"} {"log":"2025-10-30 04:09:42 info : (41586) (server3); Storing COM_QUERY while in state 'Handshaking', 2 packet(s) queued: SET sql_mode = ''\n","stream":"stdout","time":"2025-10-30T04:09:42.581907093Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to replica: server3\n","stream":"stdout","time":"2025-10-30T04:09:42.581909026Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Will return response from 'server2' to the client\n","stream":"stdout","time":"2025-10-30T04:09:42.5819109Z"} {"log":"2025-10-30 04:09:42 info : (41586) Connected to 'server2' with thread id 2114549\n","stream":"stdout","time":"2025-10-30T04:09:42.583241218Z"} {"log":"2025-10-30 04:09:42 info : (41586) Authentication to 'server2' succeeded.\n","stream":"stdout","time":"2025-10-30T04:09:42.583440271Z"} {"log":"2025-10-30 04:09:42 info : (41586) Connected to 'server3' with thread id 2103713\n","stream":"stdout","time":"2025-10-30T04:09:42.583824743Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2', discarding it: OK: 0 rows affected, 0 warnings\n","stream":"stdout","time":"2025-10-30T04:09:42.583838699Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (OK: 0 rows affected, 0 warnings)\n","stream":"stdout","time":"2025-10-30T04:09:42.583994171Z"} {"log":"2025-10-30 04:09:42 info : (41586) [MariaDBProtocol] (GaleraService); Added COM_QUERY to history with ID 1: SET sql_mode = '' (result: OK)\n","stream":"stdout","time":"2025-10-30T04:09:42.583998319Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [not open], cmd: (0x3) COM_QUERY, plen: 32, type: sql::TYPE_SESSION_WRITE, stmt: SET time_zone='Europe/Kyiv'\n","stream":"stdout"… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Session write, routing to all servers.\n","stream":"stdout","time":"2025-10-30T04:09:42.584056288Z"} {"log":"2025-10-30 04:09:42 info : (41586) (server1); Storing COM_QUERY while in state 'Handshaking', 3 packet(s) queued: SET time_zone='Europe/Kyiv'\n","stream":"stdout","time":"2025-10-30T04:09:42.584058131Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to replica: server1\n","stream":"stdout","time":"2025-10-30T04:09:42.584059624Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2\n","stream":"stdout","time":"2025-10-30T04:09:42.584072588Z"} {"log":"2025-10-30 04:09:42 info : (41586) (server3); Storing COM_QUERY while in state 'Authenticating', 3 packet(s) queued: SET time_zone='Europe/Kyiv'\n","stream":"stdout","time":"2025-10-30T04:09:42.584077067Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to replica: server3\n","stream":"stdout","time":"2025-10-30T04:09:42.58407899Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Will return response from 'server2' to the client\n","stream":"stdout","time":"2025-10-30T04:09:42.584080473Z"} {"log":"2025-10-30 04:09:42 info : (41586) Connected to 'server1' with thread id 2104238\n","stream":"stdout","time":"2025-10-30T04:09:42.58425994Z"} {"log":"2025-10-30 04:09:42 info : (41586) Authentication to 'server3' succeeded.\n","stream":"stdout","time":"2025-10-30T04:09:42.584621278Z"} {"log":"2025-10-30 04:09:42 info : (41586) Execute COM_QUERY 1 on 'server3': SET sql_mode = ''\n","stream":"stdout","time":"2025-10-30T04:09:42.584626318Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (OK: 0 rows affected, 0 warnings)\n","stream":"stdout","time":"2025-10-30T04:09:42.5846277Z"} {"log":"2025-10-30 04:09:42 info : (41586) [MariaDBProtocol] (GaleraService); Added COM_QUERY to history with ID 2: SET time_zone='Europe/Kyiv' (result: OK)\n","stream":"stdout","time":"2025-10-30T04:09:42.584629043Z"} {"log":"2025-10-30 04:09:42 info : (41586) Authentication to 'server1' succeeded.\n","stream":"stdout","time":"2025-10-30T04:09:42.584794534Z"} {"log":"2025-10-30 04:09:42 info : (41586) Execute COM_QUERY 1 on 'server1': SET sql_mode = ''\n","stream":"stdout","time":"2025-10-30T04:09:42.58479765Z"} {"log":"2025-10-30 04:09:42 info : (41586) Execute COM_QUERY 2 on 'server1': SET time_zone='Europe/Kyiv'\n","stream":"stdout","time":"2025-10-30T04:09:42.584806817Z"} {"log":"2025-10-30 04:09:42 info : (41586) Reply to 1 complete from 'server3'\n","stream":"stdout","time":"2025-10-30T04:09:42.584953312Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server3', discarding it: OK: 0 rows affected, 0 warnings\n","stream":"stdout","time":"2025-10-30T04:09:42.58529878Z"} {"log":"2025-10-30 04:09:42 info : (41586) Reply to 1 complete from 'server1'\n","stream":"stdout","time":"2025-10-30T04:09:42.585309981Z"} {"log":"2025-10-30 04:09:42 info : (41586) Reply to 2 complete from 'server1'\n","stream":"stdout","time":"2025-10-30T04:09:42.585315842Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [not open], cmd: (0x3) COM_QUERY, plen: 86, type: sql::TYPE_READ, stmt: SELECT * FROM users WHERE user_api_key='_REDACTED_' LIMIT… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to replica: server3 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.585344096Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server3', discarding it: OK: 0 rows affected, 0 warnings\n","stream":"stdout","time":"2025-10-30T04:09:42.585462197Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server3', discarding it: OK: 0 rows affected, 0 warnings\n","stream":"stdout","time":"2025-10-30T04:09:42.585464171Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server1', discarding it: OK: 0 rows affected, 0 warnings\n","stream":"stdout","time":"2025-10-30T04:09:42.585827974Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server1', discarding it: OK: 0 rows affected, 0 warnings\n","stream":"stdout","time":"2025-10-30T04:09:42.585832983Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server1', discarding it: OK: 0 rows affected, 0 warnings\n","stream":"stdout","time":"2025-10-30T04:09:42.585834426Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server3' (Resultset: 1 rows in 418B)\n","stream":"stdout","time":"2025-10-30T04:09:42.585843403Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [not open], cmd: (0x3) COM_QUERY, plen: 62, type: sql::TYPE_READ, stmt: SHOW COLUMNS FROM receipts WHERE Field NOT LIKE \"\\_%\"\… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to replica: server1 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.590355714Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server1' (Resultset: 78 rows in 2.43KiB)\n","stream":"stdout","time":"2025-10-30T04:09:42.591511424Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [not open], cmd: (0x3) COM_QUERY, plen: 27, type: sql::TYPE_READ, stmt: SELECT CONNECTION_ID()\n","stream":"stdout","time":"2025-… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to replica: server3 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.591628354Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server3' (Resultset: 1 rows in 76B)\n","stream":"stdout","time":"2025-10-30T04:09:42.591989342Z"} {"log":"2025-10-30 04:09:42 info : (41586) Added temporary table atlas_prod._temp_receipts_b08d87d7e16efff6\n","stream":"stdout","time":"2025-10-30T04:09:42.59207905Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [not open], cmd: (0x3) COM_QUERY, plen: 7737, type: sql::TYPE_WRITE|sql::TYPE_CREATE_TMP_TABLE, stmt: CREATE TEMPORARY TABLE IF N… {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); Added temporary table atlas_prod._temp_receipts_b08d87d7e16efff6\n","stream":"stdout","time":"2025-10-30T04:09:42.59209515Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.592096583Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (OK: 0 rows affected, 0 warnings)\n","stream":"stdout","time":"2025-10-30T04:09:42.592810333Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [not open], cmd: (0x3) COM_QUERY, plen: 48, type: sql::TYPE_WRITE, stmt: DELETE FROM _temp_receipts_b08d87d7e16efff6\n","stream":… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.592857852Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (OK: 0 rows affected, 0 warnings)\n","stream":"stdout","time":"2025-10-30T04:09:42.593033532Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [not open], cmd: (0x3) COM_QUERY, plen: 27, type: sql::TYPE_READ, stmt: SELECT CONNECTION_ID()\n","stream":"stdout","time":"2025-… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to replica: server1 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.593064049Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server1' (Resultset: 1 rows in 76B)\n","stream":"stdout","time":"2025-10-30T04:09:42.593412674Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 22, type: sql::TYPE_BEGIN_TRX, stmt: START TRANSACTION\n","stream":"stdout","time":"2025-10-3… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.59344265Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Transaction starting on 'server2'\n","stream":"stdout","time":"2025-10-30T04:09:42.593449583Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (OK: 0 rows affected, 0 warnings)\n","stream":"stdout","time":"2025-10-30T04:09:42.59359187Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 27, type: sql::TYPE_READ, stmt: SELECT CONNECTION_ID()\n","stream":"stdout","time":"2025-10-3… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.593624672Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (Resultset: 1 rows in 76B)\n","stream":"stdout","time":"2025-10-30T04:09:42.593774313Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 1269, type: sql::TYPE_WRITE, stmt: INSERT INTO _temp_receipts_b08d87d7e16efff6 (rd,dt,nc,ac,k… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.593909937Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (OK: 2 rows affected, 0 warnings)\n","stream":"stdout","time":"2025-10-30T04:09:42.594205703Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 27, type: sql::TYPE_READ, stmt: SELECT CONNECTION_ID()\n","stream":"stdout","time":"2025-10-3… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.594231992Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (Resultset: 1 rows in 76B)\n","stream":"stdout","time":"2025-10-30T04:09:42.594437097Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 338, type: sql::TYPE_WRITE, stmt: UPDATE _temp_receipts_b08d87d7e16efff6\\n … {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.594493142Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (OK: 2 rows affected, 0 warnings)\n","stream":"stdout","time":"2025-10-30T04:09:42.594904254Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 27, type: sql::TYPE_READ, stmt: SELECT CONNECTION_ID()\n","stream":"stdout","time":"2025-10-3… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.594934691Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (Resultset: 1 rows in 76B)\n","stream":"stdout","time":"2025-10-30T04:09:42.595126662Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 1001, type: sql::TYPE_WRITE, stmt: UPDATE receipts r\\n INNER … {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.595371091Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (OK: 2 rows affected, 0 warnings)\n","stream":"stdout","time":"2025-10-30T04:09:42.595998238Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 27, type: sql::TYPE_READ, stmt: SELECT CONNECTION_ID()\n","stream":"stdout","time":"2025-10-3… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.59602582Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (Resultset: 1 rows in 76B)\n","stream":"stdout","time":"2025-10-30T04:09:42.596182865Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 936, type: sql::TYPE_WRITE, stmt: INSERT INTO receipts (rd,dt,nc,ac,kn,k,c,s,ss,crd,ka,ik,iu,… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.596311737Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (Error: 1146, 42S02 Table 'atlas_prod._temp_receipts_b08d87d7e16efff6' doesn't exist)\n","stream":"stdout","time":"2025… {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 27, type: sql::TYPE_READ, stmt: SELECT CONNECTION_ID()\n","stream":"stdout","time":"2025-10-3… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.596596682Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (Resultset: 1 rows in 76B)\n","stream":"stdout","time":"2025-10-30T04:09:42.59673953Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 31, type: sql::TYPE_READ, stmt: SHOW TABLES LIKE '_temp_%'\n","stream":"stdout","time":"2025-… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.596779405Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (Resultset: 1 rows in 165B)\n","stream":"stdout","time":"2025-10-30T04:09:42.596994939Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 14, type: sql::TYPE_ROLLBACK, stmt: ROLLBACK \n","stream":"stdout","time":"2025-10-30T04:09:4… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.597029614Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (OK: 0 rows affected, 1 warnings)\n","stream":"stdout","time":"2025-10-30T04:09:42.597298729Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Transaction complete on 'server2', 0B of SQL.\n","stream":"stdout","time":"2025-10-30T04:09:42.597302547Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [not open], cmd: (0x3) COM_QUERY, plen: 27, type: sql::TYPE_READ, stmt: SELECT CONNECTION_ID()\n","stream":"stdout","time":"2025-… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to replica: server3 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.60758953Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server3' (Resultset: 1 rows in 76B)\n","stream":"stdout","time":"2025-10-30T04:09:42.608322356Z"} {"log":"2025-10-30 04:09:42 info : (41586) Added temporary table atlas_prod._temp_receipts_b08d87d7e16efff6\n","stream":"stdout","time":"2025-10-30T04:09:42.60839951Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [not open], cmd: (0x3) COM_QUERY, plen: 7737, type: sql::TYPE_WRITE|sql::TYPE_CREATE_TMP_TABLE, stmt: CREATE TEMPORARY TABLE IF N… {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); Added temporary table atlas_prod._temp_receipts_b08d87d7e16efff6\n","stream":"stdout","time":"2025-10-30T04:09:42.608440838Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.608443052Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (OK: 0 rows affected, 0 warnings)\n","stream":"stdout","time":"2025-10-30T04:09:42.609349564Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [not open], cmd: (0x3) COM_QUERY, plen: 48, type: sql::TYPE_WRITE, stmt: DELETE FROM _temp_receipts_b08d87d7e16efff6\n","stream":… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.609403996Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (OK: 0 rows affected, 0 warnings)\n","stream":"stdout","time":"2025-10-30T04:09:42.609595867Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [not open], cmd: (0x3) COM_QUERY, plen: 27, type: sql::TYPE_READ, stmt: SELECT CONNECTION_ID()\n","stream":"stdout","time":"2025-… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to replica: server1 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.609636743Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server1' (Resultset: 1 rows in 76B)\n","stream":"stdout","time":"2025-10-30T04:09:42.610412119Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 22, type: sql::TYPE_BEGIN_TRX, stmt: START TRANSACTION\n","stream":"stdout","time":"2025-10-3… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.610457735Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Transaction starting on 'server2'\n","stream":"stdout","time":"2025-10-30T04:09:42.610463836Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (OK: 0 rows affected, 0 warnings)\n","stream":"stdout","time":"2025-10-30T04:09:42.610626752Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 27, type: sql::TYPE_READ, stmt: SELECT CONNECTION_ID()\n","stream":"stdout","time":"2025-10-3… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.610660966Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (Resultset: 1 rows in 76B)\n","stream":"stdout","time":"2025-10-30T04:09:42.610809926Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 1269, type: sql::TYPE_WRITE, stmt: INSERT INTO _temp_receipts_b08d87d7e16efff6 (rd,dt,nc,ac,k… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.610895817Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (OK: 2 rows affected, 0 warnings)\n","stream":"stdout","time":"2025-10-30T04:09:42.611149463Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 27, type: sql::TYPE_READ, stmt: SELECT CONNECTION_ID()\n","stream":"stdout","time":"2025-10-3… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.611192134Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (Resultset: 1 rows in 76B)\n","stream":"stdout","time":"2025-10-30T04:09:42.61133917Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 338, type: sql::TYPE_WRITE, stmt: UPDATE _temp_receipts_b08d87d7e16efff6\\n … {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.611374566Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (OK: 2 rows affected, 0 warnings)\n","stream":"stdout","time":"2025-10-30T04:09:42.611607553Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 27, type: sql::TYPE_READ, stmt: SELECT CONNECTION_ID()\n","stream":"stdout","time":"2025-10-3… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.611646266Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (Resultset: 1 rows in 76B)\n","stream":"stdout","time":"2025-10-30T04:09:42.611776751Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 1001, type: sql::TYPE_WRITE, stmt: UPDATE receipts r\\n INNER … {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.611825543Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (OK: 2 rows affected, 0 warnings)\n","stream":"stdout","time":"2025-10-30T04:09:42.612329529Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 27, type: sql::TYPE_READ, stmt: SELECT CONNECTION_ID()\n","stream":"stdout","time":"2025-10-3… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.612357151Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (Resultset: 1 rows in 76B)\n","stream":"stdout","time":"2025-10-30T04:09:42.612518083Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 936, type: sql::TYPE_WRITE, stmt: INSERT INTO receipts (rd,dt,nc,ac,kn,k,c,s,ss,crd,ka,ik,iu,… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.612579849Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (OK: 0 rows affected, 0 warnings)\n","stream":"stdout","time":"2025-10-30T04:09:42.612909658Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [open], cmd: (0x3) COM_QUERY, plen: 12, type: sql::TYPE_COMMIT, stmt: COMMIT \n","stream":"stdout","time":"2025-10-30T04:09:42.61… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.613013553Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (OK: 0 rows affected, 0 warnings, GTID 50-5511-43896945)\n","stream":"stdout","time":"2025-10-30T04:09:42.614260835Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Transaction complete on 'server2', 0B of SQL.\n","stream":"stdout","time":"2025-10-30T04:09:42.61426905Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [not open], cmd: (0x3) COM_QUERY, plen: 67, type: sql::TYPE_WRITE, stmt: DROP TEMPORARY TABLE IF EXISTS _temp_receipts_b08d87d7e1… {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2 \u003c\n","stream":"stdout","time":"2025-10-30T04:09:42.614353619Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Reply complete from 'server2' (OK: 0 rows affected, 0 warnings)\n","stream":"stdout","time":"2025-10-30T04:09:42.614613106Z"} {"log":"2025-10-30 04:09:42 info : (41586) (GaleraService); \u003e Autocommit: [enabled], trx is [not open], cmd: (0x1) COM_QUIT, plen: 5, type: N/A, stmt: \n","stream":"stdout","time":"2025-10-30T04:09:42.615135076Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Session write, routing to all servers.\n","stream":"stdout","time":"2025-10-30T04:09:42.615137691Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to replica: server1\n","stream":"stdout","time":"2025-10-30T04:09:42.615149633Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to primary: server2\n","stream":"stdout","time":"2025-10-30T04:09:42.61515342Z"} {"log":"2025-10-30 04:09:42 info : (41586) [readwritesplit] (GaleraService); Route query to replica: server3\n","stream":"stdout","time":"2025-10-30T04:09:42.615160905Z"} {"log":"2025-10-30 04:09:42 info : (41586) Stopped GaleraService client session [41586]\n","stream":"stdout","time":"2025-10-30T04:09:42.615243299Z"}