[core] Fehler: Error while running background job OCA\DAV\BackgroundJob\EventReminderJob (id: 13, arguments: null)
von ? von – um 23.10.2024, 17:58:29
{“reqId”:“Rd7o5l8pjk8ErtvPK4pw”,“level”:3,“time”:“2024-10-23T15:58:29+00:00”,“remoteAddr”:“”,“user”:“–”,“app”:“core”,“method”:“”,“url”:“–”,“message”:“Error while running background job OCA\DAV\BackgroundJob\EventReminderJob (id: 13, 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”:”/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",“line”:1943,“function”:“convert”,“class”:“Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter”,“type”:“->”,“args”:[[“Doctrine\DBAL\Driver\PDO\Exception”],[“Doctrine\DBAL\Query”]]},{“file”:“/var/www/html/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1885,“function”:“handleDriverException”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”,“args”:[[“Doctrine\DBAL\Driver\PDO\Exception”],[“Doctrine\DBAL\Query”]]},{“file”:“/var/www/html/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1106,“function”:“convertExceptionDuringQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”,“args”:[[“Doctrine\DBAL\Driver\PDO\Exception”],"SELECT "cr"., "co"."calendardata", "c"."displayname", "c"."principaluri", "cr"."notification_date", "cr"."event_hash", "cr"."type" FROM "oc_calendar_reminders" "cr" INNER JOIN "oc_calendarobjects" "co" ON "cr"."object_id" = "co"."id" INNER JOIN "oc_calendars" "c" ON "cr"."calendar_id" = "c"."id" WHERE "cr"."notification_date" <= ? GROUP BY "cr"."event_hash", "cr"."notification_date", "cr"."type"”,[1729699109],[2]]},{“file”:“/var/www/html/lib/private/DB/Connection.php”,“line”:415,“function”:“executeQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”,“args”:[“SELECT "cr"., "co"."calendardata", "c"."displayname", "c"."principaluri", "cr"."notification_date", "cr"."event_hash", "cr"."type" FROM "oc_calendar_reminders" "cr" INNER JOIN "oc_calendarobjects" "co" ON "cr"."object_id" = "co"."id" INNER JOIN "oc_calendars" "c" ON "cr"."calendar_id" = "c"."id" WHERE "cr"."notification_date" <= ? GROUP BY "cr"."event_hash", "cr"."notification_date", "cr"."type"“,[1729699109],[2],null]},{“file”:”/var/www/html/lib/private/DB/ConnectionAdapter.php",“line”:50,“function”:“executeQuery”,“class”:“OC\DB\Connection”,“type”:“->”,“args”:["SELECT "cr"., "co"."calendardata", "c"."displayname", "c"."principaluri", "cr"."notification_date", "cr"."event_hash", "cr"."type" FROM "oc_calendar_reminders" "cr" INNER JOIN "oc_calendarobjects" "co" ON "cr"."object_id" = "co"."id" INNER JOIN "oc_calendars" "c" ON "cr"."calendar_id" = "c"."id" WHERE "cr"."notification_date" <= :dcValue1 GROUP BY "cr"."event_hash", "cr"."notification_date", "cr"."type"”,[1729699109],[2]]},{“file”:“/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php”,“line”:272,“function”:“executeQuery”,“class”:“OC\DB\ConnectionAdapter”,“type”:“->”,“args”:[“SELECT cr., co.calendardata, c.displayname, c.principaluri, cr.notification_date, cr.event_hash, cr.type FROM *PREFIX*calendar_reminders cr INNER JOIN *PREFIX*calendarobjects co ON cr.object_id = co.id INNER JOIN *PREFIX*calendars c ON cr.calendar_id = c.id WHERE cr.notification_date <= :dcValue1 GROUP BY cr.event_hash, cr.notification_date, cr.type",[1729699109],[2]]},{“file”:“/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php”,“line”:249,“function”:“executeQuery”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:“->”,“args”:[[“OC\DB\ConnectionAdapter”]]},{“file”:“/var/www/html/apps/dav/lib/CalDAV/Reminder/Backend.php”,“line”:53,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:“->”,“args”:[]},{“file”:“/var/www/html/apps/dav/lib/CalDAV/Reminder/ReminderService.php”,“line”:104,“function”:“getRemindersToProcess”,“class”:“OCA\DAV\CalDAV\Reminder\Backend”,“type”:“->”,“args”:[]},{“file”:“/var/www/html/apps/dav/lib/BackgroundJob/EventReminderJob.php”,“line”:50,“function”:“processReminders”,“class”:“OCA\DAV\CalDAV\Reminder\ReminderService”,“type”:“->”,“args”:[]},{“file”:“/var/www/html/lib/public/BackgroundJob/Job.php”,“line”:61,“function”:“run”,“class”:“OCA\DAV\BackgroundJob\EventReminderJob”,“type”:“->”,“args”:[null]},{“file”:“/var/www/html/lib/public/BackgroundJob/TimedJob.php”,“line”:83,“function”:“start”,“class”:“OCP\BackgroundJob\Job”,“type”:“->”,“args”:[[“OC\BackgroundJob\JobList”]]},{“file”:“/var/www/html/lib/public/BackgroundJob/TimedJob.php”,“line”:73,“function”:“start”,“class”:“OCP\BackgroundJob\TimedJob”,“type”:“->”,“args”:[[“OC\BackgroundJob\JobList”]]},{“file”:“/var/www/html/cron.php”,“line”:162,“function”:“execute”,“class”:“OCP\BackgroundJob\TimedJob”,“type”:“->”,“args”:[[“OC\BackgroundJob\JobList”]]}],“File”:“/var/www/html/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”:“/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php”,“line”:132,“function”:“new”,“class”:“Doctrine\DBAL\Driver\PDO\Exception”,“type”:“::”,“args”:[[“PDOException”,[“42803”,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 ^“]]]},{“file”:”/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",“line”:1099,“function”:“execute”,“class”:“Doctrine\DBAL\Driver\PDO\Statement”,“type”:“->”,“args”:[]},{“file”:“/var/www/html/lib/private/DB/Connection.php”,“line”:415,“function”:“executeQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”,“args”:["SELECT "cr"., "co"."calendardata", "c"."displayname", "c"."principaluri", "cr"."notification_date", "cr"."event_hash", "cr"."type" FROM "oc_calendar_reminders" "cr" INNER JOIN "oc_calendarobjects" "co" ON "cr"."object_id" = "co"."id" INNER JOIN "oc_calendars" "c" ON "cr"."calendar_id" = "c"."id" WHERE "cr"."notification_date" <= ? GROUP BY "cr"."event_hash", "cr"."notification_date", "cr"."type"”,[1729699109],[2],null]},{“file”:“/var/www/html/lib/private/DB/ConnectionAdapter.php”,“line”:50,“function”:“executeQuery”,“class”:“OC\DB\Connection”,“type”:“->”,“args”:[“SELECT "cr"., "co"."calendardata", "c"."displayname", "c"."principaluri", "cr"."notification_date", "cr"."event_hash", "cr"."type" FROM "oc_calendar_reminders" "cr" INNER JOIN "oc_calendarobjects" "co" ON "cr"."object_id" = "co"."id" INNER JOIN "oc_calendars" "c" ON "cr"."calendar_id" = "c"."id" WHERE "cr"."notification_date" <= :dcValue1 GROUP BY "cr"."event_hash", "cr"."notification_date", "cr"."type"“,[1729699109],[2]]},{“file”:”/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",“line”:272,“function”:“executeQuery”,“class”:“OC\DB\ConnectionAdapter”,“type”:“->”,“args”:["SELECT cr., co.calendardata, c.displayname, c.principaluri, cr.notification_date, cr.event_hash, cr.type FROM *PREFIX*calendar_reminders cr INNER JOIN *PREFIX*calendarobjects co ON cr.object_id = co.id INNER JOIN *PREFIX*calendars c ON cr.calendar_id = c.id WHERE cr.notification_date <= :dcValue1 GROUP BY cr.event_hash, cr.notification_date, cr.type”,[1729699109],[2]]},{“file”:“/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php”,“line”:249,“function”:“executeQuery”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:“->”,“args”:[[“OC\DB\ConnectionAdapter”]]},{“file”:“/var/www/html/apps/dav/lib/CalDAV/Reminder/Backend.php”,“line”:53,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:“->”,“args”:},{“file”:“/var/www/html/apps/dav/lib/CalDAV/Reminder/ReminderService.php”,“line”:104,“function”:“getRemindersToProcess”,“class”:“OCA\DAV\CalDAV\Reminder\Backend”,“type”:“->”,“args”:},{“file”:“/var/www/html/apps/dav/lib/BackgroundJob/EventReminderJob.php”,“line”:50,“function”:“processReminders”,“class”:“OCA\DAV\CalDAV\Reminder\ReminderService”,“type”:“->”,“args”:},{“file”:“/var/www/html/lib/public/BackgroundJob/Job.php”,“line”:61,“function”:“run”,“class”:“OCA\DAV\BackgroundJob\EventReminderJob”,“type”:“->”,“args”:[null]},{“file”:“/var/www/html/lib/public/BackgroundJob/TimedJob.php”,“line”:83,“function”:“start”,“class”:“OCP\BackgroundJob\Job”,“type”:“->”,“args”:[[“OC\BackgroundJob\JobList”]]},{“file”:“/var/www/html/lib/public/BackgroundJob/TimedJob.php”,“line”:73,“function”:“start”,“class”:“OCP\BackgroundJob\TimedJob”,“type”:“->”,“args”:[[“OC\BackgroundJob\JobList”]]},{“file”:“/var/www/html/cron.php”,“line”:162,“function”:“execute”,“class”:“OCP\BackgroundJob\TimedJob”,“type”:“->”,“args”:[[“OC\BackgroundJob\JobList”]]}],“File”:“/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php”,“Line”:28,“Previous”:{“Exception”:“PDOException”,“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”:“42803”,“Trace”:[{“file”:”/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",“line”:130,“function”:“execute”,“class”:“PDOStatement”,“type”:“->”,“args”:[null]},{“file”:“/var/www/html/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1099,“function”:“execute”,“class”:“Doctrine\DBAL\Driver\PDO\Statement”,“type”:“->”,“args”:[]},{“file”:“/var/www/html/lib/private/DB/Connection.php”,“line”:415,“function”:“executeQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”,“args”:["SELECT "cr"., "co"."calendardata", "c"."displayname", "c"."principaluri", "cr"."notification_date", "cr"."event_hash", "cr"."type" FROM "oc_calendar_reminders" "cr" INNER JOIN "oc_calendarobjects" "co" ON "cr"."object_id" = "co"."id" INNER JOIN "oc_calendars" "c" ON "cr"."calendar_id" = "c"."id" WHERE "cr"."notification_date" <= ? GROUP BY "cr"."event_hash", "cr"."notification_date", "cr"."type"”,[1729699109],[2],null]},{“file”:“/var/www/html/lib/private/DB/ConnectionAdapter.php”,“line”:50,“function”:“executeQuery”,“class”:“OC\DB\Connection”,“type”:“->”,“args”:[“SELECT "cr"., "co"."calendardata", "c"."displayname", "c"."principaluri", "cr"."notification_date", "cr"."event_hash", "cr"."type" FROM "oc_calendar_reminders" "cr" INNER JOIN "oc_calendarobjects" "co" ON "cr"."object_id" = "co"."id" INNER JOIN "oc_calendars" "c" ON "cr"."calendar_id" = "c"."id" WHERE "cr"."notification_date" <= :dcValue1 GROUP BY "cr"."event_hash", "cr"."notification_date", "cr"."type"“,[1729699109],[2]]},{“file”:”/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",“line”:272,“function”:“executeQuery”,“class”:“OC\DB\ConnectionAdapter”,“type”:“->”,“args”:["SELECT cr., co.calendardata, c.displayname, c.principaluri, cr.notification_date, cr.event_hash, cr.type FROM *PREFIX*calendar_reminders cr INNER JOIN *PREFIX*calendarobjects co ON cr.object_id = co.id INNER JOIN *PREFIX*calendars c ON cr.calendar_id = c.id WHERE cr.notification_date <= :dcValue1 GROUP BY cr.event_hash, cr.notification_date, cr.type”,[1729699109],[2]]},{“file”:“/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php”,“line”:249,“function”:“executeQuery”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:“->”,“args”:[[“OC\DB\ConnectionAdapter”]]},{“file”:“/var/www/html/apps/dav/lib/CalDAV/Reminder/Backend.php”,“line”:53,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:“->”,“args”:},{“file”:“/var/www/html/apps/dav/lib/CalDAV/Reminder/ReminderService.php”,“line”:104,“function”:“getRemindersToProcess”,“class”:“OCA\DAV\CalDAV\Reminder\Backend”,“type”:“->”,“args”:},{“file”:“/var/www/html/apps/dav/lib/BackgroundJob/EventReminderJob.php”,“line”:50,“function”:“processReminders”,“class”:“OCA\DAV\CalDAV\Reminder\ReminderService”,“type”:“->”,“args”:},{“file”:“/var/www/html/lib/public/BackgroundJob/Job.php”,“line”:61,“function”:“run”,“class”:“OCA\DAV\BackgroundJob\EventReminderJob”,“type”:“->”,“args”:[null]},{“file”:“/var/www/html/lib/public/BackgroundJob/TimedJob.php”,“line”:83,“function”:“start”,“class”:“OCP\BackgroundJob\Job”,“type”:“->”,“args”:[[“OC\BackgroundJob\JobList”]]},{“file”:“/var/www/html/lib/public/BackgroundJob/TimedJob.php”,“line”:73,“function”:“start”,“class”:“OCP\BackgroundJob\TimedJob”,“type”:“->”,“args”:[[“OC\BackgroundJob\JobList”]]},{“file”:“/var/www/html/cron.php”,“line”:162,“function”:“execute”,“class”:“OCP\BackgroundJob\TimedJob”,“type”:“->”,“args”:[[“OC\BackgroundJob\JobList”]]}],“File”:“/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php”,“Line”:130}},“message”:“Error while running background job OCA\DAV\BackgroundJob\EventReminderJob (id: 13, arguments: null)”,“exception”:,“CustomMessage”:“Error while running background job OCA\DAV\BackgroundJob\EventReminderJob (id: 13, arguments: null)”},“id”:“67191e81724c6”}