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.

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

Hasura metadata apply ends with ERROR: deadlock detected #6481

Closed
dostalradim opened this issue Jan 25, 2021 · 1 comment
Closed

Hasura metadata apply ends with ERROR: deadlock detected #6481

dostalradim opened this issue Jan 25, 2021 · 1 comment

Comments

@dostalradim
Copy link

Hello, we got this error during hasura apply metadata.

Graphql-engine is in version 1.3.4 and binary hasura-cli is in 1.3.0 could it be the issue? Is mandatory to use completly same version including patch version? Postgres version is 12.5.

Or, do you know some reason why this error should appear?

We solved it with a second try and it was successful.

Thank you

2021-01-22 19:30:00.374 CET [4766] ERROR: deadlock detected
2021-01-22 19:30:00.374 CET [4766] DETAIL: Process 4766 waits for AccessExclusiveLock on relation 21113 of database 20374; blocked by process 4727.
Process 4727 waits for AccessShareLock on relation 20982 of database 20374; blocked by process 4766.
Process 4766: DROP FUNCTION IF EXISTS hdb_views."notify_hasura_aktualizaceTelefonnihoHovoru_INSERT"() CASCADE
Process 4727: SELECT coalesce(json_agg("root" ), '[]' ) AS "root" FROM (SELECT row_to_json((SELECT "_2_e" FROM (SELECT "_1_root.base"."id" AS "id", "_1_root.base"."zacatek" AS "zacatek", "_1_root.base"."konec" AS "konec", "_1_root.base"."casSpojeni" AS "casSpojeni", "_1_root.base"."typ_id" AS "typ_id", "_1_root.base"."procesVyresitZmeskanyHovor_id" AS "procesVyresitZmeskanyHovor_id", "_1_root.base"."procesOdchoziHovor_id" AS "procesOdchoziHovor_id", "_1_root.base"."procesZaznamenatHovor_id" AS "procesZaznamenatHovor_id", "_1_root.base"."volajici" AS "volajici", "_1_root.base"."telefonniCisloProtistrany" AS "telefonniCisloProtistrany" ) AS "_2_e" ) ) AS "root" FROM (SELECT * FROM "public"."telefonniHovor" WHERE ((("public"."telefonniHovor"."telefonniCisloProtistrany") = (($2)::text)) AND (EXISTS (SELECT 1 FROM "public"."proces" AS "_0__be_0_proces" WHERE (((("_0__be_0_proces"."id") = ("public"."telefonniHovor"."procesVyresitZmeskanyHovor_id")) AND ('true')) AND ((((("_0__be_0_proces"."state_stavPro
2021-01-22 19:30:00.374 CET [4766] HINT: See server log for query details.
2021-01-22 19:30:00.374 CET [4766] STATEMENT: DROP FUNCTION IF EXISTS hdb_views."notify_hasura_aktualizaceTelefonnihoHovoru_INSERT"() CASCADE
@tirumaraiselvan
Copy link
Contributor

Please use v1.3.3 CLI as it had a bug which caused this: #6115

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants