lostrainbow
11/02/2022, 5:05 PMJoey
11/02/2022, 5:05 PMJoey
11/02/2022, 5:05 PMlostrainbow
11/02/2022, 5:09 PMJoey
11/02/2022, 5:10 PMSanPeterDev
11/02/2022, 5:11 PMJoey
11/02/2022, 5:12 PMSanPeterDev
11/02/2022, 5:12 PMJoey
11/02/2022, 5:13 PMJoey
11/02/2022, 5:13 PMobject_type
Joey
11/02/2022, 5:13 PMobjectType
Joey
11/02/2022, 5:13 PMSanPeterDev
11/02/2022, 5:14 PMlostrainbow
11/02/2022, 5:25 PMJoey
11/02/2022, 5:27 PMJoey
11/02/2022, 5:27 PMlostrainbow
11/02/2022, 6:03 PMJoey
11/02/2022, 6:03 PMlostrainbow
11/02/2022, 6:04 PMlostrainbow
11/02/2022, 6:07 PMJoey
11/02/2022, 6:08 PMlostrainbow
11/02/2022, 6:08 PMSanPeterDev
11/03/2022, 7:37 AMwilliamdclt
11/03/2022, 9:53 AMcreated_transaction
column and adding a new created_xid
(as well as other things).
- v1.13.0 relies on created_transaction
, v1.14.0 relies on created_xid
Doesn't that cause backward/forward compatibility issues?
- If the migration is ran as a pre-update hook, SpiceDB will be failing while created_transaction
doesn't exist anymore but v1.13.0 is still running
- If the migration is ran as a post-update hook, SpiceDB will be failing while created_xid
doesn't exist yet but v1.14.0 is already runningPrchowdh
11/03/2022, 9:56 AMdefinition kylelobosb_ecommerce/user {}
Any suggestion to avoid this ?ecordell
11/03/2022, 2:12 PMspicedb migrate add-xid-columns
- update spicedb to 1.14 with --datastore-migration-phase=write-both-read-old
- run spicedb migrate add-xid-constraints
- update spicedb with the flag --datastore-migration-phase=write-both-read-new
- run spicedb migrate drop-id-constraints
- update spicedb to remove the --datastore-migration-phase
flag
the next release of the operator will support walking through these phases automatically, but those are the manual stepsIgor.Shmukler
11/03/2022, 2:31 PMspicedb migrate head
and zed schema write
- both failed for me.
Full error output logs are below:Igor.Shmukler
11/03/2022, 2:32 PMhead
revision: error executing migration `add-xid-columns`: ERROR: type \"xid8\" does not exist (SQLSTATE 42704)","time":"2022-11-03T14:25:22Z","message":"terminated with errors"}
```Igor.Shmukler
11/03/2022, 2:32 PM$ zed schema write schema.zed
10:25AM FTL failed to write schema error="rpc error: code = Unknown desc = unable to find revision: ERROR: column \"xid\" does not exist (SQLSTATE 42703)"
Ideas/suggestions?Jake
11/03/2022, 2:32 PM