{"action":"created","issue":{"url":"https://api.github.com/repos/wso2/docker-apim/issues/111","repository_url":"https://api.github.com/repos/wso2/docker-apim","labels_url":"https://api.github.com/repos/wso2/docker-apim/issues/111/labels{/name}","comments_url":"https://api.github.com/repos/wso2/docker-apim/issues/111/comments","events_url":"https://api.github.com/repos/wso2/docker-apim/issues/111/events","html_url":"https://github.com/wso2/docker-apim/issues/111","id":308605779,"number":111,"title":"stats_db.API_REQUEST_SUMMARY not being created on startup","user":{"login":"simontrimboy","id":3989961,"avatar_url":"https://avatars1.githubusercontent.com/u/3989961?v=4","gravatar_id":"","url":"https://api.github.com/users/simontrimboy","html_url":"https://github.com/simontrimboy","followers_url":"https://api.github.com/users/simontrimboy/followers","following_url":"https://api.github.com/users/simontrimboy/following{/other_user}","gists_url":"https://api.github.com/users/simontrimboy/gists{/gist_id}","starred_url":"https://api.github.com/users/simontrimboy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/simontrimboy/subscriptions","organizations_url":"https://api.github.com/users/simontrimboy/orgs","repos_url":"https://api.github.com/users/simontrimboy/repos","events_url":"https://api.github.com/users/simontrimboy/events{/privacy}","received_events_url":"https://api.github.com/users/simontrimboy/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-03-26T14:51:15Z","updated_at":"2018-03-27T01:00:02Z","closed_at":null,"author_association":"NONE","body":"**Description:**\r\nThe stats_db summary table/s are not being created immediately on startup; resulting in the following exception when trying to access API analytics.\r\n\r\n```\r\nERROR - APIUsageStatisticsRdbmsClientImpl Error occurred while checking existence of the table:API_REQUEST_SUMMARY\r\ncom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'stats_db.API_REQUEST_SUMMARY' doesn't exist\r\n```\r\n\r\nI have noticed the issue can be resolved by adding an additional docker compose link from the api-manager service to mysql.\r\n\r\n```\r\nversion: '2.3'\r\n...\r\n  api-manager:\r\n  ...\r\n    links:\r\n      - mysql\r\n```"},"comment":{"url":"https://api.github.com/repos/wso2/docker-apim/issues/comments/376360586","html_url":"https://github.com/wso2/docker-apim/issues/111#issuecomment-376360586","issue_url":"https://api.github.com/repos/wso2/docker-apim/issues/111","id":376360586,"user":{"login":"DilanUA","id":8347682,"avatar_url":"https://avatars3.githubusercontent.com/u/8347682?v=4","gravatar_id":"","url":"https://api.github.com/users/DilanUA","html_url":"https://github.com/DilanUA","followers_url":"https://api.github.com/users/DilanUA/followers","following_url":"https://api.github.com/users/DilanUA/following{/other_user}","gists_url":"https://api.github.com/users/DilanUA/gists{/gist_id}","starred_url":"https://api.github.com/users/DilanUA/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DilanUA/subscriptions","organizations_url":"https://api.github.com/users/DilanUA/orgs","repos_url":"https://api.github.com/users/DilanUA/repos","events_url":"https://api.github.com/users/DilanUA/events{/privacy}","received_events_url":"https://api.github.com/users/DilanUA/received_events","type":"User","site_admin":false},"created_at":"2018-03-27T01:00:02Z","updated_at":"2018-03-27T01:00:02Z","author_association":"CONTRIBUTOR","body":"@simontrimboy Thanks for reporting. We are currently looking into this. Will reply to you shortly."}}
{"actor":{"display_login":"DilanUA"}}