okay, let me try that
# spicedb
j
okay, let me try that
what are the exact
zed permission check
and
zed permission lookup-resource
commands you're running?
and are you certain the migration completed successfully?
i
Yes, I am.
Because without migration, there was a lot of errors on missed columns.
Copy code
āžœ  agio-renderfarm git:(develop) zed permission lookup scene view user:2c222ab9-3b32-4da1-a279-0efcbcbdf077 --insecure 
8e20d910-51e7-4de8-8297-392cb974310a
163515d1-4acb-4f9b-92db-961214546b1e
402cc0a6-80e3-4172-80da-65eec7d6fbdb
2af92c8f-ae92-4c8f-9f4f-b0904acb9442
c0a242ba-49d0-42a7-9ee2-73d73442a588
a3c61068-196b-4248-95e6-74796d4f6a21
b150da18-b130-46bd-8700-b68ad847c409
08f4a6d2-dcca-4429-8ebb-4703240df17a
edc3dea5-934e-4858-9ef7-8cb003c00930
dc4fc4ea-3fbe-464d-8792-b4a48419f8dc
f997c6bd-0d3a-41f1-98b7-8966e7545eb9
5aef3e07-546a-4c35-99bd-ca847aa9a70a
ee1a95d4-c0e0-4228-8e2b-a730d346d598
463833c4-26a0-429b-bf41-6b64966b4feb
c8eec340-b126-4754-a030-c7d07e211aea
4926cb33-1139-4c16-acf1-a3467b723d67
51bcd2b0-a979-4874-baba-f459e426ee99
āžœ  agio-renderfarm git:(develop) zed permission check scene:77fbdc64-bb0c-45c2-a2e5-ed2669cdfac3 view user:2c222ab9-3b32-4da1-a279-0efcbcbdf077 --insecure 
true
j
can you try moving to v1.15.0 and seeing if it changes the output?
I don't know why it would, but I want to isolate whether it is a postgres problem or a code problem
i
Yes, one moment.
j
if that doesn't change anything, then I'd like to get a copy of your schema and a subset of test data to try to reproduce the problem
i
The same output with v.1.15.0
j
ok
very strange
if you add a new scene directly for the user
does it show up?
or even better, for a completely different user
I wonder if one of the postgres indexes is broken somehow
we do use a different index for the reverse relation queries
since the check and read works, the data is clearly present
i
It works if I added relationship directly.
j
okay
then I'll need a copy of your schema and some test data, ideally just the non-working set of relationships
if you're okay with sharing; we can do so privately via DM