{"action":"closed","issue":{"url":"https://api.github.com/repos/echothrust/echofish/issues/15","labels_url":"https://api.github.com/repos/echothrust/echofish/issues/15/labels{/name}","comments_url":"https://api.github.com/repos/echothrust/echofish/issues/15/comments","events_url":"https://api.github.com/repos/echothrust/echofish/issues/15/events","html_url":"https://github.com/echothrust/echofish/issues/15","id":53319329,"number":15,"title":"mysqld floods log with warnings after starting echofish","user":{"login":"grektum","id":10384908,"avatar_url":"https://avatars.githubusercontent.com/u/10384908?v=3","gravatar_id":"","url":"https://api.github.com/users/grektum","html_url":"https://github.com/grektum","followers_url":"https://api.github.com/users/grektum/followers","following_url":"https://api.github.com/users/grektum/following{/other_user}","gists_url":"https://api.github.com/users/grektum/gists{/gist_id}","starred_url":"https://api.github.com/users/grektum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/grektum/subscriptions","organizations_url":"https://api.github.com/users/grektum/orgs","repos_url":"https://api.github.com/users/grektum/repos","events_url":"https://api.github.com/users/grektum/events{/privacy}","received_events_url":"https://api.github.com/users/grektum/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"proditis","id":4373752,"avatar_url":"https://avatars.githubusercontent.com/u/4373752?v=3","gravatar_id":"","url":"https://api.github.com/users/proditis","html_url":"https://github.com/proditis","followers_url":"https://api.github.com/users/proditis/followers","following_url":"https://api.github.com/users/proditis/following{/other_user}","gists_url":"https://api.github.com/users/proditis/gists{/gist_id}","starred_url":"https://api.github.com/users/proditis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/proditis/subscriptions","organizations_url":"https://api.github.com/users/proditis/orgs","repos_url":"https://api.github.com/users/proditis/repos","events_url":"https://api.github.com/users/proditis/events{/privacy}","received_events_url":"https://api.github.com/users/proditis/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2015-01-03T23:52:01Z","updated_at":"2015-01-12T11:30:52Z","closed_at":"2015-01-12T11:30:52Z","body":"I just installed echofish following instructions in the INSTALL.md file (skipped the mail configuration as this is not needed for now) and upon starting it, mariadb started flooding logs with warnings.\r\n\r\n```\r\nmysqld: 150104  0:22:03 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly. Statement: INSERT INTO archive_bh (host, facility, priority, level, received_ts, program, msg,pid,tag) VALUES ( '127.0.0.1', '5', '6','6', '20150104002203', TRIM('rsyslogd'), TRIM(' [origin software=\"rsyslogd\" swVersion=\"8.6.0\" x-pid=\"8021\" x-info=\"http://www.rsyslog.com\"] start'),'', 'rsyslogd:' )\r\n```\r\n\r\n```\r\nmysqld: 150104  0:22:03 [Note] Suppressing warnings of type 'Statement is unsafe because it uses a system function that may return a different value on the slave.' for up to 300 seconds because of flooding\r\nmysqld: 150104  0:22:03 [Note] Suppressing warnings of type 'Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them.' for up to 300 seconds because of flooding\r\nmysqld: 150104  0:22:03 [Note] Suppressing warnings of type 'Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave.' for up to 300 seconds because of flooding\r\n```"}}