Uncaught exception occurred in Thread[#42,JavaFX Applicaiton Thread,5,main]

TellAnAx · June 4, 2024, 9:35am

Hi there,

I connected to a PostgreSQL database via JabRef and made some changes that were somehow not synchronized with the database. Eventually, the connection broke and now I receive the error mentioned in the title when trying to reconnect (addition: the error message also tells me “in input string ‘keywords’”).

I tried to update JabRef (now running v5.13) and also Java (now v8 Update 411). My machine runs Windows 11 Pro (v23H2).

Any idea how to fix this?

Thanks in advance!

Siedlerchr · June 4, 2024, 9:49am

Hi,

do you have the full stack trace available?
(JabRef ships with itsn own version of java)

TellAnAx · June 4, 2024, 10:34am

Hi there,

the full stacktrace is as follows.

java.lang.NumberFormatException: For input string: "keywords"
	at java.base/java.lang.NumberFormatException.forInputString(Unknown Source)
	at java.base/java.lang.Integer.parseInt(Unknown Source)
	at java.base/java.lang.Integer.parseInt(Unknown Source)
	at org.jabref@5.13.60000/org.jabref.logic.importer.util.GroupsParser.keywordGroupFromString(Unknown Source)
	at org.jabref@5.13.60000/org.jabref.logic.importer.util.GroupsParser.fromString(Unknown Source)
	at org.jabref@5.13.60000/org.jabref.logic.importer.util.GroupsParser.importGroups(Unknown Source)
	at org.jabref@5.13.60000/org.jabref.logic.importer.util.MetaDataParser.parse(Unknown Source)
	at org.jabref@5.13.60000/org.jabref.logic.shared.DBMSSynchronizer.synchronizeLocalMetaData(Unknown Source)
	at org.jabref@5.13.60000/org.jabref.logic.shared.DBMSSynchronizer.initializeDatabases(Unknown Source)
	at org.jabref@5.13.60000/org.jabref.logic.shared.DBMSSynchronizer.openSharedDatabase(Unknown Source)
	at org.jabref@5.13.60000/org.jabref.gui.shared.SharedDatabaseUIManager.openNewSharedDatabaseTab(Unknown Source)
	at org.jabref@5.13.60000/org.jabref.gui.shared.SharedDatabaseLoginDialogViewModel.openSharedDatabase(Unknown Source)
	at org.jabref@5.13.60000/org.jabref.gui.shared.SharedDatabaseLoginDialogViewModel.openDatabase(Unknown Source)
	at org.jabref@5.13.60000/org.jabref.gui.shared.SharedDatabaseLoginDialogView.openDatabase(Unknown Source)
	at org.jabref@5.13.60000/org.jabref.gui.shared.SharedDatabaseLoginDialogView.lambda$new$0(Unknown Source)
	at org.jabref@5.13.60000/org.jabref.gui.util.ControlHelper.lambda$setAction$0(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.CompositeEventHandler$NormalEventFilterRecord.handleCapturingEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.CompositeEventHandler.dispatchCapturingEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventHandlerManager.dispatchCapturingEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventHandlerManager.dispatchCapturingEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.CompositeEventDispatcher.dispatchCapturingEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventUtil.fireEventImpl(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventUtil.fireEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/javafx.event.Event.fireEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/javafx.scene.Node.fireEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/javafx.scene.control.Button.fire(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.scene.control.inputmap.InputMap.handle(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventUtil.fireEventImpl(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventUtil.fireEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/javafx.event.Event.fireEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/javafx.scene.Scene$MouseHandler.process(Unknown Source)
	at org.jabref.merged.module@5.13.60000/javafx.scene.Scene.processMouseEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/javafx.scene.Scene$ScenePeerListener.mouseEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(Unknown Source)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$2(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.glass.ui.View.handleMouseEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.glass.ui.View.notifyMouse(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.glass.ui.win.WinApplication._enterNestedEventLoopImpl(Native Method)
	at org.jabref.merged.module@5.13.60000/com.sun.glass.ui.win.WinApplication._enterNestedEventLoop(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.glass.ui.Application.enterNestedEventLoop(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.glass.ui.EventLoop.enter(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.tk.quantum.QuantumToolkit.enterNestedEventLoop(Unknown Source)
	at org.jabref.merged.module@5.13.60000/javafx.stage.Stage.showAndWait(Unknown Source)
	at org.jabref.merged.module@5.13.60000/javafx.scene.control.HeavyweightDialog.showAndWait(Unknown Source)
	at org.jabref.merged.module@5.13.60000/javafx.scene.control.Dialog.showAndWait(Unknown Source)
	at org.jabref@5.13.60000/org.jabref.gui.JabRefDialogService.showCustomDialogAndWait(Unknown Source)
	at org.jabref@5.13.60000/org.jabref.gui.shared.ConnectToSharedDatabaseCommand.execute(Unknown Source)
	at org.jabref@5.13.60000/org.jabref.gui.actions.JabRefAction.lambda$new$3(Unknown Source)
	at org.jabref.merged.module@5.13.60000/org.controlsfx.control.action.Action.handle(Unknown Source)
	at org.jabref.merged.module@5.13.60000/org.controlsfx.control.action.Action.handle(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventUtil.fireEventImpl(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventUtil.fireEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/javafx.event.Event.fireEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/javafx.scene.control.MenuItem.fire(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.scene.control.ContextMenuContent$MenuItemContainer.doSelect(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.scene.control.ContextMenuContent$MenuItemContainer.lambda$createChildren$12(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventUtil.fireEventImpl(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.event.EventUtil.fireEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/javafx.event.Event.fireEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/javafx.scene.Scene$MouseHandler.process(Unknown Source)
	at org.jabref.merged.module@5.13.60000/javafx.scene.Scene.processMouseEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/javafx.scene.Scene$ScenePeerListener.mouseEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(Unknown Source)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$2(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.glass.ui.View.handleMouseEvent(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.glass.ui.View.notifyMouse(Unknown Source)
	at org.jabref.merged.module@5.13.60000/com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
	at org.jabref.merged.module@5.13.60000/com.sun.glass.ui.win.WinApplication.lambda$runLoop$3(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)

Siedlerchr · June 4, 2024, 4:33pm

Do you have a local copy of the bib file because it seems like there is something wrong with the groups format which are stored at the end of the file. Especially a keyword group seems to be the problem here. There is probably one character off.

TellAnAx · June 7, 2024, 1:34pm

Yes, I have a copy of it. I tried to remove all keyword groups from the DB to see if it works but the error persists. Could it help if I deleted the grouping field entirely or will that likely cause an error?

TellAnAx · June 12, 2024, 7:43am

I tried to remove all groups in the meantime but the error persists. Interestingly, I only get the error on two computers (macOS, MS Windows) while everything works just fine on my third computer (macOS). Any idea how to possibly fix this without setting up the DB again?

Siedlerchr · June 15, 2024, 9:22am

When it works fine on your third computer, modify the groups .e.g just changing icon or color should be enough and let JabRef sync again then it should update the metadata.
All other clients need to reopen the library (switching between two libraries should be enough=

TellAnAx · July 7, 2024, 10:44am

Turns out my issue is related to this one:

github.com/JabRef/jabref

Exception occurred after connecting to shared database suggesting a duplicate entry

opened 12:22PM - 06 Sep 23 UTC

closed 03:43PM - 16 Oct 23 UTC

ArnaudAcoucite

shared-database

### JabRef version 5.10 (latest release) ### Operating system Windows ### De…tails on version and operating system Windows 11 pro 64bit Version 22H2 Built 22621.2134 ### Checked with the latest development build (copy version output from About dialog) - [X] I made a backup of my libraries before testing the latest development version. - [X] I have tested the latest development version and the problem persists ### Steps to reproduce the behaviour 1. Open JabRef 2. Connect to shared database 3. Fill required information 4. Click on Connect 5. An exception is thrown ![Capture d'écran 2023-09-06 140708](https://github.com/JabRef/jabref/assets/87969978/2ce6c937-eb94-4d4c-9eba-27ba936f0aae) ### Appendix Following the error message, we checked the tables JABREF_ENTRY and ENTRY on DBeaver but didn't find a duplicate entry. <details> <summary>Log File</summary> ``` 2023-09-06 14:02:43 [JavaFX Application Thread] org.jabref.gui.StateManager.setActiveDatabase() INFO: No open database detected 2023-09-06 14:02:43 [JavaFX Application Thread] org.jabref.gui.theme.ThemeManager.updateThemeSettings() INFO: Not updating theme because it hasn't changed 2023-09-06 14:02:43 [JavaFX Application Thread] org.jabref.gui.theme.ThemeManager.updateThemeSettings() INFO: Theme set to Theme{type=DEFAULT, name=''} with base css StyleSheet{jrt:/org.jabref/org/jabref/gui/Base.css} 2023-09-06 14:04:12 [JavaFX Application Thread] org.jabref.logic.shared.DBMSSynchronizer.initializeDatabases() INFO: Integrity check failed. Fixing... 2023-09-06 14:04:12 [JavaFX Application Thread] org.jabref.logic.shared.MySQLProcessor.setUp() WARN: [VERSION_DB_STRUCT_DEFAULT] not Integer! 2023-09-06 14:04:12 [JavaFX Application Thread] org.jabref.logic.shared.MySQLProcessor.setUp() INFO: Migrating from VersionDBStructure == 0 2023-09-06 14:04:12 [JavaFX Application Thread] org.jabref.logic.shared.DBMSSynchronizer.initializeDatabases() ERROR: Could not check intergrity: java.sql.SQLIntegrityConstraintViolationException: (conn=4421) Duplicate entry '2' for key 'PRIMARY' at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(Unknown Source) at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(Unknown Source) at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(Unknown Source) at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.MariaDbStatement.executeInternal(Unknown Source) at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.MariaDbStatement.executeUpdate(Unknown Source) at org.jabref@5.10.60000/org.jabref.logic.shared.MySQLProcessor.setUp(Unknown Source) at org.jabref@5.10.60000/org.jabref.logic.shared.DBMSProcessor.setupSharedDatabase(Unknown Source) at org.jabref@5.10.60000/org.jabref.logic.shared.DBMSSynchronizer.initializeDatabases(Unknown Source) at org.jabref@5.10.60000/org.jabref.logic.shared.DBMSSynchronizer.openSharedDatabase(Unknown Source) at org.jabref@5.10.60000/org.jabref.gui.shared.SharedDatabaseUIManager.openNewSharedDatabaseTab(Unknown Source) at org.jabref@5.10.60000/org.jabref.gui.shared.SharedDatabaseLoginDialogViewModel.openSharedDatabase(Unknown Source) at org.jabref@5.10.60000/org.jabref.gui.shared.SharedDatabaseLoginDialogViewModel.openDatabase(Unknown Source) at org.jabref@5.10.60000/org.jabref.gui.shared.SharedDatabaseLoginDialogView.openDatabase(Unknown Source) at org.jabref@5.10.60000/org.jabref.gui.shared.SharedDatabaseLoginDialogView.lambda$new$0(Unknown Source) at org.jabref@5.10.60000/org.jabref.gui.util.ControlHelper.lambda$setAction$0(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventHandler$NormalEventFilterRecord.handleCapturingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventHandler.dispatchCapturingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventHandlerManager.dispatchCapturingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventHandlerManager.dispatchCapturingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventDispatcher.dispatchCapturingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventUtil.fireEventImpl(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventUtil.fireEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.event.Event.fireEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.Node.fireEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.control.Button.fire(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.scene.control.inputmap.InputMap.handle(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventUtil.fireEventImpl(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventUtil.fireEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.event.Event.fireEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.Scene$MouseHandler.process(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.Scene.processMouseEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.Scene$ScenePeerListener.mouseEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(Unknown Source) at java.base/java.security.AccessController.doPrivileged(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$2(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.View.handleMouseEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.View.notifyMouse(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.win.WinApplication._enterNestedEventLoopImpl(Native Method) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.win.WinApplication._enterNestedEventLoop(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.Application.enterNestedEventLoop(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.EventLoop.enter(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.QuantumToolkit.enterNestedEventLoop(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.stage.Stage.showAndWait(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.control.HeavyweightDialog.showAndWait(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.control.Dialog.showAndWait(Unknown Source) at org.jabref@5.10.60000/org.jabref.gui.JabRefDialogService.showCustomDialogAndWait(Unknown Source) at org.jabref@5.10.60000/org.jabref.gui.shared.ConnectToSharedDatabaseCommand.execute(Unknown Source) at org.jabref@5.10.60000/org.jabref.gui.actions.JabRefAction.lambda$new$3(Unknown Source) at org.jabref.merged.module@5.10.60000/org.controlsfx.control.action.Action.handle(Unknown Source) at org.jabref.merged.module@5.10.60000/org.controlsfx.control.action.Action.handle(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventUtil.fireEventImpl(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventUtil.fireEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.event.Event.fireEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.control.MenuItem.fire(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.scene.control.ContextMenuContent$MenuItemContainer.doSelect(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.scene.control.ContextMenuContent$MenuItemContainer.lambda$createChildren$12(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventUtil.fireEventImpl(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventUtil.fireEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.event.Event.fireEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.Scene$MouseHandler.process(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.Scene.processMouseEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.Scene$ScenePeerListener.mouseEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(Unknown Source) at java.base/java.security.AccessController.doPrivileged(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$2(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.View.handleMouseEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.View.notifyMouse(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.win.WinApplication._runLoop(Native Method) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.win.WinApplication.lambda$runLoop$3(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Duplicate entry '2' for key 'PRIMARY' at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(Unknown Source) at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(Unknown Source) at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(Unknown Source) ... 113 more Caused by: java.sql.SQLException: Duplicate entry '2' for key 'PRIMARY' at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(Unknown Source) at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(Unknown Source) at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(Unknown Source) ... 114 more 2023-09-06 14:04:12 [JavaFX Application Thread] org.jabref.gui.FallbackExceptionHandler.uncaughtException() ERROR: Uncaught exception occurred in Thread[#35,JavaFX Application Thread,5,main]: java.lang.IllegalStateException: java.sql.SQLIntegrityConstraintViolationException: (conn=4421) Duplicate entry '2' for key 'PRIMARY' at org.jabref@5.10.60000/org.jabref.logic.shared.DBMSSynchronizer.initializeDatabases(Unknown Source) at org.jabref@5.10.60000/org.jabref.logic.shared.DBMSSynchronizer.openSharedDatabase(Unknown Source) at org.jabref@5.10.60000/org.jabref.gui.shared.SharedDatabaseUIManager.openNewSharedDatabaseTab(Unknown Source) at org.jabref@5.10.60000/org.jabref.gui.shared.SharedDatabaseLoginDialogViewModel.openSharedDatabase(Unknown Source) at org.jabref@5.10.60000/org.jabref.gui.shared.SharedDatabaseLoginDialogViewModel.openDatabase(Unknown Source) at org.jabref@5.10.60000/org.jabref.gui.shared.SharedDatabaseLoginDialogView.openDatabase(Unknown Source) at org.jabref@5.10.60000/org.jabref.gui.shared.SharedDatabaseLoginDialogView.lambda$new$0(Unknown Source) at org.jabref@5.10.60000/org.jabref.gui.util.ControlHelper.lambda$setAction$0(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventHandler$NormalEventFilterRecord.handleCapturingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventHandler.dispatchCapturingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventHandlerManager.dispatchCapturingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventHandlerManager.dispatchCapturingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventDispatcher.dispatchCapturingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventUtil.fireEventImpl(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventUtil.fireEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.event.Event.fireEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.Node.fireEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.control.Button.fire(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.scene.control.inputmap.InputMap.handle(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventUtil.fireEventImpl(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventUtil.fireEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.event.Event.fireEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.Scene$MouseHandler.process(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.Scene.processMouseEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.Scene$ScenePeerListener.mouseEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(Unknown Source) at java.base/java.security.AccessController.doPrivileged(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$2(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.View.handleMouseEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.View.notifyMouse(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.win.WinApplication._enterNestedEventLoopImpl(Native Method) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.win.WinApplication._enterNestedEventLoop(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.Application.enterNestedEventLoop(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.EventLoop.enter(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.QuantumToolkit.enterNestedEventLoop(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.stage.Stage.showAndWait(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.control.HeavyweightDialog.showAndWait(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.control.Dialog.showAndWait(Unknown Source) at org.jabref@5.10.60000/org.jabref.gui.JabRefDialogService.showCustomDialogAndWait(Unknown Source) at org.jabref@5.10.60000/org.jabref.gui.shared.ConnectToSharedDatabaseCommand.execute(Unknown Source) at org.jabref@5.10.60000/org.jabref.gui.actions.JabRefAction.lambda$new$3(Unknown Source) at org.jabref.merged.module@5.10.60000/org.controlsfx.control.action.Action.handle(Unknown Source) at org.jabref.merged.module@5.10.60000/org.controlsfx.control.action.Action.handle(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventUtil.fireEventImpl(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventUtil.fireEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.event.Event.fireEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.control.MenuItem.fire(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.scene.control.ContextMenuContent$MenuItemContainer.doSelect(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.scene.control.ContextMenuContent$MenuItemContainer.lambda$createChildren$12(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventUtil.fireEventImpl(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.event.EventUtil.fireEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.event.Event.fireEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.Scene$MouseHandler.process(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.Scene.processMouseEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/javafx.scene.Scene$ScenePeerListener.mouseEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(Unknown Source) at java.base/java.security.AccessController.doPrivileged(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$2(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.View.handleMouseEvent(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.View.notifyMouse(Unknown Source) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.win.WinApplication._runLoop(Native Method) at org.jabref.merged.module@5.10.60000/com.sun.glass.ui.win.WinApplication.lambda$runLoop$3(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLIntegrityConstraintViolationException: (conn=4421) Duplicate entry '2' for key 'PRIMARY' at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(Unknown Source) at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(Unknown Source) at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(Unknown Source) at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.MariaDbStatement.executeInternal(Unknown Source) at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.MariaDbStatement.executeUpdate(Unknown Source) at org.jabref@5.10.60000/org.jabref.logic.shared.MySQLProcessor.setUp(Unknown Source) at org.jabref@5.10.60000/org.jabref.logic.shared.DBMSProcessor.setupSharedDatabase(Unknown Source) ... 109 more Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Duplicate entry '2' for key 'PRIMARY' at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(Unknown Source) at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(Unknown Source) at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(Unknown Source) ... 113 more Caused by: java.sql.SQLException: Duplicate entry '2' for key 'PRIMARY' at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(Unknown Source) at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(Unknown Source) at org.jabref.merged.module@5.10.60000/org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(Unknown Source) ... 114 more ``` </details>

The most recent JabRef version that works without any flaws (until now) with regards to the database connection is 5.8. I tested all JabRef versions from 5.9 to 5.13 (on macOS for Intel) and always end up with the following error after adding groups (removal of the group/directly connecting without saving a local copy doesn’t help):

java.lang.NumberFormatException: For input string: "1"
	at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:67)
	at java.base/java.lang.Integer.parseInt(Integer.java:647)
	at java.base/java.lang.Integer.parseInt(Integer.java:777)
	at org.jabref@5.12.60000/org.jabref.logic.shared.DBMSProcessor.checkBaseIntegrity(DBMSProcessor.java:65)
	at org.jabref@5.12.60000/org.jabref.logic.shared.DBMSSynchronizer.initializeDatabases(DBMSSynchronizer.java:143)
	at org.jabref@5.12.60000/org.jabref.logic.shared.DBMSSynchronizer.openSharedDatabase(DBMSSynchronizer.java:384)
	at org.jabref@5.12.60000/org.jabref.gui.shared.SharedDatabaseUIManager.openNewSharedDatabaseTab(SharedDatabaseUIManager.java:170)
	at org.jabref@5.12.60000/org.jabref.gui.shared.SharedDatabaseLoginDialogViewModel.openSharedDatabase(SharedDatabaseLoginDialogViewModel.java:192)
	at org.jabref@5.12.60000/org.jabref.gui.shared.SharedDatabaseLoginDialogViewModel.openDatabase(SharedDatabaseLoginDialogViewModel.java:150)
	at org.jabref@5.12.60000/org.jabref.gui.shared.SharedDatabaseLoginDialogView.openDatabase(SharedDatabaseLoginDialogView.java:80)
	at org.jabref@5.12.60000/org.jabref.gui.shared.SharedDatabaseLoginDialogView.lambda$new$0(SharedDatabaseLoginDialogView.java:71)
	at org.jabref@5.12.60000/org.jabref.gui.util.ControlHelper.lambda$setAction$0(ControlHelper.java:29)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.CompositeEventHandler$NormalEventFilterRecord.handleCapturingEvent(CompositeEventHandler.java:321)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.CompositeEventHandler.dispatchCapturingEvent(CompositeEventHandler.java:98)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventHandlerManager.dispatchCapturingEvent(EventHandlerManager.java:219)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventHandlerManager.dispatchCapturingEvent(EventHandlerManager.java:178)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.CompositeEventDispatcher.dispatchCapturingEvent(CompositeEventDispatcher.java:43)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:52)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
	at org.jabref.merged.module@5.12.60000/javafx.event.Event.fireEvent(Event.java:198)
	at org.jabref.merged.module@5.12.60000/javafx.scene.Node.fireEvent(Node.java:8875)
	at org.jabref.merged.module@5.12.60000/javafx.scene.control.Button.fire(Button.java:203)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:207)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.scene.control.inputmap.InputMap.handle(InputMap.java:274)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:247)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:232)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:189)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
	at org.jabref.merged.module@5.12.60000/javafx.event.Event.fireEvent(Event.java:198)
	at org.jabref.merged.module@5.12.60000/javafx.scene.Scene$MouseHandler.process(Scene.java:3984)
	at org.jabref.merged.module@5.12.60000/javafx.scene.Scene.processMouseEvent(Scene.java:1890)
	at org.jabref.merged.module@5.12.60000/javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2708)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:411)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:301)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:400)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$2(GlassViewEventHandler.java:450)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:424)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:449)
	at org.jabref.merged.module@5.12.60000/com.sun.glass.ui.View.handleMouseEvent(View.java:551)
	at org.jabref.merged.module@5.12.60000/com.sun.glass.ui.View.notifyMouse(View.java:937)
	at org.jabref.merged.module@5.12.60000/com.sun.glass.ui.mac.MacView.notifyMouse(MacView.java:127)
	at org.jabref.merged.module@5.12.60000/com.sun.glass.ui.mac.MacApplication._enterNestedEventLoopImpl(Native Method)
	at org.jabref.merged.module@5.12.60000/com.sun.glass.ui.mac.MacApplication._enterNestedEventLoop(MacApplication.java:168)
	at org.jabref.merged.module@5.12.60000/com.sun.glass.ui.Application.enterNestedEventLoop(Application.java:515)
	at org.jabref.merged.module@5.12.60000/com.sun.glass.ui.EventLoop.enter(EventLoop.java:107)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.tk.quantum.QuantumToolkit.enterNestedEventLoop(QuantumToolkit.java:650)
	at org.jabref.merged.module@5.12.60000/javafx.stage.Stage.showAndWait(Stage.java:469)
	at org.jabref.merged.module@5.12.60000/javafx.scene.control.HeavyweightDialog.showAndWait(HeavyweightDialog.java:162)
	at org.jabref.merged.module@5.12.60000/javafx.scene.control.Dialog.showAndWait(Dialog.java:346)
	at org.jabref@5.12.60000/org.jabref.gui.JabRefDialogService.showCustomDialogAndWait(JabRefDialogService.java:273)
	at org.jabref@5.12.60000/org.jabref.gui.shared.ConnectToSharedDatabaseCommand.execute(ConnectToSharedDatabaseCommand.java:23)
	at org.jabref@5.12.60000/org.jabref.gui.actions.JabRefAction.lambda$new$3(JabRefAction.java:40)
	at org.jabref.merged.module@5.12.60000/org.controlsfx.control.action.Action.handle(Action.java:423)
	at org.jabref.merged.module@5.12.60000/org.controlsfx.control.action.Action.handle(Action.java:64)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:232)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:189)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
	at org.jabref.merged.module@5.12.60000/javafx.event.Event.fireEvent(Event.java:198)
	at org.jabref.merged.module@5.12.60000/javafx.scene.control.MenuItem.fire(MenuItem.java:459)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.scene.control.GlobalMenuAdapter.lambda$bindMenuItemProperties$2(GlobalMenuAdapter.java:150)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:232)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:189)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
	at org.jabref.merged.module@5.12.60000/javafx.event.Event.fireEvent(Event.java:198)
	at org.jabref.merged.module@5.12.60000/javafx.scene.control.MenuItem.fire(MenuItem.java:459)
	at org.jabref.merged.module@5.12.60000/com.sun.javafx.tk.quantum.GlassSystemMenu$1.action(GlassSystemMenu.java:237)

Siedlerchr · July 8, 2024, 2:04pm

The error seems to indicate that something with the VersionDbStructure field is not correct

Can you post the contents of the field metadata in the database?

e.g. execute the query wit PGAdmin
SELECT * FROM jabref.“METADATA”
LIMIT 100
it should look similar to this:

TellAnAx · July 9, 2024, 12:54pm

Hi,
this is what it looks like on my end.

TellAnAx · July 9, 2024, 12:58pm

…and this

Siedlerchr · July 10, 2024, 9:58am

Can you edit the field VersionDbStructure to only contain 1;

Topic		Replies	Views
Uncaught exception occured in Thread[#33,JavaFX Appliaction Thread,5,main] Help	13	251	April 25, 2024
Problem - uncaught exception occurred in thread Help	1	726	April 23, 2023
Random "uncaught error" appears in JabRef 5.9 Help	7	747	June 8, 2023
Error returning on attempt to do a websearch Help	1	482	September 6, 2022
Disturbing Java Error in jabref Help	1	658	August 18, 2020

Uncaught exception occurred in Thread[#42,JavaFX Applicaiton Thread,5,main]

Related topics