An important announcement from the founder of property-bee.com: The future of Property Bee is assured.

Down for maintenance from 10pm THIS evening

Site news and annoucements

Down for maintenance from 10pm THIS evening

Postby Beerhunter on Mon Aug 15, 2011 7:35 pm

Property bee will be down this evening from 10pm onwards, as we have a back log of 3 weeks data to process :?

This will take some time, but hope we will be back up and running sometime tomorrow morning.
User avatar
Beerhunter
Site Admin
 
Posts: 1788
Joined: Tue Jan 22, 2008 12:05 am

Re: Down for maintenance from 10pm THIS evening

Postby Beerhunter on Mon Aug 15, 2011 10:42 pm

Right, the bee is now down for maintenance.... I'll post more here when I know whats wrong and when it will be up again.
User avatar
Beerhunter
Site Admin
 
Posts: 1788
Joined: Tue Jan 22, 2008 12:05 am

Re: Down for maintenance from 10pm THIS evening

Postby Beerhunter on Mon Aug 15, 2011 11:48 pm

The good news is we have all the data from the last few weeks.... and I've just backed everything up before I start tweaking stuff :ugeek:

Seems that early on the 23rd July (my birthday!) a script that processes the days data ran out of memory and left the database in a partially locked state (this is by careful design!).

I've unlocked the database and increased the memory available to the script (by a factor of 8) as well as reducing the memory the script requires, and going to rerun it now... keep your fingers crossed for the next few hours :shock:
User avatar
Beerhunter
Site Admin
 
Posts: 1788
Joined: Tue Jan 22, 2008 12:05 am

Re: Down for maintenance from 10pm THIS evening

Postby Beerhunter on Tue Aug 16, 2011 2:34 am

Update at 2:30am.... still beavering away.

Just started processing information found on rightmove... which is lots, and think its take another 8 to 10 hours minimum before the bee is back up again (thats assuming everything works tonight)

Meantime, there's not much more I can do... except wait, so time for some sleep!
User avatar
Beerhunter
Site Admin
 
Posts: 1788
Joined: Tue Jan 22, 2008 12:05 am

Re: Down for maintenance from 10pm THIS evening

Postby Beerhunter on Tue Aug 16, 2011 10:03 am

Well I checked at 4:30am, 6:30am etc to make sure everything was ok, and its still processing the back log of data now at 9:55.

I think its about 60% done, which means there is another 6 or 7 hours to go... which means I'm got going hang around waiting for it, but go to work :roll:

Unfortunately (assuming the processing completes without falling over again) there's some stuff I have to do before the bee is back online, which means when I get back from work, so its not going to be up until midnight at the earliest.

Sorry for the delay, but I want to get this sorted before I go on hols :D
User avatar
Beerhunter
Site Admin
 
Posts: 1788
Joined: Tue Jan 22, 2008 12:05 am

Re: Down for maintenance from 10pm THIS evening

Postby Beerhunter on Tue Aug 16, 2011 7:37 pm

The good news is the back log of rightmove data has now been cleared.. which accounts for 75-80% of the total :D

Now to sort out the data for daft, findaproperty, propertynews... and all the others

So it looks we'll finally be back up and running around midnight / early hours of this morning :D
User avatar
Beerhunter
Site Admin
 
Posts: 1788
Joined: Tue Jan 22, 2008 12:05 am

Re: Down for maintenance from 10pm THIS evening

Postby Beerhunter on Tue Aug 16, 2011 9:51 pm

Home from work, yet time for more work :roll:
User avatar
Beerhunter
Site Admin
 
Posts: 1788
Joined: Tue Jan 22, 2008 12:05 am

Re: Down for maintenance from 10pm THIS evening

Postby Beerhunter on Tue Aug 16, 2011 10:33 pm

Whilst waiting for stuff to finish, I've done a minor update to the website..

On the the front page (and other pages too) there's a small section titled Status. Hopefully this should alert us (and you) to whether there are any known issues... like the one we are currently experiencing.
User avatar
Beerhunter
Site Admin
 
Posts: 1788
Joined: Tue Jan 22, 2008 12:05 am

Re: Down for maintenance from 10pm THIS evening

Postby Beerhunter on Tue Aug 16, 2011 10:40 pm

Just primelocation left to do, so on schedule for bring the bee back to life at around midnight
User avatar
Beerhunter
Site Admin
 
Posts: 1788
Joined: Tue Jan 22, 2008 12:05 am

Re: Down for maintenance from 10pm THIS evening

Postby Beerhunter on Tue Aug 16, 2011 11:11 pm

Almost there!

Just got to
* optimise/check the mysql tables after doing all those updates
* restore some scripts
* do a test run of the cron process that backs up the database / processes the data to make sure everything is ok
* enable the bee again

I think thats about an hours work.
User avatar
Beerhunter
Site Admin
 
Posts: 1788
Joined: Tue Jan 22, 2008 12:05 am

Re: Down for maintenance from 10pm THIS evening

Postby Beerhunter on Wed Aug 17, 2011 1:11 am

That's me finished.. everything is now back up and running again :D
User avatar
Beerhunter
Site Admin
 
Posts: 1788
Joined: Tue Jan 22, 2008 12:05 am


Return to Announcements

Who is online

Users browsing this forum: No registered users and 10 guests