Skip to main content

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

AIDA logo
AIDA logo

Harness AIDA Chatbot

AI Development Assistant


Today, March 15, 9:01pm

AIDA logo

Accelerate your software delivery with the powerful capabilities of Harness’s Platform.

AIDA logo

How can I help?

Log into your Harness Account to access AIDA