I m upgrading to v1 14 on Postgres `migrate add xid constrai

Question

I m upgrading to v1 14 on Postgres `migrate add xid constraints` failed because it s running for over 1h I don t think it s a problem for me I can just rerun it but thought I d flag it as I m not sure what would have happened if I was using the operator that manages the migration itself

vroldanbet · Answer

you run the `spicedb migrate` command manually and after an hour it failed What error did it provide

williamdclt · Answer

Exactly It gave me `context deadline exceeded`

williamdclt · Answer

After an hour exactly so I assume it s a builtin timeout somewhere AFAIK this `context deadline exceeded` is a fairly generic Go thing

Joey · Answer

How many rows are in your relationships and transactions tables < Jake>

Jake · Answer

yeah I believe we only give the migrations 1hr to run probably something that we need to revisit now that we have an actually beefy migration

williamdclt · Answer

I can t check right now but must be in the order of 10M relationships FYI I m at 3h of running this migration and it s not finished

vroldanbet · Answer

Maybe we could add another option like ` timeout` and if you specify zero it means no timeout