Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Flaky MySQL tests #1401

Open
1 task done
miparnisari opened this issue Feb 26, 2024 · 1 comment
Open
1 task done

Flaky MySQL tests #1401

miparnisari opened this issue Feb 26, 2024 · 1 comment
Labels
enhancement New feature or request help wanted Extra attention is needed Stale

Comments

@miparnisari
Copy link
Member

Checklist

Describe the problem you'd like to have solved

https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655

go generate ./...
go test -race \
		-coverpkg=./... \
		-coverprofile=coverageunit.tmp.out \
		-covermode=atomic \
		-count=1 \
		-timeout=10m \
		./...
?   	github.com/openfga/openfga/assets	[no test files]
?   	github.com/openfga/openfga/cmd	[no test files]
?   	github.com/openfga/openfga/cmd/openfga	[no test files]
?   	github.com/openfga/openfga/cmd/util	[no test files]
?   	github.com/openfga/openfga/internal/authn	[no test files]
?   	github.com/openfga/openfga/internal/authn/oidc	[no test files]
?   	github.com/openfga/openfga/internal/authn/presharedkey	[no test files]
?   	github.com/openfga/openfga/internal/build	[no test files]
?   	github.com/openfga/openfga/internal/condition/metrics	[no test files]
?   	github.com/openfga/openfga/internal/middleware/authn	[no test files]
?   	github.com/openfga/openfga/internal/mocks	[no test files]
?   	github.com/openfga/openfga/internal/test/check	[no test files]
?   	github.com/openfga/openfga/internal/test/listobjects	[no test files]
ok  	github.com/openfga/openfga/cmd/migrate	42.036s	coverage: 17.7% of statements in ./...
?   	github.com/openfga/openfga/pkg/middleware/logging	[no test files]
ok  	github.com/openfga/openfga/cmd/run	40.641s	coverage: 4[5](https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655#step:4:6).3% of statements in ./...
ok  	github.com/openfga/openfga/cmd/validatemodels	31.314s	coverage: 22.9% of statements in ./...
ok  	github.com/openfga/openfga/internal/condition	1.127s	coverage: 55.9% of statements in ./...
ok  	github.com/openfga/openfga/internal/condition/eval	1.117s	coverage: 27.4% of statements in ./...
ok  	github.com/openfga/openfga/internal/condition/types	1.0[6](https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655#step:4:7)4s	coverage: 63.6% of statements in ./...
ok  	github.com/openfga/openfga/internal/graph	16.406s	coverage: 54.6% of statements in ./...
ok  	github.com/openfga/openfga/internal/keys	1.063s	coverage: 24.3% of statements in ./...
ok  	github.com/openfga/openfga/internal/server/config	1.014s	coverage: 88.9% of statements in ./...
ok  	github.com/openfga/openfga/internal/utils	1.012s	coverage: 100.0% of statements in ./...
ok  	github.com/openfga/openfga/internal/validation	1.063s	coverage: 19.8% of statements in ./...
ok  	github.com/openfga/openfga/pkg/encoder	1.011s	coverage: [7](https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655#step:4:8).7% of statements in ./...
ok  	github.com/openfga/openfga/pkg/encrypter	1.010s	coverage: 72.0% of statements in ./...
ok  	github.com/openfga/openfga/pkg/gateway	1.01[8](https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655#step:4:9)s	coverage: 8.7% of statements in ./...
ok  	github.com/openfga/openfga/pkg/logger	1.015s	coverage: 21.4% of statements in ./...
ok  	github.com/openfga/openfga/pkg/middleware/http	1.055s	coverage: 12.3% of statements in ./...
ok  	github.com/openfga/openfga/pkg/middleware/requestid	3.365s	coverage: [9](https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655#step:4:10)2.3% of statements in ./...
ok  	github.com/openfga/openfga/pkg/middleware/storeid	1.062s	coverage: 90.9% of statements in ./...
ok  	github.com/openfga/openfga/pkg/middleware/validator	3.2[10](https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655#step:4:11)s	coverage: 100.0% of statements in ./...
?   	github.com/openfga/openfga/pkg/server/health	[no test files]
?   	github.com/openfga/openfga/pkg/server/test	[no test files]
?   	github.com/openfga/openfga/pkg/storage/test	[no test files]
?   	github.com/openfga/openfga/pkg/testfixtures/storage	[no test files]
?   	github.com/openfga/openfga/pkg/testutils	[no test files]
ok  	github.com/openfga/openfga/pkg/server	83.581s	coverage: 67.1% of statements in ./...
ok  	github.com/openfga/openfga/pkg/server/commands	1.170s	coverage: 9.1% of statements in ./...
ok  	github.com/openfga/openfga/pkg/server/commands/reverseexpand	1.102s	coverage: [11](https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655#step:4:12).0% of statements in ./...
ok  	github.com/openfga/openfga/pkg/server/errors	1.086s	coverage: 42.8% of statements in ./...
ok  	github.com/openfga/openfga/pkg/storage	1.058s	coverage: 21.6% of statements in ./...
ok  	github.com/openfga/openfga/pkg/storage/memory	3.243s	coverage: 50.0% of statements in ./...
ok  	github.com/openfga/openfga/pkg/storage/mysql	85.098s	coverage: 48.8% of statements in ./...
ok  	github.com/openfga/openfga/pkg/storage/postgres	16.062s	coverage: 48.7% of statements in ./...
ok  	github.com/openfga/openfga/pkg/storage/sqlcommon	1.052s	coverage: 4.2% of statements in ./...
ok  	github.com/openfga/openfga/pkg/storage/storagewrappers	6.085s	coverage: 11.0% of statements in ./...
ok  	github.com/openfga/openfga/pkg/telemetry	1.054s	coverage: 13.9% of statements in ./...
ok  	github.com/openfga/openfga/pkg/tuple	1.096s	coverage: 52.1% of statements in ./...
ok  	github.com/openfga/openfga/pkg/typesystem	2.184s	coverage: 37.0% of statements in ./...
ok  	github.com/openfga/openfga/tests	4.533s	coverage: 36.8% of statements in ./...
ok  	github.com/openfga/openfga/tests/check	34.523s	coverage: 40.4% of statements in ./...
2024-02-26T16:24:20.391Z	ERROR	rpc error: code = Code(4000) desc = Internal Server Error	{"grpc_service": "openfga.v1.OpenFGAService", "grpc_method": "StreamedListObjects", "grpc_type": "server_stream", "request_id": "7adf3e07-b5a1-47f2-95b4-b1682ebc9162", "user_agent": "grpc-go/1.61.1", "raw_request": {"store_id":"01HQK3PH1ZEHG37KVBY8BA6PB7","authorization_model_id":"01HQK3PH2JJWVH3H80G5K38Y92","type":"folder","relation":"can_view","user":"user:anne","contextual_tuples":{"tuple_keys":[]},"context":null}, "raw_response": {"object":"folder:a"}, "raw_response": {"object":"folder:b"}, "peer.address": "[12](https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655#step:4:13)7.0.0.1:56008", "store_id": "01HQK3PH1ZEHG37KVBY8BA6PB7", "authorization_model_id": "01HQK3PH2JJWVH3H80G5K38Y92", "grpc_code": 4000, "internal_error": "1 error occurred:\n\t* sql error: driver: bad connection\n\n"}
2024-02-26T16:24:20.426Z	ERROR	rpc error: code = Code(4000) desc = Internal Server Error	{"grpc_service": "openfga.v1.OpenFGAService", "grpc_method": "ListObjects", "grpc_type": "unary", "request_id": "5a81b81f-deaf-427b-9ccf-e2d2ba565d58", "user_agent": "grpc-go/1.61.1", "raw_request": {"store_id":"01HQK3PH21RYGEG2WA3KEH0HWA","authorization_model_id":"01HQK3PH2DKNZ21A1WYAYTSTFJ","type":"folder","relation":"viewer","user":"user:anne","contextual_tuples":{"tuple_keys":[]},"context":null}, "raw_response": {"code":"internal_error","message":"Internal Server Error"}, "peer.address": "127.0.0.1:56008", "store_id": "01HQK3PH21RYGEG2WA3KEH0HWA", "authorization_model_id": "01HQK3PH2DKNZ21A1WYAYTSTFJ", "grpc_code": 4000, "internal_error": "2 errors occurred:\n\t* sql error: driver: bad connection\n\t* sql error: driver: bad connection\n\n"}
2024-02-26T16:24:20.506Z	ERROR	rpc error: code = Code(4000) desc = Internal Server Error	{"grpc_service": "openfga.v1.OpenFGAService", "grpc_method": "ListObjects", "grpc_type": "unary", "request_id": "074900b3-306b-44b5-bec7-6e4d0a529779", "user_agent": "grpc-go/1.61.1", "raw_request": {"store_id":"01HQK3PH5AA9H4HACNFVVH44V6","authorization_model_id":"01HQK3PH64TRYBV4AS6BAKM864","type":"folder","relation":"viewer","user":"user:anne","contextual_tuples":{"tuple_keys":[{"user":"user:anne","relation":"owner","object":"module:a","condition":null},{"user":"module:a","relation":"parent","object":"folder:a","condition":null},{"user":"folder:a","relation":"parent","object":"document:a","condition":null},{"user":"document:a","relation":"parent","object":"module:b","condition":null},{"user":"module:b","relation":"parent","object":"folder:b","condition":null},{"user":"folder:b","relation":"parent","object":"document:b","condition":null}]},"context":null}, "raw_response": {"code":"internal_error","message":"Internal Server Error"}, "peer.address": "127.0.0.1:56008", "store_id": "01HQK3PH5AA9H4HACNFVVH44V6", "authorization_model_id": "01HQK3PH64TRYBV4AS6BAKM864", "grpc_code": 4000, "internal_error": "1 error occurred:\n\t* sql error: driver: bad connection\n\n"}
2024-02-26T16:24:20.507Z	ERROR	rpc error: code = Code(4000) desc = Internal Server Error	{"grpc_service": "openfga.v1.OpenFGAService", "grpc_method": "ListObjects", "grpc_type": "unary", "request_id": "88a475cd-a3cd-4c9a-9983-57a0502fed81", "user_agent": "grpc-go/1.61.1", "raw_request": {"store_id":"01HQK3PH6B6T27DC1SJYK8NC3J","authorization_model_id":"01HQK3PH6ZRS4W6Y16PE[14](https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655#step:4:15)2WJF","type":"folder","relation":"viewer","user":"user:anne","contextual_tuples":{"tuple_keys":[{"user":"user:anne","relation":"owner","object":"module:a","condition":null},{"user":"module:a","relation":"parent","object":"folder:a","condition":null},{"user":"folder:a","relation":"parent","object":"document:a","condition":null},{"user":"document:a","relation":"parent","object":"module:b","condition":null},{"user":"module:b","relation":"parent","object":"folder:b","condition":null},{"user":"folder:b","relation":"parent","object":"document:b","condition":null}]},"context":null}, "raw_response": {"code":"internal_error","message":"Internal Server Error"}, "store_id": "01HQK3PH6B6T27DC1SJYK8NC3J", "authorization_model_id": "01HQK3PH6ZRS4W6Y16PE142WJF", "peer.address": "127.0.0.1:56008", "grpc_code": 4000, "internal_error": "1 error occurred:\n\t* sql error: driver: bad connection\n\n"}
2024-02-26T16:24:20.521Z	ERROR	rpc error: code = Code(4000) desc = Internal Server Error	{"grpc_service": "openfga.v1.OpenFGAService", "grpc_method": "ListObjects", "grpc_type": "unary", "request_id": "5179926c-4eca-4fe5-a6a8-c1e72c06[15](https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655#step:4:16)17", "user_agent": "grpc-go/1.61.1", "raw_request": {"store_id":"01HQK3PH5461GWX3MFXE4ENGWG","authorization_model_id":"01HQK3PH66QZHXJ75QM19C7J8W","type":"folder","relation":"viewer","user":"user:anne","contextual_tuples":{"tuple_keys":[{"user":"user:anne","relation":"owner","object":"module:a","condition":null},{"user":"module:a","relation":"parent","object":"folder:a","condition":null},{"user":"folder:a","relation":"parent","object":"document:a","condition":null},{"user":"document:a","relation":"parent","object":"module:b","condition":null},{"user":"module:b","relation":"parent","object":"folder:b","condition":null},{"user":"folder:b","relation":"parent","object":"document:b","condition":null},{"user":"document:b","relation":"parent","object":"module:a","condition":null}]},"context":null}, "raw_response": {"code":"internal_error","message":"Internal Server Error"}, "store_id": "01HQK3PH5461GWX3MFXE4ENGWG", "authorization_model_id": "01HQK3PH66QZHXJ75QM19C7J8W", "peer.address": "127.0.0.1:56008", "grpc_code": 4000, "internal_error": "2 errors occurred:\n\t* sql error: driver: bad connection\n\t* sql error: driver: bad connection\n\n"}
2024-02-26T[16](https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655#step:4:17):24:20.627Z	ERROR	rpc error: code = Code(4000) desc = Internal Server Error	{"grpc_service": "openfga.v1.OpenFGAService", "grpc_method": "StreamedListObjects", "grpc_type": "server_stream", "request_id": "2c14527b-f7ce-4658-98[17](https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655#step:4:18)-f47a2d3b1f69", "user_agent": "grpc-go/1.61.1", "raw_request": {"store_id":"01HQK3PH6B6T27DC1SJTZBRWNF","authorization_model_id":"01HQK3PH71GBJQ27VX8CG3ECBA","type":"folder","relation":"viewer","user":"user:anne","contextual_tuples":{"tuple_keys":[]},"context":null}, "raw_response": {"object":"folder:a"}, "peer.address": "127.0.0.1:56008", "store_id": "01HQK3PH6B6T27DC1SJTZBRWNF", "authorization_model_id": "01HQK3PH71GBJQ27VX8CG3ECBA", "grpc_code": 4000, "internal_error": "1 error occurred:\n\t* sql error: driver: bad connection\n\n"}
2024-02-26T16:24:20.629Z	ERROR	rpc error: code = Code(4000) desc = Internal Server Error	{"grpc_service": "openfga.v1.OpenFGAService", "grpc_method": "ListObjects", "grpc_type": "unary", "request_id": "6dc52c3b-6f23-4eb4-a2e3-ec6c0cb6a35d", "user_agent": "grpc-go/1.61.1", "raw_request": {"store_id":"01HQK3PH8XCJ08Z1VDMV962N0H","authorization_model_id":"01HQK3PH9PRBZDZ8C8X2ENTSDA","type":"folder","relation":"viewer","user":"user:anne","contextual_tuples":{"tuple_keys":[]},"context":null}, "raw_response": {"code":"internal_error","message":"Internal Server Error"}, "peer.address": "127.0.0.1:56008", "store_id": "01HQK3PH8XCJ08Z1VDMV962N0H", "authorization_model_id": "01HQK3PH9PRBZDZ8C8X2ENTSDA", "grpc_code": 4000, "internal_error": "2 errors occurred:\n\t* sql error: driver: bad connection\n\t* sql error: driver: bad connection\n\n"}
2024-02-26T16:24:21.151Z	ERROR	rpc error: code = Code(4000) desc = Internal Server Error	{"grpc_service": "openfga.v1.OpenFGAService", "grpc_method": "ListObjects", "grpc_type": "unary", "request_id": "e31489c8-9507-4088-b469-5121b171408e", "user_agent": "grpc-go/1.61.1", "raw_request": {"store_id":"01HQK3PHSQSYC1K44GYCZFPG5P","authorization_model_id":"01HQK3PHSZYPK3N5EM68VWGF15","type":"document","relation":"can_view","user":"user:jon","contextual_tuples":{"tuple_keys":[{"user":"user:jon","relation":"allowed","object":"document:1","condition":null},{"user":"user:*","relation":"viewer","object":"document:1","condition":null},{"user":"user:*","relation":"viewer","object":"document:2","condition":null}]},"context":null}, "raw_response": {"code":"internal_error","message":"Internal Server Error"}, "authorization_model_id": "01HQK3PHSZYPK3N5EM68VWGF15", "peer.address": "127.0.0.1:56008", "store_id": "01HQK3PHSQSYC1K44GYCZFPG5P", "grpc_code": 4000, "internal_error": "sql error: driver: bad connection"}
2024-02-26T16:24:21.155Z	ERROR	rpc error: code = Code(4000) desc = Internal Server Error	{"grpc_service": "openfga.v1.OpenFGAService", "grpc_method": "ListObjects", "grpc_type": "unary", "request_id": "12ec5700-1b3b-41ba-b2cb-e9467afc91d5", "user_agent": "grpc-go/1.61.1", "raw_request": {"store_id":"01HQK3PHM9EBE2TK8KZBAX7H8Q","authorization_model_id":"01HQK3PHR6QFZJAFJV5XZPXDYK","type":"folder","relation":"can_read","user":"user:anne","contextual_tuples":{"tuple_keys":[]},"context":null}, "raw_response": {"code":"internal_error","message":"Internal Server Error"}, "peer.address": "127.0.0.1:56008", "store_id": "01HQK3PHM9EBE2TK8KZBAX7H8Q", "authorization_model_id": "01HQK3PHR6QFZJAFJV5XZPXDYK", "grpc_code": 4000, "internal_error": "1 error occurred:\n\t* sql error: driver: bad connection\n\n"}
--- FAIL: TestListObjectsMySQL (17.27s)
    tests.go:54: creating connection to address 0.0.0.0:40565
    testutils.go:192: 2024-02-26 16:24:17.92734617 +0000 UTC m=+37.454223146 not serving yet at address 0.0.0.0:40565 rpc error: code = Unavailable desc = connection error: desc = "transport: Error while dialing: dial tcp 0.0.0.0:40565: connect: connection refused"
    testutils.go:192: 2024-02-26 16:24:[18](https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655#step:4:19).553800656 +0000 UTC m=+38.080677632 not serving yet at address 0.0.0.0:40565 rpc error: code = Unavailable desc = connection error: desc = "transport: Error while dialing: dial tcp 0.0.0.0:40565: connect: connection refused"
    --- FAIL: TestListObjectsMySQL/RunAll (0.00s)
        --- FAIL: TestListObjectsMySQL/RunAll/ListObjects (0.00s)
            --- FAIL: TestListObjectsMySQL/RunAll/ListObjects/Schema1_1 (0.17s)
                --- FAIL: TestListObjectsMySQL/RunAll/ListObjects/Schema1_1/computed_user_multi_route (0.11s)
                    listobjects.go:243: 
                        	Error Trace:	/home/runner/work/openfga/openfga/tests/listobjects/listobjects.go:243
                        	Error:      	Received unexpected error:
                        	            	rpc error: code = Unknown desc = rpc error: code = Code(4000) desc = Internal Server Error
                        	Test:       	TestListObjectsMySQL/RunAll/ListObjects/Schema1_1/computed_user_multi_route
                        	Messages:   	ListObject request: type:"folder"  relation:"can_view"  user:"user:anne". Model: model
                        	            	  schema 1.1
                        	            	type user
                        	            	type folder
                        	            	  relations
                        	            	    define owner: [user] or owner from parent
                        	            	    define can_modify: owner
                        	            	    define parent: [folder]
                        	            	    define viewer: [user] or can_modify or viewer from parent
                        	            	    define can_view: viewer
                        	            	type document
                        	            	  relations
                        	            	    define can_read: can_view from parent or can_modify from parent
                        	            	    define parent: [document, folder]
                        	            	    define viewer: [user, user:*]
                        	            	. Tuples: [user:"user:anne"  relation:"owner"  object:"folder:a" user:"folder:a"  relation:"parent"  object:"folder:b" user:"folder:b"  relation:"parent"  object:"document:c" user:"document:c"  relation:"parent"  object:"document:d"]. Contextual tuples: []
                --- FAIL: TestListObjectsMySQL/RunAll/ListObjects/Schema1_1/three_prong_relation_possible_exclusion (0.14s)
                    listobjects.go:[19](https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655#step:4:20)8: 
                        	Error Trace:	/home/runner/work/openfga/openfga/tests/listobjects/listobjects.go:198
                        	Error:      	Received unexpected error:
                        	            	rpc error: code = Unknown desc = rpc error: code = Code(4000) desc = Internal Server Error
                        	Test:       	TestListObjectsMySQL/RunAll/ListObjects/Schema1_1/three_prong_relation_possible_exclusion
                        	Messages:   	ListObject request: type:"folder"  relation:"viewer"  user:"user:anne". Model: model
                        	            	  schema 1.1
                        	            	type user
                        	            	type module
                        	            	  relations
                        	            	    define owner: [user] or has_owned from parent
                        	            	    define parent: [document, module]
                        	            	    define has_owned: owner
                        	            	    define viewer: [user] or has_owned or viewer from parent
                        	            	type folder
                        	            	  relations
                        	            	    define owner: [user] or has_owned from parent
                        	            	    define parent: [module, folder]
                        	            	    define has_owned: owner
                        	            	    define viewer: [user] or has_owned or viewer from parent
                        	            	type document
                        	            	  relations
                        	            	    define banned: [user]
                        	            	    define owner: [user] or has_owned from parent
                        	            	    define has_owned: owner but not banned
                        	            	    define parent: [folder, document]
                        	            	    define viewer: [user] or has_owned or viewer from parent
                        	            	. Tuples: [user:"user:anne"  relation:"owner"  object:"module:a" user:"module:a"  relation:"parent"  object:"folder:a" user:"folder:a"  relation:"parent"  object:"document:a" user:"document:a"  relation:"parent"  object:"module:b" user:"module:b"  relation:"parent"  object:"folder:b" user:"folder:b"  relation:"parent"  object:"document:b"]. Contextual tuples: []
                --- FAIL: TestListObjectsMySQL/RunAll/ListObjects/Schema1_1/three_prong_relation_possible_exclusion_ctxTuples (0.11s)
                    listobjects.go:198: 
                        	Error Trace:	/home/runner/work/openfga/openfga/tests/listobjects/listobjects.go:198
                        	Error:      	Received unexpected error:
                        	            	rpc error: code = Unknown desc = rpc error: code = Code(4000) desc = Internal Server Error
                        	Test:       	TestListObjectsMySQL/RunAll/ListObjects/Schema1_1/three_prong_relation_possible_exclusion_ctxTuples
                        	Messages:   	ListObject request: type:"folder"  relation:"viewer"  user:"user:anne". Model: model
                        	            	  schema 1.1
                        	            	type user
                        	            	type module
                        	            	  relations
                        	            	    define owner: [user] or has_owned from parent
                        	            	    define parent: [document, module]
                        	            	    define has_owned: owner
                        	            	    define viewer: [user] or has_owned or viewer from parent
                        	            	type folder
                        	            	  relations
                        	            	    define owner: [user] or has_owned from parent
                        	            	    define parent: [module, folder]
                        	            	    define has_owned: owner
                        	            	    define viewer: [user] or has_owned or viewer from parent
                        	            	type document
                        	            	  relations
                        	            	    define banned: [user]
                        	            	    define owner: [user] or has_owned from parent
                        	            	    define has_owned: owner but not banned
                        	            	    define parent: [folder, document]
                        	            	    define viewer: [user] or has_owned or viewer from parent
                        	            	. Tuples: [user:"user:anne"  relation:"owner"  object:"module:a" user:"module:a"  relation:"parent"  object:"folder:a" user:"folder:a"  relation:"parent"  object:"document:a" user:"document:a"  relation:"parent"  object:"module:b" user:"module:b"  relation:"parent"  object:"folder:b" user:"folder:b"  relation:"parent"  object:"document:b"]. Contextual tuples: []
                --- FAIL: TestListObjectsMySQL/RunAll/ListObjects/Schema1_1/three_prong_relation_ctxTuples (0.08s)
                    listobjects.go:198: 
                        	Error Trace:	/home/runner/work/openfga/openfga/tests/listobjects/listobjects.go:198
                        	Error:      	Received unexpected error:
                        	            	rpc error: code = Unknown desc = rpc error: code = Code(4000) desc = Internal Server Error
                        	Test:       	TestListObjectsMySQL/RunAll/ListObjects/Schema1_1/three_prong_relation_ctxTuples
                        	Messages:   	ListObject request: type:"folder"  relation:"viewer"  user:"user:anne". Model: model
                        	            	  schema 1.1
                        	            	type user
                        	            	type module
                        	            	  relations
                        	            	    define owner: [user] or owner from parent
                        	            	    define parent: [document, module]
                        	            	    define viewer: [user] or owner or viewer from parent
                        	            	type folder
                        	            	  relations
                        	            	    define owner: [user] or owner from parent
                        	            	    define parent: [module, folder]
                        	            	    define viewer: [user] or owner or viewer from parent
                        	            	type document
                        	            	  relations
                        	            	    define owner: [user] or owner from parent
                        	            	    define parent: [folder, document]
                        	            	    define viewer: [user] or owner or viewer from parent
                        	            	. Tuples: [user:"user:anne"  relation:"owner"  object:"module:a" user:"module:a"  relation:"parent"  object:"folder:a" user:"folder:a"  relation:"parent"  object:"document:a" user:"document:a"  relation:"parent"  object:"module:b" user:"module:b"  relation:"parent"  object:"folder:b" user:"folder:b"  relation:"parent"  object:"document:b"]. Contextual tuples: []
                --- FAIL: TestListObjectsMySQL/RunAll/ListObjects/Schema1_1/three_prong_relation_loop_ctxTuples (0.14s)
                    listobjects.go:198: 
                        	Error Trace:	/home/runner/work/openfga/openfga/tests/listobjects/listobjects.go:198
                        	Error:      	Received unexpected error:
                        	            	rpc error: code = Unknown desc = rpc error: code = Code(4000) desc = Internal Server Error
                        	Test:       	TestListObjectsMySQL/RunAll/ListObjects/Schema1_1/three_prong_relation_loop_ctxTuples
                        	Messages:   	ListObject request: type:"folder"  relation:"viewer"  user:"user:anne". Model: model
                        	            	  schema 1.1
                        	            	type user
                        	            	type module
                        	            	  relations
                        	            	    define owner: [user] or owner from parent
                        	            	    define parent: [document, module]
                        	            	    define viewer: [user] or owner or viewer from parent
                        	            	type folder
                        	            	  relations
                        	            	    define owner: [user] or owner from parent
                        	            	    define parent: [module, folder]
                        	            	    define viewer: [user] or owner or viewer from parent
                        	            	type document
                        	            	  relations
                        	            	    define owner: [user] or owner from parent
                        	            	    define parent: [folder, document]
                        	            	    define viewer: [user] or owner or viewer from parent
                        	            	. Tuples: [user:"user:anne"  relation:"owner"  object:"module:a" user:"module:a"  relation:"parent"  object:"folder:a" user:"folder:a"  relation:"parent"  object:"document:a" user:"document:a"  relation:"parent"  object:"module:b" user:"module:b"  relation:"parent"  object:"folder:b" user:"folder:b"  relation:"parent"  object:"document:b" user:"document:b"  relation:"parent"  object:"module:a"]. Contextual tuples: []
                --- FAIL: TestListObjectsMySQL/RunAll/ListObjects/Schema1_1/three_prong_relation_loop (0.[20](https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655#step:4:21)s)
                    listobjects.go:[24](https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655#step:4:25)3: 
                        	Error Trace:	/home/runner/work/openfga/openfga/tests/listobjects/listobjects.go:243
                        	Error:      	Received unexpected error:
                        	            	rpc error: code = Unknown desc = rpc error: code = Code(4000) desc = Internal Server Error
                        	Test:       	TestListObjectsMySQL/RunAll/ListObjects/Schema1_1/three_prong_relation_loop
                        	Messages:   	ListObject request: type:"folder"  relation:"viewer"  user:"user:anne". Model: model
                        	            	  schema 1.1
                        	            	type user
                        	            	type module
                        	            	  relations
                        	            	    define owner: [user] or owner from parent
                        	            	    define parent: [document, module]
                        	            	    define viewer: [user] or owner or viewer from parent
                        	            	type folder
                        	            	  relations
                        	            	    define owner: [user] or owner from parent
                        	            	    define parent: [module, folder]
                        	            	    define viewer: [user] or owner or viewer from parent
                        	            	type document
                        	            	  relations
                        	            	    define owner: [user] or owner from parent
                        	            	    define parent: [folder, document]
                        	            	    define viewer: [user] or owner or viewer from parent
                        	            	. Tuples: [user:"user:anne"  relation:"owner"  object:"module:a" user:"module:a"  relation:"parent"  object:"folder:a" user:"folder:a"  relation:"parent"  object:"document:a" user:"document:a"  relation:"parent"  object:"module:b" user:"module:b"  relation:"parent"  object:"folder:b" user:"folder:b"  relation:"parent"  object:"document:b" user:"document:b"  relation:"parent"  object:"module:a"]. Contextual tuples: []
                --- FAIL: TestListObjectsMySQL/RunAll/ListObjects/Schema1_1/three_prong_relation (0.12s)
                    listobjects.go:198: 
                        	Error Trace:	/home/runner/work/openfga/openfga/tests/listobjects/listobjects.go:198
                        	Error:      	Received unexpected error:
                        	            	rpc error: code = Unknown desc = rpc error: code = Code(4000) desc = Internal Server Error
                        	Test:       	TestListObjectsMySQL/RunAll/ListObjects/Schema1_1/three_prong_relation
                        	Messages:   	ListObject request: type:"folder"  relation:"viewer"  user:"user:anne". Model: model
                        	            	  schema 1.1
                        	            	type user
                        	            	type module
                        	            	  relations
                        	            	    define owner: [user] or owner from parent
                        	            	    define parent: [document, module]
                        	            	    define viewer: [user] or owner or viewer from parent
                        	            	type folder
                        	            	  relations
                        	            	    define owner: [user] or owner from parent
                        	            	    define parent: [module, folder]
                        	            	    define viewer: [user] or owner or viewer from parent
                        	            	type document
                        	            	  relations
                        	            	    define owner: [user] or owner from parent
                        	            	    define parent: [folder, document]
                        	            	    define viewer: [user] or owner or viewer from parent
                        	            	. Tuples: [user:"user:anne"  relation:"owner"  object:"module:a" user:"module:a"  relation:"parent"  object:"folder:a" user:"folder:a"  relation:"parent"  object:"document:a" user:"document:a"  relation:"parent"  object:"module:b" user:"module:b"  relation:"parent"  object:"folder:b" user:"folder:b"  relation:"parent"  object:"document:b"]. Contextual tuples: []
                --- FAIL: TestListObjectsMySQL/RunAll/ListObjects/Schema1_1/relation_with_wildcard_involving_intersection_ctxTuples (0.11s)
                    listobjects.go:198: 
                        	Error Trace:	/home/runner/work/openfga/openfga/tests/listobjects/listobjects.go:198
                        	Error:      	Received unexpected error:
                        	            	rpc error: code = Unknown desc = rpc error: code = Code(4000) desc = Internal Server Error
                        	Test:       	TestListObjectsMySQL/RunAll/ListObjects/Schema1_1/relation_with_wildcard_involving_intersection_ctxTuples
                        	Messages:   	ListObject request: type:"document"  relation:"can_view"  user:"user:jon". Model: model
                        	            	  schema 1.1
                        	            	type user
                        	            	type document
                        	            	  relations
                        	            	    define allowed: [user]
                        	            	    define viewer: [user:*] and allowed
                        	            	    define can_view: viewer
                        	            	. Tuples: [user:"user:jon"  relation:"allowed"  object:"document:1" user:"user:*"  relation:"viewer"  object:"document:1" user:"user:*"  relation:"viewer"  object:"document:2"]. Contextual tuples: []
                --- FAIL: TestListObjectsMySQL/RunAll/ListObjects/Schema1_1/list_objects_expands_wildcard_tuple (0.[30](https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655#step:4:31)s)
                    listobjects.go:198: 
                        	Error Trace:	/home/runner/work/openfga/openfga/tests/listobjects/listobjects.go:198
                        	Error:      	Received unexpected error:
                        	            	rpc error: code = Unknown desc = rpc error: code = Code([40](https://github.com/openfga/openfga/actions/runs/8052034021/job/21991285655#step:4:41)00) desc = Internal Server Error
                        	Test:       	TestListObjectsMySQL/RunAll/ListObjects/Schema1_1/list_objects_expands_wildcard_tuple
                        	Messages:   	ListObject request: type:"folder"  relation:"can_read"  user:"user:anne". Model: model
                        	            	  schema 1.1
                        	            	type user
                        	            	type folder
                        	            	  relations
                        	            	    define parent: [folder]
                 	            	    define owner: [group]
                 	            	    define parent: [group]
0s
0s

Describe the ideal solution

It looks like MySQL connections are dropped mid-way of test execution. We'd like to prevent this.

It could also be that we are not waiting long enough for MySQL connections to be healthy before proceeding with tests.

Alternatives and current workarounds

No response

Additional context

No response
@miparnisari miparnisari added enhancement New feature or request help wanted Extra attention is needed labels Feb 26, 2024
@github-actions GitHub Actions
Copy link

It appears this issue has been stale for at least 14 days 🗓️. If no action is taken the maintainer team may consider closing the issue. Please reach out if you need feedback or follow up actions from the maintainer team.

@github-actions github-actions bot added the Stale label Mar 12, 2024
@miparnisari miparnisari mentioned this issue Mar 20, 2024
Merged
@00chorch 00chorch mentioned this issue May 21, 2024
Closed
4 tasks
00chorch added a commit to 00chorch/openfga that referenced this issue May 21, 2024
@00chorch
refactor(tests): indent DSL inside tests under pkg server
a503d2e 
Pushing remaining test files of pkg server.
There's a known issue with some flaky tests (see openfga#1401) that might make
github workflow "pull requests / tests" fail
00chorch added a commit to 00chorch/openfga that referenced this issue May 24, 2024
@00chorch
chore(tests): increase grpc context timeout used while testing
930f2a0 
Hypothesis is that will prevent race conditions in tests while running
GRPC+healthz and MySQL container + ready to serve check.

Must say can't reproduce locally so will use draft PR to test hypothesis.

Related to issue openfga#1401
@00chorch 00chorch mentioned this issue May 24, 2024
Draft
4 tasks
00chorch added a commit to 00chorch/openfga that referenced this issue May 31, 2024
@00chorch
refactor(tests): indent DSL inside tests under pkg server
6b68661 
Pushing remaining test files of pkg server.
There's a known issue with some flaky tests (see openfga#1401) that might make
github workflow "pull requests / tests" fail
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request help wanted Extra attention is needed Stale
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@miparnisari