xbapps/xbvr

XBVR crashing while scrapper is running

Raptor05 opened this issue · 6 comments

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!

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

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

Thanks for the hint.

Unfortunately, it's still crashing...

disable "strict_mode" for mariadb.

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.

In docker-compose.yml (portainer)

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