Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
When I try perform select that exception handled correctly, but on describe is not:
Error occurred while describing: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error: ** BEGIN NESTED EXCEPTION ** com.mysql.jdbc.exceptions.jdbc4.CommunicationsException MESSAGE: Communications link failure The last packet successfully received from the server was 277,097 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago. STACKTRACE: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 277,097 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:525) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3030) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2916) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3459) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2571) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1451) at \\...\\ .\\हिñçêČάй語简�?한\\.bꇛ⣦ꄤᛔ.executeQuery(Unknown Source) at \\...\\ .\\हिñçêČάй語简�?한\\.Cꑎꃴᚨꏑ double.h(Unknown Source) at com.aquafold.datastudio.queryanalyzer.v⣿ꊑ᠈ͮ static.BC(Unknown Source) at com.aquafold.datastudio.queryanalyzer.v⣿ꊑ᠈ͮ static.BB(Unknown Source) at com.aquafold.datastudio.queryanalyzer.qꎨꈏꏪᡛ.process(Unknown Source) at com.common.ui.util.BackgroundThread.run(Unknown Source) Caused by: 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.jdbc.MysqlIO.readFully(MysqlIO.java:2475) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2927) ... 13 more ** END NESTED EXCEPTION ** at sun.reflect.GeneratedConstructorAccessor18.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:525) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1165) at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2486) at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2468) at \\...\\ .\\हिñçêČάй語简�?한\\.xꋕ⢈ᠫᢇ.createStatement(Unknown Source) at \\...\\ .\\हिñçêČάй語简�?한\\.Cꑎꃴᚨꏑ double.i(Unknown Source) at com.aquafold.datastudio.queryanalyzer.v⣿ꊑ᠈ͮ static.BC(Unknown Source) at com.aquafold.datastudio.queryanalyzer.v⣿ꊑ᠈ͮ static.BB(Unknown Source) at com.aquafold.datastudio.queryanalyzer.qꎨꈏꏪᡛ.process(Unknown Source) at com.common.ui.util.BackgroundThread.run(Unknown Source)
Additionally I'm wonder is ADS have possibility auto reconnect in such cases (ping)?
The error message indicated is just an error from the MySQL JDBC driver indicating that the connection has been closed.
The error message indicated is just an error from the MySQL JDBC driver indicating that the connection has been closed.
The error message indicated is just an error from the MySQL JDBC driver indicating that the connection has been closed.
Sure. But when I try in such case perform query - its catched and handled and then present as error in grid for me (user). But on describe it is not catched and disposed raw to user. It what is my report about.
The error message indicated is just an error from the MySQL JDBC driver indicating that the connection has been closed.
Sure. But when I try in such case perform query - its catched and handled and then present as error in grid for me (user). But on describe it is not catched and disposed raw to user. It what is my report about.
On Describe we now check to make sure the connection is open. If the connection is closed we throw a user friendly exception message to output...
On Describe we now check to make sure the connection is open. If the connection is closed we throw a user friendly exception message to output...
1) Ivan, once the MySQL connection is closed and user performs a describe for the first time, the screen as in my attached screenshot(Describe) is displayed to the user.
If I perform Describe operations (Ctrl+D), after this, ADS will display
"Error occurred while describing: No operations allowed after connection closed..."
2.) So for the first time, why does it still display raw text as described by the user ?
1) Ivan, once the MySQL connection is closed and user performs a describe for the first time, the screen as in my attached screenshot(Describe) is displayed to the user.
If I perform Describe operations (Ctrl+D), after this, ADS will display
"Error occurred while describing: No operations allowed after connection closed..."
2.) So for the first time, why does it still display raw text as described by the user ?
If I disconnect following a Describe and run Describe again, I get no warning or message that I am disconnected.
see attached GIF animation
If I disconnect following a Describe and run Describe again, I get no warning or message that I am disconnected.
see attached GIF animation
I didn't test this correctly
fixed well before 31338
I didn't test this correctly
fixed well before 31338
Issue #7742 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
Additionally I'm wonder is ADS have possibility auto reconnect in such cases (ping)?