xbvr icon indicating copy to clipboard operation
xbvr copied to clipboard

XBVR crashing while scrapper is running

Open Raptor05 opened this issue 1 year ago • 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!

Raptor05 avatar May 13 '24 06:05 Raptor05

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

pops64 avatar May 14 '24 22:05 pops64

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

Thanks for the hint.

Raptor05 avatar May 16 '24 13:05 Raptor05

Unfortunately, it's still crashing...

Raptor05 avatar May 17 '24 13:05 Raptor05

disable "strict_mode" for mariadb.

theRealKLH avatar May 22 '24 00:05 theRealKLH

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.

Raptor05 avatar May 23 '24 06:05 Raptor05

In docker-compose.yml (portainer)

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

theRealKLH avatar Jun 29 '24 02:06 theRealKLH