Page MenuHomePhabricator
Paste P23832

(An Untitled Masterwork)
ArchivedPublic

Authored by Kormat on Mar 30 2022, 2:56 PM.
Tags
None
Referenced Files
F35030229: raw-paste-data.txt
Mar 30 2022, 2:56 PM
Subscribers
None
Mar 30 14:55:32 db2093 mysqld[4341]: 2022-03-30 14:55:32 12 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. REPLACE... SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are replaced. This order cannot be predicted and may differ on master and the slave Statement: replace into
Mar 30 14:55:32 db2093 mysqld[4341]: cluster_alias (alias, cluster_name, last_registered)
Mar 30 14:55:32 db2093 mysqld[4341]: select
Mar 30 14:55:32 db2093 mysqld[4341]: suggested_cluster_alias,
Mar 30 14:55:32 db2093 mysqld[4341]: cluster_name,
Mar 30 14:55:32 db2093 mysqld[4341]: now()
Mar 30 14:55:32 db2093 mysqld[4341]: from
Mar 30 14:55:32 db2093 mysqld[4341]: database_instance
Mar 30 14:55:32 db2093 mysqld[4341]: left join database_instance_downtime using (hostname, port)
Mar 30 14:55:32 db2093 mysqld[4341]: where
Mar 30 14:55:32 db2093 mysqld[4341]: suggested_cluster_alias!=''
Mar 30 14:55:32 db2093 mysqld[4341]: /* exclude newly demoted, downtimed masters */
Mar 30 14:55:32 db2093 mysqld[4341]: and ifnull(
Mar 30 14:55:32 db2093 mysqld[4341]: database_instance_downtime.downtime_active = 1
Mar 30 14:55:32 db2093 mysqld[4341]: and database_instance_downtime.end_timestamp > now()
Mar 30 14:55:32 db2093 mysqld[4341]: and database_instance_downtime.reason = 'lost-in-recovery'
Mar 30 14:55:32 db2093 mysqld[4341]: , 0) = 0
Mar 30 14:55:32 db2093 mysqld[4341]: order by
Mar 30 14:55:32 db2093 mysqld[4341]: ifnull(last_checked <= last_seen, 0) asc,
Mar 30 14:55:32 db2093 mysqld[4341]: read_only desc,
Mar 30 14:55:32 db2093 mysqld[4341]: num_slave_hosts asc