search

openSUSE / open-build-service

Build and distribute Linux packages from sources in an automatic, consistent and reproducible way #obs
https://openbuildservice.org
GNU General Public License v2.0
903 stars 437 forks source link

[production][public#build] Mysql2::Error: Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) f... #7536

Open hennevogel opened 5 years ago

hennevogel commented 5 years ago

public#build threw this 0 times

Mysql2::Error: Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '=': SELECT  `projects`.* FROM `projects` WHERE (projects.id not in (50315,60546,69200,122039,122041,122042,122043,189310,248287,254068,97989,277778)) AND `projects`.`name` = 'filesystems:ceph🐙upstream' LIMIT 1

https://build.opensuse.org/public/build/filesystems:ceph%F0%9F%90%99upstream/openSUSE_Tumbleweed_s390x/s390x/ceph/_log"

~See this exception on Errbit~

See this exception on Errbit

hennevogel commented 5 years ago

No 🐙 in project names. Scandalous!

dmarcoux commented 1 year ago

To get rid of such errors once and for all, we should migrate the complete database to utf8mb4. Right now, we still have some tables and columns using utf8mb3. This article explains how we could do it: https://railsmachine.com/articles/2017/05/19/converting-a-rails-database-to-utf8mb4.html