This means that row based replication will not work for JSON types from MySQL to MariaDB. Integration: Recorder (documentation, issues)Įrror executing query: (MySQLdb._exceptions. The JSON type in MySQL stores the JSON object in a compact form, not as LONGTEXT as in MariaDB. The primary difference between the two functions is that JSONQUERY returns an object or an array, while JSONVALUE returns a scalar. No response Anything in the logs that might be useful for us? Differences between JSONQUERY and JSONVALUE MariaDB starting with 10.2.3 JSON functions were added in MariaDB 10.2.3. Recorder Link to integration documentation on our website Home Assistant OS Integration causing the issue Illegal mix of collations for operation 'UNION' is the error, but I couldn't figure out why exactly.Īnybody have an idea what might be the problem here? What version of Home Assistant Core has the issue?Ĭore-2022.6.4 What was the last working version of Home Assistant Core?Ĭore-2022.5.5 What type of installation are you running?
The history graph works without a problem though. Doesn't matter it's a singular entity logbook, or the logbook of all entities in the sidebar. Since 2013 MariaDB is Arch Linux's default implementation of MySQL. Since 2022.6 I can't access the logbook at all. MariaDB is a reliable, high performance and full-featured database server which aims to be an 'always Free, backward compatible, drop-in' replacement of MySQL. In MariaDB Server 10.6, we’ve added JSONTABLE (), a powerful new function that enables you to transform JSON data directly into relational format. I'm using the MariaDB-addon connected to the recorder, exactly like it's shown in the docs. I have waited with creating this issue till #73191 was merged and released in 2022.6.4, but the issue sadly still appears. Configured/used MariaDB Storage engines Blackhole, AWS S3, MyISAM, Aria, Column Store, Heap/Memory, InnoDB and XtraDB.- Setup MariaDB High performance write-intensive TokuDB compressed environment. The errorlog below appears since updating to 2022.6 in general.
0 kommentar(er)
