09:13:35,722 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2046) Request Thread 5Ol6PtBi0E8b.0 with state NEW 09:13:35,722 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2046) 5Ol6PtBi0E8b.0 Command has no cache hint and result set cache mode is not on. 09:13:35,722 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2046) 5Ol6PtBi0E8b.0 executing execute SYSADMIN.matViewStatus('View', 'external_long_ttl') 09:13:35,726 DEBUG [org.teiid.PLANNER] (Worker2_QueryProcessorQueue2046) [LOW [Relational Planner] limit not supported by source SYS - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[Name]}, LOW [Relational Planner] limit not supported by source SYS - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[VirtualDatabases__1.Version]}, LOW [Relational Planner] limit not supported by source SYS - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[UID]}, LOW [Relational Planner] limit not supported by source SYS - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[Tables__1.IsMaterialized]}, LOW [Relational Planner] limit not supported by source SYS - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=["Value"]}, LOW [Relational Planner] limit not supported by source SYS - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[Properties__1."Value"]}] 09:13:35,726 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2046) ProcessTree for 5Ol6PtBi0E8b.0 ProjectNode(24) output=[SYSADMIN.matViewStatus.TargetSchemaName, SYSADMIN.matViewStatus.TargetName, SYSADMIN.matViewStatus.Valid, SYSADMIN.matViewStatus.LoadState, SYSADMIN.matViewStatus.Updated, SYSADMIN.matViewStatus.Cardinality, SYSADMIN.matViewStatus.LoadNumber, SYSADMIN.matViewStatus.OnErrorAction] [SYSADMIN.matViewStatus.TargetSchemaName, SYSADMIN.matViewStatus.TargetName, SYSADMIN.matViewStatus.Valid, SYSADMIN.matViewStatus.LoadState, SYSADMIN.matViewStatus.Updated, SYSADMIN.matViewStatus.Cardinality, SYSADMIN.matViewStatus.LoadNumber, SYSADMIN.matViewStatus.OnErrorAction] PlanExecutionNode(25) output=[SYSADMIN.matViewStatus.TargetSchemaName, SYSADMIN.matViewStatus.TargetName, SYSADMIN.matViewStatus.Valid, SYSADMIN.matViewStatus.LoadState, SYSADMIN.matViewStatus.Updated, SYSADMIN.matViewStatus.Cardinality, SYSADMIN.matViewStatus.LoadNumber, SYSADMIN.matViewStatus.OnErrorAction] 09:13:35,726 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2046) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@46391794(5Ol6PtBi0E8b) 09:13:35,726 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2046) after getOrCreateTransactionContext : 5Ol6PtBi0E8b NONE ID:NONE 09:13:35,727 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2046) Creating TupleBuffer: 7305 [SYSADMIN.matViewStatus.TargetSchemaName, SYSADMIN.matViewStatus.TargetName, SYSADMIN.matViewStatus.Valid, SYSADMIN.matViewStatus.LoadState, SYSADMIN.matViewStatus.Updated, SYSADMIN.matViewStatus.Cardinality, SYSADMIN.matViewStatus.LoadNumber, SYSADMIN.matViewStatus.OnErrorAction] [class java.lang.String, class java.lang.String, class java.lang.Boolean, class java.lang.String, class java.sql.Timestamp, class java.lang.Long, class java.lang.Long, class java.lang.String] batch size 256 of type PROCESSOR 09:13:35,727 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2046) Creating TupleBuffer: 7306 [Name] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:35,727 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2046) QueryProcessor: closing processor 09:13:35,727 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2046) Removing TupleBuffer: 7306 09:13:35,727 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2046) Creating TupleBuffer: 7307 [convert(Version, integer)] [class java.lang.Integer] batch size 2048 of type PROCESSOR 09:13:35,727 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2046) QueryProcessor: closing processor 09:13:35,727 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2046) Removing TupleBuffer: 7307 09:13:35,727 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2046) Creating TupleBuffer: 7308 [UID] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:35,727 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2046) QueryProcessor: closing processor 09:13:35,727 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2046) Removing TupleBuffer: 7308 09:13:35,728 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2046) Creating TupleBuffer: 7309 [IsMaterialized] [class java.lang.Boolean] batch size 2048 of type PROCESSOR 09:13:35,728 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2046) QueryProcessor: closing processor 09:13:35,728 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2046) Removing TupleBuffer: 7309 09:13:35,728 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2046) Creating TupleBuffer: 7310 ["Value"] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:35,728 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2046) QueryProcessor: closing processor 09:13:35,728 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2046) Removing TupleBuffer: 7310 09:13:35,728 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2046) Creating TupleBuffer: 7311 ["Value"] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:35,728 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2046) QueryProcessor: closing processor 09:13:35,729 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2046) Removing TupleBuffer: 7311 09:13:35,730 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2046) 5Ol6PtBi0E8b.0.26.3224 Create State 09:13:35,731 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2046) 5Ol6PtBi0E8b.0.26.3224 Blocking on source query 5Ol6PtBi0E8b.0.26.3224 09:13:35,731 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2047) Running task for parent thread Worker2_QueryProcessorQueue2046 09:13:35,731 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2046) 5Ol6PtBi0E8b.0 Blocking on source request(s). 09:13:35,731 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2047) 5Ol6PtBi0E8b.0.26.3224 Processing NEW request: SELECT g_0.TARGETSCHEMANAME, g_0.TARGETNAME, g_0.VALID, g_0.LOADSTATE, g_0.UPDATED, g_0.CARDINALITY, g_0.LOADNUMBER FROM Source.JSTASTNY.DV_MATVIEWS_STATUSTABLE AS g_0 WHERE (g_0.VDBNAME = 'saphana') AND (g_0.VDBVERSION = 1) AND (g_0.SCHEMANAME = 'View') AND (g_0.Name = 'external_long_ttl') 09:13:35,731 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2046) Request Thread 5Ol6PtBi0E8b.0 - processor blocked 09:13:35,731 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2047) 5Ol6PtBi0E8b.0.26.3224 Obtained execution 09:13:35,732 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2047) Source-specific command: SELECT g_0."TARGETSCHEMANAME", g_0."TARGETNAME", g_0."VALID", g_0."LOADSTATE", g_0."UPDATED", g_0."CARDINALITY", g_0."LOADNUMBER" FROM "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE AS g_0 WHERE g_0."VDBNAME" = 'saphana' AND g_0."VDBVERSION" = 1 AND g_0."SCHEMANAME" = 'View' AND g_0."NAME" = 'external_long_ttl' 09:13:36,067 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2047) 5Ol6PtBi0E8b.0.26.3224 Executed command 09:13:36,068 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2047) 5Ol6PtBi0E8b.0.26.3224 Processing MORE request 09:13:36,068 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2047) 5Ol6PtBi0E8b.0.26.3224 Getting results from connector 09:13:36,068 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2047) 5Ol6PtBi0E8b.0.26.3224 Obtained last batch, total row count: 1 09:13:36,069 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2048) Request Thread 5Ol6PtBi0E8b.0 with state PROCESSING 09:13:36,069 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2048) 5Ol6PtBi0E8b.0.26.3224 Remove State 09:13:36,070 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2048) 5Ol6PtBi0E8b.0.26.3224 Processing Close : SELECT g_0.TARGETSCHEMANAME, g_0.TARGETNAME, g_0.VALID, g_0.LOADSTATE, g_0.UPDATED, g_0.CARDINALITY, g_0.LOADNUMBER FROM Source.JSTASTNY.DV_MATVIEWS_STATUSTABLE AS g_0 WHERE (g_0.VDBNAME = 'saphana') AND (g_0.VDBVERSION = 1) AND (g_0.SCHEMANAME = 'View') AND (g_0.Name = 'external_long_ttl') 09:13:36,237 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2048) 5Ol6PtBi0E8b.0.26.3224 Closed execution 09:13:36,237 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2048) 5Ol6PtBi0E8b.0.26.3224 Closed connection 09:13:36,238 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2048) QueryProcessor: closing processor 09:13:36,238 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2048) QueryProcessor: closing processor 09:13:36,238 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2048) 5Ol6PtBi0E8b.0 Finished Processing 09:13:36,238 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2048) [RequestWorkItem.sendResultsIfNeeded] requestID: 5Ol6PtBi0E8b.0 resultsID: 7305 done: true 09:13:36,239 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2048) closeQuery for requestID=5Ol6PtBi0E8b.0 09:13:36,240 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2048) cancelQuery for requestID=5Ol6PtBi0E8b.0 09:13:36,240 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2048) Failed to Cancel request 5Ol6PtBi0E8b.0 09:13:36,240 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2048) before cancelTransactions:org.teiid.dqp.internal.process.TransactionServerImpl@46391794(5Ol6PtBi0E8b,false) 09:13:36,240 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2048) after cancelTransactions : null 09:13:36,241 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2048) Removing tuplesource for the request 5Ol6PtBi0E8b.0 09:13:36,241 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2048) Removing TupleBuffer: 7305 09:13:36,241 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2049) Request Thread 5Qq01iSjX6hq.0 with state NEW 09:13:36,241 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2049) 5Qq01iSjX6hq.0 Command has no cache hint and result set cache mode is not on. 09:13:36,241 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2049) 5Qq01iSjX6hq.0 executing execute SYSADMIN.loadMatView('View','external_long_ttl') 09:13:36,270 DEBUG [org.teiid.PLANNER] (Worker0_QueryProcessorQueue2049) [LOW [Relational Planner] limit not supported by source SYS - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[Name]}, LOW [Relational Planner] limit not supported by source SYS - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[VirtualDatabases__1.Version]}, LOW [Relational Planner] limit not supported by source SYS - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[UID]}, LOW [Relational Planner] limit not supported by source SYS - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[Tables__1.IsMaterialized]}, LOW [Relational Planner] limit not supported by source SYS - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=["value"]}, LOW [Relational Planner] limit not supported by source SYS - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[Properties__1."Value"]}, LOW [Relational Planner] limit not supported by source SYS - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[Properties__2."Value"]}, LOW [Relational Planner] limit not supported by source SYS - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[Properties__3."Value"]}, LOW [Relational Planner] limit not supported by source SYS - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[Properties__4."Value"]}, LOW [Relational Planner] limit not supported by source SYS - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[Properties__5."Value"]}, LOW [Relational Planner] limit not supported by source SYS - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[Properties__6."Value"]}, LOW [Relational Planner] limit not supported by source SYSADMIN - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[TargetName, TargetSchemaName]}, LOW [Relational Planner] limit not supported by source SYS - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[Properties__7."Value"]}, LOW [Relational Planner] limit not supported by source __TEMP__ - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true}, LOW [Relational Planner] limit not supported by source __TEMP__ - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[Name]}, LOW [Relational Planner] limit not supported by source __TEMP__ - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true}, LOW [Relational Planner] limit not supported by source __TEMP__ - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[rowCount]}] 09:13:36,270 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2049) ProcessTree for 5Qq01iSjX6hq.0 ProjectNode(62) output=[SYSADMIN.loadMatView."return"] [SYSADMIN.loadMatView."return"] PlanExecutionNode(63) output=[SYSADMIN.loadMatView."return"] 09:13:36,270 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue2049) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@46391794(5Qq01iSjX6hq) 09:13:36,270 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue2049) after getOrCreateTransactionContext : 5Qq01iSjX6hq NONE ID:NONE 09:13:36,271 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Creating TupleBuffer: 7312 [SYSADMIN.loadMatView."return"] [class java.lang.Integer] batch size 2048 of type PROCESSOR 09:13:36,271 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Creating TupleBuffer: 7313 [Name] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:36,271 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2049) QueryProcessor: closing processor 09:13:36,271 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Removing TupleBuffer: 7313 09:13:36,271 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Creating TupleBuffer: 7314 [convert(Version, integer)] [class java.lang.Integer] batch size 2048 of type PROCESSOR 09:13:36,271 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2049) QueryProcessor: closing processor 09:13:36,271 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Removing TupleBuffer: 7314 09:13:36,271 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Creating TupleBuffer: 7315 [UID] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:36,272 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2049) QueryProcessor: closing processor 09:13:36,272 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Removing TupleBuffer: 7315 09:13:36,272 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Creating TupleBuffer: 7316 [IsMaterialized] [class java.lang.Boolean] batch size 2048 of type PROCESSOR 09:13:36,272 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2049) QueryProcessor: closing processor 09:13:36,272 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Removing TupleBuffer: 7316 09:13:36,272 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Creating TupleBuffer: 7317 ["value"] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:36,272 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2049) QueryProcessor: closing processor 09:13:36,273 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Removing TupleBuffer: 7317 09:13:36,273 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Creating TupleBuffer: 7318 ["value"] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:36,273 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2049) QueryProcessor: closing processor 09:13:36,273 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Removing TupleBuffer: 7318 09:13:36,273 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Creating TupleBuffer: 7319 ["value"] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:36,273 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2049) QueryProcessor: closing processor 09:13:36,273 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Removing TupleBuffer: 7319 09:13:36,273 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Creating TupleBuffer: 7320 ["value"] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:36,274 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2049) QueryProcessor: closing processor 09:13:36,274 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Removing TupleBuffer: 7320 09:13:36,274 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Creating TupleBuffer: 7321 [convert("value", integer)] [class java.lang.Integer] batch size 2048 of type PROCESSOR 09:13:36,274 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2049) QueryProcessor: closing processor 09:13:36,274 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Removing TupleBuffer: 7321 09:13:36,274 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Creating TupleBuffer: 7322 ["value"] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:36,274 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2049) QueryProcessor: closing processor 09:13:36,274 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Removing TupleBuffer: 7322 09:13:36,274 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Creating TupleBuffer: 7323 ["value"] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:36,275 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2049) QueryProcessor: closing processor 09:13:36,275 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Removing TupleBuffer: 7323 09:13:36,275 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Creating TupleBuffer: 7324 [(TargetName, TargetSchemaName)] [class [Ljava.lang.String;] batch size 512 of type PROCESSOR 09:13:36,275 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2049) QueryProcessor: closing processor 09:13:36,275 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Removing TupleBuffer: 7324 09:13:36,275 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Creating TupleBuffer: 7325 ["Value"] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:36,275 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2049) QueryProcessor: closing processor 09:13:36,275 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Removing TupleBuffer: 7325 09:13:36,278 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) Creating STree: 7326 09:13:36,278 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2049) 5Qq01iSjX6hq.0.65.3225 Create State 09:13:36,278 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) 5Qq01iSjX6hq.0.65.3225 Blocking on source query 5Qq01iSjX6hq.0.65.3225 09:13:36,279 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2050) Running task for parent thread Worker0_QueryProcessorQueue2049 09:13:36,279 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2049) 5Qq01iSjX6hq.0 Blocking on source request(s). 09:13:36,279 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2049) Request Thread 5Qq01iSjX6hq.0 - processor blocked 09:13:36,279 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2050) 5Qq01iSjX6hq.0.65.3225 Processing NEW request: SELECT g_0.Name, g_0.TARGETSCHEMANAME, g_0.TARGETNAME, g_0.VALID, g_0.LOADSTATE, g_0.UPDATED, g_0.CARDINALITY, g_0.LOADNUMBER FROM Source.JSTASTNY.DV_MATVIEWS_STATUSTABLE AS g_0 WHERE (g_0.VDBNAME = 'saphana') AND (g_0.VDBVERSION = 1) AND (g_0.SCHEMANAME = 'View') AND (g_0.Name = 'external_long_ttl') 09:13:36,280 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2050) 5Qq01iSjX6hq.0.65.3225 Obtained execution 09:13:36,282 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2050) Source-specific command: SELECT g_0."NAME", g_0."TARGETSCHEMANAME", g_0."TARGETNAME", g_0."VALID", g_0."LOADSTATE", g_0."UPDATED", g_0."CARDINALITY", g_0."LOADNUMBER" FROM "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE AS g_0 WHERE g_0."VDBNAME" = 'saphana' AND g_0."VDBVERSION" = 1 AND g_0."SCHEMANAME" = 'View' AND g_0."NAME" = 'external_long_ttl' 09:13:36,796 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2050) 5Qq01iSjX6hq.0.65.3225 Executed command 09:13:36,797 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2050) 5Qq01iSjX6hq.0.65.3225 Processing MORE request 09:13:36,797 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2050) 5Qq01iSjX6hq.0.65.3225 Getting results from connector 09:13:36,797 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2050) 5Qq01iSjX6hq.0.65.3225 Obtained last batch, total row count: 1 09:13:36,798 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2051) Request Thread 5Qq01iSjX6hq.0 with state PROCESSING 09:13:36,798 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2051) 5Qq01iSjX6hq.0.65.3225 Remove State 09:13:36,799 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2051) 5Qq01iSjX6hq.0.65.3225 Processing Close : SELECT g_0.Name, g_0.TARGETSCHEMANAME, g_0.TARGETNAME, g_0.VALID, g_0.LOADSTATE, g_0.UPDATED, g_0.CARDINALITY, g_0.LOADNUMBER FROM Source.JSTASTNY.DV_MATVIEWS_STATUSTABLE AS g_0 WHERE (g_0.VDBNAME = 'saphana') AND (g_0.VDBVERSION = 1) AND (g_0.SCHEMANAME = 'View') AND (g_0.Name = 'external_long_ttl') 09:13:36,970 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2051) 5Qq01iSjX6hq.0.65.3225 Closed execution 09:13:36,970 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2051) 5Qq01iSjX6hq.0.65.3225 Closed connection 09:13:36,971 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2051) Creating TupleBuffer: 7328 [#load.Name, #load.TargetSchemaName, #load.TargetName, #load.Valid, #load.LoadState, #load.Updated, #load.Cardinality, #load.LoadNumber] [class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.Boolean, class java.lang.String, class java.sql.Timestamp, class java.lang.Long, class java.lang.Long] batch size 256 of type PROCESSOR 09:13:36,971 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2051) Creating TupleBuffer: 7329 [rowId, #load.Name, #load.TargetSchemaName, #load.TargetName, #load.Valid, #load.LoadState, #load.Updated, #load.Cardinality, #load.LoadNumber] [class java.lang.Integer, class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.Boolean, class java.lang.String, class java.sql.Timestamp, class java.lang.Long, class java.lang.Long] batch size 256 of type PROCESSOR 09:13:36,971 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2051) Removing TupleBuffer: 7328 09:13:36,971 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2051) Removing TupleBuffer: 7329 09:13:36,972 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2051) QueryProcessor: closing processor 09:13:36,972 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2051) Creating TupleBuffer: 7330 [Name] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:36,972 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2051) Creating TupleBuffer: 7331 [#load.Name] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:36,972 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2051) Removing TupleBuffer: 7331 09:13:36,972 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2051) QueryProcessor: closing processor 09:13:36,972 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2051) Removing TupleBuffer: 7330 09:13:36,973 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2051) Creating TupleBuffer: 7332 [#load.Valid, #load.Updated, #load.LoadState, #load.Cardinality, #load.LoadNumber] [class java.lang.Boolean, class java.sql.Timestamp, class java.lang.String, class java.lang.Long, class java.lang.Long] batch size 1024 of type PROCESSOR 09:13:36,973 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2051) Removing TupleBuffer: 7332 09:13:36,973 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2051) QueryProcessor: closing processor 09:13:36,975 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2051) 5Qq01iSjX6hq.0.66.3226 Create State 09:13:36,976 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2051) 5Qq01iSjX6hq.0.66.3226 Blocking on source query 5Qq01iSjX6hq.0.66.3226 09:13:36,976 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2052) Running task for parent thread Worker0_QueryProcessorQueue2051 09:13:36,976 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2051) 5Qq01iSjX6hq.0 Blocking on source request(s). 09:13:36,976 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2051) Request Thread 5Qq01iSjX6hq.0 - processor blocked 09:13:36,976 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2052) 5Qq01iSjX6hq.0.66.3226 Processing NEW request: UPDATE Source.JSTASTNY.dv_matviews_statustable SET LoadNumber = 211, LoadState = 'LOADING', valid = TRUE, Updated = {ts'2016-06-21 09:13:36.974'}, Cardinality = 10 WHERE (VDBName = 'saphana') AND (VDBVersion = 1) AND (schemaName = 'View') AND (Name = 'external_long_ttl') AND (loadNumber = 210) 09:13:36,977 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2052) 5Qq01iSjX6hq.0.66.3226 Obtained execution 09:13:36,977 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2052) Source-specific command: UPDATE "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE SET "LOADNUMBER" = 211, "LOADSTATE" = 'LOADING', "VALID" = 1, "UPDATED" = {ts '2016-06-21 09:13:36.974'}, "CARDINALITY" = 10 WHERE "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE."VDBNAME" = 'saphana' AND "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE."VDBVERSION" = 1 AND "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE."SCHEMANAME" = 'View' AND "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE."NAME" = 'external_long_ttl' AND "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE."LOADNUMBER" = 210 09:13:37,151 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2052) 5Qq01iSjX6hq.0.66.3226 Executed command 09:13:37,151 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2052) 5Qq01iSjX6hq.0.66.3226 Processing MORE request 09:13:37,151 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2052) 5Qq01iSjX6hq.0.66.3226 Getting results from connector 09:13:37,151 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2052) 5Qq01iSjX6hq.0.66.3226 Obtained last batch, total row count: 1 09:13:37,152 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2053) Request Thread 5Qq01iSjX6hq.0 with state PROCESSING 09:13:37,152 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.66.3226 Remove State 09:13:37,152 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.66.3226 Processing Close : UPDATE Source.JSTASTNY.dv_matviews_statustable SET LoadNumber = 211, LoadState = 'LOADING', valid = TRUE, Updated = {ts'2016-06-21 09:13:36.974'}, Cardinality = 10 WHERE (VDBName = 'saphana') AND (VDBVersion = 1) AND (schemaName = 'View') AND (Name = 'external_long_ttl') AND (loadNumber = 210) 09:13:37,152 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.66.3226 Closed execution 09:13:37,153 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.66.3226 Closed connection 09:13:37,153 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2053) QueryProcessor: closing processor 09:13:37,153 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue2053) before begin:org.teiid.dqp.internal.process.TransactionServerImpl@46391794(5Qq01iSjX6hq NONE ID:NONE) 09:13:37,153 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue2053) after begin : null 09:13:37,154 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.68.3227 Create State 09:13:37,155 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.68.3227 Processing NEW request: EXEC Source.native('truncate table dvqe_X_XjdkY_Ydv_matviews_mat_view_stage') 09:13:37,155 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.68.3227 Obtained execution 09:13:37,155 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) Source-specific command: truncate table dvqe_X_XjdkY_Ydv_matviews_mat_view_stage 09:13:37,280 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) processing message:MessageHolder: key=180 contents=Invoke interface org.teiid.client.DQP.executeRequest 09:13:37,281 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2054) Request Thread /a7B+puFaYd0.9 with state NEW 09:13:37,281 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2054) /a7B+puFaYd0.9 Command has no cache hint and result set cache mode is not on. 09:13:37,281 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2054) /a7B+puFaYd0.9 executing exec SYSADMIN.loadMatView(schemaName=>'View',viewname=>'external_long_ttl', invalidate=>'true') 09:13:37,285 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2054) ProcessTree for /a7B+puFaYd0.9 ProjectNode(0) output=[SYSADMIN.loadMatView."return"] [SYSADMIN.loadMatView."return"] PlanExecutionNode(1) output=[SYSADMIN.loadMatView."return"] 09:13:37,286 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2054) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@46391794(/a7B+puFaYd0) 09:13:37,286 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2054) after getOrCreateTransactionContext : /a7B+puFaYd0 NONE ID:NONE 09:13:37,286 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Creating TupleBuffer: 7333 [SYSADMIN.loadMatView."return"] [class java.lang.Integer] batch size 2048 of type PROCESSOR 09:13:37,287 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Creating TupleBuffer: 7334 [Name] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:37,287 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2054) QueryProcessor: closing processor 09:13:37,288 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Removing TupleBuffer: 7334 09:13:37,288 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Creating TupleBuffer: 7335 [convert(Version, integer)] [class java.lang.Integer] batch size 2048 of type PROCESSOR 09:13:37,288 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2054) QueryProcessor: closing processor 09:13:37,288 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Removing TupleBuffer: 7335 09:13:37,288 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Creating TupleBuffer: 7336 [UID] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:37,289 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2054) QueryProcessor: closing processor 09:13:37,289 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Removing TupleBuffer: 7336 09:13:37,289 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Creating TupleBuffer: 7337 [IsMaterialized] [class java.lang.Boolean] batch size 2048 of type PROCESSOR 09:13:37,289 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2054) QueryProcessor: closing processor 09:13:37,289 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Removing TupleBuffer: 7337 09:13:37,290 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Creating TupleBuffer: 7338 ["value"] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:37,290 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2054) QueryProcessor: closing processor 09:13:37,290 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Removing TupleBuffer: 7338 09:13:37,290 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Creating TupleBuffer: 7339 ["value"] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:37,290 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2054) QueryProcessor: closing processor 09:13:37,290 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Removing TupleBuffer: 7339 09:13:37,290 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Creating TupleBuffer: 7340 ["value"] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:37,291 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2054) QueryProcessor: closing processor 09:13:37,291 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Removing TupleBuffer: 7340 09:13:37,291 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Creating TupleBuffer: 7341 ["value"] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:37,291 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2054) QueryProcessor: closing processor 09:13:37,291 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Removing TupleBuffer: 7341 09:13:37,291 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Creating TupleBuffer: 7342 [convert("value", integer)] [class java.lang.Integer] batch size 2048 of type PROCESSOR 09:13:37,291 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2054) QueryProcessor: closing processor 09:13:37,291 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Removing TupleBuffer: 7342 09:13:37,291 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Creating TupleBuffer: 7343 ["value"] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:37,292 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2054) QueryProcessor: closing processor 09:13:37,292 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Removing TupleBuffer: 7343 09:13:37,292 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Creating TupleBuffer: 7344 ["value"] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:37,292 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2054) QueryProcessor: closing processor 09:13:37,292 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Removing TupleBuffer: 7344 09:13:37,292 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Creating TupleBuffer: 7345 [(TargetName, TargetSchemaName)] [class [Ljava.lang.String;] batch size 512 of type PROCESSOR 09:13:37,292 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2054) QueryProcessor: closing processor 09:13:37,292 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Removing TupleBuffer: 7345 09:13:37,293 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Creating TupleBuffer: 7346 ["Value"] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:37,293 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2054) QueryProcessor: closing processor 09:13:37,293 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Removing TupleBuffer: 7346 09:13:37,295 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) Creating STree: 7347 09:13:37,295 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2054) /a7B+puFaYd0.9.70.3228 Create State 09:13:37,296 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) /a7B+puFaYd0.9.70.3228 Blocking on source query /a7B+puFaYd0.9.70.3228 09:13:37,296 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2054) /a7B+puFaYd0.9 Blocking on source request(s). 09:13:37,296 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2054) Request Thread /a7B+puFaYd0.9 - processor blocked 09:13:37,302 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue2055) Running task for parent thread Worker2_QueryProcessorQueue2054 09:13:37,302 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2055) /a7B+puFaYd0.9.70.3228 Processing NEW request: SELECT g_0.Name, g_0.TARGETSCHEMANAME, g_0.TARGETNAME, g_0.VALID, g_0.LOADSTATE, g_0.UPDATED, g_0.CARDINALITY, g_0.LOADNUMBER FROM Source.JSTASTNY.DV_MATVIEWS_STATUSTABLE AS g_0 WHERE (g_0.VDBNAME = 'saphana') AND (g_0.VDBVERSION = 1) AND (g_0.SCHEMANAME = 'View') AND (g_0.Name = 'external_long_ttl') 09:13:37,302 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2055) /a7B+puFaYd0.9.70.3228 Obtained execution 09:13:37,303 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2055) Source-specific command: SELECT g_0."NAME", g_0."TARGETSCHEMANAME", g_0."TARGETNAME", g_0."VALID", g_0."LOADSTATE", g_0."UPDATED", g_0."CARDINALITY", g_0."LOADNUMBER" FROM "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE AS g_0 WHERE g_0."VDBNAME" = 'saphana' AND g_0."VDBVERSION" = 1 AND g_0."SCHEMANAME" = 'View' AND g_0."NAME" = 'external_long_ttl' 09:13:37,331 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.68.3227 Executed command 09:13:37,332 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.68.3227 Processing MORE request 09:13:37,332 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.68.3227 Getting results from connector 09:13:37,332 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.68.3227 Obtained last batch, total row count: 1 09:13:37,332 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.68.3227 Remove State 09:13:37,333 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.68.3227 Processing Close : EXEC Source.native('truncate table dvqe_X_XjdkY_Ydv_matviews_mat_view_stage') 09:13:37,333 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.68.3227 Closed execution 09:13:37,333 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.68.3227 Closed connection 09:13:37,333 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2053) QueryProcessor: closing processor 09:13:37,336 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.71.3229 Create State 09:13:37,337 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.71.3229 Processing NEW request: SELECT g_0.ID, (g_0.BEFORE_LOAD + 1) FROM Source.JSTASTNY.DV_MATVIEWS_CHECK_TABLE AS g_0 WHERE g_0.ID = 'external_long_ttl' 09:13:37,337 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.71.3229 Obtained execution 09:13:37,337 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) Source-specific command: SELECT g_0."ID", (g_0."BEFORE_LOAD" + 1) FROM "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_CHECK_TABLE AS g_0 WHERE g_0."ID" = 'external_long_ttl' 09:13:37,638 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2055) /a7B+puFaYd0.9.70.3228 Executed command 09:13:37,639 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2055) /a7B+puFaYd0.9.70.3228 Processing MORE request 09:13:37,639 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2055) /a7B+puFaYd0.9.70.3228 Getting results from connector 09:13:37,639 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2055) /a7B+puFaYd0.9.70.3228 Obtained last batch, total row count: 1 09:13:37,640 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2056) Request Thread /a7B+puFaYd0.9 with state PROCESSING 09:13:37,640 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2056) /a7B+puFaYd0.9.70.3228 Remove State 09:13:37,640 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2056) /a7B+puFaYd0.9.70.3228 Processing Close : SELECT g_0.Name, g_0.TARGETSCHEMANAME, g_0.TARGETNAME, g_0.VALID, g_0.LOADSTATE, g_0.UPDATED, g_0.CARDINALITY, g_0.LOADNUMBER FROM Source.JSTASTNY.DV_MATVIEWS_STATUSTABLE AS g_0 WHERE (g_0.VDBNAME = 'saphana') AND (g_0.VDBVERSION = 1) AND (g_0.SCHEMANAME = 'View') AND (g_0.Name = 'external_long_ttl') 09:13:37,680 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.71.3229 Executed command 09:13:37,680 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.71.3229 Processing MORE request 09:13:37,680 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.71.3229 Getting results from connector 09:13:37,680 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.71.3229 Obtained last batch, total row count: 1 09:13:37,680 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.71.3229 Remove State 09:13:37,681 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.71.3229 Processing Close : SELECT g_0.ID, (g_0.BEFORE_LOAD + 1) FROM Source.JSTASTNY.DV_MATVIEWS_CHECK_TABLE AS g_0 WHERE g_0.ID = 'external_long_ttl' 09:13:37,807 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2056) /a7B+puFaYd0.9.70.3228 Closed execution 09:13:37,808 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2056) /a7B+puFaYd0.9.70.3228 Closed connection 09:13:37,808 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2056) Creating TupleBuffer: 7349 [#load.Name, #load.TargetSchemaName, #load.TargetName, #load.Valid, #load.LoadState, #load.Updated, #load.Cardinality, #load.LoadNumber] [class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.Boolean, class java.lang.String, class java.sql.Timestamp, class java.lang.Long, class java.lang.Long] batch size 256 of type PROCESSOR 09:13:37,808 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2056) Creating TupleBuffer: 7350 [rowId, #load.Name, #load.TargetSchemaName, #load.TargetName, #load.Valid, #load.LoadState, #load.Updated, #load.Cardinality, #load.LoadNumber] [class java.lang.Integer, class java.lang.String, class java.lang.String, class java.lang.String, class java.lang.Boolean, class java.lang.String, class java.sql.Timestamp, class java.lang.Long, class java.lang.Long] batch size 256 of type PROCESSOR 09:13:37,809 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2056) Removing TupleBuffer: 7349 09:13:37,809 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2056) Removing TupleBuffer: 7350 09:13:37,809 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2056) QueryProcessor: closing processor 09:13:37,809 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2056) Creating TupleBuffer: 7351 [Name] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:37,809 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2056) Creating TupleBuffer: 7352 [#load.Name] [class java.lang.String] batch size 1024 of type PROCESSOR 09:13:37,809 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2056) Removing TupleBuffer: 7352 09:13:37,809 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2056) QueryProcessor: closing processor 09:13:37,809 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2056) Removing TupleBuffer: 7351 09:13:37,809 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2056) Creating TupleBuffer: 7353 [#load.Valid, #load.Updated, #load.LoadState, #load.Cardinality, #load.LoadNumber] [class java.lang.Boolean, class java.sql.Timestamp, class java.lang.String, class java.lang.Long, class java.lang.Long] batch size 1024 of type PROCESSOR 09:13:37,810 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2056) Removing TupleBuffer: 7353 09:13:37,810 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2056) QueryProcessor: closing processor 09:13:37,811 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2056) /a7B+puFaYd0.9.77.3230 Create State 09:13:37,811 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2056) /a7B+puFaYd0.9.77.3230 Blocking on source query /a7B+puFaYd0.9.77.3230 09:13:37,811 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2056) /a7B+puFaYd0.9 Blocking on source request(s). 09:13:37,811 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue2057) Running task for parent thread Worker2_QueryProcessorQueue2056 09:13:37,811 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2056) Request Thread /a7B+puFaYd0.9 - processor blocked 09:13:37,811 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2057) /a7B+puFaYd0.9.77.3230 Processing NEW request: UPDATE Source.JSTASTNY.dv_matviews_statustable SET LoadNumber = 212, LoadState = 'LOADING', valid = FALSE, Updated = {ts'2016-06-21 09:13:37.81'}, Cardinality = 10 WHERE (VDBName = 'saphana') AND (VDBVersion = 1) AND (schemaName = 'View') AND (Name = 'external_long_ttl') AND (loadNumber = 211) 09:13:37,812 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2057) /a7B+puFaYd0.9.77.3230 Obtained execution 09:13:37,812 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2057) Source-specific command: UPDATE "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE SET "LOADNUMBER" = 212, "LOADSTATE" = 'LOADING', "VALID" = 0, "UPDATED" = {ts '2016-06-21 09:13:37.81'}, "CARDINALITY" = 10 WHERE "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE."VDBNAME" = 'saphana' AND "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE."VDBVERSION" = 1 AND "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE."SCHEMANAME" = 'View' AND "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE."NAME" = 'external_long_ttl' AND "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE."LOADNUMBER" = 211 09:13:37,853 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.71.3229 Closed execution 09:13:37,853 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.71.3229 Closed connection 09:13:37,853 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2053) QueryProcessor: closing processor 09:13:37,854 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2053) Creating TupleBuffer: 7354 [1] [class java.lang.Integer] batch size 2048 of type PROCESSOR 09:13:37,854 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.73.3231 Create State 09:13:37,854 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.73.3231 Processing NEW request: SELECT 1 FROM Source.JSTASTNY.DV_MATVIEWS_CHECK_TABLE AS g_0 WHERE g_0.ID = 'external_long_ttl' 09:13:37,854 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.73.3231 Obtained execution 09:13:37,855 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) Source-specific command: SELECT 1 FROM "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_CHECK_TABLE AS g_0 WHERE g_0."ID" = ? 09:13:37,985 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2057) /a7B+puFaYd0.9.77.3230 Executed command 09:13:37,985 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2057) /a7B+puFaYd0.9.77.3230 Processing MORE request 09:13:37,985 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2057) /a7B+puFaYd0.9.77.3230 Getting results from connector 09:13:37,985 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2057) /a7B+puFaYd0.9.77.3230 Obtained last batch, total row count: 1 09:13:37,986 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2058) Request Thread /a7B+puFaYd0.9 with state PROCESSING 09:13:37,986 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.77.3230 Remove State 09:13:37,986 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.77.3230 Processing Close : UPDATE Source.JSTASTNY.dv_matviews_statustable SET LoadNumber = 212, LoadState = 'LOADING', valid = FALSE, Updated = {ts'2016-06-21 09:13:37.81'}, Cardinality = 10 WHERE (VDBName = 'saphana') AND (VDBVersion = 1) AND (schemaName = 'View') AND (Name = 'external_long_ttl') AND (loadNumber = 211) 09:13:37,986 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.77.3230 Closed execution 09:13:37,986 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.77.3230 Closed connection 09:13:37,987 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2058) QueryProcessor: closing processor 09:13:37,987 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2058) before begin:org.teiid.dqp.internal.process.TransactionServerImpl@46391794(/a7B+puFaYd0 NONE ID:NONE) 09:13:37,987 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2058) after begin : null 09:13:37,988 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.79.3232 Create State 09:13:37,988 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.79.3232 Processing NEW request: EXEC Source.native('truncate table dvqe_X_XjdkY_Ydv_matviews_mat_view_stage') 09:13:37,989 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.79.3232 Obtained execution 09:13:37,989 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) Source-specific command: truncate table dvqe_X_XjdkY_Ydv_matviews_mat_view_stage 09:13:38,161 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.79.3232 Executed command 09:13:38,162 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.79.3232 Processing MORE request 09:13:38,162 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.79.3232 Getting results from connector 09:13:38,162 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.79.3232 Obtained last batch, total row count: 1 09:13:38,162 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.79.3232 Remove State 09:13:38,162 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.79.3232 Processing Close : EXEC Source.native('truncate table dvqe_X_XjdkY_Ydv_matviews_mat_view_stage') 09:13:38,162 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.79.3232 Closed execution 09:13:38,162 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.79.3232 Closed connection 09:13:38,162 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2058) QueryProcessor: closing processor 09:13:38,166 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.80.3233 Create State 09:13:38,166 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.80.3233 Processing NEW request: SELECT g_0.ID, (g_0.BEFORE_LOAD + 1) FROM Source.JSTASTNY.DV_MATVIEWS_CHECK_TABLE AS g_0 WHERE g_0.ID = 'external_long_ttl' 09:13:38,166 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.80.3233 Obtained execution 09:13:38,166 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) Source-specific command: SELECT g_0."ID", (g_0."BEFORE_LOAD" + 1) FROM "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_CHECK_TABLE AS g_0 WHERE g_0."ID" = 'external_long_ttl' 09:13:38,198 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.73.3231 Executed command 09:13:38,198 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.73.3231 Processing MORE request 09:13:38,198 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.73.3231 Getting results from connector 09:13:38,198 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.73.3231 Obtained results from connector, current row count: 1 09:13:38,198 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.73.3231 Processing MORE request 09:13:38,198 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.73.3231 Getting results from connector 09:13:38,198 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.73.3231 Obtained last batch, total row count: 1 09:13:38,198 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.73.3231 Remove State 09:13:38,199 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.73.3231 Processing Close : SELECT 1 FROM Source.JSTASTNY.DV_MATVIEWS_CHECK_TABLE AS g_0 WHERE g_0.ID = 'external_long_ttl' 09:13:38,370 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.73.3231 Closed execution 09:13:38,370 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.73.3231 Closed connection 09:13:38,371 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2053) QueryProcessor: closing processor 09:13:38,371 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2053) Removing TupleBuffer: 7354 09:13:38,371 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.74.3234 Create State 09:13:38,371 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.74.3234 Processing NEW request: UPDATE dv_matviews_check_table SET before_load = 211 WHERE id = 'external_long_ttl' 09:13:38,371 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.74.3234 Obtained execution 09:13:38,372 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) Source-specific command: UPDATE "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_CHECK_TABLE SET "BEFORE_LOAD" = ? WHERE "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_CHECK_TABLE."ID" = ? 09:13:38,502 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.80.3233 Executed command 09:13:38,502 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.80.3233 Processing MORE request 09:13:38,502 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.80.3233 Getting results from connector 09:13:38,502 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.80.3233 Obtained last batch, total row count: 1 09:13:38,502 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.80.3233 Remove State 09:13:38,503 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.80.3233 Processing Close : SELECT g_0.ID, (g_0.BEFORE_LOAD + 1) FROM Source.JSTASTNY.DV_MATVIEWS_CHECK_TABLE AS g_0 WHERE g_0.ID = 'external_long_ttl' 09:13:38,670 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.80.3233 Closed execution 09:13:38,670 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.80.3233 Closed connection 09:13:38,671 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2058) QueryProcessor: closing processor 09:13:38,671 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2058) Creating TupleBuffer: 7355 [1] [class java.lang.Integer] batch size 2048 of type PROCESSOR 09:13:38,671 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.82.3235 Create State 09:13:38,672 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.82.3235 Processing NEW request: SELECT 1 FROM Source.JSTASTNY.DV_MATVIEWS_CHECK_TABLE AS g_0 WHERE g_0.ID = 'external_long_ttl' 09:13:38,672 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.82.3235 Obtained execution 09:13:38,672 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) Source-specific command: SELECT 1 FROM "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_CHECK_TABLE AS g_0 WHERE g_0."ID" = ? 09:13:38,716 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.74.3234 Executed command 09:13:38,716 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.74.3234 Processing MORE request 09:13:38,716 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.74.3234 Getting results from connector 09:13:38,716 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.74.3234 Obtained last batch, total row count: 1 09:13:38,716 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.74.3234 Remove State 09:13:38,716 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.74.3234 Processing Close : UPDATE dv_matviews_check_table SET before_load = 211 WHERE id = 'external_long_ttl' 09:13:38,888 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.74.3234 Closed execution 09:13:38,888 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.74.3234 Closed connection 09:13:38,888 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2053) QueryProcessor: closing processor 09:13:38,888 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2053) QueryProcessor: closing processor 09:13:38,888 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2053) QueryProcessor: closing processor 09:13:38,891 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.87.3236 Create State 09:13:38,891 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.87.3236 Processing NEW request: INSERT INTO dv_matviews_mat_view_stage (customer_id, total_amount) SELECT g_0.ID, CONVERT(SUM(g_1.AMOUNT), integer) FROM Source.JSTASTNY.DV_MATVIEWS_CUSTOMERS AS g_0, Source.JSTASTNY.DV_MATVIEWS_ORDERS AS g_1 WHERE g_0.ID = g_1.CUSTOMER_ID GROUP BY g_0.ID 09:13:38,891 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.87.3236 Obtained execution 09:13:38,892 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) Source-specific command: INSERT INTO "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_MAT_VIEW_STAGE ("CUSTOMER_ID", "TOTAL_AMOUNT") SELECT g_0."ID", cast(SUM(g_1."AMOUNT") AS integer) FROM "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_CUSTOMERS AS g_0, "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_ORDERS AS g_1 WHERE g_0."ID" = g_1."CUSTOMER_ID" GROUP BY g_0."ID" 09:13:39,007 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.82.3235 Executed command 09:13:39,008 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.82.3235 Processing MORE request 09:13:39,008 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.82.3235 Getting results from connector 09:13:39,008 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.82.3235 Obtained results from connector, current row count: 1 09:13:39,008 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.82.3235 Processing MORE request 09:13:39,008 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.82.3235 Getting results from connector 09:13:39,008 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.82.3235 Obtained last batch, total row count: 1 09:13:39,008 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.82.3235 Remove State 09:13:39,008 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.82.3235 Processing Close : SELECT 1 FROM Source.JSTASTNY.DV_MATVIEWS_CHECK_TABLE AS g_0 WHERE g_0.ID = 'external_long_ttl' 09:13:39,069 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.87.3236 Executed command 09:13:39,070 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.87.3236 Processing MORE request 09:13:39,070 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.87.3236 Getting results from connector 09:13:39,070 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.87.3236 Obtained last batch, total row count: 1 09:13:39,070 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.87.3236 Remove State 09:13:39,070 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.87.3236 Processing Close : INSERT INTO dv_matviews_mat_view_stage (customer_id, total_amount) SELECT g_0.ID, CONVERT(SUM(g_1.AMOUNT), integer) FROM Source.JSTASTNY.DV_MATVIEWS_CUSTOMERS AS g_0, Source.JSTASTNY.DV_MATVIEWS_ORDERS AS g_1 WHERE g_0.ID = g_1.CUSTOMER_ID GROUP BY g_0.ID 09:13:39,070 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.87.3236 Closed execution 09:13:39,070 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.87.3236 Closed connection 09:13:39,071 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2053) QueryProcessor: closing processor 09:13:39,072 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2053) Creating STree: 7356 09:13:39,072 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.90.3237 Create State 09:13:39,073 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.90.3237 Processing NEW request: SELECT COUNT(*) FROM Source.JSTASTNY.DV_MATVIEWS_MAT_VIEW AS g_0 09:13:39,073 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.90.3237 Obtained execution 09:13:39,073 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) Source-specific command: SELECT COUNT(*) FROM "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_MAT_VIEW AS g_0 09:13:39,176 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.82.3235 Closed execution 09:13:39,176 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.82.3235 Closed connection 09:13:39,176 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2058) QueryProcessor: closing processor 09:13:39,176 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2058) Removing TupleBuffer: 7355 09:13:39,177 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.83.3238 Create State 09:13:39,177 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.83.3238 Processing NEW request: UPDATE dv_matviews_check_table SET before_load = 211 WHERE id = 'external_long_ttl' 09:13:39,177 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.83.3238 Obtained execution 09:13:39,177 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) Source-specific command: UPDATE "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_CHECK_TABLE SET "BEFORE_LOAD" = ? WHERE "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_CHECK_TABLE."ID" = ? 09:13:39,418 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.90.3237 Executed command 09:13:39,418 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.90.3237 Processing MORE request 09:13:39,419 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.90.3237 Getting results from connector 09:13:39,419 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.90.3237 Obtained last batch, total row count: 1 09:13:39,419 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.90.3237 Remove State 09:13:39,419 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.90.3237 Processing Close : SELECT COUNT(*) FROM Source.JSTASTNY.DV_MATVIEWS_MAT_VIEW AS g_0 09:13:39,514 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.83.3238 Executed command 09:13:39,514 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.83.3238 Processing MORE request 09:13:39,514 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.83.3238 Getting results from connector 09:13:39,514 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.83.3238 Obtained last batch, total row count: 1 09:13:39,514 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.83.3238 Remove State 09:13:39,514 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.83.3238 Processing Close : UPDATE dv_matviews_check_table SET before_load = 211 WHERE id = 'external_long_ttl' 09:13:39,590 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.90.3237 Closed execution 09:13:39,590 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2053) 5Qq01iSjX6hq.0.90.3237 Closed connection 09:13:39,591 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2053) Creating TupleBuffer: 7358 [#load_count.rowCount] [class java.lang.Integer] batch size 2048 of type PROCESSOR 09:13:39,591 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2053) Creating TupleBuffer: 7359 [rowId, #load_count.rowCount] [class java.lang.Integer, class java.lang.Integer] batch size 2048 of type PROCESSOR 09:13:39,591 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2053) Removing TupleBuffer: 7358 09:13:39,591 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2053) Removing TupleBuffer: 7359 09:13:39,592 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2053) QueryProcessor: closing processor 09:13:39,592 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2053) Creating TupleBuffer: 7360 [rowCount] [class java.lang.Integer] batch size 2048 of type PROCESSOR 09:13:39,592 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue2053) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@46391794(5Qq01iSjX6hq REQUEST ID:TransactionImple < ac, BasicAction: 0:ffff7f000001:328d8552:5768d49b:475 status: ActionStatus.RUNNING >) 09:13:39,592 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue2053) after suspend : null 09:13:39,592 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2053) Request Thread 5Qq01iSjX6hq.0 - processor blocked 09:13:39,592 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue2059) Request Thread 5Qq01iSjX6hq.0 with state PROCESSING 09:13:39,592 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue2059) before resume:org.teiid.dqp.internal.process.TransactionServerImpl@46391794(5Qq01iSjX6hq REQUEST ID:TransactionImple < ac, BasicAction: 0:ffff7f000001:328d8552:5768d49b:475 status: ActionStatus.RUNNING >) 09:13:39,593 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue2059) after resume : null 09:13:39,593 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue2059) Creating TupleBuffer: 7361 [#load_count.rowCount] [class java.lang.Integer] batch size 2048 of type PROCESSOR 09:13:39,593 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue2059) Removing TupleBuffer: 7361 09:13:39,593 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue2059) QueryProcessor: closing processor 09:13:39,593 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue2059) Removing TupleBuffer: 7360 09:13:39,594 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.92.3239 Create State 09:13:39,595 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.92.3239 Processing NEW request: EXEC Source.native('RENAME TABLE dvqe_X_XjdkY_Ydv_matviews_mat_view_stage TO dvqe_X_XjdkY_Ydv_matviews_mat_view_temp') 09:13:39,595 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.92.3239 Obtained execution 09:13:39,596 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) Source-specific command: RENAME TABLE dvqe_X_XjdkY_Ydv_matviews_mat_view_stage TO dvqe_X_XjdkY_Ydv_matviews_mat_view_temp 09:13:39,682 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.83.3238 Closed execution 09:13:39,682 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.83.3238 Closed connection 09:13:39,682 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2058) QueryProcessor: closing processor 09:13:39,683 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2058) QueryProcessor: closing processor 09:13:39,683 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2058) QueryProcessor: closing processor 09:13:39,686 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.94.3240 Create State 09:13:39,687 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.94.3240 Processing NEW request: INSERT INTO dv_matviews_mat_view_stage (customer_id, total_amount) SELECT g_0.ID, CONVERT(SUM(g_1.AMOUNT), integer) FROM Source.JSTASTNY.DV_MATVIEWS_CUSTOMERS AS g_0, Source.JSTASTNY.DV_MATVIEWS_ORDERS AS g_1 WHERE g_0.ID = g_1.CUSTOMER_ID GROUP BY g_0.ID 09:13:39,687 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.94.3240 Obtained execution 09:13:39,688 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) Source-specific command: INSERT INTO "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_MAT_VIEW_STAGE ("CUSTOMER_ID", "TOTAL_AMOUNT") SELECT g_0."ID", cast(SUM(g_1."AMOUNT") AS integer) FROM "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_CUSTOMERS AS g_0, "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_ORDERS AS g_1 WHERE g_0."ID" = g_1."CUSTOMER_ID" GROUP BY g_0."ID" 09:13:39,771 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.92.3239 Executed command 09:13:39,771 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.92.3239 Processing MORE request 09:13:39,771 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.92.3239 Getting results from connector 09:13:39,771 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.92.3239 Obtained last batch, total row count: 1 09:13:39,771 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.92.3239 Remove State 09:13:39,772 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.92.3239 Processing Close : EXEC Source.native('RENAME TABLE dvqe_X_XjdkY_Ydv_matviews_mat_view_stage TO dvqe_X_XjdkY_Ydv_matviews_mat_view_temp') 09:13:39,772 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.92.3239 Closed execution 09:13:39,772 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.92.3239 Closed connection 09:13:39,772 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue2059) QueryProcessor: closing processor 09:13:39,773 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.96.3241 Create State 09:13:39,773 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.96.3241 Processing NEW request: EXEC Source.native('RENAME TABLE dvqe_X_XjdkY_Ydv_matviews_mat_view TO dvqe_X_XjdkY_Ydv_matviews_mat_view_stage') 09:13:39,773 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.96.3241 Obtained execution 09:13:39,774 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) Source-specific command: RENAME TABLE dvqe_X_XjdkY_Ydv_matviews_mat_view TO dvqe_X_XjdkY_Ydv_matviews_mat_view_stage 09:13:39,857 WARN [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) Connector worker process failed for atomic-request=/a7B+puFaYd0.9.94.3240: org.teiid.translator.jdbc.JDBCExecutionException: 259 TEIID11013:TEIID11004 Error executing statement(s): [SQL: INSERT INTO "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_MAT_VIEW_STAGE ("CUSTOMER_ID", "TOTAL_AMOUNT") SELECT g_0."ID", cast(SUM(g_1."AMOUNT") AS integer) FROM "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_CUSTOMERS AS g_0, "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_ORDERS AS g_1 WHERE g_0."ID" = g_1."CUSTOMER_ID" GROUP BY g_0."ID"] at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:293) [translator-jdbc-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.translator.jdbc.JDBCUpdateExecution.execute(JDBCUpdateExecution.java:84) [translator-jdbc-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:402) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364) at sun.reflect.GeneratedMethodAccessor159.invoke(Unknown Source) [:1.7.0_79] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_79] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_79] at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) at com.sun.proxy.$Proxy80.execute(Unknown Source) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:142) at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:391) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) at org.teiid.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:608) at org.teiid.query.processor.proc.CreateCursorResultSetInstruction.process(CreateCursorResultSetInstruction.java:69) at org.teiid.query.processor.proc.ExecDynamicSqlInstruction$1.process(ExecDynamicSqlInstruction.java:216) at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:389) at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:298) at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:270) at org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_79] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_79] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_79] Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [259] (at 23): invalid table name: Could not find table/view DVQE_X_XJDKY_YDV_MATVIEWS_MAT_VIEW_STAGE in schema JSTASTNY: line 1 col 24 (at pos 23) at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:345) at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:176) at com.sap.db.jdbc.packet.ReplyPacket.buildExceptionChain(ReplyPacket.java:100) at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1130) at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:877) at com.sap.db.jdbc.StatementSapDB.sendCommand(StatementSapDB.java:932) at com.sap.db.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:981) at com.sap.db.jdbc.StatementSapDB.execute(StatementSapDB.java:256) at com.sap.db.jdbc.StatementSapDB.executeUpdate(StatementSapDB.java:416) at com.sap.db.jdbc.trace.Statement.executeUpdate(Statement.java:163) at org.jboss.jca.adapters.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:375) at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:207) [translator-jdbc-8.12.5.redhat-5.jar:8.12.5.redhat-5] ... 44 more 09:13:39,866 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.94.3240 Remove State 09:13:39,866 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.94.3240 Processing Close : INSERT INTO dv_matviews_mat_view_stage (customer_id, total_amount) SELECT g_0.ID, CONVERT(SUM(g_1.AMOUNT), integer) FROM Source.JSTASTNY.DV_MATVIEWS_CUSTOMERS AS g_0, Source.JSTASTNY.DV_MATVIEWS_ORDERS AS g_1 WHERE g_0.ID = g_1.CUSTOMER_ID GROUP BY g_0.ID 09:13:39,866 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.94.3240 Closed execution 09:13:39,866 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9.94.3240 Closed connection 09:13:39,866 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2058) QueryProcessor: closing processor 09:13:39,866 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2058) before resume:org.teiid.dqp.internal.process.TransactionServerImpl@46391794(/a7B+puFaYd0 REQUEST ID:TransactionImple < ac, BasicAction: 0:ffff7f000001:328d8552:5768d49b:476 status: ActionStatus.RUNNING >) 09:13:39,866 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2058) after resume : null 09:13:39,866 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2058) before rollback:org.teiid.dqp.internal.process.TransactionServerImpl@46391794(/a7B+puFaYd0 REQUEST ID:TransactionImple < ac, BasicAction: 0:ffff7f000001:328d8552:5768d49b:476 status: ActionStatus.RUNNING >) 09:13:39,867 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2058) after rollback : null 09:13:39,867 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2058) QueryProcessor: closing processor 09:13:39,868 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2058) TEIID30020 Processing exception for request /a7B+puFaYd0.9 'TEIID30168 Couldn't execute the dynamic SQL command "EXECUTE IMMEDIATE (updateStmt || ' AND loadNumber = DVARS.loadNumber') USING loadNumber = VARIABLES.loadNumber, vdbName = VARIABLES.vdbName, vdbVersion = VARIABLES.vdbVersion, schemaName = schemaName, viewName = loadMatView.viewName, updated = now(), LoadState = 'FAILED_LOAD', valid = (VARIABLES.valid) AND (NOT (invalidate)), cardinality = -1" with the SQL statement "UPDATE Source.JSTASTNY.dv_matviews_statustable SET LoadNumber = DVARS.LoadNumber, LoadState = DVARS.LoadState, valid = DVARS.valid, Updated = DVARS.updated, Cardinality = DVARS.cardinality WHERE VDBName = DVARS.vdbName AND VDBVersion = DVARS.vdbVersion AND schemaName = DVARS.schemaName AND Name = DVARS.viewName AND loadNumber = DVARS.loadNumber" due to: TEIID30347 There is a recursive invocation of group 'SYSADMIN.loadMatView'. Please correct the SQL.'. Originally QueryProcessingException CommandContext.java:434.: org.teiid.api.exception.query.QueryProcessingException: TEIID30168 Couldn't execute the dynamic SQL command "EXECUTE IMMEDIATE (updateStmt || ' AND loadNumber = DVARS.loadNumber') USING loadNumber = VARIABLES.loadNumber, vdbName = VARIABLES.vdbName, vdbVersion = VARIABLES.vdbVersion, schemaName = schemaName, viewName = loadMatView.viewName, updated = now(), LoadState = 'FAILED_LOAD', valid = (VARIABLES.valid) AND (NOT (invalidate)), cardinality = -1" with the SQL statement "UPDATE Source.JSTASTNY.dv_matviews_statustable SET LoadNumber = DVARS.LoadNumber, LoadState = DVARS.LoadState, valid = DVARS.valid, Updated = DVARS.updated, Cardinality = DVARS.cardinality WHERE VDBName = DVARS.vdbName AND VDBVersion = DVARS.vdbVersion AND schemaName = DVARS.schemaName AND Name = DVARS.viewName AND loadNumber = DVARS.loadNumber" due to: TEIID30347 There is a recursive invocation of group 'SYSADMIN.loadMatView'. Please correct the SQL. at org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:258) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:389) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:298) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:270) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_79] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_79] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_79] Caused by: org.teiid.api.exception.query.QueryProcessingException: TEIID30347 There is a recursive invocation of group 'SYSADMIN.loadMatView'. Please correct the SQL. at org.teiid.query.util.CommandContext.pushCall(CommandContext.java:434) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.query.processor.proc.ExecDynamicSqlInstruction.validateDynamicCommand(ExecDynamicSqlInstruction.java:368) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] at org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:173) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5] ... 22 more 09:13:39,869 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2058) Removing tuplesource for the request /a7B+puFaYd0.9 09:13:39,869 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2058) Removing TupleBuffer: 7333 09:13:39,869 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2058) /a7B+puFaYd0.9 Finished Processing 09:13:39,869 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2058) org.teiid.api.exception.query.QueryProcessingException: TEIID30168 Couldn't execute the dynamic SQL command "EXECUTE IMMEDIATE (updateStmt || ' AND loadNumber = DVARS.loadNumber') USING loadNumber = VARIABLES.loadNumber, vdbName = VARIABLES.vdbName, vdbVersion = VARIABLES.vdbVersion, schemaName = schemaName, viewName = loadMatView.viewName, updated = now(), LoadState = 'FAILED_LOAD', valid = (VARIABLES.valid) AND (NOT (invalidate)), cardinality = -1" with the SQL statement "UPDATE Source.JSTASTNY.dv_matviews_statustable SET LoadNumber = DVARS.LoadNumber, LoadState = DVARS.LoadState, valid = DVARS.valid, Updated = DVARS.updated, Cardinality = DVARS.cardinality WHERE VDBName = DVARS.vdbName AND VDBVersion = DVARS.vdbVersion AND schemaName = DVARS.schemaName AND Name = DVARS.viewName AND loadNumber = DVARS.loadNumber" due to: TEIID30347 There is a recursive invocation of group 'SYSADMIN.loadMatView'. Please correct the SQL. Sending error to client /a7B+puFaYd0.9 09:13:39,869 DEBUG [org.teiid.TRANSPORT] (Worker2_QueryProcessorQueue2058) send message: MessageHolder: key=180 contents=ResultsMessage rowCount=0 finalRow=-1 09:13:39,949 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.96.3241 Executed command 09:13:39,949 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.96.3241 Processing MORE request 09:13:39,949 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.96.3241 Getting results from connector 09:13:39,949 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.96.3241 Obtained last batch, total row count: 1 09:13:39,949 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.96.3241 Remove State 09:13:39,949 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.96.3241 Processing Close : EXEC Source.native('RENAME TABLE dvqe_X_XjdkY_Ydv_matviews_mat_view TO dvqe_X_XjdkY_Ydv_matviews_mat_view_stage') 09:13:39,949 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.96.3241 Closed execution 09:13:39,949 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.96.3241 Closed connection 09:13:39,950 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue2059) QueryProcessor: closing processor 09:13:39,951 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.98.3242 Create State 09:13:39,951 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.98.3242 Processing NEW request: EXEC Source.native('RENAME TABLE dvqe_X_XjdkY_Ydv_matviews_mat_view_temp TO dvqe_X_XjdkY_Ydv_matviews_mat_view') 09:13:39,951 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.98.3242 Obtained execution 09:13:39,951 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) Source-specific command: RENAME TABLE dvqe_X_XjdkY_Ydv_matviews_mat_view_temp TO dvqe_X_XjdkY_Ydv_matviews_mat_view 09:13:40,127 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.98.3242 Executed command 09:13:40,127 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.98.3242 Processing MORE request 09:13:40,127 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.98.3242 Getting results from connector 09:13:40,127 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.98.3242 Obtained last batch, total row count: 1 09:13:40,127 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.98.3242 Remove State 09:13:40,128 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.98.3242 Processing Close : EXEC Source.native('RENAME TABLE dvqe_X_XjdkY_Ydv_matviews_mat_view_temp TO dvqe_X_XjdkY_Ydv_matviews_mat_view') 09:13:40,128 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.98.3242 Closed execution 09:13:40,128 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.98.3242 Closed connection 09:13:40,128 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue2059) QueryProcessor: closing processor 09:13:40,131 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.99.3243 Create State 09:13:40,132 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.99.3243 Processing NEW request: SELECT g_0.ID, (g_0.AFTER_LOAD + 1) FROM Source.JSTASTNY.DV_MATVIEWS_CHECK_TABLE AS g_0 WHERE g_0.ID = 'external_long_ttl' 09:13:40,132 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.99.3243 Obtained execution 09:13:40,132 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) Source-specific command: SELECT g_0."ID", (g_0."AFTER_LOAD" + 1) FROM "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_CHECK_TABLE AS g_0 WHERE g_0."ID" = 'external_long_ttl' 09:13:40,476 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.99.3243 Executed command 09:13:40,476 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.99.3243 Processing MORE request 09:13:40,476 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.99.3243 Getting results from connector 09:13:40,476 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.99.3243 Obtained last batch, total row count: 1 09:13:40,476 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.99.3243 Remove State 09:13:40,476 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.99.3243 Processing Close : SELECT g_0.ID, (g_0.AFTER_LOAD + 1) FROM Source.JSTASTNY.DV_MATVIEWS_CHECK_TABLE AS g_0 WHERE g_0.ID = 'external_long_ttl' 09:13:40,648 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.99.3243 Closed execution 09:13:40,648 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.99.3243 Closed connection 09:13:40,648 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue2059) QueryProcessor: closing processor 09:13:40,649 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue2059) Creating TupleBuffer: 7362 [1] [class java.lang.Integer] batch size 2048 of type PROCESSOR 09:13:40,649 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.101.3244 Create State 09:13:40,649 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.101.3244 Processing NEW request: SELECT 1 FROM Source.JSTASTNY.DV_MATVIEWS_CHECK_TABLE AS g_0 WHERE g_0.ID = 'external_long_ttl' 09:13:40,649 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.101.3244 Obtained execution 09:13:40,650 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) Source-specific command: SELECT 1 FROM "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_CHECK_TABLE AS g_0 WHERE g_0."ID" = ? 09:13:40,995 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.101.3244 Executed command 09:13:40,995 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.101.3244 Processing MORE request 09:13:40,995 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.101.3244 Getting results from connector 09:13:40,995 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.101.3244 Obtained results from connector, current row count: 1 09:13:40,995 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.101.3244 Processing MORE request 09:13:40,996 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.101.3244 Getting results from connector 09:13:40,996 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.101.3244 Obtained last batch, total row count: 1 09:13:40,996 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.101.3244 Remove State 09:13:40,996 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.101.3244 Processing Close : SELECT 1 FROM Source.JSTASTNY.DV_MATVIEWS_CHECK_TABLE AS g_0 WHERE g_0.ID = 'external_long_ttl' 09:13:41,167 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.101.3244 Closed execution 09:13:41,167 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.101.3244 Closed connection 09:13:41,168 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue2059) QueryProcessor: closing processor 09:13:41,168 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue2059) Removing TupleBuffer: 7362 09:13:41,168 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.102.3245 Create State 09:13:41,168 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.102.3245 Processing NEW request: UPDATE dv_matviews_check_table SET after_load = 208 WHERE id = 'external_long_ttl' 09:13:41,169 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.102.3245 Obtained execution 09:13:41,169 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) Source-specific command: UPDATE "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_CHECK_TABLE SET "AFTER_LOAD" = ? WHERE "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_CHECK_TABLE."ID" = ? 09:13:41,512 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.102.3245 Executed command 09:13:41,513 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.102.3245 Processing MORE request 09:13:41,513 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.102.3245 Getting results from connector 09:13:41,513 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.102.3245 Obtained last batch, total row count: 1 09:13:41,513 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.102.3245 Remove State 09:13:41,513 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.102.3245 Processing Close : UPDATE dv_matviews_check_table SET after_load = 208 WHERE id = 'external_long_ttl' 09:13:41,684 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.102.3245 Closed execution 09:13:41,685 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue2059) 5Qq01iSjX6hq.0.102.3245 Closed connection 09:13:41,685 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue2059) QueryProcessor: closing processor 09:13:41,685 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue2059) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@46391794(5Qq01iSjX6hq REQUEST ID:TransactionImple < ac, BasicAction: 0:ffff7f000001:328d8552:5768d49b:475 status: ActionStatus.RUNNING >) 09:13:41,685 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue2059) after suspend : null 09:13:41,685 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue2059) Request Thread 5Qq01iSjX6hq.0 - processor blocked 09:13:41,685 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2060) Request Thread 5Qq01iSjX6hq.0 with state PROCESSING 09:13:41,686 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2060) before resume:org.teiid.dqp.internal.process.TransactionServerImpl@46391794(5Qq01iSjX6hq REQUEST ID:TransactionImple < ac, BasicAction: 0:ffff7f000001:328d8552:5768d49b:475 status: ActionStatus.RUNNING >) 09:13:41,686 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2060) after resume : null 09:13:41,686 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2060) QueryProcessor: closing processor 09:13:41,686 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2060) QueryProcessor: closing processor 09:13:41,688 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2060) 5Qq01iSjX6hq.0.105.3246 Create State 09:13:41,689 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2060) 5Qq01iSjX6hq.0.105.3246 Processing NEW request: UPDATE Source.JSTASTNY.dv_matviews_statustable SET LoadNumber = 211, LoadState = 'LOADED', valid = TRUE, Updated = {ts'2016-06-21 09:13:41.687'}, Cardinality = 10 WHERE (VDBName = 'saphana') AND (VDBVersion = 1) AND (schemaName = 'View') AND (Name = 'external_long_ttl') AND (loadNumber = 211) 09:13:41,689 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2060) 5Qq01iSjX6hq.0.105.3246 Obtained execution 09:13:41,690 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2060) Source-specific command: UPDATE "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE SET "LOADNUMBER" = 211, "LOADSTATE" = 'LOADED', "VALID" = 1, "UPDATED" = {ts '2016-06-21 09:13:41.687'}, "CARDINALITY" = ? WHERE "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE."VDBNAME" = 'saphana' AND "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE."VDBVERSION" = 1 AND "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE."SCHEMANAME" = 'View' AND "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE."NAME" = 'external_long_ttl' AND "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_STATUSTABLE."LOADNUMBER" = 211 09:13:42,037 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2060) 5Qq01iSjX6hq.0.105.3246 Executed command 09:13:42,037 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2060) 5Qq01iSjX6hq.0.105.3246 Processing MORE request 09:13:42,037 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2060) 5Qq01iSjX6hq.0.105.3246 Getting results from connector 09:13:42,037 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2060) 5Qq01iSjX6hq.0.105.3246 Obtained last batch, total row count: 1 09:13:42,037 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2060) 5Qq01iSjX6hq.0.105.3246 Remove State 09:13:42,038 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2060) 5Qq01iSjX6hq.0.105.3246 Processing Close : UPDATE Source.JSTASTNY.dv_matviews_statustable SET LoadNumber = 211, LoadState = 'LOADED', valid = TRUE, Updated = {ts'2016-06-21 09:13:41.687'}, Cardinality = 10 WHERE (VDBName = 'saphana') AND (VDBVersion = 1) AND (schemaName = 'View') AND (Name = 'external_long_ttl') AND (loadNumber = 211) 09:13:42,209 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2060) 5Qq01iSjX6hq.0.105.3246 Closed execution 09:13:42,209 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2060) 5Qq01iSjX6hq.0.105.3246 Closed connection 09:13:42,210 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2060) QueryProcessor: closing processor 09:13:42,210 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2060) before resume:org.teiid.dqp.internal.process.TransactionServerImpl@46391794(5Qq01iSjX6hq REQUEST ID:TransactionImple < ac, BasicAction: 0:ffff7f000001:328d8552:5768d49b:475 status: ActionStatus.RUNNING >) 09:13:42,210 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2060) after resume : null 09:13:42,210 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2060) before commit:org.teiid.dqp.internal.process.TransactionServerImpl@46391794(5Qq01iSjX6hq REQUEST ID:TransactionImple < ac, BasicAction: 0:ffff7f000001:328d8552:5768d49b:475 status: ActionStatus.RUNNING >) 09:13:42,384 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2060) after commit : null 09:13:42,384 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2060) QueryProcessor: closing processor 09:13:42,384 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2060) 5Qq01iSjX6hq.0 Finished Processing 09:13:42,384 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2060) [RequestWorkItem.sendResultsIfNeeded] requestID: 5Qq01iSjX6hq.0 resultsID: 7312 done: true 09:13:42,385 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2060) closeQuery for requestID=5Qq01iSjX6hq.0 09:13:42,385 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2060) cancelQuery for requestID=5Qq01iSjX6hq.0 09:13:42,386 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2060) Failed to Cancel request 5Qq01iSjX6hq.0 09:13:42,386 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2060) before cancelTransactions:org.teiid.dqp.internal.process.TransactionServerImpl@46391794(5Qq01iSjX6hq,false) 09:13:42,386 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue2060) after cancelTransactions : null 09:13:42,386 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue2060) Removing tuplesource for the request 5Qq01iSjX6hq.0 09:13:42,386 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue2060) Removing TupleBuffer: 7312