{"action":"closed","issue":{"url":"https://api.github.com/repos/sipcapture/homer-api/issues/61","labels_url":"https://api.github.com/repos/sipcapture/homer-api/issues/61/labels{/name}","comments_url":"https://api.github.com/repos/sipcapture/homer-api/issues/61/comments","events_url":"https://api.github.com/repos/sipcapture/homer-api/issues/61/events","html_url":"https://github.com/sipcapture/homer-api/issues/61","id":120128560,"number":61,"title":"db_mysql_submit_query(): driver error on query: Table 'homer_data.sip_capture_call_20151203' doesn't exist","user":{"login":"yuvalcnaan","id":16132287,"avatar_url":"https://avatars.githubusercontent.com/u/16132287?v=3","gravatar_id":"","url":"https://api.github.com/users/yuvalcnaan","html_url":"https://github.com/yuvalcnaan","followers_url":"https://api.github.com/users/yuvalcnaan/followers","following_url":"https://api.github.com/users/yuvalcnaan/following{/other_user}","gists_url":"https://api.github.com/users/yuvalcnaan/gists{/gist_id}","starred_url":"https://api.github.com/users/yuvalcnaan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yuvalcnaan/subscriptions","organizations_url":"https://api.github.com/users/yuvalcnaan/orgs","repos_url":"https://api.github.com/users/yuvalcnaan/repos","events_url":"https://api.github.com/users/yuvalcnaan/events{/privacy}","received_events_url":"https://api.github.com/users/yuvalcnaan/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-12-03T09:39:42Z","updated_at":"2015-12-03T09:57:55Z","closed_at":"2015-12-03T09:57:54Z","body":"After few days kamailio can't write to mysql....why ? who is creating new table every day?\r\n\r\nmysql> show tables;\r\n+-----------------------------------+\r\n| Tables_in_homer_data              |\r\n+-----------------------------------+\r\n| logs_capture                      |\r\n| report_capture                    |\r\n| rtcp_capture                      |\r\n| sip_capture_call_20151129         |\r\n| sip_capture_call_20151130         |\r\n| sip_capture_call_20151201         |\r\n| sip_capture_registration_20151129 |\r\n| sip_capture_registration_20151130 |\r\n| sip_capture_registration_20151201 |\r\n| sip_capture_rest_20151129         |\r\n| sip_capture_rest_20151130         |\r\n| sip_capture_rest_20151201         |\r\n+-----------------------------------+\r\n\r\nThanks!\r\n\r\nYuval Cnaan"}}