trying to send a few batches of 1,000 relationship touches. I'll paste the Go code in case anyone is interested, but so far this code has not worked against the memdb docker container, or a MySQL backed instance. Both result in about only one or two batches succeeding, the rest fail with the

serialization

error in the case of memDB, or timeout in the case of MySQL.

given a schema of

definition document {
    relation reader: user
  }

  definition user {}

Here's the Go code that demonstrates concurrent updates failing

it's been pretty reproducible for me. I started to test this against local docker container because I was seeing strange transaction timeouts against MySQL, but kind of looks like a similar issue exists in the memdb?

TOUCH

is also more expensive on MySQL: it has to delete the older relationship before creating the new one (if any)

use

CREATE

if you're backfilling