The mailing list for listmasters using Sympa

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

Thanks, Soji. Can that be done safely in production without downtime or 
disruption? Will it affect the other databases tables?

Sent from my mobile device.

> On Aug 16, 2016, at 5:15 AM, IKEDA Soji <address@concealed> wrote:
> 
> 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/

Attachment: smime.p7s
Description: S/MIME cryptographic signature