Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-29347

MariaDB 10.6.8 fails to start when ONLY_FULL_GROUP_BY gets provided

Details

    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
          elenst Elena Stepanova added a comment -

          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.

          elenst Elena Stepanova added a comment - 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.
          danblack Daniel Black added a comment -

          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.

          danblack Daniel Black added a comment - 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.
          sanja Oleksandr Byelkin added a comment -

          OK to push

          sanja Oleksandr Byelkin added a comment - OK to push
          szaimen Simon added a comment -

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

          szaimen Simon added a comment - Hello, is there any update here? Is this already fixed in a new release?
          serg Sergei Golubchik added a comment -

          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.

          serg Sergei Golubchik added a comment - 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

            serg Sergei Golubchik
            szaimen Simon
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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