Nextcloud core error: "Doctrine\DBAL\Query\QueryException: More than 1000 expressions in a list are not allowed on Oracle."

[tdoerschel]

Hi,
I just found the following error in the NC log. We have around 1900 contact entries. I guess it happened when user invited attendees in the calender meeting.
I report it here to calendar app because the log refers to /var/www/nextcloud/apps/calendar/lib/Controller/ContactController.php
Unfortunatelly, I cannot reproduce it right now.

Nextcloud 22.2.3
MariaDB mysql 10.3.31
PHP-FPM 8.0.12
contacts app 4.0.6
calendar app 2.3.4

Might be related to the these issues:
nextcloud/mail#4584
nextcloud/server#25036

{"reqId":"dFbRLS1WxOyonNv5BT3T","level":3,"time":"2021-11-17T14:48:42+00:00","remoteAddr":"XXXXXXXX","user":"XXXXXXXX","app":"core","method":"POST","url":"/index.php/apps/calendar/v1/autocompletion/attendee","message":"More than 1000 expressions in a list are not allowed on Oracle.","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.69 Safari/537.36","version":"22.2.3.0","exception":{"Exception":"Doctrine\DBAL\Query\QueryException","Message":"More than 1000 expressions in a list are not allowed on Oracle.","Code":0,"Trace":[{"file":"/var/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php","line":1132,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php","line":1030,"function":"searchByAddressBookIds","class":"OCA\DAV\CardDAV\CardDavBackend","type":"->"},{"file":"/var/www/nextcloud/apps/dav/lib/CardDAV/AddressBookImpl.php","line":119,"function":"search","class":"OCA\DAV\CardDAV\CardDavBackend","type":"->"},{"file":"/var/www/nextcloud/lib/private/ContactsManager.php","line":51,"function":"search","class":"OCA\DAV\CardDAV\AddressBookImpl","type":"->"},{"file":"/var/www/nextcloud/apps/calendar/lib/Controller/ContactController.php","line":125,"function":"search","class":"OC\ContactsManager","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":217,"function":"searchAttendee","class":"OCA\Calendar\Controller\ContactController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":126,"function":"executeController","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":156,"function":"dispatch","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\AppFramework\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":1006,"function":"match","class":"OC\Route\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","Line":268,"CustomMessage":"More than 1000 expressions in a list are not allowed on Oracle."},"id":"6196336ee609e"}

[miaulalala]

fixed in nextcloud/server#31274