Sleuth Home - Message Boards - Sleuth Talk


0 0
Database cleanup
  <<First Page  |  <Previous Next>  |  Last Page>>  

Sleuth Admin
Sleuth Admin
Tale Spinner

Aug-23-2007 02:20

I ran a database cleanup job around midnight, Thursday morning 8/23. Hopefully this will speed things up a bit, as I know the server has been lagging a bit.

The last time I ran a similar script, some stored case files became corrupted and were unplayable. I think I've ironed out those wrinkles, but let me know if you spot something like that, or something else seems wrong today.

Thanks.


Replies

Sleuth Admin
Sleuth Admin
Tale Spinner

Aug-23-2007 11:10

I love all those exclamation marks!!!! That's how I know a thread is well received.

Sorry for the late reply. I was up until 3am last night working on this cleanup process and thought everything was ok when I went to sleep. (ok, before I got up to change diapers three times).

Everybody's daily cases should now be available, and little jobs should be there for people who couldn't access them.

In accordance with our subscription policy, all current subscribers have had a full day added to their subscriptions.

Let me know if you spot any problems with case files (either agency or apartment).


Brasco De Gama
Brasco De Gama
Old Shoe

Aug-23-2007 11:27

The cases in my apartment have been corrupted too. :(

roamie
roamie
Well-Connected

Aug-23-2007 11:41

Thanks for cleaning things up Ben. I dont mind losing a few cases if things move faster around here!!!!!!!!!!!!!!!!!!!!!!!

**lots of exlamation marks for the Sleuth Gods**

Deborha Lee
Deborha Lee

Aug-23-2007 11:48

New one, Ben. I was trying to start a new case in a new villain hunt that I just got. :P This page came up which read:

Spyce exception
File: /var/www/html/case/new.spy
Message:

TypeError: unsubscriptable object

Stack: /var/www/html/common/py/intro.py:68, in load_random:


self.detectiveid = int(result[0])

new.spy:38, in (main):


intro.load_random(db,detective.city,(mystery_difficulty==0))

lilangel
lilangel
Sleuth About Town

Aug-23-2007 12:45

I got a similar message around 3 am my time, that was when Ben was working on the clean up... and seeing as how other members of my agency as well as myself have been able to store files and solve cases before I got back on and while I'm still on... I've been here for about an hour or so, but when Ben first got the site up again, I saw I had 12 cases, I didn't try doing them or checking everything else considering I was tired and went to bed sometime after 4 am my time.

and as to further notice, It would be nice considering I don't always read boards anymore and I was online when the clean up started. I don't know what or if I had lost anything, obviously I'm not that concerned. I just saw that it was planned and went to do something else on my computer.

Angel

Sleuth Admin
Sleuth Admin
Tale Spinner

Aug-23-2007 12:49

Hold on to any corrupted case files. I'm should be able to fix those. It may take a few hours though.

lilangel
lilangel
Sleuth About Town

Aug-23-2007 13:08

Oh whew... I was beginning to think that we were having a strange problem, as mine just started, of course I didn't look at any files that was already in there and got an error message.

Sleuth Admin
Sleuth Admin
Tale Spinner

Aug-23-2007 17:28

Alright, those casefiles should all be working now.

I'm going to go sleep for awhile.


lilangel
lilangel
Sleuth About Town

Aug-23-2007 18:12

Affirmative on the files working again.

Deborha Lee
Deborha Lee

Aug-24-2007 01:51

Great job, Ben! The server is running wonderfully!! :)

I just got that message once, then tried again and it was a go. Since I'm away from my agency, I missed out on the checking of case files, but I'm sure there's no worry now. :)

Lots of smily faces are annoying, but a good sign, eh?

  <<First Page  |  <Previous Next>  |  Last Page>>  

[ You must login to reply ]