Open qwc opened 1 year ago
Sidenote: When asked for the nextcloud.log (json) and actually provided the logfile (223506 lines, beautified json) the form creates an internal github error, which leads to recreating the whole issue aaaagain. Might be a good idea to notify users about big logs to store those externally, like pastebin, github-gist or whatever. If you have it in your template description, sorry, might have overread it, but if not please add the note.
Oh, as we're talkin about it... the link to my nextcloud.log here: https://gist.github.com/qwc/6f0f44977b26cf1f6d027a5764fad296
Update: Output from the browser console
dist.js:1 PROPFIND https://c.mmo.to/remote.php/dav/calendars/qwc/defaultcalendar/DAB30937-4A5F-4FEC-BDE4-C1E14D1396C.ics 404 (Not Found)
dist.js:1 PROPFIND https://c.mmo.to/remote.php/dav/calendars/qwc/default-calendar-2/E962FAAA-3698-499F-BA19-44B22850726.ics 404 (Not Found)
Why can't it find the resources? Now your help is required, as you know way more about it than me. Did I do something wrong with the instance? (At least I cannot remember changing anysettings, which could result in such a problem...)
Another test just now was, creating another new calendar, and trying to add something immediately afterwards, fails in the same error.
Nothing in your lofile regarding those two ICS files you posted but I found this:
Can you try and disable the activity app to see if you can then save a new event?
"reqId": "GpnbgNBiWJ6XTIZcQc8i",
"level": 3,
"time": "2023-08-30T09:19:01+00:00",
"remoteAddr": "2003:e7:f719:e8db:7b60:94a5:b821:b6f4",
"user": "qwc",
"app": "dav",
"method": "PUT",
"url": "/remote.php/dav/calendars/qwc/defaultcalendar/C88381E3-AAD3-4B2D-9629-8D9D66C9173B.ics",
"message": "Error generating activity for a deleted calendar object: An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(255)",
"userAgent": "Mozilla/5.0 (X11; Linux x86_64; rv:115.0) Gecko/20100101 Thunderbird/115.1.1",
"version": "27.0.2.1",
"exception": {
"Exception": "OC\\DB\\Exceptions\\DbalException",
"Message": "An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(255)",
"Code": 7,
"Trace": [
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 328,
"function": "wrap",
"class": "OC\\DB\\Exceptions\\DbalException",
"type": "::",
"args": [
[
"Doctrine\\DBAL\\Exception\\DriverException"
]
]
},
{
"file": "/var/www/html/apps/activity/lib/Data.php",
"line": 110,
"function": "executeStatement",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/activity/lib/Consumer.php",
"line": 68,
"function": "send",
"class": "OCA\\Activity\\Data",
"type": "->",
"args": [
[
"OC\\Activity\\Event"
]
]
},
{
"file": "/var/www/html/lib/private/Activity/Manager.php",
"line": 157,
"function": "receive",
"class": "OCA\\Activity\\Consumer",
"type": "->",
"args": [
[
"OC\\Activity\\Event"
]
]
},
{
"file": "/var/www/html/apps/dav/lib/CalDAV/Activity/Backend.php",
"line": 507,
"function": "publish",
"class": "OC\\Activity\\Manager",
"type": "->",
"args": [
[
"OC\\Activity\\Event"
]
]
},
{
"file": "/var/www/html/apps/dav/lib/Listener/ActivityUpdaterListener.php",
"line": 173,
"function": "onTouchCalendarObject",
"class": "OCA\\DAV\\CalDAV\\Activity\\Backend",
"type": "->",
"args": [
"object_update_event",
[
"*** sensitive parameters replaced ***",
"defaultcalendar",
"principals/users/qwc",
"http://sabre.io/ns/sync/4463",
4463,
"And 9 more entries, set log level to debug to see all entries"
],
[],
[
2488,
"*** sensitive parameters replaced ***",
1693387141,
"\"5c9389c2483e5e9ca4953aca3c566e07\"",
"*** sensitive parameters replaced ***",
"And 5 more entries, set log level to debug to see all entries"
]
]
},
{
"file": "/var/www/html/lib/private/EventDispatcher/ServiceEventListener.php",
"line": 86,
"function": "handle",
"class": "OCA\\DAV\\Listener\\ActivityUpdaterListener",
"type": "->",
"args": [
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
]
},
{
"file": "/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
"line": 251,
"function": "__invoke",
"class": "OC\\EventDispatcher\\ServiceEventListener",
"type": "->",
"args": [
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
],
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent",
[
"Symfony\\Component\\EventDispatcher\\EventDispatcher"
]
]
},
{
"file": "/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
"line": 73,
"function": "callListeners",
"class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
"type": "->",
"args": [
[
[
"Closure"
],
[
"Closure"
],
[
"Closure"
]
],
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent",
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
]
},
{
"file": "/var/www/html/lib/private/EventDispatcher/EventDispatcher.php",
"line": 94,
"function": "dispatch",
"class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
"type": "->",
"args": [
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
],
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
},
{
"file": "/var/www/html/lib/private/EventDispatcher/EventDispatcher.php",
"line": 106,
"function": "dispatch",
"class": "OC\\EventDispatcher\\EventDispatcher",
"type": "->",
"args": [
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent",
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
]
},
{
"file": "/var/www/html/apps/dav/lib/CalDAV/CalDavBackend.php",
"line": 1337,
"function": "dispatchTyped",
"class": "OC\\EventDispatcher\\EventDispatcher",
"type": "->",
"args": [
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
]
},
{
"file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
"line": 63,
"function": "OCA\\DAV\\CalDAV\\{closure}",
"class": "OCA\\DAV\\CalDAV\\CalDavBackend",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/dav/lib/CalDAV/CalDavBackend.php",
"line": 1346,
"function": "atomic",
"class": "OCA\\DAV\\CalDAV\\CalDavBackend",
"type": "->",
"args": [
[
"Closure"
],
[
"OC\\DB\\ConnectionAdapter"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/CalDAV/CalendarObject.php",
"line": 103,
"function": "updateCalendarObject",
"class": "OCA\\DAV\\CalDAV\\CalDavBackend",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 1137,
"function": "put",
"class": "Sabre\\CalDAV\\CalendarObject",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
"line": 492,
"function": "updateFile",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
"line": 89,
"function": "httpPut",
"class": "Sabre\\DAV\\CorePlugin",
"type": "->",
"args": [
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 472,
"function": "emit",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
"method:PUT",
[
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 253,
"function": "invokeMethod",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 321,
"function": "start",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/dav/lib/Server.php",
"line": 364,
"function": "exec",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/dav/appinfo/v2/remote.php",
"line": 35,
"function": "exec",
"class": "OCA\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/remote.php",
"line": 172,
"args": [
"/var/www/html/apps/dav/appinfo/v2/remote.php"
],
"function": "require_once"
}
],
"File": "/var/www/html/lib/private/DB/Exceptions/DbalException.php",
"Line": 71,
"Previous": {
"Exception": "Doctrine\\DBAL\\Exception\\DriverException",
"Message": "An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(255)",
"Code": 7,
"Trace": [
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1814,
"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": 1749,
"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": 1163,
"function": "convertExceptionDuringQuery",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
[
"Doctrine\\DBAL\\Driver\\PDO\\Exception"
],
"INSERT INTO \"oc_activity\" (\"app\", \"subject\", \"subjectparams\", \"message\", \"messageparams\", \"file\", \"link\", \"user\", \"affecteduser\", \"timestamp\", \"priority\", \"type\", \"object_type\", \"object_id\") VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
[
"dav",
"object_update_event_self",
"{\"actor\":\"qwc\",\"calendar\":{\"id\":5,\"uri\":\"defaultcalendar\",\"name\":\"Default calendar\"},\"object\":{\"id\":\"072a9ae2-ce22-46f2-9a32-c07e2e76f176\",\"name\":\"Kids abholen\",\"classified\":false,\"link\":{\"object_uri\":\"C88381E3-AAD3-4B2D-9629-8D9D66C9173B.ics\",\"calendar_uri\":\"defaultcalendar\",\"owner\":\"qwc\"}}}",
"",
"[]",
"And 9 more entries, set log level to debug to see all entries"
],
[]
]
},
{
"file": "/var/www/html/lib/private/DB/Connection.php",
"line": 295,
"function": "executeStatement",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
"INSERT INTO \"oc_activity\" (\"app\", \"subject\", \"subjectparams\", \"message\", \"messageparams\", \"file\", \"link\", \"user\", \"affecteduser\", \"timestamp\", \"priority\", \"type\", \"object_type\", \"object_id\") VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
[
"dav",
"object_update_event_self",
"{\"actor\":\"qwc\",\"calendar\":{\"id\":5,\"uri\":\"defaultcalendar\",\"name\":\"Default calendar\"},\"object\":{\"id\":\"072a9ae2-ce22-46f2-9a32-c07e2e76f176\",\"name\":\"Kids abholen\",\"classified\":false,\"link\":{\"object_uri\":\"C88381E3-AAD3-4B2D-9629-8D9D66C9173B.ics\",\"calendar_uri\":\"defaultcalendar\",\"owner\":\"qwc\"}}}",
"",
"[]",
"And 9 more entries, set log level to debug to see all entries"
],
[]
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
"line": 354,
"function": "executeStatement",
"class": "OC\\DB\\Connection",
"type": "->",
"args": [
"INSERT INTO \"oc_activity\" (\"app\", \"subject\", \"subjectparams\", \"message\", \"messageparams\", \"file\", \"link\", \"user\", \"affecteduser\", \"timestamp\", \"priority\", \"type\", \"object_type\", \"object_id\") VALUES(:app, :subject, :subjectparams, :message, :messageparams, :object_name, :link, :user, :affecteduser, :timestamp, :priority, :type, :object_type, :object_id)",
[
"dav",
"calendar_event",
"qwc",
"qwc",
1693387141,
"And 9 more entries, set log level to debug to see all entries"
],
[]
]
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 280,
"function": "execute",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 326,
"function": "execute",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/activity/lib/Data.php",
"line": 110,
"function": "executeStatement",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/activity/lib/Consumer.php",
"line": 68,
"function": "send",
"class": "OCA\\Activity\\Data",
"type": "->",
"args": [
[
"OC\\Activity\\Event"
]
]
},
{
"file": "/var/www/html/lib/private/Activity/Manager.php",
"line": 157,
"function": "receive",
"class": "OCA\\Activity\\Consumer",
"type": "->",
"args": [
[
"OC\\Activity\\Event"
]
]
},
{
"file": "/var/www/html/apps/dav/lib/CalDAV/Activity/Backend.php",
"line": 507,
"function": "publish",
"class": "OC\\Activity\\Manager",
"type": "->",
"args": [
[
"OC\\Activity\\Event"
]
]
},
{
"file": "/var/www/html/apps/dav/lib/Listener/ActivityUpdaterListener.php",
"line": 173,
"function": "onTouchCalendarObject",
"class": "OCA\\DAV\\CalDAV\\Activity\\Backend",
"type": "->",
"args": [
"object_update_event",
[
"*** sensitive parameters replaced ***",
"defaultcalendar",
"principals/users/qwc",
"http://sabre.io/ns/sync/4463",
4463,
"And 9 more entries, set log level to debug to see all entries"
],
[],
[
2488,
"*** sensitive parameters replaced ***",
1693387141,
"\"5c9389c2483e5e9ca4953aca3c566e07\"",
"*** sensitive parameters replaced ***",
"And 5 more entries, set log level to debug to see all entries"
]
]
},
{
"file": "/var/www/html/lib/private/EventDispatcher/ServiceEventListener.php",
"line": 86,
"function": "handle",
"class": "OCA\\DAV\\Listener\\ActivityUpdaterListener",
"type": "->",
"args": [
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
]
},
{
"file": "/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
"line": 251,
"function": "__invoke",
"class": "OC\\EventDispatcher\\ServiceEventListener",
"type": "->",
"args": [
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
],
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent",
[
"Symfony\\Component\\EventDispatcher\\EventDispatcher"
]
]
},
{
"file": "/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
"line": 73,
"function": "callListeners",
"class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
"type": "->",
"args": [
[
[
"Closure"
],
[
"Closure"
],
[
"Closure"
]
],
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent",
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
]
},
{
"file": "/var/www/html/lib/private/EventDispatcher/EventDispatcher.php",
"line": 94,
"function": "dispatch",
"class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
"type": "->",
"args": [
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
],
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
},
{
"file": "/var/www/html/lib/private/EventDispatcher/EventDispatcher.php",
"line": 106,
"function": "dispatch",
"class": "OC\\EventDispatcher\\EventDispatcher",
"type": "->",
"args": [
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent",
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
]
},
{
"file": "/var/www/html/apps/dav/lib/CalDAV/CalDavBackend.php",
"line": 1337,
"function": "dispatchTyped",
"class": "OC\\EventDispatcher\\EventDispatcher",
"type": "->",
"args": [
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
]
},
{
"file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
"line": 63,
"function": "OCA\\DAV\\CalDAV\\{closure}",
"class": "OCA\\DAV\\CalDAV\\CalDavBackend",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/dav/lib/CalDAV/CalDavBackend.php",
"line": 1346,
"function": "atomic",
"class": "OCA\\DAV\\CalDAV\\CalDavBackend",
"type": "->",
"args": [
[
"Closure"
],
[
"OC\\DB\\ConnectionAdapter"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/CalDAV/CalendarObject.php",
"line": 103,
"function": "updateCalendarObject",
"class": "OCA\\DAV\\CalDAV\\CalDavBackend",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 1137,
"function": "put",
"class": "Sabre\\CalDAV\\CalendarObject",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
"line": 492,
"function": "updateFile",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
"line": 89,
"function": "httpPut",
"class": "Sabre\\DAV\\CorePlugin",
"type": "->",
"args": [
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 472,
"function": "emit",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
"method:PUT",
[
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 253,
"function": "invokeMethod",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 321,
"function": "start",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/dav/lib/Server.php",
"line": 364,
"function": "exec",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/dav/appinfo/v2/remote.php",
"line": 35,
"function": "exec",
"class": "OCA\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/remote.php",
"line": 172,
"args": [
"/var/www/html/apps/dav/appinfo/v2/remote.php"
],
"function": "require_once"
}
],
"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php",
"Line": 91,
"Previous": {
"Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
"Message": "SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(255)",
"Code": 7,
"Trace": [
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"line": 103,
"function": "new",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
"type": "::",
"args": [
[
"PDOException",
[
"22001",
7,
"ERROR: value too long for type character varying(255)"
]
]
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1155,
"function": "execute",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
"type": "->",
"args": [
[
"dav",
"object_update_event_self",
"{\"actor\":\"qwc\",\"calendar\":{\"id\":5,\"uri\":\"defaultcalendar\",\"name\":\"Default calendar\"},\"object\":{\"id\":\"072a9ae2-ce22-46f2-9a32-c07e2e76f176\",\"name\":\"Kids abholen\",\"classified\":false,\"link\":{\"object_uri\":\"C88381E3-AAD3-4B2D-9629-8D9D66C9173B.ics\",\"calendar_uri\":\"defaultcalendar\",\"owner\":\"qwc\"}}}",
"",
"[]",
"And 9 more entries, set log level to debug to see all entries"
]
]
},
{
"file": "/var/www/html/lib/private/DB/Connection.php",
"line": 295,
"function": "executeStatement",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
"INSERT INTO \"oc_activity\" (\"app\", \"subject\", \"subjectparams\", \"message\", \"messageparams\", \"file\", \"link\", \"user\", \"affecteduser\", \"timestamp\", \"priority\", \"type\", \"object_type\", \"object_id\") VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
[
"dav",
"object_update_event_self",
"{\"actor\":\"qwc\",\"calendar\":{\"id\":5,\"uri\":\"defaultcalendar\",\"name\":\"Default calendar\"},\"object\":{\"id\":\"072a9ae2-ce22-46f2-9a32-c07e2e76f176\",\"name\":\"Kids abholen\",\"classified\":false,\"link\":{\"object_uri\":\"C88381E3-AAD3-4B2D-9629-8D9D66C9173B.ics\",\"calendar_uri\":\"defaultcalendar\",\"owner\":\"qwc\"}}}",
"",
"[]",
"And 9 more entries, set log level to debug to see all entries"
],
[]
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
"line": 354,
"function": "executeStatement",
"class": "OC\\DB\\Connection",
"type": "->",
"args": [
"INSERT INTO \"oc_activity\" (\"app\", \"subject\", \"subjectparams\", \"message\", \"messageparams\", \"file\", \"link\", \"user\", \"affecteduser\", \"timestamp\", \"priority\", \"type\", \"object_type\", \"object_id\") VALUES(:app, :subject, :subjectparams, :message, :messageparams, :object_name, :link, :user, :affecteduser, :timestamp, :priority, :type, :object_type, :object_id)",
[
"dav",
"calendar_event",
"qwc",
"qwc",
1693387141,
"And 9 more entries, set log level to debug to see all entries"
],
[]
]
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 280,
"function": "execute",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 326,
"function": "execute",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/activity/lib/Data.php",
"line": 110,
"function": "executeStatement",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/activity/lib/Consumer.php",
"line": 68,
"function": "send",
"class": "OCA\\Activity\\Data",
"type": "->",
"args": [
[
"OC\\Activity\\Event"
]
]
},
{
"file": "/var/www/html/lib/private/Activity/Manager.php",
"line": 157,
"function": "receive",
"class": "OCA\\Activity\\Consumer",
"type": "->",
"args": [
[
"OC\\Activity\\Event"
]
]
},
{
"file": "/var/www/html/apps/dav/lib/CalDAV/Activity/Backend.php",
"line": 507,
"function": "publish",
"class": "OC\\Activity\\Manager",
"type": "->",
"args": [
[
"OC\\Activity\\Event"
]
]
},
{
"file": "/var/www/html/apps/dav/lib/Listener/ActivityUpdaterListener.php",
"line": 173,
"function": "onTouchCalendarObject",
"class": "OCA\\DAV\\CalDAV\\Activity\\Backend",
"type": "->",
"args": [
"object_update_event",
[
"*** sensitive parameters replaced ***",
"defaultcalendar",
"principals/users/qwc",
"http://sabre.io/ns/sync/4463",
4463,
"And 9 more entries, set log level to debug to see all entries"
],
[],
[
2488,
"*** sensitive parameters replaced ***",
1693387141,
"\"5c9389c2483e5e9ca4953aca3c566e07\"",
"*** sensitive parameters replaced ***",
"And 5 more entries, set log level to debug to see all entries"
]
]
},
{
"file": "/var/www/html/lib/private/EventDispatcher/ServiceEventListener.php",
"line": 86,
"function": "handle",
"class": "OCA\\DAV\\Listener\\ActivityUpdaterListener",
"type": "->",
"args": [
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
]
},
{
"file": "/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
"line": 251,
"function": "__invoke",
"class": "OC\\EventDispatcher\\ServiceEventListener",
"type": "->",
"args": [
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
],
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent",
[
"Symfony\\Component\\EventDispatcher\\EventDispatcher"
]
]
},
{
"file": "/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
"line": 73,
"function": "callListeners",
"class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
"type": "->",
"args": [
[
[
"Closure"
],
[
"Closure"
],
[
"Closure"
]
],
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent",
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
]
},
{
"file": "/var/www/html/lib/private/EventDispatcher/EventDispatcher.php",
"line": 94,
"function": "dispatch",
"class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
"type": "->",
"args": [
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
],
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
},
{
"file": "/var/www/html/lib/private/EventDispatcher/EventDispatcher.php",
"line": 106,
"function": "dispatch",
"class": "OC\\EventDispatcher\\EventDispatcher",
"type": "->",
"args": [
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent",
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
]
},
{
"file": "/var/www/html/apps/dav/lib/CalDAV/CalDavBackend.php",
"line": 1337,
"function": "dispatchTyped",
"class": "OC\\EventDispatcher\\EventDispatcher",
"type": "->",
"args": [
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
]
},
{
"file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
"line": 63,
"function": "OCA\\DAV\\CalDAV\\{closure}",
"class": "OCA\\DAV\\CalDAV\\CalDavBackend",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/dav/lib/CalDAV/CalDavBackend.php",
"line": 1346,
"function": "atomic",
"class": "OCA\\DAV\\CalDAV\\CalDavBackend",
"type": "->",
"args": [
[
"Closure"
],
[
"OC\\DB\\ConnectionAdapter"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/CalDAV/CalendarObject.php",
"line": 103,
"function": "updateCalendarObject",
"class": "OCA\\DAV\\CalDAV\\CalDavBackend",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 1137,
"function": "put",
"class": "Sabre\\CalDAV\\CalendarObject",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
"line": 492,
"function": "updateFile",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
"line": 89,
"function": "httpPut",
"class": "Sabre\\DAV\\CorePlugin",
"type": "->",
"args": [
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 472,
"function": "emit",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
"method:PUT",
[
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 253,
"function": "invokeMethod",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 321,
"function": "start",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/dav/lib/Server.php",
"line": 364,
"function": "exec",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/dav/appinfo/v2/remote.php",
"line": 35,
"function": "exec",
"class": "OCA\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/remote.php",
"line": 172,
"args": [
"/var/www/html/apps/dav/appinfo/v2/remote.php"
],
"function": "require_once"
}
],
"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
"Line": 30,
"Previous": {
"Exception": "PDOException",
"Message": "SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(255)",
"Code": "22001",
"Trace": [
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"line": 101,
"function": "execute",
"class": "PDOStatement",
"type": "->",
"args": [
[
"dav",
"object_update_event_self",
"{\"actor\":\"qwc\",\"calendar\":{\"id\":5,\"uri\":\"defaultcalendar\",\"name\":\"Default calendar\"},\"object\":{\"id\":\"072a9ae2-ce22-46f2-9a32-c07e2e76f176\",\"name\":\"Kids abholen\",\"classified\":false,\"link\":{\"object_uri\":\"C88381E3-AAD3-4B2D-9629-8D9D66C9173B.ics\",\"calendar_uri\":\"defaultcalendar\",\"owner\":\"qwc\"}}}",
"",
"[]",
"And 9 more entries, set log level to debug to see all entries"
]
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1155,
"function": "execute",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
"type": "->",
"args": [
[
"dav",
"object_update_event_self",
"{\"actor\":\"qwc\",\"calendar\":{\"id\":5,\"uri\":\"defaultcalendar\",\"name\":\"Default calendar\"},\"object\":{\"id\":\"072a9ae2-ce22-46f2-9a32-c07e2e76f176\",\"name\":\"Kids abholen\",\"classified\":false,\"link\":{\"object_uri\":\"C88381E3-AAD3-4B2D-9629-8D9D66C9173B.ics\",\"calendar_uri\":\"defaultcalendar\",\"owner\":\"qwc\"}}}",
"",
"[]",
"And 9 more entries, set log level to debug to see all entries"
]
]
},
{
"file": "/var/www/html/lib/private/DB/Connection.php",
"line": 295,
"function": "executeStatement",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
"INSERT INTO \"oc_activity\" (\"app\", \"subject\", \"subjectparams\", \"message\", \"messageparams\", \"file\", \"link\", \"user\", \"affecteduser\", \"timestamp\", \"priority\", \"type\", \"object_type\", \"object_id\") VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
[
"dav",
"object_update_event_self",
"{\"actor\":\"qwc\",\"calendar\":{\"id\":5,\"uri\":\"defaultcalendar\",\"name\":\"Default calendar\"},\"object\":{\"id\":\"072a9ae2-ce22-46f2-9a32-c07e2e76f176\",\"name\":\"Kids abholen\",\"classified\":false,\"link\":{\"object_uri\":\"C88381E3-AAD3-4B2D-9629-8D9D66C9173B.ics\",\"calendar_uri\":\"defaultcalendar\",\"owner\":\"qwc\"}}}",
"",
"[]",
"And 9 more entries, set log level to debug to see all entries"
],
[]
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
"line": 354,
"function": "executeStatement",
"class": "OC\\DB\\Connection",
"type": "->",
"args": [
"INSERT INTO \"oc_activity\" (\"app\", \"subject\", \"subjectparams\", \"message\", \"messageparams\", \"file\", \"link\", \"user\", \"affecteduser\", \"timestamp\", \"priority\", \"type\", \"object_type\", \"object_id\") VALUES(:app, :subject, :subjectparams, :message, :messageparams, :object_name, :link, :user, :affecteduser, :timestamp, :priority, :type, :object_type, :object_id)",
[
"dav",
"calendar_event",
"qwc",
"qwc",
1693387141,
"And 9 more entries, set log level to debug to see all entries"
],
[]
]
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 280,
"function": "execute",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 326,
"function": "execute",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/activity/lib/Data.php",
"line": 110,
"function": "executeStatement",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/activity/lib/Consumer.php",
"line": 68,
"function": "send",
"class": "OCA\\Activity\\Data",
"type": "->",
"args": [
[
"OC\\Activity\\Event"
]
]
},
{
"file": "/var/www/html/lib/private/Activity/Manager.php",
"line": 157,
"function": "receive",
"class": "OCA\\Activity\\Consumer",
"type": "->",
"args": [
[
"OC\\Activity\\Event"
]
]
},
{
"file": "/var/www/html/apps/dav/lib/CalDAV/Activity/Backend.php",
"line": 507,
"function": "publish",
"class": "OC\\Activity\\Manager",
"type": "->",
"args": [
[
"OC\\Activity\\Event"
]
]
},
{
"file": "/var/www/html/apps/dav/lib/Listener/ActivityUpdaterListener.php",
"line": 173,
"function": "onTouchCalendarObject",
"class": "OCA\\DAV\\CalDAV\\Activity\\Backend",
"type": "->",
"args": [
"object_update_event",
[
"*** sensitive parameters replaced ***",
"defaultcalendar",
"principals/users/qwc",
"http://sabre.io/ns/sync/4463",
4463,
"And 9 more entries, set log level to debug to see all entries"
],
[],
[
2488,
"*** sensitive parameters replaced ***",
1693387141,
"\"5c9389c2483e5e9ca4953aca3c566e07\"",
"*** sensitive parameters replaced ***",
"And 5 more entries, set log level to debug to see all entries"
]
]
},
{
"file": "/var/www/html/lib/private/EventDispatcher/ServiceEventListener.php",
"line": 86,
"function": "handle",
"class": "OCA\\DAV\\Listener\\ActivityUpdaterListener",
"type": "->",
"args": [
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
]
},
{
"file": "/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
"line": 251,
"function": "__invoke",
"class": "OC\\EventDispatcher\\ServiceEventListener",
"type": "->",
"args": [
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
],
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent",
[
"Symfony\\Component\\EventDispatcher\\EventDispatcher"
]
]
},
{
"file": "/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
"line": 73,
"function": "callListeners",
"class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
"type": "->",
"args": [
[
[
"Closure"
],
[
"Closure"
],
[
"Closure"
]
],
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent",
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
]
},
{
"file": "/var/www/html/lib/private/EventDispatcher/EventDispatcher.php",
"line": 94,
"function": "dispatch",
"class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
"type": "->",
"args": [
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
],
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
},
{
"file": "/var/www/html/lib/private/EventDispatcher/EventDispatcher.php",
"line": 106,
"function": "dispatch",
"class": "OC\\EventDispatcher\\EventDispatcher",
"type": "->",
"args": [
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent",
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
]
},
{
"file": "/var/www/html/apps/dav/lib/CalDAV/CalDavBackend.php",
"line": 1337,
"function": "dispatchTyped",
"class": "OC\\EventDispatcher\\EventDispatcher",
"type": "->",
"args": [
[
"OCA\\DAV\\Events\\CalendarObjectUpdatedEvent"
]
]
},
{
"file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
"line": 63,
"function": "OCA\\DAV\\CalDAV\\{closure}",
"class": "OCA\\DAV\\CalDAV\\CalDavBackend",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/dav/lib/CalDAV/CalDavBackend.php",
"line": 1346,
"function": "atomic",
"class": "OCA\\DAV\\CalDAV\\CalDavBackend",
"type": "->",
"args": [
[
"Closure"
],
[
"OC\\DB\\ConnectionAdapter"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/CalDAV/CalendarObject.php",
"line": 103,
"function": "updateCalendarObject",
"class": "OCA\\DAV\\CalDAV\\CalDavBackend",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 1137,
"function": "put",
"class": "Sabre\\CalDAV\\CalendarObject",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
"line": 492,
"function": "updateFile",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
"line": 89,
"function": "httpPut",
"class": "Sabre\\DAV\\CorePlugin",
"type": "->",
"args": [
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 472,
"function": "emit",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
"method:PUT",
[
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 253,
"function": "invokeMethod",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": [
[
"Sabre\\HTTP\\Request"
],
[
"Sabre\\HTTP\\Response"
]
]
},
{
"file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 321,
"function": "start",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/dav/lib/Server.php",
"line": 364,
"function": "exec",
"class": "Sabre\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/apps/dav/appinfo/v2/remote.php",
"line": 35,
"function": "exec",
"class": "OCA\\DAV\\Server",
"type": "->",
"args": []
},
{
"file": "/var/www/html/remote.php",
"line": 172,
"args": [
"/var/www/html/apps/dav/appinfo/v2/remote.php"
],
"function": "require_once"
}
],
"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"Line": 101
}
}
},
"message": "Error generating activity for a deleted calendar object: An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(255)",
"exception": {},
"CustomMessage": "Error generating activity for a deleted calendar object: An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(255)"
}
OH Thank all gods humanity believes in, you gave the right hint!
The Activities extension caused the problem. Disabled it and everything works as expected!
Thank you very much for your work and your eagle eyes spotting the actual problem point. :heart:
Reopening to fix that in the activities app.
Steps to reproduce
Web:
Thunderbird:
Expected behavior
Appointment is saved and shown on all connected devices.
Actual behaviour
Web: The 'I am doing somthing' wheel is turning forever (after 20 minutes or so, i didn't care anymore...)
Thunderbird: That sneaky client actually cached the appointment, but it never reached the server - verified through looking at the Web version of the calendar. The Thunderbird instance of a second user did not save and show the entered appointment
Android: Not tested.
The same behaviour I can also witness with different users.
Calendar app version
4.4.4
CalDAV-clients used
Thunderbird
Browser
Vivaldi 6.1.3035.302, Firefox (latest, windows)
Client operating system
Arch Linux, Windows
Server operating system
Arch Linux (Nextcloud AIO - Docker)
Web server
Apache
Database engine version
PostgreSQL
PHP engine version
None
Nextcloud version
27.0.2
Updated from an older installed version or fresh install
Updated from an older version
List of activated apps
Nextcloud configuration
Web server error log
No response
Log file
No response
Browser log
No response
Additional info
I tried a bunch of things to see what is going on.
New Calendar
So I created a new calendar, added an appointment, voila, works. (What the hell?!)
Reimport current calendar into a new one
Okay, as adding an appointment to a new calendar works - I tried to reimport my current into a new one.
Now it gets funny...
Importing works fine, no actual errors. But the calendar items do not appear in the WebGUI - no matter what.
What actually happens is that the invitation emails are sent again of still running regular appointments - WTF?!
So sooomething got inserted actually...
Got now two calendars with the same content, the original (where I can see the items) and another one where I cannot. And as I cannot verify through GUI that I can add an item to the new-re-imported calendar I skipped trying that. I could of course access the database directly, but honestly I do not have time for that.
I can provide more information, dumping anything to a textfile where possible, on request.
Affected users
I assume the whole instance is affected by this problem. Tested my own user and a second existing. (did actually NOT try to create a new user)
I hope this problem is known and a solution fast and easy. If not, I may of course help trying to nail this down. It is actually a showstopper for the whole calendar app, and actually almost the whole nextcloud, as I manage my life through my nextcloud instance. (That's why i labeled that as a blocker...)