Limitation on number of files per folder on local storage

[calvsung]

Steps to reproduce

1. Create local storage mount
2. Browse to subfolder with more than 1000 files.

Expected behaviour

Files show as usual

Actual behaviour

This directory is unavailable, please check the logs or contact the administrator

Server configuration

Operating system: Centos 7.4

Web server: Apache

Database: Sqlite

PHP version: 5.6

ownCloud version: 10.0.3.3

Updated from an older ownCloud or fresh install: fresh install

Where did you install ownCloud from: tarball

Signing status (ownCloud 9.0 and above): N/A

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results into https://gist.github.com/ and puth the link here.

The content of config/config.php:

https://gist.github.com/anonymous/f4329fb0be03b03c2089c3847c12ab9f

List of activated apps:

Are you using external storage, if yes which one: local

Are you using encryption: no

Are you using an external user-backend, if yes which one: No

Client configuration

Browser:

Operating system:

Logs

Web server error log

- - [13/Oct/2017:11:48:11 +0800] "GET /owncloud/index.php/avatar/xxxxx/28 HTTP/1.1" 200 33 "-" "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:56.0) Gecko/20100101 Firefox/56.0"
- - [13/Oct/2017:11:48:11 +0800] "PROPFIND /owncloud/remote.php/webdav/CCloud/iphone/2012 HTTP/1.1" 500 14369 "-" "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:56.0) Gecko/20100101 Firefox/56.0"
- - [13/Oct/2017:11:48:12 +0800] "GET /owncloud/index.php/apps/files_external/userglobalstorages/1?testOnly=false HTTP/1.1" 200 191 "-" "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:56.0) Gecko/20100101 Firefox/56.0"
- - [13/Oct/2017:11:48:12 +0800] "PROPFIND /owncloud/remote.php/webdav/ HTTP/1.1" 207 3546 "-" "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:56.0) Gecko/20100101 Firefox/56.0"
- - [13/Oct/2017:11:48:12 +0800] "GET /owncloud/index.php/avatar/xxxxx/28 HTTP/1.1" 200 33 "-" "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:56.0) Gecko/20100101 Firefox/56.0"
- - [13/Oct/2017:11:48:12 +0800] "GET /owncloud/index.php/apps/files/ajax/getstoragestats.php?dir=%2F HTTP/1.1" 200 191 "-" "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:56.0) Gecko/20100101 Firefox/56.0"

ownCloud log (data/owncloud.log)

{"reqId":"WeA3e0uMZY8omfzxOhHo4gAAAAM","level":4,"time":"2017-10-13T11:48:11+08:00","remoteAddr":"xxxxxxxx","user":"xxxxx","app":"webdav","method":"PROPFIND","url":"\/owncloud\/remote.php\/webdav\/CCloud\/iphone\/2012","message":"Exception: {\"Message\":\"An exception occurred while executing 'SELECT * FROM \\\"oc_share\\\" WHERE ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ((\\\"item_type\\\" = ?) OR (\\\"item_type\\\" = ?)) AND ((\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?) OR (\\\"share_type\\\" = ?)) AND (\\\"uid_initiator\\\" = ?) AND (\\\"file_source\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY \\\"id\\\" ASC' with params [\\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\", \\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\", \\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\", \\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\", \\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\", \\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\", \\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\", \\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\", \\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\", \\\"file\\\", \\\"folder\\\", 0, 1, 3, \\\"xxxxx\\\", \\\"33318\\\", \\\"33319\\\", \\\"33320\\\", \\\"33321\\\", \\\"33322\\\", \\\"33323\\\", \\\"33324\\\", \\\"33325\\\", \\\"33326\\\", \\\"33327\\\", \\\"33328\\\", \\\"33329\\\", \\\"33330\\\", \\\"33331\\\", \\\"33332\\\", \\\"33333\\\", \\\"33334\\\", \\\"33335\\\", \\\"33336\\\", \\\"33337\\\", \\\"33338\\\", \\\"33339\\\", \\\"33340\\\", \\\"33341\\\", \\\"33342\\\", \\\"33343\\\", \\\"33344\\\", \\\"33345\\\", \\\"33346\\\", \\\"33347\\\", \\\"33348\\\", \\\"33349\\\", \\\"33350\\\", \\\"33351\\\", \\\"33352\\\", \\\"33353\\\", \\\"33354\\\", \\\"33355\\\", \\\"33356\\\", \\\"33357\\\", \\\"33358\\\", \\\"33359\\\", \\\"33360\\\", \\\"33361\\\", \\\"33362\\\", \\\"33363\\\", \\\"33364\\\", \\\"33365\\\", \\\"33366\\\", \\\"33367\\\", \\\"33368\\\", \\\"33369\\\", \\\"33370\\\", \\\"33371\\\", \\\"33372\\\", \\\"33373\\\", \\\"33374\\\", \\\"33375\\\", \\\"33376\\\", \\\"33377\\\", \\\"33378\\\", \\\"33379\\\", \\\"33380\\\", \\\"33381\\\", \\\"33382\\\", \\\"33383\\\", \\\"33384\\\", \\\"33385\\\", \\\"33386\\\", \\\"33387\\\", \\\"33388\\\", \\\"33389\\\", \\\"33390\\\", \\\"33391\\\", \\\"33392\\\", \\\"33393\\\", \\\"33394\\\", \\\"33395\\\", \\\"33396\\\", \\\"33397\\\", \\\"33398\\\", \\\"33399\\\", \\\"33400\\\", \\\"33401\\\", \\\"33402\\\", \\\"33403\\\", \\\"33404\\\", \\\"33405\\\", \\\"33406\\\", \\\"33407\\\", \\\"33408\\\", \\\"33409\\\", \\\"33410\\\", \\\"33411\\\", \\\"33412\\\", \\\"33413\\\", \\\"33414\\\", \\\"33415\\\", \\\"33416\\\", \\\"33417\\\"]:\\n\\nSQLSTATE[HY000]: General error: 1 too many SQL variables\",\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractSQLiteDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(855): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOSqlite\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'SELECT * FROM \\\"...', Array)\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(190): Doctrine\\\\DBAL\\\\Connection->executeQuery('SELECT * FROM \\\"...', Array, Array, NULL)\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(206): OC\\\\DB\\\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(141): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Share20\\\/DefaultShareProvider.php(514): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Share20\\\/Manager.php(924): OC\\\\Share20\\\\DefaultShareProvider->getAllSharesBy('xxxxx', Array, Array, false)\\n#7 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/SharesPlugin.php(145): OC\\\\Share20\\\\Manager->getAllSharesBy('xxxxx', Array, Array)\\n#8 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/SharesPlugin.php(195): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\SharesPlugin->getSharesForNodeIds(Array)\\n#9 [internal function]: OCA\\\\DAV\\\\Connector\\\\Sabre\\\\SharesPlugin->handleGetProperties(Object(Sabre\\\\DAV\\\\PropFind), Object(OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory))\\n#10 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#11 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1058): Sabre\\\\Event\\\\EventEmitter->emit('propFind', Array)\\n#12 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(980): Sabre\\\\DAV\\\\Server->getPropertiesByNode(Object(Sabre\\\\DAV\\\\PropFind), Object(OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory))\\n#13 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1665): Sabre\\\\DAV\\\\Server::getPropertiesIteratorForPath('CCloud\\\/iphone\\\/2...', Array, 1)\\n#14 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(355): Sabre\\\\DAV\\\\Server->generateMultiStatus(Object(Generator), false)\\n#15 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpPropFind(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#16 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#17 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:PROPFIND', Array)\\n#18 \\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#19 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v1\\\/webdav.php(63): Sabre\\\\DAV\\\\Server->exec()\\n#20 \\\/var\\\/www\\\/owncloud\\\/remote.php(165): require_once('\\\/var\\\/www\\\/ownclo...')\\n#21 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractSQLiteDriver.php\",\"Line\":85,\"User\":\"xxxxx\"}"}

Browser log

[PVince81]

duplicate of #20334

[ghost]

@PVince81 Really a duplicate? At least the General error: 1 too many SQL variables from the posted logfiles is something which probably shouldn't happen?

[PVince81]

Seems we're missing some chunking algorithm for the SQLite query... Ah... SQLite...

Please use Mysql/Mariadb or PostgreSQL if possible when dealing with a lot of data.

[PVince81]

Basically for SQLite we need to add extra code to make sure that a select ... where x in (...) doesn't have more than 1000 arguments. Other databases do not have this limitation.

[cortho]

Oracle does have the 1000 limit too, so every code which is using an SQL IN clause should use chunking.

[PVince81]

Hmmmm... ok, need to look into it.

[Grunthos]

Just upgraded from 8.x to 10.x and hitting this one with large directories.

It looks like this is a regression and was probably fixed years ago here:

#239!

Though a chunking algorithm would probably be better.

Ignore that; this problem looks to be in CustomPropertiesBackend, and there's even a TODO referring to chunking.

Any eta on a fix? I didn't have this problem in 8.0.

[PVince81]

@VicDeo can we add chunking in the custom properties backend ?

Let me know if you were able to reproduce the issue.

[Grunthos]

For reference here is my crash:

{"reqId":"5pO9kilJyTOCudGNoHN4","level":4,"time":"2017-10-27T07:56:19+00:00","remoteAddr":"x.y.z.t","user":"uuuu","app":"webdav","method":"PROPFIND","url":"\/remote.php\/webdav\/SomeRoot\/SomeDir\/","message":"Exception: {\"Message\":\"An exception occurred while executing 'SELECT * FROM \\\"oc_properties\\\" WHERE \\\"fileid\\\" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND \\\"propertyname\\\" in (?, ?, ?) ORDER BY \\\"propertyname\\\"' with params [\\\"9669\\\", \\\"3131\\\", \\\"3132\\\", \\\"3133\\\", \\\"3134\\\", \\\"3135\\\", \\\"3136\\\", \\\"3137\\\", \\\"3138\\\", \\\"3139\\\", \\\"3140\\\", \\\"3141\\\", \\\"3142\\\", \\\"3143\\\", \\\"3144\\\", \\\"3145\\\", \\\"3146\\\", \\\"3147\\\", \\\"3148\\\", \\\"3149\\\", \\\"3150\\\", \\\"3151\\\", \\\"3152\\\", \\\"3153\\\", \\\"3154\\\", \\\"3155\\\", \\\"3156\\\", \\\"3157\\\", \\\"3158\\\", \\\"3159\\\", \\\"3160\\\", \\\"3161\\\", \\\"3162\\\", \\\"3163\\\", \\\"3164\\\", \\\"3165\\\", \\\"3166\\\", \\\"3167\\\", \\\"3168\\\", \\\"3169\\\", \\\"3170\\\", \\\"3171\\\", \\\"3172\\\", \\\"3173\\\", \\\"3174\\\", \\\"3175\\\", \\\"3176\\\", \\\"3177\\\", \\\"3178\\\", \\\"3179\\\", \\\"3180\\\", \\\"3181\\\", \\\"3182\\\", \\\"3234\\\", \\\"3235\\\", \\\"3236\\\", \\\"3237\\\", \\\"3238\\\", \\\"3239\\\", \\\"3240\\\", \\\"3241\\\", \\\"3242\\\", \\\"3243\\\", \\\"3244\\\", \\\"3245\\\", \\\"3246\\\", \\\"3247\\\", \\\"3248\\\", \\\"3249\\\", \\\"3250\\\", \\\"3251\\\", \\\"3252\\\", \\\"3253\\\", \\\"3254\\\", \\\"3255\\\", \\\"3256\\\", \\\"3257\\\", \\\"3258\\\", \\\"3259\\\", \\\"3260\\\", \\\"3261\\\", \\\"3262\\\", \\\"3263\\\", \\\"3264\\\", \\\"3265\\\", \\\"3266\\\", \\\"3267\\\", \\\"3268\\\", \\\"3269\\\", \\\"3270\\\", \\\"3271\\\", \\\"3272\\\", \\\"3273\\\", \\\"3274\\\", \\\"3275\\\", \\\"3276\\\", \\\"3277\\\", \\\"3278\\\", \\\"3279\\\", \\\"3280\\\", \\\"3281\\\", \\\"3282\\\", \\\"3283\\\", \\\"3284\\\", \\\"3285\\\", \\\"3286\\\", \\\"3287\\\", \\\"3288\\\", \\\"3289\\\", \\\"3290\\\", \\\"3291\\\", \\\"3292\\\", \\\"3293\\\", \\\"3294\\\", \\\"3295\\\", \\\"3296\\\", \\\"3297\\\", \\\"3298\\\", \\\"3299\\\", \\\"3300\\\", \\\"3301\\\", \\\"3302\\\", \\\"3303\\\", \\\"3304\\\", \\\"3305\\\", \\\"3306\\\", \\\"3307\\\", \\\"3308\\\", \\\"3309\\\", \\\"3310\\\", \\\"3311\\\", \\\"3312\\\", \\\"3313\\\", \\\"3314\\\", \\\"3315\\\", \\\"3316\\\", \\\"3317\\\", \\\"3318\\\", \\\"3319\\\", \\\"30551\\\", \\\"3320\\\", \\\"3321\\\", \\\"3322\\\", \\\"3323\\\", \\\"3324\\\", \\\"3325\\\", \\\"3326\\\", \\\"3327\\\", \\\"3328\\\", \\\"3329\\\", \\\"3330\\\", \\\"3331\\\", \\\"3332\\\", \\\"3333\\\", \\\"3334\\\", \\\"3335\\\", \\\"3336\\\", \\\"3337\\\", \\\"3338\\\", \\\"3339\\\", \\\"3340\\\", \\\"3341\\\", \\\"3342\\\", \\\"3343\\\", \\\"3344\\\", \\\"3345\\\", \\\"3346\\\", \\\"3347\\\", \\\"3348\\\", \\\"3349\\\", \\\"3350\\\", \\\"3351\\\", \\\"3352\\\", \\\"3353\\\", \\\"3354\\\", \\\"3355\\\", \\\"3356\\\", \\\"3357\\\", \\\"3358\\\", \\\"3359\\\", \\\"3360\\\", \\\"3361\\\", \\\"3362\\\", \\\"3363\\\", \\\"3364\\\", \\\"3365\\\", \\\"3366\\\", \\\"3367\\\", \\\"3368\\\", \\\"3369\\\", \\\"3370\\\", \\\"3371\\\", \\\"3372\\\", \\\"3373\\\", \\\"2765\\\", \\\"3374\\\", \\\"3375\\\", \\\"3376\\\", \\\"3377\\\", \\\"3378\\\", \\\"3379\\\", \\\"3380\\\", \\\"3381\\\", \\\"3382\\\", \\\"3383\\\", \\\"3384\\\", \\\"3385\\\", \\\"3386\\\", \\\"30853\\\", \\\"3387\\\", \\\"3388\\\", \\\"3389\\\", \\\"3390\\\", \\\"3391\\\", \\\"3392\\\", \\\"3393\\\", \\\"3394\\\", \\\"3395\\\", \\\"3396\\\", \\\"3397\\\", \\\"3398\\\", \\\"3399\\\", \\\"3400\\\", \\\"3401\\\", \\\"3402\\\", \\\"3403\\\", \\\"3404\\\", \\\"3405\\\", \\\"3406\\\", \\\"3407\\\", \\\"3408\\\", \\\"3409\\\", \\\"3410\\\", \\\"3411\\\", \\\"3412\\\", \\\"3413\\\", \\\"3414\\\", \\\"3415\\\", \\\"3416\\\", \\\"3417\\\", \\\"3418\\\", \\\"3419\\\", \\\"3420\\\", \\\"3421\\\", \\\"3422\\\", \\\"3423\\\", \\\"3424\\\", \\\"3425\\\", \\\"3426\\\", \\\"3427\\\", \\\"3428\\\", \\\"3429\\\", \\\"3430\\\", \\\"3431\\\", \\\"3432\\\", \\\"3433\\\", \\\"3434\\\", \\\"8031\\\", \\\"3435\\\", \\\"3436\\\", \\\"3437\\\", \\\"3438\\\", \\\"3439\\\", \\\"3440\\\", \\\"3441\\\", \\\"3442\\\", \\\"3443\\\", \\\"3444\\\", \\\"3445\\\", \\\"3446\\\", \\\"3447\\\", \\\"3448\\\", \\\"3449\\\", \\\"3450\\\", \\\"3451\\\", \\\"3452\\\", \\\"3453\\\", \\\"3454\\\", \\\"3455\\\", \\\"3456\\\", \\\"3457\\\", \\\"3458\\\", \\\"3459\\\", \\\"3460\\\", \\\"3461\\\", \\\"3462\\\", \\\"3463\\\", \\\"3464\\\", \\\"3465\\\", \\\"8877\\\", \\\"3466\\\", \\\"3467\\\", \\\"3468\\\", \\\"3469\\\", \\\"3470\\\", \\\"3471\\\", \\\"3472\\\", \\\"3473\\\", \\\"3474\\\", \\\"3475\\\", \\\"3476\\\", \\\"3477\\\", \\\"3478\\\", \\\"3479\\\", \\\"3480\\\", \\\"3481\\\", \\\"3482\\\", \\\"3483\\\", \\\"3484\\\", \\\"3485\\\", \\\"3486\\\", \\\"3487\\\", \\\"3488\\\", \\\"3489\\\", \\\"3490\\\", \\\"3491\\\", \\\"3492\\\", \\\"3493\\\", \\\"3494\\\", \\\"3495\\\", \\\"3496\\\", \\\"3497\\\", \\\"3498\\\", \\\"3499\\\", \\\"8878\\\", \\\"3500\\\", \\\"3501\\\", \\\"3502\\\", \\\"3503\\\", \\\"3504\\\", \\\"3505\\\", \\\"3506\\\", \\\"3507\\\", \\\"3508\\\", \\\"3509\\\", \\\"3510\\\", \\\"3511\\\", \\\"3512\\\", \\\"3513\\\", \\\"3514\\\", \\\"3515\\\", \\\"3516\\\", \\\"3517\\\", \\\"3518\\\", \\\"3519\\\", \\\"3520\\\", \\\"3521\\\", \\\"3522\\\", \\\"3523\\\", \\\"3524\\\", \\\"3525\\\", \\\"3526\\\", \\\"3527\\\", \\\"3528\\\", \\\"3529\\\", \\\"3530\\\", \\\"3531\\\", \\\"3532\\\", \\\"3533\\\", \\\"3534\\\", \\\"3535\\\", \\\"3536\\\", \\\"3537\\\", \\\"3538\\\", \\\"3539\\\", \\\"3540\\\", \\\"3541\\\", \\\"3542\\\", \\\"3543\\\", \\\"3544\\\", \\\"3545\\\", \\\"3546\\\", \\\"3547\\\", \\\"3548\\\", \\\"3549\\\", \\\"3550\\\", \\\"3551\\\", \\\"3552\\\", \\\"3553\\\", \\\"3554\\\", \\\"3555\\\", \\\"3556\\\", \\\"3557\\\", \\\"3558\\\", \\\"3559\\\", \\\"3560\\\", \\\"8879\\\", \\\"3561\\\", \\\"3562\\\", \\\"3563\\\", \\\"3564\\\", \\\"3565\\\", \\\"3566\\\", \\\"3567\\\", \\\"3568\\\", \\\"3569\\\", \\\"3570\\\", \\\"3571\\\", \\\"3572\\\", \\\"3573\\\", \\\"3574\\\", \\\"3575\\\", \\\"3576\\\", \\\"3577\\\", \\\"3578\\\", \\\"3579\\\", \\\"3580\\\", \\\"3581\\\", \\\"3582\\\", \\\"3583\\\", \\\"3584\\\", \\\"3585\\\", \\\"3586\\\", \\\"3587\\\", \\\"3588\\\", \\\"3589\\\", \\\"3590\\\", \\\"3591\\\", \\\"3592\\\", \\\"3593\\\", \\\"30552\\\", \\\"3594\\\", \\\"3595\\\", \\\"3596\\\", \\\"3597\\\", \\\"3598\\\", \\\"3599\\\", \\\"3600\\\", \\\"3601\\\", \\\"3602\\\", \\\"3603\\\", \\\"3604\\\", \\\"3605\\\", \\\"3606\\\", \\\"14990\\\", \\\"3607\\\", \\\"3608\\\", \\\"3609\\\", \\\"3610\\\", \\\"3611\\\", \\\"3612\\\", \\\"3613\\\", \\\"3614\\\", \\\"3615\\\", \\\"3616\\\", \\\"3617\\\", \\\"3618\\\", \\\"8032\\\", \\\"3619\\\", \\\"3620\\\", \\\"3621\\\", \\\"3622\\\", \\\"3623\\\", \\\"3624\\\", \\\"3625\\\", \\\"3626\\\", \\\"3627\\\", \\\"3628\\\", \\\"3629\\\", \\\"3630\\\", \\\"3631\\\", \\\"3632\\\", \\\"3633\\\", \\\"3634\\\", \\\"3635\\\", \\\"3636\\\", \\\"3637\\\", \\\"3638\\\", \\\"3639\\\", \\\"3640\\\", \\\"3641\\\", \\\"3642\\\", \\\"3643\\\", \\\"3644\\\", \\\"3645\\\", \\\"3646\\\", \\\"3647\\\", \\\"3648\\\", \\\"3649\\\", \\\"3650\\\", \\\"3651\\\", \\\"3652\\\", \\\"3653\\\", \\\"3654\\\", \\\"3655\\\", \\\"3656\\\", \\\"3657\\\", \\\"3658\\\", \\\"3659\\\", \\\"3660\\\", \\\"3661\\\", \\\"3662\\\", \\\"3663\\\", \\\"30553\\\", \\\"3664\\\", \\\"3665\\\", \\\"3666\\\", \\\"3667\\\", \\\"3668\\\", \\\"3669\\\", \\\"3670\\\", \\\"3671\\\", \\\"3672\\\", \\\"3673\\\", \\\"3674\\\", \\\"3675\\\", \\\"3676\\\", \\\"3677\\\", \\\"3678\\\", \\\"3679\\\", \\\"3680\\\", \\\"3681\\\", \\\"3682\\\", \\\"3683\\\", \\\"3684\\\", \\\"3685\\\", \\\"3686\\\", \\\"3687\\\", \\\"3688\\\", \\\"3689\\\", \\\"3690\\\", \\\"3691\\\", \\\"3692\\\", \\\"3693\\\", \\\"3694\\\", \\\"3695\\\", \\\"3696\\\", \\\"3697\\\", \\\"3698\\\", \\\"3699\\\", \\\"3700\\\", \\\"3701\\\", \\\"3702\\\", \\\"3703\\\", \\\"3704\\\", \\\"3705\\\", \\\"3706\\\", \\\"3707\\\", \\\"3708\\\", \\\"3709\\\", \\\"3710\\\", \\\"3711\\\", \\\"3712\\\", \\\"3713\\\", \\\"3714\\\", \\\"3715\\\", \\\"3716\\\", \\\"3717\\\", \\\"3718\\\", \\\"3719\\\", \\\"3720\\\", \\\"3721\\\", \\\"3722\\\", \\\"3723\\\", \\\"3724\\\", \\\"3725\\\", \\\"3726\\\", \\\"3727\\\", \\\"3728\\\", \\\"3729\\\", \\\"3730\\\", \\\"3731\\\", \\\"3732\\\", \\\"3733\\\", \\\"3737\\\", \\\"3738\\\", \\\"3739\\\", \\\"3740\\\", \\\"3741\\\", \\\"3742\\\", \\\"3774\\\", \\\"3777\\\", \\\"3874\\\", \\\"3911\\\", \\\"3912\\\", \\\"3913\\\", \\\"3914\\\", \\\"3915\\\", \\\"3916\\\", \\\"3917\\\", \\\"3918\\\", \\\"3919\\\", \\\"3920\\\", \\\"3921\\\", \\\"3922\\\", \\\"3923\\\", \\\"3924\\\", \\\"3925\\\", \\\"3926\\\", \\\"3978\\\", \\\"4087\\\", \\\"4185\\\", \\\"4269\\\", \\\"4390\\\", \\\"4484\\\", \\\"4485\\\", \\\"4486\\\", \\\"4487\\\", \\\"4488\\\", \\\"4489\\\", \\\"4490\\\", \\\"4491\\\", \\\"4492\\\", \\\"4493\\\", \\\"4494\\\", \\\"4495\\\", \\\"4496\\\", \\\"4497\\\", \\\"4498\\\", \\\"4499\\\", \\\"4500\\\", \\\"4501\\\", \\\"4502\\\", \\\"4503\\\", \\\"4504\\\", \\\"4505\\\", \\\"4506\\\", \\\"4507\\\", \\\"4508\\\", \\\"10894\\\", \\\"4509\\\", \\\"4510\\\", \\\"4511\\\", \\\"4512\\\", \\\"4513\\\", \\\"4514\\\", \\\"4515\\\", \\\"4516\\\", \\\"4517\\\", \\\"4518\\\", \\\"4519\\\", \\\"4520\\\", \\\"4521\\\", \\\"4522\\\", \\\"4523\\\", \\\"4524\\\", \\\"4525\\\", \\\"4526\\\", \\\"4527\\\", \\\"4528\\\", \\\"4529\\\", \\\"4530\\\", \\\"31348\\\", \\\"4531\\\", \\\"4532\\\", \\\"4533\\\", \\\"4534\\\", \\\"4535\\\", \\\"4536\\\", \\\"4537\\\", \\\"4538\\\", \\\"4539\\\", \\\"4540\\\", \\\"4541\\\", \\\"4542\\\", \\\"4543\\\", \\\"4544\\\", \\\"4545\\\", \\\"4546\\\", \\\"4547\\\", \\\"4548\\\", \\\"4549\\\", \\\"4550\\\", \\\"4551\\\", \\\"4552\\\", \\\"4553\\\", \\\"4554\\\", \\\"4555\\\", \\\"4556\\\", \\\"4557\\\", \\\"4558\\\", \\\"4559\\\", \\\"4560\\\", \\\"10895\\\", \\\"4561\\\", \\\"4562\\\", \\\"4563\\\", \\\"4564\\\", \\\"4565\\\", \\\"4566\\\", \\\"4567\\\", \\\"4568\\\", \\\"4569\\\", \\\"4570\\\", \\\"4571\\\", \\\"4572\\\", \\\"2766\\\", \\\"4573\\\", \\\"4574\\\", \\\"4575\\\", \\\"4576\\\", \\\"4577\\\", \\\"4578\\\", \\\"4579\\\", \\\"4580\\\", \\\"4581\\\", \\\"4582\\\", \\\"4583\\\", \\\"4584\\\", \\\"4585\\\", \\\"4586\\\", \\\"4587\\\", \\\"30554\\\", \\\"4588\\\", \\\"4589\\\", \\\"4590\\\", \\\"4591\\\", \\\"4592\\\", \\\"4593\\\", \\\"4594\\\", \\\"4595\\\", \\\"4596\\\", \\\"4597\\\", \\\"4598\\\", \\\"4599\\\", \\\"4600\\\", \\\"4601\\\", \\\"4602\\\", \\\"4603\\\", \\\"4604\\\", \\\"4605\\\", \\\"4606\\\", \\\"4607\\\", \\\"4608\\\", \\\"4609\\\", \\\"4610\\\", \\\"4611\\\", \\\"4612\\\", \\\"4613\\\", \\\"4614\\\", \\\"4615\\\", \\\"4616\\\", \\\"4617\\\", \\\"4618\\\", \\\"4619\\\", \\\"4620\\\", \\\"4621\\\", \\\"4622\\\", \\\"4623\\\", \\\"4624\\\", \\\"4625\\\", \\\"4626\\\", \\\"4627\\\", \\\"4628\\\", \\\"4629\\\", \\\"4630\\\", \\\"4631\\\", \\\"4632\\\", \\\"4633\\\", \\\"4634\\\", \\\"4635\\\", \\\"4636\\\", \\\"4637\\\", \\\"4638\\\", \\\"4639\\\", \\\"4640\\\", \\\"4641\\\", \\\"4642\\\", \\\"4643\\\", \\\"4644\\\", \\\"4645\\\", \\\"4646\\\", \\\"4647\\\", \\\"4648\\\", \\\"4649\\\", \\\"4650\\\", \\\"4651\\\", \\\"4652\\\", \\\"4653\\\", \\\"9670\\\", \\\"4654\\\", \\\"4655\\\", \\\"4656\\\", \\\"4657\\\", \\\"4658\\\", \\\"4659\\\", \\\"4660\\\", \\\"4661\\\", \\\"4662\\\", \\\"4663\\\", \\\"4664\\\", \\\"2768\\\", \\\"2769\\\", \\\"2770\\\", \\\"183\\\", \\\"2771\\\", \\\"3127\\\", \\\"6832\\\", \\\"7777\\\", \\\"8033\\\", \\\"8596\\\", \\\"9671\\\", \\\"27548\\\", \\\"30556\\\", \\\"30790\\\", \\\"34732\\\", \\\"4665\\\", \\\"4666\\\", \\\"4667\\\", \\\"4668\\\", \\\"4669\\\", \\\"4670\\\", \\\"4671\\\", \\\"4672\\\", \\\"4673\\\", \\\"4674\\\", \\\"4675\\\", \\\"4676\\\", \\\"4677\\\", \\\"4678\\\", \\\"4679\\\", \\\"4680\\\", \\\"4681\\\", \\\"4682\\\", \\\"4683\\\", \\\"4684\\\", \\\"4685\\\", \\\"4686\\\", \\\"4687\\\", \\\"4688\\\", \\\"4689\\\", \\\"4690\\\", \\\"4691\\\", \\\"4692\\\", \\\"4693\\\", \\\"4694\\\", \\\"4695\\\", \\\"4696\\\", \\\"4697\\\", \\\"4698\\\", \\\"7770\\\", \\\"4699\\\", \\\"4700\\\", \\\"4701\\\", \\\"4702\\\", \\\"4703\\\", \\\"4704\\\", \\\"4705\\\", \\\"4706\\\", \\\"4707\\\", \\\"4708\\\", \\\"4709\\\", \\\"4710\\\", \\\"4711\\\", \\\"4712\\\", \\\"4713\\\", \\\"4714\\\", \\\"4715\\\", \\\"4716\\\", \\\"4717\\\", \\\"4718\\\", \\\"4719\\\", \\\"4720\\\", \\\"4721\\\", \\\"4722\\\", \\\"4723\\\", \\\"4724\\\", \\\"4725\\\", \\\"4726\\\", \\\"4727\\\", \\\"4728\\\", \\\"4729\\\", \\\"4730\\\", \\\"4731\\\", \\\"4732\\\", \\\"4733\\\", \\\"4734\\\", \\\"4735\\\", \\\"4736\\\", \\\"4737\\\", \\\"4738\\\", \\\"4739\\\", \\\"4740\\\", \\\"4741\\\", \\\"4742\\\", \\\"4743\\\", \\\"4744\\\", \\\"4745\\\", \\\"4746\\\", \\\"4747\\\", \\\"4748\\\", \\\"4749\\\", \\\"4750\\\", \\\"4751\\\", \\\"4752\\\", \\\"4753\\\", \\\"4754\\\", \\\"4755\\\", \\\"4756\\\", \\\"4757\\\", \\\"7771\\\", \\\"4758\\\", \\\"4759\\\", \\\"4760\\\", \\\"4761\\\", \\\"4762\\\", \\\"4763\\\", \\\"4764\\\", \\\"4765\\\", \\\"4766\\\", \\\"4767\\\", \\\"4768\\\", \\\"4769\\\", \\\"4770\\\", \\\"4771\\\", \\\"4772\\\", \\\"4773\\\", \\\"4774\\\", \\\"4775\\\", \\\"4776\\\", \\\"4777\\\", \\\"4778\\\", \\\"4779\\\", \\\"8880\\\", \\\"4780\\\", \\\"4781\\\", \\\"4782\\\", \\\"4783\\\", \\\"30555\\\", \\\"4784\\\", \\\"4785\\\", \\\"4786\\\", \\\"4787\\\", \\\"4788\\\", \\\"2767\\\", \\\"4789\\\", \\\"4790\\\", \\\"4791\\\", \\\"4792\\\", \\\"4793\\\", \\\"4794\\\", \\\"4795\\\", \\\"4796\\\", \\\"4797\\\", \\\"4798\\\", \\\"4799\\\", \\\"4800\\\", \\\"4801\\\", \\\"4802\\\", \\\"4803\\\", \\\"4804\\\", \\\"4805\\\", \\\"2773\\\", \\\"2772\\\", \\\"4806\\\", \\\"4807\\\", \\\"4808\\\", \\\"4809\\\", \\\"4810\\\", \\\"4811\\\", \\\"4812\\\", \\\"30557\\\", \\\"4813\\\", \\\"4814\\\", \\\"4815\\\", \\\"4816\\\", \\\"4817\\\", \\\"4818\\\", \\\"4819\\\", \\\"4820\\\", \\\"4821\\\", \\\"4822\\\", \\\"4823\\\", \\\"4824\\\", \\\"4825\\\", \\\"4826\\\", \\\"4827\\\", \\\"4828\\\", \\\"4829\\\", \\\"4830\\\", \\\"4831\\\", \\\"4832\\\", \\\"4833\\\", \\\"4834\\\", \\\"4835\\\", \\\"4836\\\", \\\"4837\\\", \\\"4838\\\", \\\"4839\\\", \\\"4840\\\", \\\"4841\\\", \\\"4842\\\", \\\"4843\\\", \\\"4844\\\", \\\"4845\\\", \\\"4846\\\", \\\"4847\\\", \\\"4848\\\", \\\"4849\\\", \\\"4850\\\", \\\"4851\\\", \\\"4852\\\", \\\"4853\\\", \\\"9672\\\", \\\"4854\\\", \\\"4855\\\", \\\"4856\\\", \\\"30558\\\", \\\"4857\\\", \\\"4858\\\", \\\"4859\\\", \\\"4860\\\", \\\"4861\\\", \\\"4862\\\", \\\"4863\\\", \\\"4864\\\", \\\"4865\\\", \\\"4866\\\", \\\"4867\\\", \\\"4868\\\", \\\"4869\\\", \\\"4870\\\", \\\"4871\\\", \\\"4872\\\", \\\"4873\\\", \\\"4874\\\", \\\"4875\\\", \\\"4876\\\", \\\"4877\\\", \\\"4878\\\", \\\"4879\\\", \\\"4880\\\", \\\"4881\\\", \\\"4882\\\", \\\"4883\\\", \\\"4884\\\", \\\"4885\\\", \\\"4886\\\", \\\"4887\\\", \\\"4888\\\", \\\"10896\\\", \\\"10897\\\", \\\"4891\\\", \\\"4892\\\", \\\"4893\\\", \\\"4894\\\", \\\"30561\\\", \\\"4895\\\", \\\"4896\\\", \\\"4897\\\", \\\"4898\\\", \\\"4899\\\", \\\"4900\\\", \\\"4901\\\", \\\"4902\\\", \\\"4903\\\", \\\"4904\\\", \\\"4905\\\", \\\"4906\\\", \\\"4907\\\", \\\"4908\\\", \\\"4909\\\", \\\"4910\\\", \\\"4911\\\", \\\"4912\\\", \\\"4913\\\", \\\"4914\\\", \\\"4915\\\", \\\"4916\\\", \\\"4917\\\", \\\"4918\\\", \\\"4919\\\", \\\"4920\\\", \\\"4921\\\", \\\"4922\\\", \\\"4923\\\", \\\"4924\\\", \\\"4925\\\", \\\"4926\\\", \\\"4927\\\", \\\"4928\\\", \\\"4929\\\", \\\"4930\\\", \\\"4931\\\", \\\"4932\\\", \\\"4933\\\", \\\"4934\\\", \\\"4935\\\", \\\"4936\\\", \\\"4937\\\", \\\"4938\\\", \\\"4939\\\", \\\"4940\\\", \\\"4941\\\", \\\"4942\\\", \\\"4943\\\", \\\"4944\\\", \\\"4945\\\", \\\"4946\\\", \\\"4947\\\", \\\"4948\\\", \\\"4949\\\", \\\"4950\\\", \\\"4951\\\", \\\"4952\\\", \\\"4953\\\", \\\"4954\\\", \\\"4955\\\", \\\"4956\\\", \\\"4957\\\", \\\"4958\\\", \\\"4959\\\", \\\"4960\\\", \\\"4961\\\", \\\"4962\\\", \\\"4963\\\", \\\"4964\\\", \\\"4965\\\", \\\"4966\\\", \\\"4967\\\", \\\"4968\\\", \\\"4969\\\", \\\"4970\\\", \\\"4971\\\", \\\"4972\\\", \\\"4973\\\", \\\"4974\\\", \\\"4975\\\", \\\"4976\\\", \\\"4977\\\", \\\"4978\\\", \\\"4979\\\", \\\"4980\\\", \\\"4981\\\", \\\"4982\\\", \\\"4983\\\", \\\"4984\\\", \\\"4985\\\", \\\"4986\\\", \\\"4987\\\", \\\"4988\\\", \\\"4989\\\", \\\"4990\\\", \\\"4991\\\", \\\"4992\\\", \\\"4993\\\", \\\"4994\\\", \\\"4995\\\", \\\"4996\\\", \\\"4997\\\", \\\"4998\\\", \\\"4999\\\", \\\"5000\\\", \\\"5001\\\", \\\"5002\\\", \\\"5003\\\", \\\"5004\\\", \\\"5005\\\", \\\"5006\\\", \\\"5007\\\", \\\"5008\\\", \\\"5009\\\", \\\"5010\\\", \\\"5011\\\", \\\"5012\\\", \\\"5013\\\", \\\"5014\\\", \\\"5018\\\", \\\"5024\\\", \\\"5026\\\", \\\"5027\\\", \\\"9675\\\", \\\"5028\\\", \\\"5029\\\", \\\"5030\\\", \\\"5031\\\", \\\"5032\\\", \\\"5033\\\", \\\"5034\\\", \\\"5035\\\", \\\"5036\\\", \\\"5037\\\", \\\"5038\\\", \\\"5039\\\", \\\"5040\\\", \\\"5041\\\", \\\"5042\\\", \\\"7780\\\", \\\"5043\\\", \\\"5044\\\", \\\"5045\\\", \\\"5046\\\", \\\"5047\\\", \\\"5048\\\", \\\"5049\\\", \\\"5050\\\", \\\"5051\\\", \\\"30562\\\", \\\"5052\\\", \\\"5053\\\", \\\"5054\\\", \\\"10898\\\", \\\"9677\\\", \\\"2775\\\", \\\"6836\\\", \\\"2777\\\", \\\"6837\\\", \\\"30565\\\", \\\"6838\\\", \\\"5055\\\", \\\"5056\\\", \\\"5057\\\", \\\"5058\\\", \\\"5059\\\", \\\"5060\\\", \\\"5061\\\", \\\"5062\\\", \\\"5063\\\", \\\"5064\\\", \\\"5065\\\", \\\"5066\\\", \\\"5067\\\", \\\"5068\\\", \\\"5069\\\", \\\"6959\\\", \\\"5070\\\", \\\"5071\\\", \\\"5072\\\", \\\"5073\\\", \\\"5074\\\", \\\"5075\\\", \\\"5076\\\", \\\"5077\\\", \\\"5078\\\", \\\"5079\\\", \\\"5080\\\", \\\"5081\\\", \\\"5082\\\", \\\"5083\\\", \\\"5084\\\", \\\"5085\\\", \\\"5086\\\", \\\"5087\\\", \\\"5088\\\", \\\"5089\\\", \\\"5090\\\", \\\"5091\\\", \\\"5092\\\", \\\"5093\\\", \\\"5094\\\", \\\"5095\\\", \\\"5096\\\", \\\"5097\\\", \\\"5098\\\", \\\"5099\\\", \\\"5100\\\", \\\"5101\\\", \\\"5102\\\", \\\"5103\\\", \\\"5104\\\", \\\"5105\\\", \\\"5106\\\", \\\"5107\\\", \\\"5108\\\", \\\"5109\\\", \\\"5110\\\", \\\"5111\\\", \\\"5112\\\", \\\"5113\\\", \\\"5114\\\", \\\"5115\\\", \\\"5116\\\", \\\"5117\\\", \\\"5118\\\", \\\"5119\\\", \\\"5120\\\", \\\"5121\\\", \\\"5122\\\", \\\"5123\\\", \\\"5124\\\", \\\"5125\\\", \\\"5126\\\", \\\"5127\\\", \\\"5128\\\", \\\"9678\\\", \\\"5129\\\", \\\"5130\\\", \\\"5131\\\", \\\"5132\\\", \\\"5133\\\", \\\"5134\\\", \\\"5135\\\", \\\"6839\\\", \\\"30795\\\", \\\"30567\\\", \\\"30568\\\", \\\"{DAV:}creationdate\\\", \\\"{DAV:}displayname\\\", \\\"{DAV:}source\\\"]:\\n\\nSQLSTATE[HY000]: General error: 1 too many SQL variables\",\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Code\":0,\"Trace\":\"#0 \\\/srv\\\/www\\\/htdocs\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractSQLiteDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/srv\\\/www\\\/htdocs\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(855): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOSqlite\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'SELECT * FROM \\\"...', Array)\\n#2 \\\/srv\\\/www\\\/htdocs\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(190): Doctrine\\\\DBAL\\\\Connection->executeQuery('SELECT * FROM \\\"...', Array, Array, NULL)\\n#3 \\\/srv\\\/www\\\/htdocs\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/CustomPropertiesBackend.php(333): OC\\\\DB\\\\Connection->executeQuery('SELECT * FROM \\\"...', Array, Array)\\n#4 \\\/srv\\\/www\\\/htdocs\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/CustomPropertiesBackend.php(139): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\CustomPropertiesBackend->loadChildrenProperties(Object(OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory), Array)\\n#5 \\\/srv\\\/www\\\/htdocs\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/PropertyStorage\\\/Plugin.php(91): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\CustomPropertiesBackend->propFind('Documents\\\/BookC...', Object(Sabre\\\\DAV\\\\PropFind))\\n#6 [internal function]: Sabre\\\\DAV\\\\PropertyStorage\\\\Plugin->propFind(Object(Sabre\\\\DAV\\\\PropFind), Object(OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory))\\n#7 \\\/srv\\\/www\\\/htdocs\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#8 \\\/srv\\\/www\\\/htdocs\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1058): Sabre\\\\Event\\\\EventEmitter->emit('propFind', Array)\\n#9 \\\/srv\\\/www\\\/htdocs\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(980): Sabre\\\\DAV\\\\Server->getPropertiesByNode(Object(Sabre\\\\DAV\\\\PropFind), Object(OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory))\\n#10 \\\/srv\\\/www\\\/htdocs\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1665): Sabre\\\\DAV\\\\Server->getPropertiesIteratorForPath('Documents\\\/BookC...', Array, 1)\\n#11 \\\/srv\\\/www\\\/htdocs\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(355): Sabre\\\\DAV\\\\Server->generateMultiStatus(Object(Generator), false)\\n#12 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpPropFind(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#13 \\\/srv\\\/www\\\/htdocs\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#14 \\\/srv\\\/www\\\/htdocs\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:PROPFIND', Array)\\n#15 \\\/srv\\\/www\\\/htdocs\\\/owncloud\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#16 \\\/srv\\\/www\\\/htdocs\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v1\\\/webdav.php(63): Sabre\\\\DAV\\\\Server->exec()\\n#17 \\\/srv\\\/www\\\/htdocs\\\/owncloud\\\/remote.php(165): require_once('\\\/srv\\\/www\\\/htdocs...')\\n#18 {main}\",\"File\":\"\\\/srv\\\/www\\\/htdocs\\\/owncloud\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractSQLiteDriver.php\",\"Line\":85,\"User\":\"user\"}"}

[PVince81]

Thanks, that looks bad. @VicDeo I've assigned you to fix this

[VicDeo]

@Grunthos @cortho @calvsung mind testing #29405 ?

[Grunthos]

Sadly I'm running 10.0.3 which does not have the patched file, so not really able to test.

[Grunthos]

stable10 seems to be very different from the 10.0.3 that I have installed on OpenSuse 42.3. The SuSE one seems to look more like v10.0

See:
https://github.com/owncloud/core/tree/v10.0/apps/dav/lib/DAV

Vs.

https://github.com/owncloud/core/tree/stable10/apps/dav/lib/DAV

Any plans to update the v10.0 branch?

[VicDeo]

@Grunthos v10.0 is a release tag, not a branch. While stable10 is a branch where all the work for 10.0.x takes place.
You can compare v10.0 with another tag e.g. 10.0.4 beta v10.0.4beta2
https://github.com/owncloud/core/tree/v10.0.4beta2/apps/dav/lib/DAV

[lock]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.