Sleuth Home - Message Boards - Sleuth Talk


0 0
Database cleanup
  <<First Page  |  <Previous  

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

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?

Lady Emerald Devon
Lady Emerald Devon
Nomad

Aug-24-2007 06:49

Oh Bla Di! Oh Bla Da! now my mail loads again.
Tra la la la la lah!

Thanks Ben :)

biggie528
biggie528
Lucky Stiff

Aug-25-2007 20:24

Who said Ben could sleep?

Blasphemy... ;)

Stooby
Stooby
Well-Connected

Aug-25-2007 23:19

Who said Ben could sleep, he's ignoring little Diego's late night cries! Poor Sunny doing all the work!

  <<First Page  |  <Previous  

[ You must login to reply ]