{"action":"created","issue":{"url":"https://api.github.com/repos/elabftw/elabftw/issues/623","repository_url":"https://api.github.com/repos/elabftw/elabftw","labels_url":"https://api.github.com/repos/elabftw/elabftw/issues/623/labels{/name}","comments_url":"https://api.github.com/repos/elabftw/elabftw/issues/623/comments","events_url":"https://api.github.com/repos/elabftw/elabftw/issues/623/events","html_url":"https://github.com/elabftw/elabftw/issues/623","id":307956056,"number":623,"title":"Removing revisions for (timestamped) experiments","user":{"login":"lbonnefond","id":24911821,"avatar_url":"https://avatars2.githubusercontent.com/u/24911821?v=4","gravatar_id":"","url":"https://api.github.com/users/lbonnefond","html_url":"https://github.com/lbonnefond","followers_url":"https://api.github.com/users/lbonnefond/followers","following_url":"https://api.github.com/users/lbonnefond/following{/other_user}","gists_url":"https://api.github.com/users/lbonnefond/gists{/gist_id}","starred_url":"https://api.github.com/users/lbonnefond/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lbonnefond/subscriptions","organizations_url":"https://api.github.com/users/lbonnefond/orgs","repos_url":"https://api.github.com/users/lbonnefond/repos","events_url":"https://api.github.com/users/lbonnefond/events{/privacy}","received_events_url":"https://api.github.com/users/lbonnefond/received_events","type":"User","site_admin":false},"labels":[{"id":220330135,"url":"https://api.github.com/repos/elabftw/elabftw/labels/feature%20request","name":"feature request","color":"009800","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2018-03-23T09:29:35Z","updated_at":"2018-03-26T12:16:50Z","closed_at":null,"author_association":"NONE","body":"# Description of the problem\r\n\r\nI found on at least two different instances of an elabftw labnote that most of the database size comes from the 'experiements_revisions' table. In one case the database is 6.3 Mo with 5.5 mo in 'experiments_revisions', and in another case the database is already 2.7 Go with 2.7 Go in the 'experiments_revisions'.\r\n\r\nWhat makes this table so big ? And how to clean it ? Or else, could it be possible to remove those revisions once an experiment is finished or timestamped ?\r\n\r\nBest regards,\r\nLuc\r\n\r\n# Informations\r\n\r\n* Elabftw version (visible in Sysadmin panel) : 1.8.4\r\n* Installation method (git, docker or zip archive) : git\r\n* Operating system + version : Linux spectator 3.2.61-grsec-modsign x86_64\r\n* Browser used (firefox/chrome) : firefox\r\n\r\nFor git/zip installation method:\r\n\r\n* PHP version: 7.1\r\n* MySQL version:  4.7.7\r\n* Webserver (apache/nginx) + version : Apache 2.2.31-5\r\n"},"comment":{"url":"https://api.github.com/repos/elabftw/elabftw/issues/comments/376145597","html_url":"https://github.com/elabftw/elabftw/issues/623#issuecomment-376145597","issue_url":"https://api.github.com/repos/elabftw/elabftw/issues/623","id":376145597,"user":{"login":"lbonnefond","id":24911821,"avatar_url":"https://avatars2.githubusercontent.com/u/24911821?v=4","gravatar_id":"","url":"https://api.github.com/users/lbonnefond","html_url":"https://github.com/lbonnefond","followers_url":"https://api.github.com/users/lbonnefond/followers","following_url":"https://api.github.com/users/lbonnefond/following{/other_user}","gists_url":"https://api.github.com/users/lbonnefond/gists{/gist_id}","starred_url":"https://api.github.com/users/lbonnefond/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lbonnefond/subscriptions","organizations_url":"https://api.github.com/users/lbonnefond/orgs","repos_url":"https://api.github.com/users/lbonnefond/repos","events_url":"https://api.github.com/users/lbonnefond/events{/privacy}","received_events_url":"https://api.github.com/users/lbonnefond/received_events","type":"User","site_admin":false},"created_at":"2018-03-26T12:16:50Z","updated_at":"2018-03-26T12:16:50Z","author_association":"NONE","body":">No there is a second datetime field that cannot be changed. Once created, the original creation date will always stay the same even if user changes the date. \r\n\r\nOk, maybe I did not explained myself properly. \r\n\r\nLet's say you have an experiment named A dating from January 1st 2018 that is not timestamped yet and I want to tamper with the results. I create a new experiment A', choose the date January 1st 2018 and write the fake results modified from A. Then I delete experiment A (if the option is available) and rename experiment A' to A. Thus all traces of the correct original data from experiment A will be lost, No ?"}}
{"actor":{"display_login":"lbonnefond"}}