{"action":"created","issue":{"url":"https://api.github.com/repos/CellProfiler/CellProfiler-Analyst/issues/4","labels_url":"https://api.github.com/repos/CellProfiler/CellProfiler-Analyst/issues/4/labels{/name}","comments_url":"https://api.github.com/repos/CellProfiler/CellProfiler-Analyst/issues/4/comments","events_url":"https://api.github.com/repos/CellProfiler/CellProfiler-Analyst/issues/4/events","html_url":"https://github.com/CellProfiler/CellProfiler-Analyst/issues/4","id":2805957,"number":4,"title":"make training sets saveable even if connection to DB is lost","user":{"login":"thouis","id":473043,"avatar_url":"https://avatars.githubusercontent.com/u/473043?v=3","gravatar_id":"","url":"https://api.github.com/users/thouis","html_url":"https://github.com/thouis","followers_url":"https://api.github.com/users/thouis/followers","following_url":"https://api.github.com/users/thouis/following{/other_user}","gists_url":"https://api.github.com/users/thouis/gists{/gist_id}","starred_url":"https://api.github.com/users/thouis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thouis/subscriptions","organizations_url":"https://api.github.com/users/thouis/orgs","repos_url":"https://api.github.com/users/thouis/repos","events_url":"https://api.github.com/users/thouis/events{/privacy}","received_events_url":"https://api.github.com/users/thouis/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/CellProfiler/CellProfiler-Analyst/labels/Bug","name":"Bug","color":"e10c02"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/CellProfiler/CellProfiler-Analyst/milestones/1","html_url":"https://github.com/CellProfiler/CellProfiler-Analyst/milestones/Functional%20for%20basic%20use","labels_url":"https://api.github.com/repos/CellProfiler/CellProfiler-Analyst/milestones/1/labels","id":251727,"number":1,"title":"Functional for basic use","description":"Things we really need to fix before we feel comfortable using CPA in workshops and promoting it.","creator":{"login":"ljosa","id":197881,"avatar_url":"https://avatars.githubusercontent.com/u/197881?v=3","gravatar_id":"","url":"https://api.github.com/users/ljosa","html_url":"https://github.com/ljosa","followers_url":"https://api.github.com/users/ljosa/followers","following_url":"https://api.github.com/users/ljosa/following{/other_user}","gists_url":"https://api.github.com/users/ljosa/gists{/gist_id}","starred_url":"https://api.github.com/users/ljosa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ljosa/subscriptions","organizations_url":"https://api.github.com/users/ljosa/orgs","repos_url":"https://api.github.com/users/ljosa/repos","events_url":"https://api.github.com/users/ljosa/events{/privacy}","received_events_url":"https://api.github.com/users/ljosa/received_events","type":"User","site_admin":false},"open_issues":10,"closed_issues":11,"state":"open","created_at":"2013-01-25T16:40:18Z","updated_at":"2015-02-24T19:28:06Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2012-01-11T15:54:40Z","updated_at":"2015-08-07T18:36:06Z","closed_at":null,"body":"If the DB goes away, training can hang, and saving the training set can become impossible because it relies on being able to talk to the DB.  All of the information for saving is available outside the DB, so we should make saving more robust."},"comment":{"url":"https://api.github.com/repos/CellProfiler/CellProfiler-Analyst/issues/comments/128790780","html_url":"https://github.com/CellProfiler/CellProfiler-Analyst/issues/4#issuecomment-128790780","issue_url":"https://api.github.com/repos/CellProfiler/CellProfiler-Analyst/issues/4","id":128790780,"user":{"login":"dlogan","id":1225595,"avatar_url":"https://avatars.githubusercontent.com/u/1225595?v=3","gravatar_id":"","url":"https://api.github.com/users/dlogan","html_url":"https://github.com/dlogan","followers_url":"https://api.github.com/users/dlogan/followers","following_url":"https://api.github.com/users/dlogan/following{/other_user}","gists_url":"https://api.github.com/users/dlogan/gists{/gist_id}","starred_url":"https://api.github.com/users/dlogan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dlogan/subscriptions","organizations_url":"https://api.github.com/users/dlogan/orgs","repos_url":"https://api.github.com/users/dlogan/repos","events_url":"https://api.github.com/users/dlogan/events{/privacy}","received_events_url":"https://api.github.com/users/dlogan/received_events","type":"User","site_admin":false},"created_at":"2015-08-07T18:36:06Z","updated_at":"2015-08-07T18:36:06Z","body":"Yes, I hate this error below, which happens if you leave up CPA for a little while and then are unsure whether you have saved the latest training set.  It would be great to make saving training sets not depend on the MySQL connection.\r\n```\r\nAn error occurred in the program:\r\nDBException: ERROR: Database query failed for connection \"MainThread\" and failed to reconnect\r\nQuery was: \"select UPDATE_TIME from INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='AssayDev_CP_only_Seeding_v1_Per_Object' and TABLE_SCHEMA='2007_11_07_Hepatotoxicity_1'\"\r\nFirst exception was: (2006, 'MySQL server has gone away')\r\nSecond exception was: \r\n\r\n\r\nTraceback (most recent call last):\r\n  File \"classifier.pyc\", line 786, in OnSaveTrainingSet\r\n  File \"classifier.pyc\", line 797, in SaveTrainingSet\r\n  File \"classifier.pyc\", line 803, in SaveTrainingSetAs\r\n  File \"trainingset.pyc\", line 47, in Create\r\n  File \"trainingset.pyc\", line 36, in Clear\r\n  File \"trainingset.pyc\", line 227, in clear_if_objects_modified\r\n  File \"dbconnect.pyc\", line 1638, in verify_objects_modify_date_earlier\r\n  File \"dbconnect.pyc\", line 1633, in get_objects_modify_date\r\n  File \"dbconnect.pyc\", line 64, in fn\r\n  File \"dbconnect.pyc\", line 512, in execute\r\n```"}}