org.postgresql.util.PSQLException: ERROR: deadlock detected Detail: Process 17234 waits for ShareLock on transaction 3122817; blocked by process 16620. Process 16620 waits for ExclusiveLock on tuple (16,51) of relation 24072 of database 24021; blocked by process 17234. Hint: See server log for query details.

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via Atlassian JIRA by Jacek Jaroczynski [Atlassian] Bugmaster, 1 year ago
ERROR: deadlock detected Detail: Process 17234 waits for ShareLock on transaction 3122817; blocked by process 16620. Process 16620 waits for ExclusiveLock on tuple (16,51) of relation 24072 of database 24021; blocked by process 17234. Hint: See server log for query details.
via Atlassian JIRA by Jacek Jaroczynski [Atlassian] Bugmaster, 1 year ago
ERROR: deadlock detected Detail: Process 17234 waits for ShareLock on transaction 3122817; blocked by process 16620. Process 16620 waits for ExclusiveLock on tuple (16,51) of relation 24072 of database 24021; blocked by process 17234. Hint: See server log for query details.
via GitHub by jayp
, 2 years ago
ERROR: column "data" is of type json but expression is of type character varying Hint: You will need to rewrite or cast the expression. Position: 51
via Server Fault by pstanton
, 1 year ago
ERROR: could not write block 3478284 of temporary file: No space left on device
via Google Groups by Csaba Nagy, 3 months ago
via Stack Overflow by Aulia Ardy
, 2 years ago
ERROR: duplicate key value violates unique constraint "pk_tb_faq" Detail: Key (id_faq)=(135) already exists.
org.postgresql.util.PSQLException: ERROR: deadlock detected Detail: Process 17234 waits for ShareLock on transaction 3122817; blocked by process 16620. Process 16620 waits for ExclusiveLock on tuple (16,51) of relation 24072 of database 24021; blocked by process 17234. Hint: See server log for query details.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at translate.TranslationService.saveTranslation(TranslationService.groovy:433)
at translate.TranslationService$_prepopulateWithSuggestedEntries_closure6.doCall(TranslationService.groovy:247)
at translate.TranslationService.prepopulateWithSuggestedEntries(TranslationService.groovy:220)
at translate.TranslationService$prepopulateWithSuggestedEntries.call(Unknown Source)
at translate.ProductVersionDropDownController$_closure1.doCall(ProductVersionDropDownController.groovy:75)
at translate.ProductVersionDropDownController$_closure1.doCall(ProductVersionDropDownController.groovy)
at com.studentsonly.grails.plugins.uiperformance.CacheFilter.doFilter(CacheFilter.java:67)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
22 times, 5 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
102 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.