{"action":"created","issue":{"url":"https://api.github.com/repos/pingcap/tidb/issues/8219","repository_url":"https://api.github.com/repos/pingcap/tidb","labels_url":"https://api.github.com/repos/pingcap/tidb/issues/8219/labels{/name}","comments_url":"https://api.github.com/repos/pingcap/tidb/issues/8219/comments","events_url":"https://api.github.com/repos/pingcap/tidb/issues/8219/events","html_url":"https://github.com/pingcap/tidb/issues/8219","id":378221152,"node_id":"MDU6SXNzdWUzNzgyMjExNTI=","number":8219,"title":"Create table alway failed from syncer(mysql to proxysql + tidb) ","user":{"login":"CrazyNash","id":39256431,"node_id":"MDQ6VXNlcjM5MjU2NDMx","avatar_url":"https://avatars1.githubusercontent.com/u/39256431?v=4","gravatar_id":"","url":"https://api.github.com/users/CrazyNash","html_url":"https://github.com/CrazyNash","followers_url":"https://api.github.com/users/CrazyNash/followers","following_url":"https://api.github.com/users/CrazyNash/following{/other_user}","gists_url":"https://api.github.com/users/CrazyNash/gists{/gist_id}","starred_url":"https://api.github.com/users/CrazyNash/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CrazyNash/subscriptions","organizations_url":"https://api.github.com/users/CrazyNash/orgs","repos_url":"https://api.github.com/users/CrazyNash/repos","events_url":"https://api.github.com/users/CrazyNash/events{/privacy}","received_events_url":"https://api.github.com/users/CrazyNash/received_events","type":"User","site_admin":false},"labels":[{"id":1043169315,"node_id":"MDU6TGFiZWwxMDQzMTY5MzE1","url":"https://api.github.com/repos/pingcap/tidb/labels/component/syncer","name":"component/syncer","color":"ccbf0e","default":false},{"id":256872086,"node_id":"MDU6TGFiZWwyNTY4NzIwODY=","url":"https://api.github.com/repos/pingcap/tidb/labels/type/bug","name":"type/bug","color":"fc2929","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-11-07T10:09:55Z","updated_at":"2018-11-07T11:44:30Z","closed_at":null,"author_association":"NONE","body":"## Bug Report\r\n\r\nPlease answer these questions before submitting your issue. Thanks!\r\n\r\n1. What did you do?\r\nIf possible, provide a recipe for reproducing the error.\r\n\r\nSync data from mysql to tidb. Proxysql was set upon tidb. \r\n\r\nsyncer failed for \r\n```\r\n2018/11/07 17:32:51 db.go:94: [warning] sql stmt_exec retry 16: [USE `nash`; CREATE TABLE `t_test_test_test_test_test` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `black_api_name` varchar(64) NOT NULL DEFAULT '',\r\n  `create_time` int(10) NOT NULL DEFAULT '0',\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;] - [[]]\r\n2018/11/07 17:33:04 db.go:121: [error] exec sqls[[USE `nash`; CREATE TABLE `t_test_test_test_test_test` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `black_api_name` varchar(64) NOT NULL DEFAULT '',\r\n  `create_time` int(10) NOT NULL DEFAULT '0',\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;]] begin failed Error 1105: line 1 column 10 near \"`; CREATE TABLE `t_test_test_test_test_test` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `black_api_name` varchar(64) NOT NULL DEFAULT '',\r\n  `create_time` int(10) NOT NULL DEFAULT '0',\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8`\" (total length 253)\r\n```\r\ntidb error log\r\n\r\n```\r\n2018/11/07 17:36:22.038 session.go:808: [warning] [con:154] parse error:\r\nline 1 column 10 near \"`; CREATE TABLE `t_test_test_test_test_test` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `black_api_name` varchar(64) NOT NULL DEFAULT '',\r\n  `create_time` int(10) NOT NULL DEFAULT '0',\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8`\" (total length 253)\r\nuse ``nash`; CREATE TABLE `t_test_test_test_test_test` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `black_api_name` varchar(64) NOT NULL DEFAULT '',\r\n  `create_time` int(10) NOT NULL DEFAULT '0',\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8`\r\n```\r\n\r\n2. What did you expect to see?\r\n\r\naction success\r\n\r\n3. What did you see instead?\r\n\r\nfailure\r\n\r\n\r\n4. What version of TiDB are you using (`tidb-server -V` or run `select tidb_version();` on TiDB)?\r\n\r\n2.0.4\r\n\r\n\r\nSeems like interop issue between syncer and proxysql. When I run syncer without proxysql, the work completed successfully. the log looks like\r\n\r\n```\r\n2018/11/07 17:58:17.536 session.go:1399: [info] [CRUCIAL OPERATION] [con:199]  CREATE TABLE `t_test_test_test_test_test` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `black_api_name` varchar(64) NOT NULL DEFAULT '',\r\n  `create_time` int(10) NOT NULL DEFAULT '0',\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8; (by root@10.23.13.27).\r\n2018/11/07 17:58:17.545 session.go:976: [info] [con:199] NewTxn() inside a transaction auto commit: 404117178945372164\r\n2018/11/07 17:58:17.555 ddl.go:436: [info] [ddl] start DDL job ID:116, Type:create table, State:none, SchemaState:none, SchemaID:113, TableID:115, RowCount:0, ArgLen:1, start time: 2018-11-07 \r\n\r\n17:58:17.515 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, Query: CREATE TABLE `t_test_test_test_test_test` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `black_api_name` varchar(64) NOT NULL DEFAULT '',\r\n  `create_time` int(10) NOT NULL DEFAULT '0',\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n2018/11/07 17:58:18.091 domain.go:102: [info] [ddl] diff load InfoSchema from version 47 to 48, in 2.39617ms\r\n2018/11/07 17:58:18.557 ddl.go:468: [info] [ddl] DDL job 116 is finished\r\n2018/11/07 17:58:18.557 domain.go:412: [info] [ddl] on DDL change, must reload\r\n2018/11/07 17:58:18.559 adapter.go:353: [warning] [SLOW_QUERY] cost_time:1.022094042s succ:true connection_id:199 txn_start_ts:404117178945372167 database:nash table_ids:[] index_ids:[] sql: CREATE \r\n\r\nTABLE `t_test_test_test_test_test` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `black_api_name` varchar(64) NOT NULL DEFAULT '',\r\n  `create_time` int(10) NOT NULL DEFAULT '0',\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n2018/11/07 17:58:33.673 server.go:303: [info] [con:200] new connection 10.23.67.26:41522\r\n2018/11/07 17:58:33.674 server.go:305: [info] [con:200] close connection\r\n2018/11/07 17:58:34.284 server.go:303: [info] [con:201] new connection 10.23.189.166:47574\r\n2018/11/07 17:58:34.284 server.go:305: [info] [con:201] close connection\r\n\r\n```"},"comment":{"url":"https://api.github.com/repos/pingcap/tidb/issues/comments/436597300","html_url":"https://github.com/pingcap/tidb/issues/8219#issuecomment-436597300","issue_url":"https://api.github.com/repos/pingcap/tidb/issues/8219","id":436597300,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNjU5NzMwMA==","user":{"login":"CrazyNash","id":39256431,"node_id":"MDQ6VXNlcjM5MjU2NDMx","avatar_url":"https://avatars1.githubusercontent.com/u/39256431?v=4","gravatar_id":"","url":"https://api.github.com/users/CrazyNash","html_url":"https://github.com/CrazyNash","followers_url":"https://api.github.com/users/CrazyNash/followers","following_url":"https://api.github.com/users/CrazyNash/following{/other_user}","gists_url":"https://api.github.com/users/CrazyNash/gists{/gist_id}","starred_url":"https://api.github.com/users/CrazyNash/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CrazyNash/subscriptions","organizations_url":"https://api.github.com/users/CrazyNash/orgs","repos_url":"https://api.github.com/users/CrazyNash/repos","events_url":"https://api.github.com/users/CrazyNash/events{/privacy}","received_events_url":"https://api.github.com/users/CrazyNash/received_events","type":"User","site_admin":false},"created_at":"2018-11-07T11:44:30Z","updated_at":"2018-11-07T11:44:30Z","author_association":"NONE","body":"@csuzhangxc  \r\n\r\n```\r\ncreate database nash;\r\n\r\nuse nash;\r\n\r\nCREATE TABLE `t_test_test_test_test_test` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `black_api_name` varchar(64) NOT NULL DEFAULT '',\r\n  `create_time` int(10) NOT NULL DEFAULT '0',\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\n```"}}
{"actor":{"display_login":"CrazyNash"}}