You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm using MySQL 5.7.24 in a percola cluster of 3 master-master.
When I run the script my2.sql I do have a lot of error 1055 like this one : [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Do you have any idea why?
The text was updated successfully, but these errors were encountered:
In the mysql log: Percona-XtraDB-Cluster prohibits use of DML command on a table (my2.status) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER
I never user the collector with a cluster and I'm quite sure there are problems.
Each node should collect its own statistics, can have problems with GTID, ...
The collector has been used on hundreds of "easier" configurations but I do not have clusters to manage and I can not test enough. I'm sorry!
I'm using MySQL 5.7.24 in a percola cluster of 3 master-master.
When I run the script my2.sql I do have a lot of error 1055 like this one :
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Do you have any idea why?
The text was updated successfully, but these errors were encountered: