From ArchWiki
Revision as of 15:21, 9 August 2010 by Pierre (Talk | contribs) (dbscripts package pool migration)

Jump to: navigation, search

L10n-de Todo

FluxBB 1.4 Upgrade

  • done :-)

Post update tasks

  • write a script to check and fix database integrity
update topics a set a.first_post_id=(SELECT MIN( FROM posts WHERE;
update topics a set a.last_post_id=(SELECT MAX( FROM posts WHERE;
update topics set first_post_id=0, last_post_id=0, last_poster=null, num_views=0, num_replies=0 where moved_to is not null;
update topics set num_replies=(select count(id)-1 from posts where where topics.moved_to is null;
update forums set num_topics=(select count(id) from topics where;
update forums set num_posts=(select sum(num_replies)+count( from topics where and topics.moved_to is null);
  • if everything is fine remove phpbb db
  • why are there two fluxbb users
  • why is the db that slow?
  • create backup script

dbscripts package pool migration

  • sigurd
    • install -d -o root -g tusers /srv/ftp/packages/community/{i686,x86_64,any}
  • gerolde
    • install -d -o ftp -g ftp-extra /srv/ftp/packages/arch/{i686,x86_64,any}
    • rsync the packages/community dir from sigurd
  • check if mirrors sync correctly
  • review rsync modules
  • git pull on sigurd and gerolde
    • check cron jobs
  • send announcement to arch-dev-public and aur-general