search

dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
39.45k stars 3.42k forks source link

ERROR: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. #35697

Open claudiocoliveira opened 1 week ago

claudiocoliveira commented 1 week ago

Description

After update to MacOS Sonoma 14.7 I could not connect to local MySQL. The message that appear is: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. But if I use other app, like SequealAce it works fine.

DBeaver Version

24.2.1.202409221725

Operating System

macOS Sonoma 14.7

Database and driver

MySQL 5.7.33

Steps to reproduce

  1. Install MySQL 5.7.33 in docker with rancher desktop;
  2. Try to connect to MySQL by DBeaver;

Additional context

eclipse.buildId=unknown java.version=17.0.6 java.vendor=Eclipse Adoptium BootLoader constants: OS=macosx, ARCH=x86_64, WS=cocoa, NL=pt_PT Framework arguments: -eclipse.keyring /Users/USER/Library/DBeaverData/secure/secure_storage Command-line arguments: -os macosx -ws cocoa -arch x86_64

org.jkiss.dbeaver.model Error Tue Sep 24 13:44:08 WEST 2024 Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.

java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81) at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:576) at com.mysql.cj.protocol.a.NativeProtocol.readServerCapabilities(NativeProtocol.java:537) at com.mysql.cj.protocol.a.NativeProtocol.beforeHandshake(NativeProtocol.java:425) at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1426) at com.mysql.cj.NativeSession.connect(NativeSession.java:133) at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:935) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:805) at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:438) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:189) at org.jkiss.dbeaver.model.impl.jdbc.JDBCConnectionOpener.run(JDBCConnectionOpener.java:109) at org.jkiss.dbeaver.model.impl.jdbc.JDBCConnectionOpener.run(JDBCConnectionOpener.java:83) at org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.openConnection(JDBCDataSource.java:223) at org.jkiss.dbeaver.ext.mysql.model.MySQLDataSource.openConnection(MySQLDataSource.java:513) at org.jkiss.dbeaver.model.impl.jdbc.JDBCExecutionContext.connect(JDBCExecutionContext.java:119) at org.jkiss.dbeaver.model.impl.jdbc.JDBCRemoteInstance.initializeMainContext(JDBCRemoteInstance.java:102) at org.jkiss.dbeaver.model.impl.jdbc.JDBCRemoteInstance.(JDBCRemoteInstance.java:61) at org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.initializeRemoteInstance(JDBCDataSource.java:121) at org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.(JDBCDataSource.java:105) at org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.(JDBCDataSource.java:96) at org.jkiss.dbeaver.ext.mysql.model.MySQLDataSource.(MySQLDataSource.java:123) at org.jkiss.dbeaver.ext.mysql.model.MySQLDataSource.(MySQLDataSource.java:118) at org.jkiss.dbeaver.ext.mysql.MySQLDataSourceProvider.openDataSource(MySQLDataSourceProvider.java:154) at org.jkiss.dbeaver.registry.DataSourceDescriptor.openDataSource(DataSourceDescriptor.java:1406) at org.jkiss.dbeaver.registry.DataSourceDescriptor.connect0(DataSourceDescriptor.java:1276) at org.jkiss.dbeaver.registry.DataSourceDescriptor.connect(DataSourceDescriptor.java:1061) at org.jkiss.dbeaver.runtime.jobs.ConnectJob.run(ConnectJob.java:78) at org.jkiss.dbeaver.runtime.jobs.ConnectJob.runSync(ConnectJob.java:109) at org.jkiss.dbeaver.ui.actions.datasource.DataSourceHandler.connectToDataSource(DataSourceHandler.java:122) at org.jkiss.dbeaver.ui.actions.datasource.UIServiceConnectionsImpl.initConnection(UIServiceConnectionsImpl.java:87) at org.jkiss.dbeaver.model.DBUtils.initDataSource(DBUtils.java:2414) at org.jkiss.dbeaver.model.navigator.DBNDataSource.initializeNode(DBNDataSource.java:159) at org.jkiss.dbeaver.model.navigator.DBNDatabaseNode.getChildren(DBNDatabaseNode.java:226) at org.jkiss.dbeaver.model.navigator.DBNDatabaseNode.getChildren(DBNDatabaseNode.java:1) at org.jkiss.dbeaver.model.navigator.DBNUtils.getNodeChildrenFiltered(DBNUtils.java:91) at org.jkiss.dbeaver.ui.navigator.database.load.TreeLoadService.evaluate(TreeLoadService.java:49) at org.jkiss.dbeaver.ui.navigator.database.load.TreeLoadService.evaluate(TreeLoadService.java:1) at org.jkiss.dbeaver.ui.LoadingJob.run(LoadingJob.java:88) at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:117) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)

E1izabeth commented 5 days ago

How did you configure the connection? Do you use SSH, SSL, etc.?