dbeaver: Cannot run program "/usr/bin/mysqldump" since version 22.3.4 (Permission denied)

Description

I try to do a mysqldump and get the error

Error executing process
  Cannot run program "/usr/bin/mysqldump" (in directory "/usr/bin"): error=13, Permission denied
  Cannot run program "/usr/bin/mysqldump" (in directory "/usr/bin"): error=13, Permission denied
    error=13, Permission denied
    error=13, Permission denied

DBeaver Version

Community Edition 22.3.4

Operating System

Ubuntu 22.04.1 LTS

Database and driver

Server version: 10.6.11-MariaDB-0ubuntu0.22.04.1
Driver name: MySQL 5

Steps to reproduce

Upgrade to dBeaver version 22.3.4 (dbeaver-ce_22.3.4_amd64.deb)
Open a database
Go to Tools > Dump database
Click on Next and Start
Get the error

After downgrade back to 22.3.3 it works again.

Additional context

No response

About this issue

Original URL
State: closed
Created a year ago
Reactions: 15
Comments: 21 (9 by maintainers)

Most upvoted comments

Most likely it is a result of Java 17 upgrade. We are investigating this and going to fix it in the next version.

serge-rider on Feb 7, 2023

Downgrade to version 22.3.3 solve the problem.

=> https://dbeaver.io/files/22.3.3/

acantepie on Feb 8, 2023

Upgrade to dBeaver version 22.3.4 (dbeaver-ce_22.3.4_amd64.deb)

According to this, I assume you installed DBeaver package manually and not from Snap or Flatpack. Am I correct?

Matvey16 on Feb 6, 2023

Same problem, but with Postgres: Pop!_OS 22.04 LTS Version 22.3.4, installed with apt-get Local and remote databases

2023-02-06 09:00:24.615 - IO error: Cannot run program "/usr/bin/pg_dump" (in directory "/usr/bin"): error=13, Permission denied
2023-02-06 09:00:24.615 - java.io.IOException: Cannot run program "/usr/bin/pg_dump" (in directory "/usr/bin"): error=13, Permission denied
	at java.base/java.lang.ProcessBuilder.start(Unknown Source)
	at java.base/java.lang.ProcessBuilder.start(Unknown Source)
	at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.executeProcess(AbstractNativeToolHandler.java:208)
	at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.doExecute(AbstractNativeToolHandler.java:262)
	at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.lambda$0(AbstractNativeToolHandler.java:83)
	at org.jkiss.dbeaver.runtime.RunnableContextDelegate.lambda$0(RunnableContextDelegate.java:39)
	at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
Caused by: java.io.IOException: error=13, Permission denied
	at java.base/java.lang.ProcessImpl.forkAndExec(Native Method)
	at java.base/java.lang.ProcessImpl.<init>(Unknown Source)
	at java.base/java.lang.ProcessImpl.start(Unknown Source)
	... 7 more

For some reason the Product Version is empty as well:

Logs for the Product Version:

ENTRY org.jkiss.dbeaver.model 2 0 2023-02-06 09:22:45.049
!MESSAGE Error reading PostgreSQL native client version from /usr/bin/psql
!SUBENTRY 1 org.jkiss.dbeaver.model 2 0 2023-02-06 09:22:45.049
!MESSAGE Cannot run program "/usr/bin/psql": error=13, Permission denied
!SUBENTRY 2 org.jkiss.dbeaver.model 2 0 2023-02-06 09:22:45.049
!MESSAGE error=13, Permission denied
!STACK 0
java.io.IOException: error=13, Permission denied
	at java.base/java.lang.ProcessImpl.forkAndExec(Native Method)
	at java.base/java.lang.ProcessImpl.<init>(Unknown Source)
	at java.base/java.lang.ProcessImpl.start(Unknown Source)
	at java.base/java.lang.ProcessBuilder.start(Unknown Source)
	at java.base/java.lang.ProcessBuilder.start(Unknown Source)
	at java.base/java.lang.Runtime.exec(Unknown Source)
	at java.base/java.lang.Runtime.exec(Unknown Source)
	at org.jkiss.dbeaver.ext.postgresql.PostgreDataSourceProvider.getFullServerVersion(PostgreDataSourceProvider.java:255)
	at org.jkiss.dbeaver.ext.postgresql.PostgreDataSourceProvider.getProductVersion(PostgreDataSourceProvider.java:155)
	at org.jkiss.dbeaver.ui.dialogs.connection.ClientHomesPanel.selectHome(ClientHomesPanel.java:204)
	at org.jkiss.dbeaver.ui.dialogs.connection.ClientHomesPanel$1.widgetSelected(ClientHomesPanel.java:108)
	at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:252)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
	at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5855)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1529)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5065)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4517)
	at org.eclipse.jface.window.Window.runEventLoop(Window.java:823)
	at org.eclipse.jface.window.Window.open(Window.java:799)
	at org.jkiss.dbeaver.ui.dialogs.connection.ClientHomesPanel.chooseClientHome(ClientHomesPanel.java:327)
	at org.jkiss.dbeaver.ui.dialogs.connection.ClientHomesSelector.manageHomes(ClientHomesSelector.java:109)
	at org.jkiss.dbeaver.ui.dialogs.connection.ClientHomesSelector$1.widgetSelected(ClientHomesSelector.java:87)
	at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:252)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
	at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5855)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1529)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5065)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4517)
	at org.eclipse.jface.window.Window.runEventLoop(Window.java:823)
	at org.eclipse.jface.window.Window.open(Window.java:799)
	at org.jkiss.dbeaver.tasks.ui.nativetool.NativeToolWizardDialog.openClientConfiguration(NativeToolWizardDialog.java:111)
	at org.jkiss.dbeaver.tasks.ui.nativetool.NativeToolWizardDialog.buttonPressed(NativeToolWizardDialog.java:101)
	at org.eclipse.jface.dialogs.Dialog.lambda$0(Dialog.java:619)
	at org.eclipse.swt.events.SelectionListener$1.widgetSelected(SelectionListener.java:84)
	at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:252)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
	at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5855)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1529)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5065)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4517)
	at org.eclipse.jface.window.Window.runEventLoop(Window.java:823)
	at org.eclipse.jface.window.Window.open(Window.java:799)
	at org.jkiss.dbeaver.ext.postgresql.tools.PostgreToolBackup.execute(PostgreToolBackup.java:39)
	at org.jkiss.dbeaver.tasks.ui.ExecuteToolHandler.executeTool(ExecuteToolHandler.java:59)
	at org.jkiss.dbeaver.tasks.ui.ExecuteToolHandler.run(ExecuteToolHandler.java:51)
	at org.jkiss.dbeaver.ui.ActionUtils$1.run(ActionUtils.java:382)
	at org.eclipse.jface.action.Action.runWithEvent(Action.java:474)
	at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:580)
	at org.eclipse.jface.action.ActionContributionItem.lambda$4(ActionContributionItem.java:414)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
	at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5855)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1529)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5065)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4517)
	at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1155)
	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)
	at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1046)
	at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:155)
	at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:643)
	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)
	at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:550)
	at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:171)
	at org.jkiss.dbeaver.ui.app.standalone.DBeaverApplication.start(DBeaverApplication.java:296)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:203)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:136)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:402)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:255)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:659)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:596)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1467)
	at org.eclipse.equinox.launcher.Main.main(Main.java:1440)

crossworth on Feb 6, 2023

Verified

Matvey16 on Feb 10, 2023

I have the same error, but when I try to connect to databases using SSH tunnel. DBeaver Version Community Edition 22.3.4

Operating System Ubuntu 22.04.1 LTS

After downgrading back to 22.3.3 it works again. 👍

npetrovopt on Feb 6, 2023