Job Scheduler

Files with bad naming scheme are added multiple times to Managed Database

Details

  • Type: Bug Bug
  • Status: Open Open
  • Priority: Minor Minor
  • Resolution: Unresolved
  • Affects Version/s: 1.3.6
  • Fix Version/s: next
  • Component/s: Managed Jobs
  • Description:
    Hide

    Filenames like AEW00200.job.xml,montags.order.xml which match 2 naming conventions are not handled correctly by Managed Starter and are added again and again on each run of the Managed starter
    05 09:37:36.021 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug7] Processing file /live/AEW00200.job.xml,montags.order.xml
    05 09:37:36.021 scheduler 0 4916.1910 234.098MB ..{scheduler} [info] Configuration file /live/AEW00200.job.xml,montags.order.xml does not exist in database. Adding file...
    05 09:37:36.036 scheduler 16 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.getSingleValue(738)
    05 09:37:36.036 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235)
    05 09:37:36.036 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=SELECT "ID" FROM SCHEDULER_MANAGED_TREE WHERE "PATH"='/scheduler/live'
    05 09:37:36.036 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.getSingleValue(746): SELECT "ID" FROM SCHEDULER_MANAGED_TREE WHERE "PATH"='/scheduler/live'
    05 09:37:36.302 scheduler 265 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.getSingleValue(756).. successfully executed.
    05 09:37:36.302 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) calling sos.settings.SOSConnectionSettings.getLockedSequence
    05 09:37:36.302 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.settings.SOSConnectionSettings.getLockedSequence: get result query: SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id' %updlock
    05 09:37:36.317 scheduler 16 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.getSingleValue(738)
    05 09:37:36.317 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235)
    05 09:37:36.317 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id' %updlock
    05 09:37:36.317 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.normalizeStatement(2295), result [SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id' FOR UPDATE]
    05 09:37:36.317 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.getSingleValue(746): SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id' FOR UPDATE
    05 09:37:36.349 scheduler 31 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.getSingleValue(756).. successfully executed.
    05 09:37:36.349 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.settings.SOSConnectionSettings.getLockedSequence: query: UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id'
    05 09:37:36.349 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.execute(1937)
    05 09:37:36.349 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235)
    05 09:37:36.349 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id'
    05 09:37:36.349 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.normalizeStatement(2295), result [UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id']
    05 09:37:36.349 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSMySQLConnection.replaceCasts(189)
    05 09:37:36.349 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) .. result [UPDATE SETTINGS SET "VALUE"=TRIM(CAST(CAST("VALUE" AS SIGNED)+1 AS CHAR)) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id']
    05 09:37:36.349 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1946): UPDATE SETTINGS SET "VALUE"=TRIM(CAST(CAST("VALUE" AS SIGNED)+1 AS CHAR)) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id'
    05 09:37:36.380 scheduler 31 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1950) successfully executed.
    05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.settings.SOSConnectionSettings.getLockedSequence: successfully executed: UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id'
    05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) calling sos.settings.SOSConnectionSettings.getLockedSequence
    05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.settings.SOSConnectionSettings.getLockedSequence: get result query: SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id' %updlock
    05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.getSingleValue(738)
    05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235)
    05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id' %updlock
    05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.normalizeStatement(2295), result [SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id' FOR UPDATE]
    05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.getSingleValue(746): SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id' FOR UPDATE
    05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.getSingleValue(756).. successfully executed.
    05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.settings.SOSConnectionSettings.getLockedSequence: query: UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id'
    05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.execute(1937)
    05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235)
    05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id'
    05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.normalizeStatement(2295), result [UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id']
    05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSMySQLConnection.replaceCasts(189)
    05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) .. result [UPDATE SETTINGS SET "VALUE"=TRIM(CAST(CAST("VALUE" AS SIGNED)+1 AS CHAR)) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id']
    05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1946): UPDATE SETTINGS SET "VALUE"=TRIM(CAST(CAST("VALUE" AS SIGNED)+1 AS CHAR)) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id'
    05 09:37:36.396 scheduler 16 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1950) successfully executed.
    05 09:37:36.396 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.settings.SOSConnectionSettings.getLockedSequence: successfully executed: UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id'
    05 09:37:36.396 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.execute(1937)
    05 09:37:36.396 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235)
    05 09:37:36.396 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=INSERT INTO SCHEDULER_MANAGED_OBJECTS ("ID", "NAME", "TYPE", "HASH", "STATE", "REFERENCE") VALUES(52298, 'AEW00200', 'o', '9b760b052a856ca1f382bd15a39cc522', 10, 0)
    05 09:37:36.396 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1946): INSERT INTO SCHEDULER_MANAGED_OBJECTS ("ID", "NAME", "TYPE", "HASH", "STATE", "REFERENCE") VALUES(52298, 'AEW00200', 'o', '9b760b052a856ca1f382bd15a39cc522', 10, 0)
    05 09:37:36.411 scheduler 16 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1950) successfully executed.
    05 09:37:36.427 scheduler 15 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.updateClob(1122)
    05 09:37:36.427 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235)
    05 09:37:36.427 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=UPDATE SCHEDULER_MANAGED_OBJECTS SET "XML" = ? WHERE "ID"=52298
    05 09:37:36.427 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.updateClob(1158): UPDATE SCHEDULER_MANAGED_OBJECTS SET "XML" = ? WHERE "ID"=52298
    05 09:37:36.442 scheduler 16 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.updateClob(1170) successfully executed.
    05 09:37:36.442 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.execute(1937)
    05 09:37:36.442 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235)
    05 09:37:36.442 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=INSERT INTO SCHEDULER_MANAGED_TREE ("ID", "PARENT", "LEAF", "TYPE", "ITEM_ID", "NAME", "OWNER", "GROUP", "PERMISSION", "CREATED", "CREATED_BY", "MODIFIED", "MODIFIED_BY", "PATH") VALUES(52339, 52, 1, 'o', 52298, 'AEW00200', 0, 0, 774, %now, 'Managed Starter 3', %now, 'Managed Starter 3', '/scheduler/live/AEW00200')
    05 09:37:36.442 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.normalizeStatement(2295), result [INSERT INTO SCHEDULER_MANAGED_TREE ("ID", "PARENT", "LEAF", "TYPE", "ITEM_ID", "NAME", "OWNER", "GROUP", "PERMISSION", "CREATED", "CREATED_BY", "MODIFIED", "MODIFIED_BY", "PATH") VALUES(52339, 52, 1, 'o', 52298, 'AEW00200', 0, 0, 774, NOW(), 'Managed Starter 3', NOW(), 'Managed Starter 3', '/scheduler/live/AEW00200')]
    05 09:37:36.442 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1946): INSERT INTO SCHEDULER_MANAGED_TREE ("ID", "PARENT", "LEAF", "TYPE", "ITEM_ID", "NAME", "OWNER", "GROUP", "PERMISSION", "CREATED", "CREATED_BY", "MODIFIED", "MODIFIED_BY", "PATH") VALUES(52339, 52, 1, 'o', 52298, 'AEW00200', 0, 0, 774, NOW(), 'Managed Starter 3', NOW(), 'Managed Starter 3', '/scheduler/live/AEW00200')
    05 09:37:36.474 scheduler 31 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1950) successfully executed.
    05 09:37:36.474 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.commit(1978)
    05 09:37:36.505 scheduler 31 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.commit(1988) successfully executed.
    05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) calling sos.settings.SOSConnectionSettings.getLockedSequence
    05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.settings.SOSConnectionSettings.getLockedSequence: get result query: SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id' %updlock
    05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.getSingleValue(738)
    05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235)
    05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id' %updlock
    05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.normalizeStatement(2295), result [SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id' FOR UPDATE]
    05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.getSingleValue(746): SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id' FOR UPDATE
    05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.getSingleValue(756).. successfully executed.
    05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.settings.SOSConnectionSettings.getLockedSequence: query: UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id'
    05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.execute(1937)
    05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235)
    05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id'
    05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.normalizeStatement(2295), result [UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id']
    05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSMySQLConnection.replaceCasts(189)
    05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) .. result [UPDATE SETTINGS SET "VALUE"=TRIM(CAST(CAST("VALUE" AS SIGNED)+1 AS CHAR)) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id']
    05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1946): UPDATE SETTINGS SET "VALUE"=TRIM(CAST(CAST("VALUE" AS SIGNED)+1 AS CHAR)) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id'
    05 09:37:36.521 scheduler 16 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1950) successfully executed.
    05 09:37:36.521 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.settings.SOSConnectionSettings.getLockedSequence: successfully executed: UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id'
    05 09:37:36.521 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.executeUpdate(1874)
    05 09:37:36.521 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235)
    05 09:37:36.521 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=INSERT INTO SCHEDULER_MANAGED_SUBMISSIONS ("ID", "OBJECT_ID", "TREE_ID", "PATH", "OLD_PATH", "SPOOLER_ID", "ACTION", "STATE", "MODIFIED", "MODIFIED_BY", "HASH") VALUES(52547, 52298, 52339, '/live/AEW00200.job.xml,montags.order.xml', '/live/AEW00200.job.xml,montags.order.xml', 'scheduler', 'submit', 'stored', %now, 'Managed Starter 3', '9b760b052a856ca1f382bd15a39cc522')
    05 09:37:36.521 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.normalizeStatement(2295), result [INSERT INTO SCHEDULER_MANAGED_SUBMISSIONS ("ID", "OBJECT_ID", "TREE_ID", "PATH", "OLD_PATH", "SPOOLER_ID", "ACTION", "STATE", "MODIFIED", "MODIFIED_BY", "HASH") VALUES(52547, 52298, 52339, '/live/AEW00200.job.xml,montags.order.xml', '/live/AEW00200.job.xml,montags.order.xml', 'scheduler', 'submit', 'stored', NOW(), 'Managed Starter 3', '9b760b052a856ca1f382bd15a39cc522')]
    05 09:37:36.521 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.executeUpdate(1883): INSERT INTO SCHEDULER_MANAGED_SUBMISSIONS ("ID", "OBJECT_ID", "TREE_ID", "PATH", "OLD_PATH", "SPOOLER_ID", "ACTION", "STATE", "MODIFIED", "MODIFIED_BY", "HASH") VALUES(52547, 52298, 52339, '/live/AEW00200.job.xml,montags.order.xml', '/live/AEW00200.job.xml,montags.order.xml', 'scheduler', 'submit', 'stored', NOW(), 'Managed Starter 3', '9b760b052a856ca1f382bd15a39cc522')
    05 09:37:36.552 scheduler 31 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.executeUpdate(1888) successfully executed.
    05 09:37:36.552 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.commit(1978)
    05 09:37:36.567 scheduler 16 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.commit(1988) successfully executed.

    Show
    Filenames like AEW00200.job.xml,montags.order.xml which match 2 naming conventions are not handled correctly by Managed Starter and are added again and again on each run of the Managed starter 05 09:37:36.021 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug7] Processing file /live/AEW00200.job.xml,montags.order.xml 05 09:37:36.021 scheduler 0 4916.1910 234.098MB ..{scheduler} [info] Configuration file /live/AEW00200.job.xml,montags.order.xml does not exist in database. Adding file... 05 09:37:36.036 scheduler 16 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.getSingleValue(738) 05 09:37:36.036 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235) 05 09:37:36.036 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=SELECT "ID" FROM SCHEDULER_MANAGED_TREE WHERE "PATH"='/scheduler/live' 05 09:37:36.036 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.getSingleValue(746): SELECT "ID" FROM SCHEDULER_MANAGED_TREE WHERE "PATH"='/scheduler/live' 05 09:37:36.302 scheduler 265 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.getSingleValue(756).. successfully executed. 05 09:37:36.302 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) calling sos.settings.SOSConnectionSettings.getLockedSequence 05 09:37:36.302 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.settings.SOSConnectionSettings.getLockedSequence: get result query: SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id' %updlock 05 09:37:36.317 scheduler 16 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.getSingleValue(738) 05 09:37:36.317 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235) 05 09:37:36.317 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id' %updlock 05 09:37:36.317 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.normalizeStatement(2295), result [SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id' FOR UPDATE] 05 09:37:36.317 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.getSingleValue(746): SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id' FOR UPDATE 05 09:37:36.349 scheduler 31 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.getSingleValue(756).. successfully executed. 05 09:37:36.349 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.settings.SOSConnectionSettings.getLockedSequence: query: UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id' 05 09:37:36.349 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.execute(1937) 05 09:37:36.349 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235) 05 09:37:36.349 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id' 05 09:37:36.349 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.normalizeStatement(2295), result [UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id'] 05 09:37:36.349 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSMySQLConnection.replaceCasts(189) 05 09:37:36.349 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) .. result [UPDATE SETTINGS SET "VALUE"=TRIM(CAST(CAST("VALUE" AS SIGNED)+1 AS CHAR)) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id'] 05 09:37:36.349 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1946): UPDATE SETTINGS SET "VALUE"=TRIM(CAST(CAST("VALUE" AS SIGNED)+1 AS CHAR)) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id' 05 09:37:36.380 scheduler 31 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1950) successfully executed. 05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.settings.SOSConnectionSettings.getLockedSequence: successfully executed: UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_tree.id' 05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) calling sos.settings.SOSConnectionSettings.getLockedSequence 05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.settings.SOSConnectionSettings.getLockedSequence: get result query: SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id' %updlock 05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.getSingleValue(738) 05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235) 05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id' %updlock 05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.normalizeStatement(2295), result [SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id' FOR UPDATE] 05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.getSingleValue(746): SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id' FOR UPDATE 05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.getSingleValue(756).. successfully executed. 05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.settings.SOSConnectionSettings.getLockedSequence: query: UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id' 05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.execute(1937) 05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235) 05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id' 05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.normalizeStatement(2295), result [UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id'] 05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSMySQLConnection.replaceCasts(189) 05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) .. result [UPDATE SETTINGS SET "VALUE"=TRIM(CAST(CAST("VALUE" AS SIGNED)+1 AS CHAR)) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id'] 05 09:37:36.380 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1946): UPDATE SETTINGS SET "VALUE"=TRIM(CAST(CAST("VALUE" AS SIGNED)+1 AS CHAR)) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id' 05 09:37:36.396 scheduler 16 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1950) successfully executed. 05 09:37:36.396 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.settings.SOSConnectionSettings.getLockedSequence: successfully executed: UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_objects.id' 05 09:37:36.396 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.execute(1937) 05 09:37:36.396 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235) 05 09:37:36.396 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=INSERT INTO SCHEDULER_MANAGED_OBJECTS ("ID", "NAME", "TYPE", "HASH", "STATE", "REFERENCE") VALUES(52298, 'AEW00200', 'o', '9b760b052a856ca1f382bd15a39cc522', 10, 0) 05 09:37:36.396 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1946): INSERT INTO SCHEDULER_MANAGED_OBJECTS ("ID", "NAME", "TYPE", "HASH", "STATE", "REFERENCE") VALUES(52298, 'AEW00200', 'o', '9b760b052a856ca1f382bd15a39cc522', 10, 0) 05 09:37:36.411 scheduler 16 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1950) successfully executed. 05 09:37:36.427 scheduler 15 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.updateClob(1122) 05 09:37:36.427 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235) 05 09:37:36.427 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=UPDATE SCHEDULER_MANAGED_OBJECTS SET "XML" = ? WHERE "ID"=52298 05 09:37:36.427 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.updateClob(1158): UPDATE SCHEDULER_MANAGED_OBJECTS SET "XML" = ? WHERE "ID"=52298 05 09:37:36.442 scheduler 16 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.updateClob(1170) successfully executed. 05 09:37:36.442 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.execute(1937) 05 09:37:36.442 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235) 05 09:37:36.442 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=INSERT INTO SCHEDULER_MANAGED_TREE ("ID", "PARENT", "LEAF", "TYPE", "ITEM_ID", "NAME", "OWNER", "GROUP", "PERMISSION", "CREATED", "CREATED_BY", "MODIFIED", "MODIFIED_BY", "PATH") VALUES(52339, 52, 1, 'o', 52298, 'AEW00200', 0, 0, 774, %now, 'Managed Starter 3', %now, 'Managed Starter 3', '/scheduler/live/AEW00200') 05 09:37:36.442 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.normalizeStatement(2295), result [INSERT INTO SCHEDULER_MANAGED_TREE ("ID", "PARENT", "LEAF", "TYPE", "ITEM_ID", "NAME", "OWNER", "GROUP", "PERMISSION", "CREATED", "CREATED_BY", "MODIFIED", "MODIFIED_BY", "PATH") VALUES(52339, 52, 1, 'o', 52298, 'AEW00200', 0, 0, 774, NOW(), 'Managed Starter 3', NOW(), 'Managed Starter 3', '/scheduler/live/AEW00200')] 05 09:37:36.442 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1946): INSERT INTO SCHEDULER_MANAGED_TREE ("ID", "PARENT", "LEAF", "TYPE", "ITEM_ID", "NAME", "OWNER", "GROUP", "PERMISSION", "CREATED", "CREATED_BY", "MODIFIED", "MODIFIED_BY", "PATH") VALUES(52339, 52, 1, 'o', 52298, 'AEW00200', 0, 0, 774, NOW(), 'Managed Starter 3', NOW(), 'Managed Starter 3', '/scheduler/live/AEW00200') 05 09:37:36.474 scheduler 31 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1950) successfully executed. 05 09:37:36.474 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.commit(1978) 05 09:37:36.505 scheduler 31 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.commit(1988) successfully executed. 05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) calling sos.settings.SOSConnectionSettings.getLockedSequence 05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.settings.SOSConnectionSettings.getLockedSequence: get result query: SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id' %updlock 05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.getSingleValue(738) 05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235) 05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id' %updlock 05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.normalizeStatement(2295), result [SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id' FOR UPDATE] 05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.getSingleValue(746): SELECT "VALUE" FROM SETTINGS WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id' FOR UPDATE 05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.getSingleValue(756).. successfully executed. 05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.settings.SOSConnectionSettings.getLockedSequence: query: UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id' 05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.execute(1937) 05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235) 05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id' 05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.normalizeStatement(2295), result [UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id'] 05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSMySQLConnection.replaceCasts(189) 05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) .. result [UPDATE SETTINGS SET "VALUE"=TRIM(CAST(CAST("VALUE" AS SIGNED)+1 AS CHAR)) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id'] 05 09:37:36.505 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1946): UPDATE SETTINGS SET "VALUE"=TRIM(CAST(CAST("VALUE" AS SIGNED)+1 AS CHAR)) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id' 05 09:37:36.521 scheduler 16 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.execute(1950) successfully executed. 05 09:37:36.521 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.settings.SOSConnectionSettings.getLockedSequence: successfully executed: UPDATE SETTINGS SET "VALUE"=%cast(%cast("VALUE" integer)+1 varchar) WHERE "APPLICATION" = 'scheduler' AND "SECTION" = 'counter' AND "NAME" = 'scheduler_managed_submissions.id' 05 09:37:36.521 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.executeUpdate(1874) 05 09:37:36.521 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) Calling sos.connection.SOSConnection.normalizeStatement(2235) 05 09:37:36.521 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) ..inputString=INSERT INTO SCHEDULER_MANAGED_SUBMISSIONS ("ID", "OBJECT_ID", "TREE_ID", "PATH", "OLD_PATH", "SPOOLER_ID", "ACTION", "STATE", "MODIFIED", "MODIFIED_BY", "HASH") VALUES(52547, 52298, 52339, '/live/AEW00200.job.xml,montags.order.xml', '/live/AEW00200.job.xml,montags.order.xml', 'scheduler', 'submit', 'stored', %now, 'Managed Starter 3', '9b760b052a856ca1f382bd15a39cc522') 05 09:37:36.521 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.normalizeStatement(2295), result [INSERT INTO SCHEDULER_MANAGED_SUBMISSIONS ("ID", "OBJECT_ID", "TREE_ID", "PATH", "OLD_PATH", "SPOOLER_ID", "ACTION", "STATE", "MODIFIED", "MODIFIED_BY", "HASH") VALUES(52547, 52298, 52339, '/live/AEW00200.job.xml,montags.order.xml', '/live/AEW00200.job.xml,montags.order.xml', 'scheduler', 'submit', 'stored', NOW(), 'Managed Starter 3', '9b760b052a856ca1f382bd15a39cc522')] 05 09:37:36.521 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.executeUpdate(1883): INSERT INTO SCHEDULER_MANAGED_SUBMISSIONS ("ID", "OBJECT_ID", "TREE_ID", "PATH", "OLD_PATH", "SPOOLER_ID", "ACTION", "STATE", "MODIFIED", "MODIFIED_BY", "HASH") VALUES(52547, 52298, 52339, '/live/AEW00200.job.xml,montags.order.xml', '/live/AEW00200.job.xml,montags.order.xml', 'scheduler', 'submit', 'stored', NOW(), 'Managed Starter 3', '9b760b052a856ca1f382bd15a39cc522') 05 09:37:36.552 scheduler 31 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.executeUpdate(1888) successfully executed. 05 09:37:36.552 scheduler 0 4916.1910 234.098MB ..{scheduler} [debug9] (Scheduler_script scheduler_managed_starter) calling sos.connection.SOSConnection.commit(1978) 05 09:37:36.567 scheduler 16 4916.1910 234.098MB ..{scheduler} [debug6] (Scheduler_script scheduler_managed_starter) sos.connection.SOSConnection.commit(1988) successfully executed.

Activity

There are no comments yet on this issue.

People

Dates

  • Created:
    05 March 2010 13:43
    Updated:
    23 September 2010 11:38

Time Tracking

Estimated:
3h
Original Estimate - 3 hours
Remaining:
3h
Remaining Estimate - 3 hours
Logged:
Not Specified
Time Spent - Not Specified