Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

lost connection when I create partitioned table #7362

Closed
chainkite opened this issue Aug 13, 2018 · 5 comments · Fixed by #7366
Closed

lost connection when I create partitioned table #7362

chainkite opened this issue Aug 13, 2018 · 5 comments · Fixed by #7366
Assignees

Comments

@chainkite
Copy link

Please answer these questions before submitting your issue. Thanks!

  1. What did you do?

I tried to load data into tidb with tidb‘s loader, but it always lost connection while loading metadata sql, without any error information.

Finally I found out the reason... it lost connection while creating partitioned table.

Reproduce the issue:

mysql> create table test_partition(id bigint, name varchar(255), primary key(id)) ENGINE=InnoDB DEFAULT CHARSET=utf8 PARTITION BY RANGE  COLUMNS(id) (PARTITION p1 VALUES LESS THAN (10) ENGINE = InnoDB);
ERROR 2013 (HY000): Lost connection to MySQL server during query
  1. What did you expect to see?
    Detail error message.

  2. What did you see instead?
    Lost connection.

  3. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?
    Release Version: v2.0.4-1-g06a0bf5
    Git Commit Hash: 06a0bf5
    Git Branch: release-2.0
    UTC Build Time: 2018-06-19 05:32:47
    GoVersion: go version go1.10.2 linux/amd64
    TiKV Min Version: 2.0.0-rc.4.1 |

@chainkite chainkite changed the title lost connection when create partitioned table lost connection when I create partitioned table Aug 13, 2018
@winkyao
Copy link
Contributor

winkyao commented Aug 13, 2018

@ciscoxll PTAL

@winkyao winkyao assigned ciscoxll and winkyao and unassigned ciscoxll Aug 13, 2018
@winkyao
Copy link
Contributor

winkyao commented Aug 13, 2018

@ciscoxll I am looking into it.

@tiancaiamao
Copy link
Contributor

It's fixed in #7252
Curiously, this bug should not happen in any released version.
Did you ever upgrade the TiDB from an older version? @chainkite

@winkyao
Copy link
Contributor

winkyao commented Aug 13, 2018

@tiancaiamao No, it is another issue

@tiancaiamao
Copy link
Contributor

@chainkite
May I have your TiDB log please? Maybe you could find it at /data/deploy/tidb/tidb-server.log
Does it contains something like:

2018/08/13 11:07:54.740 tidb.go:72: [error] [ddl] init domain failed json: cannot unmarshal object into Go struct field PartitionDefinition.Name of type string
/media/genius/OS/project/src/github.com/pingcap/tidb/meta/meta.go:377: 
/media/genius/OS/project/src/github.com/pingcap/tidb/domain/domain.go:136: 
/media/genius/OS/project/src/github.com/pingcap/tidb/domain/domain.go:110: 
/media/genius/OS/project/src/github.com/pingcap/tidb/domain/domain.go:304: 
/media/genius/OS/project/src/github.com/pingcap/tidb/domain/domain.go:504

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants