szafran81
commented
3 years ago Hm... I think I managed to find the problem. As it turns out the problem was the config statement that I used before to configure recorder:
db_url: mysql://user:pass@192.168.1.3/hassioAnd this worked without problems on my previous venv setup. But now under the HASSOS-KVM setup this needs to be:
db_url: mysql://user:pass@192.168.1.3/hassio?charset=utf8mb4Now I'm not seeing any recorder related errors in any of the logs.
Hardware Environment
Home Assistant OS release:
Journal logs:
Kernel logs:
Description of problem:
The problem:
Something is going on with recorder and polish letters (now it's \u0119, and earlier it was \u0105 - if I remember correctly). It's a KVM setup on Ubuntu 20.04 (both fresh installs). I'm using MySQL on the Host for the recorder. I've used similar setup before - but now it's a bridged network "connection" and before it was local with HA venv install. Had the same devices added using the same names - didn't have any errors then (TBH I didn't have any of these errors until today, but this install exists only 2 days now). I've tried removing tables from the DB. I've tried removing the DB, and then recreating it with different name and user. I did Host+VM full shutdowns between operations on the DB, and the errors still come back.
Can anyone help me solve that issue ?