DB2 can deadlock with Transaction Isolation Level of read committed

XMLWordPrintable

    • Type: Bug
    • Resolution: Won't Fix
    • Priority: Medium
    • None
    • Affects Version/s: 2.5.6
    • Component/s: None
    • Environment:

      DB2
      Linux

    • 5

      Since fixing CONF-3507, customers are meant to be able to run DB2 with a transaction isolation level of "read committed" (2 in JDBC speak, "cursor stability" in DB2). However, in Confluence 2.5.6, that level causes deadlocks. Customers must again set their transaction isolation level to "read uncommitted" (1 in JDBC).

      The setting can be made by adding the following line to confluence.cfg.xml:

      <property name="hibernate.connection.isolation">1</property>

            Assignee:
            Steve Haffenden (Inactive)
            Reporter:
            Don Willis
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: