duplicate key value violates unique constraint "gpodder_episode_user_id"

[Marcool04]

Hi there,

Playing a podcast episode in RePod (https://git.crystalyx.net/Xefir/repod) results in the following error being thrown by Postgresql every second:

2024-07-22 13:38:21.383 CEST [1372877] ERROR:  duplicate key value violates unique constraint "gpodder_episode_user_id"
2024-07-22 13:38:21.383 CEST [1372877] DETAIL:  Key (episode, user_id)=(https://rf.proxycast.org/309b5111-1873-4f74-883a-0b3bd79b5dcc/10059-22.07.2024-ITEMA_23809732-2024C2717S0204-21.mp3, mark) already exists.
2024-07-22 13:38:21.383 CEST [1372877] STATEMENT:  INSERT INTO "oc_gpodder_episode_action" ("podcast", "episode", "guid", "action", "position", "started", "total", "timestamp_epoch", "user_id") VALUES($1, $2, $3, $4, $5, $6, $7, $8, $9)

(Please note that I'm reporting this here as I could only find the string "gpodder_episode_user_id" in nextcloud-gpodder, and nowhere in RePod, however, I am in no way certain where the fault lies.)

Although this does not seem to cause any visible problem during playback in the browser window, I did notice that the episode, once played to the end, is not marked as such. This might however be unrelated, and may well be more on the side of RePod than nextcloud-gpodder. The reason I noticed this is that, because the error repeates every second, the netdata system monitor threw a warning saying that as a large share of Postgresql transactions were resulting in errors.

Maybe I have some idiosyncracy in my setup?

uname -a
Linux HOSTNAME 6.9.10-arch1-1 #1 SMP PREEMPT_DYNAMIC Thu, 18 Jul 2024 18:06:13 +0000 x86_64 GNU/Linux

# pacman -Qi nextcloud                                                                                                
Name            : nextcloud                                                                                                              
Version         : 29.0.4-1
[snip]

# rg '<version>.*</version>' gpoddersync/appinfo/info.xml 
8:    <version>3.9.0</version>

# rg '<version>.*</version>' repod/appinfo/info.xml 
14:    <version>2.3.3</version>

If you think this is the case, any assistance would be much appreciated in figuring out what is wrong, and if you think this is an error on the apps side, do let me know if you need any help in debugging further.

Thanks for your help,
Best regards,
Mark.