The mailing list for listmasters using Sympa

[Alex Meaden <address@concealed>]

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
>