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

Unknown database 'information_schema' #7146

Closed
mavenraven opened this issue Dec 9, 2020 · 0 comments · Fixed by #7150
Closed

Unknown database 'information_schema' #7146

mavenraven opened this issue Dec 9, 2020 · 0 comments · Fixed by #7150

Comments

@mavenraven
Copy link
Contributor

Reproduction Steps

When trying to run skeema init against vtgate, I get the following error:

ERROR 1049 (42000): vtgate: http://user-ThinkPad-X1-Carbon-7th:9997/: Unknown database 'information_schema' (errno 1049) (sqlstate 42000)

This is because vtgate is looking for a keyspace in the vschema named information_schema:

https://github.com/vitessio/vitess/blob/2eb5d64406a438467f17710e822d2852b37526ba/go/vt/vtgate/vcursor_impl.go#L454

and the fact the skeema wants to connect directly to information_schema:

https://github.com/skeema/skeema/blob/c3469f0286dd269ac43158befc39927f9fc061a8/vendor/github.com/skeema/tengo/instance.go#L783

The minimal way to reproduce this is:

mysql --host 127.0.0.1 --port 10000 information_schema

where 10000 is the port vtgate is listening on.

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

Successfully merging a pull request may close this issue.

4 participants