ORMException in liferay 5.2.3

[14年前 に z z z によって更新されました。]

i use liferay 5.2.3 and tomcat-5.5 and mysql 5
when i want to save more than one wiki pages synchronizly this error occurs and i see "Wiki is temporarily unavailable"


09:05:53,974 ERROR [JDBCExceptionReporter:101] Lock wait timeout exceeded; try restarting transaction
09:05:54,180 ERROR [jsp:165] com.liferay.portal.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: Could not execute JDBC batch update
at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:91)
at com.liferay.portlet.wiki.service.persistence.WikiNodePersistenceImpl.updateImpl(WikiNodePersistenceImpl.java:350)
at com.liferay.portlet.wiki.service.persistence.WikiNodePersistenceImpl.update(WikiNodePersistenceImpl.java:313)
at com.liferay.portlet.wiki.service.impl.WikiPageLocalServiceImpl.addPage(WikiPageLocalServiceImpl.java:180)
at com.liferay.portlet.wiki.service.impl.WikiPageServiceImpl.addPage(WikiPageServiceImpl.java:104)
at com.liferay.portlet.wiki.service.WikiPageServiceUtil.addPage(WikiPageServiceUtil.java:66)
at com.liferay.portlet.wiki.action.EditPageAction.updatePage(EditPageAction.java:312)
at com.liferay.portlet.wiki.action.EditPageAction.processAction(EditPageAction.java:83)
at com.liferay.portal.struts.PortletRequestProcessor.process(PortletRequestProcessor.java:180)
at com.liferay.portlet.StrutsPortlet.processAction(StrutsPortlet.java:197)
at com.sun.portal.portletcontainer.appengine.filter.FilterChainImpl.doFilter(FilterChainImpl.java:98)
at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:57)
at com.liferay.portlet.InvokerPortletImpl.invoke(InvokerPortletImpl.java:632)
at com.liferay.portlet.InvokerPortletImpl.invokeAction(InvokerPortletImpl.java:664)
at com.liferay.portlet.InvokerPortletImpl.processAction(InvokerPortletImpl.java:359)
at com.liferay.portal.action.LayoutAction.processPortletRequest(LayoutAction.java:604)
at com.liferay.portal.action.LayoutAction.processLayout(LayoutAction.java:428)
at com.liferay.portal.action.LayoutAction.execute(LayoutAction.java:195)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)

help me plz

[14年前 に Shepherd Ching によって更新されました。]

You are using Innodb storage engine of MySQL. You need to increase value of variable "innodb_lock_wait_timeout"

Reference:
http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html#sysvar_innodb_lock_wait_timeout

[14年前 に z z z によって更新されました。]

My problem not resolved

i have this problem in other satate!

07:31:49,375 ERROR [JDBCExceptionReporter:101] Lock wait timeout exceeded; try restarting transaction
07:31:49,499 ERROR [jsp:165] com.liferay.portal.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: Could not execute JDBC batch update
at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:91)
at com.liferay.portlet.messageboards.service.persistence.MBCategoryPersistenceImpl.updateImpl(MBCategoryPersistenceImpl.java:349)
at com.liferay.portlet.messageboards.service.persistence.MBCategoryPersistenceImpl.update(MBCategoryPersistenceImpl.java:312)
at com.liferay.portlet.messageboards.service.impl.MBThreadLocalServiceImpl.deleteThread(MBThreadLocalServiceImpl.java:147)
at com.liferay.portlet.messageboards.service.impl.MBThreadLocalServiceImpl.deleteThread(MBThreadLocalServiceImpl.java:61)
at com.liferay.portlet.messageboards.service.impl.MBMessageLocalServiceImpl.deleteDiscussionMessages(MBMessageLocalServiceImpl.java:560)
at com.liferay.portal.service.impl.LayoutLocalServiceImpl.deleteLayout(LayoutLocalServiceImpl.java:267)
at com.liferay.portal.service.impl.LayoutLocalServiceImpl.deleteLayout(LayoutLocalServiceImpl.java:233)
at com.liferay.portal.service.impl.LayoutServiceImpl.deleteLayout(LayoutServiceImpl.java:111)
at com.liferay.portal.service.LayoutServiceUtil.deleteLayout(LayoutServiceUtil.java:83)
at com.liferay.portlet.communities.util.CommunitiesUtil.deleteLayout(CommunitiesUtil.java:139)
at com.liferay.portlet.communities.util.CommunitiesUtil.deleteLayout(CommunitiesUtil.java:69)
at com.liferay.portlet.communities.action.EditPagesAction.processAction(EditPagesAction.java:135)
at com.liferay.portal.struts.PortletRequestProcessor.process(PortletRequestProcessor.java:180)
at com.liferay.portlet.StrutsPortlet.processAction(StrutsPortlet.java:197)
at com.sun.portal.portletcontainer.appengine.filter.FilterChainImpl.doFilter(FilterChainImpl.java:98)
at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:57)
at com.liferay.portlet.InvokerPortletImpl.invoke(InvokerPortletImpl.java:632)
at com.liferay.portlet.InvokerPortletImpl.invokeAction(InvokerPortletImpl.java:664)
at com.liferay.portlet.InvokerPortletImpl.processAction(InvokerPortletImpl.java:359)

[14年前 に Lisa Simpson によって更新されました。]

Try restarting MySQL. You seem to have some sort of a table lock going.

[14年前 に z z z によって更新されました。]

i restart mysql but my problem exist!
i have to restart tomcat every day
any help?

[14年前 に Lisa Simpson によって更新されました。]

Go edit your my.cnf and change your thread concurrency from the default to at least 25. See if that helps at all.

[14年前 に z z z によって更新されました。]

i set innodb_thread_concurrency=25 in my.cnf file but i see that error yet!
any other help

[12年前 に Krati Gupta によって更新されました。]

Hi All,

We are also facing the same issue and due to which our Message Board stop working as when we click on any thread the thread is not opening and it showing the below error :

com.mchange.v2.c3p0.impl.NewPooledConnection -- WARN -- [c3p0] A PooledConnection that has already signalled a Connection error is still in use!
com.mchange.v2.c3p0.impl.NewPooledConnection -- WARN -- [c3p0] Another error has occurred [ com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:


** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: recv failed

STACKTRACE:

java.net.SocketException: Software caused connection abort: recv failed
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1994)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2411)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2916)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3250)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3179)
at com.mysql.jdbc.Statement.execute(Statement.java:714)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
at com.liferay.counter.service.persistence.ConnectionHeartbeatJob.sendHeartbeat(ConnectionHeartbeatJob.java:75)
at com.liferay.counter.service.persistence.ConnectionHeartbeatJob.execute(ConnectionHeartbeatJob.java:52)
at com.liferay.portal.job.JobWrapper.execute(JobWrapper.java:69)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)


** END NESTED EXCEPTION **



Last packet sent to the server was 18937 ms ago.

STACKTRACE:

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: recv failed

STACKTRACE:

java.net.SocketException: Software caused connection abort: recv failed
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1994)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2411)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2916)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3250)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3179)
at com.mysql.jdbc.Statement.execute(Statement.java:714)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
at com.liferay.counter.service.persistence.ConnectionHeartbeatJob.sendHeartbeat(ConnectionHeartbeatJob.java:75)
at com.liferay.counter.service.persistence.ConnectionHeartbeatJob.execute(ConnectionHeartbeatJob.java:52)
at com.liferay.portal.job.JobWrapper.execute(JobWrapper.java:69)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)


** END NESTED EXCEPTION **



Last packet sent to the server was 18937 ms ago.
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2622)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2916)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3250)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3179)
at com.mysql.jdbc.Statement.execute(Statement.java:714)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
at com.liferay.counter.service.persistence.ConnectionHeartbeatJob.sendHeartbeat(ConnectionHeartbeatJob.java:75)
at com.liferay.counter.service.persistence.ConnectionHeartbeatJob.execute(ConnectionHeartbeatJob.java:52)
at com.liferay.portal.job.JobWrapper.execute(JobWrapper.java:69)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)


** END NESTED EXCEPTION **

] which will not be reported to listeners!
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:


** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: recv failed


Please help how to fix this problem .

[9年前 に Kalai arasan によって更新されました。]

H! I increased the value of variable "innodb_lock_wait_timeout", but again i am facing the same problem!.

[13年前 に Ananth Mohan Kancherla によって更新されました。]

We are getting the following exception during the startup, when I restart the server this exception is not see again. Can some explain what could be the reason and a solution for the same ? We are using NDC cluster for the same.

18:54:49,710 ERROR [JDBCExceptionReporter:101] Lock wait timeout exceeded; try restarting transaction
18:54:49,743 INFO [HookHotDeployListener:268] Registering hook for message_board-hook-5.2.7.1
18:54:49,761 ERROR [IncludeTag:89] Current URL /web/guest generates exception: com.liferay.portal.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
18:54:49,772 ERROR [IncludeTag:165] com.liferay.portal.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:122)
at com.liferay.portlet.tags.service.persistence.TagsAssetPersistenceImpl.updateImpl(TagsAssetPersistenceImpl.java:292)
at com.liferay.portlet.tags.service.persistence.TagsAssetPersistenceImpl.updateImpl(TagsAssetPersistenceImpl.java:83)
at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.update(BasePersistenceImpl.java:188)
at com.liferay.portlet.tags.service.impl.TagsAssetLocalServiceImpl.incrementViewCounter(TagsAssetLocalServiceImpl.java:332)
at com.liferay.portal.spring.aop.ServiceHookAdvice.invoke(ServiceHookAdvice.java:90)
at com.liferay.portlet.tags.service.TagsAssetLocalServiceUtil.incrementViewCounter(TagsAssetLocalServiceUtil.java:282)
at org.apache.jsp.html.portlet.journal_005fcontent.view_jsp._jspService(view_jsp.java:654)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472)
at com.liferay.taglib.util.IncludeTag.doEndTag(IncludeTag.java:77)
Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:40)
at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:121)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.liferay.portal.kernel.bean.ContextClassLoaderBeanHandler.invoke(ContextClassLoaderBeanHandler.java:57)
at $Proxy209.flush(Unknown Source)