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客户端执行SQL查询报Lost connection to MySQL server during query #216

Open
bluegitter opened this issue Dec 29, 2023 · 1 comment

Comments

@bluegitter
Copy link

服务端运行日志

java -jar lealone-6.0.0-SNAPSHOT.jar
Lealone version: 6.0.0-SNAPSHOT
Use default config
Base dir: /Users/yanfei/Downloads/lealone_data
Init storage engines: 3 ms
Init transaction engines: 36 ms
Init sql engines: 4 ms
Init protocol server engines: 10 ms
Init lealone database: 102 ms
TcpServer started, host: 127.0.0.1, port: 9210
MongoServer started, host: 127.0.0.1, port: 27017
MySQLServer started, host: 127.0.0.1, port: 3306
PgServer started, host: 127.0.0.1, port: 5432
Total time: 466 ms (Load config: 3 ms, Init: 220 ms, Start: 243 ms)
Exit with Ctrl+C
Failed to prepare statement: select count() from pet
org.lealone.common.exceptions.JdbcSQLException: Table "PET" not found; SQL statement:
select count(
) from pet [42102-0]
at org.lealone.common.exceptions.DbException.getJdbcSQLException(DbException.java:342)
at org.lealone.common.exceptions.DbException.get(DbException.java:173)
at org.lealone.common.exceptions.DbException.get(DbException.java:150)
at org.lealone.sql.SQLParserBase.readTableOrView(SQLParserBase.java:5361)
at org.lealone.sql.SQLParserBase.readTableFilter(SQLParserBase.java:1797)
at org.lealone.sql.SQLParserBase.parseSelectSimpleFromPart(SQLParserBase.java:1723)
at org.lealone.sql.SQLParserBase.parseSelectSimple(SQLParserBase.java:1539)
at org.lealone.sql.SQLParserBase.parseSelectSub(SQLParserBase.java:1508)
at org.lealone.sql.SQLParserBase.parseSelectUnion(SQLParserBase.java:1478)
at org.lealone.sql.SQLParserBase.parseSelect(SQLParserBase.java:1466)
at org.lealone.sql.SQLParserBase.parseStatement(SQLParserBase.java:455)
at org.lealone.sql.SQLParserBase.parse(SQLParserBase.java:327)
at org.lealone.sql.SQLParserBase.parse(SQLParserBase.java:285)
at org.lealone.sql.SQLParserBase.parse(SQLParserBase.java:1)
at org.lealone.db.session.ServerSession.prepareStatement(ServerSession.java:476)
at org.lealone.plugins.mysql.server.MySQLServerConnection.prepareStatement(MySQLServerConnection.java:186)
at org.lealone.plugins.mysql.server.MySQLServerConnection.executeStatement(MySQLServerConnection.java:205)
at org.lealone.plugins.mysql.server.handler.CommandPacketHandler.handle(CommandPacketHandler.java:37)
at org.lealone.plugins.mysql.server.MySQLServerConnection.handle(MySQLServerConnection.java:388)
at org.lealone.net.nio.NioEventLoop.read(NioEventLoop.java:275)
at org.lealone.net.nio.NioEventLoop.handleSelectedKeys(NioEventLoop.java:492)
at org.lealone.net.NetScheduler.runEventLoop(NetScheduler.java:62)
at org.lealone.server.scheduler.GlobalScheduler.run(GlobalScheduler.java:70)
at java.lang.Thread.run(Thread.java:748)
Failed to prepare statement: select count(*) from pet

客户端日志
mysql --no-beep -h 127.0.0.1 -P 3306 -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.7.35 Lealone-6.0.0-SNAPSHOT Community Server - SSPL

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select count(*) from pet;
ERROR 2013 (HY000): Lost connection to MySQL server during query

@codefollower
Copy link
Member

pet 表不存在

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

No branches or pull requests

2 participants