jfroum idle cause freemarker to die...

[Migrated From Jforum.net]

I've been having this trouble with latest code base

log in to jforum, don't exit leave sit for 4 or 5 hours close browser

Open new browers got to jforum

get all these exceptions

Expression templateName is undefined on line 5, column 14 in exception.html. The problematic instruction: ---------- ==> ${templateName} [on line 5, column 12 in exception.html] in include "${templateName}/message.htm" [on line 5, column 1 in exception.html] ---------- Java backtrace for programmers: ---------- freemarker.core.InvalidReferenceException: Expression templateName is undefined on line 5, column 14 in exception.html. at freemarker.core.TemplateObject.assertNonNull(TemplateObject.java:124) at freemarker.core.Expression.getStringValue(Expression.java:118) at freemarker.core.Expression.getStringValue(Expression.java:93) at freemarker.core.DollarVariable.accept(DollarVariable.java:76) at freemarker.core.Environment.visit(Environment.java:196) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:196) at freemarker.core.Environment.renderElementToString(Environment.java:1461) at freemarker.core.StringLiteral.getStringValue(StringLiteral.java:95) at freemarker.core.Include.accept(Include.java:110) at freemarker.core.Environment.visit(Environment.java:196) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:196) at freemarker.core.Environment.process(Environment.java:176) at freemarker.template.Template.process(Template.java:231) at net.jforum.exceptions.ExceptionWriter.handleExceptionData(ExceptionWriter.java:108) at net.jforum.JForum.service(JForum.java:218) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:263) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:360) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:604) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:562) at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:679) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:534)

go back forwad a couple times and it starts working again....

I've been track this bug all this week as I got reports that is was happeneing.....

any ideas? I have every cache setting I know of turned off....


[originally posted on jforum.net by mqjoe1]

[Migrated From Jforum.net]

I have the same problem on low traffic forum: same error message and reloading the page one or more times fix the problem.

No idea ...
[originally posted on jforum.net by fgaillard]

[Migrated From Jforum.net]

With database, version, and connection type (Simple / Pooled / DataSource etc ) are you guys using?

"latest code base" is 2.1.5, right?

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Database version:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 30073 to server version: 4.1.12-standard-log


cvs from yesterday

here's all the db settings from my jforum-custom file

dao.driver=net.jforum.dao.mysql.MysqlDataAccessDriver
database.connection.dbname=jforum
database.connection.driver=com.mysql.jdbc.Driver
database.connection.host=mqsd02
database.connection.implementation=net.jforum.PooledConnection
database.connection.password=xxxxxxxx
database.connection.pool.max=10
database.connection.pool.min=5
database.connection.pool.timeout=5000
database.connection.port=3351
database.connection.string=jdbc\:mysql\://${database.connection.host}
\:${database.connection.port}/${database.connection.dbname}?user\=
${database.connection.username}
&password\=${database.connection.password}
&autoReconnect\=true${mysql.unicode}${mysql.encoding}
&useNewIO\=false&zeroDateTimeBehavior\=convertToNull
&useServerPrepStmts\=false
database.connection.username=mqmgr
database.driver.name=mysql
database.support.autokeys=true
database.support.subqueries=false
dateTime.format=MM/dd/yyyy HH\:mm\:ss
dbencoding=iso-8859-1
dbunicode=true

[originally posted on jforum.net by mqjoe1]

[Migrated From Jforum.net]

PS

I was running code from 01/05/2006 that exhibited the problem as well.

So I updated the last code base a week ago updating each day and the problem still exists.

[originally posted on jforum.net by mqjoe1]

[Migrated From Jforum.net]

Ok, I'll check.

For now, try changing the connection type to net.jforum.SimpleConnection .. maybe the pool is the problem

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

It's indeed a problem with the connection pool. The mysql breaks connection after X time idle.
You can solve this by changing the following parameter in the configuration file:
database.ping.delay=<time in seconds>
[originally posted on jforum.net by mortis__rigor]

[Migrated From Jforum.net]

I had this problem also with pooled connection and switched to container managed datasource with connection pools and have not seen the problem since. I am using JForum 2.1.15 Tomcat 5.5.15 and MySQL 4.1.12.
[originally posted on jforum.net by parisila]

[Migrated From Jforum.net]

<BLOCKQUOTE>
It's indeed a problem with the connection pool. The mysql breaks connection after X time idle.
You can solve this by changing the following parameter in the configuration file:
database.ping.delay=<time in seconds>
</BLOCKQUOTE>

I'm getting this problem too. What config file did you touch, and what value should I set for <time in seconds>?
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Change WEB-INF/config/SystemGlobals.properties

Also, take a look in the file jforum-custom.conf (same dir). If there is the key there, change as well

Rafael
[originally posted on jforum.net by Rafael Steil]