The mailing list for listmasters using Sympa

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

We are converting our Sympa 3.4.4.3 installation to Sympa 4b2 on a 
separate machine.  Both instances are pointing to Oracle databases.  We 
copied the lists definitions and bounces over from the old machine to 
the new machine.

Our lists are comprised of about 20,500 lists that dynamically generate 
addresses; we have absolutely nothing in the subscriber or user tables.

A typical definition is as follows:

include_sql_query
db_type Oracle
host oraclehost.tamu.edu
user sympa
passwd secret
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 = 
'ENGL104101' 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 = 
'ENGL104101'

We have encountered a situation in the new installation while testing in 
which the task manager is trying to expire bounce messages, but consumes 
all available shared memory in our Oracle server in the process bringing 
the entire RDBMS to its knees.  Inspection on an isolated database 
server revealed that the task manager is taking vast numbers of bounced 
addresses and trying to update them simultaneously in the related 
(empty) subscriber and user tables.

Is there an easy way to tell the task manager not to do that?  I just 
deleted the task from our production instance, but if there is a better 
way I would like to implement it in the new instance.  Plus, I am not 
sure if all those bounced addresses will just accumulate without bound 
if the task isn't running.

I've looked at expire_bounce_task, but am unclear as to the settings 
that would be necessary to basically turn it off.

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