| Summary: | layerindex-web: 31 database tables still use latin1, so text outside Latin-1 fails to save | ||
|---|---|---|---|
| Product: | [Yocto Project Subprojects] Layer Index | Reporter: | Tim Orling <tim.orling> |
| Component: | Layer Index | Assignee: | Tim Orling <tim.orling> |
| Status: | NEW --- | QA Contact: | apoorv sangal <apoorvsangal> |
| Severity: | normal | ||
| Priority: | Medium | ||
| Version: | unspecified | ||
| Target Milestone: | 6.2 M2 | ||
| Hardware: | All | ||
| OS: | Multiple | ||
| Whiteboard: | |||
| OS type for building Yocto: | --- | Type of Regression: | --- |
| Verified: | Documentation change: | Don't know | |
| Bug Depends on: | |||
| Bug Blocks: | 16476 | ||
|
Description
Tim Orling
2026-11-15 00:30:46 UTC
Correction to the description: the rest of the database isn't all utf8mb4. On the test instance's copy of the production database the 73 tables are: latin1_swedish_ci 31 (65 columns), utf8mb3_unicode_ci 35 (104 columns), utf8mb4_unicode_ci 5 (11 columns), utf8mb4_0900_ai_ci 2 (5 columns). Fixed on the test instance (layers.moto-timo.net) on 2026-11-15: - Backed up the database with mariadb-dump --single-transaction. - Merged two pairs of rrs_maintainer rows that collide in the unique index on name under utf8mb4_unicode_ci (latin1_swedish_ci treats o and ö as different letters). Each pair is the same person with the same email: "Enrico Jorns"/"Enrico Jörns" and "Zoltan Boszormenyi"/"Zoltán Böszörményi". Their RecipeUpgrade and RecipeMaintainerHistory references were moved to the row the maintainers file uses. - Converted the 31 tables with ALTER TABLE ... CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci. No latin1 columns are left. A maintainer name such as "Łukasz Ślęzak 测试" now saves, and rrs_upgrade_history.py runs without the "Illegal mix of collations" error. Production has not been changed yet. The scripts and steps are kept with the layer index handoff notes. |