Hi,
I recently setup nextcloud 20.0.0 on my server and PHP version is 7.4 but when i try to upload files i get message “Operation is blocked by access control”
can you guys please help me to fix it ?
Could you please use the template?
@sturtz_nate sorry for not follwing the format
Support intro
Sorry to hear you’re facing problems
help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.
In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:
example
Or for longer, use three backticks above and below the code snippet:
longer
examp
here
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
Nextcloud version : 20.0.0
Operating system and version : Ubuntu 20.04
Apache or nginx version : nginx - runcloud.io
PHP version : 7.4
The issue you are facing:
when i try to upload .zip files, I get the error “Operation is blocked by access control”
Is this the first time you’ve seen this error? (Y/N): I just installed a fresh copy of nextcloud
Steps to replicate it:
- try to upload .zip file
The output of your Nextcloud log in Admin > Logging:
{"reqId":"niTSz22alJ8wGKTKkt9Z","level":4,"time":"2020-10-12T14:17:26+00:00","remoteAddr":"122.174.192.109","user":"Rathana Puducherry","app":"webdav","method":"DELETE","url":"/remote.php/dav/files/Rathana%20Puducherry/Documents","message":{"Exception":"Doctrine\\DBAL\\Exception\\DeadlockException","Message":"An exception occurred while executing 'UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, ?), `etag` = ? WHERE (`storage` = ?) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '45b963397aa40d4a0063e0d85e4fe7a1'))' with params [1602512246, \"5f846576144a9\", 5]:\n\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction","Code":0,"Trace":[{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":169,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractMySQLDriver","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":149,"function":"wrapException","class":"Doctrine\\DBAL\\DBALException","type":"::"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1071,"function":"driverExceptionDuringQuery","class":"Doctrine\\DBAL\\DBALException","type":"::"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/DB/Connection.php","line":214,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":209,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/Files/Cache/Propagator.php","line":100,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/Files/Cache/HomePropagator.php","line":49,"function":"propagateChange","class":"OC\\Files\\Cache\\Propagator","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/Files/Cache/Updater.php","line":166,"function":"propagateChange","class":"OC\\Files\\Cache\\HomePropagator","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/Files/View.php","line":329,"function":"remove","class":"OC\\Files\\Cache\\Updater","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/Files/View.php","line":1173,"function":"removeUpdate","class":"OC\\Files\\View","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/Files/View.php","line":350,"function":"basicOperation","class":"OC\\Files\\View","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/apps/dav/lib/Connector/Sabre/Directory.php","line":309,"function":"rmdir","class":"OC\\Files\\View","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/sabre/dav/lib/DAV/Tree.php","line":183,"function":"delete","class":"OCA\\DAV\\Connector\\Sabre\\Directory","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":295,"function":"delete","class":"Sabre\\DAV\\Tree","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpDelete","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/sabre/dav/lib/DAV/Server.php","line":474,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/sabre/dav/lib/DAV/Server.php","line":251,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/sabre/dav/lib/DAV/Server.php","line":319,"function":"start","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/apps/dav/lib/Server.php","line":325,"function":"exec","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/remote.php","line":167,"args":["/home/shivalingamtransports/webapps/shivalingamtransports/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php","Line":34,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDOException","Message":"SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction","Code":"40001","Trace":[{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1062,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/DB/Connection.php","line":214,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":209,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/Files/Cache/Propagator.php","line":100,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/Files/Cache/HomePropagator.php","line":49,"function":"propagateChange","class":"OC\\Files\\Cache\\Propagator","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/Files/Cache/Updater.php","line":166,"function":"propagateChange","class":"OC\\Files\\Cache\\HomePropagator","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/Files/View.php","line":329,"function":"remove","class":"OC\\Files\\Cache\\Updater","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/Files/View.php","line":1173,"function":"removeUpdate","class":"OC\\Files\\View","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/Files/View.php","line":350,"function":"basicOperation","class":"OC\\Files\\View","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/apps/dav/lib/Connector/Sabre/Directory.php","line":309,"function":"rmdir","class":"OC\\Files\\View","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/sabre/dav/lib/DAV/Tree.php","line":183,"function":"delete","class":"OCA\\DAV\\Connector\\Sabre\\Directory","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":295,"function":"delete","class":"Sabre\\DAV\\Tree","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpDelete","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/sabre/dav/lib/DAV/Server.php","line":474,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/sabre/dav/lib/DAV/Server.php","line":251,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/sabre/dav/lib/DAV/Server.php","line":319,"function":"start","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/apps/dav/lib/Server.php","line":325,"function":"exec","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/remote.php","line":167,"args":["/home/shivalingamtransports/webapps/shivalingamtransports/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":129,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction","Code":"40001","Trace":[{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","line":127,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1062,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/DB/Connection.php","line":214,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":209,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/Files/Cache/Propagator.php","line":100,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/Files/Cache/HomePropagator.php","line":49,"function":"propagateChange","class":"OC\\Files\\Cache\\Propagator","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/Files/Cache/Updater.php","line":166,"function":"propagateChange","class":"OC\\Files\\Cache\\HomePropagator","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/Files/View.php","line":329,"function":"remove","class":"OC\\Files\\Cache\\Updater","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/Files/View.php","line":1173,"function":"removeUpdate","class":"OC\\Files\\View","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/lib/private/Files/View.php","line":350,"function":"basicOperation","class":"OC\\Files\\View","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/apps/dav/lib/Connector/Sabre/Directory.php","line":309,"function":"rmdir","class":"OC\\Files\\View","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/sabre/dav/lib/DAV/Tree.php","line":183,"function":"delete","class":"OCA\\DAV\\Connector\\Sabre\\Directory","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":295,"function":"delete","class":"Sabre\\DAV\\Tree","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpDelete","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/sabre/dav/lib/DAV/Server.php","line":474,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/sabre/dav/lib/DAV/Server.php","line":251,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/sabre/dav/lib/DAV/Server.php","line":319,"function":"start","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/apps/dav/lib/Server.php","line":325,"function":"exec","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/home/shivalingamtransports/webapps/shivalingamtransports/remote.php","line":167,"args":["/home/shivalingamtransports/webapps/shivalingamtransports/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/home/shivalingamtransports/webapps/shivalingamtransports/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":127}},"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.75 Safari/537.36","version":"20.0.0.9","id":"5f8481ea3431b"}
SOP Revision 3.zip
ok before you upload it try to rename it to sop_revision_3.zip then try to upload it
not working, still same issue “Operation is blocked by access control”
ok do you have flowupload enabled?
The app flow upload
its a fresh install and i did not change anything in settings
ok, what apps do you have enabled
I didnt enable any app on my own, Only the default app should be enabled
@sturtz_nate where you able to find the issue ?
it would be really helpful if you can help me to solve this issue.
could you please post your full nextcloud log? it is /your/nextcloud/data-dir/nextcloud.log and your config.php file please remove all sensitive data
If you could
post it using ``` that would be nice```
sure, but i am new to this… should i have to ssh to the server and download the log or i can find it in the nextcloud dashboard ?
ssh into your server and do this cat /data/path/nextcloud.log
copy and paste that into here then cat /nextcloud/path/config/config.php
copy and paste this to