Details
-
Type:
Bug
-
Status:
Open
-
Priority:
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.ShowFilenames 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. |
