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.

Atlassian JIRA | Jacek Jaroczynski [Atlassian] Bugmaster | 2 years ago
  1. 0

    {code} [793546160] errors.GrailsExceptionResolver Exception occurred when processing request: [POST] /productVersionDropDown/selectedForTranslation Stacktrace follows: 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 org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334) 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) {code}

    Atlassian JIRA | 2 years ago | Jacek Jaroczynski [Atlassian] Bugmaster
    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.
  2. 0

    {code} [793546160] errors.GrailsExceptionResolver Exception occurred when processing request: [POST] /productVersionDropDown/selectedForTranslation Stacktrace follows: 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 org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334) 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) {code}

    Atlassian JIRA | 2 years ago | Jacek Jaroczynski [Atlassian] Bugmaster
    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.
  3. 0

    geonetwork: error updating local user

    GitHub | 3 years ago | fvanderbiest
    org.postgresql.util.PSQLException: ERROR: value too long for type character varying(16)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    geonetwork: phone field too short in user table

    GitHub | 3 years ago | fvanderbiest
    org.postgresql.util.PSQLException: ERROR: value too long for type character varying(16)
  6. 0

    PGSQL JDBC BLOB Update giving error

    Stack Overflow | 3 years ago | Rocky Inde
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "," Position: 143

  1. silex 2 times, last 3 weeks ago
  2. silex 18 times, last 6 months ago
20 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeUpdate
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
    6 frames
  3. translate
    ProductVersionDropDownController$_closure1.doCall
    1. translate.TranslationService.saveTranslation(TranslationService.groovy:433)
    2. translate.TranslationService$_prepopulateWithSuggestedEntries_closure6.doCall(TranslationService.groovy:247)
    3. translate.TranslationService.prepopulateWithSuggestedEntries(TranslationService.groovy:220)
    4. translate.TranslationService$prepopulateWithSuggestedEntries.call(Unknown Source)
    5. translate.ProductVersionDropDownController$_closure1.doCall(ProductVersionDropDownController.groovy:75)
    6. translate.ProductVersionDropDownController$_closure1.doCall(ProductVersionDropDownController.groovy)
    6 frames
  4. com.studentsonly.grails
    CacheFilter.doFilter
    1. com.studentsonly.grails.plugins.uiperformance.CacheFilter.doFilter(CacheFilter.java:67)
    1 frame