{"action":"created","issue":{"url":"https://api.github.com/repos/digitalmethodsinitiative/dmi-tcat/issues/191","repository_url":"https://api.github.com/repos/digitalmethodsinitiative/dmi-tcat","labels_url":"https://api.github.com/repos/digitalmethodsinitiative/dmi-tcat/issues/191/labels{/name}","comments_url":"https://api.github.com/repos/digitalmethodsinitiative/dmi-tcat/issues/191/comments","events_url":"https://api.github.com/repos/digitalmethodsinitiative/dmi-tcat/issues/191/events","html_url":"https://github.com/digitalmethodsinitiative/dmi-tcat/issues/191","id":154906286,"number":191,"title":"PHP fatal error","user":{"login":"jaruizso","id":12252768,"avatar_url":"https://avatars.githubusercontent.com/u/12252768?v=3","gravatar_id":"","url":"https://api.github.com/users/jaruizso","html_url":"https://github.com/jaruizso","followers_url":"https://api.github.com/users/jaruizso/followers","following_url":"https://api.github.com/users/jaruizso/following{/other_user}","gists_url":"https://api.github.com/users/jaruizso/gists{/gist_id}","starred_url":"https://api.github.com/users/jaruizso/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jaruizso/subscriptions","organizations_url":"https://api.github.com/users/jaruizso/orgs","repos_url":"https://api.github.com/users/jaruizso/repos","events_url":"https://api.github.com/users/jaruizso/events{/privacy}","received_events_url":"https://api.github.com/users/jaruizso/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/digitalmethodsinitiative/dmi-tcat/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2016-05-15T12:29:29Z","updated_at":"2016-05-17T10:06:57Z","closed_at":null,"body":"Hi there,\r\n\r\nThere is something wrong with the server. I noticed it was not getting data anymore, and I tried to restart the CRON, and also the server, but did not work.\r\n\r\nI haven't touch anything, didn't change anything. Just happened by itself. Is there any solution? At least to download the data?\r\n\r\nadmin@ip-172-31-26-254:/var/www/dmi-tcat/capture/stream$ cd /var/www/dmi-tcat/capture/stream/; sudo -u jaruizso php controller.php\r\nPHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' in /var/www/dmi-tcat/common/functions.php:18\r\nStack trace:\r\n#0 /var/www/dmi-tcat/common/functions.php(18): PDO->__construct('mysql:host=loca...', 'tcatuser', 'jaruizso', Array)\r\n#1 /var/www/dmi-tcat/capture/stream/controller.php(22): dbserver_has_utf8mb4_support()\r\n#2 {main}\r\n  thrown in /var/www/dmi-tcat/common/functions.php on line 18\r\n\r\nI am afraid I might have lost all data....?\r\n"},"comment":{"url":"https://api.github.com/repos/digitalmethodsinitiative/dmi-tcat/issues/comments/219674629","html_url":"https://github.com/digitalmethodsinitiative/dmi-tcat/issues/191#issuecomment-219674629","issue_url":"https://api.github.com/repos/digitalmethodsinitiative/dmi-tcat/issues/191","id":219674629,"user":{"login":"jaruizso","id":12252768,"avatar_url":"https://avatars.githubusercontent.com/u/12252768?v=3","gravatar_id":"","url":"https://api.github.com/users/jaruizso","html_url":"https://github.com/jaruizso","followers_url":"https://api.github.com/users/jaruizso/followers","following_url":"https://api.github.com/users/jaruizso/following{/other_user}","gists_url":"https://api.github.com/users/jaruizso/gists{/gist_id}","starred_url":"https://api.github.com/users/jaruizso/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jaruizso/subscriptions","organizations_url":"https://api.github.com/users/jaruizso/orgs","repos_url":"https://api.github.com/users/jaruizso/repos","events_url":"https://api.github.com/users/jaruizso/events{/privacy}","received_events_url":"https://api.github.com/users/jaruizso/received_events","type":"User","site_admin":false},"created_at":"2016-05-17T10:06:57Z","updated_at":"2016-05-17T10:06:57Z","body":"Still investigating this. It seems I runed out of storage? I am using the Amazon free tier, which means 8Gb for each server:\r\n\r\nadmin@ip-172-31-26-254:/var/lib/mysql$ sudo service mysqld status                                                                                                                                          \r\nâ mysqld.service\r\n   Loaded: not-found (Reason: No such file or directory)\r\n   Active: inactive (dead)\r\nadmin@ip-172-31-26-254:/var/lib/mysql$ sudo service mysql status -l                                                                                                                                        \r\nâ mysql.service - LSB: Start and stop the mysql database server daemon\r\n   Loaded: loaded (/etc/init.d/mysql)\r\n   Active: failed (Result: exit-code) since Tue 2016-05-17 09:53:19 UTC; 28s ago\r\n  Process: 608 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)\r\n\r\nMay 17 09:53:19 ip-172-31-26-254 mysql[608]: /etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full! ... failed!\r\nMay 17 09:53:19 ip-172-31-26-254 /etc/init.d/mysql[626]: ERROR: The partition with /var/lib/mysql is too full!\r\nMay 17 09:53:19 ip-172-31-26-254 systemd[1]: mysql.service: control process exited, code=exited status=1\r\nMay 17 09:53:19 ip-172-31-26-254 systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.\r\nMay 17 09:53:19 ip-172-31-26-254 systemd[1]: Unit mysql.service entered failed state.\r\nadmin@ip-172-31-26-254:/var/lib/mysql$ df -h                                                                                                                                                               \r\nFilesystem      Size  Used Avail Use% Mounted on\r\n/dev/xvda1      7.8G  7.4G     0 100% /\r\nudev             10M     0   10M   0% /dev\r\ntmpfs           200M  4.3M  196M   3% /run\r\ntmpfs           500M     0  500M   0% /dev/shm\r\ntmpfs           5.0M     0  5.0M   0% /run/lock\r\ntmpfs           500M     0  500M   0% /sys/fs/cgroup\r\n"}}