Custom Value Mapping Resets Regularly

nawapon.l · August 3, 2024, 6:53am

Hello everyone!

I’m facing a quirky issue with custom value mappings. They mysteriously reset every few days to the original values. I checked the “Metabase Fieldvalues” table and noticed that the values get deleted.

I couldn’t find anything similar on GitHub or here, so it might be a configuration gremlin. Here’s my setup:

•	Metabase Community v0.50.18 (have seen this behavior long before this version though)
•	Hosted on Ubuntu 20.04.2 LTS (AWS EC2)
•	MySQL 8.0.35 (AWS RDS)

I’d love to hear your thoughts on what might be causing this, and I’ll keep you posted with any new discoveries!

TonyC · August 5, 2024, 2:28pm

Are you sure you are not hitting by mistake this bug:

github.com/metabase/metabase

Custom mapping is reset while editing unrelated settings in column metadata

opened 03:42PM - 30 May 24 UTC

zbodi74

Type:Bug Priority:P2 .Frontend Administration/Settings .Team/AdminWebapp

### Describe the bug Some unrelated actions in the column metadata editor see…m to reset the custom field value mappings set for the column. [Cal's note: the mappings are reset only on the frontend, but the persisted settings are not reset unless the user saves them again] ### To Reproduce 1. In Admin Settings / Table Metadata / Sample Database / Reviews, set up a custom mapping for the _Rating_ column. 2. Do one of the following: * Click on Save, and Exit Admin, then go back to the same place * Update an unrelated field in the column settings, such as the column description then click elsewhere so the change is saved * Click on Discard cached field values and refresh the page * On the table level page, update the title of the same column 3. (!) The 'Custom mapping' setting reverts to 'Use original value', or the setting remains, but the mapped values reset to the original field values. ### Expected behavior The mapping should be kept. ### Logs _No response_ ### Information about your Metabase installation ```JSON Reproduced in 1.49.8 and 1.49.13 ``` ### Severity Annoying. Found it while trying to reproduce something else. ### Additional context _No response_

nawapon.l · August 5, 2024, 3:17pm

I don’t think these are the same issue. Issue 43382 resets the “Metabase Fieldvalues” to their original values, whereas my issue results in the “Metabase Fieldvalues” being deleted entirely for that field.