2011-06-03 14:21:08,530 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-2) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@4189b8f7
2011-06-03 14:21:08,531 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-2) 	START USER COMMAND:	startTime=2011-06-03 14:21:08.531	requestID=QEhfkFyvS0cR.1	txID=null	sessionID=QEhfkFyvS0cR	applicationName=JDBC	principal=admin@teiid-security	vdbName=misura124	vdbVersion=1	sql=SELECT
    codop,
    codref,
    data,
    quantita,
    fatturato
FROM
    sole_rugiada_log.misura124.solerugiada.vendita_referenza
2011-06-03 14:21:08,531 DEBUG [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue164) Request Thread QEhfkFyvS0cR.1 with state NEW
2011-06-03 14:21:08,531 DEBUG [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue164) QEhfkFyvS0cR.1 No cache directive
2011-06-03 14:21:08,531 DEBUG [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue164) QEhfkFyvS0cR.1 executing  SELECT
    codop,
    codref,
    data,
    quantita,
    fatturato
FROM
    sole_rugiada_log.misura124.solerugiada.vendita_referenza
2011-06-03 14:21:08,539 DEBUG [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue164) ProcessTree for QEhfkFyvS0cR.1 ProjectNode(1) output=[SR_op.codop, codref, SR_v.data, convert(SUM(SR_v.quantita), INTEGER) AS quantita, SUM(SUM((((support_phy.mediator.referenza.quantita / quantita_reale) * SR_v.quantita) * SR_v.prezzo))) AS fatturato] [SR_op.codop, codref, SR_v.data, convert(SUM(SR_v.quantita), INTEGER) AS quantita, SUM(SUM((((support_phy.mediator.referenza.quantita / quantita_reale) * SR_v.quantita) * SR_v.prezzo))) AS fatturato]
  GroupingNode(2) output=[SR_op.codop, codref, SR_v.data, SUM(SR_v.quantita), SUM(SUM((((support_phy.mediator.referenza.quantita / quantita_reale) * SR_v.quantita) * SR_v.prezzo)))] [SR_op.codop, SR_v.data, SR_v.n_bolla, SR_v.n_prog, codref]
    JoinNode(3) [ENHANCED SORT JOIN (SORT/SORT)] [INNER JOIN] criteria=[codop=SR_op.codop] output=[SR_op.codop, SR_v.data, SR_v.n_bolla, SR_v.n_prog, codref, SR_v.quantita, SUM((((support_phy.mediator.referenza.quantita / quantita_reale) * SR_v.quantita) * SR_v.prezzo))]
      GroupingNode(4) output=[codop, SR_v.data, SR_v.n_bolla, SR_v.n_prog, codref, SR_v.quantita, SUM((((support_phy.mediator.referenza.quantita / quantita_reale) * SR_v.quantita) * SR_v.prezzo))] [codop, SR_v.quantita]
        JoinNode(5) [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [INNER JOIN] criteria=[codice=RTRIM(LTRIM(SR_v.codref))] output=[codop, SR_v.quantita, support_phy.mediator.referenza.quantita, quantita_reale, SR_v.prezzo, SR_v.data, SR_v.n_bolla, SR_v.n_prog, codref]
          AccessNode(6) output=[codice, codop, support_phy.mediator.referenza.quantita, quantita_reale, codref] SELECT g_0.codice AS c_0, g_0.codop AS c_1, g_1.quantita AS c_2, g_0.quantita_reale AS c_3, g_0.codref AS c_4 FROM support_phy.mediator.referenza_op AS g_0, support_phy.mediator.referenza AS g_1 WHERE g_0.codref = g_1.codref GROUP BY g_0.codice, g_0.codop, g_0.codref, g_1.quantita, g_0.quantita_reale ORDER BY c_0
          AccessNode(7) output=[SR_v.codref, SR_v.quantita, SR_v.prezzo, SR_v.data, SR_v.n_bolla, SR_v.n_prog, RTRIM(LTRIM(SR_v.codref))] SELECT g_0.codref AS c_0, g_0.quantita AS c_1, g_0.prezzo AS c_2, g_0.data AS c_3, g_0.n_bolla AS c_4, g_0.n_prog AS c_5, RTRIM(LTRIM(g_0.codref)) AS c_6 FROM sole_rugiada_phy.MISURA124.dbo.VENDITA_REFERENZA AS g_0 WHERE g_0.data >= {ts'2009-07-01 00:00:00.0'} ORDER BY c_6
      GroupingNode(8) output=[SR_op.codop] [SR_op.codop]
        ProjectNode(9) output=[SR_op.codop] [X.codop]
          ProjectNode(10) output=[X.codop] [sole_rugiada_log.misura124.solerugiada.op.codop]
            PlanExecutionNode(11) output=[sole_rugiada_log.misura124.solerugiada.op.codop, sole_rugiada_log.misura124.solerugiada.op.nome] 

2011-06-03 14:21:08,540 DEBUG [org.teiid.TXN_LOG] (Worker4_QueryProcessorQueue164) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR)
2011-06-03 14:21:08,540 DEBUG [org.teiid.TXN_LOG] (Worker4_QueryProcessorQueue164) after getOrCreateTransactionContext : QEhfkFyvS0cR NONE ID:NONE
2011-06-03 14:21:08,540 DEBUG [org.teiid.BUFFER_MGR] (Worker4_QueryProcessorQueue164) Creating FileStore: 79
2011-06-03 14:21:08,541 DEBUG [org.teiid.BUFFER_MGR] (Worker4_QueryProcessorQueue164) Creating TupleBuffer: 79 of type  PROCESSOR
2011-06-03 14:21:08,542 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue164) QEhfkFyvS0cR.1.6.9 Create State
2011-06-03 14:21:08,542 DEBUG [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue165) QEhfkFyvS0cR.1.6.9 Processing NEW request: SELECT g_0.codice AS c_0, g_0.codop AS c_1, g_1.quantita AS c_2, g_0.quantita_reale AS c_3, g_0.codref AS c_4 FROM support_phy.mediator.referenza_op AS g_0, support_phy.mediator.referenza AS g_1 WHERE g_0.codref = g_1.codref GROUP BY g_0.codice, g_0.codop, g_0.codref, g_1.quantita, g_0.quantita_reale ORDER BY c_0
2011-06-03 14:21:08,543 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue164) QEhfkFyvS0cR.1.7.10 Create State
2011-06-03 14:21:08,544 DEBUG [org.teiid.BUFFER_MGR] (Worker4_QueryProcessorQueue164) Creating FileStore: 80
2011-06-03 14:21:08,544 DEBUG [org.teiid.BUFFER_MGR] (Worker4_QueryProcessorQueue164) Creating TupleBuffer: 80 of type  PROCESSOR
2011-06-03 14:21:08,544 DEBUG [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue164) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:08,544 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue166) QEhfkFyvS0cR.1.7.10 Processing NEW request: SELECT g_0.codref AS c_0, g_0.quantita AS c_1, g_0.prezzo AS c_2, g_0.data AS c_3, g_0.n_bolla AS c_4, g_0.n_prog AS c_5, RTRIM(LTRIM(g_0.codref)) AS c_6 FROM sole_rugiada_phy.MISURA124.dbo.VENDITA_REFERENZA AS g_0 WHERE g_0.data >= {ts'2009-07-01 00:00:00.0'} ORDER BY c_6
2011-06-03 14:21:08,544 DEBUG [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue165) QEhfkFyvS0cR.1.6.9 Obtained execution
2011-06-03 14:21:08,544 DEBUG [org.teiid.TXN_LOG] (Worker4_QueryProcessorQueue164) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:08,545 DEBUG [org.teiid.TXN_LOG] (Worker4_QueryProcessorQueue164) after suspend : null
2011-06-03 14:21:08,545 DEBUG [org.teiid.COMMAND_LOG] (Worker5_QueryProcessorQueue165) 	START DATA SRC COMMAND:	startTime=2011-06-03 14:21:08.545	requestID=QEhfkFyvS0cR.1	sourceCommandID=6	txID=null	modelName=support_phy	connectorBindingName=mysql5	sessionID=QEhfkFyvS0cR	principal=admin@teiid-security	sql=SELECT g_0.codice AS c_0, g_0.codop AS c_1, g_1.quantita AS c_2, g_0.quantita_reale AS c_3, g_0.codref AS c_4 FROM support_phy.mediator.referenza_op AS g_0, support_phy.mediator.referenza AS g_1 WHERE g_0.codref = g_1.codref GROUP BY g_0.codice, g_0.codop, g_0.codref, g_1.quantita, g_0.quantita_reale ORDER BY c_0
2011-06-03 14:21:08,545 DEBUG [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue165) Source-specific command: SELECT g_0.codice AS c_0, g_0.codop AS c_1, g_1.quantita AS c_2, g_0.quantita_reale AS c_3, g_0.codref AS c_4 FROM referenza_op AS g_0, referenza AS g_1 WHERE g_0.codref = g_1.codref GROUP BY g_0.codice, g_0.codop, g_0.codref, g_1.quantita, g_0.quantita_reale ORDER BY c_0
2011-06-03 14:21:08,546 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue166) QEhfkFyvS0cR.1.7.10 Obtained execution
2011-06-03 14:21:08,546 DEBUG [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue166) 	START DATA SRC COMMAND:	startTime=2011-06-03 14:21:08.546	requestID=QEhfkFyvS0cR.1	sourceCommandID=7	txID=null	modelName=sole_rugiada_phy	connectorBindingName=sqlserver	sessionID=QEhfkFyvS0cR	principal=admin@teiid-security	sql=SELECT g_0.codref AS c_0, g_0.quantita AS c_1, g_0.prezzo AS c_2, g_0.data AS c_3, g_0.n_bolla AS c_4, g_0.n_prog AS c_5, RTRIM(LTRIM(g_0.codref)) AS c_6 FROM sole_rugiada_phy.MISURA124.dbo.VENDITA_REFERENZA AS g_0 WHERE g_0.data >= {ts'2009-07-01 00:00:00.0'} ORDER BY c_6
2011-06-03 14:21:08,546 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue166) Source-specific command: SELECT g_0.codref AS c_0, g_0.quantita AS c_1, g_0.prezzo AS c_2, g_0.data AS c_3, g_0.n_bolla AS c_4, g_0.n_prog AS c_5, rtrim(ltrim(g_0.codref)) AS c_6 FROM VENDITA_REFERENZA g_0 WHERE g_0.data >= ? ORDER BY c_6
2011-06-03 14:21:08,548 DEBUG [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue165) QEhfkFyvS0cR.1.6.9 Executed command
2011-06-03 14:21:08,548 DEBUG [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue165) QEhfkFyvS0cR.1.6.9 Getting results from connector
2011-06-03 14:21:08,548 DEBUG [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue165) QEhfkFyvS0cR.1.6.9 Obtained last batch, total row count: 31
2011-06-03 14:21:08,549 DEBUG [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue167) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:08,549 DEBUG [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue168) QEhfkFyvS0cR.1.6.9 Processing Close : SELECT g_0.codice AS c_0, g_0.codop AS c_1, g_1.quantita AS c_2, g_0.quantita_reale AS c_3, g_0.codref AS c_4 FROM support_phy.mediator.referenza_op AS g_0, support_phy.mediator.referenza AS g_1 WHERE g_0.codref = g_1.codref GROUP BY g_0.codice, g_0.codop, g_0.codref, g_1.quantita, g_0.quantita_reale ORDER BY c_0
2011-06-03 14:21:08,549 DEBUG [org.teiid.BUFFER_MGR] (Worker4_QueryProcessorQueue167) Creating FileStore: 81
2011-06-03 14:21:08,549 DEBUG [org.teiid.COMMAND_LOG] (Worker5_QueryProcessorQueue168) 	END SRC COMMAND:	endTime=2011-06-03 14:21:08.549	requestID=QEhfkFyvS0cR.1	sourceCommandID=6	txID=null	modelName=support_phy	connectorBindingName=mysql5	sessionID=QEhfkFyvS0cR	principal=admin@teiid-security	finalRowCount=31
2011-06-03 14:21:08,550 DEBUG [org.teiid.BUFFER_MGR] (Worker4_QueryProcessorQueue167) Creating TupleBuffer: 81 of type  PROCESSOR
2011-06-03 14:21:08,550 DEBUG [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue168) QEhfkFyvS0cR.1.6.9 Closed execution
2011-06-03 14:21:08,550 DEBUG [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue167) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:08,550 DEBUG [org.teiid.TXN_LOG] (Worker4_QueryProcessorQueue167) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:08,550 DEBUG [org.teiid.TXN_LOG] (Worker4_QueryProcessorQueue167) after suspend : null
2011-06-03 14:21:08,550 DEBUG [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue168) QEhfkFyvS0cR.1.6.9 Remove State
2011-06-03 14:21:08,550 DEBUG [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue168) QEhfkFyvS0cR.1.6.9 Closed connection
2011-06-03 14:21:08,678 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue166) QEhfkFyvS0cR.1.7.10 Executed command
2011-06-03 14:21:08,679 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue166) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:08,936 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue166) QEhfkFyvS0cR.1.7.10 Obtained results from connector, current row count: 1024
2011-06-03 14:21:08,936 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue169) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:08,936 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue170) QEhfkFyvS0cR.1.7.10 Processing MORE request
2011-06-03 14:21:08,937 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue170) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:08,938 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue169) Creating FileStore: 82
2011-06-03 14:21:08,938 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue169) Creating TupleBuffer: 82 of type  PROCESSOR
2011-06-03 14:21:08,939 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue169) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:08,939 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue169) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:08,939 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue169) after suspend : null
2011-06-03 14:21:09,192 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue170) QEhfkFyvS0cR.1.7.10 Obtained results from connector, current row count: 2048
2011-06-03 14:21:09,192 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue171) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:09,193 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue172) QEhfkFyvS0cR.1.7.10 Processing MORE request
2011-06-03 14:21:09,193 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue172) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:09,194 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue171) Creating FileStore: 83
2011-06-03 14:21:09,194 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue171) Creating TupleBuffer: 83 of type  PROCESSOR
2011-06-03 14:21:09,195 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue171) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:09,195 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue171) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:09,195 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue171) after suspend : null
2011-06-03 14:21:09,524 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue172) QEhfkFyvS0cR.1.7.10 Obtained results from connector, current row count: 3072
2011-06-03 14:21:09,524 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue173) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:09,525 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue174) QEhfkFyvS0cR.1.7.10 Processing MORE request
2011-06-03 14:21:09,525 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue174) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:09,526 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue173) Creating FileStore: 84
2011-06-03 14:21:09,526 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue173) Creating TupleBuffer: 84 of type  PROCESSOR
2011-06-03 14:21:09,527 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue173) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:09,527 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue173) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:09,527 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue173) after suspend : null
2011-06-03 14:21:09,796 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue174) QEhfkFyvS0cR.1.7.10 Obtained results from connector, current row count: 4096
2011-06-03 14:21:09,797 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue175) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:09,797 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue176) QEhfkFyvS0cR.1.7.10 Processing MORE request
2011-06-03 14:21:09,797 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue176) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:09,799 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue175) Creating FileStore: 85
2011-06-03 14:21:09,799 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue175) Creating TupleBuffer: 85 of type  PROCESSOR
2011-06-03 14:21:09,799 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue175) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:09,799 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue175) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:09,800 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue175) after suspend : null
2011-06-03 14:21:10,052 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue176) QEhfkFyvS0cR.1.7.10 Obtained results from connector, current row count: 5120
2011-06-03 14:21:10,053 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue177) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:10,053 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue178) QEhfkFyvS0cR.1.7.10 Processing MORE request
2011-06-03 14:21:10,053 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue178) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:10,055 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue177) Creating FileStore: 86
2011-06-03 14:21:10,055 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue177) Creating TupleBuffer: 86 of type  PROCESSOR
2011-06-03 14:21:10,056 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue177) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:10,056 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue177) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:10,056 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue177) after suspend : null
2011-06-03 14:21:10,314 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue178) QEhfkFyvS0cR.1.7.10 Obtained results from connector, current row count: 6144
2011-06-03 14:21:10,314 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue179) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:10,314 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue180) QEhfkFyvS0cR.1.7.10 Processing MORE request
2011-06-03 14:21:10,314 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue180) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:10,316 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue179) Creating FileStore: 87
2011-06-03 14:21:10,316 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue179) Creating TupleBuffer: 87 of type  PROCESSOR
2011-06-03 14:21:10,317 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue179) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:10,317 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue179) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:10,317 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue179) after suspend : null
2011-06-03 14:21:10,620 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue180) QEhfkFyvS0cR.1.7.10 Obtained results from connector, current row count: 7168
2011-06-03 14:21:10,621 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue181) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:10,621 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue182) QEhfkFyvS0cR.1.7.10 Processing MORE request
2011-06-03 14:21:10,621 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue182) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:10,623 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue181) Creating FileStore: 88
2011-06-03 14:21:10,623 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue181) Creating TupleBuffer: 88 of type  PROCESSOR
2011-06-03 14:21:10,624 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue181) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:10,624 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue181) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:10,624 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue181) after suspend : null
2011-06-03 14:21:10,885 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue182) QEhfkFyvS0cR.1.7.10 Obtained results from connector, current row count: 8192
2011-06-03 14:21:10,886 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue183) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:10,886 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue184) QEhfkFyvS0cR.1.7.10 Processing MORE request
2011-06-03 14:21:10,886 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue184) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:10,888 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue183) Creating FileStore: 89
2011-06-03 14:21:10,888 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue183) Creating TupleBuffer: 89 of type  PROCESSOR
2011-06-03 14:21:10,889 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue183) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:10,889 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue183) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:10,889 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue183) after suspend : null
2011-06-03 14:21:11,147 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue184) QEhfkFyvS0cR.1.7.10 Obtained results from connector, current row count: 9216
2011-06-03 14:21:11,148 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue185) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:11,148 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue186) QEhfkFyvS0cR.1.7.10 Processing MORE request
2011-06-03 14:21:11,148 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue186) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:11,150 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue185) Creating FileStore: 90
2011-06-03 14:21:11,150 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue185) Creating TupleBuffer: 90 of type  PROCESSOR
2011-06-03 14:21:11,150 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue185) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:11,150 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue185) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:11,151 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue185) after suspend : null
2011-06-03 14:21:11,510 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue186) QEhfkFyvS0cR.1.7.10 Obtained results from connector, current row count: 10240
2011-06-03 14:21:11,511 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue187) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:11,511 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue188) QEhfkFyvS0cR.1.7.10 Processing MORE request
2011-06-03 14:21:11,511 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue188) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:11,513 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue187) Creating FileStore: 91
2011-06-03 14:21:11,513 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue187) Creating TupleBuffer: 91 of type  PROCESSOR
2011-06-03 14:21:11,513 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue187) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:11,513 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue187) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:11,514 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue187) after suspend : null
2011-06-03 14:21:11,787 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue188) QEhfkFyvS0cR.1.7.10 Obtained results from connector, current row count: 11264
2011-06-03 14:21:11,787 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue189) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:11,788 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue190) QEhfkFyvS0cR.1.7.10 Processing MORE request
2011-06-03 14:21:11,788 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue190) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:11,788 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue189) Creating FileStore: 92
2011-06-03 14:21:11,789 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue189) Creating TupleBuffer: 92 of type  PROCESSOR
2011-06-03 14:21:11,790 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue189) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:11,790 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue189) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:11,790 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue189) after suspend : null
2011-06-03 14:21:12,041 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue190) QEhfkFyvS0cR.1.7.10 Obtained results from connector, current row count: 12288
2011-06-03 14:21:12,041 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue191) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:12,042 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue192) QEhfkFyvS0cR.1.7.10 Processing MORE request
2011-06-03 14:21:12,042 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue192) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:12,043 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue191) Creating FileStore: 93
2011-06-03 14:21:12,044 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue191) Creating TupleBuffer: 93 of type  PROCESSOR
2011-06-03 14:21:12,044 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue191) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:12,044 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue191) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:12,044 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue191) after suspend : null
2011-06-03 14:21:12,297 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue192) QEhfkFyvS0cR.1.7.10 Obtained results from connector, current row count: 13312
2011-06-03 14:21:12,334 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue193) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:12,337 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue193) Creating FileStore: 94
2011-06-03 14:21:12,337 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue193) Creating TupleBuffer: 94 of type  PROCESSOR
2011-06-03 14:21:12,338 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue193) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:12,338 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue193) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:12,338 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue193) after suspend : null
2011-06-03 14:21:12,338 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue194) QEhfkFyvS0cR.1.7.10 Processing MORE request
2011-06-03 14:21:12,338 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue194) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:12,610 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue194) QEhfkFyvS0cR.1.7.10 Obtained results from connector, current row count: 14336
2011-06-03 14:21:12,611 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue195) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:12,612 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue195) Creating FileStore: 95
2011-06-03 14:21:12,612 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue195) Creating TupleBuffer: 95 of type  PROCESSOR
2011-06-03 14:21:12,613 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue195) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:12,613 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue195) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:12,613 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue195) after suspend : null
2011-06-03 14:21:12,613 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue196) QEhfkFyvS0cR.1.7.10 Processing MORE request
2011-06-03 14:21:12,613 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue196) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:12,875 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue196) QEhfkFyvS0cR.1.7.10 Obtained results from connector, current row count: 15360
2011-06-03 14:21:12,875 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue197) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:12,876 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue198) QEhfkFyvS0cR.1.7.10 Processing MORE request
2011-06-03 14:21:12,876 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue198) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:12,877 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue197) Creating FileStore: 96
2011-06-03 14:21:12,878 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue197) Creating TupleBuffer: 96 of type  PROCESSOR
2011-06-03 14:21:12,878 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue197) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:12,878 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue197) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:12,878 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue197) after suspend : null
2011-06-03 14:21:13,122 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue198) QEhfkFyvS0cR.1.7.10 Obtained results from connector, current row count: 16384
2011-06-03 14:21:13,126 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue199) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:13,129 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue199) Creating FileStore: 97
2011-06-03 14:21:13,129 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue199) Creating TupleBuffer: 97 of type  PROCESSOR
2011-06-03 14:21:13,130 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue199) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:13,130 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue199) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:13,130 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue199) after suspend : null
2011-06-03 14:21:13,131 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue200) QEhfkFyvS0cR.1.7.10 Processing MORE request
2011-06-03 14:21:13,131 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue200) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:13,445 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue200) QEhfkFyvS0cR.1.7.10 Obtained results from connector, current row count: 17408
2011-06-03 14:21:13,446 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue201) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:13,446 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue202) QEhfkFyvS0cR.1.7.10 Processing MORE request
2011-06-03 14:21:13,446 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue202) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:13,448 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue201) Creating FileStore: 98
2011-06-03 14:21:13,448 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue201) Creating TupleBuffer: 98 of type  PROCESSOR
2011-06-03 14:21:13,449 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue201) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:13,449 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue201) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:13,449 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue201) after suspend : null
2011-06-03 14:21:13,713 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue202) QEhfkFyvS0cR.1.7.10 Obtained results from connector, current row count: 18432
2011-06-03 14:21:13,713 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue203) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:13,714 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue204) QEhfkFyvS0cR.1.7.10 Processing MORE request
2011-06-03 14:21:13,714 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue204) QEhfkFyvS0cR.1.7.10 Getting results from connector
2011-06-03 14:21:13,715 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue203) Creating FileStore: 99
2011-06-03 14:21:13,715 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue203) Creating TupleBuffer: 99 of type  PROCESSOR
2011-06-03 14:21:13,716 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue203) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:13,716 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue203) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:13,716 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue203) after suspend : null
2011-06-03 14:21:13,772 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue204) QEhfkFyvS0cR.1.7.10 Obtained last batch, total row count: 18717
2011-06-03 14:21:13,772 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue205) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:13,773 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue206) QEhfkFyvS0cR.1.7.10 Processing Close : SELECT g_0.codref AS c_0, g_0.quantita AS c_1, g_0.prezzo AS c_2, g_0.data AS c_3, g_0.n_bolla AS c_4, g_0.n_prog AS c_5, RTRIM(LTRIM(g_0.codref)) AS c_6 FROM sole_rugiada_phy.MISURA124.dbo.VENDITA_REFERENZA AS g_0 WHERE g_0.data >= {ts'2009-07-01 00:00:00.0'} ORDER BY c_6
2011-06-03 14:21:13,773 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 81
2011-06-03 14:21:13,773 DEBUG [org.teiid.COMMAND_LOG] (Worker4_QueryProcessorQueue206) 	END SRC COMMAND:	endTime=2011-06-03 14:21:13.773	requestID=QEhfkFyvS0cR.1	sourceCommandID=7	txID=null	modelName=sole_rugiada_phy	connectorBindingName=sqlserver	sessionID=QEhfkFyvS0cR	principal=admin@teiid-security	finalRowCount=18717
2011-06-03 14:21:13,780 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue206) QEhfkFyvS0cR.1.7.10 Closed execution
2011-06-03 14:21:13,781 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue206) QEhfkFyvS0cR.1.7.10 Remove State
2011-06-03 14:21:13,781 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue206) QEhfkFyvS0cR.1.7.10 Closed connection
2011-06-03 14:21:13,782 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Creating FileStore: 100
2011-06-03 14:21:13,782 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Creating TupleBuffer: 100 of type  PROCESSOR
2011-06-03 14:21:13,782 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Creating FileStore: 101
2011-06-03 14:21:13,782 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Creating TupleBuffer: 101 of type  PROCESSOR
2011-06-03 14:21:13,806 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 82
2011-06-03 14:21:13,806 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 83
2011-06-03 14:21:13,806 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 84
2011-06-03 14:21:13,806 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 85
2011-06-03 14:21:13,806 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 86
2011-06-03 14:21:13,806 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 87
2011-06-03 14:21:13,806 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 88
2011-06-03 14:21:13,806 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 89
2011-06-03 14:21:13,806 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 90
2011-06-03 14:21:13,806 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 91
2011-06-03 14:21:13,806 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 92
2011-06-03 14:21:13,806 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 93
2011-06-03 14:21:13,807 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 94
2011-06-03 14:21:13,807 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 95
2011-06-03 14:21:13,807 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 96
2011-06-03 14:21:13,807 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 97
2011-06-03 14:21:13,807 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 98
2011-06-03 14:21:13,807 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 99
2011-06-03 14:21:13,807 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 100
2011-06-03 14:21:13,829 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Removing TupleBuffer: 101
2011-06-03 14:21:13,829 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Creating FileStore: 102
2011-06-03 14:21:13,829 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue205) Creating TupleBuffer: 102 of type  PROCESSOR
2011-06-03 14:21:13,831 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue205) QEhfkFyvS0cR.1.1.11 Create State
2011-06-03 14:21:13,832 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue205) Request Thread QEhfkFyvS0cR.1 - processor blocked
2011-06-03 14:21:13,832 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue207) QEhfkFyvS0cR.1.1.11 Processing NEW request: SELECT g_0.codop, g_0.nome FROM support_phy.mediator.op AS g_0 WHERE g_0.nome = 'Sole e Rugiada'
2011-06-03 14:21:13,832 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue205) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:13,833 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue205) after suspend : null
2011-06-03 14:21:13,833 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue207) QEhfkFyvS0cR.1.1.11 Obtained execution
2011-06-03 14:21:13,833 DEBUG [org.teiid.COMMAND_LOG] (Worker4_QueryProcessorQueue207) 	START DATA SRC COMMAND:	startTime=2011-06-03 14:21:13.833	requestID=QEhfkFyvS0cR.1	sourceCommandID=1	txID=null	modelName=support_phy	connectorBindingName=mysql5	sessionID=QEhfkFyvS0cR	principal=admin@teiid-security	sql=SELECT g_0.codop, g_0.nome FROM support_phy.mediator.op AS g_0 WHERE g_0.nome = 'Sole e Rugiada'
2011-06-03 14:21:13,833 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue207) Source-specific command: SELECT g_0.codop, g_0.nome FROM op AS g_0 WHERE g_0.nome = ?
2011-06-03 14:21:13,834 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue207) QEhfkFyvS0cR.1.1.11 Executed command
2011-06-03 14:21:13,834 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue207) QEhfkFyvS0cR.1.1.11 Getting results from connector
2011-06-03 14:21:13,835 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue207) QEhfkFyvS0cR.1.1.11 Obtained last batch, total row count: 1
2011-06-03 14:21:13,835 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue208) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:13,835 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue208) QueryProcessor: closing processor
2011-06-03 14:21:13,835 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue209) QEhfkFyvS0cR.1.1.11 Processing Close : SELECT g_0.codop, g_0.nome FROM support_phy.mediator.op AS g_0 WHERE g_0.nome = 'Sole e Rugiada'
2011-06-03 14:21:13,836 DEBUG [org.teiid.COMMAND_LOG] (Worker4_QueryProcessorQueue209) 	END SRC COMMAND:	endTime=2011-06-03 14:21:13.836	requestID=QEhfkFyvS0cR.1	sourceCommandID=1	txID=null	modelName=support_phy	connectorBindingName=mysql5	sessionID=QEhfkFyvS0cR	principal=admin@teiid-security	finalRowCount=1
2011-06-03 14:21:13,836 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue209) QEhfkFyvS0cR.1.1.11 Closed execution
2011-06-03 14:21:13,836 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue209) QEhfkFyvS0cR.1.1.11 Remove State
2011-06-03 14:21:13,836 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue209) QEhfkFyvS0cR.1.1.11 Closed connection
2011-06-03 14:21:13,836 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue208) QueryProcessor: closing processor
2011-06-03 14:21:13,840 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue208) Creating FileStore: 103
2011-06-03 14:21:13,840 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue208) Creating TupleBuffer: 103 of type  PROCESSOR
2011-06-03 14:21:13,840 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue208) Removing TupleBuffer: 103
2011-06-03 14:21:13,840 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue208) Creating FileStore: 104
2011-06-03 14:21:13,840 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue208) Creating FileStore: 105
2011-06-03 14:21:13,840 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue208) Creating STree: 104
2011-06-03 14:21:13,840 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue208) Removing TupleBuffer: 102
2011-06-03 14:21:13,841 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue208) Removing TupleBuffer: 80
2011-06-03 14:21:13,842 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue208) Creating FileStore: 106
2011-06-03 14:21:13,842 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue208) Creating TupleBuffer: 106 of type  PROCESSOR
2011-06-03 14:21:13,842 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue208) Removing TupleBuffer: 106
2011-06-03 14:21:13,842 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue208) QueryProcessor: closing processor
2011-06-03 14:21:13,842 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue208) [RequestWorkItem.sendResultsIfNeeded] requestID: QEhfkFyvS0cR.1 resultsID: 79 done: true
2011-06-03 14:21:13,843 DEBUG [org.teiid.TRANSPORT] (Worker3_QueryProcessorQueue208)  message: MessageHolder: contents=ResultsMessage rowCount=1 finalRow=1 for message:533
2011-06-03 14:21:13,844 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue208) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:13,844 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue208) after suspend : null
2011-06-03 14:21:13,847 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-2) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@68c001cd
2011-06-03 14:21:13,848 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-2)  message: MessageHolder: contents=org.teiid.client.metadata.MetadataResult@15b66f75 for message:534
2011-06-03 14:21:13,852 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-2) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@3b410317
2011-06-03 14:21:13,852 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-2) closeQuery for requestID=QEhfkFyvS0cR.1
2011-06-03 14:21:13,853 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-2)  message: MessageHolder: contents=null for message:535
2011-06-03 14:21:13,853 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue210) Request Thread QEhfkFyvS0cR.1 with state PROCESSING
2011-06-03 14:21:13,853 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue210) Removing tuplesource for the request QEhfkFyvS0cR.1
2011-06-03 14:21:13,853 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue210) Removing TupleBuffer: 79
2011-06-03 14:21:13,853 DEBUG [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue210) 	END USER COMMAND:	endTime=2011-06-03 14:21:13.853	requestID=QEhfkFyvS0cR.1	txID=null	sessionID=QEhfkFyvS0cR	principal=admin@teiid-security	vdbName=misura124	vdbVersion=1	finalRowCount=0
2011-06-03 14:21:13,853 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue210) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@1b7f955b(QEhfkFyvS0cR NONE ID:NONE)
2011-06-03 14:21:13,853 DEBUG [org.teiid.TXN_LOG] (Worker3_QueryProcessorQueue210) after suspend : null
2011-06-03 14:21:25,353 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-2) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@6a65dbc6
2011-06-03 14:21:25,353 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-2)  message: MessageHolder: contents=null for message:84
2011-06-03 14:21:25,404 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-2) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@4aef64f8
2011-06-03 14:21:25,405 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-2) Keep-alive ping received for session: XoUR3VIVBeY0
2011-06-03 14:21:25,405 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-2)  message: MessageHolder: contents=null for message:85