Open
Description
OS: MacOS Monterey 12.7.6
JDK:java 21.0.4
MySQL on the MacOS:8.0.3
I followed your documention,started the DB server first,then create mysql plugin,start plugin,it's all goning well,but when I typed
mysql --no-beep -h 127.0.0.1 -P 3307 -u root
(I changed 3306 to 3307 because the local mysql service owned port 3306), I could go into mysql terminal,but at that time , lealone server has error log,you can see pics below
step 1

step 2

step 3

step 4

here is full server log
Failed to prepare statement: select $$
com.lealone.common.exceptions.JdbcSQLException: Syntax error in SQL statement "select [*]$$"; SQL statement:
select $$ [42000-1]
at com.lealone.common.exceptions.DbException.getJdbcSQLException(DbException.java:343)
at com.lealone.common.exceptions.DbException.get(DbException.java:174)
at com.lealone.common.exceptions.DbException.get(DbException.java:151)
at com.lealone.common.exceptions.DbException.getSyntaxError(DbException.java:186)
at com.lealone.sql.SQLParserBase.getSyntaxError(SQLParserBase.java:548)
at com.lealone.sql.SQLParserBase.checkRunOver(SQLParserBase.java:3619)
at com.lealone.sql.SQLParserBase.initialize(SQLParserBase.java:3473)
at com.lealone.sql.SQLParserBase.parse(SQLParserBase.java:314)
at com.lealone.sql.SQLParserBase.parse(SQLParserBase.java:289)
at com.lealone.sql.SQLParserBase.parse(SQLParserBase.java:1)
at com.lealone.db.session.ServerSession.prepareStatement(ServerSession.java:479)
at com.lealone.plugins.mysql.server.MySQLServerConnection.prepareStatement(MySQLServerConnection.java:187)
at com.lealone.plugins.mysql.server.MySQLServerConnection.executeStatement(MySQLServerConnection.java:206)
at com.lealone.plugins.mysql.server.handler.CommandPacketHandler.handle(CommandPacketHandler.java:37)
at com.lealone.plugins.mysql.server.MySQLServerConnection.handle(MySQLServerConnection.java:389)
at com.lealone.net.nio.NioEventLoop.read(NioEventLoop.java:269)
at com.lealone.net.nio.NioEventLoop.handleSelectedKeys(NioEventLoop.java:508)
at com.lealone.net.nio.NioEventLoop.handleSelectedKeys(NioEventLoop.java:493)
at com.lealone.net.NetScheduler.runEventLoop(NetScheduler.java:60)
at com.lealone.server.scheduler.GlobalScheduler.run(GlobalScheduler.java:70)
at java.base/java.lang.Thread.run(Thread.java:1583)
Client session timeout, session id: 1, host: 127.0.0.1, port: 53484```
Metadata
Metadata
Assignees
Labels
No labels