You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Danny <da...@mms-dresden.de> on 2003/07/10 12:44:39 UTC
MySQL DB looses permanently connection....
We have jetspeed (1.4 build 4) configured with MySQL DB (I must admit, that
the Sever is quite a poor machine) and some portlets, that generate charts
from DB. Everything works fine, but after a while Jetspeed looses the
connection to the DB. And when the connection is lost, Jetspeed has to be
restarted.
My question now is:
Is this a know thing?
Is this related to Jetspeed? (We have another Jetspeed based application
working with Oracle, where everything is OK)
Is this related to the server? (pentium 1, 128 MB RAM, OS Windows NT)
Anny hint is appreciated.
Danny
==========================================
T-Systems Multimedia Solutions GmbH
Danny Gehl
Authorized Java Center (AJC)
Hausanschrift: Riesaer Straße 5, 01029 Dresden
Tel.: (0351) 8505 845
Fax.: (in Arbeit)
E-Mail: mailto:Danny.Gehl@MMS-Dresden.de
http://www.T-Systems-MMS.com
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
AW: MySQL DB looses permanently connection....
Posted by Danny <da...@mms-dresden.de>.
It seems that torque.dsfactory.default.pool.connectionWaitTimeout=200000 solves the problem.
Thanks a lot
> -----Ursprüngliche Nachricht-----
> Von: Stefan Kuhn [mailto:stefan.kuhn@uni-koeln.de]
> Gesendet: Donnerstag, 10. Juli 2003 13:26
> An: Jetspeed Users List
> Betreff: Re: MySQL DB looses permanently connection....
>
>
> Also, if you open connections explicitly, make sure you
> release them all.
> (Sorry if the tip is too simple for you, but stupid people
> like me tend to
> forget things like this :-)
> Stefan
>
>
> Am Thursday 10 July 2003 13:04 schrieb Anandkumar Ayyachamy:
> > If you are using connection pooling DBCP from jakarta then there are
> > settings
> > such as maxIdle="20" maxWait="200000" make sure to set it
> high as per
> > requirement.
> > You can also check your Mysql variables to see the
> connection timeout
> > value and
> > set it as your requirement.
> > Hope this helps
> > -AK
> >
> > Raffaele Ragni wrote:
> > >Il gio, 2003-07-10 alle 12:44, Danny ha scritto:
> > >>We have jetspeed (1.4 build 4) configured with MySQL DB
> (I must admit,
> > >> that the Sever is quite a poor machine) and some
> portlets, that generate
> > >> charts from DB. Everything works fine, but after a while
> Jetspeed looses
> > >> the connection to the DB. And when the connection is
> lost, Jetspeed has
> > >> to be restarted.
> > >>
> > >>My question now is:
> > >>
> > >>Is this a know thing?
> > >>Is this related to Jetspeed? (We have another Jetspeed
> based application
> > >>working with Oracle, where everything is OK)
> > >>Is this related to the server? (pentium 1, 128 MB RAM, OS
> Windows NT)
> > >>
> > >>Anny hint is appreciated.
> > >>
> > >>Danny
> > >>
> > >>==========================================
> > >>T-Systems Multimedia Solutions GmbH
> > >>Danny Gehl
> > >>Authorized Java Center (AJC)
> > >>Hausanschrift: Riesaer Straße 5, 01029 Dresden
> > >>Tel.: (0351) 8505 845
> > >>Fax.: (in Arbeit)
> > >>E-Mail: mailto:Danny.Gehl@MMS-Dresden.de
> > >>http://www.T-Systems-MMS.com
> > >>
> > >>
> >
> >>------------------------------------------------------------
> ---------
> > >>To unsubscribe, e-mail:
> jetspeed-user-unsubscribe@jakarta.apache.org
> > >>For additional commands, e-mail:
> jetspeed-user-help@jakarta.apache.org
> > >
> > >I'm not sure, something about the pool connection timeout? I had a
> > >similar thing before and that was the problem.
> > >
> >
> >---------------------------------------------------------------------
> > >To unsubscribe, e-mail:
> jetspeed-user-unsubscribe@jakarta.apache.org
> > >For additional commands, e-mail:
> jetspeed-user-help@jakarta.apache.org
>
> --
> Stefan Kuhn M. A.
> Cologne University BioInformatics Center
> (http://www.cubic.uni-koeln.de)
> Zülpicher Str. 47, 50674 Cologne
> Tel: +49(0)221-470-7428 Fax: +49 (0) 221-470-7786
> My public PGP key is available at http://pgp.mit.edu
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: MySQL DB looses permanently connection....
Posted by Stefan Kuhn <st...@uni-koeln.de>.
Also, if you open connections explicitly, make sure you release them all.
(Sorry if the tip is too simple for you, but stupid people like me tend to
forget things like this :-)
Stefan
Am Thursday 10 July 2003 13:04 schrieb Anandkumar Ayyachamy:
> If you are using connection pooling DBCP from jakarta then there are
> settings
> such as maxIdle="20" maxWait="200000" make sure to set it high as per
> requirement.
> You can also check your Mysql variables to see the connection timeout
> value and
> set it as your requirement.
> Hope this helps
> -AK
>
> Raffaele Ragni wrote:
> >Il gio, 2003-07-10 alle 12:44, Danny ha scritto:
> >>We have jetspeed (1.4 build 4) configured with MySQL DB (I must admit,
> >> that the Sever is quite a poor machine) and some portlets, that generate
> >> charts from DB. Everything works fine, but after a while Jetspeed looses
> >> the connection to the DB. And when the connection is lost, Jetspeed has
> >> to be restarted.
> >>
> >>My question now is:
> >>
> >>Is this a know thing?
> >>Is this related to Jetspeed? (We have another Jetspeed based application
> >>working with Oracle, where everything is OK)
> >>Is this related to the server? (pentium 1, 128 MB RAM, OS Windows NT)
> >>
> >>Anny hint is appreciated.
> >>
> >>Danny
> >>
> >>==========================================
> >>T-Systems Multimedia Solutions GmbH
> >>Danny Gehl
> >>Authorized Java Center (AJC)
> >>Hausanschrift: Riesaer Straße 5, 01029 Dresden
> >>Tel.: (0351) 8505 845
> >>Fax.: (in Arbeit)
> >>E-Mail: mailto:Danny.Gehl@MMS-Dresden.de
> >>http://www.T-Systems-MMS.com
> >>
> >>
> >>---------------------------------------------------------------------
> >>To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> >>For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
> >
> >I'm not sure, something about the pool connection timeout? I had a
> >similar thing before and that was the problem.
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> >For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
--
Stefan Kuhn M. A.
Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de)
Zülpicher Str. 47, 50674 Cologne
Tel: +49(0)221-470-7428 Fax: +49 (0) 221-470-7786
My public PGP key is available at http://pgp.mit.edu
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: MySQL DB looses permanently connection....
Posted by Anandkumar Ayyachamy <an...@eself.com>.
If you are using connection pooling DBCP from jakarta then there are
settings
such as maxIdle="20" maxWait="200000" make sure to set it high as per
requirement.
You can also check your Mysql variables to see the connection timeout
value and
set it as your requirement.
Hope this helps
-AK
Raffaele Ragni wrote:
>Il gio, 2003-07-10 alle 12:44, Danny ha scritto:
>
>
>>We have jetspeed (1.4 build 4) configured with MySQL DB (I must admit, that
>>the Sever is quite a poor machine) and some portlets, that generate charts
>>from DB. Everything works fine, but after a while Jetspeed looses the
>>connection to the DB. And when the connection is lost, Jetspeed has to be
>>restarted.
>>
>>My question now is:
>>
>>Is this a know thing?
>>Is this related to Jetspeed? (We have another Jetspeed based application
>>working with Oracle, where everything is OK)
>>Is this related to the server? (pentium 1, 128 MB RAM, OS Windows NT)
>>
>>Anny hint is appreciated.
>>
>>Danny
>>
>>==========================================
>>T-Systems Multimedia Solutions GmbH
>>Danny Gehl
>>Authorized Java Center (AJC)
>>Hausanschrift: Riesaer Straße 5, 01029 Dresden
>>Tel.: (0351) 8505 845
>>Fax.: (in Arbeit)
>>E-Mail: mailto:Danny.Gehl@MMS-Dresden.de
>>http://www.T-Systems-MMS.com
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>>
>>
>>
>>
>
>I'm not sure, something about the pool connection timeout? I had a
>similar thing before and that was the problem.
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>
>
>
>
AW: MySQL DB looses permanently connection....
Posted by Danny <da...@mms-dresden.de>.
Yes right, that is exactly the error!
Pool connection timed out ... and nothing works any more.
You have any hint?
> -----Ursprüngliche Nachricht-----
> Von: Raffaele Ragni [mailto:raffaeleragni.jet@cone.it]
> Gesendet: Donnerstag, 10. Juli 2003 12:49
> An: Jetspeed Users List
> Betreff: Re: MySQL DB looses permanently connection....
>
>
> Il gio, 2003-07-10 alle 12:44, Danny ha scritto:
> > We have jetspeed (1.4 build 4) configured with MySQL DB (I
> must admit, that
> > the Sever is quite a poor machine) and some portlets, that
> generate charts
> > from DB. Everything works fine, but after a while Jetspeed
> looses the
> > connection to the DB. And when the connection is lost,
> Jetspeed has to be
> > restarted.
> >
> > My question now is:
> >
> > Is this a know thing?
> > Is this related to Jetspeed? (We have another Jetspeed
> based application
> > working with Oracle, where everything is OK)
> > Is this related to the server? (pentium 1, 128 MB RAM, OS
> Windows NT)
> >
> > Anny hint is appreciated.
> >
> > Danny
> >
> > ==========================================
> > T-Systems Multimedia Solutions GmbH
> > Danny Gehl
> > Authorized Java Center (AJC)
> > Hausanschrift: Riesaer Straße 5, 01029 Dresden
> > Tel.: (0351) 8505 845
> > Fax.: (in Arbeit)
> > E-Mail: mailto:Danny.Gehl@MMS-Dresden.de
> > http://www.T-Systems-MMS.com
> >
> >
> >
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> jetspeed-user-help@jakarta.apache.org
> >
> >
>
> I'm not sure, something about the pool connection timeout? I had a
> similar thing before and that was the problem.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: MySQL DB looses permanently connection....
Posted by Raffaele Ragni <ra...@cone.it>.
Il gio, 2003-07-10 alle 12:44, Danny ha scritto:
> We have jetspeed (1.4 build 4) configured with MySQL DB (I must admit, that
> the Sever is quite a poor machine) and some portlets, that generate charts
> from DB. Everything works fine, but after a while Jetspeed looses the
> connection to the DB. And when the connection is lost, Jetspeed has to be
> restarted.
>
> My question now is:
>
> Is this a know thing?
> Is this related to Jetspeed? (We have another Jetspeed based application
> working with Oracle, where everything is OK)
> Is this related to the server? (pentium 1, 128 MB RAM, OS Windows NT)
>
> Anny hint is appreciated.
>
> Danny
>
> ==========================================
> T-Systems Multimedia Solutions GmbH
> Danny Gehl
> Authorized Java Center (AJC)
> Hausanschrift: Riesaer Straße 5, 01029 Dresden
> Tel.: (0351) 8505 845
> Fax.: (in Arbeit)
> E-Mail: mailto:Danny.Gehl@MMS-Dresden.de
> http://www.T-Systems-MMS.com
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>
I'm not sure, something about the pool connection timeout? I had a
similar thing before and that was the problem.
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: MySQL DB looses permanently connection....
Posted by ThomasGrundey <tg...@techmatrix.de>.
When using mysql with jdbc I always use its autoreconnect feature (within
and without jetspeed).
This feature is described in the documentation for the mysql JDBC-Driver.
Oracle does not have such a "feature".
The URL looks then like
torque.dsfactory.default.connection.url =
jdbc:mysql://localhost:3306/jetspeed?autoReconnect=true
Without autoReconnect=true I had applications (not using torque but jdbc
directly) loosing the connection after
something like 2 or three days.
I hope this helps
Thomas Grundey
----- Original Message -----
From: "Danny" <da...@mms-dresden.de>
To: "Jetspeed User Mailing List (E-Mail)" <je...@jakarta.apache.org>
Sent: Thursday, July 10, 2003 12:44 PM
Subject: MySQL DB looses permanently connection....
We have jetspeed (1.4 build 4) configured with MySQL DB (I must admit, that
the Sever is quite a poor machine) and some portlets, that generate charts
from DB. Everything works fine, but after a while Jetspeed looses the
connection to the DB. And when the connection is lost, Jetspeed has to be
restarted.
My question now is:
Is this a know thing?
Is this related to Jetspeed? (We have another Jetspeed based application
working with Oracle, where everything is OK)
Is this related to the server? (pentium 1, 128 MB RAM, OS Windows NT)
Anny hint is appreciated.
Danny
==========================================
T-Systems Multimedia Solutions GmbH
Danny Gehl
Authorized Java Center (AJC)
Hausanschrift: Riesaer Straße 5, 01029 Dresden
Tel.: (0351) 8505 845
Fax.: (in Arbeit)
E-Mail: mailto:Danny.Gehl@MMS-Dresden.de
http://www.T-Systems-MMS.com
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org