I'm upgrading to v1.14 on Postgres: `migrate add-x...
# spicedb
w
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!
v
you run the
spicedb migrate
command manually, and after an hour it failed? What error did it provide?
w
Exactly. It gave me
context deadline exceeded
After an hour exactly, so I assume it's a builtin timeout somewhere, AFAIK this
context deadline exceeded
is a fairly generic Go thing
j
How many rows are in your relationships and transactions tables? @Jake
j
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
w
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 😄
v
Maybe we could add another option like
--timeout
and if you specify zero it means no timeout?