provide more information in the logs when insert check constraint fails

hasura / graphql-engine

Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.

https://hasura.io

Apache License 2.0

31.08k stars 2.76k forks source link

provide more information in the logs when insert check constraint fails #1649

Open 0x777 opened 5 years ago

0x777 commented 5 years ago

Currently we throw this error message: Check constraint violation. insert check constraint failed which only hints at the problem. The logs should output the values of the row for which the constraint failed and the insert constraint as defined. This information along with the session variables should help debug the problem.

dijam commented 4 years ago

Any update on this ticket? :)

tirumaraiselvan commented 4 years ago

Related to #3658

dhmacs commented 4 years ago

This would help a lot now

dvasdekis commented 4 years ago

Am having the same problem

Manubi commented 4 years ago

same with me.

dylanesque commented 4 years ago

Having this problem as well

yash2code commented 3 years ago

brunobraga95 commented 3 years ago

Same here

rajat-sr commented 3 years ago

Same problem

Manubi commented 3 years ago

If I remember correctly, most of the time it has to do with the permissions. So just got to the table and check if the authenticated user has permission to do things. Permissions_-_animal_vaccination_-_Data___Hasura

dylanesque commented 3 years ago

Yes, but if the error message doesn't indicate that it's a permissions issue, it's unhelpful to developers newer to the platform.

rosjerry commented 11 months ago

any news on this issue? is there some fix for it?