Hi everybody, I ran into an issue when doing a migration where I would replace an id value from the rows in a table with around 130k rows.
The migration froze in that point and my deployment ended up failing due to timeout.
This is the command where the migration froze:
from(:table).update(id: Hanami::Model::Sql.function(:uuid_generate_v4))
I was able to fix this by removing the update from the migration and updating the values afterwards, but I still would like to understand what caused this issue. My first though was that it just took too much memory to update all the values at once, but I’m not sure.