Not sure of the best way forward, so if anyone has suggestions, please shout.
The index broke because I started a mysql shell, without the -A option. As a consequence it started a process to get the field list of the tables in the metabase db. As it was taking over an hour I CTRL-C'ed it and killed the process. Bad idea. I've now been running the repair table for over 14 hours, as well as running a field list query on the cpanstats db that was started by another mysql shell. The question is, is there a quick way to tell the mysql shell what the field list is? Or is it not getting a field list but do something else, as the state says 'checking table'. I'm loathed to stop anything at the moment, as I don't know how long it will take, and whether it is near the end anyway. With the split of the disks, I'm confident the reports pull and builder scripts will catch up very quickly, so I'm willing to wait another day or two. Failing that I'm going to have to write an alias for the command to also add the -A. Does this field list actually lock any tables, as it appeared to when I first started it, but some of the cronjobs I've restarted appear to be fine. If it doesn't lock tables, I'll stop the repair, recopy the backup metabase db, then try another mysql shell, and just let it run. All advice gratefully received. Thanks, Barbie. -- Birmingham.pm - http://birmingham.pm.org CPAN Testers - http://cpantesters.org YAPC Surveys - http://yapc-surveys.org Perl Jam - http://perljam.info On Sun, Sep 29, 2013 at 10:05 PM, Barbie <bar...@missbarbell.co.uk> wrote: > I knew it was fateful to say it had gone well. I accidentally managed to > break the indexing during a field list check :( Repairing table now, and > also re-copying a fresh copy, just in case that would be quicker. > > More progress tomorrow. > > Barbie. > > -- > Birmingham.pm - http://birmingham.pm.org > CPAN Testers - http://cpantesters.org > YAPC Surveys - http://yapc-surveys.org > Perl Jam - http://perljam.info > > > On Sun, Sep 29, 2013 at 6:54 PM, Barbie <bar...@missbarbell.co.uk> wrote: > >> Databases copied. Libraries (Perl & C) installed. Websites prepped. Now >> starting to switch cronjobs back on. >> >> Might have some hiccups getting all the mailers working, as I'm sure I >> had problems with them last time with reverse DNS. >> >> Prefs site may need to wait until later in the week, as I need to sort >> out some new SSL certificates, both for the prefs.cpantesters.org and >> admin.cpantesters.org. The current one is due to expire shortly, and >> would rather use someone else than have to go through the hoops with our >> current supplier. >> >> Thankfully so far all has gone well. However, please let me know if you >> see any issues arising during the week. >> >> Thanks, >> Barbie. >> >> >> -- >> Birmingham.pm - http://birmingham.pm.org >> CPAN Testers - http://cpantesters.org >> YAPC Surveys - http://yapc-surveys.org >> Perl Jam - http://perljam.info >> >> >> On Sun, Sep 29, 2013 at 1:03 AM, Barbie <bar...@missbarbell.co.uk> wrote: >> >>> ftp, rsync and web now running for: >>> >>> cpan.cpantesters.org >>> backpan.cpantesters.org >>> >>> Databases still copying and not due to finish until the morning. >>> >>> Thanks, >>> Barbie. >>> >>> -- >>> Birmingham.pm - http://birmingham.pm.org >>> CPAN Testers - http://cpantesters.org >>> YAPC Surveys - http://yapc-surveys.org >>> Perl Jam - http://perljam.info >>> >>> >>> On Sat, Sep 28, 2013 at 9:21 AM, Barbie <bar...@missbarbell.co.uk>wrote: >>> >>>> Minor set back, the CPAN and BACKPAN mirrors were too big to fit on the >>>> SSDs with the web pages, so having to copy them over to the HDDs. Builders >>>> are up to date, only page requests getting added, rather than reports, so >>>> they're ready to go. Once mirrors have been copied and configured for the >>>> web/ftp/rsync, the sync from master will be restarted. Then the database >>>> will be next. >>>> >>>> Thanks, >>>> Barbie. >>>> >>>> -- >>>> Birmingham.pm - http://birmingham.pm.org >>>> CPAN Testers - http://cpantesters.org >>>> YAPC Surveys - http://yapc-surveys.org >>>> Perl Jam - http://perljam.info >>>> >>>> >>>> On Fri, Sep 27, 2013 at 8:11 AM, Barbie <bar...@missbarbell.co.uk>wrote: >>>> >>>>> Just to let you know the reports pull has now stopped, with the last >>>>> report pulled from 06:11 UTC. The builder will now catch up, and as soon >>>>> as >>>>> the DB is as complete as possible, that will be moved over. I'm trying to >>>>> avoid downtime, but you won't see any new reports on the site until the >>>>> processes are all switched on, on the new server. >>>>> >>>>> Likewise anyone trying to get database updates via the APIs or >>>>> archived data will only get updates up to today. The same applies to the >>>>> CPAN/BACKPAN mirrors, which are being copied over at the moment, and I aim >>>>> to get these up and running on the new server first. Fingers crossed this >>>>> could be this evening or tomorrow morning. >>>>> >>>>> I'll keep you updated of progress and let you know when processes are >>>>> switched back on. >>>>> >>>>> Thanks, >>>>> Barbie. >>>>> >>>>> >>>>> -- >>>>> Birmingham.pm - http://birmingham.pm.org >>>>> CPAN Testers - http://cpantesters.org >>>>> YAPC Surveys - http://yapc-surveys.org >>>>> Perl Jam - http://perljam.info >>>>> >>>>> >>>>> On Wed, Sep 25, 2013 at 7:01 PM, Barbie <bar...@missbarbell.co.uk>wrote: >>>>> >>>>>> Hi folks, >>>>>> >>>>>> sorry for the sort notice, but the server upgrade will be happening >>>>>> from Friday, and will continue over the weekend. I hadn't quite expected >>>>>> Bytemark to be so quick getting everything ready for us :) >>>>>> >>>>>> Further details on the blog - http://blog.cpantesters.org/diary/167 >>>>>> >>>>>> Please pass on to anyone you know who might be affected. >>>>>> >>>>>> Cheers, >>>>>> Barbie. >>>>>> >>>>>> -- >>>>>> Birmingham.pm - http://birmingham.pm.org >>>>>> CPAN Testers - http://cpantesters.org >>>>>> YAPC Surveys - http://yapc-surveys.org >>>>>> Perl Jam - http://perljam.info >>>>>> >>>>> >>>>> >>>> >>> >> >
