{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/26395","repository_url":"https://api.github.com/repos/owncloud/core","labels_url":"https://api.github.com/repos/owncloud/core/issues/26395/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/26395/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/26395/events","html_url":"https://github.com/owncloud/core/issues/26395","id":183480572,"number":26395,"title":"negative size of root folder in storage","user":{"login":"PVince81","id":277525,"avatar_url":"https://avatars.githubusercontent.com/u/277525?v=3","gravatar_id":"","url":"https://api.github.com/users/PVince81","html_url":"https://github.com/PVince81","followers_url":"https://api.github.com/users/PVince81/followers","following_url":"https://api.github.com/users/PVince81/following{/other_user}","gists_url":"https://api.github.com/users/PVince81/gists{/gist_id}","starred_url":"https://api.github.com/users/PVince81/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PVince81/subscriptions","organizations_url":"https://api.github.com/users/PVince81/orgs","repos_url":"https://api.github.com/users/PVince81/repos","events_url":"https://api.github.com/users/PVince81/events{/privacy}","received_events_url":"https://api.github.com/users/PVince81/received_events","type":"User","site_admin":false},"labels":[{"id":12406434,"url":"https://api.github.com/repos/owncloud/core/labels/bug","name":"bug","color":"fc2929","default":true},{"id":287820798,"url":"https://api.github.com/repos/owncloud/core/labels/comp:filesystem","name":"comp:filesystem","color":"d4c5f9","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/owncloud/core/milestones/100","html_url":"https://github.com/owncloud/core/milestones/9.1.3","labels_url":"https://api.github.com/repos/owncloud/core/milestones/100/labels","id":2018752,"number":100,"title":"9.1.3","description":null,"creator":{"login":"PVince81","id":277525,"avatar_url":"https://avatars.githubusercontent.com/u/277525?v=3","gravatar_id":"","url":"https://api.github.com/users/PVince81","html_url":"https://github.com/PVince81","followers_url":"https://api.github.com/users/PVince81/followers","following_url":"https://api.github.com/users/PVince81/following{/other_user}","gists_url":"https://api.github.com/users/PVince81/gists{/gist_id}","starred_url":"https://api.github.com/users/PVince81/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PVince81/subscriptions","organizations_url":"https://api.github.com/users/PVince81/orgs","repos_url":"https://api.github.com/users/PVince81/repos","events_url":"https://api.github.com/users/PVince81/events{/privacy}","received_events_url":"https://api.github.com/users/PVince81/received_events","type":"User","site_admin":false},"open_issues":148,"closed_issues":44,"state":"open","created_at":"2016-09-21T10:34:59Z","updated_at":"2016-11-30T12:07:01Z","due_on":null,"closed_at":null},"comments":1,"created_at":"2016-10-17T17:41:49Z","updated_at":"2016-11-30T12:12:18Z","closed_at":null,"body":"Spotted this:\n\n```\nMariaDB [owncloudtest2]> select path,size from oc_filecache where storage=324 order by path;\n+-------------------------------------------------+-----------+\n| path                                            | size      |\n+-------------------------------------------------+-----------+\n|                                                 | -26611575 |\n| cache                                           |         0 |\n| files                                           |  87134773 |\n| files/XYZ                       |  27125605 |\n| files/XYZ/Image1.gif            |    433043 |\n```\n\nIt is likely that the new \"clever\" algorithm that adjusts the size in batch didn't do it properly for the root.\n\nWhile this might not cause any harm, there is a likely chance that the background scanner will interpret that this storage needs rescanning, or at least its root.\n\nNot sure how to reproduce, spotted on a DB dump of a live system.\n"},"comment":{"url":"https://api.github.com/repos/owncloud/core/issues/comments/263859030","html_url":"https://github.com/owncloud/core/issues/26395#issuecomment-263859030","issue_url":"https://api.github.com/repos/owncloud/core/issues/26395","id":263859030,"user":{"login":"PVince81","id":277525,"avatar_url":"https://avatars.githubusercontent.com/u/277525?v=3","gravatar_id":"","url":"https://api.github.com/users/PVince81","html_url":"https://github.com/PVince81","followers_url":"https://api.github.com/users/PVince81/followers","following_url":"https://api.github.com/users/PVince81/following{/other_user}","gists_url":"https://api.github.com/users/PVince81/gists{/gist_id}","starred_url":"https://api.github.com/users/PVince81/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PVince81/subscriptions","organizations_url":"https://api.github.com/users/PVince81/orgs","repos_url":"https://api.github.com/users/PVince81/repos","events_url":"https://api.github.com/users/PVince81/events{/privacy}","received_events_url":"https://api.github.com/users/PVince81/received_events","type":"User","site_admin":false},"created_at":"2016-11-30T12:12:18Z","updated_at":"2016-11-30T12:12:18Z","body":"Also spotted on my private instance:\r\n```\r\nMariaDB [owncloud]> select * from oc_filecache where name='';\r\n+--------+---------+------+----------------------------------+--------+------+----------+----------+------------+------------+-----------+---------------+------------------+---------------+-------------+----------+\r\n| fileid | storage | path | path_hash                        | parent | name | mimetype | mimepart | size       | mtime      | encrypted | etag          | unencrypted_size | storage_mtime | permissions | checksum |\r\n+--------+---------+------+----------------------------------+--------+------+----------+----------+------------+------------+-----------+---------------+------------------+---------------+-------------+----------+\r\n|    531 |       1 |      | d41d8cd98f00b204e9800998ecf8427e |     -1 |      |        1 |        2 | -145950780 | 1480507203 |         0 | 583ebf43a7a1e |            65005 |    1478683317 |          23 | NULL     |\r\n|    665 |       2 |      | d41d8cd98f00b204e9800998ecf8427e |     -1 |      |        1 |        2 | 1688006171 | 1480439498 |         0 | 583db6ca31239 |        525212494 |    1480191137 |          23 | NULL     |\r\n|    859 |       3 |      | d41d8cd98f00b204e9800998ecf8427e |     -1 |      |        1 |        2 |          0 | 1381140058 |         0 | 5252865e65ec0 |                0 |             0 |          23 | NULL     |\r\n|   1068 |       4 |      | d41d8cd98f00b204e9800998ecf8427e |     -1 |      |        1 |        2 |          0 | 1382875647 |         0 | 526d01ffcdfea |                0 |    1382875647 |          23 | NULL     |\r\n|  20795 |       5 |      | d41d8cd98f00b204e9800998ecf8427e |     -1 |      |        1 |        2 |   93222433 | 1456996136 |         0 | 56d7ff282b335 |                0 |    1456996136 |          31 | NULL     |\r\n+--------+---------+------+----------------------------------+--------+------+----------+----------+------------+------------+-----------+---------------+------------------+---------------+-------------+----------+\r\n```\r\n\r\nUsually OC doesn't care about the size of the root of the home storage and only cares about the size of \"files\".\r\n\r\nSetting to medium for now."}}
{"actor":{"display_login":"PVince81"}}