https://authzed.com logo
Title
w

williamdclt

11/21/2022, 1:04 PM
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

vroldanbet

11/21/2022, 1:08 PM
you run the
spicedb migrate
command manually, and after an hour it failed? What error did it provide?
w

williamdclt

11/21/2022, 2:01 PM
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

Joey

11/21/2022, 3:08 PM
How many rows are in your relationships and transactions tables? @Jake
j

Jake

11/21/2022, 3:11 PM
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

williamdclt

11/21/2022, 3:37 PM
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

vroldanbet

11/21/2022, 4:23 PM
Maybe we could add another option like
--timeout
and if you specify zero it means no timeout?