Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-2639

OptimisticLock on Partitioned tables

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.3.0, 2.4.0, 2.4.1
    • Fix Version/s: None
    • Component/s: jdbc
    • Labels:
      None

      Description

      We created partition tables as it is described in the guide on http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html .
      I have a function that inserts records to partition table depending on date and a trigger that calls that function, like in the documentation.

      When i try to persist new entity in transaction to this partitioned log_table, I get an exception on commiting:

      Caused by: <openjpa-2.3.0-r422266:1540826 nonfatal store error> org.apache.openjpa.persistence.OptimisticLockException: An optimistic lock violation was detected when flushing object instance "...entities.LogTable@4a6e9cd6" to the data store. This indicates that the object was concurrently modified in another transaction.
      FailedObject: ...entities.LogTable@4a6e9cd6
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:124)

      Near that lines there is a code

      try {
      int count = executeUpdate(stmnt, sql, row);
      if (count != 1) {
      logSQLWarnings(stmnt);
      Object failed = row.getFailedObject();
      if (failed != null)
      _exceptions.add(new OptimisticException(failed));

      that is causing this exception I assume. On Postgres page there is an issue regarding this http://www.postgresql.org/message-id/56F191B0.5050505@consistentstate.com and they state that the behaviour of returning 0 is common.

      The difference in inserting on normal table and partitioned table is:
      When I insert one record manualy using INSERT on partitioned table it works, but returns "Query returned successfully: 0 rows affected, 54 ms execution time."
      Without the trigger, the manual INSERT command returns "Query returned successfully: one row affected, 51 ms execution time."

      Without the trigger, it works OK in java code, so the java code should be ok. I do nothing exceptional for persisting the entity.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              zavael Andrej Badinka
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: