Hi, 
This is a follow-on... similar testing I've now seen the set of exceptions 
below. Is there some configuration of JBoss/MySQL that I'm missing?

It's quite difficult to reliably replicate the problem at a known point, but I 
am seeing these errors and the ones in the previous posting happen on a regular 
basis. Any help/suggestions would be really appreciated.

The other question I suppose I should ask is whether people have experienced 
these sorts of issues either with JBoss4.2.x/JBossMQ combination or with 
JBoss4.2.x/JBM1.4.2


Thanks,
Joseph.


  | 13:54:48,442 WARN  [JDBCSupport] SQLException caught, SQLState HY000 
code:1296- assuming deadlock detected, try:1
  | java.sql.SQLException: Got error 4010 'Node failure caused abort of 
transaction' from NDB
  |         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
  |         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
  |         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
  |         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
  |         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
  |         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
  |         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
  |         at 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
  |         at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2046)
  |         at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964)
  |         at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949)
  |         at 
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
  |         at 
org.jboss.messaging.core.impl.JDBCPersistenceManager.cacheID(JDBCPersistenceManager.java:1637)
  |         at 
org.jboss.messaging.core.impl.JDBCPersistenceManager$1AddReferenceRunner.doTransaction(JDBCPersistenceManager.java:1370)
  |         at 
org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner2.execute(JDBCSupport.java:474)
  |         at 
org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner2.executeWithRetry(JDBCSupport.java:512)
  |         at 
org.jboss.messaging.core.impl.JDBCPersistenceManager.addReference(JDBCPersistenceManager.java:1408)
  |         at 
org.jboss.messaging.core.impl.ChannelSupport.handle(ChannelSupport.java:226)
  |         at 
org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.routeInternal(MessagingPostOffice.java:2212)
  |         at 
org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.route(MessagingPostOffice.java:499)
  |         at 
org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendMessage(ServerConnectionEndpoint.java:755)
  |         at 
org.jboss.jms.server.endpoint.ServerSessionEndpoint.send(ServerSessionEndpoint.java:397)
  |         at 
org.jboss.jms.server.endpoint.advised.SessionAdvised.org$jboss$jms$server$endpoint$advised$SessionAdvised$send$aop(SessionAdvised.java:87)
  |         at 
org.jboss.jms.server.endpoint.advised.SessionAdvised$send_7280680627620114891.invokeTarget(SessionAdvised$send_7280680627620114891.java)
  |         at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)
  |         at 
org.jboss.jms.server.container.SecurityAspect.handleSend(SecurityAspect.java:157)
  |         at sun.reflect.GeneratedMethodAccessor281.invoke(Unknown Source)
  |         at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  |         at java.lang.reflect.Method.invoke(Method.java:597)
  |         at 
org.jboss.aop.advice.PerInstanceAdvice.invoke(PerInstanceAdvice.java:122)
  |         at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  |         at 
org.jboss.jms.server.endpoint.advised.SessionAdvised.send(SessionAdvised.java)
  |         at 
org.jboss.jms.wireformat.SessionSendRequest.serverInvoke(SessionSendRequest.java:95)
  |         at 
org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke(JMSServerInvocationHandler.java:143)
  |         at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:908)
  |         at 
org.jboss.remoting.transport.socket.ServerThread.completeInvocation(ServerThread.java:742)
  |         at 
org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:695)
  |         at 
org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:549)
  |         at 
org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:230)
  | 13:54:48,444 WARN  [JDBCSupport] Trying again after a pause
  | 13:54:48,525 WARN  [TxConnectionManager] Connection error occured: 
org.jboss.resource.connectionmanager.txconnectionmanager$txconnectioneventliste...@9eb61a[state=normal
 mc=org.jboss.resource.adapter.jdbc.local.localmanagedconnect...@1323140 
handles=1 lastUse=1233928488441 permit=true trackByTx=false 
mcp=org.jboss.resource.connectionmanager.jbossmanagedconnectionpool$onep...@3f9de3
 
context=org.jboss.resource.connectionmanager.internalmanagedconnectionp...@96a235
 
xaresource=org.jboss.resource.connectionmanager.txconnectionmanager$localxaresou...@1c58721
 txSync=null]
  | java.sql.SQLException: Can't lock file (errno: 157)
  |         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
  |         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
  |         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
  |         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
  |         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
  |         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
  |         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
  |         at 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
  |         at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2046)
  |         at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964)
  |         at 
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949)
  |         at 
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
  |         at 
org.jboss.messaging.core.impl.JDBCPersistenceManager$1AddReferenceRunner.doTransaction(JDBCPersistenceManager.java:1343)
  |         at 
org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner2.execute(JDBCSupport.java:474)
  |         at 
org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner2.executeWithRetry(JDBCSupport.java:512)
  |         at 
org.jboss.messaging.core.impl.JDBCPersistenceManager.addReference(JDBCPersistenceManager.java:1408)
  |         at 
org.jboss.messaging.core.impl.ChannelSupport.handle(ChannelSupport.java:226)
  |         at 
org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.routeInternal(MessagingPostOffice.java:2212)
  |         at 
org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.route(MessagingPostOffice.java:499)
  |         at 
org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendMessage(ServerConnectionEndpoint.java:755)
  |         at 
org.jboss.jms.server.endpoint.ServerSessionEndpoint.send(ServerSessionEndpoint.java:397)
  |         at 
org.jboss.jms.server.endpoint.advised.SessionAdvised.org$jboss$jms$server$endpoint$advised$SessionAdvised$send$aop(SessionAdvised.java:87)
  |         at 
org.jboss.jms.server.endpoint.advised.SessionAdvised$send_7280680627620114891.invokeTarget(SessionAdvised$send_7280680627620114891.java)
  |         at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)
  |         at 
org.jboss.jms.server.container.SecurityAspect.handleSend(SecurityAspect.java:157)
  |         at sun.reflect.GeneratedMethodAccessor281.invoke(Unknown Source)
  |         at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  |         at java.lang.reflect.Method.invoke(Method.java:597)
  |         at 
org.jboss.aop.advice.PerInstanceAdvice.invoke(PerInstanceAdvice.java:122)
  |         at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  |         at 
org.jboss.jms.server.endpoint.advised.SessionAdvised.send(SessionAdvised.java)
  |         at 
org.jboss.jms.wireformat.SessionSendRequest.serverInvoke(SessionSendRequest.java:95)
  |         at 
org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke(JMSServerInvocationHandler.java:143)
  |         at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:908)
  |         at 
org.jboss.remoting.transport.socket.ServerThread.completeInvocation(ServerThread.java:742)
  |         at 
org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:695)
  |         at 
org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:549)
  |         at 
org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:230)
  | 

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4207718#4207718

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4207718
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to