The mailing list for listmasters using Sympa

["Petursson, Sigurdur" <address@concealed>]

Unsubscribe

Sigurd Petursson
Information Technology
University of Miami
address@concealed

> On Aug 10, 2016, at 10:43 AM, Silvers, Tim <address@concealed> wrote:
> 
> 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
>