2019-11-24 00:35:55,063 DEBUG NodeContainer PostgreSQL Connector 4:6 has new state: CONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:55,063 DEBUG NodeContainer PostgreSQL Connector 4:6 has new state: CONFIGURED_QUEUED 2019-11-24 00:35:55,064 DEBUG NodeContainer Empty Table Creator 4:10 has new state: CONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:55,064 DEBUG NodeContainer Empty Table Creator 4:10 has new state: CONFIGURED_QUEUED 2019-11-24 00:35:55,064 DEBUG NodeContainer Constant Value Column 4:11 has new state: CONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:55,064 DEBUG NodeContainer Table Creator 4:8 has new state: CONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:55,064 DEBUG NodeContainer Table Creator 4:8 has new state: CONFIGURED_QUEUED 2019-11-24 00:35:55,064 DEBUG NodeContainer Table Row To Variable Loop Start 4:15 has new state: CONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:55,064 DEBUG NodeContainer CASE Switch Variable (Start) 4:17 has new state: CONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:55,064 DEBUG NodeContainer Constant Value Column 4:12 has new state: CONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:55,064 DEBUG NodeContainer Constant Value Column 4:13 has new state: CONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:55,064 DEBUG NodeContainer CASE Switch Data (End) 4:22 has new state: UNCONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:55,064 DEBUG NodeContainer DB Writer 4:7 has new state: UNCONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:55,065 DEBUG NodeContainer Variable Loop End 4:16 has new state: UNCONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:55,065 DEBUG NodeContainer DB Writer - different table definitions in a loop 4 has new state: EXECUTING 2019-11-24 00:35:55,065 DEBUG PostgreSQL Connector 4:6 PostgreSQL Connector 4:6 doBeforePreExecution 2019-11-24 00:35:55,065 DEBUG PostgreSQL Connector 4:6 PostgreSQL Connector 4:6 has new state: PREEXECUTE 2019-11-24 00:35:55,065 DEBUG PostgreSQL Connector 4:6 PostgreSQL Connector 4:6 doBeforeExecution 2019-11-24 00:35:55,065 DEBUG PostgreSQL Connector 4:6 PostgreSQL Connector 4:6 has new state: EXECUTING 2019-11-24 00:35:55,065 DEBUG PostgreSQL Connector 4:6 Adding handler cadb609d-5c9a-4a2a-a2d5-c2237ffb68f3 (PostgreSQL Connector 4:6: ) - 1 in total 2019-11-24 00:35:55,065 DEBUG PostgreSQL Connector 4:6 PostgreSQL Connector 4:6 Start execute 2019-11-24 00:35:55,065 DEBUG Empty Table Creator 4:10 Empty Table Creator 4:10 doBeforePreExecution 2019-11-24 00:35:55,065 DEBUG Empty Table Creator 4:10 Empty Table Creator 4:10 has new state: PREEXECUTE 2019-11-24 00:35:55,065 DEBUG Empty Table Creator 4:10 Empty Table Creator 4:10 doBeforeExecution 2019-11-24 00:35:55,065 DEBUG Empty Table Creator 4:10 Empty Table Creator 4:10 has new state: EXECUTING 2019-11-24 00:35:55,065 DEBUG Empty Table Creator 4:10 Adding handler 8347e1d9-2586-4ec3-bcda-ba03bd31311f (Empty Table Creator 4:10: ) - 2 in total 2019-11-24 00:35:55,066 DEBUG Empty Table Creator 4:10 Empty Table Creator 4:10 Start execute 2019-11-24 00:35:55,066 DEBUG Table Creator 4:8 Table Creator 4:8 doBeforePreExecution 2019-11-24 00:35:55,066 DEBUG Table Creator 4:8 Table Creator 4:8 has new state: PREEXECUTE 2019-11-24 00:35:55,066 DEBUG Table Creator 4:8 Table Creator 4:8 doBeforeExecution 2019-11-24 00:35:55,066 DEBUG Table Creator 4:8 Table Creator 4:8 has new state: EXECUTING 2019-11-24 00:35:55,066 DEBUG Table Creator 4:8 Adding handler 7e54752a-c8d0-413a-acbd-fca5833d6e0a (Table Creator 4:8: ) - 3 in total 2019-11-24 00:35:55,066 DEBUG Table Creator 4:8 Table Creator 4:8 Start execute 2019-11-24 00:35:55,066 DEBUG Empty Table Creator 4:10 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2019-11-24 00:35:55,067 DEBUG Table Creator 4:8 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2019-11-24 00:35:55,067 DEBUG NodeContainer ROOT has new state: EXECUTING 2019-11-24 00:35:55,067 DEBUG PostgreSQL Connector 4:6 New database session: DefaultDBSessionInformation(id=6a7a134b-70d9-4b7d-9271-98bcd8299ccd, dbType=DBType(id=postgres, name=PostgreSQL, description=null), driverDefinition=DBDriverDefinition(id=PostgreSQL, name=PostgreSQL, version=42.2.0, driverClass=org.postgresql.Driver, dbType=DBType(id=postgres, name=PostgreSQL, description=null), description=, origin=EXTENSION), connectionController=org.knime.database.connection.UserDBConnectionController=(url=jdbc:postgresql://ads_op_db_host:5432/pgtestdb, authenticationType=USER_PWD, user=pgtest, password=true), dialectId=postgres, attributeValues={}) 2019-11-24 00:35:55,084 INFO Empty Table Creator 4:10 Empty Table Creator 4:10 End execute (0 secs) 2019-11-24 00:35:55,093 DEBUG Empty Table Creator 4:10 Empty Table Creator 4:10 doBeforePostExecution 2019-11-24 00:35:55,093 DEBUG Empty Table Creator 4:10 Empty Table Creator 4:10 has new state: POSTEXECUTE 2019-11-24 00:35:55,099 DEBUG Empty Table Creator 4:10 Empty Table Creator 4:10 doAfterExecute - success 2019-11-24 00:35:55,100 DEBUG Empty Table Creator 4:10 Empty Table Creator 4:10 has new state: EXECUTED 2019-11-24 00:35:55,100 DEBUG Constant Value Column 4:11 Configure succeeded. (Constant Value Column) 2019-11-24 00:35:55,100 DEBUG Empty Table Creator 4:10 Constant Value Column 4:11 has new state: CONFIGURED_QUEUED 2019-11-24 00:35:55,116 DEBUG Constant Value Column 4:11 Constant Value Column 4:11 doBeforePreExecution 2019-11-24 00:35:55,123 DEBUG Constant Value Column 4:11 Constant Value Column 4:11 has new state: PREEXECUTE 2019-11-24 00:35:55,123 DEBUG Constant Value Column 4:11 Constant Value Column 4:11 doBeforeExecution 2019-11-24 00:35:55,123 DEBUG Constant Value Column 4:11 Constant Value Column 4:11 has new state: EXECUTING 2019-11-24 00:35:55,123 DEBUG Constant Value Column 4:11 Adding handler c38959cc-4549-4a6b-b797-7f238a05621e (Constant Value Column 4:11: ) - 4 in total 2019-11-24 00:35:55,123 DEBUG Constant Value Column 4:11 Constant Value Column 4:11 Start execute 2019-11-24 00:35:55,124 DEBUG Constant Value Column 4:11 KNIME Buffer cache statistics: 2019-11-24 00:35:55,124 INFO Table Creator 4:8 Table Creator 4:8 End execute (0 secs) 2019-11-24 00:35:55,131 DEBUG Table Creator 4:8 Table Creator 4:8 doBeforePostExecution 2019-11-24 00:35:55,131 DEBUG Table Creator 4:8 Table Creator 4:8 has new state: POSTEXECUTE 2019-11-24 00:35:55,131 DEBUG Table Creator 4:8 Table Creator 4:8 doAfterExecute - success 2019-11-24 00:35:55,131 DEBUG Table Creator 4:8 Table Creator 4:8 has new state: EXECUTED 2019-11-24 00:35:55,131 DEBUG Table Row To Variable Loop Start 4:15 Configure succeeded. (Table Row To Variable Loop Start) 2019-11-24 00:35:55,131 DEBUG Table Creator 4:8 Table Row To Variable Loop Start 4:15 has new state: CONFIGURED_QUEUED 2019-11-24 00:35:55,127 DEBUG NodeTimer$GlobalNodeStats Successfully wrote node usage stats to file: /Users/jan/workspace/ders/ads_poc/knime/.metadata/knime/nodeusage_3.0.json 2019-11-24 00:35:55,125 DEBUG Constant Value Column 4:11 59 tables currently held in cache 2019-11-24 00:35:55,132 DEBUG Constant Value Column 4:11 215 distinct tables cached 2019-11-24 00:35:55,132 DEBUG Constant Value Column 4:11 156 tables invalidated successfully 2019-11-24 00:35:55,132 DEBUG Constant Value Column 4:11 0 tables dropped by garbage collector 2019-11-24 00:35:55,133 DEBUG Constant Value Column 4:11 393 cache hits (hard-referenced) 2019-11-24 00:35:55,133 DEBUG Constant Value Column 4:11 0 cache hits (softly referenced) 2019-11-24 00:35:55,133 DEBUG Constant Value Column 4:11 0 cache hits (weakly referenced) 2019-11-24 00:35:55,133 DEBUG Constant Value Column 4:11 0 cache misses 2019-11-24 00:35:55,134 DEBUG Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 doBeforePreExecution 2019-11-24 00:35:55,134 DEBUG Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 has new state: PREEXECUTE 2019-11-24 00:35:55,134 DEBUG Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 doBeforeExecution 2019-11-24 00:35:55,134 DEBUG Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 has new state: EXECUTING 2019-11-24 00:35:55,134 DEBUG Table Row To Variable Loop Start 4:15 Adding handler b30cfaeb-ce07-441d-a14a-f0fc2acce853 (Table Row To Variable Loop Start 4:15: ) - 5 in total 2019-11-24 00:35:55,134 DEBUG Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 Start execute 2019-11-24 00:35:55,134 INFO Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 End execute (0 secs) 2019-11-24 00:35:55,135 DEBUG Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 doBeforePostExecution 2019-11-24 00:35:55,135 DEBUG Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 has new state: POSTEXECUTE 2019-11-24 00:35:55,135 DEBUG Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 doAfterExecute - success 2019-11-24 00:35:55,135 DEBUG Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 has new state: EXECUTED 2019-11-24 00:35:55,135 DEBUG CASE Switch Variable (Start) 4:17 Configure succeeded. (CASE Switch Variable (Start)) 2019-11-24 00:35:55,135 DEBUG Table Row To Variable Loop Start 4:15 CASE Switch Variable (Start) 4:17 has new state: CONFIGURED_QUEUED 2019-11-24 00:35:55,136 DEBUG Constant Value Column 4:12 Configure succeeded. (Constant Value Column) 2019-11-24 00:35:55,137 DEBUG Constant Value Column 4:13 Configure succeeded. (Constant Value Column) 2019-11-24 00:35:55,137 WARN CASE Switch Data (End) 4:22 The table structures of active ports are not compatible. 2019-11-24 00:35:55,137 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 doBeforePreExecution 2019-11-24 00:35:55,137 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 has new state: PREEXECUTE 2019-11-24 00:35:55,137 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 doBeforeExecution 2019-11-24 00:35:55,137 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 has new state: EXECUTING 2019-11-24 00:35:55,137 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 Start execute 2019-11-24 00:35:55,138 DEBUG Constant Value Column 4:11 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2019-11-24 00:35:55,138 INFO CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 End execute (0 secs) 2019-11-24 00:35:55,138 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 doBeforePostExecution 2019-11-24 00:35:55,138 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 has new state: POSTEXECUTE 2019-11-24 00:35:55,138 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 doAfterExecute - success 2019-11-24 00:35:55,138 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 has new state: EXECUTED 2019-11-24 00:35:55,139 DEBUG Constant Value Column 4:12 Configure succeeded. (Constant Value Column) 2019-11-24 00:35:55,139 DEBUG CASE Switch Variable (Start) 4:17 Constant Value Column 4:13 has new state: IDLE 2019-11-24 00:35:55,139 DEBUG CASE Switch Variable (Start) 4:17 Constant Value Column 4:13 has new state: CONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:55,139 DEBUG CASE Switch Data (End) 4:22 Configure succeeded. (CASE Switch Data (End)) 2019-11-24 00:35:55,139 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Data (End) 4:22 has new state: CONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:55,140 INFO Constant Value Column 4:11 Constant Value Column 4:11 End execute (0 secs) 2019-11-24 00:35:55,140 DEBUG Constant Value Column 4:11 Constant Value Column 4:11 doBeforePostExecution 2019-11-24 00:35:55,140 DEBUG Constant Value Column 4:11 Constant Value Column 4:11 has new state: POSTEXECUTE 2019-11-24 00:35:55,141 DEBUG Constant Value Column 4:11 Constant Value Column 4:11 doAfterExecute - success 2019-11-24 00:35:55,141 DEBUG Constant Value Column 4:11 Constant Value Column 4:11 has new state: EXECUTED 2019-11-24 00:35:55,141 DEBUG Constant Value Column 4:12 Configure succeeded. (Constant Value Column) 2019-11-24 00:35:55,141 DEBUG Constant Value Column 4:11 Constant Value Column 4:12 has new state: CONFIGURED_QUEUED 2019-11-24 00:35:55,142 DEBUG Constant Value Column 4:11 Constant Value Column 4:13 has new state: CONFIGURED_QUEUED 2019-11-24 00:35:55,142 DEBUG CASE Switch Data (End) 4:22 Configure succeeded. (CASE Switch Data (End)) 2019-11-24 00:35:55,142 DEBUG Constant Value Column 4:12 Constant Value Column 4:12 doBeforePreExecution 2019-11-24 00:35:55,143 DEBUG Constant Value Column 4:12 Constant Value Column 4:12 has new state: PREEXECUTE 2019-11-24 00:35:55,143 DEBUG Constant Value Column 4:12 Constant Value Column 4:12 doBeforeExecution 2019-11-24 00:35:55,143 DEBUG Constant Value Column 4:12 Constant Value Column 4:12 has new state: EXECUTING 2019-11-24 00:35:55,143 DEBUG Constant Value Column 4:12 Constant Value Column 4:12 Start execute 2019-11-24 00:35:55,143 DEBUG Constant Value Column 4:13 Constant Value Column 4:13 doBeforePreExecution 2019-11-24 00:35:55,143 DEBUG Constant Value Column 4:13 Constant Value Column 4:13 has new state: PREEXECUTE 2019-11-24 00:35:55,143 DEBUG Constant Value Column 4:13 Constant Value Column 4:13 doBeforeExecution 2019-11-24 00:35:55,143 DEBUG Constant Value Column 4:13 Constant Value Column 4:13 has new state: EXECUTING 2019-11-24 00:35:55,143 DEBUG Constant Value Column 4:13 Constant Value Column 4:13 Start execute 2019-11-24 00:35:55,143 INFO Constant Value Column 4:13 Constant Value Column 4:13 End execute (0 secs) 2019-11-24 00:35:55,143 DEBUG Constant Value Column 4:13 Constant Value Column 4:13 doBeforePostExecution 2019-11-24 00:35:55,144 DEBUG Constant Value Column 4:13 Constant Value Column 4:13 has new state: POSTEXECUTE 2019-11-24 00:35:55,144 DEBUG Constant Value Column 4:13 Constant Value Column 4:13 doAfterExecute - success 2019-11-24 00:35:55,144 DEBUG Constant Value Column 4:13 Constant Value Column 4:13 has new state: EXECUTED 2019-11-24 00:35:55,144 DEBUG CASE Switch Data (End) 4:22 Configure succeeded. (CASE Switch Data (End)) 2019-11-24 00:35:55,145 DEBUG Constant Value Column 4:12 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2019-11-24 00:35:55,146 INFO Constant Value Column 4:12 Constant Value Column 4:12 End execute (0 secs) 2019-11-24 00:35:55,146 DEBUG Constant Value Column 4:12 Constant Value Column 4:12 doBeforePostExecution 2019-11-24 00:35:55,146 DEBUG Constant Value Column 4:12 Constant Value Column 4:12 has new state: POSTEXECUTE 2019-11-24 00:35:55,146 DEBUG Constant Value Column 4:12 Constant Value Column 4:12 doAfterExecute - success 2019-11-24 00:35:55,146 DEBUG Constant Value Column 4:12 Constant Value Column 4:12 has new state: EXECUTED 2019-11-24 00:35:55,147 DEBUG CASE Switch Data (End) 4:22 Configure succeeded. (CASE Switch Data (End)) 2019-11-24 00:35:55,147 DEBUG Constant Value Column 4:12 CASE Switch Data (End) 4:22 has new state: CONFIGURED_QUEUED 2019-11-24 00:35:55,147 DEBUG CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 doBeforePreExecution 2019-11-24 00:35:55,147 DEBUG CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 has new state: PREEXECUTE 2019-11-24 00:35:55,147 DEBUG CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 doBeforeExecution 2019-11-24 00:35:55,148 DEBUG CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 has new state: EXECUTING 2019-11-24 00:35:55,148 DEBUG CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 Start execute 2019-11-24 00:35:55,149 DEBUG CASE Switch Data (End) 4:22 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2019-11-24 00:35:55,153 INFO CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 End execute (0 secs) 2019-11-24 00:35:55,153 DEBUG CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 doBeforePostExecution 2019-11-24 00:35:55,153 DEBUG CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 has new state: POSTEXECUTE 2019-11-24 00:35:55,153 DEBUG CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 doAfterExecute - success 2019-11-24 00:35:55,154 DEBUG CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 has new state: EXECUTED 2019-11-24 00:35:55,462 DEBUG PostgreSQL Connector 4:6 Acquiring connection. 2019-11-24 00:35:55,519 DEBUG PostgreSQL Connector 4:6 The managed connection has been relinquished. 2019-11-24 00:35:55,519 DEBUG PostgreSQL Connector 4:6 The managed connection has been closed. 2019-11-24 00:35:55,519 DEBUG PostgreSQL Connector 4:6 Database session information:DefaultDBSessionInformation(id=6a7a134b-70d9-4b7d-9271-98bcd8299ccd, dbType=DBType(id=postgres, name=PostgreSQL, description=null), driverDefinition=DBDriverDefinition(id=PostgreSQL, name=PostgreSQL, version=42.2.0, driverClass=org.postgresql.Driver, dbType=DBType(id=postgres, name=PostgreSQL, description=null), description=, origin=EXTENSION), connectionController=org.knime.database.connection.UserDBConnectionController=(url=jdbc:postgresql://ads_op_db_host:5432/pgtestdb, authenticationType=USER_PWD, user=pgtest, password=true), dialectId=postgres, attributeValues={}) 2019-11-24 00:35:55,520 DEBUG PostgreSQL Connector 4:6 Attribute details of database session 6a7a134b-70d9-4b7d-9271-98bcd8299ccd: AttributeValueRepository(attributes={knime.db.connection.jdbc.fetch_size=knime.db.connection.jdbc.fetch_size:10000, knime.db.connection.parameter.append.separator=knime.db.connection.parameter.append.separator:&, knime.db.dialect.sql.delimiter.identifier.opening=knime.db.dialect.sql.delimiter.identifier.opening:", knime.db.dialect.sql.table_reference.keyword=knime.db.dialect.sql.table_reference.keyword:AS, knime.db.dialect.sql.capability.operation.minus=knime.db.dialect.sql.capability.operation.minus:true, knime.db.dialect.sql.insert_into_table_with_select=knime.db.dialect.sql.insert_into_table_with_select:true, knime.db.agent.writer.autocommit_if_failing_on_error=knime.db.agent.writer.autocommit_if_failing_on_error:true, knime.db.dialect.sql.table_reference.derived_table=knime.db.dialect.sql.table_reference.derived_table:true, knime.db.connection.parameter.append=knime.db.connection.parameter.append:false, knime.db.connection.parameter.append.last.suffix=knime.db.connection.parameter.append.last.suffix:, knime.db.connection.jdbc.properties=knime.db.connection.jdbc.properties:#Sat Nov 23 23:20:13 CET 2019 , knime.db.connection.statement.cancellation.polling_period=knime.db.connection.statement.cancellation.polling_period:1000, knime.db.dialect.sql.capability.random=knime.db.dialect.sql.capability.random:true, knime.db.connection.statement.cancellation.enabled=knime.db.connection.statement.cancellation.enabled:true, knime.db.connection.metadata.configure.timeout=knime.db.connection.metadata.configure.timeout:3, knime.db.connection.metadata.configure.enabled=knime.db.connection.metadata.configure.enabled:true, knime.db.dialect.sql.create_table.define_constraint_name=knime.db.dialect.sql.create_table.define_constraint_name:true, knime.db.dialect.sql.identifier.delimiting.onlyspaces=knime.db.dialect.sql.identifier.delimiting.onlyspaces:false, knime.db.connection.time_zone=knime.db.connection.time_zone:UTC, knime.db.dialect.sql.capability.random_seed=knime.db.dialect.sql.capability.random_seed:false, knime.db.dialect.sql.create.table.temporary=knime.db.dialect.sql.create.table.temporary:GLOBAL TEMPORARY, knime.db.dialect.sql.minus_operator.keyword=knime.db.dialect.sql.minus_operator.keyword:EXCEPT, knime.db.dialect.sql.delimiter.identifier.closing=knime.db.dialect.sql.delimiter.identifier.closing:", knime.db.connection.logger.log.errors=knime.db.connection.logger.log.errors:false, knime.db.dialect.sql.capability.expression.case=knime.db.dialect.sql.capability.expression.case:true, knime.db.connection.parameter.append.initial.separator=knime.db.connection.parameter.append.initial.separator:?, knime.db.connection.transaction.enabled=knime.db.connection.transaction.enabled:true, knime.db.dialect.sql.create_table.if_not_exists=knime.db.dialect.sql.create_table.if_not_exists:IF NOT EXISTS, knime.db.dialect.sql.drop_table=knime.db.dialect.sql.drop_table:true, knime.db.connection.validation_query=knime.db.connection.validation_query:SELECT 0, knime.db.connection.parameter.append.user_and_password=knime.db.connection.parameter.append.user_and_password:false, knime.db.connection.logger.enabled=knime.db.connection.logger.enabled:false}, none default values={}) 2019-11-24 00:35:55,520 DEBUG PostgreSQL Connector 4:6 Acquiring connection. 2019-11-24 00:35:55,604 DEBUG PostgreSQL Connector 4:6 All the statements have already been closed. 2019-11-24 00:35:55,605 DEBUG PostgreSQL Connector 4:6 The managed connection has been relinquished. 2019-11-24 00:35:55,605 DEBUG PostgreSQL Connector 4:6 The managed connection has been closed. 2019-11-24 00:35:55,608 INFO PostgreSQL Connector 4:6 PostgreSQL Connector 4:6 End execute (0 secs) 2019-11-24 00:35:55,608 DEBUG PostgreSQL Connector 4:6 PostgreSQL Connector 4:6 doBeforePostExecution 2019-11-24 00:35:55,608 DEBUG PostgreSQL Connector 4:6 PostgreSQL Connector 4:6 has new state: POSTEXECUTE 2019-11-24 00:35:55,608 DEBUG PostgreSQL Connector 4:6 PostgreSQL Connector 4:6 doAfterExecute - success 2019-11-24 00:35:55,608 DEBUG PostgreSQL Connector 4:6 PostgreSQL Connector 4:6 has new state: EXECUTED 2019-11-24 00:35:55,612 DEBUG DB Writer 4:7 Acquiring connection. 2019-11-24 00:35:55,688 DEBUG DB Writer 4:7 All the statements have already been closed. 2019-11-24 00:35:55,688 DEBUG DB Writer 4:7 The managed connection has been relinquished. 2019-11-24 00:35:55,688 DEBUG DB Writer 4:7 The managed connection has been closed. 2019-11-24 00:35:55,688 DEBUG DB Writer 4:7 Acquiring connection. 2019-11-24 00:35:55,853 DEBUG DB Writer 4:7 All the statements have already been closed. 2019-11-24 00:35:55,854 DEBUG DB Writer 4:7 The managed connection has been relinquished. 2019-11-24 00:35:55,854 DEBUG DB Writer 4:7 The managed connection has been closed. 2019-11-24 00:35:55,854 DEBUG DB Writer 4:7 Configure succeeded. (DB Writer) 2019-11-24 00:35:55,854 DEBUG PostgreSQL Connector 4:6 DB Writer 4:7 has new state: CONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:55,854 DEBUG PostgreSQL Connector 4:6 DB Writer 4:7 has new state: CONFIGURED_QUEUED 2019-11-24 00:35:55,854 DEBUG Variable Loop End 4:16 Configure succeeded. (Variable Loop End) 2019-11-24 00:35:55,855 DEBUG PostgreSQL Connector 4:6 Variable Loop End 4:16 has new state: CONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:55,855 DEBUG DB Writer 4:7 DB Writer 4:7 doBeforePreExecution 2019-11-24 00:35:55,855 DEBUG DB Writer 4:7 DB Writer 4:7 has new state: PREEXECUTE 2019-11-24 00:35:55,855 DEBUG DB Writer 4:7 DB Writer 4:7 doBeforeExecution 2019-11-24 00:35:55,855 DEBUG DB Writer 4:7 DB Writer 4:7 has new state: EXECUTING 2019-11-24 00:35:55,856 DEBUG DB Writer 4:7 DB Writer 4:7 Start execute 2019-11-24 00:35:55,864 DEBUG DB Writer 4:7 Acquiring connection. 2019-11-24 00:35:55,935 DEBUG DB Writer 4:7 All the statements have already been closed. 2019-11-24 00:35:55,935 DEBUG DB Writer 4:7 The managed connection has been relinquished. 2019-11-24 00:35:55,935 DEBUG DB Writer 4:7 The managed connection has been closed. 2019-11-24 00:35:55,935 DEBUG DB Writer 4:7 Acquiring connection. 2019-11-24 00:35:55,936 DEBUG DB Writer 4:7 Create SQL statement as prepareStatement: INSERT INTO "op"."temp_1" ("value", "name") VALUES (?,?) 2019-11-24 00:35:56,088 DEBUG DB Writer 4:7 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2019-11-24 00:35:56,173 DEBUG DB Writer 4:7 All the statements have already been closed. 2019-11-24 00:35:56,173 DEBUG DB Writer 4:7 The managed connection has been relinquished. 2019-11-24 00:35:56,173 DEBUG DB Writer 4:7 The managed connection has been closed. 2019-11-24 00:35:56,174 INFO DB Writer 4:7 DB Writer 4:7 End execute (0 secs) 2019-11-24 00:35:56,174 DEBUG DB Writer 4:7 DB Writer 4:7 doBeforePostExecution 2019-11-24 00:35:56,174 DEBUG DB Writer 4:7 DB Writer 4:7 has new state: POSTEXECUTE 2019-11-24 00:35:56,174 DEBUG DB Writer 4:7 DB Writer 4:7 doAfterExecute - success 2019-11-24 00:35:56,174 DEBUG DB Writer 4:7 DB Writer 4:7 has new state: EXECUTED 2019-11-24 00:35:56,174 DEBUG Variable Loop End 4:16 Configure succeeded. (Variable Loop End) 2019-11-24 00:35:56,175 DEBUG DB Writer 4:7 Variable Loop End 4:16 has new state: CONFIGURED_QUEUED 2019-11-24 00:35:56,175 DEBUG Variable Loop End 4:16 Variable Loop End 4:16 doBeforePreExecution 2019-11-24 00:35:56,175 DEBUG Variable Loop End 4:16 Variable Loop End 4:16 has new state: PREEXECUTE 2019-11-24 00:35:56,175 DEBUG Variable Loop End 4:16 Variable Loop End 4:16 doBeforeExecution 2019-11-24 00:35:56,175 DEBUG Variable Loop End 4:16 Variable Loop End 4:16 has new state: EXECUTING 2019-11-24 00:35:56,175 DEBUG Variable Loop End 4:16 Variable Loop End 4:16 Start execute 2019-11-24 00:35:56,177 DEBUG Variable Loop End 4:16 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2019-11-24 00:35:56,177 INFO Variable Loop End 4:16 Variable Loop End 4:16 End execute (0 secs) 2019-11-24 00:35:56,177 DEBUG Variable Loop End 4:16 Variable Loop End 4:16 doBeforePostExecution 2019-11-24 00:35:56,177 DEBUG Variable Loop End 4:16 Variable Loop End 4:16 has new state: POSTEXECUTE 2019-11-24 00:35:56,177 DEBUG Variable Loop End 4:16 Variable Loop End 4:16 doAfterExecute - success 2019-11-24 00:35:56,178 DEBUG Variable Loop End 4:16 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2019-11-24 00:35:56,178 DEBUG Variable Loop End 4:16 Variable Loop End 4:16 has new state: CONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:56,178 DEBUG Variable Loop End 4:16 Table Row To Variable Loop Start 4:15 has new state: EXECUTED_MARKEDFOREXEC 2019-11-24 00:35:56,179 DEBUG DB Writer 4:7 reset 2019-11-24 00:35:56,179 DEBUG DB Writer 4:7 clean output ports. 2019-11-24 00:35:56,179 DEBUG Variable Loop End 4:16 DB Writer 4:7 has new state: IDLE 2019-11-24 00:35:56,179 DEBUG CASE Switch Data (End) 4:22 reset 2019-11-24 00:35:56,179 DEBUG CASE Switch Data (End) 4:22 clean output ports. 2019-11-24 00:35:56,179 DEBUG Variable Loop End 4:16 CASE Switch Data (End) 4:22 has new state: IDLE 2019-11-24 00:35:56,179 DEBUG Constant Value Column 4:13 reset 2019-11-24 00:35:56,179 DEBUG Constant Value Column 4:13 clean output ports. 2019-11-24 00:35:56,179 DEBUG Variable Loop End 4:16 Constant Value Column 4:13 has new state: IDLE 2019-11-24 00:35:56,179 DEBUG Constant Value Column 4:12 reset 2019-11-24 00:35:56,179 DEBUG Constant Value Column 4:12 clean output ports. 2019-11-24 00:35:56,180 DEBUG Variable Loop End 4:16 Constant Value Column 4:12 has new state: IDLE 2019-11-24 00:35:56,180 DEBUG CASE Switch Variable (Start) 4:17 reset 2019-11-24 00:35:56,180 DEBUG CASE Switch Variable (Start) 4:17 clean output ports. 2019-11-24 00:35:56,180 DEBUG Variable Loop End 4:16 CASE Switch Variable (Start) 4:17 has new state: IDLE 2019-11-24 00:35:56,180 DEBUG Variable Loop End 4:16 clean output ports. 2019-11-24 00:35:56,180 DEBUG Variable Loop End 4:16 CASE Switch Variable (Start) 4:17 has new state: UNCONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:56,180 DEBUG Variable Loop End 4:16 Constant Value Column 4:12 has new state: UNCONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:56,180 DEBUG Variable Loop End 4:16 Constant Value Column 4:13 has new state: UNCONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:56,180 DEBUG Variable Loop End 4:16 CASE Switch Data (End) 4:22 has new state: UNCONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:56,180 DEBUG Variable Loop End 4:16 DB Writer 4:7 has new state: UNCONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:56,180 DEBUG Variable Loop End 4:16 Table Row To Variable Loop Start 4:15 has new state: EXECUTED_QUEUED 2019-11-24 00:35:56,181 DEBUG Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 doBeforePreExecution 2019-11-24 00:35:56,181 DEBUG Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 has new state: PREEXECUTE 2019-11-24 00:35:56,181 DEBUG Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 doBeforeExecution 2019-11-24 00:35:56,181 DEBUG Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 has new state: EXECUTING 2019-11-24 00:35:56,181 DEBUG Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 Start execute 2019-11-24 00:35:56,181 DEBUG Table Row To Variable Loop Start 4:15 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2019-11-24 00:35:56,183 INFO Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 End execute (0 secs) 2019-11-24 00:35:56,183 DEBUG Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 doBeforePostExecution 2019-11-24 00:35:56,183 DEBUG Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 has new state: POSTEXECUTE 2019-11-24 00:35:56,183 DEBUG Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 doAfterExecute - success 2019-11-24 00:35:56,183 DEBUG Table Row To Variable Loop Start 4:15 Table Row To Variable Loop Start 4:15 has new state: EXECUTED 2019-11-24 00:35:56,183 DEBUG CASE Switch Variable (Start) 4:17 Configure succeeded. (CASE Switch Variable (Start)) 2019-11-24 00:35:56,183 DEBUG Table Row To Variable Loop Start 4:15 CASE Switch Variable (Start) 4:17 has new state: CONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:56,183 DEBUG Table Row To Variable Loop Start 4:15 CASE Switch Variable (Start) 4:17 has new state: CONFIGURED_QUEUED 2019-11-24 00:35:56,184 DEBUG Constant Value Column 4:12 Configure succeeded. (Constant Value Column) 2019-11-24 00:35:56,184 DEBUG Table Row To Variable Loop Start 4:15 Constant Value Column 4:12 has new state: CONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:56,184 DEBUG Constant Value Column 4:13 Configure succeeded. (Constant Value Column) 2019-11-24 00:35:56,184 DEBUG Table Row To Variable Loop Start 4:15 Constant Value Column 4:13 has new state: CONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:56,184 WARN CASE Switch Data (End) 4:22 The table structures of active ports are not compatible. 2019-11-24 00:35:56,184 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 doBeforePreExecution 2019-11-24 00:35:56,184 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 has new state: PREEXECUTE 2019-11-24 00:35:56,184 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 doBeforeExecution 2019-11-24 00:35:56,185 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 has new state: EXECUTING 2019-11-24 00:35:56,185 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 Start execute 2019-11-24 00:35:56,185 INFO CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 End execute (0 secs) 2019-11-24 00:35:56,185 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 doBeforePostExecution 2019-11-24 00:35:56,185 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 has new state: POSTEXECUTE 2019-11-24 00:35:56,185 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 doAfterExecute - success 2019-11-24 00:35:56,185 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Variable (Start) 4:17 has new state: EXECUTED 2019-11-24 00:35:56,185 DEBUG CASE Switch Variable (Start) 4:17 Constant Value Column 4:12 has new state: IDLE 2019-11-24 00:35:56,185 DEBUG CASE Switch Variable (Start) 4:17 Constant Value Column 4:12 has new state: CONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:56,185 DEBUG CASE Switch Variable (Start) 4:17 Constant Value Column 4:12 has new state: CONFIGURED_QUEUED 2019-11-24 00:35:56,186 DEBUG Constant Value Column 4:13 Configure succeeded. (Constant Value Column) 2019-11-24 00:35:56,186 DEBUG CASE Switch Variable (Start) 4:17 Constant Value Column 4:13 has new state: CONFIGURED_QUEUED 2019-11-24 00:35:56,186 DEBUG CASE Switch Data (End) 4:22 Configure succeeded. (CASE Switch Data (End)) 2019-11-24 00:35:56,186 DEBUG CASE Switch Variable (Start) 4:17 CASE Switch Data (End) 4:22 has new state: CONFIGURED_MARKEDFOREXEC 2019-11-24 00:35:56,186 WARN DB Writer 4:7 Included column list contains invalid column(s)! 2019-11-24 00:35:56,187 DEBUG Constant Value Column 4:12 Constant Value Column 4:12 doBeforePreExecution 2019-11-24 00:35:56,187 DEBUG Constant Value Column 4:12 Constant Value Column 4:12 has new state: PREEXECUTE 2019-11-24 00:35:56,187 DEBUG Constant Value Column 4:12 Constant Value Column 4:12 doBeforeExecution 2019-11-24 00:35:56,187 DEBUG Constant Value Column 4:12 Constant Value Column 4:12 has new state: EXECUTING 2019-11-24 00:35:56,187 DEBUG Constant Value Column 4:12 Constant Value Column 4:12 Start execute 2019-11-24 00:35:56,187 DEBUG Constant Value Column 4:13 Constant Value Column 4:13 doBeforePreExecution 2019-11-24 00:35:56,187 DEBUG Constant Value Column 4:13 Constant Value Column 4:13 has new state: PREEXECUTE 2019-11-24 00:35:56,187 INFO Constant Value Column 4:12 Constant Value Column 4:12 End execute (0 secs) 2019-11-24 00:35:56,187 DEBUG Constant Value Column 4:13 Constant Value Column 4:13 doBeforeExecution 2019-11-24 00:35:56,187 DEBUG Constant Value Column 4:13 Constant Value Column 4:13 has new state: EXECUTING 2019-11-24 00:35:56,187 DEBUG Constant Value Column 4:13 Constant Value Column 4:13 Start execute 2019-11-24 00:35:56,188 DEBUG Constant Value Column 4:12 Constant Value Column 4:12 doBeforePostExecution 2019-11-24 00:35:56,188 DEBUG Constant Value Column 4:12 Constant Value Column 4:12 has new state: POSTEXECUTE 2019-11-24 00:35:56,188 DEBUG Constant Value Column 4:13 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2019-11-24 00:35:56,188 DEBUG Constant Value Column 4:12 Constant Value Column 4:12 doAfterExecute - success 2019-11-24 00:35:56,188 DEBUG Constant Value Column 4:12 Constant Value Column 4:12 has new state: EXECUTED 2019-11-24 00:35:56,189 DEBUG CASE Switch Data (End) 4:22 Configure succeeded. (CASE Switch Data (End)) 2019-11-24 00:35:56,189 INFO Constant Value Column 4:13 Constant Value Column 4:13 End execute (0 secs) 2019-11-24 00:35:56,189 DEBUG Constant Value Column 4:13 Constant Value Column 4:13 doBeforePostExecution 2019-11-24 00:35:56,189 DEBUG Constant Value Column 4:13 Constant Value Column 4:13 has new state: POSTEXECUTE 2019-11-24 00:35:56,189 DEBUG Constant Value Column 4:13 Constant Value Column 4:13 doAfterExecute - success 2019-11-24 00:35:56,189 DEBUG Constant Value Column 4:13 Constant Value Column 4:13 has new state: EXECUTED 2019-11-24 00:35:56,189 DEBUG CASE Switch Data (End) 4:22 Configure succeeded. (CASE Switch Data (End)) 2019-11-24 00:35:56,189 DEBUG Constant Value Column 4:13 CASE Switch Data (End) 4:22 has new state: CONFIGURED_QUEUED 2019-11-24 00:35:56,190 WARN DB Writer 4:7 Included column list contains invalid column(s)! 2019-11-24 00:35:56,190 DEBUG CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 doBeforePreExecution 2019-11-24 00:35:56,190 DEBUG CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 has new state: PREEXECUTE 2019-11-24 00:35:56,190 DEBUG CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 doBeforeExecution 2019-11-24 00:35:56,190 DEBUG CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 has new state: EXECUTING 2019-11-24 00:35:56,190 DEBUG CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 Start execute 2019-11-24 00:35:56,192 DEBUG CASE Switch Data (End) 4:22 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2019-11-24 00:35:56,194 INFO CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 End execute (0 secs) 2019-11-24 00:35:56,194 DEBUG CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 doBeforePostExecution 2019-11-24 00:35:56,194 DEBUG CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 has new state: POSTEXECUTE 2019-11-24 00:35:56,194 DEBUG CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 doAfterExecute - success 2019-11-24 00:35:56,194 DEBUG CASE Switch Data (End) 4:22 CASE Switch Data (End) 4:22 has new state: EXECUTED 2019-11-24 00:35:56,194 WARN DB Writer 4:7 Included column list contains invalid column(s)! 2019-11-24 00:35:56,194 DEBUG CASE Switch Data (End) 4:22 DB Writer 4:7 has new state: IDLE 2019-11-24 00:35:56,195 DEBUG CASE Switch Data (End) 4:22 Variable Loop End 4:16 has new state: CONFIGURED 2019-11-24 00:35:56,195 DEBUG CASE Switch Data (End) 4:22 DB Writer - different table definitions in a loop 4 has new state: IDLE 2019-11-24 00:35:56,195 DEBUG NodeContainer ROOT has new state: IDLE