Face Recognition Clustering Faces - database 1000 limit issue

[rohitnanda1443]

Hi I am facing an issue with my Face Recognition app.

1. Nextcloud has put a limit of 1000 for database access (as oracle does not allow more than 1000 queries at a time). Even though the backend database is postgres / maria.

2. Face Recognition does the clustering at at one go and thereby unable to cluster the faces as we get >1000 query error.

"{"reqId":"vDU6uFiHscWHWGDIdlbE","level":3,"time":"2026-02-03T08:33:18+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"--","message":"More than 1000 expressions in a list are not allowed on Oracle.","userAgent":"--","version":"31.0.10.2","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/localhost/htdocs/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":284,"function":"prepareForExecute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->"},{"file":"/var/www/localhost/htdocs/nextcloud/apps/facerecognition/lib/Db/FaceMapper.php","line":61,"function":"executeQuery","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->"},{"file":"/var/www/localhost/htdocs/nextcloud/apps/facerecognition/lib/BackgroundJob/Tasks/CreateClustersTask.php","line":182,"function":"findDescriptorsBathed","class":"OCA\FaceRecognition\Db\FaceMapper","type":"->"},{"file":"/var/www/localhost/htdocs/nextcloud/apps/facerecognition/lib/BackgroundJob/Tasks/CreateClustersTask.php","line":90,"function":"createClusterIfNeeded","class":"OCA\FaceRecognition\BackgroundJob\Tasks\CreateClustersTask","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/localhost/htdocs/nextcloud/apps/facerecognition/lib/BackgroundJob/BackgroundService.php","line":150,"function":"execute","class":"OCA\FaceRecognition\BackgroundJob\Tasks\CreateClustersTask","type":"->"},{"file":"/var/www/localhost/htdocs/nextcloud/apps/facerecognition/lib/Command/BackgroundCommand.php","line":192,"function":"execute","class":"OCA\FaceRecognition\BackgroundJob\BackgroundService","type":"->"},{"file":"/var/www/localhost/htdocs/nextcloud/3rdparty/symfony/console/Command/Command.php","line":326,"function":"execute","class":"OCA\FaceRecognition\Command\BackgroundCommand","type":"->"},{"file":"/var/www/localhost/htdocs/nextcloud/3rdparty/symfony/console/Application.php","line":1078,"function":"run","class":"Symfony\Component\Console\Command\Command","type":"->"},{"file":"/var/www/localhost/htdocs/nextcloud/3rdparty/symfony/console/Application.php","line":324,"function":"doRunCommand","class":"Symfony\Component\Console\Application","type":"->"},{"file":"/var/www/localhost/htdocs/nextcloud/3rdparty/symfony/console/Application.php","line":175,"function":"doRun","class":"Symfony\Component\Console\Application","type":"->"},{"file":"/var/www/localhost/htdocs/nextcloud/lib/private/Console/Application.php","line":187,"function":"run","class":"Symfony\Component\Console\Application","type":"->"},{"file":"/var/www/localhost/htdocs/nextcloud/console.php","line":87,"function":"run","class":"OC\Console\Application","type":"->"},{"file":"/var/www/localhost/htdocs/nextcloud/occ","line":33,"args":["/var/www/localhost/htdocs/nextcloud/console.php"],"function":"require_once"}],"File":"/var/www/localhost/htdocs/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","Line":237,"message":"More than 1000 expressions in a list are not allowed on Oracle.","query":"SELECT id, descriptor FROM *PREFIX*facerecog_faces f WHERE id IN (:face_ids)","exception":[],"CustomMessage":"More than 1000 expressions in a list are not allowed on Oracle."},"id":"6981c7a37c2fd"}"

How to resolve this?

[EngTurtle]

This is a duplicate of #786. If you're willing to edit the php files of the app then this change should address the issue.