For the complete documentation index, see llms.txt. This page is also available as Markdown.

Emoji in REDIS Database error when Migrating from REDIS to MySQL

Issue

Error returned when migrating from REDIS to MySQL: org.springframework.jdbc.UncategorizedSQLException: jOOQ; uncategorized SQLException for SQL [insert into pipeline_stages (id, legacy_id, execution_id, status, updated_at, body) values (?, ?, ?, ?, ?, ?) on duplicate key update status = ?, updated_at = ?, body = ? -- agentClass: PipelineMigrationAgent]; SQL state [HY000]; error code [1366]; Incorrect string value: '\x\x\x\x...'

As an example, the incorrect string value will be an emoji icon, e.g. \xF0\x9F\x94\x90mT... which is a lock emoji

Cause

Spinnaker doesn't parse the information properly, because it wasn't declared what kind of encoding it should process the data with

Last updated

Was this helpful?