rivenmedia / riven

Handle your Media Library with ease!
https://rivenmedia.github.io/wiki/
GNU General Public License v3.0
380 stars 51 forks source link

Delete item from library error = invalid DSA memory #685

Closed ltotsas closed 1 month ago

ltotsas commented 1 month ago

Trying to delete an item from library is not working so looking at logs this came up

2024-09-07 07:36:17.519 UTC [102] ERROR: invalid DSA memory alloc request size 1543503872 I increased shm_size bz postgres was exploding, but not it seems that the op is too much to query.

query
AyushSehrawat commented 1 month ago

I increased shm_size bz postgres was exploding, but not it seems that the op is too much to query.

Did you do it outside Docker Postgres?

AyushSehrawat commented 1 month ago

This is a known issue and Docker limitation of not able to increase shm_size. We are looking into it

ltotsas commented 1 month ago

I am not sure I follow the "outside docker postgres" but the change i did is like you said increase the shm_size from the container yml config

dreulavelle commented 1 month ago

Give it a shot now. We are currently on v0.14.1. Removing items can be tough given how much data they can store and then trying to delete that all at once.. you especially notice it with shows that have a lot of seasons and episodes.

This is something thats on my radar though and will be looking to improve.