xbapps / xbvr

Tool to organize and stream your VR porn library
345 stars 129 forks source link

XBVR crashing while scrapper is running #1729

Open Raptor05 opened 6 months ago

Raptor05 commented 6 months ago

Hey,

since a few days my XBVR instance is crashing each 12 hours. I've had a look into the docker logs and found the following:

...some scrapper entries
time="2024-05-13T01:06:12Z" level=fatal msg="Failed to save All attempts fail:
#1: Error 1366: Incorrect string value: '\xE2...' for column `xbvr`.`scenes`.`synopsis` at row 1
#2: Error 1366: Incorrect string value: '\xE2...' for column `xbvr`.`scenes`.`synopsis` at row 1
#3: Error 1366: Incorrect string value: '\xE2...' for column `xbvr`.`scenes`.`synopsis` at row 1
#4: Error 1366: Incorrect string value: '\xE2...' for column `xbvr`.`scenes`.`synopsis` at row 1
#5: Error 1366: Incorrect string value: '\xE2...' for column `xbvr`.`scenes`.`synopsis` at row 1
#6: Error 1366: Incorrect string value: '\xE2...' for column `xbvr`.`scenes`.`synopsis` at row 1
#7: Error 1366: Incorrect string value: '\xE2...' for column `xbvr`.`scenes`.`synopsis` at row 1
#8: Error 1366: Incorrect string value: '\xE2...' for column `xbvr`.`scenes`.`synopsis` at row 1
#9: Error 1366: Incorrect string value: '\xE2...' for column `xbvr`.`scenes`.`synopsis` at row 1
#10: Error 1366: Incorrect string value: '\xE2...' for column `xbvr`.`scenes`.`synopsis` at row 1"
2024/05/13 01:06:31 ffprobe and avprobe not found in $PATH
time="2024-05-13T01:06:32Z" level=info msg="Migration did run successfully"
time="2024-05-13T01:06:34Z" level=info msg="Starting router "
...

Do you have any idea whats the issue here?

My XBVR is running in docker on my Synology NAS. Version is 0.4.25 using mariadb

Thanks in advance!

pops64 commented 6 months ago

Is Swallowbay scraper enabled? There is a known bug with this scraper.

Raptor05 commented 6 months ago

Yeah, it was enabled. I disabled it now and will observe the logs.

Thanks for the hint.

Raptor05 commented 6 months ago

Unfortunately, it's still crashing...

theRealKLH commented 6 months ago

disable "strict_mode" for mariadb.

Raptor05 commented 6 months ago

disable "strict_mode" for mariadb.

Is there an docker env variable for that?

And another short update: I think the issue is not the scapper, its the preview generation process. I deactivated all tasks and activated them one after another, to see at which point it's crashing. And it's crashing, after I activated the preview generation again.

theRealKLH commented 4 months ago

In docker-compose.yml (portainer)

services:
  mariadb:
    command: --sql-mode=""
    container_name: mariadb