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

Error for any table operations (refresh, change column order, etc) #26850

Open
a-locatelli opened this issue Apr 26, 2024 · 3 comments
Open

Error for any table operations (refresh, change column order, etc) #26850

a-locatelli opened this issue Apr 26, 2024 · 3 comments

Comments

@a-locatelli
Copy link

a-locatelli commented Apr 26, 2024

Description

A popup error message appear each time i try to do some operation on table/column using the gui tools provided.

For example, when i try to re-order a column:
image

Or if i refresh the table tab:
image

Tipically the error does not affect the success the operation.
The problem occurs with every table, the one of the images is for example only

logs:

eclipse.buildId=unknown
java.version=17.0.6
java.vendor=Eclipse Adoptium
BootLoader constants: OS=linux, ARCH=x86_64, WS=gtk, NL=en_US
Framework arguments: -eclipse.keyring /home/ale/.local/share/DBeaverData/secure/secure_storage
Command-line arguments: -os linux -ws gtk -arch x86_64

This is a continuation of log file /home/ale/[omitted]/dbeaver/sei/.metadata/.bak_1.log
Created Time: 2024-04-26 10:35:39.749

org.jkiss.dbeaver.model
Error
Fri Apr 26 10:53:07 CEST 2024
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= 'event_queue'' at line 1

java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= 'event_queue'' at line 1
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1594)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1453)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1415)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:289)
at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:221)
at org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:157)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCPreparedStatementImpl.execute(JDBCPreparedStatementImpl.java:261)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCPreparedStatementImpl.executeStatement(JDBCPreparedStatementImpl.java:205)
at org.jkiss.dbeaver.model.impl.jdbc.cache.JDBCStructLookupCache.reloadObject(JDBCStructLookupCache.java:115)
at org.jkiss.dbeaver.model.impl.jdbc.cache.JDBCStructLookupCache.refreshObject(JDBCStructLookupCache.java:85)
at org.jkiss.dbeaver.ext.mysql.model.MySQLTableBase.refreshObject(MySQLTableBase.java:139)
at org.jkiss.dbeaver.ext.mysql.model.MySQLTable.refreshObject(MySQLTable.java:699)
at org.jkiss.dbeaver.model.navigator.DBNDatabaseNode.lambda$0(DBNDatabaseNode.java:362)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:194)
at org.jkiss.dbeaver.model.navigator.DBNDatabaseNode.refreshNode(DBNDatabaseNode.java:360)
at org.jkiss.dbeaver.ui.navigator.actions.NavigatorHandlerRefresh$1.run(NavigatorHandlerRefresh.java:189)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:115)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)

DBeaver Version

24.0.3

Operating System

Ubuntu 20.04

Database and driver

mariadb 3.3.2

Steps to reproduce

  1. have a database
  2. have a table and columns
  3. some actions that cause the error:
    3a. change the datatype of some column and save
    3b. change the position of columns (using icons) and save
    3c. refresh the table (F5 or refresh button)

Additional context

No response

@E1izabeth
Copy link
Member

Does your database name contain non-latin characters?

@a-locatelli
Copy link
Author

Does your database name contain non-latin characters?

No

@serjiokov
Copy link
Contributor

Can you please provide details from the "test connection"?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants