The mailing list for listmasters using Sympa

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

Since the problem was noticed a few days ago, we’ve had other lists disappear 
from the list_table. And because of the list_table discrepancies, the List of 
Lists function, which displays public lists, isn’t complete, which is an 
issue.

Tim

> On Aug 11, 2016, at 8:54 AM, Silvers, Tim <address@concealed> wrote:
> 
> We can use the direct URL to admin lists via the web UI, but I am still 
> confused as to why the list_table doesn’t contain all of the lists any 
> longer. Again, we have not upgraded Sympa in the past year. We have only 
> been applying OS updates. I have reviewed the documentation regarding the 
> Sympa database, but I found nothing pertinent. And I was hoping to find a 
> bug list for Sympa, but I have not been successful.
> 
> Tim Silvers
> Campus Communications Infrastructure
> Indiana University
> 
> 
> 
>> On Aug 10, 2016, at 10:42 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
>>>> 
>>> 
>> 
>

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