Support intro
Sorry to hear you’re facing problems. 
The community help forum (help.nextcloud.com) is for home and non-enterprise users. Support is provided by other community members on a best effort / “as available” basis. All of those responding are volunteering their time to help you.
If you’re using Nextcloud in a business/critical setting, paid and SLA-based support services can be accessed via portal.nextcloud.com where Nextcloud engineers can help ensure your business keeps running smoothly.
Getting help
In order to help you as efficiently (and quickly!) as possible, please fill in as much of the below requested information as you can.
Before clicking submit: Please check if your query is already addressed via the following resources:
- Official documentation (searchable and regularly updated)
- How to topics and FAQs
- Forum search
(Utilizing these existing resources is typically faster. It also helps reduce the load on our generous volunteers while elevating the signal to noise ratio of the forums otherwise arising from the same queries being posted repeatedly).
Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can. 
The Basics
- Nextcloud Server version (e.g., 29.x.x):
31.0.8
- Operating system and version (e.g., Ubuntu 24.04):
debian 13
- Web server and version (e.g, Apache 2.4.25):
AIO -Apache
- Reverse proxy and version _(e.g. nginx 1.27.2)
-
- PHP version (e.g, 8.3):
8.3.24
- Is this the first time you’ve seen this error? (Yes / No):
yes
- When did this problem seem to first start?
after clustering
- Installation method (e.g. AlO, NCP, Bare Metal/Archive, etc.)
AIO
- Are you using CloudfIare, mod_security, or similar? (Yes / No)
no
Summary of the issue you are facing:
Hey,
i switched over form a native installation to AIO, because I changed my setup (home server) a bit.
As my internet connection got a upgrade. I really would love to use memories with facerecongition. After moving my data to my new server and configuring/installing nextcloud AIO, I startet the face recognition background job. I’m having 80755 pictures. So the whole recognition thing took around 8 days. Yesterday I had a look at the backend and the background job seems to be done. If I look at the facerecognition App, in NC, I still get the message “no persons found, come back later”. So I tried a bit and found via the stats, that’s 80755 images processed and 72305 face recognized. If I try to run the background job again, I get the error
Face clustering will be created for the first time.
There are 71759 faces for clustering.
Error during background task execution
If error is not transient, this means that core component of face recognition is not working properly
and that quantity and quality of detected faces and person will be low or suboptimal.
You probably want to file an issue (please include exception below) to: https://github.com/matiasdelellis/facerecognition/issues
In DbalException.php line 56:
An exception occurred while executing a query: SQLSTATE[HY000]: General err
or: 7 number of parameters must be between 0 and 65535
In ExceptionConverter.php line 87:
An exception occurred while executing a query: SQLSTATE[HY000]: General err
or: 7 number of parameters must be between 0 and 65535
In Exception.php line 24:
SQLSTATE[HY000]: General error: 7 number of parameters must be between 0 an
d 65535
In Statement.php line 130:
SQLSTATE[HY000]: General error: 7 number of parameters must be between 0 an
d 65535
face:background_job [-u|--user_id USER_ID] [-M|--max_image_area MAX_IMAGE_AREA] [--sync-mode] [--analyze-mode] [--cluster-mode] [--defer-clustering] [-t|--timeout TIMEOUT]
Steps to replicate it (hint: details matter!):
- docker exec --user www-data -it nextcloud-aio-nextcloud php occ face:background_job -u david → starting recognition
- docker exec --user www-data -it nextcloud-aio-nextcloud php occ face:stats -u USERNAME → Show stats.
Log entries
Nextcloud
Please provide the log entries from your Nextcloud log that are generated during the time of problem (via the Copy raw option from Administration settings->Logging screen or from your nextcloud.log located in your data directory). Feel free to use a pastebin/gist service if necessary.
{"reqId":"2SNQRPnPZGm6l3pG2I7x","level":3,"time":"2025-09-02T09:40:10+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"--","message":"The number of parameters must not exceed 65535. Restriction by PostgreSQL.","userAgent":"--","version":"31.0.8.1","exception":{"Exception":"Doctrine\\DBAL\\Query\\QueryException","Message":"The number of parameters must not exceed 65535. Restriction by PostgreSQL.","Code":0,"Trace":[{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":284,"function":"prepareForExecute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/custom_apps/facerecognition/lib/Db/FaceMapper.php","line":61,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/custom_apps/facerecognition/lib/BackgroundJob/Tasks/CreateClustersTask.php","line":182,"function":"findDescriptorsBathed","class":"OCA\\FaceRecognition\\Db\\FaceMapper","type":"->","args":[[1,2,3,4,5,"And 71754 more entries, set log level to debug to see all entries"]]},{"file":"/var/www/html/custom_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/html/custom_apps/facerecognition/lib/BackgroundJob/BackgroundService.php","line":150,"function":"execute","class":"OCA\\FaceRecognition\\BackgroundJob\\Tasks\\CreateClustersTask","type":"->","args":[{"__class__":"OCA\\FaceRecognition\\BackgroundJob\\FaceRecognitionContext","userManager":{"__class__":"OC\\User\\Manager"},"config":{"__class__":"OC\\AllConfig"},"logger":{"__class__":"OCA\\FaceRecognition\\BackgroundJob\\FaceRecognitionLogger"},"user":{"__class__":"OC\\User\\User"},"verbose":false,"propertyBag":{"max_image_area":null,"run_mode":"default-mode","StaleImagesRemovalTask_staleRemovedImages":0}}]},{"file":"/var/www/html/custom_apps/facerecognition/lib/Command/BackgroundCommand.php","line":192,"function":"execute","class":"OCA\\FaceRecognition\\BackgroundJob\\BackgroundService","type":"->","args":[0,false,{"__class__":"OC\\User\\User"},null,"default-mode"]},{"file":"/var/www/html/3rdparty/symfony/console/Command/Command.php","line":326,"function":"execute","class":"OCA\\FaceRecognition\\Command\\BackgroundCommand","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":1078,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":324,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"OCA\\FaceRecognition\\Command\\BackgroundCommand"},{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":175,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/lib/private/Console/Application.php","line":187,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"}]},{"file":"/var/www/html/occ","line":33,"args":["/var/www/html/console.php"],"function":"require_once"}],"File":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","Line":246,"message":"The number of parameters must not exceed 65535. Restriction by PostgreSQL.","query":"SELECT `id`, `descriptor` FROM `*PREFIX*facerecog_faces` `f` WHERE `id` IN (:face_ids)","exception":[],"CustomMessage":"The number of parameters must not exceed 65535. Restriction by PostgreSQL."},"id":"68b6c2ca12d6d"}
{"reqId":"2SNQRPnPZGm6l3pG2I7x","level":3,"time":"2025-09-02T09:40:10+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.8.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":284,"function":"prepareForExecute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/custom_apps/facerecognition/lib/Db/FaceMapper.php","line":61,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/custom_apps/facerecognition/lib/BackgroundJob/Tasks/CreateClustersTask.php","line":182,"function":"findDescriptorsBathed","class":"OCA\\FaceRecognition\\Db\\FaceMapper","type":"->","args":[[1,2,3,4,5,"And 71754 more entries, set log level to debug to see all entries"]]},{"file":"/var/www/html/custom_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/html/custom_apps/facerecognition/lib/BackgroundJob/BackgroundService.php","line":150,"function":"execute","class":"OCA\\FaceRecognition\\BackgroundJob\\Tasks\\CreateClustersTask","type":"->","args":[{"__class__":"OCA\\FaceRecognition\\BackgroundJob\\FaceRecognitionContext","userManager":{"__class__":"OC\\User\\Manager"},"config":{"__class__":"OC\\AllConfig"},"logger":{"__class__":"OCA\\FaceRecognition\\BackgroundJob\\FaceRecognitionLogger"},"user":{"__class__":"OC\\User\\User"},"verbose":false,"propertyBag":{"max_image_area":null,"run_mode":"default-mode","StaleImagesRemovalTask_staleRemovedImages":0}}]},{"file":"/var/www/html/custom_apps/facerecognition/lib/Command/BackgroundCommand.php","line":192,"function":"execute","class":"OCA\\FaceRecognition\\BackgroundJob\\BackgroundService","type":"->","args":[0,false,{"__class__":"OC\\User\\User"},null,"default-mode"]},{"file":"/var/www/html/3rdparty/symfony/console/Command/Command.php","line":326,"function":"execute","class":"OCA\\FaceRecognition\\Command\\BackgroundCommand","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":1078,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":324,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"OCA\\FaceRecognition\\Command\\BackgroundCommand"},{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":175,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/lib/private/Console/Application.php","line":187,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"}]},{"file":"/var/www/html/occ","line":33,"args":["/var/www/html/console.php"],"function":"require_once"}],"File":"/var/www/html/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":"68b6c2ca12e11"}
Nextcloud
The output of occ config:list system:
{
"system": {
"one-click-instance": true,
"one-click-instance.user-limit": 100,
"memcache.local": "\\OC\\Memcache\\APCu",
"default_phone_region": "DE",
"apps_paths": [
{
"path": "\/var\/www\/html\/apps",
"url": "\/apps",
"writable": false
},
{
"path": "\/var\/www\/html\/custom_apps",
"url": "\/custom_apps",
"writable": true
}
],
"check_data_directory_permissions": false,
"memcache.distributed": "\\OC\\Memcache\\Redis",
"memcache.locking": "\\OC\\Memcache\\Redis",
"redis": {
"host": "***REMOVED SENSITIVE VALUE***",
"password": "***REMOVED SENSITIVE VALUE***",
"port": 6379
},
"overwritehost": "ncaio.davidkumar.de",
"overwriteprotocol": "https",
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": [
"localhost",
"ncaio.davidkumar.de"
],
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"dbtype": "pgsql",
"version": "31.0.8.1",
"overwrite.cli.url": "https:\/\/ncaio.davidkumar.de\/",
"dbname": "***REMOVED SENSITIVE VALUE***",
"dbhost": "***REMOVED SENSITIVE VALUE***",
"dbport": "",
"dbtableprefix": "oc_",
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"installed": true,
"instanceid": "***REMOVED SENSITIVE VALUE***",
"maintenance": false,
"updatechecker": false,
"loglevel": 2,
"log_type": "file",
"logfile": "\/var\/www\/html\/data\/nextcloud.log",
"log_rotate_size": 10485760,
"log.condition": {
"apps": [
"admin_audit"
]
},
"preview_max_x": 2048,
"preview_max_y": 2048,
"jpeg_quality": 60,
"enabledPreviewProviders": {
"1": "OC\\Preview\\Image",
"2": "OC\\Preview\\MarkDown",
"3": "OC\\Preview\\MP3",
"4": "OC\\Preview\\TXT",
"5": "OC\\Preview\\OpenDocument",
"6": "OC\\Preview\\Movie",
"7": "OC\\Preview\\Krita"
},
"enable_previews": true,
"upgrade.disable-web": true,
"mail_smtpmode": "smtp",
"trashbin_retention_obligation": "auto, 30",
"versions_retention_obligation": "auto, 30",
"activity_expire_days": 30,
"simpleSignUpLink.shown": false,
"share_folder": "\/Shared",
"one-click-instance.link": "https:\/\/nextcloud.com\/all-in-one\/",
"upgrade.cli-upgrade-link": "https:\/\/github.com\/nextcloud\/all-in-one\/discussions\/2726",
"updatedirectory": "\/nc-updater",
"maintenance_window_start": 100,
"allow_local_remote_servers": true,
"davstorage.request_timeout": 3600,
"documentation_url.server_logs": "https:\/\/github.com\/nextcloud\/all-in-one\/discussions\/5425",
"htaccess.RewriteBase": "\/",
"dbpersistent": false,
"auth.bruteforce.protection.enabled": true,
"ratelimit.protection.enabled": true,
"files_external_allow_create_new_local": false,
"trusted_proxies": "***REMOVED SENSITIVE VALUE***",
"preview_imaginary_key": "***REMOVED SENSITIVE VALUE***",
"facerecognition.external_model_url": "nextcloud-aio-facerecognition:5000",
"facerecognition.external_model_api_key": "some-super-secret-api-key",
"enabledFaceRecognitionMimetype": [
"image\/jpeg",
"image\/png",
"image\/heic",
"image\/tiff",
"image\/webp"
],
"memories.db.triggers.fcu": true,
"memories.exiftool": "\/var\/www\/html\/custom_apps\/memories\/bin-ext\/exiftool-amd64-musl",
"memories.vod.path": "\/var\/www\/html\/custom_apps\/memories\/bin-ext\/go-vod-amd64",
"memories.vod.ffmpeg": "\/usr\/bin\/ffmpeg",
"memories.vod.ffprobe": "\/usr\/bin\/ffprobe",
"memories.vod.external": true,
"memories.vod.connect": "nextcloud-aio-memories:47788",
"mail_sendmailmode": "smtp",
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"mail_smtphost": "***REMOVED SENSITIVE VALUE***",
"mail_smtpport": "465",
"mail_smtpauth": true,
"mail_smtpname": "***REMOVED SENSITIVE VALUE***",
"mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
"mail_smtpsecure": "ssl",
"app_install_overwrite": [],
"DOMAIN": "ncaio.davidkumar.de"
}
}
Apps
The output of occ app:list (if possible).
Enabled:
- activity: 4.0.0
- admin_audit: 1.21.0
- bruteforcesettings: 4.0.0
- calendar: 5.5.1
- circles: 31.0.0
- cloud_federation_api: 1.14.0
- comments: 1.21.0
- contacts: 7.2.6
- contactsinteraction: 1.12.0
- dashboard: 7.11.0
- dav: 1.33.0
- deck: 1.15.2
- facerecognition: 0.9.70
- federatedfilesharing: 1.21.0
- federation: 1.21.0
- files: 2.3.1
- files_downloadlimit: 4.0.0
- files_fulltextsearch: 31.0.0
- files_pdfviewer: 4.0.0
- files_reminders: 1.4.0
- files_sharing: 1.23.1
- files_trashbin: 1.21.0
- files_versions: 1.24.0
- firstrunwizard: 4.0.0
- forms: 5.1.2
- fulltextsearch: 31.0.0
- fulltextsearch_elasticsearch: 31.0.0
- integration_google: 4.1.0
- integration_paperless: 1.0.7
- keeweb: 0.6.21
- logreader: 4.0.0
- lookup_server_connector: 1.19.0
- maps: 1.6.0
- memories: 7.6.2
- nextcloud-aio: 0.8.0
- nextcloud_announcements: 3.0.0
- notes: 4.12.3
- notifications: 4.0.0
- notify_push: 1.2.0
- oauth2: 1.19.1
- password_policy: 3.0.0
- photos: 4.0.0
- polls: 8.4.3
- previewgenerator: 5.9.0
- privacy: 3.0.0
- profile: 1.0.0
- provisioning_api: 1.21.0
- recommendations: 4.0.0
- related_resources: 2.0.0
- richdocuments: 8.7.4
- serverinfo: 3.0.0
- settings: 1.14.0
- sharebymail: 1.21.0
- spreed: 21.1.4
- support: 3.0.0
- survey_client: 3.0.0
- systemtags: 1.21.1
- tables: 0.9.5
- tasks: 0.16.1
- text: 5.0.0
- theming: 2.6.1
- twofactor_backupcodes: 1.20.0
- twofactor_totp: 13.0.0-dev.0
- updatenotification: 1.21.0
- user_migration: 8.0.0
- user_status: 1.11.0
- viewer: 4.0.0
- weather_status: 1.11.0
- webhook_listeners: 1.2.0
- whiteboard: 1.1.3
- workflowengine: 2.13.0
Disabled: - app_api: 5.0.2 (installed 5.0.2)
- encryption: 2.19.0
- files_external: 1.23.0
- suspicious_login: 9.0.1
- twofactor_nextcloud_notification: 5.0.0
- user_ldap: 1.22.0
Any ideas?
Thanks.
If possible I don’t want to thow the recognitions away..