[BUG] SQLSTATE[42803] Fehler beim Ausführen des Hintergrundjobs OCA\DAV\BackgroundJob\EventReminderJob
timomatrixer opened this issue · 4 comments
timomatrixer commented
Is there an existing issue for this?
- I have searched the existing issues
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 appsCPU architecture
x86-64
Docker creation
unraid installationContainer 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 commented
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
Same here with fresh nextcloud-aio installation
- Nextcloud Hub 9 (30.0.0)
- "Latest", with no pending updates