Running psql -l shows that maps-test* postgres DBs were created with SQL_ASCII, whereas all our production servers have it set to UTF8.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | RKemper | T137939 Increase frequency of OSM replication | |||
| Resolved | Gehel | T147194 reimage maps-test* servers | |||
| Resolved | Gehel | T148031 Maps - error when doing initial tiles generation: "Error: could not create converter for SQL_ASCII"" | |||
| Resolved | Gehel | T148114 Maps-test was created with incorrect initial encoding |
Event Timeline
Comment Actions
Strange thing is that other servers have been reimaged recently and database were created with UTF-8 encoding. There is probably a missing dependency somewhere in Puppet. I'm having a look...
Comment Actions
The issue seems to be that when puppet is run manually, the $LANG variable is set, which is used by initdb to guess at the correct encoding. When puppet is run non interactively, which is the case during re-image, encoding falls back to SQL_ASCII. Setting the encoding / locale explicitly should fix that.
Comment Actions
Puppet now explicitly sets the locale to use. maps-test cluster has been reimaged with the new puppet code and encoding is now UTF-8.