{"action":"created","issue":{"url":"https://api.github.com/repos/zendesk/maxwell/issues/223","labels_url":"https://api.github.com/repos/zendesk/maxwell/issues/223/labels{/name}","comments_url":"https://api.github.com/repos/zendesk/maxwell/issues/223/comments","events_url":"https://api.github.com/repos/zendesk/maxwell/issues/223/events","html_url":"https://github.com/zendesk/maxwell/issues/223","id":123594707,"number":223,"title":"Exception: Couldn't find table","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":"open","locked":false,"assignee":null,"milestone":null,"comments":20,"created_at":"2015-12-23T02:55:33Z","updated_at":"2015-12-23T22:03:35Z","closed_at":null,"body":"One of our more active testing environments is getting this error.\r\n\r\n```\r\ncom.zendesk.maxwell.schema.ddl.SchemaSyncError: Couldn't find table: cgt.20151130_TSP_10291__CGPos_0_DF100961B3B9476FB02D495D50C37000\r\n\tat com.zendesk.maxwell.schema.ddl.TableAlter.apply(TableAlter.java:44)\r\n\tat com.zendesk.maxwell.MaxwellReplicator.processQueryEvent(MaxwellReplicator.java:296)\r\n\tat com.zendesk.maxwell.MaxwellReplicator.getRow(MaxwellReplicator.java:268)\r\n\tat com.zendesk.maxwell.MaxwellReplicator.work(MaxwellReplicator.java:89)\r\n\tat com.zendesk.maxwell.RunLoopProcess.runLoop(RunLoopProcess.java:31)\r\n\tat com.zendesk.maxwell.Maxwell.run(Maxwell.java:91)\r\n\tat com.zendesk.maxwell.Maxwell.main(Maxwell.java:97)\r\n2015-12-23T13:50:13,450 INFO  com.zendesk.maxwell.schema.SchemaPosition: Storing final position: null\r\n```\r\n\r\nMy theory was that this table is very short lived (should probably be a temporary table but that cant be helped).\r\n\r\nI tried reproducing this by running these two commands quickly\r\n```\r\nCREATE TABLE `cgt`.`20151130_TSP_10291__CGPos_0_DF100961B3B9476FB02D495D50C37000` (`id` INT (11));\r\n\r\nDROP TABLE `cgt`.`20151130_TSP_10291__CGPos_0_DF100961B3B9476FB02D495D50C37000`;\r\n```\r\n\r\nbut this didn't cause any issues so I guess I'm wrong."},"comment":{"url":"https://api.github.com/repos/zendesk/maxwell/issues/comments/166999351","html_url":"https://github.com/zendesk/maxwell/issues/223#issuecomment-166999351","issue_url":"https://api.github.com/repos/zendesk/maxwell/issues/223","id":166999351,"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-23T22:03:35Z","updated_at":"2015-12-23T22:03:35Z","body":"for my understanding, the three modes are\r\n\r\n- case sensitive on a case sensitive OS  (lower_case_table_names = 0)\r\n- case insensitive on a case sensitive OS (lower_case_table_names = 1)\r\n- case insensitive on a case insensitive OS  (lower_case_table_names doesn't matter)\r\n\r\ncorrect?"}}