{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/16590","labels_url":"https://api.github.com/repos/owncloud/core/issues/16590/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/16590/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/16590/events","html_url":"https://github.com/owncloud/core/issues/16590","id":81480875,"number":16590,"title":"Database Error Leads to Internal Server Error (500)","user":{"login":"marioskourtesis","id":4330999,"avatar_url":"https://avatars.githubusercontent.com/u/4330999?v=3","gravatar_id":"","url":"https://api.github.com/users/marioskourtesis","html_url":"https://github.com/marioskourtesis","followers_url":"https://api.github.com/users/marioskourtesis/followers","following_url":"https://api.github.com/users/marioskourtesis/following{/other_user}","gists_url":"https://api.github.com/users/marioskourtesis/gists{/gist_id}","starred_url":"https://api.github.com/users/marioskourtesis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marioskourtesis/subscriptions","organizations_url":"https://api.github.com/users/marioskourtesis/orgs","repos_url":"https://api.github.com/users/marioskourtesis/repos","events_url":"https://api.github.com/users/marioskourtesis/events{/privacy}","received_events_url":"https://api.github.com/users/marioskourtesis/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/owncloud/core/labels/app:files","name":"app:files","color":"02d7e1"},{"url":"https://api.github.com/repos/owncloud/core/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-05-27T14:53:36Z","updated_at":"2015-06-03T09:17:45Z","closed_at":null,"body":"### Actual behaviour\r\n\r\nThe server is responding Internal Server Error 500. This error is repeated and exhausts the server resources.\r\n\r\n### Server configuration\r\n**Operating system**: CentOS 7\r\n\r\n**Web server:** Apache\r\n\r\n**Database:** MariaDB\r\n\r\n**PHP version:** 5.4.16\r\n\r\n**ownCloud version:** 8.0.3\r\n\r\n**List of activated apps:**\r\nActivity, Deleted files, external storage support, File locking, first run wizard,\r\nmail template editor, pdf viewer, pictures, provisioning Api, share files, text editor,\r\nupdates, versions, video viewer.\r\n\r\n**The content of config/config.php:**\r\n\r\n  'dbtype' => 'mysql',\r\n  'version' => '8.0.3.4',\r\n  'dbname' => 'owncloud',\r\n  'dbhost' => 'localhost',\r\n  'dbtableprefix' => 'oc_',\r\n  'installed' => true,\r\n  'maintenance' => false,\r\n  'loglevel' => 0,\r\n\r\n\r\n**Are you using external storage, if yes which one:** no\r\n\r\n**Are you using encryption:** no\r\n\r\n**Are you using an external user-backend, if yes which one:** webdav\r\n\r\n### Logs\r\n#### Web server error log\r\n\r\nX.X.X.X - user [27/May/2015:16:30:46 +0200] \"PUT /remote.php/webdav/Products/QualityMonitor/XXX/Pilot/Sample%20Documentation/XXX/79159.xhtml HTTP/1.1\" 201 - \"-\" \"Mozilla/5.0 (Macintosh) mirall/1.8.1\"\r\n\r\n#### MariaDB\r\n```\r\nSHOW ENGINE INNODB STATUS\r\n---TRANSACTION A84B7ED, ACTIVE 3 sec starting index read\r\nmysql tables in use 1, locked 1\r\nLOCK WAIT 2 lock struct(s), heap size 488, 1 row lock(s)\r\nMySQL thread id 61, OS thread handle 0x7fb9e85a3700, query id 21659 localhost owncloud Updating\r\nUPDATE `oc_filecache` SET `permissions`='27' WHERE `fileid` = '79919'\r\n------- TRX HAS BEEN WAITING 3 SEC FOR THIS LOCK TO BE GRANTED:\r\nRECORD LOCKS space id 0 page no 14236 n bits 128 index `PRIMARY` of table `owncloud`.`oc_filecache` trx id A84B7ED lock_mode X locks rec but not gap waiting\r\n------------------\r\nTABLE LOCK table `owncloud`.`oc_filecache` trx id A84B7ED lock mode IX\r\nRECORD LOCKS space id 0 page no 14236 n bits 128 index `PRIMARY` of table `owncloud`.`oc_filecache` trx id A84B7ED lock_mode X locks rec but not gap waiting\r\n---TRANSACTION A84B79F, ACTIVE 23 sec\r\n32 lock struct(s), heap size 10680, 1327 row lock(s), undo log entries 1327\r\nMySQL thread id 33, OS thread handle 0x7fb9e8511700, query id 33246 localhost owncloud\r\nTABLE LOCK table `owncloud`.`oc_filecache` trx id A84B79F lock mode IX\r\nRECORD LOCKS space id 0 page no 14236 n bits 128 index `PRIMARY` of table `owncloud`.`oc_filecache` trx id A84B79F lock_mode X locks rec but not gap\r\nRECORD LOCKS space id 0 page no 13675 n bits 136 index `PRIMARY` of table `owncloud`.`oc_filecache` trx id A84B79F lock_mode X locks rec but not gap\r\n\r\n```\r\n#### ownCloud log (data/owncloud.log)\r\n\r\n```{\"reqId\":\"d51760956bb7ad62958978cfadbd8768\",\"remoteAddr\":\"X.X.X.X\",\"app\":\"core\",\"message\":\"Exception while scanning file \\\"QualityMonitor\\/XXX\\/Pilot\\/Sample Documentation\\/XXX\\/76376.xhtml\\\": An exception occurred while executing 'UPDATE `oc_filecache` SET `permissions`=? WHERE `fileid` = ?' with params [27, \\\"79919\\\"]:\\n\\nSQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction\",\"level\":0,\"time\":\"2015-05-27T14:09:11+00:00\",\"method\":\"PROPFIND\",\"url\":\"\\/remote.php\\/webdav\\/Products\\/QualityMonitor\\/XXX\\/Pilot\\/Sample%20Documentation\\/XXX\"}```\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/owncloud/core/issues/comments/108262576","html_url":"https://github.com/owncloud/core/issues/16590#issuecomment-108262576","issue_url":"https://api.github.com/repos/owncloud/core/issues/16590","id":108262576,"user":{"login":"marioskourtesis","id":4330999,"avatar_url":"https://avatars.githubusercontent.com/u/4330999?v=3","gravatar_id":"","url":"https://api.github.com/users/marioskourtesis","html_url":"https://github.com/marioskourtesis","followers_url":"https://api.github.com/users/marioskourtesis/followers","following_url":"https://api.github.com/users/marioskourtesis/following{/other_user}","gists_url":"https://api.github.com/users/marioskourtesis/gists{/gist_id}","starred_url":"https://api.github.com/users/marioskourtesis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marioskourtesis/subscriptions","organizations_url":"https://api.github.com/users/marioskourtesis/orgs","repos_url":"https://api.github.com/users/marioskourtesis/repos","events_url":"https://api.github.com/users/marioskourtesis/events{/privacy}","received_events_url":"https://api.github.com/users/marioskourtesis/received_events","type":"User","site_admin":false},"created_at":"2015-06-03T09:17:45Z","updated_at":"2015-06-03T09:17:45Z","body":"I access the data using the ownCloud client and web interface."}}