okay let me try that

Question

Joey · Answer

what are the exact `zed permission check` and `zed permission lookup resource` commands you re running

Joey · Answer

and are you certain the migration completed successfully

Ilya Obukhov · Answer

Yes I am

Ilya Obukhov · Answer

Because without migration there was a lot of errors on missed columns

Ilya Obukhov · Answer

``` 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 ```

Joey · Answer

can you try moving to v1 15 0 and seeing if it changes the output

Joey · Answer

I don t know why it would but I want to isolate whether it is a postgres problem or a code problem

Ilya Obukhov · Answer

Yes one moment

Joey · Answer

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

Ilya Obukhov · Answer

The same output with v 1 15 0

Joey · Answer

ok

Joey · Answer

very strange

Joey · Answer

if you add a new scene directly for the user

Joey · Answer

does it show up

Joey · Answer

or even better for a completely different user

Joey · Answer

I wonder if one of the postgres indexes is broken somehow

Joey · Answer

we do use a different index for the reverse relation queries

Joey · Answer

since the check and read works the data is clearly present

Ilya Obukhov · Answer

It works if I added relationship directly

Joey · Answer

okay

Joey · Answer

then I ll need a copy of your schema and some test data ideally just the non working set of relationships

Joey · Answer

if you re okay with sharing we can do so privately via DM