JabRef 5.1--ArchLinux--1, Linux 5.8.10-arch1-1 amd64, Java 14.0.2
I have tested the latest development version from http://builds.jabref.org/master/ and the problem persists:
Dev Version tested:
JabRef 5.2--2020-09-24--75b6770, Linux 5.8.10-arch1-1 amd64, Java 15
(The same problem exists with the latest MAC Version)
Databases tested:
PostgreSQL 12 (local)
PostgreSQL instance from elephantsql
MariaDB 10.1.40 (remote)
After successful connection to an empty Database the tables are created as expected but any entries made in JabRef are not being synced. The input of a new entry instead immedeatly results in the errors attached bellow.
Interesstingly when importing an existing library to the shared database the entries are created as expected.
Steps to reproduce the behaviour:
- Set up a database and connect to it in JabRef
- Add some Entry in JabRef
ps Thank you for all the great work!
pps Sorry if I should have missed something obvious and stupid.
Log File
Connection to PostgreSQL server established.
Enabling live reloading of /usr/share/java/jabref/resources/main/org/jabref/gui/Base.css
Enabling live reloading of /usr/share/java/jabref/resources/main/org/jabref/gui/Dark.css
SQL Error:
org.postgresql.util.PSQLException: No value specified for parameter 1.
at org.postgresql.jdbc@42.2.16/org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:275)
at org.postgresql.jdbc@42.2.16/org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:307)
at org.postgresql.jdbc@42.2.16/org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473)
at org.postgresql.jdbc@42.2.16/org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393)
at org.postgresql.jdbc@42.2.16/org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164)
at org.postgresql.jdbc@42.2.16/org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130)
at org.jabref@5.1/org.jabref.logic.shared.DBMSProcessor.insertIntoFieldTable(DBMSProcessor.java:274)
at org.jabref@5.1/org.jabref.logic.shared.DBMSProcessor.insertEntries(DBMSProcessor.java:155)
at org.jabref@5.1/org.jabref.logic.shared.DBMSSynchronizer.listen(DBMSSynchronizer.java:85)
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:564)
at com.google.common@29.0-jre/com.google.common.eventbus.Subscriber.invokeSubscriberMethod(Subscriber.java:87)
at com.google.common@29.0-jre/com.google.common.eventbus.Subscriber$SynchronizedSubscriber.invokeSubscriberMethod(Subscriber.java:144)
at com.google.common@29.0-jre/com.google.common.eventbus.Subscriber$1.run(Subscriber.java:72)
at com.google.common@29.0-jre/com.google.common.util.concurrent.DirectExecutor.execute(DirectExecutor.java:30)
at com.google.common@29.0-jre/com.google.common.eventbus.Subscriber.dispatchEvent(Subscriber.java:67)
at com.google.common@29.0-jre/com.google.common.eventbus.Dispatcher$PerThreadQueuedDispatcher.dispatch(Dispatcher.java:108)
at com.google.common@29.0-jre/com.google.common.eventbus.EventBus.post(EventBus.java:212)
at org.jabref@5.1/org.jabref.model.database.event.CoarseChangeFilter.listen(CoarseChangeFilter.java:29)
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:564)
at com.google.common@29.0-jre/com.google.common.eventbus.Subscriber.invokeSubscriberMethod(Subscriber.java:87)
at com.google.common@29.0-jre/com.google.common.eventbus.Subscriber$SynchronizedSubscriber.invokeSubscriberMethod(Subscriber.java:144)
at com.google.common@29.0-jre/com.google.common.eventbus.Subscriber$1.run(Subscriber.java:72)
at com.google.common@29.0-jre/com.google.common.util.concurrent.DirectExecutor.execute(DirectExecutor.java:30)
at com.google.common@29.0-jre/com.google.common.eventbus.Subscriber.dispatchEvent(Subscriber.java:67)
at com.google.common@29.0-jre/com.google.common.eventbus.Dispatcher$PerThreadQueuedDispatcher.dispatch(Dispatcher.java:108)
at com.google.common@29.0-jre/com.google.common.eventbus.EventBus.post(EventBus.java:212)
at org.jabref@5.1/org.jabref.model.database.BibDatabase.insertEntries(BibDatabase.java:206)
at org.jabref@5.1/org.jabref.model.database.BibDatabase.insertEntries(BibDatabase.java:195)
at org.jabref@5.1/org.jabref.gui.BasePanel.insertEntries(BasePanel.java:254)
at org.jabref@5.1/org.jabref.gui.BasePanel.insertEntry(BasePanel.java:240)
at org.jabref@5.1/org.jabref.gui.importer.NewEntryAction.execute(NewEntryAction.java:57)
at org.jabref@5.1/org.jabref.gui.actions.JabRefAction.lambda$new$2(JabRefAction.java:41)
at org.controlsfx.controls/org.controlsfx.control.action.Action.handle(Action.java:419)
at org.controlsfx.controls/org.controlsfx.control.action.Action.handle(Action.java:64)
at javafx.base/com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
at javafx.base/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:234)
at javafx.base/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
at javafx.base/com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at javafx.base/com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
at javafx.base/com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
at javafx.base/javafx.event.Event.fireEvent(Event.java:198)
at javafx.graphics/javafx.scene.Node.fireEvent(Node.java:8885)
at javafx.controls/javafx.scene.control.Button.fire(Button.java:203)
at javafx.controls/com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:206)
at javafx.controls/com.sun.javafx.scene.control.inputmap.InputMap.handle(InputMap.java:274)
at javafx.base/com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:247)
at javafx.base/com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)
at javafx.base/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:234)
at javafx.base/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
at javafx.base/com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at javafx.base/com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
at javafx.base/com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
at javafx.base/javafx.event.Event.fireEvent(Event.java:198)
at javafx.graphics/javafx.scene.Scene$MouseHandler.process(Scene.java:3890)
at javafx.graphics/javafx.scene.Scene.processMouseEvent(Scene.java:1885)
at javafx.graphics/javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2618)
at javafx.graphics/com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:409)
at javafx.graphics/com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:299)
at java.base/java.security.AccessController.doPrivileged(AccessController.java:391)
at javafx.graphics/com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$2(GlassViewEventHandler.java:447)
at javafx.graphics/com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:412)
at javafx.graphics/com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:446)
at javafx.graphics/com.sun.glass.ui.View.handleMouseEvent(View.java:556)
at javafx.graphics/com.sun.glass.ui.View.notifyMouse(View.java:942)
at javafx.graphics/com.sun.glass.ui.gtk.GtkApplication._runLoop(Native Method)
at javafx.graphics/com.sun.glass.ui.gtk.GtkApplication.lambda$runLoop$11(GtkApplication.java:277)
at java.base/java.lang.Thread.run(Thread.java:832)
JabRef 5.1--ArchLinux--1, Linux 5.8.10-arch1-1 amd64, Java 14.0.2
I have tested the latest development version from http://builds.jabref.org/master/ and the problem persists:
Dev Version tested:
JabRef 5.2--2020-09-24--75b6770, Linux 5.8.10-arch1-1 amd64, Java 15
(The same problem exists with the latest MAC Version)
Databases tested:
PostgreSQL 12 (local)
PostgreSQL instance from elephantsql
MariaDB 10.1.40 (remote)
After successful connection to an empty Database the tables are created as expected but any entries made in JabRef are not being synced. The input of a new entry instead immedeatly results in the errors attached bellow.
Interesstingly when importing an existing library to the shared database the entries are created as expected.
Steps to reproduce the behaviour:
ps Thank you for all the great work!
pps Sorry if I should have missed something obvious and stupid.
Log File
Connection to PostgreSQL server established. Enabling live reloading of /usr/share/java/jabref/resources/main/org/jabref/gui/Base.css Enabling live reloading of /usr/share/java/jabref/resources/main/org/jabref/gui/Dark.css SQL Error: org.postgresql.util.PSQLException: No value specified for parameter 1. at org.postgresql.jdbc@42.2.16/org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:275) at org.postgresql.jdbc@42.2.16/org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:307) at org.postgresql.jdbc@42.2.16/org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473) at org.postgresql.jdbc@42.2.16/org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393) at org.postgresql.jdbc@42.2.16/org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) at org.postgresql.jdbc@42.2.16/org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130) at org.jabref@5.1/org.jabref.logic.shared.DBMSProcessor.insertIntoFieldTable(DBMSProcessor.java:274) at org.jabref@5.1/org.jabref.logic.shared.DBMSProcessor.insertEntries(DBMSProcessor.java:155) at org.jabref@5.1/org.jabref.logic.shared.DBMSSynchronizer.listen(DBMSSynchronizer.java:85) 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:564) at com.google.common@29.0-jre/com.google.common.eventbus.Subscriber.invokeSubscriberMethod(Subscriber.java:87) at com.google.common@29.0-jre/com.google.common.eventbus.Subscriber$SynchronizedSubscriber.invokeSubscriberMethod(Subscriber.java:144) at com.google.common@29.0-jre/com.google.common.eventbus.Subscriber$1.run(Subscriber.java:72) at com.google.common@29.0-jre/com.google.common.util.concurrent.DirectExecutor.execute(DirectExecutor.java:30) at com.google.common@29.0-jre/com.google.common.eventbus.Subscriber.dispatchEvent(Subscriber.java:67) at com.google.common@29.0-jre/com.google.common.eventbus.Dispatcher$PerThreadQueuedDispatcher.dispatch(Dispatcher.java:108) at com.google.common@29.0-jre/com.google.common.eventbus.EventBus.post(EventBus.java:212) at org.jabref@5.1/org.jabref.model.database.event.CoarseChangeFilter.listen(CoarseChangeFilter.java:29) 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:564) at com.google.common@29.0-jre/com.google.common.eventbus.Subscriber.invokeSubscriberMethod(Subscriber.java:87) at com.google.common@29.0-jre/com.google.common.eventbus.Subscriber$SynchronizedSubscriber.invokeSubscriberMethod(Subscriber.java:144) at com.google.common@29.0-jre/com.google.common.eventbus.Subscriber$1.run(Subscriber.java:72) at com.google.common@29.0-jre/com.google.common.util.concurrent.DirectExecutor.execute(DirectExecutor.java:30) at com.google.common@29.0-jre/com.google.common.eventbus.Subscriber.dispatchEvent(Subscriber.java:67) at com.google.common@29.0-jre/com.google.common.eventbus.Dispatcher$PerThreadQueuedDispatcher.dispatch(Dispatcher.java:108) at com.google.common@29.0-jre/com.google.common.eventbus.EventBus.post(EventBus.java:212) at org.jabref@5.1/org.jabref.model.database.BibDatabase.insertEntries(BibDatabase.java:206) at org.jabref@5.1/org.jabref.model.database.BibDatabase.insertEntries(BibDatabase.java:195) at org.jabref@5.1/org.jabref.gui.BasePanel.insertEntries(BasePanel.java:254) at org.jabref@5.1/org.jabref.gui.BasePanel.insertEntry(BasePanel.java:240) at org.jabref@5.1/org.jabref.gui.importer.NewEntryAction.execute(NewEntryAction.java:57) at org.jabref@5.1/org.jabref.gui.actions.JabRefAction.lambda$new$2(JabRefAction.java:41) at org.controlsfx.controls/org.controlsfx.control.action.Action.handle(Action.java:419) at org.controlsfx.controls/org.controlsfx.control.action.Action.handle(Action.java:64) at javafx.base/com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86) at javafx.base/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:234) at javafx.base/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191) at javafx.base/com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59) at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58) at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114) at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56) at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114) at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56) at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114) at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56) at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114) at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56) at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114) at javafx.base/com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74) at javafx.base/com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49) at javafx.base/javafx.event.Event.fireEvent(Event.java:198) at javafx.graphics/javafx.scene.Node.fireEvent(Node.java:8885) at javafx.controls/javafx.scene.control.Button.fire(Button.java:203) at javafx.controls/com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:206) at javafx.controls/com.sun.javafx.scene.control.inputmap.InputMap.handle(InputMap.java:274) at javafx.base/com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:247) at javafx.base/com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80) at javafx.base/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:234) at javafx.base/com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191) at javafx.base/com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59) at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58) at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114) at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56) at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114) at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56) at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114) at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56) at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114) at javafx.base/com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56) at javafx.base/com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114) at javafx.base/com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74) at javafx.base/com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54) at javafx.base/javafx.event.Event.fireEvent(Event.java:198) at javafx.graphics/javafx.scene.Scene$MouseHandler.process(Scene.java:3890) at javafx.graphics/javafx.scene.Scene.processMouseEvent(Scene.java:1885) at javafx.graphics/javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2618) at javafx.graphics/com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:409) at javafx.graphics/com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:299) at java.base/java.security.AccessController.doPrivileged(AccessController.java:391) at javafx.graphics/com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$2(GlassViewEventHandler.java:447) at javafx.graphics/com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:412) at javafx.graphics/com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:446) at javafx.graphics/com.sun.glass.ui.View.handleMouseEvent(View.java:556) at javafx.graphics/com.sun.glass.ui.View.notifyMouse(View.java:942) at javafx.graphics/com.sun.glass.ui.gtk.GtkApplication._runLoop(Native Method) at javafx.graphics/com.sun.glass.ui.gtk.GtkApplication.lambda$runLoop$11(GtkApplication.java:277) at java.base/java.lang.Thread.run(Thread.java:832)