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

[paramazo]

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()

[stefangweichinger]

Seeing a similar issue on NC-26.0.2, mail-3.1.1.
Unsure if it is the same issue or not.

formatted

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

0. /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php line 293
   OC\DB\QueryBuilder\QueryBuilder->execute()
1. /var/www/html/lib/public/AppFramework/Db/QBMapper.php line 336
   OC\DB\QueryBuilder\QueryBuilder->executeQuery()
2. /var/www/html/apps/mail/lib/Db/MessageMapper.php line 1389
   OCP\AppFramework\Db\QBMapper->findEntities(["OC\\DB\\QueryBuilder\\QueryBuilder"])
3. /var/www/html/apps/mail/lib/Service/PreprocessingService.php line 66
   OCA\Mail\Db\MessageMapper->getUnanalyzed(1684829814, [51876,51877,518 ... "])
4. /var/www/html/apps/mail/lib/BackgroundJob/PreviewEnhancementProcessingJob.php line 94
   OCA\Mail\Service\PreprocessingService->process(1684829814, ["OCA\\Mail\\Account"])
5. /var/www/html/lib/public/BackgroundJob/Job.php line 78
   OCA\Mail\BackgroundJob\PreviewEnhancementProcessingJob->run([13])
6. /var/www/html/lib/public/BackgroundJob/TimedJob.php line 103
   OCP\BackgroundJob\Job->start(["OC\\BackgroundJob\\JobList"])
7. /var/www/html/lib/public/BackgroundJob/TimedJob.php line 93
   OCP\BackgroundJob\TimedJob->start(["OC\\BackgroundJob\\JobList"])
8. /var/www/html/cron.php line 152
   OCP\BackgroundJob\TimedJob->execute(["OC\\BackgroundJob\\JobList"], ["OC\\Log"])

at 2023-06-06T08:16:54+00:00

raw

{"reqId":"HPrax4K5XOfzx3tciOin","level":3,"time":"2023-06-06T08:16:54+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"--","message":"More than 1000 expressions in a list are not allowed on Oracle.","userAgent":"--","version":"26.0.2.1","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/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/public/AppFramework/Db/QBMapper.php","line":336,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/mail/lib/Db/MessageMapper.php","line":1389,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"]]},{"file":"/var/www/html/apps/mail/lib/Service/PreprocessingService.php","line":66,"function":"getUnanalyzed","class":"OCA\\Mail\\Db\\MessageMapper","type":"->","args":[1684829814,[51876,51877,51878,51879,51880,"And 3901 more entries, set log level to debug to see all entries"]]},{"file":"/var/www/html/apps/mail/lib/BackgroundJob/PreviewEnhancementProcessingJob.php","line":94,"function":"process","class":"OCA\\Mail\\Service\\PreprocessingService","type":"->","args":[1684829814,["OCA\\Mail\\Account"]]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":78,"function":"run","class":"OCA\\Mail\\BackgroundJob\\PreviewEnhancementProcessingJob","type":"->","args":[[13]]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":103,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":93,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/var/www/html/cron.php","line":152,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"],["OC\\Log"]]}],"File":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","Line":263,"message":"More than 1000 expressions in a list are not allowed on Oracle.","query":"SELECT * FROM `*PREFIX*mail_messages` WHERE (`sent_at` <= :dcValue1) AND (`structure_analyzed` = :dcValue2) AND (`mailbox_id` IN (:dcValue3)) ORDER BY `sent_at` ASC","exception":[],"CustomMessage":"More than 1000 expressions in a list are not allowed on Oracle."},"id":"647eeb768bc57"}

[wriver4]

Adding my 2 cents:
[core] Error: More than 1000 expressions in a list are not allowed on Oracle.
POST /index.php/apps/mail/api/mailboxes/4933/sync
from 136.61.208.132 by leonwittman at Nov 22, 2024, 5:59:01 PM
Leon is our sales guy.