Page 1 of 1

MySQL Stored Procedure: Source code not available

PostPosted: Thu Mar 24, 2016 6:15 pm
by ronald2016
I used to be able to edit stored procedures in DBeaver, but this is no longer possible for me: the Procedure Source window now displays the message "Source code not available".

My setup is as follows:

DBeaver version 3.6.2
MySQL version 5.7.11
MySQL Plug-in version 2.1.12
Java version 1.7.0_95
JDBC driver: mysql-connector-java-5.1.38-bin.jar
Operating system: Linux Mint 17.3

Are there any additional plug-ins that need to be installed?

Thanks in advance for any help.

Re: MySQL Stored Procedure: Source code not available

PostPosted: Fri Mar 25, 2016 10:44 am
by Serge
Looks like some bug but I can't reproduce that.
Please check Error Log (can be opened thru main menu Window) for any related errors. If there is anything interesting - please post full stacktrace of that errors.

Re: MySQL Stored Procedure: Source code not available

PostPosted: Fri Mar 25, 2016 8:28 pm
by ronald2016
The messages I can see in the Error Log do not seem to be related to this problem -- for instance

!ENTRY org.jkiss.dbeaver.model 2 0 2016-03-25 16:36:08.529
!MESSAGE Some data source listeners are still registered: [org.jkiss.dbeaver.ui.editors.sql.SQLEditor@512628c1]

!ENTRY org.jkiss.dbeaver.model 2 0 2016-03-25 16:36:08.582
!MESSAGE Some project listeners are still register: [org.jkiss.dbeaver.core.application.ApplicationWorkbenchWindowAdvisor@76b7fa87]

And I have just noticed that the same problem affects views as well! -- while trying to open a view's definition, the messages were

-- Loading '<view name>' source...
-- View definition not available

I have now upgraded DBeaver to version 3.6.2 on a machine that runs Windows 7 instead of Linux (with Java version 1.7.0_65 and MySQL 5.6), and procedure editing works perfectly there.

I wonder if this whole issue is limited to Linux Mint?

Re: MySQL Stored Procedure: Source code not available

PostPosted: Mon Mar 28, 2016 10:02 am
by Serge
That's odd.
There is no difference between Linux and windows versions.
Try to reinstall DBeaver on you Linux. Remove previous version completely (your settings won't be lost) and install the fresh one.

Re: MySQL Stored Procedure: Source code not available

PostPosted: Sat Apr 09, 2016 10:24 pm
by ronald2016
I have now completely uninstalled DBeaver version 3.6.2 and installed version 3.6.3, but the problem is still there.

The data that is not being displayed in the Source / Definition / DDL panes seems to originate from LONGTEXT columns in the information_schema database:

PARTITION_EXPRESSION in the information_schema's PARTITIONS view
ROUTINE_DEFINITION in the information_schema's ROUTINES view
VIEW_DEFINITION in the information_schema's VIEWS view

My understanding is that LONGTEXT columns are stored separately from the other columns of a table, so I wonder if their storage implementation is operating system and/or file system dependent? Could that perhaps explain why DBeaver displays procedure definitions in Windows but not in Linux (Mint)?