The mailing list for listmasters using Sympa

[IKEDA Soji <address@concealed>]

Hi Tim,

Though you may already found out the solution, list_table in the
database can be rebuilt entirely by running:

  # sympa.pl --sync_list_db

It empties and reloads list_table.


Regards,

-- Soji

On Wed, 10 Aug 2016 14:13:35 +0000
"Silvers, Tim" <address@concealed> 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
> 


-- 
株式会社 コンバージョン  セキュリティ&OSSソリューション部   池田荘児
〒140-0014 東京都品川区大井1-49-15 アクセス大井町ビル4F
e-mail address@concealed  TEL 03-6429-2880
http://www.conversion.co.jp/