Open
Description
Please answer these questions before submitting your issue. Thanks!
Gorse version
v0.4.15
Describe the bug
I set up a new install (docker all in one), added around 20,000 items but in logs, I'm seeing this error all the time:
{"level":"error","ts":1732991410.1143508,"msg":"trace","error":"Error 1292: Truncated incorrect INTEGER value: '-1.7976931348623157e308'","elapsed":0.000425213,"rows":0,"sql":"DELETE FROM `gorse_sorted_sets` WHERE name = 'ignore_items/1005' AND -Inf <= score AND score <= 1732991409.000000"}
{"level":"error","ts":1732991410.1144407,"msg":"failed to refresh cache","error":"Error 1292: Truncated incorrect INTEGER value: '-1.7976931348623157e308'","errorVerbose":"Error 1292: Truncated incorrect INTEGER value: '-1.7976931348623157e308'\ngithub.com/zhenghaoz/gorse/storage/cache.(*SQLDatabase).RemSortedByScore:339: \ngithub.com/zhenghaoz/gorse/worker.(*Worker).refreshCache:1143: "}
{"level":"error","ts":1732991650.2167506,"msg":"failed to continue offline recommendation","error":"Error 1292: Truncated incorrect INTEGER value: '-1.7976931348623157e308'","errorVerbose":"Error 1292: Truncated incorrect INTEGER value: '-1.7976931348623157e308'\ngithub.com/zhenghaoz/gorse/storage/cache.(*SQLDatabase).RemSortedByScore:339: \ngithub.com/zhenghaoz/gorse/worker.(*Worker).refreshCache:1143: \ngithub.com/zhenghaoz/gorse/worker.(*Worker).Recommend.func2:814: \ngithub.com/zhenghaoz/gorse/base/parallel.Parallel:40: "}
To Reproduce
New install from docker, mysql backend, mysql cache.
Added 20k items. Now seeing error above in logs, also in admin panel Collect garbage in cache Failed 2024/11/30 15:59 Error 1292: Truncated incorrect INTEGER value: '-1.7976931348623157e308'
Expected behavior
To not have this error about truncation
Additional context
Let me know if you require any other info