Submissions Temporarily Halted


    Send this topicPrint

Author Topic: Submissions Temporarily Halted  (Read 33973 times)

0 Members and 1 Guest are viewing this topic.

Offline hfactor66

  • 0p on Rings in SRA! :D
  • TMSC Profile
  • win10 firefox
  • Posts: 169
  • I have a crush on Amy Rose…
    • View Profile
Re: Submissions Temporarily Halted
« Reply #30 on: October 12, 2014, 09:53:26 PM »
These






The good news is these duplicated stats were not caused by this issue. There's a known bug where suspending all of a users' stats does not suspend their sitewide score.

I'm going to do a backup of the database, and then re-enable submissions. Hopefully nothing will break. :)

EDIT: Submissions are up. \o/
TO SUBMISSIONS!!!

Offline GerbilSoft

Re: Submissions Temporarily Halted
« Reply #31 on: October 12, 2014, 10:27:41 PM »
Unfortunately it still seems to be broken. Some newly-submitted stats are showing the wrong queue entry.

Offline GerbilSoft

Re: Submissions Temporarily Halted
« Reply #32 on: October 12, 2014, 10:44:46 PM »
It seems that some newly-submitted stats had out-of-range stat ID numbers. I'm going to go through the code tomorrow to figure out why this is happening.

I tested it with a single stat for SA2 and that seems to have worked correctly, so maybe it only triggers with large batches.

EDIT: I'll need two or more people who have stats to submit to be in #soniccenter tomorrow (2014/10/13) at around 8 PM 9 PM EDT in order to test the submissions system. (If you submitted stats after I re-enabled submissions earlier today, those stats were deleted due to the rollback. You can help me figure out what's going on by going to #soniccenter tomorrow.)

EDIT 2: [2014/10/13 11:31 AM EDT] I won't be home until around 8:40 PM, so I'll be doing tests at 9 PM tonight.

EDIT 3: [2014/10/13 08:32 PM EDT] Make that 10 PM; extra stuff came up.
« Last Edit: October 13, 2014, 08:32:32 PM by GerbilSoft »

Offline GerbilSoft

Re: Submissions Temporarily Halted
« Reply #33 on: October 13, 2014, 09:47:03 PM »
Looks like there won't be enough people around with stats tonight.

I'll be home at around 9-9:30 PM tomorrow (2014/10/14). I need at least two or three people with multiple stats to submit.

Offline hfactor66

  • 0p on Rings in SRA! :D
  • TMSC Profile
  • win10 firefox
  • Posts: 169
  • I have a crush on Amy Rose…
    • View Profile
Re: Submissions Temporarily Halted
« Reply #34 on: October 13, 2014, 09:48:57 PM »
Looks like there won't be enough people around with stats tonight.

I'll be home at around 9-9:30 PM tomorrow (2014/10/14). I need at least two or three people with multiple stats to submit.
If you're looking for people with stat to submit I've got about 20-30+ stats to submit. lol I've been buuuusy...

Offline GerbilSoft

Re: Submissions Temporarily Halted
« Reply #35 on: October 13, 2014, 09:50:30 PM »
Looks like there won't be enough people around with stats tonight.

I'll be home at around 9-9:30 PM tomorrow (2014/10/14). I need at least two or three people with multiple stats to submit.
If you're looking for people with stat to submit I've got about 20-30+ stats to submit.
Can you go to #soniccenter ?

Offline hfactor66

  • 0p on Rings in SRA! :D
  • TMSC Profile
  • win10 firefox
  • Posts: 169
  • I have a crush on Amy Rose…
    • View Profile
Re: Submissions Temporarily Halted
« Reply #36 on: October 13, 2014, 09:51:51 PM »
Looks like there won't be enough people around with stats tonight.

I'll be home at around 9-9:30 PM tomorrow (2014/10/14). I need at least two or three people with multiple stats to submit.
If you're looking for people with stat to submit I've got about 20-30+ stats to submit.
Can you go to #soniccenter ?
where can I find #soniccenter? :/ I'd be happy to help if I can find it

Offline hfactor66

  • 0p on Rings in SRA! :D
  • TMSC Profile
  • win10 firefox
  • Posts: 169
  • I have a crush on Amy Rose…
    • View Profile
Re: Submissions Temporarily Halted
« Reply #37 on: October 13, 2014, 09:54:46 PM »
Click

You just need a username, and you should get there instantly.
thanks :)

Offline GerbilSoft

Re: Submissions Temporarily Halted
« Reply #38 on: October 13, 2014, 10:06:55 PM »
Looks like this batch of submissions worked. Still not sure why the previous one borked horribly.

I'll still need to do more testing, so get some more stats ready for tomorrow at around 9:30 PM EDT. (I'll also get the stats I saved from before that had to be deleted due to the queue table shenanigans.)

Re: Submissions Temporarily Halted
« Reply #39 on: October 13, 2014, 11:23:07 PM »
I've got multiple stats to submit, and will be around at that time tomorrow if it'll help.

Re: Submissions Temporarily Halted
« Reply #40 on: October 14, 2014, 12:22:03 AM »
If you need stats then i'll be able to help out. I should be around

Offline GerbilSoft

Re: Submissions Temporarily Halted
« Reply #41 on: October 14, 2014, 10:00:51 PM »
Looks like submissions are working well in limited testing. Tomorrow I'll do a full backup and re-enable submissions globally again.

Re: Submissions Temporarily Halted
« Reply #42 on: October 21, 2014, 02:04:57 AM »
Nice work on getting the site fixed up GerbilSoft! =) (with nearly 300 stats submitted in 3hrs-without errors, it’s safe to say you’ve fixed it! :D )

Offline CriticalCyd

  • ~('w')~ ~('w')~ ~('w')~
  • TMSC Profile
  • win7 chrome
  • Posts: 60
  • =^● ⋏ ●^=
    • View Profile
    • My twitch stream
Re: Submissions Temporarily Halted
« Reply #43 on: October 21, 2014, 07:33:05 AM »
Nice job Gerbil. From what I've heard time was a resource you had little of, but in the end you still got this thing up and running again, so thanks for the hard work!

Offline GerbilSoft

Re: Submissions Temporarily Halted
« Reply #44 on: October 22, 2014, 12:21:36 AM »
TSC is back up, along with submissions. The problem this morning was a failing HDD in the server's RAID-1 array, combined with a stupid RAID controller that doesn't handle it gracefully. The HDD has been replaced.

If anyone encounters any issues with submissions not being processed, please let me know immediately. (either here or on #soniccenter)
« Last Edit: October 22, 2014, 12:36:34 AM by GerbilSoft »

Re: Submissions Temporarily Halted
« Reply #45 on: October 23, 2014, 12:24:12 AM »
legit. Thanks a lot for the hard work gerbil!!! I've heard there were a lot more issues than it seemed from the outside so I really appreciate it!
Youtube - youtube.com/user/kirbymastah1991
Twitch Stream - twitch.tv/kirbymastah

Offline SB737

  • I make Minecraft videos for a living
  • Broseidon
  • TMSC Profile
  • win10 chrome
  • Posts: 506
  • 6th Sitewide :)
    • View Profile
Re: Submissions Temporarily Halted
« Reply #46 on: October 23, 2014, 08:58:02 AM »
Hey gerbil thanks for fixing TSC, I know you don't have much free time so I personally appreciate the work you put it into sorting it out :)
Current Championships: Sonic 3, Sonic & Knuckles
Former Championships: Sonic Lost World 3DS, Sonic 1 2013, Sonic 2 2013, Sonic 1 GBA, Sonic Generations, Sonic Pocket Adventure

<CodeGirl> [-New Record-] Zeupar got 1:21:25 on SAdva / Times / Egg Rocket 1 (Tails)
<SonicBoom737> I hate you Zeupar
<Zeupar> I love you SonicBoom737, though <3

    Send this topicPrint
 

Hits: 308 | Hits This Month: 2 | DB Calls: 8 | Mem Usage: 6.87 MB | Time: 0.12s | Printable

The Sonic Center v3.9
Copyright 2003-2011 by The Sonic Center Team.