Hi Stefan,
sadly this isn't the first time the issue was brought up and afaik
it's a problem with MySQL themselves and their view on connection
pooling. More info:
http://article.gmane.org/gmane.comp.java.rife.user/1434
We don't use MySQL in production and rely pretty much on PostgreSQL
and Oracle, where no problems appear wrt at all. RIFE doesn't do
anything that JDBC doesn't allow you. I really would like to find a
way to once and for all find a workaround for this issue. I vaguely
remember that Keith switched to PostgreSQL though.
Nice to hear that RIFE is working out for you besides that and I hope
this can be ironed out.
Best regards,
Geert
On 29 May 2006, at 12:09, Stefan Thomas wrote:
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
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 1.4 © 2001-2006 by Uwyn bvba/sprl
_______________________________________________
Rife-users mailing list
[email protected]
http://lists.uwyn.com/mailman/listinfo/rife-users
--
Geert Bevin
Uwyn "Use what you need" - http://uwyn.com
RIFE Java application framework - http://rifers.org
Music and words - http://gbevin.com
_______________________________________________
Rife-users mailing list
[email protected]
http://lists.uwyn.com/mailman/listinfo/rife-users
