Error: More than 1000 expressions in a list are not allowed on Oracle

[kernie]

Expected behavior

Don't know. Saw the error below...

Follow-up of #4911

Actual behavior

Error message: "More than 1000 expressions in a list are not allowed on Oracle."

{"reqId":"xbBp071iU3q7z6zx7mlc","level":3,"time":"2021-04-10T10:17:25+00:00","remoteAddr":"","user":"","app":"core","method":"POST","url":"/apps/mail/api/mailboxes/147/sync","message":{"Exception":"Doctrine\\DBAL\\Query\\QueryException","Message":"More than 1000 expressions in a list are not allowed on Oracle.","Code":0,"Trace":[{"file":"/srv/www/htdocs/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":320,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/srv/www/htdocs/nextcloud/apps/mail/lib/Db/MessageMapper.php","line":592,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/srv/www/htdocs/nextcloud/apps/mail/lib/Service/Sync/SyncService.php","line":156,"function":"findIdsByQuery","class":"OCA\\Mail\\Db\\MessageMapper","type":"->"},{"file":"/srv/www/htdocs/nextcloud/apps/mail/lib/Service/Sync/SyncService.php","line":126,"function":"getDatabaseSyncChanges","class":"OCA\\Mail\\Service\\Sync\\SyncService","type":"->"},{"file":"/srv/www/htdocs/nextcloud/apps/mail/lib/Controller/MailboxesController.php","line":161,"function":"syncMailbox","class":"OCA\\Mail\\Service\\Sync\\SyncService","type":"->"},{"file":"/srv/www/htdocs/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":218,"function":"sync","class":"OCA\\Mail\\Controller\\MailboxesController","type":"->"},{"file":"/srv/www/htdocs/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":127,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/srv/www/htdocs/nextcloud/lib/private/AppFramework/App.php","line":157,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/srv/www/htdocs/nextcloud/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/srv/www/htdocs/nextcloud/lib/base.php","line":993,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/srv/www/htdocs/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::"}],"File":"/srv/www/htdocs/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","Line":268,"CustomMessage":"More than 1000 expressions in a list are not allowed on Oracle."},"userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Firefox/78.0","version":"21.0.1.1"}

Mail app

Mail app version: 1.9.5

Mailserver or service: Mailbox.org

Server configuration

Operating system: Ubunut 18.04

Web server: Apache 2.4

Database: MariaDB 10.3

PHP version: 8.0

Nextcloud Version: 21.0.1.1

Client configuration

Browser: (e.g. Firefox 48) Firefox 78

Operating system: OpenSuSE 15.2