You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by Kenny Smith <ja...@journalscape.com> on 2003/05/05 18:03:12 UTC
How many DB connections do you use?
Hi all,
I'm having occurances of mail getting rejected because not enough
connections are available. Whenever I find the errors in my deadletter
repository, I up the number of connections. I just turned it up to 30
connections, I'm wondering just how high I need to go....
What do you use?
Kenny Smith
JournalScape.com
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
Re: How many DB connections do you use?
Posted by Javier Storni <ja...@512konline.com.ar>.
My scenario requires up to 50 connections. I have ~120 mailboxes with
intensive use.
Javier
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
Re: How many DB connections do you use?
Posted by Kenny Smith <ja...@journalscape.com>.
Thanks, Noel. I'll just keep watching it and increasing the number as
needed.
Kenny Smith
Noel J. Bergman wrote:
>>It was the one mentioned in the config.xml file...
>>"SQLException: Giving up... no connections available."
>
>
> OK, that is from the database interface.
>
> The default is to have 20 connections. They are shared by the default of 10
> spool threads, 30 connections per protocol, and the RemoteDelivery
> thread(s). As you can see, you've got 71+ threads competing for 20 database
> connections. Usually that is OK, since the database layer will wait a bit
> for an available connection, but if everyone starts hogging connections for
> longer than expected, you can run into the above message.
>
> --- Noel
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: How many DB connections do you use?
Posted by "Noel J. Bergman" <no...@devtech.com>.
> It was the one mentioned in the config.xml file...
> "SQLException: Giving up... no connections available."
OK, that is from the database interface.
The default is to have 20 connections. They are shared by the default of 10
spool threads, 30 connections per protocol, and the RemoteDelivery
thread(s). As you can see, you've got 71+ threads competing for 20 database
connections. Usually that is OK, since the database layer will wait a bit
for an available connection, but if everyone starts hogging connections for
longer than expected, you can run into the above message.
--- Noel
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
Re: How many DB connections do you use?
Posted by Kenny Smith <ja...@journalscape.com>.
Hi Noel,
I don't have it anymore. I cleaned out the deadletter repository and
then accidentally closed my text buffer without saving.
It was the one mentioned in the config.xml file...
<!-- Maximum concurrent connections james may open to this database-->
<!-- If you see "SQLException: Giving up... no connections available."
in your log files or bounced mail increase this value -->
Sorry I can't be more helpful.
Kenny
Noel J. Bergman wrote:
> Kenny,
>
> What is the exact message (so I can grep the source), and what is in the
> logs related to that message? Search for the message's mail ID, and also
> look for exceptions around that time.
>
> --- Noel
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: How many DB connections do you use?
Posted by "Noel J. Bergman" <no...@devtech.com>.
Kenny,
What is the exact message (so I can grep the source), and what is in the
logs related to that message? Search for the message's mail ID, and also
look for exceptions around that time.
--- Noel
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
Re: How many DB connections do you use?
Posted by Kenny Smith <ja...@journalscape.com>.
Hi Noel,
I'm finding messages in the deadletter repository where the error
message contained a message stating that the max connections had been
reached.
Which of course seems strange to me because it had a db connection to
write it to the deadletter, but not to the inbox. I'm trying to find an
example, but I can't find it anymore.
Do you know of a string I can grep through my logs for to get info about
mordred (other than mordred.. that didn't turn up anything good).
Kenny
Noel J. Bergman wrote:
> Kenny,
>
> I test the stock configuration, switching to a db:// spooler, with 20
> simultanous connections running for anywhere from 24 hours on up. How many
> simultaneous connections are you seeing? Are you finding entries in the log
> that say mordred can't get a connection so it is giving up?
>
> --- Noel
>
> -----Original Message-----
> From: Kenny Smith [mailto:jakarta-james@journalscape.com]
> Sent: Monday, May 05, 2003 12:03
> To: James Users List
> Subject: How many DB connections do you use?
>
>
> Hi all,
>
> I'm having occurances of mail getting rejected because not enough
> connections are available. Whenever I find the errors in my deadletter
> repository, I up the number of connections. I just turned it up to 30
> connections, I'm wondering just how high I need to go....
>
> What do you use?
>
> Kenny Smith
> JournalScape.com
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: How many DB connections do you use?
Posted by "Noel J. Bergman" <no...@devtech.com>.
Kenny,
I test the stock configuration, switching to a db:// spooler, with 20
simultanous connections running for anywhere from 24 hours on up. How many
simultaneous connections are you seeing? Are you finding entries in the log
that say mordred can't get a connection so it is giving up?
--- Noel
-----Original Message-----
From: Kenny Smith [mailto:jakarta-james@journalscape.com]
Sent: Monday, May 05, 2003 12:03
To: James Users List
Subject: How many DB connections do you use?
Hi all,
I'm having occurances of mail getting rejected because not enough
connections are available. Whenever I find the errors in my deadletter
repository, I up the number of connections. I just turned it up to 30
connections, I'm wondering just how high I need to go....
What do you use?
Kenny Smith
JournalScape.com
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org