Now I'm running into a different issue though. I a...
# spicedb
t
Now I'm running into a different issue though. I am seeing the following error show up in spicedb when running with postgres as datastore. Does that happen to ring a bell?
Copy code
{
  "level": "error",
  "requestID": "cv8pccaa6s3s72k5rfjg",
  "pgx": {
    "args": [
      5,
      {},
      true,
      {},
      false,
      "group",
      "watcher",
      "ac42n84t",
      "user",
      "1739",
      "..."
    ],
    "err": "ERROR: transaction ID 378516518 is in the future (SQLSTATE 22023)",
    "pid": 7078,
    "sql": "\n\t\tSELECT * FROM (SELECT namespace, object_id, relation, userset_namespace, userset_object_id, userset_relation, caveat_name, caveat_context FROM relation_tuple WHERE pg_visible_in_snapshot(created_xid, $1) = $2 AND pg_visible_in_snapshot(deleted_xid, $3) = $4 AND namespace = $5 AND relation = $6 AND object_id IN ($7) AND ((userset_namespace = $8 A...",
    "time": 2.804281
  },
  "time": "2025-03-12T14:12:01Z",
  "message": "Query"
}
The only thing I could find was something about transaction_id wrapping around at 2^31. I guess I'll try to run VACUUM and see what happens 🤷‍♂️
4 Views