[MDEV-29347] MariaDB 10.6.8 fails to start when ONLY_FULL_GROUP_BY gets provided - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Affects Version/s: 10.6.8, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
Fix Version/s: 10.6.11, 10.7.7, 10.8.6, 10.9.4, 10.10.2
Component/s: Time zones
Labels:
- regression
Environment:
Docker container

Description

When starting the mariadb 10.6.8 docker container with

--sql-mode=ONLY_FULL_GROUP_BY

, it fails to initialize with

ERROR 1140 (42000) at line 2: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Here a more complete docker run command that we use in Nextcloud server for testing:

docker run -it --rm \
--name mariadb \
-e MYSQL_ROOT_PASSWORD=owncloud \
-e MYSQL_USER=oc_autotest \
-e MYSQL_PASSWORD=owncloud \
-e MYSQL_DATABASE=oc_autotest \
ghcr.io/nextcloud/continuous-integration-mariadb-10.6:latest \
--sql-mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

(The docker image is based on the official mariadb10.6.8 docker image and nothing is modified)

Attachments

Activity

Ascending order - Click to sort in descending order

Elena Stepanova added a comment - 2022-08-22 09:52

Thanks for the report.

The problem is not limited to docker containers, general timezone initialization fails the same way. Apparently the failure was brought by

commit 13e77930e615f05cc74d408110e887b00e1abcc9

Author: Daniel Black

Date:   Wed Apr 6 13:12:21 2022 +1000

    MDEV-28263: mariadb-tzinfo-to-sql improve wsrep and binlog cases

which introduced the query in question.

Elena Stepanova added a comment - 2022-08-22 09:52 Thanks for the report. The problem is not limited to docker containers, general timezone initialization fails the same way. Apparently the failure was brought by commit 13e77930e615f05cc74d408110e887b00e1abcc9 Author: Daniel Black Date: Wed Apr 6 13:12:21 2022 +1000 MDEV-28263: mariadb-tzinfo-to-sql improve wsrep and binlog cases which introduced the query in question.

Daniel Black added a comment - 2022-08-23 02:11

Thanks szaimen for the bug report.

I added a workaround that will be included in the current q3-2022 set of release soon.

Non-container users can use the same workaround. Being a blocker bug this will be corrected in the next server release.

Daniel Black added a comment - 2022-08-23 02:11 Thanks szaimen for the bug report. I added a workaround that will be included in the current q3-2022 set of release soon. Non-container users can use the same workaround. Being a blocker bug this will be corrected in the next server release.

Oleksandr Byelkin added a comment - 2022-09-05 14:55

OK to push

Oleksandr Byelkin added a comment - 2022-09-05 14:55 OK to push

Simon added a comment - 2022-09-19 14:56

Hello, is there any update here? Is this already fixed in a new release?

Simon added a comment - 2022-09-19 14:56 Hello, is there any update here? Is this already fixed in a new release?

Sergei Golubchik added a comment - 2022-09-22 10:02

No, the issue isn't closed yet. The new release was an out-of-schedule release to fix critical data corruption regressions. This fix didn't make it there, it'll be in the next scheduled release.

Sergei Golubchik added a comment - 2022-09-22 10:02 No, the issue isn't closed yet. The new release was an out-of-schedule release to fix critical data corruption regressions. This fix didn't make it there, it'll be in the next scheduled release.

People

Assignee:: Sergei Golubchik

Reporter:: Simon

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2022-08-22 08:42

Updated:: 2022-10-17 03:43

Resolved:: 2022-09-26 09:33

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server