Closed paarriagadap closed 3 weeks ago
Quick links (staging server): Site | Admin | Wizard | Docs |
---|
Login: ssh owid@staging-site-global-mpi-2024
Edited: 2024-11-08 16:51:06 UTC Execution time: 4.73 seconds
Hi @Marigold! I was modifying the name of some variables and I found the error you see here:
sqlalchemy.exc.IntegrityError: (pymysql.err.IntegrityError) (1062, "Duplicate entry 'grapher/ophi/2024-10-28/multidimensional_poverty_index/multidime' for key 'variables.idx_catalogPath'")
But I don't see I created repeated indicators, for example. Now I can't build the dataset and I get this:
sqlalchemy.exc.MultipleResultsFound: Multiple rows were found when one or none was required
I see the dataset is now empty. Do you know why? Thanks!
Seems like the dataset got corrupted because of an interrupted process or something along these lines.
@Marigold Maybe this is similar to what you've found here? I did see that before this failing the origins multiplied, and there where a lot (only two should show up)
@paarriagadap sorry, it was caused by recent migration in MySQL. I merged with master and it should work now.
Thank you @spoonerf!
Data issue: https://github.com/owid/owid-issues/issues/1605