Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

XBVR crashing while scrapper is running #1729

Open
Raptor05 opened this issue May 13, 2024 · 6 comments
Open

XBVR crashing while scrapper is running #1729

Raptor05 opened this issue May 13, 2024 · 6 comments

Comments

@Raptor05
Copy link

Raptor05 commented May 13, 2024

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
Copy link
Contributor

pops64 commented May 14, 2024

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

@Raptor05
Copy link
Author

Raptor05 commented May 16, 2024

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

Thanks for the hint.

@Raptor05
Copy link
Author

Unfortunately, it's still crashing...

@theRealKLH
Copy link
Collaborator

disable "strict_mode" for mariadb.

@Raptor05
Copy link
Author

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
Copy link
Collaborator

In docker-compose.yml (portainer)

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

@theRealKLH theRealKLH closed this as not planned Won't fix, can't repro, duplicate, stale Jun 29, 2024
@theRealKLH theRealKLH reopened this Jun 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants