{"action":"closed","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/12773","labels_url":"https://api.github.com/repos/owncloud/core/issues/12773/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/12773/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/12773/events","html_url":"https://github.com/owncloud/core/issues/12773","id":51660126,"number":12773,"title":"Invalid file timestamps, precondition failed, internal server error...","user":{"login":"ivoras","id":2300424,"avatar_url":"https://avatars.githubusercontent.com/u/2300424?v=3","gravatar_id":"","url":"https://api.github.com/users/ivoras","html_url":"https://github.com/ivoras","followers_url":"https://api.github.com/users/ivoras/followers","following_url":"https://api.github.com/users/ivoras/following{/other_user}","gists_url":"https://api.github.com/users/ivoras/gists{/gist_id}","starred_url":"https://api.github.com/users/ivoras/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ivoras/subscriptions","organizations_url":"https://api.github.com/users/ivoras/orgs","repos_url":"https://api.github.com/users/ivoras/repos","events_url":"https://api.github.com/users/ivoras/events{/privacy}","received_events_url":"https://api.github.com/users/ivoras/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/owncloud/core/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2014-12-11T08:41:58Z","updated_at":"2015-08-21T11:34:53Z","closed_at":"2015-08-21T11:34:53Z","body":"I have been using ownCloud 7.0.1 for several months with desktop sync on Linux, and it suddenly completely broke this week. Any new files I create or update, get completely invalid timestamps (mtime) in the servers data/myusername/files directory, like this:\r\n\r\n```\r\n-rw-r--r-- 1 www-data www-data 20901 -5998838837323147954 myfile.doc\r\n```\r\n\r\nThis timestamp is then persisted in the files_versions directory:\r\n\r\n```\r\n-rw-r--r-- 1 www-data www-data 20901 Dec 11 09:32 myfile.doc.v-5998838837323147954\r\n```\r\n\r\nBut this generates internal server errors as the database cannot accept this large integer:\r\n\r\n```\r\nAn exception occurred while executing 'UPDATE \"oc_filecache\" SET \"mtime\" = ?, \"etag\" = ?, \"storage_mtime\"=? WHERE \"fileid\" = ?': SQLSTATE[22003]: Numeric value out of range: 7 ERROR: value \"-5998838837323147954\" is out of range for type integer\t\r\n```\r\n\r\nThe server is on a completely plain Ubuntu 14.04.1 LTS, 64-bit, the Desktop sync client is on Ubuntu Linux, version 1.6. This started suddenly on ownCloud 7.0.1, but I've now upgraded to 7.0.4 and the problem is still there, without change. I'm using PostgreSQL 9.3.5 for the database.\r\n\r\nThis is not a file system problem, there is no random corruption, and fsck reports no problem. Restarting the server, etc. doesn't help.\r\n\r\nThe invalid timestamps (luckily) do not appear to be mirrored to the client (desktop) side. This is an urgent problem because right now ownCloud is completely broken for me.\r\n\r\nSome more entries from the owncloud log file:\r\n\r\n```\r\n{\"app\":\"remote\",\"message\":\"An exception occurred while executing 'UPDATE \\\"oc_filecache\\\" SET \\\"mtime\\\" = ?, \\\"etag\\\" = ?, \\\"storage_mtime\\\"=? WHERE \\\"fileid\\\" = ?':\\n\\nSQLSTATE[22003]: Numeric value out of range: 7 ERROR:  value \\\"-5998838837323182874\\\" is out of range for type integer\",\"level\":4,\"time\":\"2014-12-10T22:45:01+00:00\"}\r\n{\"app\":\"PHP\",\"message\":\"Session has been closed - no further changes to the session as allowed at \\/srv\\/www\\/owncloud\\/lib\\/private\\/session\\/memory.php#80\",\"level\":3,\"time\":\"2014-12-10T22:45:01+00:00\"}\r\n{\"app\":\"remote\",\"message\":\"An exception occurred while executing 'UPDATE \\\"oc_filecache\\\" SET \\\"mtime\\\" = ?, \\\"etag\\\" = ?, \\\"storage_mtime\\\"=? WHERE \\\"fileid\\\" = ?':\\n\\nSQLSTATE[22003]: Numeric value out of range: 7 ERROR:  value \\\"-5962792448118174277\\\" is out of range for type integer\",\"level\":4,\"time\":\"2014-12-10T22:48:32+00:00\"}\r\n{\"app\":\"PHP\",\"message\":\"Session has been closed - no further changes to the session as allowed at \\/srv\\/www\\/owncloud\\/lib\\/private\\/session\\/memory.php#80\",\"level\":3,\"time\":\"2014-12-10T22:48:32+00:00\"}\r\n{\"app\":\"remote\",\"message\":\"An exception occurred while executing 'UPDATE \\\"oc_filecache\\\" SET \\\"mtime\\\" = ?, \\\"etag\\\" = ?, \\\"storage_mtime\\\"=? WHERE \\\"fileid\\\" = ?':\\n\\nSQLSTATE[22003]: Numeric value out of range: 7 ERROR:  value \\\"-5998838837323182426\\\" is out of range for type integer\",\"level\":4,\"time\":\"2014-12-10T22:52:33+00:00\"}\r\n{\"app\":\"PHP\",\"message\":\"Session has been closed - no further changes to the session as allowed at \\/srv\\/www\\/owncloud\\/lib\\/private\\/session\\/memory.php#80\",\"level\":3,\"time\":\"2014-12-10T22:52:33+00:00\"}\r\n{\"app\":\"core\",\"message\":\"isWebDAVWorking: NO - Reason: [CURL] Error while making request: error:14077410:SSL routines:SSL23_GET_SERVER_HELLO:sslv3 alert handshake failure (error code: 35) (Sabre\\\\DAV\\\\Exception)\",\"level\":2,\"time\":\"2014-12-11T08:13:20+00:00\"}\r\n{\"app\":\"remote\",\"message\":\"An exception occurred while executing 'UPDATE \\\"oc_filecache\\\" SET \\\"mtime\\\" = ?, \\\"etag\\\" = ?, \\\"storage_mtime\\\"=? WHERE \\\"fileid\\\" = ?':\\n\\nSQLSTATE[22003]: Numeric value out of range: 7 ERROR:  value \\\"-5962792448118139888\\\" is out of range for type integer\",\"level\":4,\"time\":\"2014-12-11T08:21:41+00:00\"}\r\n{\"app\":\"remote\",\"message\":\"An exception occurred while executing 'UPDATE \\\"oc_filecache\\\" SET \\\"mtime\\\" = ?, \\\"etag\\\" = ?, \\\"storage_mtime\\\"=? WHERE \\\"fileid\\\" = ?':\\n\\nSQLSTATE[22003]: Numeric value out of range: 7 ERROR:  value \\\"-5962792448118139724\\\" is out of range for type integer\",\"level\":4,\"time\":\"2014-12-11T08:24:25+00:00\"}\r\n{\"app\":\"remote\",\"message\":\"An exception occurred while executing 'UPDATE \\\"oc_filecache\\\" SET \\\"mtime\\\" = ?, \\\"etag\\\" = ?, \\\"storage_mtime\\\"=? WHERE \\\"fileid\\\" = ?':\\n\\nSQLSTATE[22003]: Numeric value out of range: 7 ERROR:  value \\\"-5962792448118139660\\\" is out of range for type integer\",\"level\":4,\"time\":\"2014-12-11T08:25:29+00:00\"}\r\n{\"app\":\"remote\",\"message\":\"An exception occurred while executing 'UPDATE \\\"oc_filecache\\\" SET \\\"mtime\\\" = ?, \\\"etag\\\" = ?, \\\"storage_mtime\\\"=? WHERE \\\"fileid\\\" = ?':\\n\\nSQLSTATE[22003]: Numeric value out of range: 7 ERROR:  value \\\"-5998838837323147954\\\" is out of range for type integer\",\"level\":4,\"time\":\"2014-12-11T08:26:59+00:00\"}\r\n{\"app\":\"remote\",\"message\":\"An exception occurred while executing 'UPDATE \\\"oc_filecache\\\" SET \\\"mtime\\\" = ?, \\\"etag\\\" = ?, \\\"storage_mtime\\\"=? WHERE \\\"fileid\\\" = ?':\\n\\nSQLSTATE[22003]: Numeric value out of range: 7 ERROR:  value \\\"-5998838837323147643\\\" is out of range for type integer\",\"level\":4,\"time\":\"2014-12-11T08:32:11+00:00\"}\r\n```\r\n"}}