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

Steps to reproduce

unknown

Expected behavior

No errors

Actual behavior

Every day those entries are found in nextcloud.log

Mail app version

2.2.5

Mailserver or service

Postfix

Operating system

Debian 11

PHP engine version

PHP 7.4

Web server

Apache (supported)

Database

MySQL

Additional info

[core] Fehler: Doctrine\DBAL\Query\QueryException: More than 1000 expressions in a list are not allowed on Oracle. at <>

0. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 294
   OC\DB\QueryBuilder\QueryBuilder->execute()
1. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 336
   OC\DB\QueryBuilder\QueryBuilder->executeQuery()
2. /var/www/nextcloud/apps/mail/lib/Db/MessageMapper.php line 1381
   OCP\AppFramework\Db\QBMapper->findEntities()
3. /var/www/nextcloud/apps/mail/lib/Service/PreprocessingService.php line 66
   OCA\Mail\Db\MessageMapper->getUnanalyzed()
4. /var/www/nextcloud/apps/mail/lib/BackgroundJob/PreviewEnhancementProcessingJob.php line 94
   OCA\Mail\Service\PreprocessingService->process()
5. /var/www/nextcloud/lib/public/BackgroundJob/Job.php line 78
   OCA\Mail\BackgroundJob\PreviewEnhancementProcessingJob->run()
6. /var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php line 103
   OCP\BackgroundJob\Job->start()
7. /var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php line 93
   OCP\BackgroundJob\TimedJob->start()
8. /var/www/nextcloud/cron.php line 152
   OCP\BackgroundJob\TimedJob->execute()

Start by reading apps/mail/lib/Service/PreprocessingService.php at line 66 and apps/mail/lib/Db/MessageMapper.php at line 1381, then trace the PreviewEnhancementProcessingJob entry point. The reported failure is the Oracle limit on more than 1000 expressions in a list; completion should prevent this exception from appearing during background preprocessing.