Sharing high amounts of pictures with other user(s) fails

[E-Reg]

🐛 Bug Report

• 📁 I've Included a ZIP file containing my librephotos log files
  log.zip
• ❌ I have looked for similar issues (including closed ones)
• [] 🎬 (If applicable) I've provided pictures or links to videos that clearly demonstrate the issue

📝 Description of issue:

I placed my pictures in my home/ubuntu/Pictures folder and linked it via the .env.
I used the /data/ path for my admin user.

# Location of your photos.
scanDirectory=../Pictures

# Internal data of LibrePhotos
data=./librephotos/data

I added 863 pictures, which were added to LibrePhotos correctly and I was able to apply Faces etc. with my admin account.
I added multiple users.
When logged in with my admin, I selected all pictures in the Photos tab and tried to

1. Share photos with a user. The green button to the right of the username doesnt do anything. The red one however brings up a confirmation on the lower right of the screen
2. Make the photos public. Only 100 pictures were made public, the rest remains private.

I also tried to use the same data path /data/ for my admin user and an other one, but when scanning with the new user, the pictures wont show up. If I select rescan, it scans the 863 pictures however (but they wont display).

There are some log clues:
psycopg.errors.UniqueViolation: duplicate key value violates unique constraint "api_photo_shared_to_photo_id_user_id_d9c7c4a1_uniq" DETAIL: Key (photo_id, user_id)=(100, 27) already exists.

2023-06-11 20:50:36,138 : photos.py : post : 461 : WARNING : Could not set photo 160 to public. It does not exist.

It is also not possible to select all --> + --> Album --> Create new Album

What I actually want is one or multiple additional users, having read access to all the pictures from the admin account. I already added the face etc. and I want the other users to benefit from the structures, like face albums as well. As far as I can tell, even if I manage to share the pictures, the other users will only receive a single album of all shared pictures. No word clouds, no face albums.
If I share my admin account with the other users, they may change the password or delete pictures which I also don't want.

🔁 How can we reproduce it:

Add a large amount of pictures.
Find a way to share them between users all at once.

Please provide additional information:

• 💻 Operating system: Ubuntu 18.04.6 LTS (GNU/Linux 4.15.0 x86_64)
• ⚙ Architecture (x86 or ARM): x86
• 🔢 Librephotos version: dev/bfc19c066d39beb9c9c4dd9e8e5a179d9b4a4733
• 📸 Librephotos installation method (Docker, Kubernetes, .deb, etc.): Docker
  • 🐋 If Docker or Kubernets, provide docker-compose image tag: reallibrephotos/librephotos:latest, postgres:13, reallibrephotos/librephotos-frontend:latest, reallibrephotos/librephotos-proxy:latest, redis:6
• 📁 How is you picture library mounted (Local file system (Type), NFS, SMB, etc.): local file system (/home/ubuntu/Pictures) librephotos docker is located under /home/ubuntu/librephotos-docker
• ☁ If you are virtualizing librephotos, Virtualization platform (Proxmox, Xen, HyperV, etc.):