[Rife-users] Strange MySQL-Problem w/ RIFE/Crud

Mon, 29 May 2006 03:10:02 -0700 

Hi guys,
just to give you a short update on what happened since my last Mail to this list: The decision was made to use PHP for the frontend and RIFE/Crud for the administration interface. Both are almost ready now, but there's a bug in the admin interface we can't get rid of.
The error message is attached. This problem occurs only after Tomcat has been running for awhile. A restart fixes this problem temporarily. Basically looks like RIFE is trying to keep some connection alive, while MySQL times out.
Please note, that we currently still use RIFE 1.4, so sorry if this is fixed in 1.5.
Another thing: Personally, I've really fallen in love with RIFE. The frontend will soon be ported to RIFE, also and will then be released as an OpenSource Online Shop. First Pre-Release is scheduled somewhere in the late third quarter 2006 if everything goes well. And someone has asked me to write a book on RIFE and OpenLaszlo, so I'll think about that, too. 


Best Regards,

Stefan Thomas
Title: Uwyn RIFE - errors occurred
Uwyn RIFE
Errors occurred while processing the request.
com.uwyn.rife.database.exceptions.TransactionBeginErrorException

Error while beginning the transaction.

at  com.uwyn.rife.database.DbConnection    beginTransaction   ( DbConnection.java : 892 )
at  com.uwyn.rife.database.DbQueryManager    inTransaction   ( DbQueryManager.java : 2780 )
at  com.uwyn.rife.crud.elements.admin.Browse    processElement   ( Browse.java : 55 )
at  com.uwyn.rife.engine.ElementContext    processContext   ( ElementContext.java : 587 )
at  com.uwyn.rife.engine.RequestState    service   ( RequestState.java : 217 )
at  com.uwyn.rife.engine.Gate    handleRequest   ( Gate.java : 416 )
at  sun.reflect.GeneratedMethodAccessor23    invoke   ( <unknown> )
at  sun.reflect.DelegatingMethodAccessorImpl    invoke   ( DelegatingMethodAccessorImpl.java : 25 )
at  java.lang.reflect.Method    invoke   ( Method.java : 585 )
at  com.uwyn.rife.servlet.RifeFilter    doFilter   ( RifeFilter.java : 127 )
at  org.apache.catalina.core.ApplicationFilterChain    internalDoFilter   ( ApplicationFilterChain.java : 202 )
at  org.apache.catalina.core.ApplicationFilterChain    doFilter   ( ApplicationFilterChain.java : 173 )
at  org.apache.catalina.core.StandardWrapperValve    invoke   ( StandardWrapperValve.java : 214 )
at  org.apache.catalina.core.StandardValveContext    invokeNext   ( StandardValveContext.java : 104 )
at  org.apache.catalina.core.StandardPipeline    invoke   ( StandardPipeline.java : 520 )
at  org.apache.catalina.core.StandardContextValve    invokeInternal   ( StandardContextValve.java : 198 )
at  org.apache.catalina.core.StandardContextValve    invoke   ( StandardContextValve.java : 152 )
17 more ...

com.mysql.jdbc.CommunicationsException

Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2988) at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913) at com.uwyn.rife.database.DbConnection.beginTransaction(DbConnection.java:882) at com.uwyn.rife.database.DbQueryManager.inTransaction(DbQueryManager.java:2780) at com.uwyn.rife.crud.elements.admin.Browse.processElement(Browse.java:55) at com.uwyn.rife.engine.ElementContext.processContext(ElementContext.java:587) at com.uwyn.rife.engine.RequestState.service(RequestState.java:217) at com.uwyn.rife.engine.Gate.handleRequest(Gate.java:416) at sun.reflect.GeneratedMethodAccessor23.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.uwyn.rife.servlet.RifeFilter.doFilter(RifeFilter.java:127) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) ** END NESTED EXCEPTION ** Last packet sent to the server was 2 ms ago.

at  com.mysql.jdbc.MysqlIO    reuseAndReadPacket   ( MysqlIO.java : 2563 )
at  com.mysql.jdbc.MysqlIO    checkErrorPacket   ( MysqlIO.java : 2862 )
at  com.mysql.jdbc.MysqlIO    sendCommand   ( MysqlIO.java : 1571 )
at  com.mysql.jdbc.MysqlIO    sqlQueryDirect   ( MysqlIO.java : 1666 )
at  com.mysql.jdbc.Connection    execSQL   ( Connection.java : 2988 )
at  com.mysql.jdbc.Connection    setAutoCommit   ( Connection.java : 4913 )
at  com.uwyn.rife.database.DbConnection    beginTransaction   ( DbConnection.java : 882 )
at  com.uwyn.rife.database.DbQueryManager    inTransaction   ( DbQueryManager.java : 2780 )
at  com.uwyn.rife.crud.elements.admin.Browse    processElement   ( Browse.java : 55 )
at  com.uwyn.rife.engine.ElementContext    processContext   ( ElementContext.java : 587 )
at  com.uwyn.rife.engine.RequestState    service   ( RequestState.java : 217 )
at  com.uwyn.rife.engine.Gate    handleRequest   ( Gate.java : 416 )
at  sun.reflect.GeneratedMethodAccessor23    invoke   ( <unknown> )
at  sun.reflect.DelegatingMethodAccessorImpl    invoke   ( DelegatingMethodAccessorImpl.java : 25 )
at  java.lang.reflect.Method    invoke   ( Method.java : 585 )
at  com.uwyn.rife.servlet.RifeFilter    doFilter   ( RifeFilter.java : 127 )
at  org.apache.catalina.core.ApplicationFilterChain    internalDoFilter   ( ApplicationFilterChain.java : 202 )
23 more ...
 

_______________________________________________
Rife-users mailing list
[email protected]
http://lists.uwyn.com/mailman/listinfo/rife-users

Reply via email to