FAQ Search Today's Posts Mark Forums Read
» Video Reviews

» Linux Archive

Linux-archive is a website aiming to archive linux email lists and to make them easily accessible for linux users/developers.


» Sponsor

» Partners

» Sponsor

Go Back   Linux Archive > Redhat > Fedora User

 
 
LinkBack Thread Tools
 
Old 02-15-2008, 01:39 PM
 
Default mysql JDBC tomcat

*Perhaps there is a mysql group I could ask?* But I will ask here anyway.

Someone is using java and tomcat and mysql.* Accessing mysql on 10.0.0.66
from 10.10.0.2.* They are pingable from each other but go through gateway
10.10.0.30.

And mysql -h 10.0.0.66*
from 10.10.0.2 returns a prompt after a while.

However using jdbc times out even with a timeout of 70000.* Here is the command:


jdbc:mysql://10.0.0.66/dma_oam?useUnicode=true&characterEncoding=Big5&soc ketTimeout=700000&connectTimeout=700000** id
(id omitted from this message for security reasons)

This is being executed from Java.

And to repeat, when it was used before there were 1 hop from server machine to host machine (like here):
traceroute to 10.0.0.50 (10.0.0.50), 30 hops max, 38 byte packets
*1* 10.0.0.50 (10.0.0.50)* 1.158 ms* 0.198 ms* 0.186 ms
but in this case there are two
traceroute to 10.0.0.66 (10.0.0.66), 30 hops max, 38 byte packets
*1* 10.10.0.30 (10.10.0.30)* 20.068 ms* 19.775 ms* 19.806 ms
*2* 10.0.0.66 (10.0.0.66)* 24.404 ms* 23.240 ms* 23.249 ms


Could this be the reason for the timeout?* Can jdbc not hop?


if you are interested, here is a stack backtrace

java.net.SocketTimeoutException: Read timed out
******* at java.net.SocketInputStream.socketRead0(Native Method)
******* at java.net.SocketInputStream.read(SocketInputStream. java:129)
******* at java.io.BufferedInputStream.fill(BufferedInputStre am.java:218)
******* at java.io.BufferedInputStream.read1(BufferedInputStr eam.java:258)
******* at java.io.BufferedInputStream.read(BufferedInputStre am.java:317)
******* at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1316 )
******* at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:1463)
******* at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:1854)
******* at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:11 09)
******* at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1203)
******* at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1164)
******* at com.mysql.jdbc.Connection.execSQL(Connection.java: 2087)
******* at com.mysql.jdbc.Connection.execSQL(Connection.java: 2037)
******* at com.mysql.jdbc.Statement.executeQuery(Statement.ja va:1156)
******* at com.mysql.jdbc.Connection.initializePropsFromServe r(Connection.java:2753)
******* at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:1671)
******* at com.mysql.jdbc.Connection.<init>(Connection.java:4 32)



--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
 
Old 02-15-2008, 01:56 PM
Robert L Cochran
 
Default mysql JDBC tomcat

The Fedora 8 implementation of tomcat5 and jetty has a major bug: both
tomcat5 and jetty, as packaged by the providers, use the same port by
default. Usually jetty is started up before tomcat5, and this guarantees
that tomcat5, by default, will break because jetty is listening on that
same port. To fix the problem, you need to edit /etc/tomcat5/server.xml
and change the default connector port number.

Why does Fedora 8 include jetty? Because Fedora Eclipse needs it.

The default implementations of tomcat5 and jetty need to change to so
that they use different port numbers of both these packages are being
installed.

I don't know if this has any bearing on your problem -- on the surface
of it, doesn't seem so -- but I wanted to mention this.

Bob Cochran
Greenbelt, Maryland, USA

tony.chamberlain@lemko.com wrote:
>
> Perhaps there is a mysql group I could ask? But I will ask here anyway.
>
> Someone is using java and tomcat and mysql. Accessing mysql on 10.0.0.66
> from 10.10.0.2. They are pingable from each other but go through gateway
> 10.10.0.30.
>
> And mysql -h 10.0.0.66
> from 10.10.0.2 returns a prompt after a while.
>
> However using jdbc times out even with a timeout of 70000. Here is
> the command:
>
>
> jdbc:mysql://10.0.0.66/dma_oam?useUnicode=true&characterEncoding=Big5&soc ketTimeout=700000&connectTimeout=700000
> id
> (id omitted from this message for security reasons)
>
> This is being executed from Java.
>
> And to repeat, when it was used before there were 1 hop from server
> machine to host machine (like here):
>
> traceroute to 10.0.0.50 (10.0.0.50), 30 hops max, 38 byte packets
> 1 10.0.0.50 (10.0.0.50) 1.158 ms 0.198 ms 0.186 ms
>
> but in this case there are two
>
> traceroute to 10.0.0.66 (10.0.0.66), 30 hops max, 38 byte packets
> 1 10.10.0.30 (10.10.0.30) 20.068 ms 19.775 ms 19.806 ms
> 2 10.0.0.66 (10.0.0.66) 24.404 ms 23.240 ms 23.249 ms
>
>
>
> Could this be the reason for the timeout? Can jdbc not hop?
>
>
> if you are interested, here is a stack backtrace
>
> java.net.SocketTimeoutException: Read timed out
> at java.net.SocketInputStream.socketRead0(Native Method)
> at java.net.SocketInputStream.read(SocketInputStream. java:129)
> at java.io.BufferedInputStream.fill(BufferedInputStre am.java:218)
> at java.io.BufferedInputStream.read1(BufferedInputStr eam.java:258)
> at java.io.BufferedInputStream.read(BufferedInputStre am.java:317)
> at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1316 )
> at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:1463)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:1854)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:11 09)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1203)
> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1164)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 2087)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 2037)
> at com.mysql.jdbc.Statement.executeQuery(Statement.ja va:1156)
> at
> com.mysql.jdbc.Connection.initializePropsFromServe r(Connection.java:2753)
> at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:1671)
> at com.mysql.jdbc.Connection.<init>(Connection.java:4 32)
>
>

--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
 
Old 02-15-2008, 02:55 PM
 
Default mysql JDBC tomcat

Yeah we are using CentOS and I don't know if jetty is running anyway.
The customer played around with routing and it seems to work OK now.
Must have been some random thing?

On a completely other note, you can see below the original message.
WHy is the formatting all screwed up?* User to work fine.


-----Original Message-----
From: fedora-list-request@redhat.com [mailto:fedora-list-request@redhat.com]
Sent: Friday, February 15, 2008 09:06 AM
To: fedora-list@redhat.com
Subject: fedora-list Digest, Vol 48, Issue 122

*------------------------------

Message: 8
Date: Fri, 15 Feb 2008 09:56:04 -0500
From: Robert L Cochran
Subject: Re: mysql JDBC tomcat
To: For users of Fedora
Message-ID: <47B5A804.5070708@speakeasy.net>
Content-Type: text/plain; charset=ISO-8859-1

The Fedora 8 implementation of tomcat5 and jetty has a major bug: both
tomcat5 and jetty, as packaged by the providers, use the same port by
default. Usually jetty is started up before tomcat5, and this guarantees
that tomcat5, by default, will break because jetty is listening on that
same port. To fix the problem, you need to edit /etc/tomcat5/server.xml
and change the default connector port number.

Why does Fedora 8 include jetty? Because Fedora Eclipse needs it.

The default implementations of tomcat5 and jetty need to change to so
that they use different port numbers of both these packages are being
installed.

I don't know if this has any bearing on your problem -- on the surface
of it, doesn't seem so -- but I wanted to mention this.

Bob Cochran
Greenbelt, Maryland, USA

tony.chamberlain@lemko.com wrote:
>
> Perhaps there is a mysql group I could ask? But I will ask here anyway.
>
> Someone is using java and tomcat and mysql. Accessing mysql on 10.0.0.66
> from 10.10.0.2. They are pingable from each other but go through gateway
> 10.10.0.30.
>
> And mysql -h 10.0.0.66
> from 10.10.0.2 returns a prompt after a while.
>
> However using jdbc times out even with a timeout of 70000. Here is
> the command:
>
>
> jdbc:mysql://10.0.0.66/dma_oam?useUnicode=true&characterEncoding=Big5&soc ketTimeout=700000&connectTimeout=700000
> id
> (id omitted from this message for security reasons)
>
> This is being executed from Java.
>
> And to repeat, when it was used before there were 1 hop from server
> machine to host machine (like here):
>
> traceroute to 10.0.0.50 (10.0.0.50), 30 hops max, 38 byte packets
> 1 10.0.0.50 (10.0.0.50) 1.158 ms 0.198 ms 0.186 ms
>
> but in this case there are two
>
> traceroute to 10.0.0.66 (10.0.0.66), 30 hops max, 38 byte packets
> 1 10.10.0.30 (10.10.0.30) 20.068 ms 19.775 ms 19.806 ms
> 2 10.0.0.66 (10.0.0.66) 24.404 ms 23.240 ms 23.249 ms
>
>
>
> Could this be the reason for the timeout? Can jdbc not hop?
>
>
> if you are interested, here is a stack backtrace
>
> java.net.SocketTimeoutException: Read timed out
> at java.net.SocketInputStream.socketRead0(Native Method)
> at java.net.SocketInputStream.read(SocketInputStream. java:129)
> at java.io.BufferedInputStream.fill(BufferedInputStre am.java:218)
> at java.io.BufferedInputStream.read1(BufferedInputStr eam.java:258)
> at java.io.BufferedInputStream.read(BufferedInputStre am.java:317)
> at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1316 )
> at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:1463)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:1854)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:11 09)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1203)
> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1164)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 2087)
> at com.mysql.jdbc.Connection.execSQL(Connection.java: 2037)
> at com.mysql.jdbc.Statement.executeQuery(Statement.ja va:1156)
> at
> com.mysql.jdbc.Connection.initializePropsFromServe r(Connection.java:2753)
> at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:1671)
> at com.mysql.jdbc.Connection.(Connection.java:432)
>
>*
--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
 
Old 02-16-2008, 07:36 AM
Tim
 
Default mysql JDBC tomcat

On Fri, 2008-02-15 at 15:55 +0000, tony.chamberlain@lemko.com wrote:
> On a completely other note, you can see below the original message.
> WHy is the formatting all screwed up?

That'd be down to whatever mail system you were using, or how the digest
was created, the posting to the list was fine.

--
(This computer runs FC7, my others run FC4, FC5 & FC6, in case that's
important to the thread.)

Don't send private replies to my address, the mailbox is ignored.
I read messages from the public lists.

--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
 
Old 02-16-2008, 01:30 PM
Andrew Overholt
 
Default mysql JDBC tomcat

* Robert L Cochran <cochranb@speakeasy.net> [2008-02-15 09:56]:
> The Fedora 8 implementation of tomcat5 and jetty has a major bug: both
> tomcat5 and jetty, as packaged by the providers, use the same port by
> default.

Have you filed a bug about this?

Andrew
--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
 

Thread Tools




All times are GMT. The time now is 12:12 AM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright 2007 - 2008, www.linux-archive.org