The mailing list for listmasters using Sympa

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

What is the best way to ‘fix’ the missing entries in the list_table? We have 
an old database restored from backup with over 7500 list_table rows, more 
than twice what the list_table has now. We could use this data to add the 
missing entries, but we do not want to break Sympa so close to the semester 
starting, or anytime, really.

Tim

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