UBC Botanical Garden Forums Greenheart Canopy Walkway 
  #1  
Old July 5th, 2005, 01:33 PM
Daniel Mosquin's Avatar
Daniel Mosquin Daniel Mosquin is offline
UBC Botanical Garden and Centre for Plant Research
 
Join Date: Jun 2001
Location: Burnaby, BC
Posts: 6,929
Server crash - Jul 5 / 05

The forums were out of service from approx. 3 AM to 12:05 PM (~9 hours) today.

I noticed while completing today's Botany Photo of the Day entry that the data was not being saved to its database. After fiddling around for a couple hours, I determined that the server hosting the databases simply ran out of room.

Unfortunately, the solution is not as easy as deleting some files on the server to make space. The database system tries its best to protect the data stored within it, and "locked up" to prevent data loss. To unlock it, the database needed to be repaired, and this is only possible when a significant amount of space is available on the server - so you can see where the two problems make a bigger problem. Lack of space causes a problem that can't be repaired because of lack of space...

While I could repair the database for the Botany Photo of the Day and get it working, I didn't have access to be able to clean enough space to repair the database for the forums, which is significantly larger in size. I had to wait for the server administrator of that computer to help out.

Fortunately, he's been in the process of testing a new server dedicated to databases, so that meant we had a machine to which we could copy the database and repair it. Once this was done and everything seemed to be working, we had to decide what to do next.

The upshot is that the database that runs the forums is now running off of the new server. We're confident that the server is safe to store data, so that won't be a problem. The only thing that hadn't been fully tested is the encrypted connection between machines - so we're going to see how that works with this database over the next two weeks.

Again, the data on the machine is as safe as can be now (with plenty of room to grow). If something fails, it will likely be due to the not fully-tested connection - no data will be lost because of it, but access to the forums might go down for a few hours from time to time until we work out any bugs that might exist.

I apologize if this has inconvenienced anyone, and I hope that you continue to use and enjoy the forums.
__________________
Please consider supporting UBC Botanical Garden and Centre for Plant Research's mission of excellence in plant research, education and conservation.

Daniel Mosquin
Education and Technology Manager
UBC Botanical Garden | UBC Centre for Plant Research | Nitobe Memorial Garden | BC Flora | John Davidson

Last edited by Daniel Mosquin; July 5th, 2005 at 11:00 PM.
Reply With Quote
  #2  
Old July 5th, 2005, 07:55 PM
Ron B Ron B is offline
Ardent Plant Enthusiast (10000+ posts)
 
Join Date: Aug 2004
Location: Edmonds, WA USA (Z8)
Posts: 13,601
Re: Server crash - Jul 5 / 05

So you had your own fireworks up there, too.
Reply With Quote
  #3  
Old July 5th, 2005, 11:00 PM
Daniel Mosquin's Avatar
Daniel Mosquin Daniel Mosquin is offline
UBC Botanical Garden and Centre for Plant Research
 
Join Date: Jun 2001
Location: Burnaby, BC
Posts: 6,929
Re: Server crash - Jul 5 / 05

Ah, but I wasn't enjoying them.
__________________
Please consider supporting UBC Botanical Garden and Centre for Plant Research's mission of excellence in plant research, education and conservation.

Daniel Mosquin
Education and Technology Manager
UBC Botanical Garden | UBC Centre for Plant Research | Nitobe Memorial Garden | BC Flora | John Davidson
Reply With Quote
Post New ThreadReply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Server up and running Daniel Mosquin Forum Announcements, Feedback and How-Tos 4 November 3rd, 2005 08:46 PM
IMPORTANT: Server shutdown Nov. 3 Daniel Mosquin Forum Announcements, Feedback and How-Tos 15 November 2nd, 2005 05:10 PM
Server issues Daniel Mosquin Forum Announcements, Feedback and How-Tos 1 April 14th, 2005 01:16 AM
Server attacked Daniel Mosquin Forum Announcements, Feedback and How-Tos 0 December 28th, 2004 09:05 AM
Server times are off Daniel Mosquin Forum Announcements, Feedback and How-Tos 1 June 23rd, 2004 01:35 PM


All times are GMT -7. The time now is 04:19 PM.



Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Copyright 2001-2009, University of British Columbia Botanical Garden & Centre for Plant Research