search

linuxserver / docker-nextcloud

GNU General Public License v3.0
710 stars 128 forks source link

[BUG] SQLSTATE[42803] Fehler beim Ausführen des Hintergrundjobs OCA\DAV\BackgroundJob\EventReminderJob #474

Open timomatrixer opened 1 week ago

timomatrixer commented 1 week ago

Is there an existing issue for this?

Current Behavior

Der Fehler SQLSTATE[42803]: Grouping error: 7 ERROR: column "cr.id" must appear in the GROUP BY clause or be used in an aggregate function tritt auf.

Expected Behavior

Der Hintergrundjob sollte ohne Fehler ausgeführt werden.

Steps To Reproduce

Führen Sie den Hintergrundjob OCA\DAV\BackgroundJob\EventReminderJob aus. Der oben genannte Fehler tritt auf.

Environment

- OS:unraid
- How docker service was installed: community apps

CPU architecture

x86-64

Docker creation

unraid installation

Container logs

{
  "reqId": "mEnVXo3hvLmIG0TCOXns",
  "level": 3,
  "time": "2024-10-01T11:45:01+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "core",
  "method": "",
  "url": "--",
  "message": "Error while running background job OCA\\DAV\\BackgroundJob\\EventReminderJob (id: 9, arguments: null)",
  "userAgent": "--",
  "version": "30.0.0.14",
  "exception": {
    "Exception": "Doctrine\\DBAL\\Exception\\DriverException",
    "Message": "An exception occurred while executing a query: SQLSTATE[42803]: Grouping error: 7 ERROR:  column \"cr.id\" must appear in the GROUP BY clause or be used in an aggregate function\nLINE 1: SELECT \"cr\".*, \"co\".\"calendardata\", \"c\".\"displayname\", \"c\".\"...\n               ^",
    "Code": 7,
    "Trace": [
      {
        "file": "/app/www/public/3rdparty/doctrine/dbal/src/Connection.php",
        "line": 1943,
        "function": "convert",
        "class": "Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter",
        "type": "->"
      },
      {
        "file": "/app/www/public/3rdparty/doctrine/dbal/src/Connection.php",
        "line": 1885,
        "function": "handleDriverException",
        "class": "Doctrine\\DBAL\\Connection",
        "type": "->"
      },
      {
        "file": "/app/www/public/3rdparty/doctrine/dbal/src/Connection.php",
        "line": 1106,
        "function": "convertExceptionDuringQuery",
        "class": "Doctrine\\DBAL\\Connection",
        "type": "->"
      },
      {
        "file": "/app/www/public/lib/private/DB/Connection.php",
        "line": 415,
        "function": "executeQuery",
        "class": "Doctrine\\DBAL\\Connection",
        "type": "->"
      },
      {
        "file": "/app/www/public/lib/private/DB/ConnectionAdapter.php",
        "line": 50,
        "function": "executeQuery",
        "class": "OC\\DB\\Connection",
        "type": "->"
      },
      {
        "file": "/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php",
        "line": 272,
        "function": "executeQuery",
        "class": "OC\\DB\\ConnectionAdapter",
        "type": "->"
      },
      {
        "file": "/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php",
        "line": 249,
        "function": "executeQuery",
        "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
        "type": "->"
      },
      {
        "file": "/config/www/nextcloud/apps/dav/lib/CalDAV/Reminder/Backend.php",
        "line": 53,
        "function": "execute",
        "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
        "type": "->"
      },
      {
        "file": "/config/www/nextcloud/apps/dav/lib/CalDAV/Reminder/ReminderService.php",
        "line": 104,
        "function": "getRemindersToProcess",
        "class": "OCA\\DAV\\CalDAV\\Reminder\\Backend",
        "type": "->"
      },
      {
        "file": "/config/www/nextcloud/apps/dav/lib/BackgroundJob/EventReminderJob.php",
        "line": 50,
        "function": "processReminders",
        "class": "OCA\\DAV\\CalDAV\\Reminder\\ReminderService",
        "type": "->"
      },
      {
        "file": "/app/www/public/lib/public/BackgroundJob/Job.php",
        "line": 61,
        "function": "run",
        "class": "OCA\\DAV\\BackgroundJob\\EventReminderJob",
        "type": "->"
      },
      {
        "file": "/app/www/public/lib/public/BackgroundJob/TimedJob.php",
        "line": 83,
        "function": "start",
        "class": "OCP\\BackgroundJob\\Job",
        "type": "->"
      },
      {
        "file": "/app/www/public/lib/public/BackgroundJob/TimedJob.php",
        "line": 73,
        "function": "start",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      },
      {
        "file": "/app/www/public/cron.php",
        "line": 162,
        "function": "execute",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      }
    ],
    "File": "/app/www/public/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php",
    "Line": 87,
    "Previous": {
      "Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
      "Message": "SQLSTATE[42803]: Grouping error: 7 ERROR:  column \"cr.id\" must appear in the GROUP BY clause or be used in an aggregate function\nLINE 1: SELECT \"cr\".*, \"co\".\"calendardata\", \"c\".\"displayname\", \"c\".\"...\n               ^",
      "Code": 7,
      "Trace": [
        {
          "file": "/app/www/public/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
          "line": 132,
          "function": "new",
          "class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
          "type": "::"
        },
        {
          "file": "/app/www/public/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1099,
          "function": "execute",
          "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
          "type": "->"
        },
        {
          "file": "/app/www/public/lib/private/DB/Connection.php",
          "line": 415,
          "function": "executeQuery",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->"
        },
        {
          "file": "/app/www/public/lib/private/DB/ConnectionAdapter.php",
          "line": 50,
          "function": "executeQuery",
          "class": "OC\\DB\\Connection",
          "type": "->"
        },
        {
          "file": "/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php",
          "line": 272,
          "function": "executeQuery",
          "class": "OC\\DB\\ConnectionAdapter",
          "type": "->"
        },
        {
          "file": "/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php",
          "line": 249,
          "function": "executeQuery",
          "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
          "type": "->"
        },
        {
          "file": "/config/www/nextcloud/apps/dav/lib/CalDAV/Reminder/Backend.php",
          "line": 53,
          "function": "execute",
          "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
          "type": "->"
        },
        {
          "file": "/config/www/nextcloud/apps/dav/lib/CalDAV/Reminder/ReminderService.php",
          "line": 104,
          "function": "getRemindersToProcess",
          "class": "OCA\\DAV\\CalDAV\\Reminder\\Backend",
          "type": "->"
        },
        {
          "file": "/config/www/nextcloud/apps/dav/lib/BackgroundJob/EventReminderJob.php",
          "line": 50,
          "function":"processReminders",
          "class": "OCA\\DAV\\CalDAV\\Reminder\\ReminderService",
          "type": "->"
        },
        {
          "file": "/app/www/public/lib/public/BackgroundJob/Job.php",
          "line": 61,
          "function": "run",
          "class": "OCA\\DAV\\BackgroundJob\\EventReminderJob",
          "type": "->"
        },
        {
          "file": "/app/www/public/lib/public/BackgroundJob/TimedJob.php",
          "line": 83,
          "function": "start",
          "class": "OCP\\BackgroundJob\\Job",
          "type": "->"
        },
        {
          "file": "/app/www/public/lib/public/BackgroundJob/TimedJob.php",
          "line": 73,
          "function": "start",
          "class": "OCP\\BackgroundJob\\TimedJob",
          "type": "->"
        },
        {
          "file": "/app/www/public/cron.php",
          "line": 162,
          "function": "execute",
          "class": "OCP\\BackgroundJob\\TimedJob",
          "type": "->"
        }
      ],
      "File": "/app/www/public/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
      "Line": 28
    }
  },
  "message": "Error while running background job OCA\\DAV\\BackgroundJob\\EventReminderJob (id: 9, arguments: null)",
  "exception": {},
  "CustomMessage": "Error while running background job OCA\\DAV\\BackgroundJob\\EventReminderJob (id: 9, arguments: null)"
}
github-actions[bot] commented 1 week ago

Thanks for opening your first issue here! Be sure to follow the relevant issue templates, or risk having this issue marked as invalid.

XploD-Ing commented 1 day ago

Same here with fresh nextcloud-aio installation