shared database with postgresql, manual entry in fields truncated

[jh-midi]

JabRef version

Latest development branch build (please note build date below)

Operating system

Other (please describe below)

Details on version and operating system

almalinux

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. .open jabref, connect to shared database
2. ..enter in comment field as user asterix = je ne sais pas quoi en dire en ce moment
3. ...select from sql => je ne sais pas quoi dire en ce m
   (I read on forum this is and old issue, the same occured in 5.0.)

If another user obelix for example want to read the entry, an alert message appear , but not always.
BibEntry versions differe (look at joined screen capture please.)
BibEntry version Shared 40 and local 24
I tested this on jabref 5.9 and the version differe also:
Shared 36,
Local 29
and jabref refuse to update on shared side.

I have another question :
in the doc : https://docs.jabref.org/collaborative-work/sqldatabase we can read :
"JabRef will automatically detect your changes and push them to the shared side. JabRef will also constantly check if there is a newer version available. " but here we have to constantly refresh jabref in manual mode with Control-shif-R
It is ok ?
Thank you

Appendix

...

Log File

Paste an excerpt of your log file here


[jh-midi]

• Another examples here on JabRef 5.9--2023-01-08--76253f1a7
  Mac OS X 12.6.3 x86_64
  Java 19.0.1
  JavaFX 19+11

• import some entry
  add comment as user1 :
  my comment on this issue
  become for user2 :
  my comment on this i
  => ssue is cutted
  you can see the same result with sql : select * from jabref."FIELD";

• If I create some manual entry via new entry
  if I write for the title :
  my very short title
  it become
  my very short t

[jh-midi]

• suggested Solution :
  After some time, and when another entries are added, the sentence is completed =>
  This mean the stream buffer is flushed
  =>
  flush the jdbc buffer for each manual individual entry should probably eliminate this issue.

https://jdbc.postgresql.org/documentation/publicapi/org/postgresql/core/PGStream.html

[larsk21]

Same problem occurred to me with a shared MySQL database when adding a new entry and changing the title. In my case "Test Entry" was cut short to "Test E", both in JabRef upon re-opening and in the database (table JABREF_FIELD). Interestingly the local file for the shared database ("Automatically save the library to") contains the full title.

Details on version and operating system

JabRef 5.13--2024-04-01--6bdcf63
Linux 5.15.0-107-generic amd64 (Linux Mint 21.1 Cinnamon)
Java 21.0.2
JavaFX 22+30
mysql Ver 8.0.36-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))