Dominion Strategy Forum

Meta => Feedback => Council Room Feedback => Topic started by: Mike McCallister on January 25, 2013, 01:16:17 am

Title: Council Room Going Down for Maintenance
Post by: Mike McCallister on January 25, 2013, 01:16:17 am
Sometime in the next 24 hours, CouncilRoom.com will be down for a brief period of maintenance to expand the amount of storage available to the application. Until that is completed, new games and leaderboards will not be loaded, and the corresponding statistics will not be updated. It should continue to function fine in a "read-only" mode in the mean time. Once the additional space has been added, games played on and after January 23 will get loaded per usual.

I expect the outage to only take a few hours, though this is at best an educated guess. I'll change the CouncilRoom.com homepage while it is actually down to reflect that it is in maintenance mode, and I'll post progress updates in this thread.


Mike
Title: Re: Council Room Going Down for Maintenance
Post by: bedlam on January 26, 2013, 12:14:30 pm
Is it still down? None of the games I've played since 1/20 have posted and I would like to post a gamelog.
Title: Re: Council Room Going Down for Maintenance
Post by: Mike McCallister on January 26, 2013, 07:17:01 pm
Here's the update:

I figured out how to do the maintenance in the background, with affecting the main site. The storage space has been added, the existing database has been validated, and I just kicked off the process to load the last several day's worth of data. It starts with the most recent complete day (in this case, 2013-01-25) and works backwards in time until it finds a day that has already been loaded. Processing a normal day takes about an hour, so a ballpark estimate is that all games should be loaded and available in about three hours from now. I'll check back in a little later to verify.


Mike
Title: Re: Council Room Going Down for Maintenance
Post by: Mike McCallister on January 26, 2013, 09:52:29 pm
And we're back in business. Please let me know if you see anything amiss.


Mike
Title: Re: Council Room Going Down for Maintenance
Post by: Morgrim7 on January 27, 2013, 12:01:01 am
Thanks again for keeping CR for us!
Title: Re: Council Room Going Down for Maintenance
Post by: WanderingWinder on February 10, 2013, 08:35:35 am
Are we having this issue again? Seems like there isn't anything from the past 3-4 days.
Title: Re: Council Room Going Down for Maintenance
Post by: WanderingWinder on February 13, 2013, 04:01:39 pm
Anybody else having problems pulling recent games?
Title: Re: Council Room Going Down for Maintenance
Post by: DStu on February 13, 2013, 04:06:04 pm
Anybody else having problems pulling recent games?
here
Title: Re: Council Room Going Down for Maintenance
Post by: AdamH on February 14, 2013, 09:32:20 am
Anybody else having problems pulling recent games?
here

Me three.
Title: Re: Council Room Going Down for Maintenance
Post by: DStu on February 14, 2013, 10:25:55 am
Also from the IRC:
Quote
(16:47:30) stuff: Hello,  It looks like new games aren't being loaded.  At least into the recent games list
Title: Re: Council Room Going Down for Maintenance
Post by: Master Shuffler on February 14, 2013, 11:54:42 am
I've been having trouble pulling recent games for about a week, but since "record by opponent" still doesn't work I can't really use CR effectively at all.

Edit: Also I have 8 anticlimactic achievements (I play lots of multiplayer), but it doesn't show up in the goal statistics page.
Title: Re: Council Room Going Down for Maintenance
Post by: smoothdaddy on February 14, 2013, 12:25:33 pm
Hello,

I'm the guy that reported it on IRC.  Long time reader first time poster.  If you guys really need your game files you can use this system till council room starts working again.  Please only download the files if you are going to do something with the files as the FAQ explains.

If you already have the files on your machine Specify SEARCH_ONLY=1 -- If you are downloading for the first time just run the script


------------------------------------------------

HOME_DIR=YOUR_HOME_DIR

if [ -z "$SEARCH_ONLY" ]
then
   curl http://dominion.isotropic.org/gamelog/${LOAD_YEAR}/${LOAD_DAY}/all.tar.bz2 > ${HOME_DIR}/raw/all_${LOAD_YEAR}${LOAD_DAY}.tar.bz2
   mkdir -p ${HOME_DIR}/${LOAD_YEAR}${LOAD_DAY}
   cd ${HOME_DIR}/${LOAD_YEAR}${LOAD_DAY}
   tar -x -f ${HOME_DIR}/raw/all_${LOAD_YEAR}${LOAD_DAY}.tar.bz2
   curl http://dominion.isotropic.org/leaderboard/ > ${LOAD_YEAR}${LOAD_DAY}_leaderboard.html
fi

find ${HOME_DIR}/${LOAD_YEAR}${LOAD_DAY} -type f -name '*.html' -exec grep -l "YOUR_USERNAME" {} \; > my_games.txt

------------------------------------------------------------------------

Make sure to replace "YOUR_USERNAME" with your actual username.

Sample command run

For yesterday - 20130213

First time (you have not downloaded the files- note load_year is actually the year and month - If the LOAD_DAY is less than 10 specify it with a leading zero ie 01)

 LOAD_YEAR=201302 LOAD_DAY=13 ./get_game_logs.sh

After this runs you will see a directory 20130213 which will hold all the games for that day.  There will also be a txt file called my_games.txt in that directory that will list which games are yours so you can paste them into your browser to view (it will have the full path to the file).

If you already have the files and just want to make the my_games.txt file call it like so
SEARCH_ONLY=1 LOAD_YEAR=201302 LOAD_DAY=13 ./get_game_logs.sh

This will just do the grep through the files and print out which ones belong to you into my_games.txt


Let me know if you have any issues








Title: Re: Council Room Going Down for Maintenance
Post by: DStu on February 14, 2013, 12:28:54 pm
See also here (http://forum.dominionstrategy.com/index.php?topic=5486.0) for Windows support...