Railo3.1 MySQL5.1.34

Sana

unread,

May 8, 2009, 4:30:10 AM5/8/09

to Railo

Hi,

I have database setup problem with mysql5.1.34 on centos 64 bit. Even
though I have updated mysql connector to latest version but still
getting this error.

"Communications link failure. Last packet sent to the server was 0 ms
ago."

Looking forward to your help.

Thanks

Gert Franz

unread,

May 8, 2009, 4:33:05 AM5/8/09

to ra...@googlegroups.com

It was I suppose a problem in the MySQL driver. Can you use the one Railo
provides? Check our mailing list there was a message about this a couple of
weeks ago...

Gert

-----Ursprüngliche Nachricht-----
Von: ra...@googlegroups.com [mailto:ra...@googlegroups.com] Im Auftrag von
Sana
Gesendet: Freitag, 8. Mai 2009 10:30
An: Railo
Betreff: [railo] Railo3.1 MySQL5.1.34

Sana

unread,

May 8, 2009, 5:44:05 AM5/8/09

to Railo

Hi Gert

I am using Railo provided mysql connector, still having same
connection issue.

"Communications link failure. Last packet sent to the server was 0 ms
ago."

Can you please point me which message you are talking about .

Thanks

Sana

unread,

May 8, 2009, 5:53:44 AM5/8/09

to Railo

HERE IS FULL ERROR MESSAGE
---------
Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.ConnectException
MESSAGE: Connection refused

STACKTRACE:

java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:519)
at java.net.Socket.connect(Socket.java:469)
at java.net.Socket.(Socket.java:366)
at java.net.Socket.(Socket.java:209)
at com.mysql.jdbc.StandardSocketFactory.connect
(StandardSocketFactory.java:173)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:268)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2745)
at com.mysql.jdbc.Connection.(Connection.java:1553)
at com.mysql.jdbc.NonRegisteringDriver.connect
(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at railo.runtime.tag.Admin.getConnection(Admin.java:1874)
at railo.runtime.tag.Admin._doVerifyDatasource(Admin.java:1856)
at railo.runtime.tag.Admin._doVerifyDatasource(Admin.java:1846)
at railo.runtime.tag.Admin.doUpdateDatasource(Admin.java:1673)
at railo.runtime.tag.Admin._doStartTag(Admin.java:482)
at railo.runtime.tag.Admin.doStartTag(Admin.java:249)
at admin.services_datasource_create_cfm1334$cf.call(/Users/mic/
Projects/Railo/webroot/context31/admin/services.datasource.create.cfm:
57)
at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:597)
at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:578)
at admin.services_datasource_cfm414$cf.call(/Users/mic/Projects/Railo/
webroot/context31/admin/services.datasource.cfm:76)
at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:597)
at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:578)
at admin.web_cfm$cf.call(/Users/mic/Projects/Railo/webroot/context31/
admin/web.cfm:173)
at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:597)
at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:578)
at admin.server_cfm$cf.call(/Users/mic/Projects/Railo/webroot/
context31/admin/server.cfm:5)
at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:597)
at railo.runtime.listener.ModernAppListener._onRequest
(ModernAppListener.java:109)
at railo.runtime.listener.MixedAppListener.onRequest
(MixedAppListener.java:23)
at railo.runtime.PageContextImpl.execute(PageContextImpl.java:1638)
at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:
235)
at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:91)
at com.caucho.server.dispatch.ServletFilterChain.doFilter
(ServletFilterChain.java:103)
at com.caucho.server.webapp.WebAppFilterChain.doFilter
(WebAppFilterChain.java:175)
at com.caucho.server.dispatch.ServletInvocation.service
(ServletInvocation.java:240)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:
263)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:481)
at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:685)
at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:607)
at java.lang.Thread.run(Thread.java:619)

** END NESTED EXCEPTION **

Last packet sent to the server was 1 ms ago.

Gert Franz

unread,

May 8, 2009, 5:53:57 AM5/8/09

to ra...@googlegroups.com

Sana,

Ist from April 13th:

http://groups.google.com/group/railo/browse_thread/thread/e4ee389cb2acbc77/d
ebf964b29d45432?hl=en-~----------~----~----~----~------~----~------~--~&lnk=
gst&q=Last+packet+sent+to+the+server+was+0+ms+ago.%22#debf964b29d45432.
There it states:

it had to do with these mysql variables:

<quote>

wait_timeout
interactive_timeout
net_write_timeout
net_read_timeout

my wait_timout,net_read_timeouts, net_write_timeouts were too low at
30seconds.

Some analysis queries were taking about 45 seconds and mysql closed
the connection whereas the jdbc driver was still assuming it was
opened.

increased those values to 60 resolved the issue.

Btw, if anyone is running linux based mysql's, I highly recommend
the
ourdelta.org builds.

</quote>

Greetings from Switzerland
Gert Franz

Railo Technologies Professional Open Source
skype: gert.franz ge...@getrailo.com
+41 76 5680 231 www.getrailo.ch

-----Ursprüngliche Nachricht-----
Von: ra...@googlegroups.com [mailto:ra...@googlegroups.com] Im Auftrag von
Sana

Gesendet: Freitag, 8. Mai 2009 11:44
An: Railo
Betreff: [railo] Re: Railo3.1 MySQL5.1.34

Sana

unread,

May 8, 2009, 9:05:57 AM5/8/09

to Railo

Thanks Gert,

we had problem with connection, its solved now.

Thanks

On May 8, 10:53 am, "Gert Franz" <gert.fr...@railo.ch> wrote:
> Sana,
>
> Ist from April 13th:
>

> http://groups.google.com/group/railo/browse_thread/thread/e4ee389cb2a...

> ebf964b29d45432?hl=en-~----------~----~----~----~------~----~------~--~&lnk=
> gst&q=Last+packet+sent+to+the+server+was+0+ms+ago.%22#debf964b29d45432.
> There it states:
>
> it had to do with these mysql variables:
>
> <quote>
>
> wait_timeout
> interactive_timeout
> net_write_timeout
> net_read_timeout
>
> my wait_timout,net_read_timeouts, net_write_timeouts were too low at
> 30seconds.
>
> Some analysis queries were taking about 45 seconds and mysql closed
> the connection whereas the jdbc driver was still assuming it was
> opened.
>
> increased those values to 60 resolved the issue.
>
> Btw, if anyone is running linux based mysql's, I highly recommend
> the
> ourdelta.org builds.
>
> </quote>
>
> Greetings from Switzerland
> Gert Franz
>
> Railo Technologies Professional Open Source

> skype: gert.franz g...@getrailo.com
> +41 76 5680 231www.getrailo.ch

melinite

unread,

May 10, 2009, 6:17:48 PM5/10/09

to Railo

If you need anymore pointers for Railo MySQL stability let me know.
I had ran into some frustrating problems a while back, and have fixed
most I believe :)

On 5월8일, 오전9시05분, Sana <sanaulla...@gmail.com> wrote:
> Thanks Gert,
>
> we had problem with connection, its solved now.
>
> Thanks
>
> On May 8, 10:53 am, "Gert Franz" <gert.fr...@railo.ch> wrote:
>
>
>
> > Sana,
>
> > Ist from April 13th:
>
> >http://groups.google.com/group/railo/browse_thread/thread/e4ee389cb2a...

> > ebf964b29d45432?hl=en-~----------~----~----~----~------~----~------~--~&lnk=

Reply all

Reply to author

Forward