• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Liutauras Vilda
  • Jeanne Boyarsky
  • paul wheaton
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Henry Wong
Saloon Keepers:
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Tim Moores
  • Mikalai Zaikin
Bartenders:
  • Frits Walraven

this error often appears

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.readChannelFully(MysqlIO.java:2854) at com.mysql.jdbc.MysqlIO.reuseAndReadViaChannel(MysqlIO.java:2917) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2280) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2496) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1443) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1533) at com.mysql.jdbc.Connection.execSQL(Connection.java:2270) at com.mysql.jdbc.Connection.execSQL(Connection.java:2202) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1777) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1622) at net.jforum.drivers.generic.UserModel.selectById(UserModel.java:73) at net.jforum.JForum.checkCookies(JForum.java:389) at net.jforum.JForum.service(JForum.java:489) 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 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.catalina.connector.warp.WarpRequestHandler.handle(WarpRequestHandler.java:218) at org.apache.catalina.connector.warp.WarpConnection.run(WarpConnection.java:194) at java.lang.Thread.run(Thread.java:534) ** END NESTED

[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I use Apache,tomcat and mysql, when restart tomcat this error disappeared, but after some time (maybe half an hour or less) it appears ag
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Expression session is undefined on line 71, column 30 in default/forum_base.htm. The problematic instruction: ---------- ==> if session.isAdmin() [on line 71, column 25 in default/forum_base.htm] in include "default/forum_base.htm" [on line 2, column 1 in exception.html] ---------- Java backtrace for programmers: ---------- freemarker.core.InvalidReferenceException: Expression session is undefined on line 71, column 30 in default/forum_base.htm. at freemarker.core.TemplateObject.assertNonNull(TemplateObject.java:124) at freemarker.core.TemplateObject.invalidTypeException(TemplateObject.java:134) at freemarker.core.Dot._getAsTemplateModel(Dot.java:78) at freemarker.core.Expression.getAsTemplateModel(Expression.java:89) at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:86) at freemarker.core.Expression.getAsTemplateModel(Expression.java:89) at freemarker.core.Expression.isTrue(Expression.java:138) at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:77) at freemarker.core.Environment.visit(Environment.java:171) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:171) at freemarker.core.Environment.include(Environment.java:1256) at freemarker.core.Include.accept(Include.java:156) at freemarker.core.Environment.visit(Environment.java:171) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:171) at freemarker.core.Environment.process(Environment.java:156) at freemarker.template.Template.process(Template.java:219) at net.jforum.ForumException.(ForumException.java:81) at net.jforum.JForum.service(JForum.java:529) 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 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.catalina.connector.warp.WarpRequestHandler.handle(WarpRequestHandler.java:218) at org.apache.catalina.connector.warp.WarpConnection.run(WarpConnection.java:194) at java.lang.Thread.run(Thread.java:534)
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Anonymous wrote:I use Apache,tomcat and mysql, when restart tomcat this error disappeared, but after some time (maybe half an hour or less) it appears ag



Maybe you can provide some info on the version number of the a/m.
[originally posted on jforum.net by jamesyong]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Anonymous wrote:I use Apache,tomcat and mysql, when restart tomcat this error disappeared, but after some time (maybe half an hour or less) it appears ag



Yeah, I'm concerned about this problem. I don't get it so frequently, but I know that it occurs.

Are you using RC4? As Far As I Know ( and as far I can remember ) this error does not occur with the stable version of mysql's connector/j ( 3.0.4 ). You can try getting it from www.mysql.com and make some tests.

I've been using the alpha / beta driver because some issues with cyrillic chars.
Anyway, I'll try to make some more tests with the stable driver.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I get the same error too. I have to restart it every day.

Linux
MySQL
Tomcat 5
MysQL connector/J 3.0.14 stable


J-R
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm debugging the connection pool in search for bugs..

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

I'm a jForum newbie. This appears to be the first bug I'm encountering. It happens whenever there is a lack of activity for more than a couple of hours. Here's my setup:

Windows XP
MySQL 4.0.20
Tomcat 5.0.25
JForum 1.0 - RC4

Hope to see this sorted out soon. Thanks!
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Anonymous wrote:Hi,

I'm a jForum newbie. This appears to be the first bug I'm encountering. It happens whenever there is a lack of activity for more than a couple of hours. Here's my setup:

Windows XP
MySQL 4.0.20
Tomcat 5.0.25
JForum 1.0 - RC4

Hope to see this sorted out soon. Thanks!



Please take a look at

http://www.jforum.net/jira/browse/JF-57#action_10101

It would be nice if you can do that test.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Alright, thanks. I'll try that asap.

'Stanley

Rafael Steil wrote:

Anonymous wrote:Hi,

I'm a jForum newbie. This appears to be the first bug I'm encountering. It happens whenever there is a lack of activity for more than a couple of hours. Here's my setup:

Windows XP
MySQL 4.0.20
Tomcat 5.0.25
JForum 1.0 - RC4

Hope to see this sorted out soon. Thanks!



Please take a look at

http://www.jforum.net/jira/browse/JF-57#action_10101

It would be nice if you can do that test.

Rafael


[originally posted on jforum.net by stanleyshyeoh]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Its been more than 24 hours since I've applied the patch. The problem appears to be solved. Thanks.
[originally posted on jforum.net by stanleyshyeoh]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

stanleyshyeoh wrote:Its been more than 24 hours since I've applied the patch. The problem appears to be solved. Thanks.



That's great to hear. Just confirm one thing: did you put the call to enableConnectionPinging() somewhere? I didn't mention that, but it is necessary to activate the code ( just to confirm )

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Realised I didn't put enablePinging() but I recompiled with the enablePinging().

I have tested it for more than 48 hours with idle intervals of a few hours. And no problems whatsoever.

Thanks, Rafael.
[originally posted on jforum.net by stanleyshyeoh]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
When can I expect a new release containing a the fix for this problem?

Thanks,

J-R
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
RC5... no date defined yet, but hope that soon

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Rafael Steil wrote:Please take a look at

http://www.jforum.net/jira/browse/JF-57#action_10101

It would be nice if you can do that test.

Rafael


Just to say that I am also running into the same problem. So I am testing the above mentioned solution. Running with Linux & Resin.

Regards,
James Yong
[originally posted on jforum.net by jamesyong]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hmm..it don't seems to help in my case. The error occurs less than half an hour later, even with the new code.

Btw, I am deploying the forum in a server of which I have no access to restart the JVM. What I did was to delete the class folder and change the web.xml, so that Resin can detect the changes and reloads again.

Should I shorten the time for the enableConnectionPinging()?

Regards,
James Yong
[originally posted on jforum.net by jamesyong]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

jamesyong wrote:

Should I shorten the time for the enableConnectionPinging()?

Regards,
James Yong



You can give a try. Put it to ping each 20 / 30 min.

( btw, which mysql and connector/j are you using? )

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Ok, I'll probably work on it at a later time
[originally posted on jforum.net by jamesyong]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Rafael Steil wrote:
You can give a try. Put it to ping each 20 / 30 min.

( btw, which mysql and connector/j are you using? )

Rafael


Thanks, I will work on it and see what I can do.

The requested info are:
mysql: 4.0.20-standard
connector/j: 3.0.14-production
[originally posted on jforum.net by jamesyong]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

I change the ping time to be 2 minute. Haven't tried other values yet. But now, I don't see this error.

Regards,
James Yong
[originally posted on jforum.net by jamesyong]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

jamesyong wrote:Hi,

I change the ping time to be 2 minute. Haven't tried other values yet. But now, I don't see this error.

Regards,
James Yong



This is a very very short ping time. James, remember be to make some tests using the same connector/j's version your ISP uses. I want to check if, when using newer versions of connector/j, this ping() method is / or is not still necessary.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Anonymous wrote:I am trying to install the same patch. Forgive me, I'm no java expert.



Hi,

I'll release the next jforum's version soon, which have this pacth.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am trying to install the same patch. Forgive me, I'm no java expert. When I added the code and tried to compile ConnectionPool.java, I got

What am I missing?

TIA!
Chris
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Rafael Steil wrote:

Anonymous wrote:I am trying to install the same patch. Forgive me, I'm no java expert.



Hi,

I'll release the next jforum's version soon, which have this pacth.

Rafael



[originally posted on jforum.net by jamesyong]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
oops! I realized I hadn't logged in to ask the last question.

I've got it down to one error.

I added the code at the end of ConnectionPool.java. What gives?

Anybody? I'm *really* tired of having to restart tomcat every few hours. It's becoming a drag. I don't want to wait for the next release since no date has been defined. Soon rarely means soon. No offense. :P

TIA!
Chris
[originally posted on jforum.net by cbock]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

cbock wrote: I don't want to wait for the next release since no date has been defined. Soon rarely means soon. No offense. :P

TIA!
Chris


It will probably be released next weekend as mentioned by Rafael in another post.

Regards.

[originally posted on jforum.net by jamesyong]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Oops, still got the JDBC connection timeout problem with RC5 .

The connection timeout setting in MySQL (4.0.15) is 28800 secs (8 hours).
The database.ping.delay setiing in file SystemGlobal.properties is 3600000 msecs (1 hour).

What else should I check?

After a few hours of inactivity I get:

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.readChannelFully(MysqlIO.java:2854)
at com.mysql.jdbc.MysqlIO.reuseAndReadViaChannel(MysqlIO.java:2917)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2280)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2496)



Jean-Robert
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hhmm.. check the log files for "pinging connections... " ( somethjing like that ). I output this message when the timertask runs..

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Rafael Steil wrote:hhmm.. check the log files for "pinging connections... " ( somethjing like that ). I output this message when the timertask runs..

Rafael



I have the above mentioned problem as well. Here's what I see in my log.


[originally posted on jforum.net by cbock]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hu, crapy...

Well, that's not good :evil:

While I check why the pingConnections() is not working, please use net.jforum.SimpleConnection. You can change it by updating the key database.connection.implementation at WEB-INF/config/SystemGloals.properites ( a restart in the context is needed ).

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Well, I have done some modifications to PooledConnection to try fix the problems.

Please see that is much more an experiment than a real solution. Now, instead of just using the connections on each ping iteration, I close them an open new ones.

Please get the file

https://jforum.dev.java.net/files/documents/411/6830/PooledConnection.class

and put it at WEB-INF/classes/net/jforum. Is is recommended to create a backup of the current existing PooledConnection.class.

Don't forget to restart the container context, and give feedback if this solution works or not.

Thanks for all your suggestions so far.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
i wasn't sure if you wanted us to try both of the above mentioned fixes. i didn't think so after reading your second post. so, i only replaced PooledConnection.class. i'll report back, probably tomorrow.

one other thing i forgot to mention in my last post. if i reload the page 3 or 4 times after i see the error, the connection is successful. :?
[originally posted on jforum.net by cbock]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

cbock wrote:
one other thing i forgot to mention in my last post. if i reload the page 3 or 4 times after i see the error, the connection is successful. :?



That's happen because the pool will getting the connection, realizing that they are invalid, discarding the connection, then opening a new and putting it in the pool.

The original implementation should work - actually, it did for many users -, and I don't know exactly why, even with the ping thing, it still breaks. It may be related to some specific version of mysql or OS. If I can have this kind of information, it may help to find the problem.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
here's my specs

os: gentoo linux 2.6.5 r1
mysql: 4.0.20-r1
tomcat: 5.0.27-r4
[originally posted on jforum.net by cbock]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
looks like that may have done the trick. longest my forum's gone w/out a connection. i'll report back again in a few days.

thanks rafael!
[originally posted on jforum.net by cbock]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
things have been going better. no dropped connection after extended periods of inactivity.

i don't know if it's jforum. but, i've got lots of java process left hanging that's filling up my swap space. i didn't have a problem like this before i started using jforum. :? i've got to investigate further.
[originally posted on jforum.net by cbock]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

cbock wrote:things have been going better. no dropped connection after extended periods of inactivity.



That's really great to hear!!

cbock wrote:
i don't know if it's jforum. but, i've got lots of java process left hanging that's filling up my swap space. i didn't have a problem like this before i started using jforum. :? i've got to investigate further.



and not so great this one. But I've been watching jforum.net server processes, and there are some strange things apparently.

I *guess* that the problem may be located in the threading system - eg, the one responsible for sending emails, currently. There is also a very little prorablility of problems with ThreadLocals, but I'm not sure.

If you want, you can take a look at net.jforum.util.concurrent, and the classes who use it. I'll try to start looking better too.

Thanks.
Rafael
[originally posted on jforum.net by Rafael Steil]
 
I brought this back from the farm where they grow the tiny ads:
Gift giving made easy with the permaculture playing cards
https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing
reply
    Bookmark Topic Watch Topic
  • New Topic