API tools faq
paste
Advertisement
Guest User

teiid log

a guest
Jun 17th, 2017
44
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.37 KB | None | 0 0
raw download clone embed print report
  1. 2017-06-17 11:24:17,463 INFO [org.teiid.COMMAND_LOG] (NIO2) YjTVjiUAxdBW START USER COMMAND: startTime=2017-06-17 11:24:17.463 requestID=YjTVjiUAxdBW.2 txID=null sessionID=YjTVjiUAxdBW applicationName=JDBCprincipal=teiid vdbName=users vdbVersion=1 sql=delete from users where id = 203
  2. 2017-06-17 11:24:17,517 DEBUG [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue33) YjTVjiUAxdBW START DATA SRC COMMAND: startTime=2017-06-17 11:24:17.517 requestID=YjTVjiUAxdBW.2 sourceCommandID=1 executionID=22 txID=TransactionImple < ac, BasicAction: 0:ffffac110004:-2216b982:594160fd:3a59 status: ActionStatus.RUNNING > modelName=db1 translatorName=mysql5 sessionID=YjTVjiUAxdBW principal=teiid sql=SELECT MAX(g_0.id) FROM db1.user1 AS g_0
  3. 2017-06-17 11:24:17,518 DEBUG [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue33) YjTVjiUAxdBW SOURCE SRC COMMAND: endTime=2017-06-17 11:24:17.518 requestID=YjTVjiUAxdBW.2 sourceCommandID=1 executionID=22 txID=TransactionImple < ac, BasicAction: 0:ffffac110004:-2216b982:594160fd:3a59 status: ActionStatus.RUNNING > modelName=db1 translatorName=mysql5 sessionID=YjTVjiUAxdBW principal=teiid sourceCommand=[SELECT MAX(g_0.`id`) FROM `db1`.`user1` AS g_0]
  4. 2017-06-17 11:24:17,524 DEBUG [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue33) YjTVjiUAxdBW END SRC COMMAND: endTime=2017-06-17 11:24:17.523 requestID=YjTVjiUAxdBW.2 sourceCommandID=1 executionID=22 txID=TransactionImple < ac, BasicAction: 0:ffffac110004:-2216b982:594160fd:3a59 status: ActionStatus.RUNNING > modelName=db1 translatorName=mysql5 sessionID=YjTVjiUAxdBW principal=teiid finalRowCount=1 cpuTime(ns)=2229752
  5. 2017-06-17 11:24:17,528 DEBUG [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue33) YjTVjiUAxdBW START DATA SRC COMMAND: startTime=2017-06-17 11:24:17.527 requestID=YjTVjiUAxdBW.2 sourceCommandID=5 executionID=21 txID=TransactionImple < ac, BasicAction: 0:ffffac110004:-2216b982:594160fd:3a59 status: ActionStatus.RUNNING > modelName=db1 translatorName=mysql5 sessionID=YjTVjiUAxdBW principal=teiid sql=SELECT g_0.id, g_0.dummy_data, g_0.created_at, g_0.updated_at FROM db1.user1 AS g_0 WHERE g_0.id = 203
  6. 2017-06-17 11:24:17,532 DEBUG [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue33) YjTVjiUAxdBW SOURCE SRC COMMAND: endTime=2017-06-17 11:24:17.532 requestID=YjTVjiUAxdBW.2 sourceCommandID=5 executionID=21 txID=TransactionImple < ac, BasicAction: 0:ffffac110004:-2216b982:594160fd:3a59 status: ActionStatus.RUNNING > modelName=db1 translatorName=mysql5 sessionID=YjTVjiUAxdBW principal=teiid sourceCommand=[SELECT g_0.`id`, g_0.`dummy_data`, g_0.`created_at`, g_0.`updated_at` FROM `db1`.`user1` AS g_0 WHERE g_0.`id` = 203]
  7. 2017-06-17 11:24:17,533 DEBUG [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue33) YjTVjiUAxdBW END SRC COMMAND: endTime=2017-06-17 11:24:17.533 requestID=YjTVjiUAxdBW.2 sourceCommandID=5 executionID=21 txID=TransactionImple < ac, BasicAction: 0:ffffac110004:-2216b982:594160fd:3a59 status: ActionStatus.RUNNING > modelName=db1 translatorName=mysql5 sessionID=YjTVjiUAxdBW principal=teiid finalRowCount=0 cpuTime(ns)=2071060
  8. 2017-06-17 11:24:17,535 WARN [com.arjuna.ats.arjuna] (Worker3_QueryProcessorQueue33) YjTVjiUAxdBW ARJUNA012140: Adding multiple last resources is disallowed. Trying to add LastResourceRecord(XAOnePhaseResource(LocalXAResourceImpl@10cb6e39[connectionListener=3c7490ef connectionManager=f1c1fe4 warned=false currentXid=< formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffac110004:-2216b982:594160fd:3a59, node_name=1, branch_uid=0:ffffac110004:-2216b982:594160fd:3a5c, subordinatenodename=null, eis_name=java:/db2-ds > productName=MySQL productVersion=10.1.22-MariaDB-1~jessie jndiName=java:/db2-ds])), but already have LastResourceRecord(XAOnePhaseResource(LocalXAResourceImpl@768c78ba[connectionListener=279e3472 connectionManager=509876c3 warned=false currentXid=< formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffac110004:-2216b982:594160fd:3a59, node_name=1, branch_uid=0:ffffac110004:-2216b982:594160fd:3a5b, subordinatenodename=null, eis_name=java:/db1-ds > productName=MySQL productVersion=10.1.22-MariaDB-1~jessie jndiName=java:/db1-ds]))
  9. 2017-06-17 11:24:17,539 DEBUG [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue33) YjTVjiUAxdBW ERROR SRC COMMAND: endTime=2017-06-17 11:24:17.539 requestID=YjTVjiUAxdBW.2 sourceCommandID=6 executionID=23 txID=TransactionImple < ac, BasicAction: 0:ffffac110004:-2216b982:594160fd:3a59 status: ActionStatus.ABORT_ONLY > modelName=db2 translatorName=mysql5 sessionID=YjTVjiUAxdBW principal=teiid
  10. 2017-06-17 11:24:17,540 WARN [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue33) YjTVjiUAxdBW Connector worker process failed for atomic-request=YjTVjiUAxdBW.2.6.23: org.teiid.translator.TranslatorException: TEIID11009 java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@3c7490ef[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@16a4b953 connection handles=0 lastReturned=1497698657538 lastValidated=1497698349672 lastCheckedOut=1497698657534 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@5d55b718 mcp=SemaphoreConcurrentLinkedQueueManagedConnectionPool@5b009b67[pool=db2DS] xaResource=LocalXAResourceImpl@10cb6e39[connectionListener=3c7490ef connectionManager=f1c1fe4 warned=false currentXid=null productName=MySQL productVersion=10.1.22-MariaDB-1~jessie jndiName=java:/db2-ds] txSync=null]
  11. at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:282)
  12. at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:69)
  13. at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:205)
  14. at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:329)
  15. at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
  16. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  17. at java.lang.reflect.Method.invoke(Method.java:498)
  18. at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:220)
  19. at com.sun.proxy.$Proxy30.execute(Unknown Source)
  20. at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
  21. at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:142)
  22. at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:394)
  23. at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281)
  24. at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:147)
  25. at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281)
  26. at org.teiid.query.processor.relational.SelectNode.nextBatchDirect(SelectNode.java:104)
  27. at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281)
  28. at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150)
  29. at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281)
  30. at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
  31. at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
  32. at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
  33. at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:94)
  34. at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:120)
  35. at org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
  36. at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281)
  37. at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150)
  38. at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281)
  39. at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
  40. at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
  41. at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
  42. at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
  43. at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
  44. at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:477)
  45. at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:349)
  46. at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
  47. at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:275)
  48. at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
  49. at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
  50. at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
  51. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  52. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  53. at java.lang.Thread.run(Thread.java:748)
  54. Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@3c7490ef[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@16a4b953 connection handles=0 lastReturned=1497698657538 lastValidated=1497698349672 lastCheckedOut=1497698657534 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@5d55b718 mcp=SemaphoreConcurrentLinkedQueueManagedConnectionPool@5b009b67[pool=db2DS] xaResource=LocalXAResourceImpl@10cb6e39[connectionListener=3c7490ef connectionManager=f1c1fe4 warned=false currentXid=null productName=MySQL productVersion=10.1.22-MariaDB-1~jessie jndiName=java:/db2-ds] txSync=null]
  55. at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:146)
  56. at org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:66)
  57. at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:278)
  58. ... 42 more
  59. Caused by: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@3c7490ef[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@16a4b953 connection handles=0 lastReturned=1497698657538 lastValidated=1497698349672 lastCheckedOut=1497698657534 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@5d55b718 mcp=SemaphoreConcurrentLinkedQueueManagedConnectionPool@5b009b67[pool=db2DS] xaResource=LocalXAResourceImpl@10cb6e39[connectionListener=3c7490ef connectionManager=f1c1fe4 warned=false currentXid=null productName=MySQL productVersion=10.1.22-MariaDB-1~jessie jndiName=java:/db2-ds] txSync=null]
  60. at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:933)
  61. at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:750)
  62. at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:138)
  63. ... 44 more
  64. Caused by: javax.resource.ResourceException: IJ000461: Could not enlist in transaction on entering meta-aware object
  65. at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:560)
  66. at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:928)
  67. ... 46 more
  68. Caused by: javax.transaction.SystemException: IJ000356: Failed to enlist: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: 0:ffffac110004:-2216b982:594160fd:3a59 status: ActionStatus.ABORT_ONLY >
  69. at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener$TransactionSynchronization.checkEnlisted(TxConnectionListener.java:942)
  70. at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:394)
  71. at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:553)
  72. ... 47 more
  73.  
  74. 2017-06-17 11:24:17,552 DEBUG [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue33) YjTVjiUAxdBW END SRC COMMAND: endTime=2017-06-17 11:24:17.552 requestID=YjTVjiUAxdBW.2 sourceCommandID=6 executionID=23 txID=TransactionImple < ac, BasicAction: 0:ffffac110004:-2216b982:594160fd:3a59 status: ActionStatus.ABORT_ONLY > modelName=db2 translatorName=mysql5 sessionID=YjTVjiUAxdBW principal=teiid finalRowCount=0 cpuTime(ns)=6324843
  75. 2017-06-17 11:24:17,555 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue33) YjTVjiUAxdBW ERROR USER COMMAND: endTime=2017-06-17 11:24:17.555 requestID=YjTVjiUAxdBW.2 txID=null sessionID=YjTVjiUAxdBW principal=teiid vdbName=users vdbVersion=1 finalRowCount=null
  76. 2017-06-17 11:24:17,556 WARN [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue33) YjTVjiUAxdBW TEIID30020 Processing exception for request YjTVjiUAxdBW.2 'TEIID30504 db2: TEIID11009 java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@3c7490ef[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@16a4b953 connection handles=0 lastReturned=1497698657538 lastValidated=1497698349672 lastCheckedOut=1497698657534 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@5d55b718 mcp=SemaphoreConcurrentLinkedQueueManagedConnectionPool@5b009b67[pool=db2DS] xaResource=LocalXAResourceImpl@10cb6e39[connectionListener=3c7490ef connectionManager=f1c1fe4 warned=false currentXid=null productName=MySQL productVersion=10.1.22-MariaDB-1~jessie jndiName=java:/db2-ds] txSync=null]'. Originally TeiidProcessingException 'IJ000356: Failed to enlist: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: 0:ffffac110004:-2216b982:594160fd:3a59 status: ActionStatus.ABORT_ONLY >' TxConnectionListener.java:942. Enable more detailed logging to see the entire stacktrace.
  77. 2017-06-17 11:24:17,559 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue33) YjTVjiUAxdBW END USER COMMAND: endTime=2017-06-17 11:24:17.559 requestID=YjTVjiUAxdBW.2 txID=null sessionID=YjTVjiUAxdBW principal=teiid vdbName=users vdbVersion=1 finalRowCount=0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!