Nextcloud not available

Hello everybody,

I’m a new Nextcloud user and excited about running my own cloud.

Also, I’m new to the field of Linux, but have managed with patience and Google to get Nextcloud to work. But from time to time, I sometimes have problems using it, because the cloud temporarily fails. Currently it is not running at all. Sometimes it needs a server restart.

And often I get several error messages.

I wonder if you can help me here. Nextcloud runs on a home server with 4GB of memory,

  • Nextcloud 13.04
  • Ubuntu Server 18.04 LTS,
  • nginx 1.15.0,
  • PHP 7.2.5 und
  • mariaDB 10.3.7.

The call should be done using virtual host and dynamic dns. An SSL certificate has been created with letsencrypt.
Yesterday when uploading images, the Internet connection is aborted. Since then I can not get on the cloud anymore. I enclose my log files and .conf files. Maybe you have an idea.

Thank you in advance in any case!

Is this the first time you’ve seen this error? (Y/N)_: No

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'instanceid' => 'ocf0ssmjs4md',
  'passwordsalt' => 'q2iX9AYZZyoiIljQ78u8m2waFJPGBr',
  'secret' => '5i5du/XSbJJqD1aq+uW4SpwQcIjXxGXUOFkFlm6ABUN0wQe6',
  'trusted_domains' => 
  array (
    0 => 'MY-DOMAIN',
    1 => '192.168.1**.**',
  ),
  'datadirectory' => '/myDataDirectory/nextcloud_data',
  'overwrite.cli.url' => 'http://MY-DOMAIN/nextcloud',
  'dbtype' => 'mysql',
  'version' => '13.0.4.0',
  'dbname' => 'db_name',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'username',
  'dbpassword' => 'password',
  'installed' => true,
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'overwriteprotocol' => 'https',
  'logtimezone' => 'Europe/Berlin',
  'mysql.utf8mb4' => true,
  'maintenance' => false,
);

The output of your Apache/nginx/system log in /var/log/____:

2018/06/28 07:11:20 [error] 1656#1656: *848 open() "/etc/nginx/html/unauthenticated/css/bundle.min.css" failed (2: No such file or directory), client: 80.187.116.88, server: MY-DOMAIN, request: "GET /unauthenticated/css/bundle.min.css?19092 HTTP/2.0", host: "MY-DOMAIN", referrer: "https://MY-DOMAIN/webmin/"
2018/06/28 07:11:20 [error] 1656#1656: *848 open() "/etc/nginx/html/unauthenticated/css/fonts-roboto.min.css" failed (2: No such file or directory), client: 80.187.116.88, server: MY-DOMAIN, request: "GET /unauthenticated/css/fonts-roboto.min.css?19092 HTTP/2.0", host: "MY-DOMAIN", referrer: "https://MY-DOMAIN/webmin/"
2018/06/28 07:11:20 [error] 1656#1656: *848 open() "/etc/nginx/html/images/favicon-webmin.ico" failed (2: No such file or directory), client: 80.187.116.88, server: MY-DOMAIN, request: "GET /images/favicon-webmin.ico HTTP/2.0", host: "MY-DOMAIN", referrer: "https://MY-DOMAIN/webmin/"
2018/06/28 07:11:40 [error] 1656#1656: *848 open() "/etc/nginx/html/session_login.cgi" failed (2: No such file or directory), client: 80.187.116.88, server: MY-DOMAIN, request: "POST /session_login.cgi HTTP/2.0", host: "MY-DOMAIN", referrer: "https://MY-DOMAIN/webmin/"
2018/06/28 07:11:40 [error] 1656#1656: *848 open() "/etc/nginx/html/favicon.ico" failed (2: No such file or directory), client: 80.187.116.88, server: MY-DOMAIN, request: "GET /favicon.ico HTTP/2.0", host: "MY-DOMAIN", referrer: "https://MY-DOMAIN/session_login.cgi"
2018/06/28 09:22:17 [error] 1656#1656: *912 open() "/etc/nginx/html/admin/config.php" failed (2: No such file or directory), client: 37.49.231.62, server: MY-DOMAIN, request: "GET //admin/config.php HTTP/1.1", host: "MY-DOMAIN"
2018/06/28 13:32:15 [error] 1656#1656: *1058 access forbidden by rule, client: 139.162.78.135, server: MY-DOMAIN, request: "GET / HTTP/1.1", host: "87.122.1.116"
2018/06/28 13:38:36 [error] 1656#1656: *1064 open() "/etc/nginx/html/favicon.ico" failed (2: No such file or directory), client: 94.102.49.193, server: MY-DOMAIN, request: "GET /favicon.ico HTTP/1.1", host: "MY-DOMAIN"
2018/06/28 15:18:54 [error] 1656#1656: *1068 access forbidden by rule, client: 94.102.49.193, server: MY-DOMAIN, request: "GET / HTTP/1.1", host: "87.122.1.116"
2018/06/28 15:18:58 [crit] 1656#1656: *1070 SSL_do_handshake() failed (SSL: error:1417D102:SSL routines:tls_process_client_hello:unsupported protocol) while SSL handshaking, client: 94.102.49.193, server: 0.0.0.0:443
2018/06/28 15:19:03 [crit] 1656#1656: *1072 SSL_do_handshake() failed (SSL: error:1417D18C:SSL routines:tls_process_client_hello:version too low) while SSL handshaking, client: 94.102.49.193, server: 0.0.0.0:443
2018/06/28 15:19:04 [crit] 1656#1656: *1073 SSL_do_handshake() failed (SSL: error:1417D102:SSL routines:tls_process_client_hello:unsupported protocol) while SSL handshaking, client: 94.102.49.193, server: 0.0.0.0:443
2018/06/28 15:19:18 [error] 1656#1656: *1080 open() "/etc/nginx/html/robots.txt" failed (2: No such file or directory), client: 94.102.49.193, server: MY-DOMAIN, request: "GET /robots.txt HTTP/1.1", host: "87.122.1.116"
2018/06/28 15:19:24 [error] 1656#1656: *1081 open() "/etc/nginx/html/sitemap.xml" failed (2: No such file or directory), client: 94.102.49.193, server: MY-DOMAIN, request: "GET /sitemap.xml HTTP/1.1", host: "87.122.1.116"
2018/06/28 15:19:28 [error] 1656#1656: *1082 open() "/etc/nginx/html/.well-known/security.txt" failed (2: No such file or directory), client: 94.102.49.193, server: MY-DOMAIN, request: "GET /.well-known/security.txt HTTP/1.1", host: "87.122.1.116"
2018/06/28 15:19:41 [error] 1656#1656: *1083 open() "/etc/nginx/html/favicon.ico" failed (2: No such file or directory), client: 94.102.49.193, server: MY-DOMAIN, request: "GET /favicon.ico HTTP/1.1", host: "87.122.1.116"
2018/06/28 15:42:12 [error] 1656#1656: *1183 access forbidden by rule, client: 109.90.14.20, server: MY-DOMAIN, request: "GET / HTTP/1.0"
2018/06/28 17:11:55 [warn] 793#793: the "ssl" directive is deprecated, use the "listen ... ssl" directive instead in /etc/nginx/conf.d/dynamicdns_webmin.conf:5
2018/06/28 17:14:11 [warn] 817#817: the "ssl" directive is deprecated, use the "listen ... ssl" directive instead in /etc/nginx/conf.d/dynamicdns_webmin.conf:5

Just to complete

The output of your Nextcloud log in Admin > Logging:

{"reqId":"6GlxxUDCEh0x2KGQzvbd","level":4,"time":"2018-06-27T21:09:55+02:00","remoteAddr":"87.122.13.46","user":"Admin","app":"webdav","method":"PUT","url":"\/nextcloud\/remote.php\/dav\/files\/Admin\/Photos\/folder%202015\/IMG_1252.JPG","message":"Exception: {\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\BadRequest\",\"Message\":\"expected filesize 8018912 got 8011776\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/Directory.php(156): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->put(Resource id #19)\\n#1 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1096): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory->createFile('IMG_1252.JPG', Resource id #19)\\n#2 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(529): Sabre\\\\DAV\\\\Server->createFile('files\\\/Admin\\\/Pho...', Resource id #19, NULL)\\n#3 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpPut(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#4 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#5 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:PUT', Array)\\n#6 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#7 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/lib\\\/Server.php(287): Sabre\\\\DAV\\\\Server->exec()\\n#8 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(35): OCA\\\\DAV\\\\Server->exec()\\n#9 \\\/var\\\/www\\\/nextcloud\\\/remote.php(164): require_once('\\\/var\\\/www\\\/nextcl...')\\n#10 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php\",\"Line\":180}","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"13.0.4.0"}
{"reqId":"8fva8IuiDXxeiY2h2PHL","level":4,"time":"2018-06-27T21:09:55+02:00","remoteAddr":"87.122.13.46","user":"Admin","app":"webdav","method":"PUT","url":"\/nextcloud\/remote.php\/dav\/files\/Admin\/Photos\/folder%202015\/IMG_1254.JPG","message":"Exception: {\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\BadRequest\",\"Message\":\"expected filesize 7181555 got 6635520\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/Directory.php(156): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->put(Resource id #19)\\n#1 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1096): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory->createFile('IMG_1254.JPG', Resource id #19)\\n#2 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(529): Sabre\\\\DAV\\\\Server->createFile('files\\\/Admin\\\/Pho...', Resource id #19, NULL)\\n#3 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpPut(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#4 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#5 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:PUT', Array)\\n#6 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#7 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/lib\\\/Server.php(287): Sabre\\\\DAV\\\\Server->exec()\\n#8 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(35): OCA\\\\DAV\\\\Server->exec()\\n#9 \\\/var\\\/www\\\/nextcloud\\\/remote.php(164): require_once('\\\/var\\\/www\\\/nextcl...')\\n#10 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php\",\"Line\":180}","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"13.0.4.0"}
{"reqId":"esNh7rpyPY93w5R8zWYq","level":3,"time":"2018-06-28T05:50:31+02:00","remoteAddr":"87.122.1.116","user":"Admin","app":"index","method":"GET","url":"\/nextcloud\/core\/preview.png?file=%2FIMG_20180507_162638.jpg&c=7b0b20ac30e24663fd6360698539f202&x=82&y=82&forceIcon=0","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'INSERT INTO `oc_filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`parent`,`checksum`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0' with params [\\\"11\\\", \\\"12\\\", 1530157830, 0, \\\"2ba9b530e9d4fcae2aa03ebd2d52ed04\\\", 1530157830, 27, 617, \\\"\\\", \\\"328378a3a076df800a11af34b2c8cd66\\\", \\\"appdata_ocf0ssmjs4md\\\\\\\/preview\\\\\\\/568\\\\\\\/128-128-crop.jpg\\\", \\\"128-128-crop.jpg\\\", 1, 1, \\\"328378a3a076df800a11af34b2c8cd66\\\"]:\\n\\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1015): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'INSERT INTO `oc...', Array)\\n#2 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/DB\\\/Connection.php(216): Doctrine\\\\DBAL\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#3 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/DB\\\/Adapter.php(114): OC\\\\DB\\\\Connection->executeUpdate('INSERT INTO `oc...', Array)\\n#4 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/DB\\\/Connection.php(254): OC\\\\DB\\\\Adapter->insertIfNotExist('*PREFIX*filecac...', Array, Array)\\n#5 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Cache.php(273): OC\\\\DB\\\\Connection->insertIfNotExist('*PREFIX*filecac...', Array, Array)\\n#6 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Cache.php(230): OC\\\\Files\\\\Cache\\\\Cache->insert('appdata_ocf0ssm...', Array)\\n#7 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Scanner.php(292): OC\\\\Files\\\\Cache\\\\Cache->put('appdata_ocf0ssm...', Array)\\n#8 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Scanner.php(221): OC\\\\Files\\\\Cache\\\\Scanner->addToCache('appdata_ocf0ssm...', Array, -1)\\n#9 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Scanner.php(336): OC\\\\Files\\\\Cache\\\\Scanner->scanFile('appdata_ocf0ssm...', 3, 617, false, false)\\n#10 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Updater.php(124): OC\\\\Files\\\\Cache\\\\Scanner->scan('appdata_ocf0ssm...', false, 3, false)\\n#11 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/View.php(319): OC\\\\Files\\\\Cache\\\\Updater->update('appdata_ocf0ssm...', 1530157830)\\n#12 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/View.php(1163): OC\\\\Files\\\\View->writeUpdate(Object(OCA\\\\Files_Trashbin\\\\Storage), 'appdata_ocf0ssm...')\\n#13 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/View.php(568): OC\\\\Files\\\\View->basicOperation('touch', '\\\/appdata_ocf0ss...', Array, NULL)\\n#14 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/Node\\\/Folder.php(181): OC\\\\Files\\\\View->touch('\\\/appdata_ocf0ss...')\\n#15 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/SimpleFS\\\/SimpleFolder.php(83): OC\\\\Files\\\\Node\\\\Folder->newFile('128-128-crop.jp...')\\n#16 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Preview\\\/Generator.php(376): OC\\\\Files\\\\SimpleFS\\\\SimpleFolder->newFile('128-128-crop.jp...')\\n#17 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Preview\\\/Generator.php(145): OC\\\\Preview\\\\Generator->generatePreview(Object(OC\\\\Files\\\\SimpleFS\\\\SimpleFolder), Object(OC\\\\Files\\\\SimpleFS\\\\SimpleFile), 128, 128, true, 3072, 4096)\\n#18 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/PreviewManager.php(202): OC\\\\Preview\\\\Generator->getPreview(Object(OC\\\\Files\\\\Node\\\\File), 128, 128, true, 'fill', 'image\\\/jpeg')\\n#19 \\\/var\\\/www\\\/nextcloud\\\/core\\\/Controller\\\/PreviewController.php(114): OC\\\\PreviewManager->getPreview(Object(OC\\\\Files\\\\Node\\\\File), 82, 82, true, 'fill')\\n#20 [internal function]: OC\\\\Core\\\\Controller\\\\PreviewController->getPreview(Object(OC\\\\Files\\\\Node\\\\File), 82, 82, false, false, 'fill')\\n#21 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(161): call_user_func_array(Array, Array)\\n#22 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(91): OC\\\\AppFramework\\\\Http\\\\Dispatcher->executeController(Object(OC\\\\Core\\\\Controller\\\\PreviewController), 'getPreview')\\n#23 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/AppFramework\\\/App.php(115): OC\\\\AppFramework\\\\Http\\\\Dispatcher->dispatch(Object(OC\\\\Core\\\\Controller\\\\PreviewController), 'getPreview')\\n#24 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/AppFramework\\\/Routing\\\/RouteActionHandler.php(47): OC\\\\AppFramework\\\\App::main('OC\\\\\\\\Core\\\\\\\\Control...', 'getPreview', Object(OC\\\\AppFramework\\\\DependencyInjection\\\\DIContainer), Array)\\n#25 [internal function]: OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler->__invoke(Array)\\n#26 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Route\\\/Router.php(297): call_user_func(Object(OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler), Array)\\n#27 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(999): OC\\\\Route\\\\Router->match('\\\/core\\\/preview.p...')\\n#28 \\\/var\\\/www\\\/nextcloud\\\/index.php(42): OC::handleRequest()\\n#29 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":115}","userAgent":"Mozilla\/5.0 (Linux; Android 8.1.0; CLT-L29 Build\/HUAWEICLT-L29) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/67.0.3396.87 Mobile Safari\/537.36","version":"13.0.4.0"}
{"reqId":"97u8K1dxJPMV2Sr0u1SK","level":3,"time":"2018-06-28T05:50:31+02:00","remoteAddr":"87.122.1.116","user":"Admin","app":"index","method":"GET","url":"\/nextcloud\/core\/preview.png?file=%2FIMG-20180601-WA0003.jpg&c=51db75c41bfffdc20a7236792e13cd17&x=82&y=82&forceIcon=0","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'INSERT INTO `oc_filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`parent`,`checksum`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0' with params [\\\"11\\\", \\\"12\\\", 1530157830, 0, \\\"5880931a36c250a3ccfbb96394a2e28f\\\", 1530157830, 27, 559, \\\"\\\", \\\"53d2f2fa5be856dba11522e0bc943004\\\", \\\"appdata_ocf0ssmjs4md\\\\\\\/preview\\\\\\\/540\\\\\\\/128-128-crop.jpg\\\", \\\"128-128-crop.jpg\\\", 1, 1, \\\"53d2f2fa5be856dba11522e0bc943004\\\"]:\\n\\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1015): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'INSERT INTO `oc...', Array)\\n#2 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/DB\\\/Connection.php(216): Doctrine\\\\DBAL\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#3 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/DB\\\/Adapter.php(114): OC\\\\DB\\\\Connection->executeUpdate('INSERT INTO `oc...', Array)\\n#4 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/DB\\\/Connection.php(254): OC\\\\DB\\\\Adapter->insertIfNotExist('*PREFIX*filecac...', Array, Array)\\n#5 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Cache.php(273): OC\\\\DB\\\\Connection->insertIfNotExist('*PREFIX*filecac...', Array, Array)\\n#6 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Cache.php(230): OC\\\\Files\\\\Cache\\\\Cache->insert('appdata_ocf0ssm...', Array)\\n#7 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Scanner.php(292): OC\\\\Files\\\\Cache\\\\Cache->put('appdata_ocf0ssm...', Array)\\n#8 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Scanner.php(221): OC\\\\Files\\\\Cache\\\\Scanner->addToCache('appdata_ocf0ssm...', Array, -1)\\n#9 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Scanner.php(336): OC\\\\Files\\\\Cache\\\\Scanner->scanFile('appdata_ocf0ssm...', 3, 559, false, false)\\n#10 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/Cache\\\/Updater.php(124): OC\\\\Files\\\\Cache\\\\Scanner->scan('appdata_ocf0ssm...', false, 3, false)\\n#11 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/View.php(319): OC\\\\Files\\\\Cache\\\\Updater->update('appdata_ocf0ssm...', 1530157830)\\n#12 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/View.php(1163): OC\\\\Files\\\\View->writeUpdate(Object(OCA\\\\Files_Trashbin\\\\Storage), 'appdata_ocf0ssm...')\\n#13 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/View.php(568): OC\\\\Files\\\\View->basicOperation('touch', '\\\/appdata_ocf0ss...', Array, NULL)\\n#14 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/Node\\\/Folder.php(181): OC\\\\Files\\\\View->touch('\\\/appdata_ocf0ss...')\\n#15 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/SimpleFS\\\/SimpleFolder.php(83): OC\\\\Files\\\\Node\\\\Folder->newFile('128-128-crop.jp...')\\n#16 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Preview\\\/Generator.php(376): OC\\\\Files\\\\SimpleFS\\\\SimpleFolder->newFile('128-128-crop.jp...')\\n#17 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Preview\\\/Generator.php(145): OC\\\\Preview\\\\Generator->generatePreview(Object(OC\\\\Files\\\\SimpleFS\\\\SimpleFolder), Object(OC\\\\Files\\\\SimpleFS\\\\SimpleFile), 128, 128, true, 720, 1280)\\n#18 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/PreviewManager.php(202): OC\\\\Preview\\\\Generator->getPreview(Object(OC\\\\Files\\\\Node\\\\File), 128, 128, true, 'fill', 'image\\\/jpeg')\\n#19 \\\/var\\\/www\\\/nextcloud\\\/core\\\/Controller\\\/PreviewController.php(114): OC\\\\PreviewManager->getPreview(Object(OC\\\\Files\\\\Node\\\\File), 82, 82, true, 'fill')\\n#20 [internal function]: OC\\\\Core\\\\Controller\\\\PreviewController->getPreview(Object(OC\\\\Files\\\\Node\\\\File), 82, 82, false, false, 'fill')\\n#21 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(161): call_user_func_array(Array, Array)\\n#22 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(91): OC\\\\AppFramework\\\\Http\\\\Dispatcher->executeController(Object(OC\\\\Core\\\\Controller\\\\PreviewController), 'getPreview')\\n#23 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/AppFramework\\\/App.php(115): OC\\\\AppFramework\\\\Http\\\\Dispatcher->dispatch(Object(OC\\\\Core\\\\Controller\\\\PreviewController), 'getPreview')\\n#24 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/AppFramework\\\/Routing\\\/RouteActionHandler.php(47): OC\\\\AppFramework\\\\App::main('OC\\\\\\\\Core\\\\\\\\Control...', 'getPreview', Object(OC\\\\AppFramework\\\\DependencyInjection\\\\DIContainer), Array)\\n#25 [internal function]: OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler->__invoke(Array)\\n#26 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Route\\\/Router.php(297): call_user_func(Object(OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler), Array)\\n#27 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/base.php(999): OC\\\\Route\\\\Router->match('\\\/core\\\/preview.p...')\\n#28 \\\/var\\\/www\\\/nextcloud\\\/index.php(42): OC::handleRequest()\\n#29 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":115}","userAgent":"Mozilla\/5.0 (Linux; Android 8.1.0; CLT-L29 Build\/HUAWEICLT-L29) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/67.0.3396.87 Mobile Safari\/537.36","version":"13.0.4.0"}
{"reqId":"bkMyP8h8VHrICPT4XcRH","level":4,"time":"2018-06-28T17:00:27+02:00","remoteAddr":"87.122.1.116","user":"Admin","app":"webdav","method":"PUT","url":"\/nextcloud\/remote.php\/dav\/files\/Admin\/Photos\/folder%202015\/IMG_1254.JPG","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'INSERT INTO `oc_file_locks` (`key`,`lock`,`ttl`) SELECT ?,?,? FROM `oc_file_locks` WHERE `key` = ? HAVING COUNT(*) = 0' with params [\\\"files\\\\\\\/f4c1dc3d9755c918967c5e2b9ee69caa\\\", 1, 1530201626, \\\"files\\\\\\\/f4c1dc3d9755c918967c5e2b9ee69caa\\\"]:\\n\\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1015): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'INSERT INTO `oc...', Array)\\n#2 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/DB\\\/Connection.php(216): Doctrine\\\\DBAL\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#3 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/DB\\\/Adapter.php(114): OC\\\\DB\\\\Connection->executeUpdate('INSERT INTO `oc...', Array)\\n#4 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/DB\\\/Connection.php(254): OC\\\\DB\\\\Adapter->insertIfNotExist('*PREFIX*file_lo...', Array, Array)\\n#5 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(119): OC\\\\DB\\\\Connection->insertIfNotExist('*PREFIX*file_lo...', Array, Array)\\n#6 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(164): OC\\\\Lock\\\\DBLockingProvider->initLockField('files\\\/f4c1dc3d9...', 1)\\n#7 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/Storage\\\/Common.php(709): OC\\\\Lock\\\\DBLockingProvider->acquireLock('files\\\/f4c1dc3d9...', 1)\\n#8 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(592): OC\\\\Files\\\\Storage\\\\Common->acquireLock('files\\\/Photos\\\/Th...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#9 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/View.php(1924): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Photos\\\/Th...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#10 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/View.php(2038): OC\\\\Files\\\\View->lockPath('\\\/Photos\\\/Thailan...', 1)\\n#11 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/Node.php(342): OC\\\\Files\\\\View->lockFile('\\\/Photos\\\/Thailan...', 1)\\n#12 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/Directory.php(153): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Node->acquireLock(1)\\n#13 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1096): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory->createFile('IMG_1254.JPG', Resource id #19)\\n#14 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(529): Sabre\\\\DAV\\\\Server->createFile('files\\\/Admin\\\/Pho...', Resource id #19, NULL)\\n#15 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpPut(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#16 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#17 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:PUT', Array)\\n#18 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#19 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/lib\\\/Server.php(287): Sabre\\\\DAV\\\\Server->exec()\\n#20 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(35): OCA\\\\DAV\\\\Server->exec()\\n#21 \\\/var\\\/www\\\/nextcloud\\\/remote.php(164): require_once('\\\/var\\\/www\\\/nextcl...')\\n#22 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":115}","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"13.0.4.0"}
{"reqId":"6VSCqXQEafALuodb0tQV","level":4,"time":"2018-06-28T17:00:28+02:00","remoteAddr":"87.122.1.116","user":"Admin","app":"webdav","method":"PUT","url":"\/nextcloud\/remote.php\/dav\/files\/Admin\/Photos\/folder%202015\/IMG_1252.JPG","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\UniqueConstraintViolationException\",\"Message\":\"An exception occurred while executing 'INSERT INTO `oc_file_locks` (`key`,`lock`,`ttl`) SELECT ?,?,? FROM `oc_file_locks` WHERE `key` = ? HAVING COUNT(*) = 0' with params [\\\"files\\\\\\\/39118080a51ee0741072ba1242157349\\\", 1, 1530201627, \\\"files\\\\\\\/39118080a51ee0741072ba1242157349\\\"]:\\n\\nSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'files\\\/39118080a51ee0741072ba1242157349' for key 'lock_key_index'\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1015): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'INSERT INTO `oc...', Array)\\n#2 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/DB\\\/Connection.php(216): Doctrine\\\\DBAL\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#3 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/DB\\\/Adapter.php(114): OC\\\\DB\\\\Connection->executeUpdate('INSERT INTO `oc...', Array)\\n#4 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/DB\\\/Connection.php(254): OC\\\\DB\\\\Adapter->insertIfNotExist('*PREFIX*file_lo...', Array, Array)\\n#5 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(119): OC\\\\DB\\\\Connection->insertIfNotExist('*PREFIX*file_lo...', Array, Array)\\n#6 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(164): OC\\\\Lock\\\\DBLockingProvider->initLockField('files\\\/39118080a...', 1)\\n#7 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/Storage\\\/Common.php(709): OC\\\\Lock\\\\DBLockingProvider->acquireLock('files\\\/39118080a...', 1)\\n#8 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(592): OC\\\\Files\\\\Storage\\\\Common->acquireLock('files\\\/Admin\\\/fil...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#9 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/View.php(1924): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/Admin\\\/fil...', 1, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#10 \\\/var\\\/www\\\/nextcloud\\\/lib\\\/private\\\/Files\\\/View.php(2038): OC\\\\Files\\\\View->lockPath('\\\/Admin\\\/files', 1)\\n#11 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/Directory.php(154): OC\\\\Files\\\\View->lockFile('\\\/Admin\\\/files\\\/Ph...', 2)\\n#12 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1096): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory->createFile('IMG_1252.JPG', Resource id #19)\\n#13 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(529): Sabre\\\\DAV\\\\Server->createFile('files\\\/Admin\\\/Pho...', Resource id #19, NULL)\\n#14 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpPut(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#15 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#16 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:PUT', Array)\\n#17 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#18 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/lib\\\/Server.php(287): Sabre\\\\DAV\\\\Server->exec()\\n#19 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(35): OCA\\\\DAV\\\\Server->exec()\\n#20 \\\/var\\\/www\\\/nextcloud\\\/remote.php(164): require_once('\\\/var\\\/www\\\/nextcl...')\\n#21 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":66}","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"13.0.4.0"}
{"reqId":"30lmtqurdqvX5GyjnBWA","level":4,"time":"2018-06-28T17:04:33+02:00","remoteAddr":"87.122.1.116","user":"Admin","app":"webdav","method":"PUT","url":"\/nextcloud\/remote.php\/dav\/files\/Admin\/Photos\/folder%202015\/IMG_1288.JPG","message":"Exception: {\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\BadRequest\",\"Message\":\"expected filesize 9694429 got 3801088\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/Directory.php(156): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->put(Resource id #19)\\n#1 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1096): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory->createFile('IMG_1288.JPG', Resource id #19)\\n#2 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(529): Sabre\\\\DAV\\\\Server->createFile('files\\\/Admin\\\/Pho...', Resource id #19, NULL)\\n#3 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpPut(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#4 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#5 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:PUT', Array)\\n#6 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#7 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/lib\\\/Server.php(287): Sabre\\\\DAV\\\\Server->exec()\\n#8 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(35): OCA\\\\DAV\\\\Server->exec()\\n#9 \\\/var\\\/www\\\/nextcloud\\\/remote.php(164): require_once('\\\/var\\\/www\\\/nextcl...')\\n#10 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php\",\"Line\":180}","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"13.0.4.0"}
{"reqId":"gGGNbkVb8ffN6QsUFqGe","level":4,"time":"2018-06-28T17:04:33+02:00","remoteAddr":"87.122.1.116","user":"Admin","app":"webdav","method":"PUT","url":"\/nextcloud\/remote.php\/dav\/files\/Admin\/Photos\/folder%202015\/IMG_1287.JPG","message":"Exception: {\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\BadRequest\",\"Message\":\"expected filesize 9435940 got 3948544\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/Directory.php(156): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->put(Resource id #19)\\n#1 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1096): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory->createFile('IMG_1287.JPG', Resource id #19)\\n#2 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(529): Sabre\\\\DAV\\\\Server->createFile('files\\\/Admin\\\/Pho...', Resource id #19, NULL)\\n#3 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpPut(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#4 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#5 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:PUT', Array)\\n#6 \\\/var\\\/www\\\/nextcloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#7 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/lib\\\/Server.php(287): Sabre\\\\DAV\\\\Server->exec()\\n#8 \\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(35): OCA\\\\DAV\\\\Server->exec()\\n#9 \\\/var\\\/www\\\/nextcloud\\\/remote.php(164): require_once('\\\/var\\\/www\\\/nextcl...')\\n#10 {main}\",\"File\":\"\\\/var\\\/www\\\/nextcloud\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php\",\"Line\":180}","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1) (Nextcloud)","version":"13.0.4.0"}

Hey guys,

I’m still having this issues and was wondering if anyone could help me out to fix this.

Your problem happened after your disconnection. So my first guess would be that your IP address has changed and your dyn-dns-entry was not updated properly. Does access through your local ip (192.168…) work?

Then your logs show a lot of things you could do but if you don’t see your server itself (login page or error page), there is probably a network thing to solve first. For your ssl setup, you can use https://www.ssllabs.com/ssltest/, they test your server from extern for many ssl problems (modern ciphers, certificate chain, …).

Once you can use your Nextcloud, you can set up redis as a filelocking-cache, it takes a lot of load from your database when you move or upload many files and most of the oc_filelocking-errors should disappear. But that is to optimize your setup.

Thanks tflidd for your reply! :slight_smile:

I got a cronjob for a script to update my IP every 5 minutes. So I think, the DynDNS works well.

I’m running nextcloud via vHost on nginx. The configuration of the vHost forwarded my local IP direct to the DynDNS.

I’ve installed redis, so the oc_filelocking-errors disappeared. Thanks for that.

I tried https://www.ssllabs.com/ssltest/. When my Nextcloud is online, I do not get any error messages and everything seems to be fine.

2018/07/15 03:16:09 [error] 1802#1802: *14 access forbidden by rule, client: 122.228.10.51, server: noopiescloud.ddnss.de, request: "GET / HTTP/1.1", host: "89.245.100.103:443"
2018/07/15 05:16:37 [error] 1802#1802: *23 access forbidden by rule, client: 125.212.217.214, server: noopiescloud.ddnss.de, request: "GET / HTTP/1.1", host: "89.245.100.103"
2018/07/15 05:16:38 [crit] 1802#1802: *27 SSL_do_handshake() failed (SSL: error:1417D102:SSL routines:tls_process_client_hello:unsupported protocol) while SSL handshaking, client: 125.212.217.214, server: 0.0.0.0:443
2018/07/15 05:16:39 [crit] 1802#1802: *30 SSL_do_handshake() failed (SSL: error:1417D18C:SSL routines:tls_process_client_hello:version too low) while SSL handshaking, client: 125.212.217.214, server: 0.0.0.0:443
2018/07/15 05:16:40 [crit] 1802#1802: *31 SSL_do_handshake() failed (SSL: error:1417D102:SSL routines:tls_process_client_hello:unsupported protocol) while SSL handshaking, client: 125.212.217.214, server: 0.0.0.0:443
2018/07/15 05:16:41 [error] 1802#1802: *32 open() "/etc/nginx/html/favicon.ico" failed (2: No such file or directory), client: 125.212.217.214, server: noopiescloud.ddnss.de, request: "GET /favicon.ico HTTP/1.1", host: "noopiescloud.ddnss.de"
2018/07/15 05:16:44 [error] 1802#1802: *38 open() "/etc/nginx/html/robots.txt" failed (2: No such file or directory), client: 125.212.217.214, server: noopiescloud.ddnss.de, request: "GET /robots.txt HTTP/1.1", host: "89.245.100.103"
2018/07/15 05:16:45 [error] 1802#1802: *39 open() "/etc/nginx/html/sitemap.xml" failed (2: No such file or directory), client: 125.212.217.214, server: noopiescloud.ddnss.de, request: "GET /sitemap.xml HTTP/1.1", host: "89.245.100.103"
2018/07/15 05:16:46 [error] 1802#1802: *40 open() "/etc/nginx/html/.well-known/security.txt" failed (2: No such file or directory), client: 125.212.217.214, server: noopiescloud.ddnss.de, request: "GET /.well-known/security.txt HTTP/1.1", host: "89.245.100.103"
2018/07/15 05:16:48 [error] 1802#1802: *41 open() "/etc/nginx/html/favicon.ico" failed (2: No such file or directory), client: 125.212.217.214, server: noopiescloud.ddnss.de, request: "GET /favicon.ico HTTP/1.1", host: "89.245.100.103"
2018/07/15 10:45:14 [error] 1802#1802: *221 access forbidden by rule, client: 185.35.63.117, server: noopiescloud.ddnss.de, request: "GET / HTTP/1.1", host: "89.245.100.103"

That’s an output of my nginx error.log from last night. Can’t find any solution on google for that. You’re right that it’s always an issue of my internet connection. But can’t figure out, whats the problem.

Thanks in advance!