Skip to Content.
Sympa Menu

devel - [sympa-dev] Re: Sympa 5.3b.5 automatic list creation load testing

Subject: Developers of Sympa

List archive

Chronological Thread  
  • From: Thomas Berry <address@concealed>
  • To: sympa dev <address@concealed>
  • Subject: [sympa-dev] Re: Sympa 5.3b.5 automatic list creation load testing
  • Date: Fri, 18 May 2007 10:25:33 -0700

Sympa 5.3b.5


During that test, I'm seeing the following error for each member synchronized from the LDAP entry:


May 18 10:23:05 int-list sympa(creation)[5042]: List::add_user() Unable to execute SQL statement "INSERT INTO subscriber_table (user_subscriber, comment_subscriber, list_subscriber, robot_subscriber, date_subscriber, update_subscriber, reception_subscriber, topics_subscriber, visibility_subscriber,subscribed_subscriber,included_subscriber,include_sources_subscriber) VALUES ('address@concealed', NULL, 'testgroup9000', 'int-list.jpl.nasa.gov', FROM_UNIXTIME(1179508958), FROM_UNIXTIME(1179508958), 'mail', NULL, 'noconceal', 0, 1, 'a162ec6a')" : Duplicate entry 'address@concealed' for key 1


Thomas


We're running some load tests in an effort to see the load Sympa puts
on the LDAP servers when retrieving members.

For now, I'm sending six messages to mailing lists with member counts
ranging from 10 to 9000 members. Here are some of the messages that
result from the test:

Sympa will sometimes bounce with this message:

- - - -

Your message for list 'testgroup10' (attached below) was rejected.
You are not allowed to send this message for the following reason :

Message distribution in the list is restricted to list subscribers.

- - - -

The authorization of automatic list creation set to intranet, the
sender's email address is in the domain, and the list is configured with
"send public".


So far, there have been two occurrence when Sympa bounced back with the
following message:

- - - -

Impossible to distribute your message for list '' for the following reason :

The testgroup2000 list could not be created.

- - - -

Note: The number in the list name denotes the number of test members in
the list.

Note: We have modified sympa.pl "DoFile" in order to get Sympa to use
admin::update_list for every message sent to a list. This is done
because some of the list settings are in an LDAP entry that can be
changed by the owners of the LDAP entry. We need messaging being sent
to the list to adhere to the configuration settings in the LDAP entry.




Archive powered by MHonArc 2.6.19+.

Top of Page