Jabref not showing contents of shared database library

[falschgeldkind]

JabRef version

Latest development branch build (Build date 2022-05-09)

Operating system

GNU / Linux

Details on version and operating system

Ubuntu 20.04.4 LTS

Checked with the latest development build

• I made a backup of my libraries before testing the latest development version.
• I have tested the latest development version and the problem persists

Steps to reproduce the behaviour

1. Have a shared library with a ton of entries (in my case 39.744)

2. Try to connect to that library

3. Watch it saying "Connection [...] established"

4. Don't see any entries

5. (Optional) Click on Pull changes from shared database

6. (Optional) Get the error dialog "The connection to the server has been terminated" and the options to work offline, reconnect and close library

If wanted I can send you a database dump

Appendix

No response

[Siedlerchr]

Thanks for bringing this to our attention. Can you specify which database you use? MySQL? Postgres? Is there anything in the error log in Jabref. You can send a db dump privately to

web [at] jabref.org

[falschgeldkind]

use a PostgreSQL database

The event log says:
eventlog.LOG

I've sent the database dump to the email address you've given me.

[Siedlerchr]

Ah you hit a bug in postgresl: pgjdbc/pgjdbc#1311
The number of parameter in the query is too large...
We need to split the query into multiple smaller ones

Related JabRef code:
at org.jabref@5.7.36/org.jabref.logic.shared.DBMSProcessor.getSharedEntries(Unknown Source)
at org.jabref@5.7.36/org.jabref.logic.shared.DBMSSynchronizer.synchronizeLocalDatabase(Unknown Source)
at org.jabref@5.7.36/org.jabref.logic.shared.DBMSSynchronizer.initializeDatabases(Unknown Source)
at org.jabref@5.7.36/org.jabref.logic.shared.DBMSSynchronizer.openSharedDatabase(Unknown Source)

[falschgeldkind]

Oh nice. No bug hunting needed then I guess.
But I thought it might be something on these lines, because when I viewed the data with DataGrip it loaded all of it but did it in multiple 501 elements queries and that worked fine

[falschgeldkind]

While being here:
how it the column VERSION in "ENTRY" used? I never found a case where that field wasn't 1

[falschgeldkind]

Ok I've got a fix
Never made a push; how do I do a push-request?

[ThiloteE]

From JabRef GitHub frontpage:

"You are welcome to contribute new features. To get your code included into JabRef, just fork the JabRef repository, make your changes, and create a pull request."

As a general advice: check out https://github.com/JabRef/jabref/blob/main/CONTRIBUTING.md for a start. Also, https://devdocs.jabref.org/getting-into-the-code/guidelines-for-setting-up-a-local-workspace is worth having a look at.

[Siedlerchr]

@falschgeldkind Thanks for your fix! If I am not mistaken, version is used when multiple people using a shared database work on the same entry

[falschgeldkind]

see #8793