{"action":"created","issue":{"url":"https://api.github.com/repos/zendesk/maxwell/issues/189","labels_url":"https://api.github.com/repos/zendesk/maxwell/issues/189/labels{/name}","comments_url":"https://api.github.com/repos/zendesk/maxwell/issues/189/comments","events_url":"https://api.github.com/repos/zendesk/maxwell/issues/189/events","html_url":"https://github.com/zendesk/maxwell/issues/189","id":121395638,"number":189,"title":"Warning on tables non-included tables","user":{"login":"jpeyper","id":6560018,"avatar_url":"https://avatars.githubusercontent.com/u/6560018?v=3","gravatar_id":"","url":"https://api.github.com/users/jpeyper","html_url":"https://github.com/jpeyper","followers_url":"https://api.github.com/users/jpeyper/followers","following_url":"https://api.github.com/users/jpeyper/following{/other_user}","gists_url":"https://api.github.com/users/jpeyper/gists{/gist_id}","starred_url":"https://api.github.com/users/jpeyper/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jpeyper/subscriptions","organizations_url":"https://api.github.com/users/jpeyper/orgs","repos_url":"https://api.github.com/users/jpeyper/repos","events_url":"https://api.github.com/users/jpeyper/events{/privacy}","received_events_url":"https://api.github.com/users/jpeyper/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-12-10T03:41:40Z","updated_at":"2015-12-11T22:08:49Z","closed_at":"2015-12-11T21:42:23Z","body":"One of my environments is reporting this `WARN` (a lot!).\r\n```\r\n14:31:07,477 WARN  MaxwellReplicator - Unhandled QueryEvent inside transaction: QueryEvent[header=BinlogEventV4HeaderImpl[timestamp=1449710974000,eventType=2,serverId=441,eventLength=279,nextPosition=219695949,flags=0,timestampOfReceipt=1449718267477],threadId=4,elapsedTime=0,databaseNameLength=6,errorCode=0,statusVariablesLength=35,statusVariables=[QFlags2Code[flags=0], QSQLModeCode[sqlMode=2097152], QCatalogNzCode[catalogName=std], QCharsetCode[characterSetClient=8,collationConnection=8,collationServer=8], QUpdatedDBNames[accessedDbCount=1,accessedDbs=[Lcom.google.code.or.common.glossary.column.StringColumn;@2da0770]],databaseName=merlyn,sql=INSERT INTO merlyn.system_variables(project, var_name, var_value) VALUES('xxxxx', 'yyyyy', 'zzzzz') ON DUPLICATE KEY UPDATE var_value= 'zzzzz']\r\n```\r\n\r\nMy config file is setup to include specify databases (`include_dbs`) and tables (`include_tables`). Both `merlyn` and `system_variables` are not included.\r\n\r\nIs there any reason that Maxwell needs to care about tables and databases that I'm not tracking events for?\r\n\r\nAnd secondly, if I got this `WARN` on a table that I was tracking, what does it actually mean? have I missed a change? What is causing this `WARN`?"},"comment":{"url":"https://api.github.com/repos/zendesk/maxwell/issues/comments/164062795","html_url":"https://github.com/zendesk/maxwell/issues/189#issuecomment-164062795","issue_url":"https://api.github.com/repos/zendesk/maxwell/issues/189","id":164062795,"user":{"login":"jpeyper","id":6560018,"avatar_url":"https://avatars.githubusercontent.com/u/6560018?v=3","gravatar_id":"","url":"https://api.github.com/users/jpeyper","html_url":"https://github.com/jpeyper","followers_url":"https://api.github.com/users/jpeyper/followers","following_url":"https://api.github.com/users/jpeyper/following{/other_user}","gists_url":"https://api.github.com/users/jpeyper/gists{/gist_id}","starred_url":"https://api.github.com/users/jpeyper/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jpeyper/subscriptions","organizations_url":"https://api.github.com/users/jpeyper/orgs","repos_url":"https://api.github.com/users/jpeyper/repos","events_url":"https://api.github.com/users/jpeyper/events{/privacy}","received_events_url":"https://api.github.com/users/jpeyper/received_events","type":"User","site_admin":false},"created_at":"2015-12-11T22:08:49Z","updated_at":"2015-12-11T22:08:49Z","body":"That fine, our dba's theory is that the dB was set to mixed mode,  and Maxwell's position in the log was set behind where the switch to row was made (not sure how it was set there, but anyway). \r\n\r\nAs it was a testing environment we deleted the existing logs and Maxwell schema and we having seen any issues since. "}}