Возникла ошибка посмотрите файл протокола dbeaver

dbeaver was working fine in my system.But,suddenly it is giving an error «See the log file /home/system/.dbeaver/.metadata/.log». Please,can someone help me to resolve this issue?

asked Jan 6, 2016 at 7:02

Bhagyashree O's user avatar

Bhagyashree OBhagyashree O

1231 gold badge3 silver badges13 bronze badges

7

1 Answer

It might be the case that jdk is changed. Try moving the jdk if so from /Library/Java/JavaVirtualMachines to another location. This happened with me when I installed jdk11 and moving it, resolved my issue.

answered Oct 12, 2018 at 5:44

Gayatri Parameswaran's user avatar

I. Фон

Операционная система: win10
версия dbeaver: 5.2.2
Хороший dbeaver, который использовался внезапно, не может быть использован нормально, загрузка новой версии все еще не работает, подсказка: произошла ошибка. Смотрите файл журнала,

Два журнала ошибок

Перейдите в каталог приглашения C: Users bin.dbeaver4.metadata, чтобы просмотреть журнал ошибок .log следующим образом:

!SESSION 2018-10-08 17:23:58.845 -----------------------------------------------
eclipse.buildId=unknown
java.version=11
java.vendor=Oracle Corporation
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=zh_CN
Command-line arguments:  -os win32 -ws win32 -arch x86_64

!ENTRY org.jkiss.dbeaver.model 4 0 2018-10-08 17:24:00.778
! СООБЩЕНИЕ не создало верстак.
!STACK 0
 java.lang.IllegalStateException: рабочая среда не была создана.
	at org.eclipse.ui.PlatformUI.getWorkbench(PlatformUI.java:93)
	at org.jkiss.dbeaver.core.application.DBeaverApplication.shutdown(DBeaverApplication.java:290)
	at org.jkiss.dbeaver.core.application.DBeaverApplication.start(DBeaverApplication.java:165)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:653)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:590)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1499)

!ENTRY org.eclipse.osgi.compatibility.state.nls 2 0 2018-10-08 17:24:00.808
!MESSAGE Could not resolve module: org.eclipse.osgi.compatibility.state.nls [241]
  Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state
  Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state


!ENTRY org.eclipse.core.filesystem.win32.x86_64.nls 2 0 2018-10-08 17:24:00.809
!MESSAGE Could not resolve module: org.eclipse.core.filesystem.win32.x86_64.nls [253]
  Unresolved requirement: Fragment-Host: org.eclipse.core.filesystem.win32.x86_64
  Unresolved requirement: Fragment-Host: org.eclipse.core.filesystem.win32.x86_64


!ENTRY org.eclipse.osgi 4 0 2018-10-08 17:24:00.824
 Ошибка приложения! MESSAGE
!STACK 1
 org.eclipse.swt.SWTException: не удалось выполнить runnable (java.lang.IllegalStateException: Workbench не был создан.)
	at org.eclipse.swt.SWT.error(SWT.java:4533)
	at org.eclipse.swt.SWT.error(SWT.java:4448)
	at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:185)
	at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4213)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3820)
	at org.eclipse.swt.widgets.Display.release(Display.java:3874)
	at org.eclipse.swt.graphics.Device.dispose(Device.java:298)
	at org.jkiss.dbeaver.core.application.DBeaverApplication.start(DBeaverApplication.java:174)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:653)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:590)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1499)
 Причина: java.lang.IllegalStateException: рабочая среда не была создана.
	at org.eclipse.ui.PlatformUI.getWorkbench(PlatformUI.java:93)
	at org.jkiss.dbeaver.core.WorkbenchContextListener.<init>(WorkbenchContextListener.java:57)
	at org.jkiss.dbeaver.core.WorkbenchContextListener.registerInWorkbench(WorkbenchContextListener.java:254)
	at org.jkiss.dbeaver.core.DBeaverUI.lambda$0(DBeaverUI.java:124)
	at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:37)
	at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:182)
	... 17 more

!ENTRY org.eclipse.e4.ui.workbench 4 0 2018-10-08 17:24:00.835
!MESSAGE FrameworkEvent ERROR
!STACK 0
java.lang.NoClassDefFoundError: javax/annotation/PreDestroy
	at org.eclipse.e4.core.internal.di.InjectorImpl.disposed(InjectorImpl.java:450)
	at org.eclipse.e4.core.internal.di.Requestor.disposed(Requestor.java:156)
	at org.eclipse.e4.core.internal.contexts.ContextObjectSupplier$ContextInjectionListener.update(ContextObjectSupplier.java:78)
	at org.eclipse.e4.core.internal.contexts.TrackableComputationExt.update(TrackableComputationExt.java:111)
	at org.eclipse.e4.core.internal.contexts.TrackableComputationExt.handleInvalid(TrackableComputationExt.java:74)
	at org.eclipse.e4.core.internal.contexts.EclipseContext.dispose(EclipseContext.java:178)
	at org.eclipse.e4.core.internal.contexts.osgi.EclipseContextOSGi.dispose(EclipseContextOSGi.java:99)
	at org.eclipse.e4.core.internal.contexts.osgi.EclipseContextOSGi.bundleChanged(EclipseContextOSGi.java:141)
	at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:908)
	at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)
	at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148)
	at org.eclipse.osgi.internal.framework.EquinoxEventPublisher.publishBundleEventPrivileged(EquinoxEventPublisher.java:213)
	at org.eclipse.osgi.internal.framework.EquinoxEventPublisher.publishBundleEvent(EquinoxEventPublisher.java:120)
	at org.eclipse.osgi.internal.framework.EquinoxEventPublisher.publishBundleEvent(EquinoxEventPublisher.java:112)
	at org.eclipse.osgi.internal.framework.EquinoxContainerAdaptor.publishModuleEvent(EquinoxContainerAdaptor.java:168)
	at org.eclipse.osgi.container.Module.publishEvent(Module.java:476)
	at org.eclipse.osgi.container.Module.doStop(Module.java:634)
	at org.eclipse.osgi.container.Module.stop(Module.java:498)
	at org.eclipse.osgi.container.SystemModule.stop(SystemModule.java:202)
	at org.eclipse.osgi.internal.framework.EquinoxBundle$SystemBundle$EquinoxSystemModule$1.run(EquinoxBundle.java:165)
	at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.lang.ClassNotFoundException: javax.annotation.PreDestroy cannot be found by org.eclipse.e4.core.di_1.6.100.v20170421-1418
	at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:433)
	at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:395)
	at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:387)
	at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:150)
	at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)
	... 21 more

Простой анализ журнала ошибок
java.version = 11 означает версию jdk, которую я использую. Недавно операционная система была обновлена ​​до jdk11. Я загрузил внешнюю версию jre dbeaver, поэтому здесь напечатана версия 11.
Информация о критических исключениях: java.lang.NoClassDefFoundError: javax / annotation / PreDestroy
PreDestroy не найден, поскольку Jdk9 начал использовать модульность. PreDestroy необходимо добавить вручную, чтобы поддержать его.
Мы переходим в корневой каталог dbeaver. Откройте dbeaver.ini

-startup
plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar
--launcher.library
plugins/org.eclipse.equinox.launcher.win32.win32.x86_64_1.1.551.v20171108-1834
-showsplash
-vmargs
-XX:+IgnoreUnrecognizedVMOptions
--add-modules=ALL-SYSTEM
-Xms64m
-Xmx1024m

Обнаружено, что в параметрах уже есть add-modules = ALL-SYSTEM или NoClassDefFoundError. Я не знаю, если dbeaver еще не совместим с jdk11, попробуйте другое решение.

Три решения

Откройте файл readme.txt в корневом каталоге dbeaver.

  -f <sql-file1 [sql-file2..]>
    Open specified SQL file(s) in SQL editor.
    This command can be used to associate SQL files with DBeaver in shell.

  -nosplash
    Do not show splash screen

  -data <path>
    Store all projects/configuration in folder <path>. By default DBeaver
	stores all its data in user's home ".dbeaver4" folder.
	<path> can be an absolute or relative directory name.
	If you want to use DBeaver as redistributable program start it
	with arguments like "dbeaver -data workspace".

  -nl locale
    Use specified locale instead of default one.
    Example: -nl en (use English locale).

  -vm <java vm path>
    Use Java VM installed in <java vm path> folder instead of default
    location.

  -vmargs <jvm parameters>
    Allows to pass any number of additional parameters to JVM.
    Additional parameters may be used to customize environment or
    3-rd party jdbc drivers.

  -clean
    Clears all Eclipse caches. Use it if DBeaver fails to start after version upgrade.

Мы используем параметр -vm, чтобы указать jdk в качестве каталога jdk8.
1. Щелкните правой кнопкой мыши файл dbeaver.exe, чтобы отправить ярлык на рабочий стол.

Укажите параметр -vm в целевой папке: D: dbeaver dbeaver.exe -vm «C: Program Files Java jdk1.8.0_45 bin»
Используйте указанный Jdk при запуске dbeaver.

dbeaver was working fine in my system.But,suddenly it is giving an error «See the log file /home/system/.dbeaver/.metadata/.log». Please,can someone help me to resolve this issue?

asked Jan 6, 2016 at 7:02

Bhagyashree O's user avatar

Bhagyashree OBhagyashree O

1231 gold badge3 silver badges12 bronze badges

7

1 Answer

It might be the case that jdk is changed. Try moving the jdk if so from /Library/Java/JavaVirtualMachines to another location. This happened with me when I installed jdk11 and moving it, resolved my issue.

answered Oct 12, 2018 at 5:44

Gayatri Parameswaran's user avatar


EXE проблемы с dbeaver.exe чаще всего связаны с повреждением или отсутствием исполняемого файла, и зачастую возникают во время запуска Third-Party Application. Как правило, любую проблему, связанную с файлом EXE, можно решить посредством замены файла на новую копию. Мы также рекомендуем выполнить сканирование реестра, чтобы очистить все недействительные ссылки на dbeaver.exe, которые могут являться причиной ошибки.

Исполнимые файлы, которые относятся к формату Windows Executable File обычно содержат суффикс файла EXE. В таблице ниже представлен список доступных для загрузки файлов dbeaver.exe, подходящих для большинства версий Windows (включая %%os%%). Если в настоящее время необходимая вам версия dbeaver.exe недоступна для загрузки, вы можете запросить её копию, нажав на кнопку Request (Запрос) ниже. В крайнем случае, если ниже отсутствует необходимая вам версия файла, вы всегда можете связаться с Windows Software Developer.

Настоятельно рекомендуется выполнить проверку и убедиться в том, что файл был размещён в правильном каталоге. Тщательно следуйте настоящим инструкциям, чтобы устранить возникающую ошибку, связанную с файлом dbeaver.exe, однако мы рекомендуем выполнить быструю проверку. Повторно запустите Third-Party Application, чтобы убедиться в успешном решении проблемы.

dbeaver.exe Описание файла
Расширение файла: EXE
Функция:
Application: Third-Party Application
ID: 1.0
Создано: Windows Software Developer
 
Имя файла: dbeaver.exe  
Размер (в байтах): 53248
SHA-1: 1d04f42f4bfee1ecc2466815afbbaf89bdec6a3e
MD5: c236e87616927390b9447cf4fbaab129
CRC32:

Продукт Solvusoft

Загрузка
WinThruster 2023 — Сканировать ваш компьютер на наличие ошибок реестра в dbeaver.exe

Windows
11/10/8/7/Vista/XP

Установить необязательные продукты — WinThruster (Solvusoft) | Лицензия | Политика защиты личных сведений | Условия | Удаление

EXE
dbeaver.exe

Идентификатор статьи:   1135176

Dbeaver.exe

Filename ID Размер (в байтах) Загрузить
+ dbeaver.exe c236e87616927390b9447cf4fbaab129 52.00 KB
App Third-Party Application 1.0
Создано Windows Software Developer
Вер Windows 7
Архитектура 64-разрядная (x64)
Размер 53248
MD5 c236e87616927390b9447cf4fbaab129
Контрольная сумма SHA1 1d04f42f4bfee1ecc2466815afbbaf89bdec6a3e
Контрольная сумма SHA256: 8da4783a7fcdeb98f147a3f775d698b2ded3c9c8d102c0c24e8d51f00fef020f
CRC32:
Расположение файла %PROGRAMFILES%DBeaver

Типичные ошибки Dbeaver.exe

Эти проблемы Third-Party Application, связанные с dbeaver.exe, включают в себя:

  • «Ошибка в приложении: dbeaver.exe»
  • «Dbeaver.exe не является программой Win32. «
  • «Извините, dbeaver.exe столкнулся с проблемой. «
  • «К сожалению, мы не можем найти dbeaver.exe. «
  • «Dbeaver.exe не может быть найден. «
  • «Ошибка запуска в приложении: dbeaver.exe. «
  • «Файл Dbeaver.exe не запущен.»
  • «Dbeaver.exe выйти. «
  • «Неверный путь к программе: dbeaver.exe. «

Проблемы dbeaver.exe с участием Third-Party Applications возникают во время установки, при запуске или завершении работы программного обеспечения, связанного с dbeaver.exe, или во время процесса установки Windows. Важно отметить, когда возникают проблемы dbeaver.exe, так как это помогает устранять проблемы Third-Party Application (и сообщать в Windows Software Developer).

Источники проблем Dbeaver.exe

Заражение вредоносными программами, недопустимые записи реестра Third-Party Application или отсутствующие или поврежденные файлы dbeaver.exe могут создать эти ошибки dbeaver.exe.

В первую очередь, проблемы dbeaver.exe создаются:

  • Поврежденные ключи реестра Windows, связанные с dbeaver.exe / Third-Party Application.
  • Вирус или вредоносное ПО, которые повредили файл dbeaver.exe или связанные с Third-Party Application программные файлы.
  • Dbeaver.exe злонамеренно удален (или ошибочно) другим изгоем или действительной программой.
  • Другое программное обеспечение, конфликтующее с Third-Party Application, dbeaver.exe или общими ссылками.
  • Поврежденная загрузка или неполная установка программного обеспечения Third-Party Application.

I had a sql that had some error. Although the error says

SQL Error [42601]: ERROR: syntax error at or near "from"
  Position: 420

. However, it seems dbeaver didn’t highlight exactly where the error is. It tells me it is position 420, but i don’t know where is position 420 intuitively….

Is it possible to let DBeaver to highlight error for me.

PS: I could identify the error by eyeballing this time… but other times seem difficult…

enter image description here

asked Sep 15, 2021 at 3:14

hg628193hg's user avatar

0

With this option activated dbeaver it will show you a red marker on the line that contains the error.

With this option activated dbeaver it will show you a red marker on the line that contains the error.

answered Apr 20, 2022 at 20:46

rogeriodsc's user avatar

0

I’m not sure the accepted answer is correct. Normally I’d go into Window | Preferences | Editors | SQL Editor | Code Editor and turn on the option Show problem markers.

DBeaver | Preferences | Editors | SQL Editor | Code Editor | Option: Show problem markers

Tooltip: Shows individual markers near the failed queries and highlights the problematic segment of it in the editor. if disabled, selects the problematic segment in the editor.

qyb2zm302's user avatar

answered Apr 22, 2022 at 9:01

John K. N.'s user avatar

John K. N.John K. N.

15.7k10 gold badges45 silver badges100 bronze badges

In this case, your problem is you have a comma at the end of db4_open, right before the FROM clause. Remove that comma and the query will not have that error. Some query GUIs have the ability in an Options page to turn on line numbers. Not sure if that is the case for this tool or not.

answered Sep 16, 2021 at 2:04

Lee M's user avatar

Lee MLee M

3842 silver badges10 bronze badges

0

enter image description here

I think, just turn on the «Show line numbers» in preferences

answered Nov 26, 2021 at 15:41

clid saniny's user avatar

I had a sql that had some error. Although the error says

SQL Error [42601]: ERROR: syntax error at or near "from"
  Position: 420

. However, it seems dbeaver didn’t highlight exactly where the error is. It tells me it is position 420, but i don’t know where is position 420 intuitively….

Is it possible to let DBeaver to highlight error for me.

PS: I could identify the error by eyeballing this time… but other times seem difficult…

enter image description here

asked Sep 15, 2021 at 3:14

hg628193hg's user avatar

0

With this option activated dbeaver it will show you a red marker on the line that contains the error.

With this option activated dbeaver it will show you a red marker on the line that contains the error.

answered Apr 20, 2022 at 20:46

rogeriodsc's user avatar

0

I’m not sure the accepted answer is correct. Normally I’d go into Window | Preferences | Editors | SQL Editor | Code Editor and turn on the option Show problem markers.

DBeaver | Preferences | Editors | SQL Editor | Code Editor | Option: Show problem markers

Tooltip: Shows individual markers near the failed queries and highlights the problematic segment of it in the editor. if disabled, selects the problematic segment in the editor.

qyb2zm302's user avatar

answered Apr 22, 2022 at 9:01

John K. N.'s user avatar

John K. N.John K. N.

15.7k10 gold badges45 silver badges100 bronze badges

In this case, your problem is you have a comma at the end of db4_open, right before the FROM clause. Remove that comma and the query will not have that error. Some query GUIs have the ability in an Options page to turn on line numbers. Not sure if that is the case for this tool or not.

answered Sep 16, 2021 at 2:04

Lee M's user avatar

Lee MLee M

3842 silver badges10 bronze badges

0

enter image description here

I think, just turn on the «Show line numbers» in preferences

answered Nov 26, 2021 at 15:41

clid saniny's user avatar

Log files

Error Log view

There is an Error Log view (main menu Window->Show View->Error Log) which contains all errors which occur during the DBeaver runtime.
You can double click on the warning/error in the log viewer and see the error stacktrace. Please attach it to the bug report.
Also, you can open the full log (all error messages) if you need:

Log files

DBeaver writes different log files. Most of them are Eclipse logs.
Log files usually reside in the workspace/workspace6/.metadata .

  • In Windows open Explorer and paste path %APPDATA%DBeaverDataworkspace6.metadata.
  • In Linux just type cd $XDG_DATA_HOME/DBeaverData/workspace6/.metadata
  • In MacOS open path ~/Library/DBeaverData/workspace6/.metadata in Finder.
    • To view hidden folders press Cmd+Shift+. in the folder view.

Two standard log files:

  • workspace/workspace6/.metadata/.log — all warnings and errors which happen during normal work
  • workspace/workspace6/.metadata/dbeaver-debug.log — the same as .log plus debug information

In special cases log files can be written in other directories. A special case is an emergency situation when DBeaver cannot start and there is no workspace.
Two typical places to find emergency logs:

  • <install-path>/configuration
  • ${HOME}/.eclipse/org.jkiss.dbeaver.product_<dbeaver-version>

If you are reporting an error, please attach the applicable part of the log — not the complete file.
Logs are very useful. Many errors cannot be reproduced and fixed without a full error stacktrace (all the details).

Java fatal logs

On the rare occasion that the DBeaver process dies, it does not leave any valuable logs. This is caused by a Java VM crash.
JVM creates a fatal log file for each crash (log gile hs_err_PID.log). This log usually resides in the same directory where the DBeaver launcher is (e.g. dbeaver.exe).
But in some cases it is a write-protected directory and the log file will be created in other folder.
Instructions on how to find the Java fatal log file: https://docs.oracle.com/javase/9/troubleshoot/fatal-error-log.htm

Did we resolve your issue?

System information:

  • Operating system (distribution) and version
  • DBeaver version
  • Additional extensions

Connection specification:

  • Database name and version
  • Driver name
  • Do you use tunnels or proxies (SSH, SOCKS, etc)?

Describe the problem you’re observing: I cannot open my DBeaver. Every time I try to open it it gives me the error message: «An error has occurred. See the log file…» and when I try to go to the location of the log file, it does not exist.

Steps to reproduce, if exist:

Include any warning/errors/backtraces from the logs

dbeaver was working fine in my system.But,suddenly it is giving an error «See the log file /home/system/.dbeaver/.metadata/.log». Please,can someone help me to resolve this issue?

asked Jan 6, 2016 at 7:02

Bhagyashree O's user avatar

Bhagyashree OBhagyashree O

1231 gold badge3 silver badges12 bronze badges

7

1 Answer

It might be the case that jdk is changed. Try moving the jdk if so from /Library/Java/JavaVirtualMachines to another location. This happened with me when I installed jdk11 and moving it, resolved my issue.

answered Oct 12, 2018 at 5:44

Gayatri Parameswaran's user avatar

I. Фон

Операционная система: win10
версия dbeaver: 5.2.2
Хороший dbeaver, который использовался внезапно, не может быть использован нормально, загрузка новой версии все еще не работает, подсказка: произошла ошибка. Смотрите файл журнала,

Два журнала ошибок

Перейдите в каталог приглашения C: Users bin.dbeaver4.metadata, чтобы просмотреть журнал ошибок .log следующим образом:

!SESSION 2018-10-08 17:23:58.845 -----------------------------------------------
eclipse.buildId=unknown
java.version=11
java.vendor=Oracle Corporation
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=zh_CN
Command-line arguments:  -os win32 -ws win32 -arch x86_64

!ENTRY org.jkiss.dbeaver.model 4 0 2018-10-08 17:24:00.778
! СООБЩЕНИЕ не создало верстак.
!STACK 0
 java.lang.IllegalStateException: рабочая среда не была создана.
	at org.eclipse.ui.PlatformUI.getWorkbench(PlatformUI.java:93)
	at org.jkiss.dbeaver.core.application.DBeaverApplication.shutdown(DBeaverApplication.java:290)
	at org.jkiss.dbeaver.core.application.DBeaverApplication.start(DBeaverApplication.java:165)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:653)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:590)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1499)

!ENTRY org.eclipse.osgi.compatibility.state.nls 2 0 2018-10-08 17:24:00.808
!MESSAGE Could not resolve module: org.eclipse.osgi.compatibility.state.nls [241]
  Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state
  Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state


!ENTRY org.eclipse.core.filesystem.win32.x86_64.nls 2 0 2018-10-08 17:24:00.809
!MESSAGE Could not resolve module: org.eclipse.core.filesystem.win32.x86_64.nls [253]
  Unresolved requirement: Fragment-Host: org.eclipse.core.filesystem.win32.x86_64
  Unresolved requirement: Fragment-Host: org.eclipse.core.filesystem.win32.x86_64


!ENTRY org.eclipse.osgi 4 0 2018-10-08 17:24:00.824
 Ошибка приложения! MESSAGE
!STACK 1
 org.eclipse.swt.SWTException: не удалось выполнить runnable (java.lang.IllegalStateException: Workbench не был создан.)
	at org.eclipse.swt.SWT.error(SWT.java:4533)
	at org.eclipse.swt.SWT.error(SWT.java:4448)
	at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:185)
	at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4213)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3820)
	at org.eclipse.swt.widgets.Display.release(Display.java:3874)
	at org.eclipse.swt.graphics.Device.dispose(Device.java:298)
	at org.jkiss.dbeaver.core.application.DBeaverApplication.start(DBeaverApplication.java:174)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:653)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:590)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1499)
 Причина: java.lang.IllegalStateException: рабочая среда не была создана.
	at org.eclipse.ui.PlatformUI.getWorkbench(PlatformUI.java:93)
	at org.jkiss.dbeaver.core.WorkbenchContextListener.<init>(WorkbenchContextListener.java:57)
	at org.jkiss.dbeaver.core.WorkbenchContextListener.registerInWorkbench(WorkbenchContextListener.java:254)
	at org.jkiss.dbeaver.core.DBeaverUI.lambda$0(DBeaverUI.java:124)
	at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:37)
	at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:182)
	... 17 more

!ENTRY org.eclipse.e4.ui.workbench 4 0 2018-10-08 17:24:00.835
!MESSAGE FrameworkEvent ERROR
!STACK 0
java.lang.NoClassDefFoundError: javax/annotation/PreDestroy
	at org.eclipse.e4.core.internal.di.InjectorImpl.disposed(InjectorImpl.java:450)
	at org.eclipse.e4.core.internal.di.Requestor.disposed(Requestor.java:156)
	at org.eclipse.e4.core.internal.contexts.ContextObjectSupplier$ContextInjectionListener.update(ContextObjectSupplier.java:78)
	at org.eclipse.e4.core.internal.contexts.TrackableComputationExt.update(TrackableComputationExt.java:111)
	at org.eclipse.e4.core.internal.contexts.TrackableComputationExt.handleInvalid(TrackableComputationExt.java:74)
	at org.eclipse.e4.core.internal.contexts.EclipseContext.dispose(EclipseContext.java:178)
	at org.eclipse.e4.core.internal.contexts.osgi.EclipseContextOSGi.dispose(EclipseContextOSGi.java:99)
	at org.eclipse.e4.core.internal.contexts.osgi.EclipseContextOSGi.bundleChanged(EclipseContextOSGi.java:141)
	at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:908)
	at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)
	at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148)
	at org.eclipse.osgi.internal.framework.EquinoxEventPublisher.publishBundleEventPrivileged(EquinoxEventPublisher.java:213)
	at org.eclipse.osgi.internal.framework.EquinoxEventPublisher.publishBundleEvent(EquinoxEventPublisher.java:120)
	at org.eclipse.osgi.internal.framework.EquinoxEventPublisher.publishBundleEvent(EquinoxEventPublisher.java:112)
	at org.eclipse.osgi.internal.framework.EquinoxContainerAdaptor.publishModuleEvent(EquinoxContainerAdaptor.java:168)
	at org.eclipse.osgi.container.Module.publishEvent(Module.java:476)
	at org.eclipse.osgi.container.Module.doStop(Module.java:634)
	at org.eclipse.osgi.container.Module.stop(Module.java:498)
	at org.eclipse.osgi.container.SystemModule.stop(SystemModule.java:202)
	at org.eclipse.osgi.internal.framework.EquinoxBundle$SystemBundle$EquinoxSystemModule$1.run(EquinoxBundle.java:165)
	at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.lang.ClassNotFoundException: javax.annotation.PreDestroy cannot be found by org.eclipse.e4.core.di_1.6.100.v20170421-1418
	at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:433)
	at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:395)
	at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:387)
	at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:150)
	at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)
	... 21 more

Простой анализ журнала ошибок
java.version = 11 означает версию jdk, которую я использую. Недавно операционная система была обновлена ​​до jdk11. Я загрузил внешнюю версию jre dbeaver, поэтому здесь напечатана версия 11.
Информация о критических исключениях: java.lang.NoClassDefFoundError: javax / annotation / PreDestroy
PreDestroy не найден, поскольку Jdk9 начал использовать модульность. PreDestroy необходимо добавить вручную, чтобы поддержать его.
Мы переходим в корневой каталог dbeaver. Откройте dbeaver.ini

-startup
plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar
--launcher.library
plugins/org.eclipse.equinox.launcher.win32.win32.x86_64_1.1.551.v20171108-1834
-showsplash
-vmargs
-XX:+IgnoreUnrecognizedVMOptions
--add-modules=ALL-SYSTEM
-Xms64m
-Xmx1024m

Обнаружено, что в параметрах уже есть add-modules = ALL-SYSTEM или NoClassDefFoundError. Я не знаю, если dbeaver еще не совместим с jdk11, попробуйте другое решение.

Три решения

Откройте файл readme.txt в корневом каталоге dbeaver.

  -f <sql-file1 [sql-file2..]>
    Open specified SQL file(s) in SQL editor.
    This command can be used to associate SQL files with DBeaver in shell.

  -nosplash
    Do not show splash screen

  -data <path>
    Store all projects/configuration in folder <path>. By default DBeaver
	stores all its data in user's home ".dbeaver4" folder.
	<path> can be an absolute or relative directory name.
	If you want to use DBeaver as redistributable program start it
	with arguments like "dbeaver -data workspace".

  -nl locale
    Use specified locale instead of default one.
    Example: -nl en (use English locale).

  -vm <java vm path>
    Use Java VM installed in <java vm path> folder instead of default
    location.

  -vmargs <jvm parameters>
    Allows to pass any number of additional parameters to JVM.
    Additional parameters may be used to customize environment or
    3-rd party jdbc drivers.

  -clean
    Clears all Eclipse caches. Use it if DBeaver fails to start after version upgrade.

Мы используем параметр -vm, чтобы указать jdk в качестве каталога jdk8.
1. Щелкните правой кнопкой мыши файл dbeaver.exe, чтобы отправить ярлык на рабочий стол.

Укажите параметр -vm в целевой папке: D: dbeaver dbeaver.exe -vm «C: Program Files Java jdk1.8.0_45 bin»
Используйте указанный Jdk при запуске dbeaver.

dbeaver работал нормально в моей системе. Но вдруг он выдает ошибку «Смотрите файл журнала /home/system/.dbeaver/.metadata/.log». Пожалуйста, кто-нибудь может помочь мне решить эту проблему?

2

java
ubuntu-14.04
dbeaver

Источник


user4916408

06 янв ’16 в 07:02
2016-01-06 07:02

2016-01-06 07:02

1
ответ

Это может быть случай, когда jdk изменен. Попробуйте переместить JDK, если это так, из /Library/Java/JavaVirtualMachines в другое место. Это случилось со мной, когда я установил jdk11 и переместил его, решил мою проблему.

Источник


user10493326

12 окт ’18 в 05:44
2018-10-12 05:44

2018-10-12 05:44

Другие вопросы по тегам
java
ubuntu-14.04
dbeaver

I. Фон

Операционная система: win10
версия dbeaver: 5.2.2
Хороший dbeaver, который использовался внезапно, не может быть использован нормально, загрузка новой версии все еще не работает, подсказка: произошла ошибка. Смотрите файл журнала,

Два журнала ошибок

Перейдите в каталог приглашения C: \ Users \ bin.dbeaver4.metadata, чтобы просмотреть журнал ошибок .log следующим образом:

!SESSION 2018-10-08 17:23:58.845 -----------------------------------------------
eclipse.buildId=unknown
java.version=11
java.vendor=Oracle Corporation
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=zh_CN
Command-line arguments:  -os win32 -ws win32 -arch x86_64

!ENTRY org.jkiss.dbeaver.model 4 0 2018-10-08 17:24:00.778
! СООБЩЕНИЕ не создало верстак.
!STACK 0
 java.lang.IllegalStateException: рабочая среда не была создана.
	at org.eclipse.ui.PlatformUI.getWorkbench(PlatformUI.java:93)
	at org.jkiss.dbeaver.core.application.DBeaverApplication.shutdown(DBeaverApplication.java:290)
	at org.jkiss.dbeaver.core.application.DBeaverApplication.start(DBeaverApplication.java:165)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:653)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:590)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1499)

!ENTRY org.eclipse.osgi.compatibility.state.nls 2 0 2018-10-08 17:24:00.808
!MESSAGE Could not resolve module: org.eclipse.osgi.compatibility.state.nls [241]
  Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state
  Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state


!ENTRY org.eclipse.core.filesystem.win32.x86_64.nls 2 0 2018-10-08 17:24:00.809
!MESSAGE Could not resolve module: org.eclipse.core.filesystem.win32.x86_64.nls [253]
  Unresolved requirement: Fragment-Host: org.eclipse.core.filesystem.win32.x86_64
  Unresolved requirement: Fragment-Host: org.eclipse.core.filesystem.win32.x86_64


!ENTRY org.eclipse.osgi 4 0 2018-10-08 17:24:00.824
 Ошибка приложения! MESSAGE
!STACK 1
 org.eclipse.swt.SWTException: не удалось выполнить runnable (java.lang.IllegalStateException: Workbench не был создан.)
	at org.eclipse.swt.SWT.error(SWT.java:4533)
	at org.eclipse.swt.SWT.error(SWT.java:4448)
	at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:185)
	at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4213)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3820)
	at org.eclipse.swt.widgets.Display.release(Display.java:3874)
	at org.eclipse.swt.graphics.Device.dispose(Device.java:298)
	at org.jkiss.dbeaver.core.application.DBeaverApplication.start(DBeaverApplication.java:174)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:653)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:590)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1499)
 Причина: java.lang.IllegalStateException: рабочая среда не была создана.
	at org.eclipse.ui.PlatformUI.getWorkbench(PlatformUI.java:93)
	at org.jkiss.dbeaver.core.WorkbenchContextListener.<init>(WorkbenchContextListener.java:57)
	at org.jkiss.dbeaver.core.WorkbenchContextListener.registerInWorkbench(WorkbenchContextListener.java:254)
	at org.jkiss.dbeaver.core.DBeaverUI.lambda$0(DBeaverUI.java:124)
	at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:37)
	at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:182)
	... 17 more

!ENTRY org.eclipse.e4.ui.workbench 4 0 2018-10-08 17:24:00.835
!MESSAGE FrameworkEvent ERROR
!STACK 0
java.lang.NoClassDefFoundError: javax/annotation/PreDestroy
	at org.eclipse.e4.core.internal.di.InjectorImpl.disposed(InjectorImpl.java:450)
	at org.eclipse.e4.core.internal.di.Requestor.disposed(Requestor.java:156)
	at org.eclipse.e4.core.internal.contexts.ContextObjectSupplier$ContextInjectionListener.update(ContextObjectSupplier.java:78)
	at org.eclipse.e4.core.internal.contexts.TrackableComputationExt.update(TrackableComputationExt.java:111)
	at org.eclipse.e4.core.internal.contexts.TrackableComputationExt.handleInvalid(TrackableComputationExt.java:74)
	at org.eclipse.e4.core.internal.contexts.EclipseContext.dispose(EclipseContext.java:178)
	at org.eclipse.e4.core.internal.contexts.osgi.EclipseContextOSGi.dispose(EclipseContextOSGi.java:99)
	at org.eclipse.e4.core.internal.contexts.osgi.EclipseContextOSGi.bundleChanged(EclipseContextOSGi.java:141)
	at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:908)
	at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)
	at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148)
	at org.eclipse.osgi.internal.framework.EquinoxEventPublisher.publishBundleEventPrivileged(EquinoxEventPublisher.java:213)
	at org.eclipse.osgi.internal.framework.EquinoxEventPublisher.publishBundleEvent(EquinoxEventPublisher.java:120)
	at org.eclipse.osgi.internal.framework.EquinoxEventPublisher.publishBundleEvent(EquinoxEventPublisher.java:112)
	at org.eclipse.osgi.internal.framework.EquinoxContainerAdaptor.publishModuleEvent(EquinoxContainerAdaptor.java:168)
	at org.eclipse.osgi.container.Module.publishEvent(Module.java:476)
	at org.eclipse.osgi.container.Module.doStop(Module.java:634)
	at org.eclipse.osgi.container.Module.stop(Module.java:498)
	at org.eclipse.osgi.container.SystemModule.stop(SystemModule.java:202)
	at org.eclipse.osgi.internal.framework.EquinoxBundle$SystemBundle$EquinoxSystemModule$1.run(EquinoxBundle.java:165)
	at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.lang.ClassNotFoundException: javax.annotation.PreDestroy cannot be found by org.eclipse.e4.core.di_1.6.100.v20170421-1418
	at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:433)
	at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:395)
	at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:387)
	at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:150)
	at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)
	... 21 more

Простой анализ журнала ошибок
java.version = 11 означает версию jdk, которую я использую. Недавно операционная система была обновлена ​​до jdk11. Я загрузил внешнюю версию jre dbeaver, поэтому здесь напечатана версия 11.
Информация о критических исключениях: java.lang.NoClassDefFoundError: javax / annotation / PreDestroy
PreDestroy не найден, поскольку Jdk9 начал использовать модульность. PreDestroy необходимо добавить вручную, чтобы поддержать его.
Мы переходим в корневой каталог dbeaver. Откройте dbeaver.ini

-startup
plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar
--launcher.library
plugins/org.eclipse.equinox.launcher.win32.win32.x86_64_1.1.551.v20171108-1834
-showsplash
-vmargs
-XX:+IgnoreUnrecognizedVMOptions
--add-modules=ALL-SYSTEM
-Xms64m
-Xmx1024m

Обнаружено, что в параметрах уже есть add-modules = ALL-SYSTEM или NoClassDefFoundError. Я не знаю, если dbeaver еще не совместим с jdk11, попробуйте другое решение.

Три решения

Откройте файл readme.txt в корневом каталоге dbeaver.

  -f <sql-file1 [sql-file2..]>
    Open specified SQL file(s) in SQL editor.
    This command can be used to associate SQL files with DBeaver in shell.

  -nosplash
    Do not show splash screen

  -data <path>
    Store all projects/configuration in folder <path>. By default DBeaver
	stores all its data in user's home ".dbeaver4" folder.
	<path> can be an absolute or relative directory name.
	If you want to use DBeaver as redistributable program start it
	with arguments like "dbeaver -data workspace".

  -nl locale
    Use specified locale instead of default one.
    Example: -nl en (use English locale).

  -vm <java vm path>
    Use Java VM installed in <java vm path> folder instead of default
    location.

  -vmargs <jvm parameters>
    Allows to pass any number of additional parameters to JVM.
    Additional parameters may be used to customize environment or
    3-rd party jdbc drivers.

  -clean
    Clears all Eclipse caches. Use it if DBeaver fails to start after version upgrade.

Мы используем параметр -vm, чтобы указать jdk в качестве каталога jdk8.
1. Щелкните правой кнопкой мыши файл dbeaver.exe, чтобы отправить ярлык на рабочий стол.

Укажите параметр -vm в целевой папке: D: \ dbeaver \ dbeaver.exe -vm «C: \ Program Files \ Java \ jdk1.8.0_45 \ bin»
Используйте указанный Jdk при запуске dbeaver.

[SOLVED 2022] DBeaver Communication link failure

DBeaver SQL Client

Are you having trouble connecting to a local MySQL database through DBeaver Community Edition? DBeaver fails to connect to a local MySQL database with the error “Communication link failure the last packet sent successfully to the server was 0 milliseconds ago“.

Here is a breakdown of this page:

  • Introduction
  • Solution
  • MySQL Configuration File
    • Location on macOS
    • Location on Linux
    • Location on Windows
  • Setting the MySQL port
  • Restarting MySQL
    • Restart MySQL on macOS
    • Restart MySQL on Linux
    • Restart MySQL on Windows

Introduction

The problem isn’t with DBeaver, in fact, if you installed another MySQL GUI tool, this issue would still occur.

This error occurs when the port used by MySQL is busy. To fix the communication link failure in DBeaver, we need to assign a port to MySQL.

In the solution below I used a Linux machine running Ubuntu 20.04 and verified using a Windows machine running Ubuntu 18.04 through WSL2 (Windows Subsystem for Linux).

Where possible I have provided alternative methods for both macOS and Windows.

This post also assumes you already have the correct database drivers installed and have created the MySQL connection.

DBeaver Communication Link Failure

Solution – Fixing communication link failure in DBeaver

First, you will need to locate your my.cnf file.

The my.cnf file is the configuration file used by MySQL. This MYSQL configuration file can reside in different locations, depending on your system and how it was installed.

Below are some locations where your installation’s my.conf could be for different operating systems.

Location of MySQL my.cnf file on MacOS or Linux

On macOS and Linux, you can find the MySQL configuration file in either the users home directory or within the /etc directory.

  • ~/.my.cnf
  • /etc/my.cnf

Location of MySQL my.cnf file on Windows

On a Windows machine, the MySQL configuration file can be in either the Windows directory or the root of the C drive.

In some cases, the my.cnf file can actually be a ini file, like so:

  • C:\Windows\my.ini
  • C:\Windows\my.cnf
  • C:\my.ini
  • C:\my.cnf

Once you have located the file, open it with your preferred editor. I will be using Nano.

nano /etc/mysql/my.cnf

You may need to append sudo to the command if you require higher security privileges.

Edit MySQL cnf file

Once you have opened the file using an editor, go to the bottom of the file and add the following configuration:

[mysqld]
port=3306 # or any other port
bind-address=0.0.0.0

Set the port to a port you know is open and not in use. By default, MySQL uses port 3306, but you can change this to another open port if required.

Save the file using Ctrl+O.

Now restart MySQL, there are multiple ways to do this, depending on your environment.

Restart MySQL on macOS or Linux

/etc/init.d/mysqld restart
# or 
systemctl restart mysqld

Restart MySQL on Windows

  • Open ‘Run’ by using Win key + R
  • Type ‘services.msc’
  • Now search for MySQL based on the version that is installed.
  • Click on ‘restart

If you found this post useful, check out how to Create SSH Connections in DBeaver.

Did this solution work for you? Leave a comment with your results.

I use DBeaver to watch an SQL database on MySQL 8+.

Everything is working, but sometimes, opening DBeaver, I have the following error message :

Public Key Retrieval is not allowed

And then, DBeaver can’t connect to MySQL.

In order to fix this problem, I have to reconfigure MySQL.

Is there any simplest way to fix this problem ?

Manuel Jordan's user avatar

Manuel Jordan

15.3k21 gold badges95 silver badges159 bronze badges

asked May 12, 2020 at 10:24

Alex Dana's user avatar

2

Change the settings on Dbeaver:

  1. Right click your connection, choose Edit Connection
  2. On the Connection settings screen (main screen) click on Edit Driver Settings
    enter image description here
  3. Click on Connection properties
  4. Right click the User Properties area and choose Add new property
  5. Add two properties: useSSL and allowPublicKeyRetrieval
    enter image description here
  6. Set their values to false and true respectively by double clicking on the value column
  7. Save and test the connection.

Hopefully it should work!

Manuel Jordan's user avatar

Manuel Jordan

15.3k21 gold badges95 silver badges159 bronze badges

answered May 21, 2020 at 17:02

Ratish Bansal's user avatar

Ratish BansalRatish Bansal

1,9921 gold badge10 silver badges19 bronze badges

6

Edit Connection

click second tab Driver Properties

Change property allowPublicKeyRetrieval to True

Connection settings or Driver properties:

enter image description here

Manuel Jordan's user avatar

Manuel Jordan

15.3k21 gold badges95 silver badges159 bronze badges

answered Mar 8, 2021 at 18:00

OxaCyber's user avatar

OxaCyberOxaCyber

4415 silver badges3 bronze badges

Did you try explicitly allowing public key retrieval in DBeaver?
In the connection settings, SSL tab you can find it

enter image description here

This is in case you are using SSL, otherwise in the same screen you can disable SSL by unchecking «use SSL» and «require SSL»

answered May 16, 2020 at 6:37

Carlos Robles's user avatar

Carlos RoblesCarlos Robles

10.8k3 gold badges41 silver badges60 bronze badges

0

Ratish Bansal’s solution works for me on MacOS Mojave, and after that, I always get a timezone error. The solution for that is to set my local timezone in the connection settings:

enter image description here

answered Jun 2, 2020 at 22:31

agm1984's user avatar

agm1984agm1984

15.6k6 gold badges91 silver badges113 bronze badges

Понравилась статья? Поделить с друзьями:
  • Возникла ошибка пожалуйста попробуйте еще раз crunchyroll
  • Возникла ошибка подключения камеры trueconf 1072875772
  • Возникла ошибка подключения к игровым серверам vikings
  • Возникла ошибка при обновлении облиго sap
  • Возникла ошибка повторите попытку позже tinder 42901