Details
-
Fix
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.3.4
-
None
-
Windows, MySQL, distributed orders
Description
11:28:52.281 scheduler 172 1824.CB0 701.875MB
{scheduler} Execute <?xml version="1.0" encoding="ISO-8859-1"?><show_job_chain job_chain="/params_test" max_order_history="50" what="job_chain_orders job_chain_jobs order_history blacklist"/>
11:28:52.281 scheduler 0 1824.CB0 701.875MB xmlSchemaValidateDoc()
11:28:52.281 scheduler 0 1824.CB0 701.875MB .jdbc: prepareStatement select count from SCHEDULER_ORDERS where "SPOOLER_ID"='scheduler.balance' and "JOB_CHAIN"='params_test' and "DISTRIBUTED_NEXT_TIME" is not null
11:28:52.281 scheduler 0 1824.CB0 701.875MB .jdbc: prepareStatement select count from SCHEDULER_ORDERS where "DISTRIBUTED_NEXT_TIME" is not null and "SPOOLER_ID"='scheduler.balance' and "JOB_CHAIN"='params_test' and "STATE"='start'
11:28:52.281 scheduler 0 1824.CB0 701.875MB .jdbc: prepareStatement select "ID", "PRIORITY", "STATE", "STATE_TEXT", "INITIAL_STATE", "TITLE", "CREATED_TIME", "JOB_CHAIN", "OCCUPYING_CLUSTER_MEMBER_ID" from SCHEDULER_ORDERS where "SPOOLER_ID"='scheduler.balance' and "JOB_CHAIN"='params_test' and "STATE"='start' and "DISTRIBUTED_NEXT_TIME" is not null and ( "OCCUPYING_CLUSTER_MEMBER_ID"<>'scheduler.balance/al:4242' or "OCCUPYING_CLUSTER_MEMBER_ID" is null ) order by "DISTRIBUTED_NEXT_TIME", "PRIORITY", "ORDERING" limit 2147483647
11:28:52.296 scheduler 16 1824.CB0 701.875MB .jdbc: prepareStatement SELECT "ORDER_XML" FROM SCHEDULER_ORDERS where "ID"='params_test' and "JOB_CHAIN"='params_test' and "SPOOLER_ID"='scheduler.balance'
11:28:52.296 scheduler 0 1824.CB0 701.875MB .jdbc: prepareStatement select count from SCHEDULER_ORDERS where "DISTRIBUTED_NEXT_TIME" is not null and "SPOOLER_ID"='scheduler.balance' and "JOB_CHAIN"='params_test' and "STATE"='change'
11:28:52.312 scheduler 15 1824.CB0 701.875MB .jdbc: prepareStatement select "ID", "PRIORITY", "STATE", "STATE_TEXT", "INITIAL_STATE", "TITLE", "CREATED_TIME", "JOB_CHAIN", "OCCUPYING_CLUSTER_MEMBER_ID" from SCHEDULER_ORDERS where "SPOOLER_ID"='scheduler.balance' and "JOB_CHAIN"='params_test' and "STATE"='change' and "DISTRIBUTED_NEXT_TIME" is not null and ( "OCCUPYING_CLUSTER_MEMBER_ID"<>'scheduler.balance/al:4242' or "OCCUPYING_CLUSTER_MEMBER_ID" is null ) order by "DISTRIBUTED_NEXT_TIME", "PRIORITY", "ORDERING" limit 2147483647
11:28:52.312 scheduler 0 1824.CB0 701.875MB .jdbc: prepareStatement select count from SCHEDULER_ORDERS where "DISTRIBUTED_NEXT_TIME" is not null and "SPOOLER_ID"='scheduler.balance' and "JOB_CHAIN"='params_test' and "STATE"='end'
11:28:52.312 scheduler 0 1824.CB0 701.875MB .jdbc: prepareStatement select "ID", "PRIORITY", "STATE", "STATE_TEXT", "INITIAL_STATE", "TITLE", "CREATED_TIME", "JOB_CHAIN", "OCCUPYING_CLUSTER_MEMBER_ID" from SCHEDULER_ORDERS where "SPOOLER_ID"='scheduler.balance' and "JOB_CHAIN"='params_test' and "STATE"='end' and "DISTRIBUTED_NEXT_TIME" is not null and ( "OCCUPYING_CLUSTER_MEMBER_ID"<>'scheduler.balance/al:4242' or "OCCUPYING_CLUSTER_MEMBER_ID" is null ) order by "DISTRIBUTED_NEXT_TIME", "PRIORITY", "ORDERING" limit 2147483647
11:28:52.312 scheduler 0 1824.CB0 701.875MB .jdbc: prepareStatement select "ORDER_ID", "HISTORY_ID", "JOB_CHAIN", "START_TIME", "END_TIME", "TITLE", "STATE", "STATE_TEXT" from SCHEDULER_ORDER_HISTORY where "JOB_CHAIN"='params_test' and "SPOOLER_ID"='scheduler.balance' order by "HISTORY_ID" desc limit 50
11:28:52.328 scheduler 16 1824.CB0 701.875MB [xc.insert 1, "java.sql.SQLException"]
11:28:52.328 scheduler 0 1824.CB0 701.875MB [xc.insert 2, "Value '0000-00-00' can not be represented as java.sql.Timestamp"]
11:28:52.328 scheduler 0 1824.CB0 701.875MB [xc.insert 3, "getString"]
11:28:53.468 scheduler 1140 1824.CB0 701.875MB [ERROR Z-JAVA-105 Java exception java.sql.SQLException("Value '0000-00-00' can not be represented as java.sql.Timestamp"), method=getString []]