I am receiving this error, and it is referenced in March of 2021 as being an issue.
I’ve ignored it so far. Figured since it persisted into what is now my second major update from 28, I would post it here.
QueryException
More than 1000 expressions in a list are not allowed on Oracle.
The error has really been logging from 28 (or earlier) to 30.0.6. I could go into the code and comment it out. The reference to Oracle might be a bit outdated, and I can only guess why it is still there, so have not followed others’ solutions to remove it. Has this truly been fixed and somehow I have old code sticking around? Is anyone else seeing these log errors?
Thanks,
–Joe.
Nextcloud Hub 9 (30.0.6)
nginx app server
Postgres database
Operating System: Linux 5.15.0-134-generic x86_64
CPU: Intel(R) Xeon(R) CPU E5649 @ 2.53GHz (24 threads)
Memory: 125.78 GB
Files: 1152741
Storages: 68
Free Space: 1.2 TB
Version: 8.2.27
Memory limit: 10 GB
Max execution time: 20000
Upload max size: 50 GB
OPcache Revalidate Frequency: 60
Extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, random, Reflection, SPL, session, standard, sodium, cgi-fcgi, pdlib, PDO, xml, apcu, bcmath, bz2, calendar, ctype, curl, dom, mbstring, FFI, fileinfo, ftp, gd, gettext, gmp, iconv, igbinary, imagick, intl, exif, pdo_pgsql, pgsql, Phar, posix, readline, redis, shmop, SimpleXML, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, xmlreader, xmlwriter, xsl, zip, Zend OPcache
Type: pgsql
Version: PostgreSQL 16.6 (Ubuntu 16.6-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.2) 9.4.0, 64-bit
Size: 3.6 GB
- Nextcloud Server version (e.g., 29.x.x): 30.0.6
- Operating system and version (e.g., Ubuntu 24.04): 22.04
- Web server and version (e.g, Apache 2.4.25):
- Reverse proxy and version _(e.g. nginx 1.27.2): 1.26.2
- PHP version (e.g, 8.3):8.2.27
- Is this the first time you’ve seen this error? (Yes / No):No
- When did this problem seem to first start? 28.x
- Installation method *(e.g. AIO, NCP, Bare Metal/Archive, etc.) Bare metal
- Are you using Cloudflare, mod_security, or similar? (Yes / No) No
Server log:
QueryException
More than 1000 expressions in a list are not allowed on Oracle.
/usr/share/nginx/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php
Line 284
OC\DB\QueryBuilder\QueryBuilder->prepareForExecute()
/usr/share/nginx/nextcloud/apps/facerecognition/lib/Db/FaceMapper.php
Line 61
OC\DB\QueryBuilder\QueryBuilder->executeQuery()
/usr/share/nginx/nextcloud/apps/facerecognition/lib/BackgroundJob/Tasks/CreateClustersTask.php
Line 182
OCA\FaceRecognition\Db\FaceMapper->findDescriptorsBathed()
/usr/share/nginx/nextcloud/apps/facerecognition/lib/BackgroundJob/Tasks/CreateClustersTask.php
Line 90
OCA\FaceRecognition\BackgroundJob\Tasks\CreateClustersTask->createClusterIfNeeded(
"*** sensitive parameters replaced ***"
)
/usr/share/nginx/nextcloud/apps/facerecognition/lib/BackgroundJob/BackgroundService.php
Line 150
OCA\FaceRecognition\BackgroundJob\Tasks\CreateClustersTask->execute()
/usr/share/nginx/nextcloud/apps/facerecognition/lib/Command/BackgroundCommand.php
Line 192
OCA\FaceRecognition\BackgroundJob\BackgroundService->execute()
/usr/share/nginx/nextcloud/3rdparty/symfony/console/Command/Command.php
Line 326
OCA\FaceRecognition\Command\BackgroundCommand->execute()
/usr/share/nginx/nextcloud/3rdparty/symfony/console/Application.php
Line 1078
Symfony\Component\Console\Command\Command->run()
/usr/share/nginx/nextcloud/3rdparty/symfony/console/Application.php
Line 324
Symfony\Component\Console\Application->doRunCommand()
/usr/share/nginx/nextcloud/3rdparty/symfony/console/Application.php
Line 175
Symfony\Component\Console\Application->doRun()
/usr/share/nginx/nextcloud/lib/private/Console/Application.php
Line 183
Symfony\Component\Console\Application->run()
/usr/share/nginx/nextcloud/console.php
Line 87
OC\Console\Application->run()
/usr/share/nginx/nextcloud/occ
Line 11
undefinedundefinedrequire_once(
"/usr/share/nginx/nextcloud/console.php"
)