Skip to content

Fail to use mysql plugin #1

Open
@YamahaFG1984

Description

@YamahaFG1984

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

截屏2024-09-07 10 58 48

step 2

截屏2024-09-07 10 59 39

step 3

截屏2024-09-07 11 01 03

step 4

截屏2024-09-07 11 01 50

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

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions