-- Logs begin at Fri 2021-01-29 03:38:15 UTC, end at Tue 2021-03-16 23:10:17 UTC. -- Mar 15 00:00:02 maxscale-staging-0 maxscale[1568995]: Log file flush following reception of SIGUSR1 Mar 15 00:00:02 maxscale-staging-0 maxscale[1568995]: Log rotation complete Mar 15 17:05:32 maxscale-staging-0 maxscale[1568995]: [mariadbmon] 'mariadb-monitor' acquired the exclusive lock on a majority of its servers. Automatic cluster manipulation operations such as failover will be enabled in 5 monitor ticks. Mar 15 17:21:13 maxscale-staging-0 systemd[1]: /lib/systemd/system/maxscale.service:15: PIDFile= references a path below legacy directory /var/run/, updating /var/run/maxscale/maxscale.pid → /run/maxscale/maxscale.pid; please update the unit file accordingly. Mar 15 17:21:14 maxscale-staging-0 systemd[1]: /lib/systemd/system/maxscale.service:15: PIDFile= references a path below legacy directory /var/run/, updating /var/run/maxscale/maxscale.pid → /run/maxscale/maxscale.pid; please update the unit file accordingly. Mar 15 17:21:14 maxscale-staging-0 systemd[1]: /lib/systemd/system/maxscale.service:15: PIDFile= references a path below legacy directory /var/run/, updating /var/run/maxscale/maxscale.pid → /run/maxscale/maxscale.pid; please update the unit file accordingly. Mar 15 17:21:14 maxscale-staging-0 systemd[1]: /lib/systemd/system/maxscale.service:15: PIDFile= references a path below legacy directory /var/run/, updating /var/run/maxscale/maxscale.pid → /run/maxscale/maxscale.pid; please update the unit file accordingly. Mar 15 17:21:15 maxscale-staging-0 systemd[1]: /lib/systemd/system/maxscale.service:15: PIDFile= references a path below legacy directory /var/run/, updating /var/run/maxscale/maxscale.pid → /run/maxscale/maxscale.pid; please update the unit file accordingly. Mar 15 17:21:20 maxscale-staging-0 systemd[1]: Stopping MariaDB MaxScale Database Proxy... Mar 15 17:21:20 maxscale-staging-0 maxscale[1568995]: Stopped MaxScale REST API Mar 15 17:21:20 maxscale-staging-0 maxscale[1568995]: MaxScale is shutting down. Mar 15 17:21:20 maxscale-staging-0 maxscale[1568995]: All workers have shut down. Mar 15 17:21:20 maxscale-staging-0 maxscale[1568995]: MaxScale shutdown completed. Mar 15 17:21:20 maxscale-staging-0 maxscale[1568995]: MaxScale received signal SIGTERM. Exiting. Mar 15 17:21:21 maxscale-staging-0 systemd[1]: maxscale.service: Succeeded. Mar 15 17:21:21 maxscale-staging-0 systemd[1]: Stopped MariaDB MaxScale Database Proxy. Mar 15 17:21:21 maxscale-staging-0 systemd[1]: /lib/systemd/system/maxscale.service:15: PIDFile= references a path below legacy directory /var/run/, updating /var/run/maxscale/maxscale.pid → /run/maxscale/maxscale.pid; please update the unit file accordingly. Mar 15 17:21:44 maxscale-staging-0 systemd[1]: /lib/systemd/system/maxscale.service:15: PIDFile= references a path below legacy directory /var/run/, updating /var/run/maxscale/maxscale.pid → /run/maxscale/maxscale.pid; please update the unit file accordingly. Mar 15 17:21:53 maxscale-staging-0 systemd[1]: /lib/systemd/system/maxscale.service:15: PIDFile= references a path below legacy directory /var/run/, updating /var/run/maxscale/maxscale.pid → /run/maxscale/maxscale.pid; please update the unit file accordingly. Mar 15 17:21:53 maxscale-staging-0 systemd[1]: /lib/systemd/system/maxscale.service:15: PIDFile= references a path below legacy directory /var/run/, updating /var/run/maxscale/maxscale.pid → /run/maxscale/maxscale.pid; please update the unit file accordingly. Mar 15 17:21:54 maxscale-staging-0 systemd[1]: /lib/systemd/system/maxscale.service:15: PIDFile= references a path below legacy directory /var/run/, updating /var/run/maxscale/maxscale.pid → /run/maxscale/maxscale.pid; please update the unit file accordingly. Mar 15 17:22:06 maxscale-staging-0 systemd[1]: Starting MariaDB MaxScale Database Proxy... Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: syslog logging is enabled. Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: maxlog logging is enabled. Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: The collection of SQLite memory allocation statistics turned off. Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Threading mode of SQLite set to Multi-thread. Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: The systemd watchdog is Enabled. Internal timeout = 30s Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Worker message queue size: 1MiB Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Using up to 1.17GiB of memory for query classifier cache Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Running OS: Linux@5.4.0-1034-gcp, #37-Ubuntu SMP Wed Jan 6 19:44:41 UTC 2021, x86_64 with 2 processor cores. Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Total usable main memory: 7.77GiB. Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: MariaDB MaxScale 2.5.9 started (Commit: f4a081d82c5b00a33a71f7ba209501ee9ab223d4) Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: MaxScale is running in process 3745612 Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Configuration file: /etc/maxscale.cnf Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Log directory: /var/log/maxscale Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Data directory: /var/lib/maxscale Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Module directory: /usr/lib/x86_64-linux-gnu/maxscale Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Service cache: /var/cache/maxscale Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Working directory: /var/log/maxscale Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Loaded module qc_sqlite: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libqc_sqlite.so Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Query classification results are cached and reused. Memory used per thread: 597.11MiB Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Using encrypted passwords. Encryption key read from '/var/lib/maxscale/.secrets'. Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes. Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Loading /etc/maxscale.cnf. Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: /etc/maxscale.cnf.d does not exist, not reading. Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Loaded module MariaDBClient: V1.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbclient.so Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Loaded module readwritesplit: V1.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libreadwritesplit.so Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Loaded module mariadbmon: V1.5.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbmon.so Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Loaded module qlafilter: V1.1.1 from /usr/lib/x86_64-linux-gnu/maxscale/libqlafilter.so Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: (mariadb-listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbauth.so Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Started REST API on [0.0.0.0]:8989 Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Journal file was created 311752 seconds ago. Maximum journal age is 28800 seconds. Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Removing stale journal file for monitor 'mariadb-monitor'. Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Server 'node_secondary-0' version: 10.5.6-MariaDB-1:10.5.6+maria~bionic-log Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Server 'node_primary-2' version: 10.5.6-MariaDB-1:10.5.6+maria~bionic-log Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Server 'node_primary-0' version: 10.5.6-MariaDB-1:10.5.6+maria~bionic-log Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Server 'node_primary-1' version: 10.5.6-MariaDB-1:10.5.6+maria~bionic-log Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Server 'node_secondary-1' version: 10.5.6-MariaDB-1:10.5.6+maria~bionic-log Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: [mariadbmon] Selecting new master server. Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: [mariadbmon] 'node_primary-0' is not a valid master candidate because it's not marked as master by the primary MaxScale. 'node_secondary-1' is not a valid master candidate because it's read_only. Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: [mariadbmon] Setting 'node_primary-1' as master. Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Server changed state: node_primary-0[db-staging-primary-0:3306]: server_up. [Down] -> [Running] Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Server changed state: node_primary-1[db-staging-primary-1:3306]: master_up. [Down] -> [Master, Running] Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Server changed state: node_primary-2[db-staging-primary-2:3306]: slave_up. [Down] -> [Slave, Running] Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Server changed state: node_secondary-0[db-staging-secondary-0:3306]: slave_up. [Down] -> [Slave, Running] Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Server changed state: node_secondary-1[db-staging-secondary-1:3306]: server_up. [Down] -> [Running] Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Starting a total of 2 services... Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: (mariadb-listener) Listening for connections at [::]:3306 Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Service 'mariadb-service' started (1/2) Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: (mariadb-reporting-listener) Listening for connections at [::]:3307 Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Service 'mariadb-reporting-service' started (2/2) Mar 15 17:22:06 maxscale-staging-0 systemd[1]: Started MariaDB MaxScale Database Proxy. Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Read 12 user@host entries from 'node_secondary-0' for service 'mariadb-reporting-service'. Mar 15 17:22:06 maxscale-staging-0 maxscale[3745612]: Read 12 user@host entries from 'node_primary-1' for service 'mariadb-service'. Mar 15 17:23:24 maxscale-staging-0 maxscale[3745612]: (12) [readwritesplit] (mariadb-service) 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 'mariadb-service'. To increase the limit (currently 500), add `max_sescmd_history` to the same service and increase the value. Mar 15 17:36:31 maxscale-staging-0 maxscale[3745612]: (541) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 17:36:31 maxscale-staging-0 maxscale[3745612]: (541) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (23642)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 17:35:39 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Running] state: [NOT_IN_USE] last opened at: [not opened] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 17:36:31 maxscale-staging-0 maxscale[3745612]: (541) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 17:36:48 maxscale-staging-0 maxscale[3745612]: (447) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.1.10. Could not find a valid master connection. Closing client connection. Mar 15 17:36:48 maxscale-staging-0 maxscale[3745612]: (447) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Detroit'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 08:00:00' and '2021-03-16 08:00:00') and (visitentit0_.business_id in (7314)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Detroit'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 17:32:28 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Running] state: [NOT_IN_USE] last opened at: [not opened] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 17:36:48 maxscale-staging-0 maxscale[3745612]: (447) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 17:36:51 maxscale-staging-0 maxscale[3745612]: (576) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 17:36:51 maxscale-staging-0 maxscale[3745612]: (576) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (23642)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 17:36:31 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Running] state: [NOT_IN_USE] last opened at: [not opened] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 17:36:51 maxscale-staging-0 maxscale[3745612]: (576) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 17:44:49 maxscale-staging-0 maxscale[3745612]: (702) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 17:44:49 maxscale-staging-0 maxscale[3745612]: (702) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Detroit'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 08:00:00' and '2021-03-16 08:00:00') and (visitentit0_.business_id in (7314)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Detroit'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 17:40:34 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Running] state: [NOT_IN_USE] last opened at: [not opened] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 17:44:49 maxscale-staging-0 maxscale[3745612]: (702) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 17:45:13 maxscale-staging-0 maxscale[3745612]: (760) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.1.10. Could not find a valid master connection. Closing client connection. Mar 15 17:45:13 maxscale-staging-0 maxscale[3745612]: (760) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (14602)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 17:42:19 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Running] state: [NOT_IN_USE] last opened at: [not opened] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 17:45:13 maxscale-staging-0 maxscale[3745612]: (760) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 17:46:47 maxscale-staging-0 maxscale[3745612]: Monitor was unable to connect to server node_primary-0[db-staging-primary-0:3306] : 'Can't connect to MySQL server on 'db-staging-primary-0' (115)' Mar 15 17:46:48 maxscale-staging-0 maxscale[3745612]: Server changed state: node_primary-0[db-staging-primary-0:3306]: server_down. [Running] -> [Down] Mar 15 17:48:14 maxscale-staging-0 maxscale[3745612]: (896) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.1.10. Could not find a valid master connection. Closing client connection. Mar 15 17:48:14 maxscale-staging-0 maxscale[3745612]: (896) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (11055)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 17:47:17 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Running] state: [NOT_IN_USE] last opened at: [not opened] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 17:48:14 maxscale-staging-0 maxscale[3745612]: (896) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 17:48:38 maxscale-staging-0 maxscale[3745612]: (800) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.2.240. Could not find a valid master connection. Closing client connection. Mar 15 17:48:38 maxscale-staging-0 maxscale[3745612]: (800) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (14602)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 17:43:55 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Running] state: [NOT_IN_USE] last opened at: [not opened] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 17:48:38 maxscale-staging-0 maxscale[3745612]: (800) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 17:48:39 maxscale-staging-0 maxscale[3745612]: (925) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.240.0.188. Could not find a valid master connection. Closing client connection. Mar 15 17:48:39 maxscale-staging-0 maxscale[3745612]: (925) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'US/Central'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (134)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'US/Central'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 17:47:43 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Running] state: [NOT_IN_USE] last opened at: [not opened] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 17:48:39 maxscale-staging-0 maxscale[3745612]: (925) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 17:49:01 maxscale-staging-0 maxscale[3745612]: (957) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.240.0.188. Could not find a valid master connection. Closing client connection. Mar 15 17:49:01 maxscale-staging-0 maxscale[3745612]: (957) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'US/Central'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (134)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'US/Central'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 17:48:40 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Running] state: [NOT_IN_USE] last opened at: [not opened] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 17:49:01 maxscale-staging-0 maxscale[3745612]: (957) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 18:03:35 maxscale-staging-0 maxscale[3745612]: (1258) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.2.240. Could not find a valid master connection. Closing client connection. Mar 15 18:03:35 maxscale-staging-0 maxscale[3745612]: (1258) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (7915)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 17:58:48 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Running] state: [NOT_IN_USE] last opened at: [not opened] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 18:03:35 maxscale-staging-0 maxscale[3745612]: (1258) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 18:15:47 maxscale-staging-0 maxscale[3745612]: (1775) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 18:15:47 maxscale-staging-0 maxscale[3745612]: (1775) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/New_York'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 08:00:00' and '2021-03-16 08:00:00') and (visitentit0_.business_id in (23643)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/New_York'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 18:15:15 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Running] state: [NOT_IN_USE] last opened at: [not opened] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 18:15:47 maxscale-staging-0 maxscale[3745612]: (1775) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 18:20:05 maxscale-staging-0 maxscale[3745612]: Monitor was unable to connect to server node_secondary-1[db-staging-secondary-1:3306] : 'Can't connect to MySQL server on 'db-staging-secondary-1' (115)' Mar 15 18:20:05 maxscale-staging-0 maxscale[3745612]: Server changed state: node_secondary-1[db-staging-secondary-1:3306]: server_down. [Running] -> [Down] Mar 15 18:20:16 maxscale-staging-0 maxscale[3745612]: Server 'node_secondary-1' charset: utf8mb4 Mar 15 18:20:16 maxscale-staging-0 maxscale[3745612]: Server changed state: node_secondary-1[db-staging-secondary-1:3306]: slave_up. [Down] -> [Slave, Running] Mar 15 18:22:18 maxscale-staging-0 maxscale[3745612]: (1950) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 18:22:18 maxscale-staging-0 maxscale[3745612]: (1950) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (8695)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 18:20:10 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [NOT_IN_USE] last opened at: [not opened] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 18:22:18 maxscale-staging-0 maxscale[3745612]: (1950) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 18:22:28 maxscale-staging-0 maxscale[3745612]: (2013) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.1.10. Could not find a valid master connection. Closing client connection. Mar 15 18:22:28 maxscale-staging-0 maxscale[3745612]: (2013) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (8675)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 18:21:53 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 18:21:53 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 18:22:28 maxscale-staging-0 maxscale[3745612]: (2013) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 18:22:46 maxscale-staging-0 maxscale[3745612]: (2019) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 18:22:46 maxscale-staging-0 maxscale[3745612]: (2019) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(purchaseen0_.created_at, 'UTC', 'America/Chicago'), '2021-02-14T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.created_at between '2021-02-14 06:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.business_id in (8675)) group by date_format(CONVERT_TZ(purchaseen0_.created_at, 'UTC', 'America/Chicago'), '2021-02-14T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 18:22:18 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 18:22:18 2021] last closed at: [not closed] last close reason: [] num sescmd: [1] Mar 15 18:22:46 maxscale-staging-0 maxscale[3745612]: (2019) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 18:23:38 maxscale-staging-0 maxscale[3745612]: (2024) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.1.10. Could not find a valid master connection. Closing client connection. Mar 15 18:23:38 maxscale-staging-0 maxscale[3745612]: (2024) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.current_ticket_group_id is not null) and (purchaseen0_.reporting_ticket_group_date between '2021-02-14' and '2021-03-15') and (CONVERT_TZ(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), 'America/Chicago', 'UTC') between '2021-02-14 06:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.created_at between '1970-01-01 00:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.business_id in (8675)) group by date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 18:22:28 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 18:22:28 2021] last closed at: [not closed] last close reason: [] num sescmd: [1] Mar 15 18:23:38 maxscale-staging-0 maxscale[3745612]: (2024) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 18:24:45 maxscale-staging-0 maxscale[3745612]: (2042) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.1.10. Could not find a valid master connection. Closing client connection. Mar 15 18:24:45 maxscale-staging-0 maxscale[3745612]: (2042) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-01T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.current_ticket_group_id is not null) and (purchaseen0_.reporting_ticket_group_date between '2021-02-01' and '2021-02-28') and (CONVERT_TZ(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), 'America/Chicago', 'UTC') between '2021-02-01 06:00:00' and '2021-03-01 05:59:59.999') and (purchaseen0_.created_at between '1970-01-01 00:00:00' and '2021-03-01 05:59:59.999') and (purchaseen0_.business_id in (8675)) group by date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-01T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 18:23:38 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 18:23:38 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 18:24:45 maxscale-staging-0 maxscale[3745612]: (2042) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 18:26:19 maxscale-staging-0 maxscale[3745612]: (2120) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 18:26:19 maxscale-staging-0 maxscale[3745612]: (2120) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.current_ticket_group_id is not null) and (purchaseen0_.reporting_ticket_group_date between '2021-02-14' and '2021-03-15') and (CONVERT_TZ(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), 'America/Chicago', 'UTC') between '2021-02-14 06:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.created_at between '1970-01-01 00:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.business_id in (8675)) group by date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 18:25:04 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 18:25:04 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 18:26:19 maxscale-staging-0 maxscale[3745612]: (2120) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 18:29:48 maxscale-staging-0 maxscale[3745612]: (2178) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.1.10. Could not find a valid master connection. Closing client connection. Mar 15 18:29:48 maxscale-staging-0 maxscale[3745612]: (2178) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (23625)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 18:26:46 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 18:26:46 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 18:29:48 maxscale-staging-0 maxscale[3745612]: (2178) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 18:33:52 maxscale-staging-0 maxscale[3745612]: (2346) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.1.10. Could not find a valid master connection. Closing client connection. Mar 15 18:33:52 maxscale-staging-0 maxscale[3745612]: (2346) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.current_ticket_group_id is not null) and (purchaseen0_.reporting_ticket_group_date between '2021-02-14' and '2021-03-15') and (CONVERT_TZ(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), 'America/Chicago', 'UTC') between '2021-02-14 06:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.created_at between '1970-01-01 00:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.business_id in (8675)) group by date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 18:31:43 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 18:31:43 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 18:33:52 maxscale-staging-0 maxscale[3745612]: (2346) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 18:37:59 maxscale-staging-0 maxscale[3745612]: (2447) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 18:37:59 maxscale-staging-0 maxscale[3745612]: (2447) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-01T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.current_ticket_group_id is not null) and (purchaseen0_.reporting_ticket_group_date between '2021-02-01' and '2021-02-14') and (CONVERT_TZ(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), 'America/Chicago', 'UTC') between '2021-02-01 06:00:00' and '2021-02-15 05:59:59.999') and (purchaseen0_.created_at between '1970-01-01 00:00:00' and '2021-02-15 05:59:59.999') and (purchaseen0_.business_id in (8675)) group by date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-01T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 18:34:55 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 18:34:55 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 18:37:59 maxscale-staging-0 maxscale[3745612]: (2447) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 18:38:01 maxscale-staging-0 maxscale[3745612]: (2521) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 18:38:01 maxscale-staging-0 maxscale[3745612]: (2521) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-01T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.current_ticket_group_id is not null) and (purchaseen0_.reporting_ticket_group_date between '2021-02-01' and '2021-02-28') and (CONVERT_TZ(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), 'America/Chicago', 'UTC') between '2021-02-01 06:00:00' and '2021-03-01 05:59:59.999') and (purchaseen0_.created_at between '1970-01-01 00:00:00' and '2021-03-01 05:59:59.999') and (purchaseen0_.business_id in (8675)) group by date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-01T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 18:37:59 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 18:37:59 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 18:38:01 maxscale-staging-0 maxscale[3745612]: (2521) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 18:42:55 maxscale-staging-0 maxscale[3745612]: (2595) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 18:42:55 maxscale-staging-0 maxscale[3745612]: (2595) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (14602)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 18:39:52 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 18:39:52 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 18:42:55 maxscale-staging-0 maxscale[3745612]: (2595) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 18:44:50 maxscale-staging-0 maxscale[3745612]: Monitor timed out when connecting to server node_secondary-1[db-staging-secondary-1:3306] : 'Lost connection to MySQL server at 'handshake: reading initial communication packet', system error: 110' Mar 15 18:44:50 maxscale-staging-0 maxscale[3745612]: Server changed state: node_secondary-1[db-staging-secondary-1:3306]: slave_down. [Slave, Running] -> [Down] Mar 15 18:45:09 maxscale-staging-0 maxscale[3745612]: Server changed state: node_secondary-1[db-staging-secondary-1:3306]: slave_up. [Down] -> [Slave, Running] Mar 15 18:46:18 maxscale-staging-0 maxscale[3745612]: (2677) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.2.240. Could not find a valid master connection. Closing client connection. Mar 15 18:46:18 maxscale-staging-0 maxscale[3745612]: (2677) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (14602)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 18:43:13 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [NOT_IN_USE] last opened at: [Mon Mar 15 18:43:13 2021] last closed at: [Mon Mar 15 18:44:50 2021] last close reason: [Slave connection failed: #HY000: Lost connection to backend server: connection closed by peer (node_secondary-1: Generated event)] num sescmd: [0] Mar 15 18:46:18 maxscale-staging-0 maxscale[3745612]: (2677) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 18:49:47 maxscale-staging-0 maxscale[3745612]: (2748) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 18:49:47 maxscale-staging-0 maxscale[3745612]: (2748) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (7915)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 18:44:57 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [NOT_IN_USE] last opened at: [not opened] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 18:49:47 maxscale-staging-0 maxscale[3745612]: (2748) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 19:10:35 maxscale-staging-0 maxscale[3745612]: (3536) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.240.0.188. Could not find a valid master connection. Closing client connection. Mar 15 19:10:35 maxscale-staging-0 maxscale[3745612]: (3536) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-01T00:00') as col_0_0_, sum(paymentent2_.amount_charged_cents) as col_1_0_ from purchase purchaseen0_ inner join payment_purchase payments1_ on purchaseen0_.id=payments1_.purchase_id inner join payment paymentent2_ on payments1_.payment_id=paymentent2_.id where (purchaseen0_.reporting_ticket_group_date between '2021-02-01' and '2021-02-28') and (CONVERT_TZ(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), 'US/Pacific', 'UTC') between '2021-02-01 08:00:00' and '2021-03-01 07:59:59.999') and (purchaseen0_.business_id in (156)) group by date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-01T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 19:10:31 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 19:10:31 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 19:10:35 maxscale-staging-0 maxscale[3745612]: (3536) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 19:12:35 maxscale-staging-0 maxscale[3745612]: (3622) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.240.0.188. Could not find a valid master connection. Closing client connection. Mar 15 19:12:35 maxscale-staging-0 maxscale[3745612]: (3622) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-01T00:00') as col_0_0_, sum(paymentent2_.amount_charged_cents) as col_1_0_ from purchase purchaseen0_ inner join payment_purchase payments1_ on purchaseen0_.id=payments1_.purchase_id inner join payment paymentent2_ on payments1_.payment_id=paymentent2_.id where (purchaseen0_.reporting_ticket_group_date between '2021-02-01' and '2021-02-28') and (CONVERT_TZ(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), 'US/Pacific', 'UTC') between '2021-02-01 08:00:00' and '2021-03-01 07:59:59.999') and (purchaseen0_.business_id in (156)) group by date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-01T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 19:12:31 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 19:12:31 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 19:12:35 maxscale-staging-0 maxscale[3745612]: (3622) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 19:13:28 maxscale-staging-0 maxscale[3745612]: (3644) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.240.0.188. Could not find a valid master connection. Closing client connection. Mar 15 19:13:28 maxscale-staging-0 maxscale[3745612]: (3644) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-01T00:00') as col_0_0_, sum(paymentent2_.amount_charged_cents) as col_1_0_ from purchase purchaseen0_ inner join payment_purchase payments1_ on purchaseen0_.id=payments1_.purchase_id inner join payment paymentent2_ on payments1_.payment_id=paymentent2_.id where (purchaseen0_.reporting_ticket_group_date between '2021-02-01' and '2021-02-28') and (CONVERT_TZ(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), 'US/Pacific', 'UTC') between '2021-02-01 08:00:00' and '2021-03-01 07:59:59.999') and (purchaseen0_.business_id in (156)) group by date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-01T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 19:13:14 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 19:13:14 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 19:13:28 maxscale-staging-0 maxscale[3745612]: (3644) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 19:22:39 maxscale-staging-0 maxscale[3745612]: (3835) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 19:22:39 maxscale-staging-0 maxscale[3745612]: (3835) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (7915)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 19:19:08 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 19:19:08 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 19:22:39 maxscale-staging-0 maxscale[3745612]: (3835) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 19:40:26 maxscale-staging-0 maxscale[3745612]: (4399) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.2.240. Could not find a valid master connection. Closing client connection. Mar 15 19:40:26 maxscale-staging-0 maxscale[3745612]: (4399) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (14602)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 19:37:29 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 19:37:29 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 19:40:26 maxscale-staging-0 maxscale[3745612]: (4399) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 19:44:27 maxscale-staging-0 maxscale[3745612]: (4590) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 19:44:27 maxscale-staging-0 maxscale[3745612]: (4590) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (7915)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 19:43:44 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 19:43:44 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 19:44:27 maxscale-staging-0 maxscale[3745612]: (4590) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:11:15 maxscale-staging-0 maxscale[3745612]: (5451) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.1.10. Could not find a valid master connection. Closing client connection. Mar 15 20:11:15 maxscale-staging-0 maxscale[3745612]: (5451) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'US/Central'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (134)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'US/Central'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:10:34 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 20:10:34 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 20:11:15 maxscale-staging-0 maxscale[3745612]: (5451) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:11:22 maxscale-staging-0 maxscale[3745612]: (5374) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 20:11:22 maxscale-staging-0 maxscale[3745612]: (5374) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (7915)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:08:26 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 20:08:26 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 20:11:22 maxscale-staging-0 maxscale[3745612]: (5374) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:11:31 maxscale-staging-0 maxscale[3745612]: (5472) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 20:11:31 maxscale-staging-0 maxscale[3745612]: (5472) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (7915)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:11:22 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 20:11:22 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 20:11:31 maxscale-staging-0 maxscale[3745612]: (5472) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:11:33 maxscale-staging-0 maxscale[3745612]: (5476) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 20:11:33 maxscale-staging-0 maxscale[3745612]: (5476) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(purchaseen0_.created_at, 'UTC', 'America/Chicago'), '2021-02-14T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.created_at between '2021-02-14 06:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.business_id in (7915)) group by date_format(CONVERT_TZ(purchaseen0_.created_at, 'UTC', 'America/Chicago'), '2021-02-14T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:11:31 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 20:11:31 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 20:11:33 maxscale-staging-0 maxscale[3745612]: (5476) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:11:59 maxscale-staging-0 maxscale[3745612]: (5478) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 20:11:59 maxscale-staging-0 maxscale[3745612]: (5478) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(purchaseen0_.created_at, 'UTC', 'America/Chicago'), '2021-02-14T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.created_at between '2021-02-14 06:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.business_id in (7915)) group by date_format(CONVERT_TZ(purchaseen0_.created_at, 'UTC', 'America/Chicago'), '2021-02-14T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:11:33 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 20:11:33 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 20:11:59 maxscale-staging-0 maxscale[3745612]: (5478) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:12:18 maxscale-staging-0 maxscale[3745612]: (5489) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 20:12:18 maxscale-staging-0 maxscale[3745612]: (5489) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.current_ticket_group_id is not null) and (purchaseen0_.reporting_ticket_group_date between '2021-02-14' and '2021-03-15') and (CONVERT_TZ(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), 'America/Chicago', 'UTC') between '2021-02-14 06:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.created_at between '1970-01-01 00:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.business_id in (7915)) group by date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:11:59 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 20:11:59 2021] last closed at: [not closed] last close reason: [] num sescmd: [1] Mar 15 20:12:18 maxscale-staging-0 maxscale[3745612]: (5489) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:16:09 maxscale-staging-0 maxscale[3745612]: (5494) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.2.240. Could not find a valid master connection. Closing client connection. Mar 15 20:16:09 maxscale-staging-0 maxscale[3745612]: (5494) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.current_ticket_group_id is not null) and (purchaseen0_.reporting_ticket_group_date between '2021-02-14' and '2021-03-15') and (CONVERT_TZ(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), 'America/Chicago', 'UTC') between '2021-02-14 06:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.created_at between '1970-01-01 00:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.business_id in (7915)) group by date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00')), closing connection. name: [node_secondary-0] status: [Maintenance, Running] state: [NOT_IN_USE] last opened at: [Mon Mar 15 20:12:09 2021] last closed at: [Mon Mar 15 20:16:09 2021] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:12:09 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 20:16:09 maxscale-staging-0 maxscale[3745612]: (5494) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:16:15 maxscale-staging-0 maxscale[3745612]: (5615) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.1.10. Could not find a valid master connection. Closing client connection. Mar 15 20:16:15 maxscale-staging-0 maxscale[3745612]: (5615) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.current_ticket_group_id is not null) and (purchaseen0_.reporting_ticket_group_date between '2021-02-14' and '2021-03-15') and (CONVERT_TZ(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), 'America/Chicago', 'UTC') between '2021-02-14 06:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.created_at between '1970-01-01 00:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.business_id in (7915)) group by date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00')), closing connection. name: [node_secondary-0] status: [Maintenance, Running] state: [NOT_IN_USE] last opened at: [Mon Mar 15 20:15:32 2021] last closed at: [Mon Mar 15 20:16:15 2021] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:15:32 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 20:16:15 maxscale-staging-0 maxscale[3745612]: (5615) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:16:36 maxscale-staging-0 maxscale[3745612]: (5634) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.1.10. Could not find a valid master connection. Closing client connection. Mar 15 20:16:36 maxscale-staging-0 maxscale[3745612]: (5634) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.current_ticket_group_id is not null) and (purchaseen0_.reporting_ticket_group_date between '2021-02-14' and '2021-03-15') and (CONVERT_TZ(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), 'America/Chicago', 'UTC') between '2021-02-14 06:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.created_at between '1970-01-01 00:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.business_id in (7915)) group by date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:16:36 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Maintenance, Running] state: [NOT_IN_USE] last opened at: [Mon Mar 15 20:16:15 2021] last closed at: [Mon Mar 15 20:16:36 2021] last close reason: [] num sescmd: [0] Mar 15 20:16:36 maxscale-staging-0 maxscale[3745612]: (5634) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:17:01 maxscale-staging-0 maxscale[3745612]: (5542) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.220. Could not find a valid master connection. Closing client connection. Mar 15 20:17:01 maxscale-staging-0 maxscale[3745612]: (5542) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.current_ticket_group_id is not null) and (purchaseen0_.reporting_ticket_group_date between '2021-02-14' and '2021-03-15') and (CONVERT_TZ(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), 'America/Chicago', 'UTC') between '2021-02-14 06:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.created_at between '1970-01-01 00:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.business_id in (7915)) group by date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:13:22 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Maintenance, Running] state: [NOT_IN_USE] last opened at: [Mon Mar 15 20:13:22 2021] last closed at: [Mon Mar 15 20:17:01 2021] last close reason: [] num sescmd: [0] Mar 15 20:17:01 maxscale-staging-0 maxscale[3745612]: (5542) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:20:24 maxscale-staging-0 maxscale[3745612]: (5658) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.2.240. Could not find a valid master connection. Closing client connection. Mar 15 20:20:24 maxscale-staging-0 maxscale[3745612]: (5658) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.current_ticket_group_id is not null) and (purchaseen0_.reporting_ticket_group_date between '2021-02-14' and '2021-03-15') and (CONVERT_TZ(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), 'America/Chicago', 'UTC') between '2021-02-14 06:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.created_at between '1970-01-01 00:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.business_id in (7915)) group by date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:17:03 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [NOT_IN_USE] last opened at: [not opened] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 20:20:24 maxscale-staging-0 maxscale[3745612]: (5658) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:21:19 maxscale-staging-0 maxscale[3745612]: [mariadbmon] Error during monitor update of server 'node_secondary-1': Query 'SELECT @@global.server_id, @@read_only, @@global.gtid_domain_id;' failed: 'Lost connection to MySQL server at 'handshake: reading initial communication packet', system error: 104'. Mar 15 20:21:19 maxscale-staging-0 maxscale[3745612]: Monitor was unable to connect to server node_secondary-1[db-staging-secondary-1:3306] : 'Can't connect to MySQL server on 'db-staging-secondary-1' (115)' Mar 15 20:21:19 maxscale-staging-0 maxscale[3745612]: Server changed state: node_secondary-1[db-staging-secondary-1:3306]: slave_down. [Slave, Running] -> [Down] Mar 15 20:21:32 maxscale-staging-0 maxscale[3745612]: Server changed state: node_secondary-1[db-staging-secondary-1:3306]: slave_up. [Down] -> [Slave, Running] Mar 15 20:23:47 maxscale-staging-0 maxscale[3745612]: (5819) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.2.240. Could not find a valid master connection. Closing client connection. Mar 15 20:23:47 maxscale-staging-0 maxscale[3745612]: (5819) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (25398)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:21:58 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 20:21:58 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 20:23:47 maxscale-staging-0 maxscale[3745612]: (5819) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:24:14 maxscale-staging-0 maxscale[3745612]: (5781) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.1.10. Could not find a valid master connection. Closing client connection. Mar 15 20:24:14 maxscale-staging-0 maxscale[3745612]: (5781) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (23625)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:20:26 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [NOT_IN_USE] last opened at: [Mon Mar 15 20:20:26 2021] last closed at: [Mon Mar 15 20:21:19 2021] last close reason: [Slave connection failed: #HY000: Lost connection to backend server: connection closed by peer (node_secondary-1)] num sescmd: [0] Mar 15 20:24:14 maxscale-staging-0 maxscale[3745612]: (5781) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:28:35 maxscale-staging-0 maxscale[3745612]: (5941) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.1.10. Could not find a valid master connection. Closing client connection. Mar 15 20:28:35 maxscale-staging-0 maxscale[3745612]: (5941) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (23642)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:25:24 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 20:25:24 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 20:28:35 maxscale-staging-0 maxscale[3745612]: (5941) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:30:20 maxscale-staging-0 maxscale[3745612]: (6084) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.2.241. Could not find a valid master connection. Closing client connection. Mar 15 20:30:20 maxscale-staging-0 maxscale[3745612]: (6084) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.current_ticket_group_id is not null) and (purchaseen0_.reporting_ticket_group_date between '2021-02-14' and '2021-03-15') and (CONVERT_TZ(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), 'America/Chicago', 'UTC') between '2021-02-14 06:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.created_at between '1970-01-01 00:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.business_id in (7915)) group by date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:29:49 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:29:49 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 20:30:20 maxscale-staging-0 maxscale[3745612]: (6084) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:32:15 maxscale-staging-0 maxscale[3745612]: (6116) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.2.241. Could not find a valid master connection. Closing client connection. Mar 15 20:32:15 maxscale-staging-0 maxscale[3745612]: (6116) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.current_ticket_group_id is not null) and (purchaseen0_.reporting_ticket_group_date between '2021-02-14' and '2021-03-15') and (CONVERT_TZ(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), 'America/Chicago', 'UTC') between '2021-02-14 06:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.created_at between '1970-01-01 00:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.business_id in (7915)) group by date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:30:20 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 20:30:20 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 20:32:15 maxscale-staging-0 maxscale[3745612]: (6116) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:39:51 maxscale-staging-0 maxscale[3745612]: (6278) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.221. Could not find a valid master connection. Closing client connection. Mar 15 20:39:51 maxscale-staging-0 maxscale[3745612]: (6278) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.current_ticket_group_id is not null) and (purchaseen0_.reporting_ticket_group_date between '2021-02-14' and '2021-03-15') and (CONVERT_TZ(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), 'America/Chicago', 'UTC') between '2021-02-14 06:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.created_at between '1970-01-01 00:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.business_id in (7915)) group by date_format(timestamp(purchaseen0_.reporting_ticket_group_date, purchaseen0_.reporting_start_time), '2021-02-14T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:35:26 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:35:26 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 20:39:51 maxscale-staging-0 maxscale[3745612]: (6278) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:47:18 maxscale-staging-0 maxscale[3745612]: (6642) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.1.11. Could not find a valid master connection. Closing client connection. Mar 15 20:47:18 maxscale-staging-0 maxscale[3745612]: (6642) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (23625)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Maintenance, Running] state: [NOT_IN_USE] last opened at: [not opened] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:47:06 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 20:47:18 maxscale-staging-0 maxscale[3745612]: (6642) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:49:58 maxscale-staging-0 maxscale[3745612]: (6579) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.221. Could not find a valid master connection. Closing client connection. Mar 15 20:49:58 maxscale-staging-0 maxscale[3745612]: (6579) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (7915)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Maintenance, Running] state: [NOT_IN_USE] last opened at: [not opened] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:45:18 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 20:49:58 maxscale-staging-0 maxscale[3745612]: (6579) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:53:43 maxscale-staging-0 maxscale[3745612]: (6812) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.1.11. Could not find a valid master connection. Closing client connection. Mar 15 20:53:43 maxscale-staging-0 maxscale[3745612]: (6812) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/New_York'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 08:00:00' and '2021-03-16 08:00:00') and (visitentit0_.business_id in (20255)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/New_York'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 20:52:02 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 20:52:02 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 20:53:43 maxscale-staging-0 maxscale[3745612]: (6812) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 20:58:48 maxscale-staging-0 maxscale[3745612]: [mariadbmon] Failed to update lock status of server 'node_secondary-1'. Query 'SELECT IS_USED_LOCK('maxscale_mariadbmonitor'), IS_USED_LOCK('maxscale_mariadbmonitor_master');' failed: 'Can't connect to MySQL server on 'db-staging-secondary-1' (115)'. Mar 15 20:58:48 maxscale-staging-0 maxscale[3745612]: [mariadbmon] Error during monitor update of server 'node_secondary-1': Query 'SELECT @@global.server_id, @@read_only, @@global.gtid_domain_id;' failed: 'Can't connect to MySQL server on 'db-staging-secondary-1' (115)'. Mar 15 20:58:48 maxscale-staging-0 maxscale[3745612]: Monitor was unable to connect to server node_secondary-1[db-staging-secondary-1:3306] : 'Can't connect to MySQL server on 'db-staging-secondary-1' (115)' Mar 15 20:58:48 maxscale-staging-0 maxscale[3745612]: Server changed state: node_secondary-1[db-staging-secondary-1:3306]: slave_down. [Slave, Running] -> [Down] Mar 15 20:58:57 maxscale-staging-0 maxscale[3745612]: Server changed state: node_secondary-1[db-staging-secondary-1:3306]: slave_up. [Down] -> [Slave, Running] Mar 15 21:07:44 maxscale-staging-0 maxscale[3745612]: (7283) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.1.11. Could not find a valid master connection. Closing client connection. Mar 15 21:07:44 maxscale-staging-0 maxscale[3745612]: (7283) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (7915)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 21:06:43 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 21:06:43 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 15 21:07:44 maxscale-staging-0 maxscale[3745612]: (7283) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 21:17:07 maxscale-staging-0 maxscale[3745612]: Server 'node_primary-0' charset: utf8mb4 Mar 15 21:17:08 maxscale-staging-0 maxscale[3745612]: Server changed state: node_primary-0[db-staging-primary-0:3306]: slave_up. [Down] -> [Slave, Running] Mar 15 21:43:11 maxscale-staging-0 maxscale[3745612]: (8357) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.2.242. Could not find a valid master connection. Closing client connection. Mar 15 21:43:11 maxscale-staging-0 maxscale[3745612]: (8357) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (23642)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 21:38:36 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 21:38:36 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 21:43:11 maxscale-staging-0 maxscale[3745612]: (8357) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 21:45:43 maxscale-staging-0 maxscale[3745612]: (8504) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.2.242. Could not find a valid master connection. Closing client connection. Mar 15 21:45:43 maxscale-staging-0 maxscale[3745612]: (8504) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (7915)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 21:43:31 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 21:43:31 2021] last closed at: [not closed] last close reason: [] num sescmd: [1] Mar 15 21:45:43 maxscale-staging-0 maxscale[3745612]: (8504) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 21:45:46 maxscale-staging-0 maxscale[3745612]: (8446) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.12.0.222. Could not find a valid master connection. Closing client connection. Mar 15 21:45:46 maxscale-staging-0 maxscale[3745612]: (8446) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(purchaseen0_.created_at, 'UTC', 'America/Chicago'), '2021-02-14T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.created_at between '2021-02-14 06:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.business_id in (7915)) group by date_format(CONVERT_TZ(purchaseen0_.created_at, 'UTC', 'America/Chicago'), '2021-02-14T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 21:42:00 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 21:42:00 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 21:45:46 maxscale-staging-0 maxscale[3745612]: (8446) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 22:07:14 maxscale-staging-0 maxscale[3745612]: (9191) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.124.1.73. Could not find a valid master connection. Closing client connection. Mar 15 22:07:14 maxscale-staging-0 maxscale[3745612]: (9191) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (11055)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 22:06:18 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 22:06:18 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 22:07:14 maxscale-staging-0 maxscale[3745612]: (9191) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 22:08:24 maxscale-staging-0 maxscale[3745612]: (9221) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.124.1.73. Could not find a valid master connection. Closing client connection. Mar 15 22:08:24 maxscale-staging-0 maxscale[3745612]: (9221) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (24415)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 22:07:14 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 22:07:14 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 22:08:24 maxscale-staging-0 maxscale[3745612]: (9221) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 22:10:01 maxscale-staging-0 maxscale[3745612]: (9263) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.124.1.73. Could not find a valid master connection. Closing client connection. Mar 15 22:10:01 maxscale-staging-0 maxscale[3745612]: (9263) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(purchaseen0_.created_at, 'UTC', 'America/Chicago'), '2021-02-14T00:00') as col_0_0_, count(distinct purchaseen0_.id) as col_1_0_ from purchase purchaseen0_ where (purchaseen0_.next_purchase_id is null) and (purchaseen0_.created_at between '2021-02-14 06:00:00' and '2021-03-16 04:59:59.999') and (purchaseen0_.business_id in (24415)) group by date_format(CONVERT_TZ(purchaseen0_.created_at, 'UTC', 'America/Chicago'), '2021-02-14T00:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 22:08:24 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 22:08:24 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] Mar 15 22:10:01 maxscale-staging-0 maxscale[3745612]: (9263) [mariadbclient] Routing the query failed. Session will be closed. Mar 15 23:07:36 maxscale-staging-0 maxscale[3745612]: (10830) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.124.1.73. Could not find a valid master connection. Closing client connection. Mar 15 23:07:36 maxscale-staging-0 maxscale[3745612]: (10830) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-15 09:00:00' and '2021-03-16 09:00:00') and (visitentit0_.business_id in (24415)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-15T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Mon Mar 15 23:05:40 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Mon Mar 15 23:05:40 2021] last closed at: [not closed] last close reason: [] num sescmd: [1] Mar 15 23:07:36 maxscale-staging-0 maxscale[3745612]: (10830) [mariadbclient] Routing the query failed. Session will be closed. Mar 16 00:00:06 maxscale-staging-0 maxscale[3745612]: Log file flush following reception of SIGUSR1 Mar 16 00:00:06 maxscale-staging-0 maxscale[3745612]: Log rotation complete Mar 16 14:48:28 maxscale-staging-0 maxscale[3745612]: (34153) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.124.1.73. Could not find a valid master connection. Closing client connection. Mar 16 14:48:29 maxscale-staging-0 maxscale[3745612]: (34153) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-16T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-16 09:00:00' and '2021-03-17 09:00:00') and (visitentit0_.business_id in (25981)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-16T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Tue Mar 16 14:43:49 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Tue Mar 16 14:43:49 2021] last closed at: [not closed] last close reason: [] num sescmd: [1] Mar 16 14:48:29 maxscale-staging-0 maxscale[3745612]: (34153) [mariadbclient] Routing the query failed. Session will be closed. Mar 16 14:52:45 maxscale-staging-0 maxscale[3745612]: (34276) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.124.1.73. Could not find a valid master connection. Closing client connection. Mar 16 14:52:45 maxscale-staging-0 maxscale[3745612]: (34276) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: select date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-16T04:00') as col_0_0_, sum(visitsumma1_.num_people_present) as col_1_0_ from visit visitentit0_ inner join visit_summary_party_snapshot visitsumma1_ on visitentit0_.current_snapshot_event_id=visitsumma1_.event_id and visitentit0_.current_snapshot_visit_id=visitsumma1_.visit_id left outer join purchase purchaseen2_ on visitentit0_.current_purchase_id=purchaseen2_.id where ((visitsumma1_.arrival_time is not null) and visitsumma1_.removed_from_service=0 or (visitentit0_.current_purchase_id is not null) and (purchaseen2_.next_purchase_id is null)) and (coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time) between '2021-03-16 09:00:00' and '2021-03-17 09:00:00') and (visitentit0_.business_id in (25981)) and (case when visitentit0_.walk_in_id is not null then 1 else 0 end in (1)) and (cast(visitsumma1_.primary_state_enum as signed) not in (0 , 1 , 5 , 6)) group by date_format(CONVERT_TZ(coalesce(visitsumma1_.seated_time, visitsumma1_.arrival_time), 'UTC', 'America/Chicago'), '2021-03-16T04:00')), closing connection. name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Tue Mar 16 14:48:16 2021] last closed at: [not closed] last close reason: [] num sescmd: [0] name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Tue Mar 16 14:48:16 2021] last closed at: [not closed] last close reason: [] num sescmd: [2] Mar 16 14:52:45 maxscale-staging-0 maxscale[3745612]: (34276) [mariadbclient] Routing the query failed. Session will be closed. Mar 16 17:22:07 maxscale-staging-0 maxscale[3745612]: Read 13 user@host entries from 'node_primary-1' for service 'mariadb-service'. Mar 16 18:35:33 maxscale-staging-0 maxscale[3745612]: [mariadbmon] Failed to update lock status of server 'node_secondary-1'. Query 'SELECT IS_USED_LOCK('maxscale_mariadbmonitor'), IS_USED_LOCK('maxscale_mariadbmonitor_master');' failed: 'Lost connection to MySQL server at 'handshake: reading initial communication packet', system error: 110'. Mar 16 18:35:39 maxscale-staging-0 maxscale[3745612]: [mariadbmon] Error during monitor update of server 'node_secondary-1': Query 'SELECT @@global.server_id, @@read_only, @@global.gtid_domain_id;' failed: 'Lost connection to MySQL server at 'handshake: reading initial communication packet', system error: 110'. Mar 16 18:35:49 maxscale-staging-0 maxscale[3745612]: Monitor timed out when connecting to server node_secondary-1[db-staging-secondary-1:3306] : 'Lost connection to MySQL server at 'handshake: reading initial communication packet', system error: 110' Mar 16 18:35:49 maxscale-staging-0 maxscale[3745612]: Server changed state: node_secondary-1[db-staging-secondary-1:3306]: slave_down. [Slave, Running] -> [Down] Mar 16 18:36:47 maxscale-staging-0 maxscale[3745612]: Server changed state: node_secondary-1[db-staging-secondary-1:3306]: slave_up. [Down] -> [Slave, Running] Mar 16 19:02:48 maxscale-staging-0 maxscale[3745612]: Monitor was unable to connect to server node_secondary-1[db-staging-secondary-1:3306] : 'Can't connect to MySQL server on 'db-staging-secondary-1' (115)' Mar 16 19:02:48 maxscale-staging-0 maxscale[3745612]: Server changed state: node_secondary-1[db-staging-secondary-1:3306]: slave_down. [Slave, Running] -> [Down] Mar 16 19:02:57 maxscale-staging-0 maxscale[3745612]: Server changed state: node_secondary-1[db-staging-secondary-1:3306]: slave_up. [Down] -> [Slave, Running] Mar 16 19:27:40 maxscale-staging-0 maxscale[3745612]: [mariadbmon] Failed to update lock status of server 'node_secondary-1'. Query 'SELECT IS_USED_LOCK('maxscale_mariadbmonitor'), IS_USED_LOCK('maxscale_mariadbmonitor_master');' failed: 'Lost connection to MySQL server at 'handshake: reading initial communication packet', system error: 11'. Mar 16 19:27:41 maxscale-staging-0 maxscale[3745612]: [mariadbmon] Error during monitor update of server 'node_secondary-1': Query 'SELECT @@global.server_id, @@read_only, @@global.gtid_domain_id;' failed: 'Can't connect to MySQL server on 'db-staging-secondary-1' (115)'. Mar 16 19:27:41 maxscale-staging-0 maxscale[3745612]: Monitor was unable to connect to server node_secondary-1[db-staging-secondary-1:3306] : 'Can't connect to MySQL server on 'db-staging-secondary-1' (115)' Mar 16 19:27:41 maxscale-staging-0 maxscale[3745612]: Server changed state: node_secondary-1[db-staging-secondary-1:3306]: slave_down. [Slave, Running] -> [Down] Mar 16 19:27:52 maxscale-staging-0 maxscale[3745612]: Server changed state: node_secondary-1[db-staging-secondary-1:3306]: slave_up. [Down] -> [Slave, Running] Mar 16 20:45:00 maxscale-staging-0 maxscale[3745612]: Monitor timed out when connecting to server node_secondary-1[db-staging-secondary-1:3306] : 'Lost connection to MySQL server at 'handshake: reading initial communication packet', system error: 110' Mar 16 20:45:00 maxscale-staging-0 maxscale[3745612]: Server changed state: node_secondary-1[db-staging-secondary-1:3306]: slave_down. [Slave, Running] -> [Down] Mar 16 20:47:35 maxscale-staging-0 maxscale[3745612]: Server changed state: node_secondary-1[db-staging-secondary-1:3306]: slave_up. [Down] -> [Slave, Running] Mar 16 20:50:11 maxscale-staging-0 systemd[1]: Stopping MariaDB MaxScale Database Proxy... Mar 16 20:50:11 maxscale-staging-0 maxscale[3745612]: Stopped MaxScale REST API Mar 16 20:50:12 maxscale-staging-0 maxscale[3745612]: MaxScale is shutting down. Mar 16 20:50:12 maxscale-staging-0 maxscale[3745612]: All workers have shut down. Mar 16 20:50:12 maxscale-staging-0 maxscale[3745612]: MaxScale shutdown completed. Mar 16 20:50:12 maxscale-staging-0 maxscale[3745612]: MaxScale received signal SIGTERM. Exiting. Mar 16 20:50:12 maxscale-staging-0 systemd[1]: maxscale.service: Succeeded. Mar 16 20:50:12 maxscale-staging-0 systemd[1]: Stopped MariaDB MaxScale Database Proxy. Mar 16 20:50:12 maxscale-staging-0 systemd[1]: Starting MariaDB MaxScale Database Proxy... Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: syslog logging is enabled. Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: maxlog logging is enabled. Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: The collection of SQLite memory allocation statistics turned off. Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Threading mode of SQLite set to Multi-thread. Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: The systemd watchdog is Enabled. Internal timeout = 30s Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Worker message queue size: 1MiB Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Using up to 1.17GiB of memory for query classifier cache Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Running OS: Linux@5.4.0-1034-gcp, #37-Ubuntu SMP Wed Jan 6 19:44:41 UTC 2021, x86_64 with 2 processor cores. Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Total usable main memory: 7.77GiB. Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: MariaDB MaxScale 2.5.9 started (Commit: f4a081d82c5b00a33a71f7ba209501ee9ab223d4) Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: MaxScale is running in process 3835388 Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Configuration file: /etc/maxscale.cnf Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Log directory: /var/log/maxscale Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Data directory: /var/lib/maxscale Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Module directory: /usr/lib/x86_64-linux-gnu/maxscale Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Service cache: /var/cache/maxscale Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Working directory: /var/log/maxscale Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Loaded module qc_sqlite: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libqc_sqlite.so Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Query classification results are cached and reused. Memory used per thread: 597.11MiB Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Using encrypted passwords. Encryption key read from '/var/lib/maxscale/.secrets'. Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes. Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Loading /etc/maxscale.cnf. Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: /etc/maxscale.cnf.d does not exist, not reading. Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Loaded module MariaDBClient: V1.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbclient.so Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Loaded module readwritesplit: V1.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libreadwritesplit.so Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Loaded module mariadbmon: V1.5.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbmon.so Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Loaded module qlafilter: V1.1.1 from /usr/lib/x86_64-linux-gnu/maxscale/libqlafilter.so Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: (mariadb-listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmariadbauth.so Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Started REST API on [0.0.0.0]:8989 Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Server 'node_primary-2' version: 10.5.6-MariaDB-1:10.5.6+maria~bionic-log Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Server 'node_primary-0' version: 10.5.6-MariaDB-1:10.5.6+maria~bionic-log Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Server 'node_secondary-0' version: 10.5.6-MariaDB-1:10.5.6+maria~bionic-log Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Server 'node_primary-1' version: 10.5.6-MariaDB-1:10.5.6+maria~bionic-log Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Server 'node_secondary-1' version: 10.5.6-MariaDB-1:10.5.6+maria~bionic-log Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Starting a total of 2 services... Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: (mariadb-listener) Listening for connections at [::]:3306 Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Service 'mariadb-service' started (1/2) Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: (mariadb-reporting-listener) Listening for connections at [::]:3307 Mar 16 20:50:12 maxscale-staging-0 maxscale[3835388]: Service 'mariadb-reporting-service' started (2/2) Mar 16 20:50:12 maxscale-staging-0 systemd[1]: Started MariaDB MaxScale Database Proxy. Mar 16 20:50:13 maxscale-staging-0 maxscale[3835388]: Read 13 user@host entries from 'node_primary-1' for service 'mariadb-service'. Mar 16 20:50:13 maxscale-staging-0 maxscale[3835388]: Read 12 user@host entries from 'node_secondary-1' for service 'mariadb-reporting-service'. Mar 16 20:50:35 maxscale-staging-0 maxscale[3835388]: (5) [readwritesplit] (mariadb-service) 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 'mariadb-service'. To increase the limit (currently 500), add `max_sescmd_history` to the same service and increase the value. Mar 16 21:17:45 maxscale-staging-0 maxscale[3835388]: Monitor was unable to connect to server node_secondary-0[db-staging-secondary-0:3306] : 'Can't connect to MySQL server on 'db-staging-secondary-0' (115)' Mar 16 21:17:45 maxscale-staging-0 maxscale[3835388]: Server changed state: node_secondary-0[db-staging-secondary-0:3306]: slave_down. [Slave, Running] -> [Down] Mar 16 21:17:54 maxscale-staging-0 maxscale[3835388]: Server 'node_secondary-0' charset: utf8mb4 Mar 16 21:17:54 maxscale-staging-0 maxscale[3835388]: Server changed state: node_secondary-0[db-staging-secondary-0:3306]: slave_up. [Down] -> [Slave, Running]