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

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

Closed
2 of 3 tasks
hustjieke opened this issue Oct 8, 2022 · 1 comment
Closed
2 of 3 tasks
Assignees
Labels
A-bug Something isn't working

Comments

@hustjieke
Copy link
Collaborator

Have you read the Contributing Guidelines on issues?

Please confirm if bug report does NOT exists already ?

  • I confirm there is no existing issue for this

Describe the problem

When execute concat testcase sql:

use test;
CREATE TABLE `test_case` (
  `id` int DEFAULT NULL,
  `name` text
) ENGINE=TIANMU;
insert into test_case values(1,'test');
insert into test_case (name) values('test2');
insert into test_case values(3,'test3');
select concat(id,name) from test_case;
drop table test_case;

The mysql client return:

mysql> CREATE TABLE `test_case` (
    ->   `id` int DEFAULT NULL,
    ->   `name` text
    -> ) ENGINE=TIANMU;
Query OK, 0 rows affected (0.04 sec)

mysql> insert into test_case values(1,'test');
Query OK, 1 row affected (0.01 sec)

mysql> insert into test_case (name) values('test2');
ERROR 2013 (HY000): Lost connection to MySQL server during query
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/github/stonedb/build/install8/tmp/mysql.sock' (2)
ERROR: 
Can't connect to the server

mysql> insert into test_case (name) values('test2');
No connection. Trying to reconnect...
Connection id:    8
Current database: test

Query OK, 1 row affected (0.07 sec)

mysql> insert into test_case values(3,'test3');
ERROR 2013 (HY000): Lost connection to MySQL server during query
No connection. Trying to reconnect...
Connection id:    8
Current database: test

Query OK, 1 row affected (0.08 sec)

Expected behavior

Execute sql successed.

How To Reproduce

No response

Environment

  1. ubuntu 20
  2. stonedb-8.0-dev

Are you interested in submitting a PR to solve the problem?

  • Yes, I will!
@hustjieke hustjieke added the A-bug Something isn't working label Oct 8, 2022
@hustjieke hustjieke moved this to In Progress in StoneDB for MySQL 8.0 Oct 8, 2022
@hustjieke hustjieke added this to the stonedb_8.0_v1.0.0 milestone Oct 8, 2022
@hustjieke
Copy link
Collaborator Author

Actuall these sqls runned success in mtr.

@lujiashun lujiashun self-assigned this Oct 9, 2022
lujiashun pushed a commit to lujiashun/stonedb that referenced this issue Oct 9, 2022
…rver during query. (stoneatom#650)

[summary]
1 cause reason: tianmu load construct Sql_cmd_load_table itself, but not assign it to thd->lex->m_sql_cmd;
2 thd->lex->m_sql_cmd(nullptr) is used later, so crashed;
lujiashun pushed a commit to lujiashun/stonedb that referenced this issue Oct 9, 2022
…rver during query. (stoneatom#650)

[summary]
1 cause reason: tianmu load construct Sql_cmd_load_table itself, but not assign it to thd->lex->m_sql_cmd;
2 thd->lex->m_sql_cmd(nullptr) is used later, so crashed;
mergify bot pushed a commit that referenced this issue Oct 9, 2022
…rver during query. (#650)

[summary]
1 cause reason: tianmu load construct Sql_cmd_load_table itself, but not assign it to thd->lex->m_sql_cmd;
2 thd->lex->m_sql_cmd(nullptr) is used later, so crashed;
Repository owner moved this from In Progress to Done in StoneDB for MySQL 8.0 Oct 9, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-bug Something isn't working
Projects
Development

No branches or pull requests

2 participants