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

🌐 Non-english support 🇩🇪 Deutsch (german)
, ,
1

Hallo,

habe in NC21 obige Fehlermeldung im Core. Kann mir da jemand bitte einen Hinweis geben wo ich schauen muss?

NC21
Debian 10
PHP 7.3.27
Datenbank: mysql, Version: 10.3.27

1 Like
2

Nextcloud verwende keine Oracle-Datenbank, deshalb bezweifele ich erst einmal, dass die Meldung von Nextcloud selbst stammt. Kannst Du bitte einmal die vollständige Fehlermeldung aus der Nextcloud-Logdatei posten und weitergehende Informationen zu Deiner Installationsumgebung bereit stellen. d.h. läuft Nextcloud bei Dir lokal, in einer geteilten Umgebung etc., etc.

3

Hallo j-ed,

danke für die Hilfe:
NC läuft lokal, habe vollen Zugriff.
Alle Programme up to date
Webserver ist Apache2
Ja der Hinweis auf Oracle hat mich auch gewundert, hier nun der Logeintrag ich hoffe das ist gut so:
[core] Error: Doctrine\DBAL\Query\QueryException: More than 1000 expressions in a list are not allowed on Oracle. at <>

  1. /var/www/html/nextcloud/lib/private/Comments/Manager.php line 657
    OC\DB\QueryBuilder\QueryBuilder->execute()
  2. /var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/CommentPropertiesPlugin.php line 89
    OC\Comments\Manager->getNumberOfUnreadCommentsForObjects(“files”, [“2668317”,"2667 … "], OC\User\User {})
  3. /var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/CommentPropertiesPlugin.php line 117
    OCA\DAV\Connector\Sabre\CommentPropertiesPlugin->cacheDirectory(OCA\DAV\Connector\Sabre\Directory {})
  4. /var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    OCA\DAV\Connector\Sabre\CommentPropertiesPlugin->handleGetProperties(Sabre\DAV\PropFind {}, OCA\DAV\Connector\Sabre\Directory {})
  5. /var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 1052
    Sabre\DAV\Server->emit(“propFind”, [Sabre\DAV\PropF … }])
  6. /var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 984
    Sabre\DAV\Server->getPropertiesByNode(Sabre\DAV\PropFind {}, OCA\DAV\Connector\Sabre\Directory {})
  7. /var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 1661
    Sabre\DAV\Server->getPropertiesIteratorForPath(“Photos”, ["{http://ownclo … "], 1)
  8. /var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 1646
    Sabre\DAV\Server->writeMultiStatus(Sabre\Xml\Writer … ]}, Generator {}, false)
  9. /var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 346
    Sabre\DAV\Server->generateMultiStatus(Generator {}, false)
  10. /var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    Sabre\DAV\CorePlugin->httpPropFind(Sabre\HTTP\Request {}, Sabre\HTTP\Response {})
  11. /var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 472
    Sabre\DAV\Server->emit(“method:PROPFIND”, [Sabre\HTTP\Requ … }])
  12. /var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 253
    Sabre\DAV\Server->invokeMethod(Sabre\HTTP\Request {}, Sabre\HTTP\Response {})
  13. /var/www/html/nextcloud/3rdparty/*****sabre/dav/lib/DAV/Server.php line 321
    Sabre\DAV\Server->start()
  14. /var/www/html/nextcloud/apps/dav/appinfo/v1/webdav.php line 84
    Sabre\DAV\Server->exec()
  15. /var/www/html/nextcloud/remote.php line 167
    require_once("/var/www/html/n … p")

PROPFIND /remote.php/webdav/Photos/
from ***** by ***** at 2021-03-07T14:03:50+01:00

4

Bitte poste auch Deine Nextcloud Konfigurationsdatei.

5 
<?php
$CONFIG = array (
  'instanceid' => '********',
  'passwordsalt' => '*************',
  'secret' => '*************',
  'trusted_domains' => 
  array (
    0 => '*******',
    1 => '*******',,
    4 => 'localhost',
    5 => '*******',,
  ),
  'default_language' => 'de',
  'datadirectory' => '/media/sda_luks/data',
  'dbtype' => 'mysql',
  'version' => '21.0.0.18',
  'overwrite.cli.url' => ''*******',',
  'overwriteprotocol' => 'https',
  'dbname' => ''*******',',
  'dbhost' => ''*******',',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'dbuser' => ''*******',',
  'dbpassword' => ''*******',',
  'installed' => true,
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'mail_smtpmode' => 'smtp',
  'mail_smtpsecure' => 'tls',
  'mail_from_address' => ''*******',',
  'mail_domain' => ''*******',.de',
  'mail_smtpauthtype' => 'LOGIN',
  'mail_smtpauth' => 1,
  'mail_smtphost' => ''*******',.de',
  'mail_smtpport' => ''*******',',
  'mail_smtpname' => ''*******',',
  'mail_smtppassword' => ''*******',',
  'mysql.utf8mb4' => true,
  'maintenance' => false,
  'updater.release.channel' => 'stable',
  'theme' => '',
  'loglevel' => 2,
  'logtimezone' => 'Europe/Berlin',
  'twofactor_enforced' => 'false',
  'app.mail.smtp.timeout' => 10,
  'default_phone_region' => 'DE',
  'twofactor_enforced_groups' => 
  array (
  ),
  'twofactor_enforced_excluded_groups' => 
  array (
  ),
  'app_install_overwrite' => 
  array (
    0 => 'occweb',
    1 => 'dicomviewer',
    2 => 'files_external_onedrive',
    3 => 'keeweb',
    4 => 'telephoneprovider',
    5 => 'weather',
    6 => 'ownbackup',
    7 => 'fulltextsearch_elasticsearch',
    8 => 'music',
    9 => 'printer',
    10 => 'workflow_ocr',
    11 => 'fulltextsearch',
    12 => 'nextbackup',
    13 => 'bruteforcesettings',
  ),
);
6

Please insert a line containing three backticks (```) before and after the configuration file content to make it readable :wink:

1 Like
7

geändert, danke!

8

Is this issue resolved? I too see the same exception in logs.

9

not yet, but it is a strange issue…

10

Found it also in my Log

11

I have the same issue as well.

12

Die gleiche Fehlermeldung hier im Mail bereich:
{“reqId”:“YE8Ylu-mM9vYp81GykOGFAAA0gM”,“level”:3,“time”:“2021-03-15T08:19:35+00:00”,“remoteAddr”:“xx.xx.xx.xx”,“user”:“125132FC-FA1C-4780-A280-DE9458AAFA8E”,“app”:“core”,“method”:“POST”,“url”:"/nextcloud/index.php/apps/mail/api/mailboxes/526/sync",“message”:{“Exception”:“Doctrine\DBAL\Query\QueryException”,“Message”:“More than 1000 expressions in a list are not allowed on Oracle.”,“Code”:0,“Trace”:[{“file”:"/home/httpd/html/nextcloud/lib/public/AppFramework/Db/QBMapper.php",“line”:320,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:"->"},{“file”:"/home/httpd/html/nextcloud/apps/mail/lib/Db/MessageMapper.php",“line”:584,“function”:“findEntities”,“class”:“OCP\AppFramework\Db\QBMapper”,“type”:"->"},{“file”:"/home/httpd/html/nextcloud/apps/mail/lib/Service/Sync/SyncService.php",“line”:156,“function”:“findIdsByQuery”,“class”:“OCA\Mail\Db\MessageMapper”,“type”:"->"},{“file”:"/home/httpd/html/nextcloud/apps/mail/lib/Service/Sync/SyncService.php",“line”:126,“function”:“getDatabaseSyncChanges”,“class”:“OCA\Mail\Service\Sync\SyncService”,“type”:"->"},{“file”:"/home/httpd/html/nextcloud/apps/mail/lib/Controller/MailboxesController.php",“line”:161,“function”:“syncMailbox”,“class”:“OCA\Mail\Service\Sync\SyncService”,“type”:"->"},{“file”:"/home/httpd/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:218,“function”:“sync”,“class”:“OCA\Mail\Controller\MailboxesController”,“type”:"->"},{“file”:"/home/httpd/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/home/httpd/html/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/home/httpd/html/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/home/httpd/html/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/home/httpd/html/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/home/httpd/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",“Line”:267,“CustomMessage”:“More than 1000 expressions in a list are not allowed on Oracle.”},“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:86.0) Gecko/20100101 Firefox/86.0”,“version”:“21.0.0.18”,“id”:“604f18c48d00e”}

13

Bug report is here: NC21, postgres, Doctrine\DBAL\Query\QueryException: More than 1000 expressions in a list are not allowed on Oracle. · Issue #4584 · nextcloud/mail · GitHub

14

Hallo,

ich habe exakt die gleiche Fehlermeldung in 21.0.3 bei Öffnen eines Ordners mit 1500 Fotos in „Files“. Ich habe Issue #27932 eröffnet, weil der hierfür eröffnete Bug „closed“ ist, und der Fehler in der Mail-App auftrat, anstatt im Core. Das sieht aber sehr nach einem verwandten Problem aus.

15

Same here, but with contacts ( NC 22.2.0. Contacts 4.0.3):
{“reqId”:“S4TIXj2220fLrrU0seSY”,“level”:3,“time”:“2021-10-12T09:46:54+00:00”,“remoteAddr”:“xxx.xxx.xxx.xxx”,“user”:“xxxxxxxx”,“app”:“core”,“method”:“GET”,“url”:"/index.php/apps/polls/search/users/b",“message”:“More than 1000 expressions in a list are not allowed on Oracle.”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0”,“version”:“22.2.0.2”,“exception”:{“Exception”:“Doctrine\DBAL\Query\QueryException”,“Message”:“More than 1000 expressions in a list are not allowed on Oracle.”,“Code”:0,“Trace”:[{“file”:"/data/www/nextcloud.office.b-k-architekten.de/htdocs/apps/dav/lib/CardDAV/CardDavBackend.php",“line”:1132,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:"->"},{“file”:"/data/www/nextcloud.office.b-k-architekten.de/htdocs/apps/dav/lib/CardDAV/CardDavBackend.php",“line”:1030,“function”:“searchByAddressBookIds”,“class”:“OCA\DAV\CardDAV\CardDavBackend”,“type”:"->"},{“file”:"/data/www/nextcloud.office.b-k-architekten.de/htdocs/apps/dav/lib/CardDAV/AddressBookImpl.php",“line”:119,“function”:“search”,“class”:“OCA\DAV\CardDAV\CardDavBackend”,“type”:"->"},{“file”:"/data/www/nextcloud.office.b-k-architekten.de/htdocs/lib/private/ContactsManager.php",“line”:51,“function”:“search”,“class”:“OCA\DAV\CardDAV\AddressBookImpl”,“type”:"->"},{“file”:"/data/www/nextcloud.office.b-k-architekten.de/htdocs/apps/polls/lib/Model/Contact.php",“line”:123,“function”:“search”,“class”:“OC\ContactsManager”,“type”:"->"},{“file”:"/data/www/nextcloud.office.b-k-architekten.de/htdocs/apps/polls/lib/Model/Contact.php",“line”:137,“function”:“listRaw”,“class”:“OCA\Polls\Model\Contact”,“type”:"::"},{“file”:"/data/www/nextcloud.office.b-k-architekten.de/htdocs/apps/polls/lib/Model/UserGroupClass.php",“line”:211,“function”:“search”,“class”:“OCA\Polls\Model\Contact”,“type”:"::"},{“file”:"/data/www/nextcloud.office.b-k-architekten.de/htdocs/apps/polls/lib/Service/SystemService.php",“line”:122,“function”:“search”,“class”:“OCA\Polls\Model\UserGroupClass”,“type”:"::"},{“file”:"/data/www/nextcloud.office.b-k-architekten.de/htdocs/apps/polls/lib/Controller/SystemController.php",“line”:53,“function”:“getSiteUsersAndGroups”,“class”:“OCA\Polls\Service\SystemService”,“type”:"->"},{“file”:"/data/www/nextcloud.office.b-k-architekten.de/htdocs/lib/private/AppFramework/Http/Dispatcher.php",“line”:217,“function”:“userSearch”,“class”:“OCA\Polls\Controller\SystemController”,“type”:"->"},{“file”:"/data/www/nextcloud.office.b-k-architekten.de/htdocs/lib/private/AppFramework/Http/Dispatcher.php",“line”:126,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/www/nextcloud.office.b-k-architekten.de/htdocs/lib/private/AppFramework/App.php",“line”:156,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/www/nextcloud.office.b-k-architekten.de/htdocs/lib/private/Route/Router.php",“line”:301,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/www/nextcloud.office.b-k-architekten.de/htdocs/lib/base.php",“line”:1000,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/www/nextcloud.office.b-k-architekten.de/htdocs/index.php",“line”:36,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/www/nextcloud.office.b-k-architekten.de/htdocs/lib/private/DB/QueryBuilder/QueryBuilder.php",“Line”:268,“CustomMessage”:“More than 1000 expressions in a list are not allowed on Oracle.”},“id”:“616d2e1a98190”}

16

The original issue was reported to github and solved there. If you still have similar messages on the contact apps, I’d report a bug report there. Also please check if that is just an error message that fills up your logs or if you experience any other problems regarding the functionality of NC.