WarcraftReamls.com
  FAQFAQ    SearchSearch    MemberlistMemberlist    UsergroupsUsergroups   RegisterRegister 
  ProfileProfile    Log in to check your private messagesLog in to check your private messages    Log inLog in 
WR Updates, Not Updating (4.0.3a patch)
Goto page 1, 2  Next
 
Post new topic   Reply to topic    WarcraftRealms.com Forum Index -> WarcraftRealms.com Bugs
View previous topic :: View next topic  
Author Message
EpikPhailure



Joined: 09 Jun 2009
Posts: 60
Location: Havre Montana
WR Updates: 742,121
EpikPhailure WR Profile

PostPosted: Thu Nov 25, 2010 9:41 am    Post subject: WR Updates, Not Updating (4.0.3a patch) Reply with quote

OK, I am sure with the new census plus addon there are some bugs, however my uploads are not being counted.

Nov 25, 10 09:34:57 0 0 N
Nov 24, 10 17:55:47 0 0 N
Nov 24, 10 16:52:08 0 0 N
Nov 24, 10 13:00:10 0 0 N
Nov 24, 10 10:18:48 0 0 N
Nov 22, 10 16:10:27 0 0 N


I figured I would wait a couple of days before complaining...

/RollieSignal

(Oh yeah and I am back playing again LOL)
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
FuxieDK



Joined: 22 May 2008
Posts: 449
Location: Copenhagen, DK
WR Updates: 2,571,239
FuxieDK WR Profile

PostPosted: Thu Nov 25, 2010 10:51 am    Post subject: Reply with quote

We have a 100+ hours delay right now Sad
_________________
Doing census on various servers Wink
Back to top
View user's profile Send private message
EpikPhailure



Joined: 09 Jun 2009
Posts: 60
Location: Havre Montana
WR Updates: 742,121
EpikPhailure WR Profile

PostPosted: Thu Nov 25, 2010 10:53 am    Post subject: Reply with quote

Thanks for the reply!
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
EpikPhailure



Joined: 09 Jun 2009
Posts: 60
Location: Havre Montana
WR Updates: 742,121
EpikPhailure WR Profile

PostPosted: Fri Nov 26, 2010 12:25 pm    Post subject: Reply with quote

Well, I am pretty sure the site has stalled... still no updates proccessed.

Nov 26, 10 10:52:58 0 0 N
Nov 25, 10 22:35:55 0 0 N
Nov 25, 10 16:53:22 0 0 N
Nov 25, 10 11:18:40 0 0 N
Nov 25, 10 09:34:57 0 0 N
Nov 24, 10 17:55:47 0 0 N
Nov 24, 10 16:52:08 0 0 N
Nov 24, 10 13:00:10 0 0 N
Nov 24, 10 10:18:48 0 0 N
Nov 22, 10 16:10:27 0 0 N


/ROLLIESIGNAL
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Balgair
Araiceil


Joined: 30 Sep 2005
Posts: 1483
Location: UK
WR Updates: 10,829,931
Balgair WR Profile

PostPosted: Fri Nov 26, 2010 1:25 pm    Post subject: Reply with quote

It has indeed stalled, been sitting at the same date last processed for about 2 days now - Rollie made some changes a couple of days back to try and fix the backlog but it seems it's died entirely for the moment Confused
_________________
EU-Draenor:
-- Sagart - Tairbh - Buinne - Balgair - Eilnich - Ruire - Dubh - Laidir - Naomh --
Back to top
View user's profile Send private message
Rollie
Site Admin


Joined: 28 Nov 2004
Posts: 5374
Location: Austin, TX
WR Updates: 480,131
Rollie WR Profile

PostPosted: Fri Nov 26, 2010 8:00 pm    Post subject: Reply with quote

Yep, it's borked, I"m looking into it, was out a couple days for Thanksgiving
Back to top
View user's profile Send private message Visit poster's website
Rollie
Site Admin


Joined: 28 Nov 2004
Posts: 5374
Location: Austin, TX
WR Updates: 480,131
Rollie WR Profile

PostPosted: Fri Nov 26, 2010 8:09 pm    Post subject: Reply with quote

It should resume processing now, obviously will take some time to catch up, help me keep an eye on it to be sure it's actually catching up and not falling further behind =x
Back to top
View user's profile Send private message Visit poster's website
EpikPhailure



Joined: 09 Jun 2009
Posts: 60
Location: Havre Montana
WR Updates: 742,121
EpikPhailure WR Profile

PostPosted: Sat Nov 27, 2010 5:32 am    Post subject: Reply with quote

Rollie wrote:
It should resume processing now, obviously will take some time to catch up, help me keep an eye on it to be sure it's actually catching up and not falling further behind =x


Rollie! How are things?

Will keep an eye on it!
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Rollie
Site Admin


Joined: 28 Nov 2004
Posts: 5374
Location: Austin, TX
WR Updates: 480,131
Rollie WR Profile

PostPosted: Sat Nov 27, 2010 10:42 am    Post subject: Reply with quote

It's moving forward now at least =)
Back to top
View user's profile Send private message Visit poster's website
Rollie
Site Admin


Joined: 28 Nov 2004
Posts: 5374
Location: Austin, TX
WR Updates: 480,131
Rollie WR Profile

PostPosted: Sat Nov 27, 2010 10:46 am    Post subject: Reply with quote

Although it is only running at about 10 processed files per hour right now, which is waaaaay too slow. I will be watching to see how/if it speeds up as the cull process runs to reduce the size of the characters table.
Back to top
View user's profile Send private message Visit poster's website
EpikPhailure



Joined: 09 Jun 2009
Posts: 60
Location: Havre Montana
WR Updates: 742,121
EpikPhailure WR Profile

PostPosted: Sat Nov 27, 2010 5:34 pm    Post subject: Reply with quote

Rollie wrote:
Although it is only running at about 10 processed files per hour right now, which is waaaaay too slow. I will be watching to see how/if it speeds up as the cull process runs to reduce the size of the characters table.


How goes the battle?

Is it moving faster?
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
1974ER
Epic Censi


Joined: 07 Nov 2008
Posts: 723

WR Updates: 22,719,157
1974ER WR Profile

PostPosted: Sun Nov 28, 2010 1:58 am    Post subject: Reply with quote

Rollie might be able to supply a more comprehensive answer, but to me, it seems we are slowly weathering this storm as well. Queue seems to have shrunk from about 6 days 4+ hours to 5 days 17 hours. If I recall correctly, last time there was a major problem, it took more than 4 days after Rollie's repairs before the situation started to truely normalize.

So I would say: Early days, but looking good again. Smile
Back to top
View user's profile Send private message
EpikPhailure



Joined: 09 Jun 2009
Posts: 60
Location: Havre Montana
WR Updates: 742,121
EpikPhailure WR Profile

PostPosted: Sun Nov 28, 2010 8:25 am    Post subject: Reply with quote

Where Are you seeing the Queue numbers at and etc?
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
1974ER
Epic Censi


Joined: 07 Nov 2008
Posts: 723

WR Updates: 22,719,157
1974ER WR Profile

PostPosted: Sun Nov 28, 2010 8:28 am    Post subject: Reply with quote

http://www.warcraftrealms.com/dbstats.php

There you go. Very Happy
Back to top
View user's profile Send private message
EpikPhailure



Joined: 09 Jun 2009
Posts: 60
Location: Havre Montana
WR Updates: 742,121
EpikPhailure WR Profile

PostPosted: Sun Nov 28, 2010 8:33 am    Post subject: Reply with quote

Nice, Thanks!
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
ashyni



Joined: 29 May 2010
Posts: 1

WR Updates: 33,658
ashyni WR Profile

PostPosted: Tue Nov 30, 2010 8:26 pm    Post subject: Stats stalled out? Reply with quote

Last processed file was uploaded on 2010-11-26 09:45:05.
Current server time is 2010-11-30 20:25:11

From:
http://www.warcraftrealms.com/dbstats.php
Back to top
View user's profile Send private message
pencey



Joined: 28 Nov 2010
Posts: 28

WR Updates: 34,199
pencey WR Profile

PostPosted: Tue Nov 30, 2010 9:04 pm    Post subject: Reply with quote

on pace to be caught up in about 12 days by my math
in the past 30 hours, it's caught up about 11 hours.. 30/11*(current delay of 107 hours) = 291 hours = about 12 days
Back to top
View user's profile Send private message
EpikPhailure



Joined: 09 Jun 2009
Posts: 60
Location: Havre Montana
WR Updates: 742,121
EpikPhailure WR Profile

PostPosted: Tue Nov 30, 2010 9:08 pm    Post subject: Reply with quote

pencey wrote:
on pace to be caught up in about 12 days by my math
in the past 30 hours, it's caught up about 11 hours.. 30/11*(current delay of 107 hours) = 291 hours = about 12 days


Is that 12 days only if there are no newer uploads? Just curious
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
1974ER
Epic Censi


Joined: 07 Nov 2008
Posts: 723

WR Updates: 22,719,157
1974ER WR Profile

PostPosted: Wed Dec 01, 2010 5:38 pm    Post subject: Reply with quote

As far as I can reverse the math, Pencey was assuming the rate of catchup to be constant, which unfortunately isn't true as it depends on the amount and size of unprocessed submissions.

In other words, if submissions stopped completely, the time would be cut down, if the amount and size of submissions remained steady, the time would be fairly accurate and if there were a lot more and / or bigger files, the time would go up.
Back to top
View user's profile Send private message
pencey



Joined: 28 Nov 2010
Posts: 28

WR Updates: 34,199
pencey WR Profile

PostPosted: Wed Dec 01, 2010 8:12 pm    Post subject: Reply with quote

1974ER wrote:
As far as I can reverse the math, Pencey was assuming the rate of catchup to be constant, which unfortunately isn't true as it depends on the amount and size of unprocessed submissions.

In other words, if submissions stopped completely, the time would be cut down, if the amount and size of submissions remained steady, the time would be fairly accurate and if there were a lot more and / or bigger files, the time would go up.


correct. and i was hoping that over time, the fact that the rate of updates isn't constant wouldn't matter much (since it'd start to average out)

unfortunately, relative when I started keeping track (2010-11-29 15:02:30), we are now going negative, haven fallen from 117 hours behind to 121 hours behind.

this is due to the big stall last night, and the fact that it is currently processing the 'busy time' uploads for 2010-11-26 (~6pm when everyone is home playing and censusing). once it gets over this 'busy time' hump and into the nighttime updates, it'll catch up a bit..

anyway, it looks like, on a good day, it can catch up around 8 hours, so if it were 80 hours behind, it'd take roughly 10 days to catch up. we're looking at around 15 days right now... but maybe with the slowdown, people have been submitting less often, allowing it to catch up faster..

on the other hand.. with the release of cataclysm in a few days, there will be an explosion of low-level characters, which could slow the db down more (adding a new chars to the db will probably slow it down more than updating an existing char).. plus maybe people will come back to the game and start uploading censuses again, increasing load on the site..

so really i have no idea when it'll be caught up again Smile could be 10 days if all goes well.. or could be significantly longer.

rollie could put some sort of 'efficiency of upload' measure for files, dividing the number of new char updates the file generated by the time it took to process the file. if the efficiency number is low, the person uploading could see that they need to do something to make their uploads more efficient, such as perhaps pruning/purging more, or avoiding certain realms that are already well-censused. if the site detected that the currently processing file had an abnormally low efficiency after looking at x characters in the file, it could just stop processing the file and move on to the next one.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    WarcraftRealms.com Forum Index -> WarcraftRealms.com Bugs All times are GMT - 6 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
WarcraftRealms.com  


Powered by phpBB © 2001, 2005 phpBB Group