Skip to Content.
Sympa Menu

en - [sympa-users] Re: sympa-5.2.3, mysql and largish table (230 000 roughly)

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Dale Ghent <address@concealed>
  • To: Teunis Peters <address@concealed>
  • Cc: address@concealed
  • Subject: [sympa-users] Re: sympa-5.2.3, mysql and largish table (230 000 roughly)
  • Date: Tue, 14 Nov 2006 19:08:32 -0500


I ran into this situation as well.

There is a bug, it seems, in bounced where it'll loop with that error message if there is one occurrence of a connection error between bounced and the mysql database. What caused this situation in my case was that the maximum number of concurrent connections to the mysql server was reached. Increasing the maximum number of concurrent connections in mysql relieved this problem.

/dale


On Nov 14, 2006, at 5:29 PM, Teunis Peters wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I've just moved my company's list server from mailman to sympa...
... and already things are looking brighter.

Some questions though
- - I'm getting a rediculous number (more than 1 per minute) of "DataBase
connection restored" and "No DataBase" mail notifications. Any
suggestions?
(I've temporarily disabled actually logging it - but this strikes me as
unsafe)

- - Is there any way to change the reply-to to be a specific email?
(for instance: if it were from me, have it be from "Teunis Peters
<address@concealed>")

and... is there any way to find out where a process is "hung"? I
occasionally get rather long delays (hours) in processing and have yet
to discover where and what.

system:
- - sympa-5.2.3
- - mysql 4.1.20
- - perl 5.8.5
Not sure what else you need other than it's a quad-cpu Xeon system with
plenty of resources.


Should I move to another database system such as postgres?

- - Teunis
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFWkL8bFT/SAfwLKMRApyTAJ40YdEZCc6vGkJcVjozpZ0bkdlj2QCeMJnP
4I21981pOe43gK9Cho3bNto=
=hjjZ
-----END PGP SIGNATURE-----


--
Dale Ghent
UNIX Systems Specialist
UMBC - Office of Information Technology
ECS 201 - x51705






Archive powered by MHonArc 2.6.19+.

Top of Page