Doctrine\DBAL\Query\QueryException: More than 1000 expressions in a list are not allowed on Oracle
#26493
Comments
AndyXheli
added
0. Needs triage
|
Happens to me as well while browsing a folder via the Android app. The spinner continues spinning, but backend already errored out. I'm running NextCloud 21.0.1 with PostgreSQL as db backend. The issue sounds similar to nextcloud/mail#4584. |
|
@mweinelt yes but that error looks more with the mail app |
|
Yes, but ultimatly runs into the same exception
|
|
Hopefully it’ll be fixed! I restored my server back to 20 too many issues with 21 |
|
This probably also breaks the "External Storage" Extension (no uploads possible because of "no Space left") I get the following error right after the DBAL one: |
solracsf
changed the title
AndyXheli
changed the title
|
@ChristophWurst I'm sorry to bother you any way you can have a quick look at this and any suggestions. Please and thank you!! I know you had some dealings with a similar error caused by the mail app so maybe you can shine some light on this? |
AndyXheli
changed the title
|
Same for me. I attach here my information and case: Expected behaviorNot throwing this exception Actual behaviorWhen accessing folders with more or less 1GB of data, throws this exception: {
"reqId": "y0Ghs7XZz0SSc4sGNxR6",
"level": 3,
"time": "2021-04-21T15:05:44+02:00",
"remoteAddr": "172.20.0.15",
"user": "upuelles",
"app": "core",
"method": "PROPFIND",
"url": "/remote.php/dav/files/upuelles/Imagenes/Wha_Mi_Mix_01_04_2020",
"message": {
"Exception": "Doctrine\\DBAL\\Query\\QueryException",
"Message": "More than 1000 expressions in a list are not allowed on Oracle.",
"Code": 0,
"Trace": [
{
"file": "/var/www/nextcloud/lib/private/Comments/Manager.php",
"line": 657,
"function": "execute",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/dav/lib/Connector/Sabre/CommentPropertiesPlugin.php",
"line": 89,
"function": "getNumberOfUnreadCommentsForObjects",
"class": "OC\\Comments\\Manager",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/dav/lib/Connector/Sabre/CommentPropertiesPlugin.php",
"line": 117,
"function": "cacheDirectory",
"class": "OCA\\DAV\\Connector\\Sabre\\CommentPropertiesPlugin",
"type": "->"
},
{
"file": "/var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
"line": 89,
"function": "handleGetProperties",
"class": "OCA\\DAV\\Connector\\Sabre\\CommentPropertiesPlugin",
"type": "->"
},
{
"file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 1052,
"function": "emit",
"class": "Sabre\\DAV\\Server",
"type": "->"
},
{
"file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 984,
"function": "getPropertiesByNode",
"class": "Sabre\\DAV\\Server",
"type": "->"
},
{
"file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 1661,
"function": "getPropertiesIteratorForPath",
"class": "Sabre\\DAV\\Server",
"type": "->"
},
{
"file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 1646,
"function": "writeMultiStatus",
"class": "Sabre\\DAV\\Server",
"type": "->"
},
{
"file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
"line": 346,
"function": "generateMultiStatus",
"class": "Sabre\\DAV\\Server",
"type": "->"
},
{
"file": "/var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
"line": 89,
"function": "httpPropFind",
"class": "Sabre\\DAV\\CorePlugin",
"type": "->"
},
{
"file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 472,
"function": "emit",
"class": "Sabre\\DAV\\Server",
"type": "->"
},
{
"file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 253,
"function": "invokeMethod",
"class": "Sabre\\DAV\\Server",
"type": "->"
},
{
"file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
"line": 321,
"function": "start",
"class": "Sabre\\DAV\\Server",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/dav/lib/Server.php",
"line": 332,
"function": "exec",
"class": "Sabre\\DAV\\Server",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/dav/appinfo/v2/remote.php",
"line": 35,
"function": "exec",
"class": "OCA\\DAV\\Server",
"type": "->"
},
{
"file": "/var/www/nextcloud/remote.php",
"line": 167,
"args": [
"/var/www/nextcloud/apps/dav/appinfo/v2/remote.php"
],
"function": "require_once"
}
],
"File": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
"Line": 268,
"CustomMessage": "More than 1000 expressions in a list are not allowed on Oracle."
},
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0",
"version": "21.0.1.1"
}Mail appMail app version: 1.9.5 Mailserver or service: Gmail Server configurationMotherboard: Raspberry Pi 4 - 4GB Operating system: Linux 5.10.17-v7l+ armv7l (Raspberri PI OS) Web server: Nginx 1.14.2 Database: MariaDB -> 10.3.27-MariaDB-0+deb10u1 Raspbian 10 PHP version: 7.4.16 Nextcloud Version: 21.0.1 Client configurationBrowser: Firefox 88.0 Operating system: Windows 10 Pro 20H2 |
|
So i logged into the nextcloud via browser on my phone went under file photos and started to scroll down and then after you start to scroll down looking at the files and i have alot of files under photos is just crashes and says A problem repeatedly occurred and if i go into the log i see this error in this issue just wanted to give some more info. |
|
I've had exactly the same problem. The WA is to disable comment app, which is a source of the error. I don't need comments in my NC server, so it is solved the problem for me. Probably the issue should be tagged as comment app issue. |
|
Disabling the comment app may take the error out but dose not fix the issue when you open nextcloud via mobile browser and start to scroll down fast you get the below affect like in the video i can confirm this happens on Nextcloud 21.0.1 then if you go into your error log you will see the error in this ticket. 21-04-22.10-15-21.4001_Trim.mp4 |
solracsf
changed the title
Doctrine\DBAL\Query\QueryException: More than 1000 expressions in a list are not allowed on Oracle
|
Would anything from this link help https://stackoverflow.com/questions/17842453/is-there-a-workaround-for-ora-01795-maximum-number-of-expressions-in-a-list-is |
|
It seems like a serious issue encountered by a lot of people (including myself) when you have a lot of content (files, images…) in one directory since 21. Any feedback would be really appreciated. |
|
@Simounet I would not tag people based on my expense you get blocked. Plus they have to much work that i sure they hate getting stuff that's its not related to them. I want to apologies for the people that I have tagged I was just trying to help and report the bugs to help the community. My sincere apologies.. |
|
FYI, I temporarily removed the exception from https://github.com/nextcloud/server/blob/master/lib/private/DB/QueryBuilder/QueryBuilder.php#L267 (Line 267 to 275) and everything is back to normal. I assume this code has been introduced for a good reason by #25036 but in the mean time, my NC instance is working correctly again. |
You're right. I removed my mentions. Sorry about that. |
|
server/lib/private/Comments/Manager.php Line 646 in abb5b5d If anyone is interested in a fix you can look into nextcloud/mail#4947 because there we have lots of good examples of how to transform the various types of queries. |
|
Thanks for the hint @ChristophWurst . I'll look into this if I can. |
|
@Simounet where you able to look into this ? |
|
Same problem NC21.0.2 with iOS app. |
I'm sorry but no. I just removed my comment to get the error back but I couldn't reproduce the issue I encountered a month ago with a large file folder. I'll try to go deeper. |
|
Ok so I get the error back browsing files through the Android App. I fixed it and made a PR that you can check at #27187 . 🤞 |
|
@Simounet Thank you so very much I applied the patch so far so good. wooho :) |
|
@AndyXheli Hi, you should update the code with the one on #27187. |
@Simounet thank you for taking your time to fix this and help the community! 🙏🏻 |
|
My pleasure. I'm always happy to contribute to this amazing project! |
|
Not fixed in v21 |
Not helpful. This could be triggered by any app. If you don't post traces of the exception then we can't help you. Please dig deeper and open tickets in the respective app(s). Thanks. |
|
Pretty sure this fix hasn't been backported to v21 yet. I see that 21.0.3 milestone is around a week away, would be great if this and some other fixes got in. For now my instance is fairly unusable with any of the big media folders. |
|
#27187 should fix this and i believe it's back ported |
This comment has been minimized.
This comment has been minimized.
This comment has been minimized.
This comment has been minimized.
|
Good day! Please help. I can't find a solution here, but all links lead here. After NC auto-update via snap to version 22, an error appeared and synchronization works intermittently. Please tell me what to do? Thank you in advance. Logs Doctrine\DBAL\Query\QueryException: More than 1000 expressions in a list are not allowed on Oracle. |
|
@toriva report this at https://github.com/nextcloud/groupfolders/issues. |
|
Running into this issue already for half a year, relates to contact app. One user has +8000 contacts and it keeps throwing error below. Had also posted here nextcloud/contacts#677 but no updates [core] Error: More than 1000 expressions in a list are not allowed on Oracle. at 2021-11-28T20:30:03+00:00 Doctrine\DBAL\Query\QueryException: More than 1000 expressions in a list are not allowed on Oracle. |
|
in the mean time on nextcloud 23.0.3, still same errors:
Doctrine\DBAL\Query\QueryException: More than 1000 expressions in a list are not allowed on Oracle. why is this issue closed btw, is it resolved? |
|
ArchLinux: nextcloud 25.0.4.1, postgresql 15.2-1 |
|
I believe in my case it is because of Probably it is fixed by adding: Also I am adding |
|
@ChristophWurst Hello Christoph, I hope you are well. |
It's not. Yours is for the activity baackground job to expire activities. See nextcloud/activity#1384. |
Getting the following error on Nextcloud 21.
Doctrine\DBAL\Query\QueryException: More than 1000 expressions in a list are not allowed on Oracle.
The text was updated successfully, but these errors were encountered: