The mailing list for listmasters using Sympa

["Keith A. Marrocco" <address@concealed>]

I apologize if I have missed the answer to this somewhere.

Our installation of sympa (Sympa version is 4.0.b2) dies upon restart when all 20,000 course lists are present in the expl directory.  Preliminary investigation suggests that it is opening many, many more files than the operating system can accommodate, most of the form /tmp/bn* .  We are running Solaris 9 on a Sunfire 480 with 8GB of ram.

I will be scheduling downtime for the service over the weekend to collect debugging information, unless upgrading to the production release is known to fix this issue.

The course lists are all defined as per the template below.

---
Keith A. Marrocco - Lead Software Applications Developer
Computing and Information Services Texas A&M University
(979) 845-1037 -  http://lt.tamu.edu/~keith/
Co-Advisor - Society of Mexican American Engineers and Scientists


## List template for an intranet usage (no visibility from the outside)

subject {$listname} students

## Not listed with LIST command
visibility conceal

send editorkeyonlyauth

## list archived weekly access restricted to subscribers.
archive
  period week
  access private

## Reply-To: header field is set to the sender email
reply_to sender

reply_to_header
value sender
apply forced

include_sql_query
db_type Oracle
host oracle.tamu.edu
user sympa
passwd notreally
db_name CIS
sql_query select c.courseno, l.ldap_uid || '@neo.tamu.edu' "USER_SUBSCRIBER" from roster.stu_course c, sims_directory s, roster.fac_course f, nameserv.ldap l where c.student_id = s.student_id and s.student_id = l.ssn and f.courseno  = c.courseno and c.courseno = '{uc($courseno)}' union select c.courseno, address@concealed' "USER_SUBSCRIBER" from roster.stu_course c, sims_directory s, roster.fac_course f, nameserv.ldap l where c.student_id = s.student_id and s.student_id = l.ssn and f.courseno  = c.courseno and c.courseno = '{uc($courseno)}'

## Subscription need approval of the owner
subscribe closed

## Unsubscription is free, owner is notified
unsubscribe closed

## Owners ONLY have access to the list subscribers
review owner

owner
email address@concealed

editor
email {$editor}

editor
email address@concealed