MySQL Stored Procedure: Source code not available

Note: please leave bug reports and feature requests on

MySQL Stored Procedure: Source code not available

Postby ronald2016 » Thu Mar 24, 2016 6:15 pm

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.
ronald2016
 
Posts: 3
Joined: Sat Mar 05, 2016 4:31 pm

Re: MySQL Stored Procedure: Source code not available

Postby Serge » Fri Mar 25, 2016 10:44 am

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.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: MySQL Stored Procedure: Source code not available

Postby ronald2016 » Fri Mar 25, 2016 8:28 pm

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?
ronald2016
 
Posts: 3
Joined: Sat Mar 05, 2016 4:31 pm

Re: MySQL Stored Procedure: Source code not available

Postby Serge » Mon Mar 28, 2016 10:02 am

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.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: MySQL Stored Procedure: Source code not available

Postby ronald2016 » Sat Apr 09, 2016 10:24 pm

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)?
ronald2016
 
Posts: 3
Joined: Sat Mar 05, 2016 4:31 pm


Return to Support



Who is online

Users browsing this forum: No registered users and 25 guests