{"action":"created","issue":{"url":"https://api.github.com/repos/pingcap/docs-cn/issues/316","repository_url":"https://api.github.com/repos/pingcap/docs-cn","labels_url":"https://api.github.com/repos/pingcap/docs-cn/issues/316/labels{/name}","comments_url":"https://api.github.com/repos/pingcap/docs-cn/issues/316/comments","events_url":"https://api.github.com/repos/pingcap/docs-cn/issues/316/events","html_url":"https://github.com/pingcap/docs-cn/issues/316","id":257330589,"number":316,"title":"loader checker成功 导入失败 (2)","user":{"login":"larry2208","id":7788332,"avatar_url":"https://avatars3.githubusercontent.com/u/7788332?v=4","gravatar_id":"","url":"https://api.github.com/users/larry2208","html_url":"https://github.com/larry2208","followers_url":"https://api.github.com/users/larry2208/followers","following_url":"https://api.github.com/users/larry2208/following{/other_user}","gists_url":"https://api.github.com/users/larry2208/gists{/gist_id}","starred_url":"https://api.github.com/users/larry2208/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/larry2208/subscriptions","organizations_url":"https://api.github.com/users/larry2208/orgs","repos_url":"https://api.github.com/users/larry2208/repos","events_url":"https://api.github.com/users/larry2208/events{/privacy}","received_events_url":"https://api.github.com/users/larry2208/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2017-09-13T10:23:33Z","updated_at":"2017-09-14T01:18:32Z","closed_at":null,"author_association":"NONE","body":"@buggithubs\r\n重新安装后，现在3个tikv server 3个Pd server 导入任然失败\r\n2017/09/13 17:56:04 db.go:99: [warning] transaction execution costs 1.004126 seconds\r\n2017/09/13 17:56:11 db.go:150: [error] exec sqls[[USE soeasy_business; INSERT INTO bid_transfer_all VALUES(50002503073,2027009,1,800524,100058,\"#65#\",\"泰禾集团\",\"XZW1UBOJRH\" UPDATE tidb_loader.checkpoint SET offset=62981093 WHERE id ='24484c' AND filename='soeasy_business.b]] commit failed Error 1105: Information schema is out of date.\r\n2017/09/13 17:56:11 db.go:99: [warning] transaction execution costs 7.121481 seconds\r\n2017/09/13 17:56:11 db.go:67: [warning] exec sql retry 1 - [USE soeasy_business; INSERT INTO bid_transfer_all VALUES(50002503073,2027009,1,800524,100058,\"#65#\",\"泰禾集团\",\"XZW1UBOJRH\" UPDATE tidb_loader.checkpoint SET offset=62981093 WHERE id ='24484c' AND filename='soeasy_business.b]\r\n2017/09/13 17:56:19 db.go:150: [error] exec sqls[[USE soeasy_business; INSERT INTO bid_transfer_all VALUES(50002503073,2027009,1,800524,100058,\"#65#\",\"泰禾集团\",\"XZW1UBOJRH\" UPDATE tidb_loader.checkpoint SET offset=62981093 WHERE id ='24484c' AND filename='soeasy_business.b]] commit failed Error 1105: Information schema is out of date.\r\n2017/09/13 17:56:19 db.go:99: [warning] transaction execution costs 6.043543 seconds\r\n2017/09/13 17:56:19 db.go:67: [warning] exec sql retry 2 - [USE soeasy_business; INSERT INTO bid_transfer_all VALUES(50002503073,2027009,1,800524,100058,\"#65#\",\"泰禾集团\",\"XZW1UBOJRH\" UPDATE tidb_loader.checkpoint SET offset=62981093 WHERE id ='24484c' AND filename='soeasy_business.b]\r\n2017/09/13 17:56:30 db.go:150: [error] exec sqls[[USE soeasy_business; INSERT INTO bid_transfer_all VALUES(50002503073,2027009,1,800524,100058,\"#65#\",\"泰禾集团\",\"XZW1UBOJRH\" UPDATE tidb_loader.checkpoint SET offset=62981093 WHERE id ='24484c' AND filename='soeasy_business.b]] commit failed Error 1105: Information schema is out of date.\r\n这个什么错误？ 有Q 或者微信吗？"},"comment":{"url":"https://api.github.com/repos/pingcap/docs-cn/issues/comments/329341210","html_url":"https://github.com/pingcap/docs-cn/issues/316#issuecomment-329341210","issue_url":"https://api.github.com/repos/pingcap/docs-cn/issues/316","id":329341210,"user":{"login":"larry2208","id":7788332,"avatar_url":"https://avatars3.githubusercontent.com/u/7788332?v=4","gravatar_id":"","url":"https://api.github.com/users/larry2208","html_url":"https://github.com/larry2208","followers_url":"https://api.github.com/users/larry2208/followers","following_url":"https://api.github.com/users/larry2208/following{/other_user}","gists_url":"https://api.github.com/users/larry2208/gists{/gist_id}","starred_url":"https://api.github.com/users/larry2208/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/larry2208/subscriptions","organizations_url":"https://api.github.com/users/larry2208/orgs","repos_url":"https://api.github.com/users/larry2208/repos","events_url":"https://api.github.com/users/larry2208/events{/privacy}","received_events_url":"https://api.github.com/users/larry2208/received_events","type":"User","site_admin":false},"created_at":"2017-09-14T01:18:32Z","updated_at":"2017-09-14T01:18:32Z","author_association":"NONE","body":"@holys 没有，我是单库导出的。 但是我看tidb 初始化完以后，确实有INFORMATION_SCHEMA，PERFORMANCE_SCHEMA 这些库。 我现在是将1T左右的mysql库，导入到tidb ，这个单库，大概300-400G 最大单表是85G 然后各种报错。。"}}
{"actor":{"display_login":"larry2208"}}