17:36:16,021 FINE [org.teiid.jdbc] (Worker18_QueryProcessorQueue74) Successfully executed a query select * from timetable where ts_start = now() and ts_stop = timestampadd(SQL_TSI_SECOND, 20, now()) and period = 2000 and obtained results 17:36:16,039 DEBUG [org.teiid.PROCESSOR] (Worker28_QueryProcessorQueue97) Request Thread +JeAfqp6j0+H.0 with state PROCESSING 17:36:16,020 DEBUG [org.teiid.COMMAND_LOG] (Worker6_QueryProcessorQueue84) END SRC COMMAND: endTime=2012-08-09 17:36:16.02 requestID=OsvQL93RZjci.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=OsvQL93RZjci principal=user finalRowCount=1 17:36:16,041 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue84) OsvQL93RZjci.0.0.0 Closed execution 17:36:16,018 FINE [org.teiid.jdbc] (Worker27_QueryProcessorQueue72) Successfully executed a query select * from timetable where ts_start = now() and ts_stop = timestampadd(SQL_TSI_SECOND, 20, now()) and period = 2000 and obtained results 17:36:16,018 FINE [org.teiid.jdbc] (Worker7_QueryProcessorQueue71) Successfully executed a query select * from timetable where ts_start = now() and ts_stop = timestampadd(SQL_TSI_SECOND, 20, now()) and period = 2000 and obtained results 17:36:16,017 DEBUG [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue94) Running task for parent thread Worker21_QueryProcessorQueue60 17:36:16,043 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue94) 0R9zuJhbl0m3.0.0.20 Processing NEW request: SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.016'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.016'}) AND (TIMES.timetable.period = 2000) 17:36:16,016 INFO [stdout] (Worker1_QueryProcessorQueue66) ### Retrieved row:[2012-08-09 17:36:15.717, 2012-08-09 17:36:17.717, 2000] 17:36:16,048 DEBUG [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue66) DQP process cursor request from 2 17:36:16,048 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue66) YwmMk1xiMfqc.0.0.22 Create State 17:36:16,049 DEBUG [org.teiid.BUFFER_MGR] (Worker1_QueryProcessorQueue66) YwmMk1xiMfqc.0.0.22 Blocking on source query YwmMk1xiMfqc.0.0.22 17:36:16,049 DEBUG [org.teiid.BUFFER_MGR] (Worker1_QueryProcessorQueue66) YwmMk1xiMfqc.0 Blocking on source request(s). 17:36:16,050 DEBUG [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue66) Request Thread YwmMk1xiMfqc.0 - processor blocked 17:36:16,050 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue94) 0R9zuJhbl0m3.0.0.20 Obtained execution 17:36:16,051 DEBUG [org.teiid.COMMAND_LOG] (Worker11_QueryProcessorQueue94) START DATA SRC COMMAND: startTime=2012-08-09 17:36:16.051 requestID=0R9zuJhbl0m3.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=0R9zuJhbl0m3 principal=user sql=SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.016'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.016'}) AND (TIMES.timetable.period = 2000) 17:36:16,052 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue94) 0R9zuJhbl0m3.0.0.20 Executed command 17:36:16,052 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue94) 0R9zuJhbl0m3.0.0.20 Processing MORE request 17:36:16,053 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue94) 0R9zuJhbl0m3.0.0.20 Getting results from connector 17:36:16,017 DEBUG [org.teiid.BUFFER_MGR] (Worker21_QueryProcessorQueue60) 0R9zuJhbl0m3.0.0.20 Blocking on source query 0R9zuJhbl0m3.0.0.20 17:36:16,053 DEBUG [org.teiid.BUFFER_MGR] (Worker21_QueryProcessorQueue60) 0R9zuJhbl0m3.0 Blocking on source request(s). 17:36:16,054 DEBUG [org.teiid.PROCESSOR] (Worker21_QueryProcessorQueue60) Request Thread 0R9zuJhbl0m3.0 - processor blocked 17:36:16,054 DEBUG [org.teiid.PROCESSOR] (Worker25_QueryProcessorQueue99) Request Thread YwmMk1xiMfqc.0 with state PROCESSING 17:36:16,055 DEBUG [org.teiid.BUFFER_MGR] (Worker25_QueryProcessorQueue99) YwmMk1xiMfqc.0.0.22 Blocking on source query YwmMk1xiMfqc.0.0.22 17:36:16,055 DEBUG [org.teiid.BUFFER_MGR] (Worker25_QueryProcessorQueue99) YwmMk1xiMfqc.0 Blocking on source request(s). 17:36:16,055 DEBUG [org.teiid.PROCESSOR] (Worker25_QueryProcessorQueue99) Request Thread YwmMk1xiMfqc.0 - processor blocked 17:36:16,056 DEBUG [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue100) Request Thread 0R9zuJhbl0m3.0 with state PROCESSING 17:36:16,060 DEBUG [org.teiid.BUFFER_MGR] (Worker11_QueryProcessorQueue100) 0R9zuJhbl0m3.0.0.20 Blocking on DataNotAvailableException 0R9zuJhbl0m3.0.0.20 17:36:16,060 DEBUG [org.teiid.BUFFER_MGR] (Worker11_QueryProcessorQueue100) 0R9zuJhbl0m3.0 Blocking on source request(s). 17:36:16,060 DEBUG [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue100) Request Thread 0R9zuJhbl0m3.0 - processor blocked 17:36:16,054 INFO [stdout] (Worker13_QueryProcessorQueue55) ### Retrieved row:[2012-08-09 17:36:15.744, 2012-08-09 17:36:17.744, 2000] 17:36:16,061 DEBUG [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue55) DQP process cursor request from 2 17:36:16,062 DEBUG [org.teiid.CONNECTOR] (Worker13_QueryProcessorQueue55) 837WR5xoRD5z.0.0.23 Create State 17:36:16,063 DEBUG [org.teiid.BUFFER_MGR] (Worker13_QueryProcessorQueue55) 837WR5xoRD5z.0.0.23 Blocking on source query 837WR5xoRD5z.0.0.23 17:36:16,063 DEBUG [org.teiid.BUFFER_MGR] (Worker13_QueryProcessorQueue55) 837WR5xoRD5z.0 Blocking on source request(s). 17:36:16,064 DEBUG [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue55) Request Thread 837WR5xoRD5z.0 - processor blocked 17:36:16,064 DEBUG [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue101) Running task for parent thread Worker13_QueryProcessorQueue55 17:36:16,065 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue101) 837WR5xoRD5z.0.0.23 Processing NEW request: SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.062'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.062'}) AND (TIMES.timetable.period = 2000) 17:36:16,068 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue101) 837WR5xoRD5z.0.0.23 Obtained execution 17:36:16,068 DEBUG [org.teiid.COMMAND_LOG] (Worker11_QueryProcessorQueue101) START DATA SRC COMMAND: startTime=2012-08-09 17:36:16.068 requestID=837WR5xoRD5z.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=837WR5xoRD5z principal=user sql=SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.062'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.062'}) AND (TIMES.timetable.period = 2000) 17:36:16,070 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue101) 837WR5xoRD5z.0.0.23 Executed command 17:36:16,070 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue101) 837WR5xoRD5z.0.0.23 Processing MORE request 17:36:16,070 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue101) 837WR5xoRD5z.0.0.23 Getting results from connector 17:36:16,071 DEBUG [org.teiid.PROCESSOR] (Worker25_QueryProcessorQueue102) Request Thread 837WR5xoRD5z.0 with state PROCESSING 17:36:16,016 DEBUG [org.teiid.CONNECTOR] (Worker14_QueryProcessorQueue62) nOGsFb6Bhq1c.0.0.21 Create State 17:36:16,072 DEBUG [org.teiid.BUFFER_MGR] (Worker14_QueryProcessorQueue62) nOGsFb6Bhq1c.0.0.21 Blocking on source query nOGsFb6Bhq1c.0.0.21 17:36:16,072 DEBUG [org.teiid.BUFFER_MGR] (Worker14_QueryProcessorQueue62) nOGsFb6Bhq1c.0 Blocking on source request(s). 17:36:16,073 DEBUG [org.teiid.PROCESSOR] (Worker14_QueryProcessorQueue62) Request Thread nOGsFb6Bhq1c.0 - processor blocked 17:36:16,073 DEBUG [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue105) Request Thread nOGsFb6Bhq1c.0 with state PROCESSING 17:36:16,011 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue86) ClGOr7lfEaVN.0.0.12 Closed execution 17:36:16,010 DEBUG [org.teiid.PROCESSOR] (Worker15_QueryProcessorQueue93) Request Thread qCrkDSpb0Upi.0 with state PROCESSING 17:36:16,007 DEBUG [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue69) hq0BvHtpGw1J.0.0.13 Obtained last batch, total row count: 1 17:36:16,007 DEBUG [org.teiid.PROCESSOR] (Worker23_QueryProcessorQueue63) Request Thread hq0BvHtpGw1J.0 - processor blocked 17:36:16,006 DEBUG [org.teiid.CONNECTOR] (Worker29_QueryProcessorQueue68) TmRw7jTOJZom.0.0.15 Getting results from connector 17:36:16,006 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue64) Request Thread TmRw7jTOJZom.0 - processor blocked 17:36:16,006 DEBUG [org.teiid.CONNECTOR] (Worker24_QueryProcessorQueue50) b5yYbhMnL8t/.0.0.17 Getting results from connector 17:36:16,005 DEBUG [org.teiid.CONNECTOR] (Worker10_QueryProcessorQueue87) lULWYCOEPyVz.0.0.16 Processing MORE request 17:36:16,005 DEBUG [org.teiid.BUFFER_MGR] (Worker20_QueryProcessorQueue88) 3LBpP59YosUw.0 Blocking on source request(s). 17:36:16,005 DEBUG [org.teiid.CONNECTOR] (Worker32_QueryProcessorQueue90) 3LBpP59YosUw.0.0.14 Processing MORE request 17:36:16,004 DEBUG [org.teiid.PROCESSOR] (Worker31_QueryProcessorQueue92) Running task for parent thread Worker30_QueryProcessorQueue91 17:36:16,004 DEBUG [org.teiid.PROCESSOR] (Worker30_QueryProcessorQueue91) [RequestWorkItem.sendResultsIfNeeded] requestID: QkKZQ7ygd8c7.0 resultsID: 6 done: false 17:36:16,004 DEBUG [org.teiid.CONNECTOR] (Worker19_QueryProcessorQueue12) yr3168kYguhR.0.0.19 Create State 17:36:16,078 FINE [org.teiid.jdbc] (Worker30_QueryProcessorQueue91) Successfully executed a query select * from timetable where ts_start = now() and ts_stop = timestampadd(SQL_TSI_SECOND, 20, now()) and period = 2000 and obtained results 17:36:16,078 DEBUG [org.teiid.CONNECTOR] (Worker31_QueryProcessorQueue92) QkKZQ7ygd8c7.0.0.2 Remove State 17:36:16,077 DEBUG [org.teiid.CONNECTOR] (Worker32_QueryProcessorQueue90) 3LBpP59YosUw.0.0.14 Getting results from connector 17:36:16,080 DEBUG [org.teiid.CONNECTOR] (Worker32_QueryProcessorQueue90) 3LBpP59YosUw.0.0.14 Obtained last batch, total row count: 1 17:36:16,077 DEBUG [org.teiid.PROCESSOR] (Worker20_QueryProcessorQueue88) Request Thread 3LBpP59YosUw.0 - processor blocked 17:36:16,080 DEBUG [org.teiid.CONNECTOR] (Worker31_QueryProcessorQueue92) QkKZQ7ygd8c7.0.0.2 Processing Close : SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:15.714'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:35.714'}) AND (TIMES.timetable.period = 2000) 17:36:16,077 DEBUG [org.teiid.CONNECTOR] (Worker10_QueryProcessorQueue87) lULWYCOEPyVz.0.0.16 Getting results from connector 17:36:16,082 DEBUG [org.teiid.CONNECTOR] (Worker10_QueryProcessorQueue87) lULWYCOEPyVz.0.0.16 Obtained last batch, total row count: 1 17:36:16,077 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue108) Request Thread b5yYbhMnL8t/.0 with state PROCESSING 17:36:16,083 DEBUG [org.teiid.PROCESSOR] (Worker20_QueryProcessorQueue111) Request Thread lULWYCOEPyVz.0 with state PROCESSING 17:36:16,076 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue107) Request Thread hq0BvHtpGw1J.0 with state PROCESSING 17:36:16,085 DEBUG [org.teiid.PROCESSOR] (Worker23_QueryProcessorQueue113) Running task for parent thread Worker20_QueryProcessorQueue111 17:36:16,076 DEBUG [org.teiid.CONNECTOR] (Worker29_QueryProcessorQueue68) TmRw7jTOJZom.0.0.15 Obtained last batch, total row count: 1 17:36:16,075 DEBUG [org.teiid.PROCESSOR] (Worker12_QueryProcessorQueue106) Running task for parent thread Worker15_QueryProcessorQueue93 17:36:16,075 DEBUG [org.teiid.BUFFER_MGR] (Worker15_QueryProcessorQueue93) qCrkDSpb0Upi.0.0.18 Blocking on source query qCrkDSpb0Upi.0.0.18 17:36:16,073 DEBUG [org.teiid.BUFFER_MGR] (Worker13_QueryProcessorQueue105) nOGsFb6Bhq1c.0.0.21 Blocking on source query nOGsFb6Bhq1c.0.0.21 17:36:16,072 DEBUG [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue104) Running task for parent thread Worker14_QueryProcessorQueue62 17:36:16,072 DEBUG [org.teiid.BUFFER_MGR] (Worker25_QueryProcessorQueue102) 837WR5xoRD5z.0.0.23 Blocking on DataNotAvailableException 837WR5xoRD5z.0.0.23 17:36:16,071 INFO [stdout] (Worker18_QueryProcessorQueue74) ### Retrieved row:[2012-08-09 17:36:15.601, 2012-08-09 17:36:17.601, 2000] 17:36:16,071 DEBUG [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue103) Running task for parent thread Worker1_QueryProcessorQueue66 17:36:16,088 INFO [stdout] (Worker7_QueryProcessorQueue71) ### Retrieved row:[2012-08-09 17:36:15.811, 2012-08-09 17:36:17.811, 2000] 17:36:16,089 DEBUG [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue71) DQP process cursor request from 2 17:36:16,045 DEBUG [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue98) Running task for parent thread Worker28_QueryProcessorQueue97 17:36:16,090 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue98) +JeAfqp6j0+H.0.0.10 Remove State 17:36:16,091 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue98) +JeAfqp6j0+H.0.0.10 Processing Close : SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:15.758'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:35.758'}) AND (TIMES.timetable.period = 2000) 17:36:16,092 DEBUG [org.teiid.COMMAND_LOG] (Worker4_QueryProcessorQueue98) END SRC COMMAND: endTime=2012-08-09 17:36:16.092 requestID=+JeAfqp6j0+H.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=+JeAfqp6j0+H principal=user finalRowCount=1 17:36:16,092 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue98) +JeAfqp6j0+H.0.0.10 Closed execution 17:36:16,040 DEBUG [org.teiid.PROCESSOR] (Worker28_QueryProcessorQueue97) [RequestWorkItem.sendResultsIfNeeded] requestID: +JeAfqp6j0+H.0 resultsID: 7 done: false 17:36:16,095 FINE [org.teiid.jdbc] (Worker28_QueryProcessorQueue97) Successfully executed a query select * from timetable where ts_start = now() and ts_stop = timestampadd(SQL_TSI_SECOND, 20, now()) and period = 2000 and obtained results 17:36:16,024 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue96) Running task for parent thread Worker26_QueryProcessorQueue79 17:36:16,024 DEBUG [org.teiid.BUFFER_MGR] (Worker26_QueryProcessorQueue79) 6DOh1h2KDMyo.0.0.9 Blocking on source query 6DOh1h2KDMyo.0.0.9 17:36:16,101 DEBUG [org.teiid.CONNECTOR] (Worker8_QueryProcessorQueue96) 6DOh1h2KDMyo.0.0.9 Processing MORE request 17:36:16,092 DEBUG [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue71) ClGOr7lfEaVN.0.0.24 Create State 17:36:16,089 INFO [stdout] (Worker27_QueryProcessorQueue72) ### Retrieved row:[2012-08-09 17:36:15.741, 2012-08-09 17:36:17.741, 2000] 17:36:16,089 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue103) YwmMk1xiMfqc.0.0.22 Processing NEW request: SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.048'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.048'}) AND (TIMES.timetable.period = 2000) 17:36:16,088 DEBUG [org.teiid.PROCESSOR] (Worker18_QueryProcessorQueue74) DQP process cursor request from 2 17:36:16,104 DEBUG [org.teiid.CONNECTOR] (Worker18_QueryProcessorQueue74) OsvQL93RZjci.0.0.25 Create State 17:36:16,104 DEBUG [org.teiid.BUFFER_MGR] (Worker18_QueryProcessorQueue74) OsvQL93RZjci.0.0.25 Blocking on source query OsvQL93RZjci.0.0.25 17:36:16,105 DEBUG [org.teiid.BUFFER_MGR] (Worker18_QueryProcessorQueue74) OsvQL93RZjci.0 Blocking on source request(s). 17:36:16,105 DEBUG [org.teiid.PROCESSOR] (Worker18_QueryProcessorQueue74) Request Thread OsvQL93RZjci.0 - processor blocked 17:36:16,088 DEBUG [org.teiid.BUFFER_MGR] (Worker25_QueryProcessorQueue102) 837WR5xoRD5z.0 Blocking on source request(s). 17:36:16,106 DEBUG [org.teiid.PROCESSOR] (Worker25_QueryProcessorQueue102) Request Thread 837WR5xoRD5z.0 - processor blocked 17:36:16,106 DEBUG [org.teiid.PROCESSOR] (Worker29_QueryProcessorQueue117) Running task for parent thread Worker18_QueryProcessorQueue74 17:36:16,088 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue104) nOGsFb6Bhq1c.0.0.21 Processing NEW request: SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.016'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.016'}) AND (TIMES.timetable.period = 2000) 17:36:16,087 DEBUG [org.teiid.BUFFER_MGR] (Worker13_QueryProcessorQueue105) nOGsFb6Bhq1c.0 Blocking on source request(s). 17:36:16,087 DEBUG [org.teiid.BUFFER_MGR] (Worker15_QueryProcessorQueue93) qCrkDSpb0Upi.0 Blocking on source request(s). 17:36:16,086 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue106) qCrkDSpb0Upi.0.0.18 Processing MORE request 17:36:16,086 DEBUG [org.teiid.PROCESSOR] (Worker21_QueryProcessorQueue115) Request Thread TmRw7jTOJZom.0 with state PROCESSING 17:36:16,086 DEBUG [org.teiid.CONNECTOR] (Worker23_QueryProcessorQueue113) lULWYCOEPyVz.0.0.16 Remove State 17:36:16,085 DEBUG [org.teiid.PROCESSOR] (Worker14_QueryProcessorQueue114) Running task for parent thread Worker5_QueryProcessorQueue107 17:36:16,085 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue107) [RequestWorkItem.sendResultsIfNeeded] requestID: hq0BvHtpGw1J.0 resultsID: 13 done: false 17:36:16,085 DEBUG [org.teiid.PROCESSOR] (Worker10_QueryProcessorQueue112) Running task for parent thread Worker2_QueryProcessorQueue108 17:36:16,085 DEBUG [org.teiid.PROCESSOR] (Worker20_QueryProcessorQueue111) [RequestWorkItem.sendResultsIfNeeded] requestID: lULWYCOEPyVz.0 resultsID: 16 done: false 17:36:16,084 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue108) b5yYbhMnL8t/.0.0.17 Blocking on source query b5yYbhMnL8t/.0.0.17 17:36:16,082 DEBUG [org.teiid.COMMAND_LOG] (Worker31_QueryProcessorQueue92) END SRC COMMAND: endTime=2012-08-09 17:36:16.082 requestID=QkKZQ7ygd8c7.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=QkKZQ7ygd8c7 principal=user finalRowCount=1 17:36:16,112 DEBUG [org.teiid.CONNECTOR] (Worker31_QueryProcessorQueue92) QkKZQ7ygd8c7.0.0.2 Closed execution 17:36:16,081 DEBUG [org.teiid.PROCESSOR] (Worker32_QueryProcessorQueue110) Request Thread 3LBpP59YosUw.0 with state PROCESSING 17:36:16,113 DEBUG [org.teiid.PROCESSOR] (Worker32_QueryProcessorQueue110) [RequestWorkItem.sendResultsIfNeeded] requestID: 3LBpP59YosUw.0 resultsID: 15 done: false 17:36:16,079 DEBUG [org.teiid.PROCESSOR] (Worker24_QueryProcessorQueue109) Running task for parent thread Worker19_QueryProcessorQueue12 17:36:16,079 DEBUG [org.teiid.BUFFER_MGR] (Worker19_QueryProcessorQueue12) yr3168kYguhR.0.0.19 Blocking on source query yr3168kYguhR.0.0.19 17:36:16,115 DEBUG [org.teiid.BUFFER_MGR] (Worker19_QueryProcessorQueue12) yr3168kYguhR.0 Blocking on source request(s). 17:36:16,116 DEBUG [org.teiid.PROCESSOR] (Worker19_QueryProcessorQueue12) Request Thread yr3168kYguhR.0 - processor blocked 17:36:16,115 DEBUG [org.teiid.CONNECTOR] (Worker24_QueryProcessorQueue109) yr3168kYguhR.0.0.19 Processing NEW request: SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.003'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.003'}) AND (TIMES.timetable.period = 2000) 17:36:16,114 DEBUG [org.teiid.PROCESSOR] (Worker31_QueryProcessorQueue120) Running task for parent thread Worker32_QueryProcessorQueue110 17:36:16,114 FINE [org.teiid.jdbc] (Worker32_QueryProcessorQueue110) Successfully executed a query select * from timetable where ts_start = now() and ts_stop = timestampadd(SQL_TSI_SECOND, 20, now()) and period = 2000 and obtained results 17:36:16,111 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue108) b5yYbhMnL8t/.0 Blocking on source request(s). 17:36:16,111 FINE [org.teiid.jdbc] (Worker20_QueryProcessorQueue111) Successfully executed a query select * from timetable where ts_start = now() and ts_stop = timestampadd(SQL_TSI_SECOND, 20, now()) and period = 2000 and obtained results 17:36:16,110 DEBUG [org.teiid.CONNECTOR] (Worker10_QueryProcessorQueue112) b5yYbhMnL8t/.0.0.17 Processing MORE request 17:36:16,119 DEBUG [org.teiid.CONNECTOR] (Worker10_QueryProcessorQueue112) b5yYbhMnL8t/.0.0.17 Getting results from connector 17:36:16,120 DEBUG [org.teiid.CONNECTOR] (Worker10_QueryProcessorQueue112) b5yYbhMnL8t/.0.0.17 Obtained last batch, total row count: 1 17:36:16,110 FINE [org.teiid.jdbc] (Worker5_QueryProcessorQueue107) Successfully executed a query select * from timetable where ts_start = now() and ts_stop = timestampadd(SQL_TSI_SECOND, 20, now()) and period = 2000 and obtained results 17:36:16,110 DEBUG [org.teiid.CONNECTOR] (Worker14_QueryProcessorQueue114) hq0BvHtpGw1J.0.0.13 Remove State 17:36:16,109 DEBUG [org.teiid.CONNECTOR] (Worker23_QueryProcessorQueue113) lULWYCOEPyVz.0.0.16 Processing Close : SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:15.867'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:35.868'}) AND (TIMES.timetable.period = 2000) 17:36:16,109 DEBUG [org.teiid.PROCESSOR] (Worker25_QueryProcessorQueue119) Running task for parent thread Worker21_QueryProcessorQueue115 17:36:16,109 DEBUG [org.teiid.PROCESSOR] (Worker21_QueryProcessorQueue115) [RequestWorkItem.sendResultsIfNeeded] requestID: TmRw7jTOJZom.0 resultsID: 18 done: false 17:36:16,109 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue106) qCrkDSpb0Upi.0.0.18 Getting results from connector 17:36:16,123 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue106) qCrkDSpb0Upi.0.0.18 Obtained last batch, total row count: 1 17:36:16,108 DEBUG [org.teiid.PROCESSOR] (Worker15_QueryProcessorQueue93) Request Thread qCrkDSpb0Upi.0 - processor blocked 17:36:16,108 DEBUG [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue105) Request Thread nOGsFb6Bhq1c.0 - processor blocked 17:36:16,108 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue104) nOGsFb6Bhq1c.0.0.21 Obtained execution 17:36:16,124 DEBUG [org.teiid.COMMAND_LOG] (Worker11_QueryProcessorQueue104) START DATA SRC COMMAND: startTime=2012-08-09 17:36:16.124 requestID=nOGsFb6Bhq1c.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=nOGsFb6Bhq1c principal=user sql=SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.016'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.016'}) AND (TIMES.timetable.period = 2000) 17:36:16,126 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue104) nOGsFb6Bhq1c.0.0.21 Executed command 17:36:16,126 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue104) nOGsFb6Bhq1c.0.0.21 Processing MORE request 17:36:16,127 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue104) nOGsFb6Bhq1c.0.0.21 Getting results from connector 17:36:16,107 DEBUG [org.teiid.CONNECTOR] (Worker29_QueryProcessorQueue117) OsvQL93RZjci.0.0.25 Processing NEW request: SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.104'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.104'}) AND (TIMES.timetable.period = 2000) 17:36:16,128 DEBUG [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue122) Request Thread nOGsFb6Bhq1c.0 with state PROCESSING 17:36:16,106 DEBUG [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue118) Request Thread OsvQL93RZjci.0 with state PROCESSING 17:36:16,129 DEBUG [org.teiid.BUFFER_MGR] (Worker1_QueryProcessorQueue118) OsvQL93RZjci.0.0.25 Blocking on source query OsvQL93RZjci.0.0.25 17:36:16,129 DEBUG [org.teiid.BUFFER_MGR] (Worker1_QueryProcessorQueue118) OsvQL93RZjci.0 Blocking on source request(s). 17:36:16,130 DEBUG [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue118) Request Thread OsvQL93RZjci.0 - processor blocked 17:36:16,103 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue103) YwmMk1xiMfqc.0.0.22 Obtained execution 17:36:16,102 INFO [stdout] (Worker16_QueryProcessorQueue83) ### Retrieved row:[2012-08-09 17:36:15.713, 2012-08-09 17:36:17.713, 2000] 17:36:16,131 DEBUG [org.teiid.COMMAND_LOG] (Worker6_QueryProcessorQueue103) START DATA SRC COMMAND: startTime=2012-08-09 17:36:16.131 requestID=YwmMk1xiMfqc.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=YwmMk1xiMfqc principal=user sql=SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.048'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.048'}) AND (TIMES.timetable.period = 2000) 17:36:16,136 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue103) YwmMk1xiMfqc.0.0.22 Executed command 17:36:16,136 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue103) YwmMk1xiMfqc.0.0.22 Processing MORE request 17:36:16,137 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue103) YwmMk1xiMfqc.0.0.22 Getting results from connector 17:36:16,102 DEBUG [org.teiid.PROCESSOR] (Worker27_QueryProcessorQueue72) DQP process cursor request from 2 17:36:16,138 DEBUG [org.teiid.CONNECTOR] (Worker27_QueryProcessorQueue72) Ihnw5N5YY4AH.0.0.26 Create State 17:36:16,138 DEBUG [org.teiid.BUFFER_MGR] (Worker27_QueryProcessorQueue72) Ihnw5N5YY4AH.0.0.26 Blocking on source query Ihnw5N5YY4AH.0.0.26 17:36:16,139 DEBUG [org.teiid.BUFFER_MGR] (Worker27_QueryProcessorQueue72) Ihnw5N5YY4AH.0 Blocking on source request(s). 17:36:16,139 DEBUG [org.teiid.PROCESSOR] (Worker27_QueryProcessorQueue72) Request Thread Ihnw5N5YY4AH.0 - processor blocked 17:36:16,140 DEBUG [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue123) Request Thread YwmMk1xiMfqc.0 with state PROCESSING 17:36:16,140 DEBUG [org.teiid.BUFFER_MGR] (Worker1_QueryProcessorQueue123) YwmMk1xiMfqc.0.0.22 Blocking on DataNotAvailableException YwmMk1xiMfqc.0.0.22 17:36:16,140 DEBUG [org.teiid.BUFFER_MGR] (Worker1_QueryProcessorQueue123) YwmMk1xiMfqc.0 Blocking on source request(s). 17:36:16,141 DEBUG [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue123) Request Thread YwmMk1xiMfqc.0 - processor blocked 17:36:16,141 DEBUG [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue124) Request Thread Ihnw5N5YY4AH.0 with state PROCESSING 17:36:16,141 DEBUG [org.teiid.BUFFER_MGR] (Worker11_QueryProcessorQueue124) Ihnw5N5YY4AH.0.0.26 Blocking on source query Ihnw5N5YY4AH.0.0.26 17:36:16,142 DEBUG [org.teiid.BUFFER_MGR] (Worker11_QueryProcessorQueue124) Ihnw5N5YY4AH.0 Blocking on source request(s). 17:36:16,142 DEBUG [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue124) Request Thread Ihnw5N5YY4AH.0 - processor blocked 17:36:16,102 DEBUG [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue116) Running task for parent thread Worker7_QueryProcessorQueue71 17:36:16,143 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue116) ClGOr7lfEaVN.0.0.24 Processing NEW request: SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.09'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.09'}) AND (TIMES.timetable.period = 2000) 17:36:16,144 DEBUG [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue125) Running task for parent thread Worker27_QueryProcessorQueue72 17:36:16,145 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue125) Ihnw5N5YY4AH.0.0.26 Processing NEW request: SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.138'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.138'}) AND (TIMES.timetable.period = 2000) 17:36:16,147 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue116) ClGOr7lfEaVN.0.0.24 Obtained execution 17:36:16,147 DEBUG [org.teiid.COMMAND_LOG] (Worker4_QueryProcessorQueue116) START DATA SRC COMMAND: startTime=2012-08-09 17:36:16.147 requestID=ClGOr7lfEaVN.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=ClGOr7lfEaVN principal=user sql=SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.09'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.09'}) AND (TIMES.timetable.period = 2000) 17:36:16,148 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue125) Ihnw5N5YY4AH.0.0.26 Obtained execution 17:36:16,149 DEBUG [org.teiid.COMMAND_LOG] (Worker6_QueryProcessorQueue125) START DATA SRC COMMAND: startTime=2012-08-09 17:36:16.149 requestID=Ihnw5N5YY4AH.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=Ihnw5N5YY4AH principal=user sql=SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.138'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.138'}) AND (TIMES.timetable.period = 2000) 17:36:16,102 DEBUG [org.teiid.BUFFER_MGR] (Worker7_QueryProcessorQueue71) ClGOr7lfEaVN.0.0.24 Blocking on source query ClGOr7lfEaVN.0.0.24 17:36:16,153 DEBUG [org.teiid.BUFFER_MGR] (Worker7_QueryProcessorQueue71) ClGOr7lfEaVN.0 Blocking on source request(s). 17:36:16,154 DEBUG [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue71) Request Thread ClGOr7lfEaVN.0 - processor blocked 17:36:16,154 DEBUG [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue126) Request Thread ClGOr7lfEaVN.0 with state PROCESSING 17:36:16,154 DEBUG [org.teiid.BUFFER_MGR] (Worker11_QueryProcessorQueue126) ClGOr7lfEaVN.0.0.24 Blocking on source query ClGOr7lfEaVN.0.0.24 17:36:16,155 DEBUG [org.teiid.BUFFER_MGR] (Worker11_QueryProcessorQueue126) ClGOr7lfEaVN.0 Blocking on source request(s). 17:36:16,155 DEBUG [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue126) Request Thread ClGOr7lfEaVN.0 - processor blocked 17:36:16,136 INFO [stdout] (Worker22_QueryProcessorQueue77) ### Retrieved row:[2012-08-09 17:36:15.722, 2012-08-09 17:36:17.722, 2000] 17:36:16,158 DEBUG [org.teiid.PROCESSOR] (Worker22_QueryProcessorQueue77) DQP process cursor request from 2 17:36:16,159 DEBUG [org.teiid.CONNECTOR] (Worker22_QueryProcessorQueue77) GCPJdhJaKm+g.0.0.27 Create State 17:36:16,161 DEBUG [org.teiid.BUFFER_MGR] (Worker22_QueryProcessorQueue77) GCPJdhJaKm+g.0.0.27 Blocking on source query GCPJdhJaKm+g.0.0.27 17:36:16,161 DEBUG [org.teiid.BUFFER_MGR] (Worker22_QueryProcessorQueue77) GCPJdhJaKm+g.0 Blocking on source request(s). 17:36:16,161 DEBUG [org.teiid.PROCESSOR] (Worker22_QueryProcessorQueue77) Request Thread GCPJdhJaKm+g.0 - processor blocked 17:36:16,164 DEBUG [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue127) Running task for parent thread Worker22_QueryProcessorQueue77 17:36:16,164 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue127) GCPJdhJaKm+g.0.0.27 Processing NEW request: SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.159'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.159'}) AND (TIMES.timetable.period = 2000) 17:36:16,166 DEBUG [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue128) Request Thread GCPJdhJaKm+g.0 with state PROCESSING 17:36:16,166 DEBUG [org.teiid.BUFFER_MGR] (Worker7_QueryProcessorQueue128) GCPJdhJaKm+g.0.0.27 Blocking on source query GCPJdhJaKm+g.0.0.27 17:36:16,166 DEBUG [org.teiid.BUFFER_MGR] (Worker7_QueryProcessorQueue128) GCPJdhJaKm+g.0 Blocking on source request(s). 17:36:16,167 DEBUG [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue128) Request Thread GCPJdhJaKm+g.0 - processor blocked 17:36:16,162 INFO [stdout] (Worker3_QueryProcessorQueue78) ### Retrieved row:[2012-08-09 17:36:15.753, 2012-08-09 17:36:17.753, 2000] 17:36:16,168 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue78) DQP process cursor request from 2 17:36:16,173 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue78) Aqy1Isr+KuJD.0.0.28 Create State 17:36:16,177 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue78) Aqy1Isr+KuJD.0.0.28 Blocking on source query Aqy1Isr+KuJD.0.0.28 17:36:16,177 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue78) Aqy1Isr+KuJD.0 Blocking on source request(s). 17:36:16,177 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue78) Request Thread Aqy1Isr+KuJD.0 - processor blocked 17:36:16,178 DEBUG [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue129) Running task for parent thread Worker3_QueryProcessorQueue78 17:36:16,178 DEBUG [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue129) Aqy1Isr+KuJD.0.0.28 Processing NEW request: SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.17'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.172'}) AND (TIMES.timetable.period = 2000) 17:36:16,180 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue125) Ihnw5N5YY4AH.0.0.26 Executed command 17:36:16,180 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue125) Ihnw5N5YY4AH.0.0.26 Processing MORE request 17:36:16,181 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue125) Ihnw5N5YY4AH.0.0.26 Getting results from connector 17:36:16,101 DEBUG [org.teiid.CONNECTOR] (Worker8_QueryProcessorQueue96) 6DOh1h2KDMyo.0.0.9 Getting results from connector 17:36:16,181 DEBUG [org.teiid.CONNECTOR] (Worker8_QueryProcessorQueue96) 6DOh1h2KDMyo.0.0.9 Obtained last batch, total row count: 1 17:36:16,182 DEBUG [org.teiid.PROCESSOR] (Worker22_QueryProcessorQueue130) Request Thread Aqy1Isr+KuJD.0 with state PROCESSING 17:36:16,183 DEBUG [org.teiid.BUFFER_MGR] (Worker22_QueryProcessorQueue130) Aqy1Isr+KuJD.0.0.28 Blocking on source query Aqy1Isr+KuJD.0.0.28 17:36:16,183 DEBUG [org.teiid.BUFFER_MGR] (Worker22_QueryProcessorQueue130) Aqy1Isr+KuJD.0 Blocking on source request(s). 17:36:16,183 DEBUG [org.teiid.PROCESSOR] (Worker22_QueryProcessorQueue130) Request Thread Aqy1Isr+KuJD.0 - processor blocked 17:36:16,101 DEBUG [org.teiid.BUFFER_MGR] (Worker26_QueryProcessorQueue79) 6DOh1h2KDMyo.0 Blocking on source request(s). 17:36:16,182 DEBUG [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue129) Aqy1Isr+KuJD.0.0.28 Obtained execution 17:36:16,184 DEBUG [org.teiid.COMMAND_LOG] (Worker7_QueryProcessorQueue129) START DATA SRC COMMAND: startTime=2012-08-09 17:36:16.184 requestID=Aqy1Isr+KuJD.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=Aqy1Isr+KuJD principal=user sql=SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.17'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.172'}) AND (TIMES.timetable.period = 2000) 17:36:16,182 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue127) GCPJdhJaKm+g.0.0.27 Obtained execution 17:36:16,178 INFO [stdout] (Worker5_QueryProcessorQueue107) ### Retrieved row:[2012-08-09 17:36:15.84, 2012-08-09 17:36:17.84, 2000] 17:36:16,187 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue107) DQP process cursor request from 2 17:36:16,182 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue131) Request Thread Ihnw5N5YY4AH.0 with state PROCESSING 17:36:16,187 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue131) Ihnw5N5YY4AH.0.0.26 Blocking on DataNotAvailableException Ihnw5N5YY4AH.0.0.26 17:36:16,188 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue131) Ihnw5N5YY4AH.0 Blocking on source request(s). 17:36:16,151 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue116) ClGOr7lfEaVN.0.0.24 Executed command 17:36:16,134 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue83) DQP process cursor request from 2 17:36:16,129 DEBUG [org.teiid.BUFFER_MGR] (Worker13_QueryProcessorQueue122) nOGsFb6Bhq1c.0.0.21 Blocking on DataNotAvailableException nOGsFb6Bhq1c.0.0.21 17:36:16,128 DEBUG [org.teiid.CONNECTOR] (Worker29_QueryProcessorQueue117) OsvQL93RZjci.0.0.25 Obtained execution 17:36:16,125 DEBUG [org.teiid.PROCESSOR] (Worker12_QueryProcessorQueue121) Request Thread qCrkDSpb0Upi.0 with state PROCESSING 17:36:16,123 FINE [org.teiid.jdbc] (Worker21_QueryProcessorQueue115) Successfully executed a query select * from timetable where ts_start = now() and ts_stop = timestampadd(SQL_TSI_SECOND, 20, now()) and period = 2000 and obtained results 17:36:16,122 DEBUG [org.teiid.CONNECTOR] (Worker25_QueryProcessorQueue119) TmRw7jTOJZom.0.0.15 Remove State 17:36:16,191 DEBUG [org.teiid.CONNECTOR] (Worker25_QueryProcessorQueue119) TmRw7jTOJZom.0.0.15 Processing Close : SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:15.866'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:35.866'}) AND (TIMES.timetable.period = 2000) 17:36:16,192 DEBUG [org.teiid.COMMAND_LOG] (Worker25_QueryProcessorQueue119) END SRC COMMAND: endTime=2012-08-09 17:36:16.192 requestID=TmRw7jTOJZom.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=TmRw7jTOJZom principal=user finalRowCount=1 17:36:16,193 DEBUG [org.teiid.CONNECTOR] (Worker25_QueryProcessorQueue119) TmRw7jTOJZom.0.0.15 Closed execution 17:36:16,122 DEBUG [org.teiid.COMMAND_LOG] (Worker23_QueryProcessorQueue113) END SRC COMMAND: endTime=2012-08-09 17:36:16.122 requestID=lULWYCOEPyVz.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=lULWYCOEPyVz principal=user finalRowCount=1 17:36:16,194 DEBUG [org.teiid.CONNECTOR] (Worker23_QueryProcessorQueue113) lULWYCOEPyVz.0.0.16 Closed execution 17:36:16,121 DEBUG [org.teiid.CONNECTOR] (Worker14_QueryProcessorQueue114) hq0BvHtpGw1J.0.0.13 Processing Close : SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:15.84'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:35.84'}) AND (TIMES.timetable.period = 2000) 17:36:16,195 DEBUG [org.teiid.COMMAND_LOG] (Worker14_QueryProcessorQueue114) END SRC COMMAND: endTime=2012-08-09 17:36:16.195 requestID=hq0BvHtpGw1J.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=hq0BvHtpGw1J principal=user finalRowCount=1 17:36:16,196 DEBUG [org.teiid.CONNECTOR] (Worker14_QueryProcessorQueue114) hq0BvHtpGw1J.0.0.13 Closed execution 17:36:16,118 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue108) Request Thread b5yYbhMnL8t/.0 - processor blocked 17:36:16,117 DEBUG [org.teiid.CONNECTOR] (Worker31_QueryProcessorQueue120) 3LBpP59YosUw.0.0.14 Remove State 17:36:16,117 DEBUG [org.teiid.CONNECTOR] (Worker24_QueryProcessorQueue109) yr3168kYguhR.0.0.19 Obtained execution 17:36:16,198 DEBUG [org.teiid.COMMAND_LOG] (Worker24_QueryProcessorQueue109) START DATA SRC COMMAND: startTime=2012-08-09 17:36:16.198 requestID=yr3168kYguhR.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=yr3168kYguhR principal=user sql=SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.003'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.003'}) AND (TIMES.timetable.period = 2000) 17:36:16,198 DEBUG [org.teiid.CONNECTOR] (Worker31_QueryProcessorQueue120) 3LBpP59YosUw.0.0.14 Processing Close : SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:15.858'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:35.858'}) AND (TIMES.timetable.period = 2000) 17:36:16,197 DEBUG [org.teiid.PROCESSOR] (Worker14_QueryProcessorQueue133) Request Thread b5yYbhMnL8t/.0 with state PROCESSING 17:36:16,201 DEBUG [org.teiid.PROCESSOR] (Worker14_QueryProcessorQueue133) [RequestWorkItem.sendResultsIfNeeded] requestID: b5yYbhMnL8t/.0 resultsID: 17 done: false 17:36:16,201 FINE [org.teiid.jdbc] (Worker14_QueryProcessorQueue133) Successfully executed a query select * from timetable where ts_start = now() and ts_stop = timestampadd(SQL_TSI_SECOND, 20, now()) and period = 2000 and obtained results 17:36:16,190 DEBUG [org.teiid.PROCESSOR] (Worker22_QueryProcessorQueue132) Running task for parent thread Worker12_QueryProcessorQueue121 17:36:16,202 DEBUG [org.teiid.CONNECTOR] (Worker22_QueryProcessorQueue132) qCrkDSpb0Upi.0.0.18 Remove State 17:36:16,203 DEBUG [org.teiid.CONNECTOR] (Worker22_QueryProcessorQueue132) qCrkDSpb0Upi.0.0.18 Processing Close : SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:15.872'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:35.872'}) AND (TIMES.timetable.period = 2000) 17:36:16,190 DEBUG [org.teiid.PROCESSOR] (Worker12_QueryProcessorQueue121) [RequestWorkItem.sendResultsIfNeeded] requestID: qCrkDSpb0Upi.0 resultsID: 14 done: false 17:36:16,190 DEBUG [org.teiid.COMMAND_LOG] (Worker29_QueryProcessorQueue117) START DATA SRC COMMAND: startTime=2012-08-09 17:36:16.19 requestID=OsvQL93RZjci.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=OsvQL93RZjci principal=user sql=SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.104'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.104'}) AND (TIMES.timetable.period = 2000) 17:36:16,189 DEBUG [org.teiid.BUFFER_MGR] (Worker13_QueryProcessorQueue122) nOGsFb6Bhq1c.0 Blocking on source request(s). 17:36:16,189 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue83) VFYGQAOfmSF6.0.0.30 Create State 17:36:16,189 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue116) ClGOr7lfEaVN.0.0.24 Processing MORE request 17:36:16,188 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue131) Request Thread Ihnw5N5YY4AH.0 - processor blocked 17:36:16,187 INFO [stdout] (Worker20_QueryProcessorQueue111) ### Retrieved row:[2012-08-09 17:36:15.867, 2012-08-09 17:36:17.867, 2000] 17:36:16,187 DEBUG [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue107) hq0BvHtpGw1J.0.0.29 Create State 17:36:16,186 DEBUG [org.teiid.COMMAND_LOG] (Worker11_QueryProcessorQueue127) START DATA SRC COMMAND: startTime=2012-08-09 17:36:16.186 requestID=GCPJdhJaKm+g.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=GCPJdhJaKm+g principal=user sql=SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.159'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.159'}) AND (TIMES.timetable.period = 2000) 17:36:16,186 DEBUG [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue129) Aqy1Isr+KuJD.0.0.28 Executed command 17:36:16,184 DEBUG [org.teiid.PROCESSOR] (Worker26_QueryProcessorQueue79) Request Thread 6DOh1h2KDMyo.0 - processor blocked 17:36:16,209 DEBUG [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue129) Aqy1Isr+KuJD.0.0.28 Processing MORE request 17:36:16,210 DEBUG [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue129) Aqy1Isr+KuJD.0.0.28 Getting results from connector 17:36:16,209 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue127) GCPJdhJaKm+g.0.0.27 Executed command 17:36:16,211 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue127) GCPJdhJaKm+g.0.0.27 Processing MORE request 17:36:16,211 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue127) GCPJdhJaKm+g.0.0.27 Getting results from connector 17:36:16,212 DEBUG [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue138) Request Thread 6DOh1h2KDMyo.0 with state PROCESSING 17:36:16,213 DEBUG [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue138) [RequestWorkItem.sendResultsIfNeeded] requestID: 6DOh1h2KDMyo.0 resultsID: 8 done: false 17:36:16,213 FINE [org.teiid.jdbc] (Worker7_QueryProcessorQueue138) Successfully executed a query select * from timetable where ts_start = now() and ts_stop = timestampadd(SQL_TSI_SECOND, 20, now()) and period = 2000 and obtained results 17:36:16,207 INFO [stdout] (Worker32_QueryProcessorQueue110) ### Retrieved row:[2012-08-09 17:36:15.858, 2012-08-09 17:36:17.858, 2000] 17:36:16,214 DEBUG [org.teiid.PROCESSOR] (Worker32_QueryProcessorQueue110) DQP process cursor request from 2 17:36:16,215 DEBUG [org.teiid.CONNECTOR] (Worker32_QueryProcessorQueue110) 3LBpP59YosUw.0.0.31 Create State 17:36:16,215 DEBUG [org.teiid.BUFFER_MGR] (Worker32_QueryProcessorQueue110) 3LBpP59YosUw.0.0.31 Blocking on source query 3LBpP59YosUw.0.0.31 17:36:16,216 DEBUG [org.teiid.BUFFER_MGR] (Worker32_QueryProcessorQueue110) 3LBpP59YosUw.0 Blocking on source request(s). 17:36:16,216 DEBUG [org.teiid.PROCESSOR] (Worker32_QueryProcessorQueue110) Request Thread 3LBpP59YosUw.0 - processor blocked 17:36:16,217 DEBUG [org.teiid.PROCESSOR] (Worker26_QueryProcessorQueue139) Request Thread GCPJdhJaKm+g.0 with state PROCESSING 17:36:16,217 DEBUG [org.teiid.BUFFER_MGR] (Worker26_QueryProcessorQueue139) GCPJdhJaKm+g.0.0.27 Blocking on DataNotAvailableException GCPJdhJaKm+g.0.0.27 17:36:16,217 DEBUG [org.teiid.BUFFER_MGR] (Worker26_QueryProcessorQueue139) GCPJdhJaKm+g.0 Blocking on source request(s). 17:36:16,218 DEBUG [org.teiid.PROCESSOR] (Worker26_QueryProcessorQueue139) Request Thread GCPJdhJaKm+g.0 - processor blocked 17:36:16,218 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue140) Running task for parent thread Worker32_QueryProcessorQueue110 17:36:16,219 DEBUG [org.teiid.CONNECTOR] (Worker8_QueryProcessorQueue140) 3LBpP59YosUw.0.0.31 Processing NEW request: SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.215'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.215'}) AND (TIMES.timetable.period = 2000) 17:36:16,208 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue136) Running task for parent thread Worker5_QueryProcessorQueue107 17:36:16,221 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue136) hq0BvHtpGw1J.0.0.29 Processing NEW request: SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.187'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.187'}) AND (TIMES.timetable.period = 2000) 17:36:16,222 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue136) hq0BvHtpGw1J.0.0.29 Obtained execution 17:36:16,222 DEBUG [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue136) START DATA SRC COMMAND: startTime=2012-08-09 17:36:16.222 requestID=hq0BvHtpGw1J.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=hq0BvHtpGw1J principal=user sql=SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.187'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.187'}) AND (TIMES.timetable.period = 2000) 17:36:16,208 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue107) hq0BvHtpGw1J.0.0.29 Blocking on source query hq0BvHtpGw1J.0.0.29 17:36:16,207 DEBUG [org.teiid.PROCESSOR] (Worker20_QueryProcessorQueue111) DQP process cursor request from 2 17:36:16,207 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue116) ClGOr7lfEaVN.0.0.24 Getting results from connector 17:36:16,225 DEBUG [org.teiid.PROCESSOR] (Worker26_QueryProcessorQueue143) Request Thread ClGOr7lfEaVN.0 with state PROCESSING 17:36:16,226 DEBUG [org.teiid.BUFFER_MGR] (Worker26_QueryProcessorQueue143) ClGOr7lfEaVN.0.0.24 Blocking on DataNotAvailableException ClGOr7lfEaVN.0.0.24 17:36:16,226 DEBUG [org.teiid.BUFFER_MGR] (Worker26_QueryProcessorQueue143) ClGOr7lfEaVN.0 Blocking on source request(s). 17:36:16,226 DEBUG [org.teiid.PROCESSOR] (Worker26_QueryProcessorQueue143) Request Thread ClGOr7lfEaVN.0 - processor blocked 17:36:16,206 DEBUG [org.teiid.PROCESSOR] (Worker23_QueryProcessorQueue135) Running task for parent thread Worker16_QueryProcessorQueue83 17:36:16,229 DEBUG [org.teiid.CONNECTOR] (Worker23_QueryProcessorQueue135) VFYGQAOfmSF6.0.0.30 Processing NEW request: SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.189'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.189'}) AND (TIMES.timetable.period = 2000) 17:36:16,206 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue83) VFYGQAOfmSF6.0.0.30 Blocking on source query VFYGQAOfmSF6.0.0.30 17:36:16,206 DEBUG [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue122) Request Thread nOGsFb6Bhq1c.0 - processor blocked 17:36:16,206 DEBUG [org.teiid.CONNECTOR] (Worker29_QueryProcessorQueue117) OsvQL93RZjci.0.0.25 Executed command 17:36:16,204 FINE [org.teiid.jdbc] (Worker12_QueryProcessorQueue121) Successfully executed a query select * from timetable where ts_start = now() and ts_stop = timestampadd(SQL_TSI_SECOND, 20, now()) and period = 2000 and obtained results 17:36:16,204 DEBUG [org.teiid.COMMAND_LOG] (Worker22_QueryProcessorQueue132) END SRC COMMAND: endTime=2012-08-09 17:36:16.204 requestID=qCrkDSpb0Upi.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=qCrkDSpb0Upi principal=user finalRowCount=1 17:36:16,233 DEBUG [org.teiid.CONNECTOR] (Worker22_QueryProcessorQueue132) qCrkDSpb0Upi.0.0.18 Closed execution 17:36:16,202 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue134) Running task for parent thread Worker14_QueryProcessorQueue133 17:36:16,234 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue134) b5yYbhMnL8t/.0.0.17 Remove State 17:36:16,234 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue134) b5yYbhMnL8t/.0.0.17 Processing Close : SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:15.868'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:35.868'}) AND (TIMES.timetable.period = 2000) 17:36:16,235 DEBUG [org.teiid.COMMAND_LOG] (Worker2_QueryProcessorQueue134) END SRC COMMAND: endTime=2012-08-09 17:36:16.235 requestID=b5yYbhMnL8t/.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=b5yYbhMnL8t/ principal=user finalRowCount=1 17:36:16,236 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue134) b5yYbhMnL8t/.0.0.17 Closed execution 17:36:16,200 DEBUG [org.teiid.COMMAND_LOG] (Worker31_QueryProcessorQueue120) END SRC COMMAND: endTime=2012-08-09 17:36:16.2 requestID=3LBpP59YosUw.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=3LBpP59YosUw principal=user finalRowCount=1 17:36:16,237 DEBUG [org.teiid.CONNECTOR] (Worker31_QueryProcessorQueue120) 3LBpP59YosUw.0.0.14 Closed execution 17:36:16,199 DEBUG [org.teiid.CONNECTOR] (Worker24_QueryProcessorQueue109) yr3168kYguhR.0.0.19 Executed command 17:36:16,231 DEBUG [org.teiid.CONNECTOR] (Worker29_QueryProcessorQueue117) OsvQL93RZjci.0.0.25 Processing MORE request 17:36:16,231 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue83) VFYGQAOfmSF6.0 Blocking on source request(s). 17:36:16,231 DEBUG [org.teiid.CONNECTOR] (Worker23_QueryProcessorQueue135) VFYGQAOfmSF6.0.0.30 Obtained execution 17:36:16,230 DEBUG [org.teiid.CONNECTOR] (Worker20_QueryProcessorQueue111) lULWYCOEPyVz.0.0.32 Create State 17:36:16,224 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue107) hq0BvHtpGw1J.0 Blocking on source request(s). 17:36:16,239 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue107) Request Thread hq0BvHtpGw1J.0 - processor blocked 17:36:16,240 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue144) Request Thread hq0BvHtpGw1J.0 with state PROCESSING 17:36:16,240 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue144) hq0BvHtpGw1J.0.0.29 Blocking on source query hq0BvHtpGw1J.0.0.29 17:36:16,241 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue144) hq0BvHtpGw1J.0 Blocking on source request(s). 17:36:16,241 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue144) Request Thread hq0BvHtpGw1J.0 - processor blocked 17:36:16,242 DEBUG [org.teiid.PROCESSOR] (Worker31_QueryProcessorQueue145) Running task for parent thread Worker20_QueryProcessorQueue111 17:36:16,242 DEBUG [org.teiid.CONNECTOR] (Worker31_QueryProcessorQueue145) lULWYCOEPyVz.0.0.32 Processing NEW request: SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.225'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.226'}) AND (TIMES.timetable.period = 2000) 17:36:16,224 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue136) hq0BvHtpGw1J.0.0.29 Executed command 17:36:16,244 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue136) hq0BvHtpGw1J.0.0.29 Processing MORE request 17:36:16,244 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue136) hq0BvHtpGw1J.0.0.29 Getting results from connector 17:36:16,220 DEBUG [org.teiid.CONNECTOR] (Worker8_QueryProcessorQueue140) 3LBpP59YosUw.0.0.31 Obtained execution 17:36:16,245 DEBUG [org.teiid.COMMAND_LOG] (Worker8_QueryProcessorQueue140) START DATA SRC COMMAND: startTime=2012-08-09 17:36:16.245 requestID=3LBpP59YosUw.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=3LBpP59YosUw principal=user sql=SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.215'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.215'}) AND (TIMES.timetable.period = 2000) 17:36:16,218 INFO [stdout] (Worker28_QueryProcessorQueue97) ### Retrieved row:[2012-08-09 17:36:15.758, 2012-08-09 17:36:17.758, 2000] 17:36:16,219 DEBUG [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue142) Request Thread 3LBpP59YosUw.0 with state PROCESSING 17:36:16,248 DEBUG [org.teiid.BUFFER_MGR] (Worker6_QueryProcessorQueue142) 3LBpP59YosUw.0.0.31 Blocking on source query 3LBpP59YosUw.0.0.31 17:36:16,249 DEBUG [org.teiid.BUFFER_MGR] (Worker6_QueryProcessorQueue142) 3LBpP59YosUw.0 Blocking on source request(s). 17:36:16,249 DEBUG [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue142) Request Thread 3LBpP59YosUw.0 - processor blocked 17:36:16,219 DEBUG [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue141) Running task for parent thread Worker7_QueryProcessorQueue138 17:36:16,211 DEBUG [org.teiid.PROCESSOR] (Worker25_QueryProcessorQueue137) Request Thread Aqy1Isr+KuJD.0 with state PROCESSING 17:36:16,250 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue141) 6DOh1h2KDMyo.0.0.9 Remove State 17:36:16,248 INFO [stdout] (Worker30_QueryProcessorQueue91) ### Retrieved row:[2012-08-09 17:36:15.714, 2012-08-09 17:36:17.714, 2000] 17:36:16,251 DEBUG [org.teiid.PROCESSOR] (Worker30_QueryProcessorQueue91) DQP process cursor request from 2 17:36:16,252 DEBUG [org.teiid.CONNECTOR] (Worker30_QueryProcessorQueue91) QkKZQ7ygd8c7.0.0.33 Create State 17:36:16,252 DEBUG [org.teiid.BUFFER_MGR] (Worker30_QueryProcessorQueue91) QkKZQ7ygd8c7.0.0.33 Blocking on source query QkKZQ7ygd8c7.0.0.33 17:36:16,258 DEBUG [org.teiid.BUFFER_MGR] (Worker30_QueryProcessorQueue91) QkKZQ7ygd8c7.0 Blocking on source request(s). 17:36:16,258 DEBUG [org.teiid.PROCESSOR] (Worker30_QueryProcessorQueue91) Request Thread QkKZQ7ygd8c7.0 - processor blocked 17:36:16,248 DEBUG [org.teiid.PROCESSOR] (Worker28_QueryProcessorQueue97) DQP process cursor request from 2 17:36:16,259 DEBUG [org.teiid.CONNECTOR] (Worker28_QueryProcessorQueue97) +JeAfqp6j0+H.0.0.34 Create State 17:36:16,260 DEBUG [org.teiid.BUFFER_MGR] (Worker28_QueryProcessorQueue97) +JeAfqp6j0+H.0.0.34 Blocking on source query +JeAfqp6j0+H.0.0.34 17:36:16,260 DEBUG [org.teiid.BUFFER_MGR] (Worker28_QueryProcessorQueue97) +JeAfqp6j0+H.0 Blocking on source request(s). 17:36:16,260 DEBUG [org.teiid.PROCESSOR] (Worker28_QueryProcessorQueue97) Request Thread +JeAfqp6j0+H.0 - processor blocked 17:36:16,261 DEBUG [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue148) Running task for parent thread Worker30_QueryProcessorQueue91 17:36:16,248 DEBUG [org.teiid.COMMAND_LOG] (Worker8_QueryProcessorQueue140) ERROR SRC COMMAND: endTime=2012-08-09 17:36:16.248 requestID=3LBpP59YosUw.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=3LBpP59YosUw principal=user finalRowCount=null 17:36:16,247 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue146) Request Thread hq0BvHtpGw1J.0 with state PROCESSING 17:36:16,263 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue146) hq0BvHtpGw1J.0.0.29 Blocking on DataNotAvailableException hq0BvHtpGw1J.0.0.29 17:36:16,263 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue146) hq0BvHtpGw1J.0 Blocking on source request(s). 17:36:16,264 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue146) Request Thread hq0BvHtpGw1J.0 - processor blocked 17:36:16,246 DEBUG [org.teiid.CONNECTOR] (Worker31_QueryProcessorQueue145) lULWYCOEPyVz.0.0.32 Obtained execution 17:36:16,265 DEBUG [org.teiid.COMMAND_LOG] (Worker31_QueryProcessorQueue145) START DATA SRC COMMAND: startTime=2012-08-09 17:36:16.265 requestID=lULWYCOEPyVz.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=lULWYCOEPyVz principal=user sql=SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.225'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.226'}) AND (TIMES.timetable.period = 2000) 17:36:16,239 DEBUG [org.teiid.BUFFER_MGR] (Worker20_QueryProcessorQueue111) lULWYCOEPyVz.0.0.32 Blocking on source query lULWYCOEPyVz.0.0.32 17:36:16,239 DEBUG [org.teiid.COMMAND_LOG] (Worker23_QueryProcessorQueue135) START DATA SRC COMMAND: startTime=2012-08-09 17:36:16.239 requestID=VFYGQAOfmSF6.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=VFYGQAOfmSF6 principal=user sql=SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.189'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.189'}) AND (TIMES.timetable.period = 2000) 17:36:16,238 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue83) Request Thread VFYGQAOfmSF6.0 - processor blocked 17:36:16,269 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue151) Request Thread VFYGQAOfmSF6.0 with state PROCESSING 17:36:16,238 DEBUG [org.teiid.CONNECTOR] (Worker29_QueryProcessorQueue117) OsvQL93RZjci.0.0.25 Getting results from connector 17:36:16,238 DEBUG [org.teiid.CONNECTOR] (Worker24_QueryProcessorQueue109) yr3168kYguhR.0.0.19 Processing MORE request 17:36:16,271 DEBUG [org.teiid.CONNECTOR] (Worker24_QueryProcessorQueue109) yr3168kYguhR.0.0.19 Getting results from connector 17:36:16,270 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue152) Request Thread OsvQL93RZjci.0 with state PROCESSING 17:36:16,272 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue152) OsvQL93RZjci.0.0.25 Blocking on DataNotAvailableException OsvQL93RZjci.0.0.25 17:36:16,270 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue151) VFYGQAOfmSF6.0.0.30 Blocking on source query VFYGQAOfmSF6.0.0.30 17:36:16,269 DEBUG [org.teiid.CONNECTOR] (Worker23_QueryProcessorQueue135) VFYGQAOfmSF6.0.0.30 Executed command 17:36:16,273 DEBUG [org.teiid.CONNECTOR] (Worker23_QueryProcessorQueue135) VFYGQAOfmSF6.0.0.30 Processing MORE request 17:36:16,273 DEBUG [org.teiid.CONNECTOR] (Worker23_QueryProcessorQueue135) VFYGQAOfmSF6.0.0.30 Getting results from connector 17:36:16,267 DEBUG [org.teiid.BUFFER_MGR] (Worker20_QueryProcessorQueue111) lULWYCOEPyVz.0 Blocking on source request(s). 17:36:16,274 DEBUG [org.teiid.PROCESSOR] (Worker20_QueryProcessorQueue111) Request Thread lULWYCOEPyVz.0 - processor blocked 17:36:16,267 DEBUG [org.teiid.CONNECTOR] (Worker31_QueryProcessorQueue145) lULWYCOEPyVz.0.0.32 Executed command 17:36:16,275 DEBUG [org.teiid.CONNECTOR] (Worker31_QueryProcessorQueue145) lULWYCOEPyVz.0.0.32 Processing MORE request 17:36:16,275 DEBUG [org.teiid.CONNECTOR] (Worker31_QueryProcessorQueue145) lULWYCOEPyVz.0.0.32 Getting results from connector 17:36:16,261 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue148) QkKZQ7ygd8c7.0.0.33 Processing NEW request: SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.251'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.251'}) AND (TIMES.timetable.period = 2000) 17:36:16,261 INFO [stdout] (Worker12_QueryProcessorQueue121) ### Retrieved row:[2012-08-09 17:36:15.872, 2012-08-09 17:36:17.872, 2000] 17:36:16,277 DEBUG [org.teiid.PROCESSOR] (Worker12_QueryProcessorQueue121) DQP process cursor request from 2 17:36:16,277 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue148) QkKZQ7ygd8c7.0.0.33 Obtained execution 17:36:16,278 DEBUG [org.teiid.COMMAND_LOG] (Worker6_QueryProcessorQueue148) START DATA SRC COMMAND: startTime=2012-08-09 17:36:16.278 requestID=QkKZQ7ygd8c7.0 sourceCommandID=0 txID=null modelName=TIMES translatorName=timerange-async sessionID=QkKZQ7ygd8c7 principal=user sql=SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.251'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.251'}) AND (TIMES.timetable.period = 2000) 17:36:16,261 DEBUG [org.teiid.PROCESSOR] (Worker30_QueryProcessorQueue150) Running task for parent thread Worker28_QueryProcessorQueue97 17:36:16,280 DEBUG [org.teiid.CONNECTOR] (Worker30_QueryProcessorQueue150) +JeAfqp6j0+H.0.0.34 Processing NEW request: SELECT TIMES.timetable.ts_start, TIMES.timetable.ts_stop, TIMES.timetable.period FROM TIMES.timetable WHERE (TIMES.timetable.ts_start = {ts'2012-08-09 17:36:16.259'}) AND (TIMES.timetable.ts_stop = {ts'2012-08-09 17:36:36.259'}) AND (TIMES.timetable.period = 2000) 17:36:16,262 ERROR [org.teiid.CONNECTOR] (Worker8_QueryProcessorQueue140) Connector worker process failed for atomic-request=3LBpP59YosUw.0.0.31: java.lang.NullPointerException at com.ca.chorus.teiid.translator.async.TimerExecution.getReuseCount(TimerExecution.java:104) [asyncTest-3.0.0-SNAPSHOT.jar:] at com.ca.chorus.teiid.translator.async.TimerExecution.execute(TimerExecution.java:97) [asyncTest-3.0.0-SNAPSHOT.jar:] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:261) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:422) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:170) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:167) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_05] at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_05] at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:118) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:249) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_05] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_05] at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_05]