I have been running a local szurubooru instance for a few years, currently at ~3,100 posts. The other day, I noticed that only about 480 posts are visible, seemingly at random*. The old posts still exist in some form, as they're included in the total post count and tag post counts, but they don't show up in search results or the unfiltered Posts list. Trying to use the left and right arrows to move between posts will properly skip over deleted post numbers, but the invisible posts are not skipped and instead show a "Post [number] not found" error page. There are no errors or lines out of the ordinary in the Docker console when trying to access these posts.
*Bizarrely, it's not entirely random which posts are gone—a lot of the remaining posts are from sets that were uploaded together, with their entire set still being visible. This isn't true for everything, though.
I checked the data, and the images + thumbnails for the invisible posts are still there as well, which makes me hope they may be recoverable. Nothing about the configuration has changed; as far as I can tell, this issue arose spontaneously. I'm a bit of a Docker and SQL noob, so I'm at a loss for what to try. I've tried doing docker-compose pull already, but it didn't change anything. Has anyone else encountered this before?
I have been running a local szurubooru instance for a few years, currently at ~3,100 posts. The other day, I noticed that only about 480 posts are visible, seemingly at random*. The old posts still exist in some form, as they're included in the total post count and tag post counts, but they don't show up in search results or the unfiltered Posts list. Trying to use the left and right arrows to move between posts will properly skip over deleted post numbers, but the invisible posts are not skipped and instead show a "Post [number] not found" error page. There are no errors or lines out of the ordinary in the Docker console when trying to access these posts.
*Bizarrely, it's not entirely random which posts are gone—a lot of the remaining posts are from sets that were uploaded together, with their entire set still being visible. This isn't true for everything, though.
I checked the data, and the images + thumbnails for the invisible posts are still there as well, which makes me hope they may be recoverable. Nothing about the configuration has changed; as far as I can tell, this issue arose spontaneously. I'm a bit of a Docker and SQL noob, so I'm at a loss for what to try. I've tried doing
docker-compose pullalready, but it didn't change anything. Has anyone else encountered this before?