The mailing list for listmasters using Sympa

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

We just upgraded to sympa 4.1.1 and have tried to implement include2 
lists, as per the configuration file below.  The response from sympa is 
routinely "List cpsc203300-2004b has no subscriber.", unless I switch it 
back to include. Debug output is at the bottom of the message.

Also, our task manager continues to go wild when running, causing all 
available shared memory to become exhausted in our Oracle database.  I 
have been running with it disabled.  Is this a known condition that I 
can address?

Thanks,

Keith
---
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



keith@groups:/usr/local/sympa/expl/cpsc203300-2004b % cat config
## List template for an intranet usage (no visibility from the outside)

subject cpsc203300-2004b 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

user_data_source include2

include_sql_query
db_type Oracle
host oblio.tamu.edu
user sympa
passwd NotTheMama
db_name CIS
sql_query select 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.student_id and f.courseno  = c.courseno and c.courseno = 'CPSC203300' 
and lower(c.term) = '2004b' union select 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.student_id and f.courseno  = c.courseno and 
c.courseno = 'CPSC203300' and lower(c.term) = '2004b'

## 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

## The owners
#owner
#email

owner
email address@concealed

owner
email address@concealed
reception nomail

editor
email address@concealed

=====================
Log snippet:
Processing /data/sympa/spool/msg/sympa.1087426572.4965 with priority 1
DoFile(/data/sympa/spool/msg/sympa.1087426572.4965)
Message::new(/data/sympa/spool/msg/sympa.1087426572.4965)
Scan virus in /data/sympa/spool/msg/sympa.1087426572.4965
ld.so.1: /usr/local/uvscan/uvscan: fatal: libsunfv.so.4: open failed: No 
such fi
le or directory
DoCommand(sympa groups.tamu.edu MIME::Entity=HASH(0x9ddf8c) 
/data/sympa/spool/ms
g/sympa.1087426572.4965)
Processing command with priority 1, <address@concealed>

Commands::parse(address@concealed, groups.tamu.edu, review cpsc203300-2004b, )
Parsing: review cpsc203300-2004b
Commands::review(cpsc203300-2004b,groups.tamu.edu,)
List::new(cpsc203300-2004b,groups.tamu.edu)
List::load(cpsc203300-2004b, groups.tamu.edu)
unknown Locale en, maybe sub LoadLang not Loaded before
List::new(cpsc203300-2004b,)
List::load(cpsc203300-2004b, )
List::new(cpsc203300-2004b,)
List::load(cpsc203300-2004b, )
List::new(cpsc203300-2004b,)
List::load(cpsc203300-2004b, )
List::get_first_user(cpsc203300-2004b,email,0,0)
Got lock for reading on /data/sympa/expl/cpsc203300-2004b/include.lock
List::_load_total_db(cpsc203300-2004b)
No subscribers in list 'cpsc203300-2004b'
smtp::smtpto(address@concealed, address@concealed,  )
Moving bad file sympa.1087426572.4965 to bad/
unknown Locale en, maybe sub LoadLang not Loaded before
List::init_list_cache()
Reaper unwaited pids : 4967
Open = 1