Systems Staff Meeting Notes
March 14, 2005
March 14, 2005
Present: Rich Bennett, Cynthia Bowker, Will Chaney, Bill Covey, Suzy Covey, Debra Fetzer, Chris Nicolich, Ying TangAnnouncements
Ongoing Systems Updates
- Gators won the SEC basketball tournament.and beat Kentucky to do it!
- Stack creep on the loose in the MSL public area. Reportedly "improperly touching people". Bill had Cynthia track down the user logged on at the time of the incident. It is just one piece of data in the chain.
- LAD bugout - LAD (located in the old Maas Brothers basement) is one of the places we are currently storing books. We now have to vacate the space by this summer. The lease specifies that either party can cancel with 120 days notice. The rumor is that the owner has a hot prospect willing to pay more money. Coincidentally, the Law School currently has books stored at the old Publix in Butler plaza. It's possible we can move there if they vacate at the time we are looking to move. The LAD bugout has been on-again-off-again, but it is currently on. The plan to transfer all of the collection to LC from Dewey before moving into West may be hindered by this development.
- Info Gator - TEAMS & USPS climate survey coming soon - will probably be online. Will be interesting to see if the results correspond to the faculty survey.
- Orders - revamping orders from last week that were lost due to the NT4/SQL outage.
- Greenstone - no definitive response yet. It has already reached the 5-7 day response time. Bill wants to talk to the person in charge of arranging for the installation.
- Microsoft software order - server software should have gone through. Much confusion abounds with the user software order. Bill is checking with Mike Conlon.
- Bill plans on sending out an email about the SQL server outage of last week.
- Will also send out a notice regarding the use of time keeping software.
Software Projects Status
- Last Thursday morning - SQL server had been having problems - was clogged; the C:drive was out of space. We decided to add space and the final step was to make the space available to the C:drive. The space is added to the end of the raid array. Will started the process around 6AM on Thursday. By 7:30-8AM, it became evident that the process was hopelessly slow or even hung. We were unable to take control of the box. We brought over a back-up server from MSL and continued the recovery efforts on the original server. Turned out that it was faster to get the old server up. The data drives had to be rebuilt. We restored the information from back-ups, but SQL always lags a day behind. We ended up losing 1½-2 days of data. NT4 is back up, but we still need to do the original procedure of adding space. We've started to back-up the SQL server logs so that theoretically we'll have one more day of data. There is no way to get all of the data restored in a case like this, unless we have two servers running at the same time. This would be costly. We do have a second server as backup to NT2R. After this, we may get it for NT4. The current backup window is 19 hours - out of hand. Working on a faster scheme - firewire backup. There was a problem with the failover - public machines were down for two hours.
- Mars network outage - the vending machines were not reporting to CNS -networking people were over here tracking down the problem.
- Cynthia - updating the East Florida Website with a template given to her by Erich. The searchable page is loading very slowly. Bill said he will take a look at the data structure on the search.
- Verify Patron - Geoffrey is testing it on public machines in Special Collections/MSL. Seems to be working well.
- DLC Tracker - ongoing; keep finding more bugs.
- Permission Description Database - Bill has been waiting to review it, but no one brings it to him. This week for sure. Martha is very interested in it.
- Ref Express - Chris is finding locations with hard-coded dates. "Closed for the Holidays" was set by hand. We have to turn the service on/off manually. The front page to Ref Express redirects you to a closed Web page. The dates are hard-coded and wrong. Bill suspects it may have something to do with some work Joe Aufmuth was doing at one time. There is a problem with the times that are listed.
- Tom is out all this week tending to his sick mother.
- Laurie Brennan's problem with NT8 seems to be resolved. She was unable to work on their Web site without slow response or timing out.