The mailing list for listmasters using Sympa

[IKEDA Soji <address@concealed>]

Tim,

On Tue, 16 Aug 2016 09:19:13 +0000
"Silvers, Tim" <address@concealed> wrote:

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

list_table will be emptied at first.  This means that lists page will
also be emptied or partially displayed for a while (but hitting the
direct link to list pages is possible).

Message distribution (sympa.pl) seems not affected, but IMHO it
would be better to be stopped just in case of mess.

Duration of downtime depends on environment.  For example, I've
experienced a half to a few hours on the servers with several to ten
millions of lists.

It will never affect other tables.


Regards,

-- Soji

> 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/


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