Last error: Error: SAVEPOINT

[Zumo]

Operating system

Linux

Joplin version

3.4.3

Desktop version info

Joplin 3.4.12 (prod, linux)

Device: linux, Intel(R) Core(TM) i5-9600K CPU @ 3.70GHz
Client ID: e9cac719366a42d8b96700b776d9caa9
Sync Version: 3
Profile Version: 48
Keychain Supported: No
Alternative instance ID: -

Revision: e9a9f6856

Backup: 1.4.3
Freehand Drawing: 3.1.0
Rich Markdown: 0.15.0
Search & Replace: 2.2.0

Sync target

Joplin Server

What issue do you have?

I'm seeing this error in Joplin app in Linux.
Last error: Error: SAVEPOINT sp_Cphmj11AL7J52QH9fj2jdA - current transaction is aborted, commands ignored until end of transaction block

The latest change was the upgrade of the PostGres DB.

Screenshots

Log file

error_log.txt (46 KB)

[laurent]

It always shows this when you sync? Probably something's off with the database and you should try restarting it

[Zumo]

Hello,

Tried restarting joplin and postgres, still the same outcome.

[mrjo118]

Try setting up writing stdout to a file on your Joplin server and reproduce the issue, then send over the server log

[Zumo]

Fixed it.

I had a backup from yesterday before upgrading the PostGres container.

I’ve dropped the database, created it again and imported.

Error gone.

The error is not related to the Joplin but yes with the PostGres.
This is basically a lock in the database you can do a rollback of the savepoint, but I was unable to find the transaction.
Using the backup was the best and faster choice.

https://www.postgresql.org/docs/current/tutorial-transactions.htmlhttps://www.postgresql.org/docs/current/tutorial-transactions.html