Nextcloud AIO becomes unresponsive because of the Music app

ℹ️ Support
, , ,
1

Hi,

I was listening to music using Power Ampache 2 app on android which relies on the music app. After running smoothly for around 30 minutes the server became unresponsive. The CPU & RAM usage spiked. I couldn’t access the web UI. Even restarting the server didn’t help. I tried to access AIO Dashboard but it said nextcloud was running. I then stopped the apache container and tried to stop all containers from AIO Dashboard. But after a while (It couldn’t stop the notify push container and nextcloud-aio-nextcloud) it aborted the connection and became unresponsive. I then manually stopped all containers and restarted the master container. Then started the containers from the dashboard. This is not the first time. I think the culprit is the music app.

Here’s the relevant logs:

{"level":"error","ts":1729016378.7970474,"logger":"http.log.error","msg":"dial tcp 127.0.0.1:8000: i/o timeout","request":{"remote_ip":"172.21.0.1","remote_port":"46058","client_ip":"2400:3dc0:46:103:8d8a:ec4c:f7f6:8ec1","proto":"HTTP/1.1","method":"GET","host":"cloud.buddyverse.one","uri":"/apps/music/ampache/image.php?object_type=album&object_id=334&token=1-3b480f6c59bec49f3996fbaf25d5366a","headers":{"X-Forwarded-Port":["443"],"X-Forwarded-Scheme":["https"],"X-Forwarded-Proto":["https"],"X-Real-Ip":["172.71.124.27"],"Cf-Ipcountry":["BD"],"X-Forwarded-For":["2400:3dc0:46:103:8d8a:ec4c:f7f6:8ec1, 172.71.124.27"],"Connection":["close"],"Cf-Ray":["8d31d163bfd7ce27-SIN"],"Cf-Visitor":["{\"scheme\":\"https\"}"],"Cdn-Loop":["cloudflare; loops=1"],"Cf-Connecting-Ip":["2400:3dc0:46:103:8d8a:ec4c:f7f6:8ec1"],"User-Agent":["okhttp/5.0.0-alpha.14"]}},"duration":3.023692995,"status":502,"err_id":"5zsgcp0vm","err_trace":"reverseproxy.statusError (reverseproxy.go:1269)"}
{"level":"error","ts":1729016378.7971632,"logger":"http.log.error","msg":"dial tcp 127.0.0.1:8000: i/o timeout","request":{"remote_ip":"172.21.0.1","remote_port":"46062","client_ip":"2400:3dc0:46:103:8d8a:ec4c:f7f6:8ec1","proto":"HTTP/1.1","method":"GET","host":"cloud.buddyverse.one","uri":"/apps/music/ampache/image.php?object_type=album&object_id=334&token=1-3b480f6c59bec49f3996fbaf25d5366a","headers":{"X-Real-Ip":["172.71.124.85"],"Cdn-Loop":["cloudflare; loops=1"],"Cf-Ipcountry":["BD"],"User-Agent":["okhttp/5.0.0-alpha.14"],"X-Forwarded-Port":["443"],"X-Forwarded-Scheme":["https"],"Connection":["close"],"Cf-Ray":["8d31d163b98bce51-SIN"],"Cf-Visitor":["{\"scheme\":\"https\"}"],"Cf-Connecting-Ip":["2400:3dc0:46:103:8d8a:ec4c:f7f6:8ec1"],"X-Forwarded-For":["2400:3dc0:46:103:8d8a:ec4c:f7f6:8ec1, 172.71.124.85"],"X-Forwarded-Proto":["https"]}},"duration":3.022295804,"status":502,"err_id":"0f6eqg8yj","err_trace":"reverseproxy.statusError (reverseproxy.go:1269)"}

…

[Tue Oct 15 18:21:10 2024] [error] [client: 2400:3dc0:46:103:8d8a:ec4c:f7f6:8ec1, 172.71.124.85, 172.21.0.1] [AH01079: failed to make connection to backend: nextcloud-aio-nextcloud] [okhttp/5.0.0-alpha.14]
[Tue Oct 15 18:21:10 2024] [error] [client: 2400:3dc0:46:103:8d8a:ec4c:f7f6:8ec1, 172.71.124.144, 172.21.0.1] [AH01079: failed to make connection to backend: nextcloud-aio-nextcloud] [okhttp/5.0.0-alpha.14]
[Tue Oct 15 18:21:10 2024] [error] [client: 2400:3dc0:46:103:8d8a:ec4c:f7f6:8ec1, 172.71.124.211, 172.21.0.1] [AH01067: Failed to read FastCGI header] [okhttp/5.0.0-alpha.14]
[Tue Oct 15 18:21:11 2024] [error] [(104)Connection reset by peer] [client: 2400:3dc0:46:103:8d8a:ec4c:f7f6:8ec1, 172.71.124.211, 172.21.0.1] [AH01075: Error dispatching request to : ] [okhttp/5.0.0-alpha.14]
[Tue Oct 15 18:21:10 2024] [error] [client: 2400:3dc0:46:103:8d8a:ec4c:f7f6:8ec1, 172.71.124.144, 172.21.0.1] [AH01079: failed to make connection to backend: nextcloud-aio-nextcloud] [okhttp/5.0.0-alpha.14]
[Tue Oct 15 18:21:10 2024] [error] [client: 2400:3dc0:46:103:8d8a:ec4c:f7f6:8ec1, 172.71.124.85, 172.21.0.1] [AH01079: failed to make connection to backend: nextcloud-aio-nextcloud] [okhttp/5.0.0-alpha.14]

TIA

2

Also these three errors appeard in my logs more than 3 thousand times:

Log 1 (formatted):

[no app in context] Warning: Icon of notification is not an absolute URL and does not work in mobile and desktop clients [app: survey_client, subject: updated]
	GET /ocs/v2.php/apps/notifications/api/v2/notifications
	from 172.70.142.238 by admin at Oct 16, 2024, 7:59:02 PM

Log 1 Raw Entry:

{"reqId":"xO3ivYV2K8OuzZPyPDUv","level":2,"time":"2024-10-16T13:59:02+00:00","remoteAddr":"172.70.142.238","user":"admin","app":"no app in context","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications","message":"Icon of notification is not an absolute URL and does not work in mobile and desktop clients [app: survey_client, subject: updated]","userAgent":"Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36","version":"30.0.0.14","data":[],"id":"670fc6af1c922"}

Log 2 formatted:

[no app in context] Error: image not found: image:apps/whiteboard.svg webroot: serverroot:/var/www/html
	GET /ocs/v2.php/apps/notifications/api/v2/notifications
	from 172.70.143.246 by admin at Oct 16, 2024, 7:55:21 PM

Log 2 Raw:

{"reqId":"i1DwwEn1M3FlQLYu9JKa","level":3,"time":"2024-10-16T13:55:21+00:00","remoteAddr":"172.70.143.246","user":"admin","app":"no app in context","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications","message":"image not found: image:apps/whiteboard.svg webroot: serverroot:/var/www/html","userAgent":"Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36","version":"30.0.0.14","exception":{"Exception":"RuntimeException","Message":"image not found: image:apps/whiteboard.svg webroot: serverroot:/var/www/html","Code":0,"Trace":[{"file":"/var/www/html/apps/firstrunwizard/lib/Notification/Notifier.php","line":205,"function":"imagePath","class":"OC\\URLGenerator","type":"->","args":["firstrunwizard","apps/whiteboard.svg"]},{"file":"/var/www/html/apps/firstrunwizard/lib/Notification/Notifier.php","line":105,"function":"setAppHintDetails","class":"OCA\\FirstRunWizard\\Notification\\Notifier","type":"->","args":[["OC\\Notification\\Notification"],"en","whiteboard"]},{"file":"/var/www/html/lib/private/Notification/Manager.php","line":337,"function":"prepare","class":"OCA\\FirstRunWizard\\Notification\\Notifier","type":"->","args":[["OC\\Notification\\Notification"],"en"]},{"file":"/var/www/html/apps/notifications/lib/Controller/EndpointController.php","line":103,"function":"prepare","class":"OC\\Notification\\Manager","type":"->","args":[["OC\\Notification\\Notification"],"en"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":208,"function":"listNotifications","class":"OCA\\Notifications\\Controller\\EndpointController","type":"->","args":["v2"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":114,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Notifications\\Controller\\EndpointController"],"listNotifications"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Notifications\\Controller\\EndpointController"],"listNotifications"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Notifications\\Controller\\EndpointController","listNotifications",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["v2","ocs.notifications.endpoint.listnotifications"]]},{"file":"/var/www/html/ocs/v1.php","line":43,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/ocsapp/apps/notifications/api/v2/notifications"]},{"file":"/var/www/html/ocs/v2.php","line":7,"args":["/var/www/html/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/html/lib/private/URLGenerator.php","Line":242,"message":"image not found: image:apps/whiteboard.svg webroot: serverroot:/var/www/html","exception":[],"CustomMessage":"image not found: image:apps/whiteboard.svg webroot: serverroot:/var/www/html"},"id":"670fc6a53260f"}

Log 3 Formatted:

[core] Error: Error while running background job OCA\DAV\BackgroundJob\EventReminderJob (id: 23, arguments: null)
	from ? by -- at Oct 16, 2024, 7:55:11 PM

Log 3 Raw:

 {"reqId":"MuM6ucVvBkUj0iTZnqc1","level":3,"time":"2024-10-16T13:55:11+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"--","message":"Error while running background job OCA\\DAV\\BackgroundJob\\EventReminderJob (id: 23, 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\"",[1729086911],[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\"",[1729086911],[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\"",[1729086911],[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`",[1729086911],[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\"",[1729086911],[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\"",[1729086911],[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`",[1729086911],[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\"",[1729086911],[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\"",[1729086911],[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`",[1729086911],[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: 23, arguments: null)","exception":[],"CustomMessage":"Error while running background job OCA\\DAV\\BackgroundJob\\EventReminderJob (id: 23, arguments: null)"},"id":"670fc6a53276c"}
3

You could try to disable the music app and check if that resolves the problem. If so you might wanna log an issue at the music repo

1 Like
4

Is there any alternative to music? This issue occurred only when I was listening to music using the Power Ampache 2 android app. Maybe I should try to reproduce the issue by using the Web app.