SQL Exception when retrieving profile statistics

Description

When accessing the profile view I'm getting this exception:

16:58:11,173 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-54) Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'all_translation.lastChanged' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
16:58:11,179 ERROR [org.zanata.rest.HibernateExceptionMapper] (default task-54) Hibernate Exception in REST request: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:2117)
	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1900)
	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1876)
	at org.hibernate.loader.Loader.doQuery(Loader.java:919)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
	at org.hibernate.loader.Loader.doList(Loader.java:2617)
	at org.hibernate.loader.Loader.doList(Loader.java:2600)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2429)
	at org.hibernate.loader.Loader.list(Loader.java:2424)
	at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:336)
	at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1967)
	at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:322)
	at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:125)
	at org.zanata.dao.TextFlowTargetHistoryDAO.getUserTranslationMatrix(TextFlowTargetHistoryDAO.java:321)
…

Environment

MySQL 8.0.11

Activity

Show:

Former user 12 June 2018 at 23:26

@Michal Petrov I would recommend to recreate your DB.
Docs: http://docs.zanata.org/en/release/user-guide/system-admin/configuration/installation/#setting-up-the-zanata-database

`CREATE DATABASE zanata /**!40100 DEFAULT CHARACTER SET utf8 **/`

Michal Petrov 12 June 2018 at 09:59

@Former user, it's possible this is caused by some MySQL setting on my end but I'm using a default installation, the problem persists in the latest snapshot.

Former user 11 June 2018 at 22:35

Issue cannot reproduce in 4.5 and 4.6

Cannot Reproduce

Details

Assignee

Unassigned

Reporter

Michal Petrov(Deactivated)

Tested Version/s

None

Components

frontend

Affects versions

platform-4.4.5

Priority

unspecified

More fields

Created 8 June 2018 at 15:11

Updated 12 June 2018 at 23:26

Resolved 11 June 2018 at 22:35

Configure

Zanata