Uploaded image for project: 'OpenNMS'
  1. OpenNMS
  2. NMS-7732

JDBCExceptionReporter: ERROR: deadlock detected

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 16.0.0
    • Fix Version/s: None
    • Component/s: Database
    • Security Level: Default (Default Security Scheme)
    • Labels:
      None
    • Environment:
      RHEL7

      Description

      I've done an upgrade from

      Feb 13 20:03:24 Updated: opennms-core-15.0.1-1.noarch
      Feb 13 20:03:26 Updated: opennms-webapp-jetty-15.0.1-1.noarch
      Feb 13 20:03:26 Updated: opennms-15.0.1-1.noarch
      

      to

      Jun 10 15:46:41 Updated: opennms-core-16.0.0-1.noarch
      Jun 10 15:46:43 Updated: opennms-webapp-jetty-16.0.0-1.noarch
      Jun 10 15:46:43 Updated: opennms-16.0.0-1.noarch
      

      and now the system hangs after running about half a day with following entries /var/log/opennms/web.log and OpenNMS is using all CPU Cores.

      2015-06-11 06:34:19,321 WARN  [pool-17-thread-3] o.h.u.JDBCExceptionReporter: SQL Error: 0, SQLState: 40P01
      2015-06-11 06:34:19,321 ERROR [pool-17-thread-3] o.h.u.JDBCExceptionReporter: ERROR: deadlock detected
        Detail: Process 61589 waits for ShareLock on transaction 16291601; blocked by process 61588.
      Process 61588 waits for ShareLock on transaction 16291602; blocked by process 61589.
        Hint: See server log for query details.
      2015-06-11 06:34:19,329 INFO  [pool-17-thread-3] o.s.b.f.x.XmlBeanDefinitionReader: Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
      2015-06-11 06:34:19,454 INFO  [pool-17-thread-3] o.s.j.s.SQLErrorCodesFactory: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
      2015-06-11 06:43:44,870 WARN  [qtp179868864-144250 - /] o.e.j.h.HttpGenerator: Ignoring extra content 
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              robertpenz Robert Penz (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration