The mailing list for listmasters using Sympa

["Silvers, Tim" <address@concealed>]

Thanks for the quick responses!

We run the database on a separate server from the app server. On the app 
server, are the filesystem directories for the lists 
(/usr/local/sympa/list_data/$ROBOT/). In the directories, we have 7636 lists, 
some of which may have been deleted and not yet purged, so they are inactive; 
most should be active lists, however.

All lists not appearing in the list_table seems odd. I don’t recall this 
being an issue before. I documented how to count our metrics for this service 
last year. One of those metrics was to count the number of lists and, as I 
stated, it is now half of what we totaled last year running the query (e.g., 
"select count(name_list) from list_table where status_list!='closed’;”) from 
the list_table.

At the moment, we have a list rename request pending because we perform 
renames via the web UI generally when a user wants to move the list to a new 
robot (i.e., subdomain). And there is the other issue I previously mentioned.

Thanks,

Tim

> On Aug 10, 2016, at 10:29 AM, Alex Meaden <address@concealed> wrote:
> 
> From experience, not all lists are stored in the database. At least, not
> in the list_table table. I don't know why this is, but I had also
> previously assumed that all lists would be there. Many of our mailing
> lists do not appear in that table, but they appear to function correctly.
> 
> Have you looked within the filesystem to see if they are there? There
> will be a directory for each list, within /var/lib/sympa/list_data or
> similar location.
> 
> Perhaps someone else can explain why this apparent inconsistency exists?
> 
> Alex
> 
> On 10/08/16 15:13, Silvers, Tim wrote:
>> Hi. We may have a database corruption issue, I don’t know. We just noticed 
>> that querying the Web UI as the listmaster for some lists, which we know 
>> exist, returns zero results. Querying the database directly, via the 
>> list_table, we find that these lists are missing. In fact, around half of 
>> our lists appear to be missing. Last year we had nearly 6500 active lists. 
>> A query this morning returned only just over 3300.
>> 
>> We have not upgraded or performed any updates to the system recently 
>> except for monthly OS patching (RHEL 6). Here are the mysql patches we 
>> have applied.
>> 
>> mysql-server-5.1.73-7.el6.x86_64              Sun 05 Jun 2016 07:00:37 AM 
>> EDT
>> mysql-5.1.73-7.el6.x86_64                     Sun 05 Jun 2016 06:59:51 AM 
>> EDT
>> mysql-libs-5.1.73-7.el6.x86_64                Sun 05 Jun 2016 06:59:50 AM 
>> EDT
>> mysql-connector-odbc-5.1.5r1144-7.el6.x86_64  Thu 12 Jul 2012 01:15:01 PM 
>> EDT
>> 
>> Our Sympa version is 6.1.11.
>> 
>> So far, no one is complaining that sending to lists is being affected. The 
>> subscriber_table is okay, as far as we can tell. However, this does make 
>> administration tasks difficult for us. And we have a user complaining that 
>> they receive an error when trying to administrate their list via the web 
>> UI, which we have replicated for this particular list, which is missing 
>> from the list_table.
>> 
>> Has anyone seen this before? Any help is appreciated.
>> 
>> Thanks,
>> 
>> Tim
>> 
>

Attachment: signature.asc
Description: Message signed with OpenPGP using GPGMail