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 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
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 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
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 | ||||||||||||||||||
|
Типичные ошибки 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…
asked Sep 15, 2021 at 3:14
0
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
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
.
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.
answered Apr 22, 2022 at 9:01
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 MLee M
3842 silver badges10 bronze badges
0
I think, just turn on the «Show line numbers» in preferences
answered Nov 26, 2021 at 15:41
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…
asked Sep 15, 2021 at 3:14
0
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
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
.
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.
answered Apr 22, 2022 at 9:01
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 MLee M
3842 silver badges10 bronze badges
0
I think, just turn on the «Show line numbers» in preferences
answered Nov 26, 2021 at 15:41
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 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
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
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.
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
15.3k21 gold badges95 silver badges159 bronze badges
asked May 12, 2020 at 10:24
2
Change the settings on Dbeaver
:
- Right click your connection, choose
Edit Connection
- On the
Connection settings
screen (main screen) click onEdit Driver Settings
- Click on
Connection properties
- Right click the
User Properties
area and chooseAdd new property
- Add two properties:
useSSL
andallowPublicKeyRetrieval
- Set their values to
false
andtrue
respectively by double clicking on thevalue
column - Save and test the connection.
Hopefully it should work!
Manuel Jordan
15.3k21 gold badges95 silver badges159 bronze badges
answered May 21, 2020 at 17:02
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
:
Manuel Jordan
15.3k21 gold badges95 silver badges159 bronze badges
answered Mar 8, 2021 at 18:00
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
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 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
:
answered Jun 2, 2020 at 22:31
agm1984agm1984
15.6k6 gold badges91 silver badges113 bronze badges