search

gorse-io / gorse

Gorse open source recommender system engine
https://gorse.io
Apache License 2.0
8.49k stars 778 forks source link

'innodb_snapshot_isolation' can't be set to the value of 'READ-UNCOMMITTED' #844

Open Xoshbin opened 3 months ago

Xoshbin commented 3 months ago

Gorse version Latest Describe the bug Suddenly I'm receiving this error, I tried many ways but so far could not solve it,

ERROR failed to initialize database, got error Error 1231: Variable 'innodb_snapshot_isolation' can't be set to the value of 'READ-UNCOMMITTED' 2024-06-07T18:10:53.279Z FATAL failed to connect data database {"error": "Error 1231: Variable 'innodb_snapshot_isolation' can't be set to the value of 'READ-UNCOMMITTED'", "errorVerbose": "Error 1231: Variable 'innodb_snapshot_isolation' can't be set to the value of 'READ-UNCOMMITTED'\ngithub.com/zhenghaoz/gorse/storage/data.Open:176: To Reproduce After restarting the server and running the gorse command the error appeared.

Xoshbin commented 3 months ago

Is it possible to add "innodb_snapshot_isolation" to optional in the config.tom file or it's required?! Because in a situation like mine I can't change the innodb_snapshot_isolation to READ-UNCOMMITTED on the server side.