shared SQL database - jabref updates one char and crashes after

[Processeer]

JabRef version

Latest development branch build (please note build date below)

Operating system

Windows

Details on version and operating system

Windows 11 pro 64bit Version 22H2 Built 22621.1555

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

SQL database is within an intranet, so from outside I have to connect via VPN

1. Connecting to Intranet through Barracuda VPN ... ok
2. connecting to shared database ... ok
3. pulling data ... ok
4. changing entries ... now it gets interesting

• if I type a "," it is instantly changed in the database (checked via phpMyAdmin). It takes JabRef 5-10s to return focus to the user
• If I type characters the first one is instantly updated into the database, jabref is frozen and nothing more happens in the database
• If I paste an entire string or even an entire entry at once, this one is updated/ created but jabref does not come around. I can't read the log since its gone after restart. (is there an option to recover some kind of crash report? or last actions to derive from?)
• I tried to insert a group - it does work without crash, database is updated, focus returned

This looks like a special thing to me. Since jabref can communicate with the database in general but somehow there is a disturbance after one UPDATE cycle.

Appendix

JabRef 5.10--2023-04-13--81f2688
Windows 11 10.0 amd64
Java 19.0.2
JavaFX 20+19

Log File

Paste an excerpt of your log file here

[ThiloteE]

Might be related: #8977

[ThiloteE]

What do you mean with

but jabref does not come around

Does it freeze too?

What version of sql are you using?

[Siedlerchr]

refs #8496
It freezes/blocks because sync happens on the UI thread. Tried to fix this but caused deadlocks...
Regarding logs:

Q: Where can I find JabRef's log files?
A: On Windows, one finds the log files in %APPDATA%..\Local\org.jabref\jabref\Logs{version}. {version} indicates the currently used JabRef version.

[Processeer]

ya, "does not come around" means it freezes - looks like its waiting for some kind of response it does not get. But then Im am not a programmer and am not using programmer language :) sorry for that

SQL:: 10.3.29-MariaDB

[Processeer]

I surely did not change that many things that needed saving in the log file. Maybe it tells you something.

log.txt

by the way: the foldes name is:
~ 5.10--2023-04-13--81f2688\

indicating the 13th April but the content is from the 24th April. Almost missed it.

[Processeer]

following your lead with #8496

I deactivated the emodificationdate update:

and yes it does not crash anymore. It sometimes just takes some seconds to return th focus to the user.

[Siedlerchr]

Glad to hear that this helps. I was on a good way with my PR, however in the end I did not manage to solve the deadlocks that now occured.:(

[Processeer]

never give up! sometimes the next day everything seems so easy.

[Processeer]

connected to #8485 too?