看这里有一些报错是,在 sql_mode=only_full_group_by 下 group by 的条件不完善。 请检查你的sql_mode.
[2020/06/11 10:16:50.185 +08:00] [Error] [conn.go:728] [“command dispatched failed”] [conn=2381] [connInfo=“id:2381, addr:10.204.40.82:60126 status:10, collation:utf8_general_ci, user:uniorder”] [command=Query] [status=“inTxn:0, autocommit:1”] [sql=“SELECT STATE AS 状态, ROUND(SUM(DURATION),7) AS 期间, CONCAT(ROUND(SUM(DURATION)/0*100,3), ‘%’) AS 百分比 FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID=0 GROUP BY STATE ORDER BY SEQ”] [txn_mode=PESSIMISTIC] [err="[planner:1055]Expression #1 of ORDER BY is not in GROUP BY clause and contains nonaggregated column ‘’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by