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

mysql client's information_schema read with table names containing - can put the client in a bad state. #5151

Closed
reltuk opened this issue Jan 17, 2023 · 1 comment · Fixed by dolthub/vitess#218
Labels
bug Something isn't working

Comments

@reltuk
Copy link
Contributor

reltuk commented Jan 17, 2023

$ mkdir table_name_test
$ cd table_name_test
$ dolt init
$ dolt sql -q 'create table `a_table-attributes_test` (id int primary key, `key` longtext not null);'
$ dolt sql -q 'create table django_migrations (`id` bigint not null, `app` varchar(255) not null, `name` varchar(255) not null, `applied` datetime not null, primary key (`id`) );'
$ dolt sql-server &
$ mysql -u root -h 127.0.0.1 table_name_test
mysql> show tables;
ERROR 2013 (HY000): Lost connection to MySQL server during query
No connection. Trying to reconnect...
2023-01-17T12:15:40-08:00 INFO [conn 2] ConnectionClosed {}
2023-01-17T12:15:40-08:00 INFO [conn 3] NewConnection {DisableClientMultiStatements=false}
Connection id:    3
Current database: table_name_test

ERROR 2013 (HY000): Lost connection to MySQL server during query
No connection. Trying to reconnect...
2023-01-17T12:15:40-08:00 INFO [conn 4] NewConnection {DisableClientMultiStatements=false}
2023-01-17T12:15:40-08:00 ERROR [no conn] Error writing query error to client 3 (127.0.0.1:58119): write tcp 127.0.0.1:3306->127.0.0.1:58119: write: broken pipe
Write(header) failed
conn 3 {}
2023-01-17T12:15:40-08:00 INFO [conn 3] ConnectionClosed {}
Connection id:    4
Current database: table_name_test

ERROR 2013 (HY000): Lost connection to MySQL server during query

Trace logs from the server show the query against the table with the - running but not returning results before the next query runs:

2023-01-17T12:16:47-08:00 INFO [conn 2] NewConnection {DisableClientMultiStatements=false}
2023-01-17T12:16:47-08:00 DEBUG [conn 2] Starting query {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=show databases}
2023-01-17T12:16:47-08:00 TRACE [conn 2] beginning execution {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=show databases}
2023-01-17T12:16:47-08:00 TRACE [conn 2] beginning new transaction {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=show databases}
2023-01-17T12:16:47-08:00 TRACE [conn 2] spooling result row [TEXT("information_schema")] {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=show databases}
2023-01-17T12:16:47-08:00 TRACE [conn 2] spooling result row [TEXT("mysql")] {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=show databases}
2023-01-17T12:16:47-08:00 TRACE [conn 2] spooling result row [TEXT("table_name_test")] {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=show databases}
2023-01-17T12:16:47-08:00 TRACE [conn 2] committing transaction DoltTransaction {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=show databases}
2023-01-17T12:16:47-08:00 DEBUG [conn 2] Query finished in 0 ms {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=show databases}
2023-01-17T12:16:47-08:00 DEBUG [conn 2] Starting query {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=show tables}
2023-01-17T12:16:47-08:00 TRACE [conn 2] beginning execution {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=show tables}
2023-01-17T12:16:47-08:00 TRACE [conn 2] beginning new transaction {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=show tables}
2023-01-17T12:16:47-08:00 TRACE [conn 2] spooling result row [TEXT("a_table-attributes_test")] {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=show tables}
2023-01-17T12:16:47-08:00 TRACE [conn 2] spooling result row [TEXT("django_migrations")] {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=show tables}
2023-01-17T12:16:47-08:00 TRACE [conn 2] committing transaction DoltTransaction {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=show tables}
2023-01-17T12:16:47-08:00 DEBUG [conn 2] Query finished in 0 ms {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=show tables}
2023-01-17T12:16:47-08:00 DEBUG [conn 2] Starting query {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=SELECT * FROM a_table-attributes_test LIMIT 0;}
ERROR 2013 (HY000): Lost connection to MySQL server during query
No connection. Trying to reconnect...
2023-01-17T12:16:47-08:00 DEBUG [conn 2] Starting query {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=SELECT * FROM django_migrations LIMIT 0;}
2023-01-17T12:16:47-08:00 TRACE [conn 2] beginning execution {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=SELECT * FROM django_migrations LIMIT 0;}
2023-01-17T12:16:47-08:00 TRACE [conn 2] beginning new transaction {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=SELECT * FROM django_migrations LIMIT 0;}
2023-01-17T12:16:47-08:00 TRACE [conn 2] committing transaction DoltTransaction {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=SELECT * FROM django_migrations LIMIT 0;}
2023-01-17T12:16:47-08:00 TRACE [conn 2] returning empty result {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=SELECT * FROM django_migrations LIMIT 0;}
2023-01-17T12:16:47-08:00 DEBUG [conn 2] Query finished in 0 ms {connectTime=2023-01-17T12:16:47-08:00, connectionDb=table_name_test, query=SELECT * FROM django_migrations LIMIT 0;}
@timsehn timsehn added the bug Something isn't working label Jan 17, 2023
@fulghum
Copy link
Contributor

fulghum commented Feb 1, 2023

This seems like it might be the same this issue @zachmu is looking at: #4464

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
3 participants