Uploaded image for project: 'JS - JobScheduler'
  1. JS - JobScheduler
  2. JS-1403

Fix for JS-1251/JS-1285: Handling of duplicate order key in database failed if order log contains some lines

    XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.8, 1.9
    • 1.8.2, 1.9.1, 1.10
    • None
    • None

    Description

      File scheduler.log shows lines like the following:

      .02 18:15:14.784     0 56419.85AE4700 INSERT into SCHEDULER_ORDERS ("CREATED_TIME","ID","INITIAL_STATE","JOB_CHAIN","MOD_TIME","ORDERING","PRIORITY","SPOOLER_ID","STATE","STATE_TEXT","TITLE") values ('2015-06-02 16:15:14','/home/sos/scheduler/engine/engine-tests/target/6462093109224634112/X-MATCHING-TEST-DONT-DELETE','100','test','2015-06-02 16:15:14',12,0,'tes
      t','100','','') [23505-187]"]
      .02 18:15:14.784     0 56419.85AE4700 [xc.insert 2, "executeUpdate"]
      .02 18:15:14.784     0 56419.85AE4700 [xc.append "sos::scheduler::order::Order::db_try_insert"]
      .02 18:15:14.784     0 56419.85AE4700 {scheduler} sos::scheduler::order::Order::db_try_insert Z-JAVA-105  Java exception org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY_KEY_E ON PUBLIC.SCHEDULER_ORDERS(SPOOLER_ID, JOB_CHAIN, ID) VALUES ('test', 'test', '/home/sos/scheduler/engine/engine-tests/target/6462093109224634112/X-MATCHING-T
      EST-DONT-DELETE', 76)"; SQL statement:
      .02 18:15:14.784     0 56419.85AE4700 INSERT into SCHEDULER_ORDERS ("CREATED_TIME","ID","INITIAL_STATE","JOB_CHAIN","MOD_TIME","ORDERING","PRIORITY","SPOOLER_ID","STATE","STATE_TEXT","TITLE") values ('2015-06-02 16:15:14','/home/sos/scheduler/engine/engine-..., method=executeUpdate [] / sos::scheduler::order::Order::db_try_insert
      .02 18:15:14.784     0 56419.85AE4700 {scheduler} sos::scheduler::database::Transaction::execute  ROLLBACK  (sos::scheduler::order::Order::db_try_insert)
      .02 18:15:14.785     1 56419.85AE4700 [xc.insert "String0(1024)"]
      .02 18:15:14.786     1 56419.85AE4700 [ERROR SOS-1221  Wert ist f<FC>r String0(1024) zu lang: ]
      .02 18:15:14.786     0 56419.85AE4700 [xc.insert "<order end_time="2015-06-02T16:15:14.644Z" history_id="11" on_blacklist="yes" path="/" start_time="2015-06-02T16:15:13.569Z" touched="yes"><file_based state="not_initialized"><requisites/></file_based><log>2015-06-02 18:15:13.575+0200 [info]   (Task test-dont-delete:118) SCHEDULER-842  Task is going to process Order test:/home/sos/scheduler/engine/engine-tests/target/6462093109224634112/X-MATCHING-TEST-DONT-DELETE, state=100, on JobScheduler
      

      Attachments

        1. test_JS1403.png
          113 kB
          Victor Garcia-Beltran

        Issue Links

          Activity

            People

              jz Joacim Zschimmer
              jz Joacim Zschimmer
              Victor Garcia-Beltran Victor Garcia-Beltran (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: