Page 1 of 2
0 new, 0 updated, anyone else getting the same?
Posted: Sun Jan 25, 2009 5:42 am
by 1974ER
Hello everyone!
My submissions from Jan 22nd, 13:10:48 and 16:00:00 show as processed Y and contain 0 new, 0 updated. Anybody else getting 0s?
Posted: Sun Jan 25, 2009 7:02 am
by Kerebo
its uploaded but data is not refreshed, give it some time.
Posted: Sun Jan 25, 2009 8:37 am
by 1974ER
Hi Kerebo!
Well, the problem is... there are already correct looking entries for me for the 23rd... and those two still show as double 0s...

Posted: Sun Jan 25, 2009 10:10 am
by Kerebo
hmm, actually have the same, but can me uploading twice before censusing more, one at night before bed and then at the morning. So mine is prolly user fault.
Posted: Sun Jan 25, 2009 10:47 am
by DM.
Rollie has halted processing for the time being until his performance improvements are in place. Those updates will eventually get processed.
Posted: Sun Jan 25, 2009 3:06 pm
by uigrad
As DM said, Rollie has temporarily put a hold on processing. He started a thread about it here:
http://www.warcraftrealms.com/forum/vie ... php?t=4169
He'll probably update that thread once all the changes are complete, but it may take a few more days, and then it might take a few days to catch up with all the submissions that have passed.
If you look again at your profile, there is a column for "Processed", and it contains 'Y' and 'N' for each of your submissions. The ones that say "0 0" are almost all listed as N (not processed yet). Once they have been processed, the 0's will change, and the N will change to Y.
Posted: Mon Jan 26, 2009 3:29 am
by 1974ER
Hi all!
Thanks for all comments.

The problem is still that those two submissions are showing Y (processed) and still contain 0 new, 0 updates. And there are a lot of correctly processed entries AFTER them (23rd to 25th)... So I am still wondering what is wrong with those two from 22nd.

Posted: Mon Jan 26, 2009 1:51 pm
by Dromic
Looking at other peoples uploads from the top 10 and most show the same thing. Not a great problem but at Jan 21, 2009 21:16 Rollie had warned the census had been stopped. Most likely that 3 hour period there was lost if the buffers overloaded.
I was doing a prune before each census run in the problem time. Reason was to make it easy on the server when it can back. Now rebuilding my normal /census prune 8.
The good news is the database is back and running at a good pace again. Before Rollie archived off all that data is was taking 18-24 hours to see updates.
________
Honda CR series history
Posted: Mon Jan 26, 2009 3:34 pm
by 1974ER
Hi Dromic (and everyone else too)!
Well, if you look at my OP and data... my problems are on the 22nd, not 21st. And to make the matter even more mysterious... according to the data available to me, YOU made a successful submission on the 22nd at 13:36:55. And that is BETWEEN the two from me that are showing double 0s. Naturally, it is theoretically possible that the database choked on two (or possibly more) occasions, but it is still very weird. :/
Last of all, big thank you to Rollie, it is nice that the data is again processed quickly!!!
Edit at (23:53 my local, 15:53 WCR time):

Not happy... my data just updated... my submission 26th, at 10:32:32 is now also showing double 0s and Y (processed) status.
Edit 2: Hmmm... this submission corrected itself...

Posted: Mon Jan 26, 2009 5:38 pm
by Dromic
1974ER wrote:Edit at (23:53 my local, 15:53 WCR time):

Not happy... my data just updated... my submission 26th, at 10:32:32 is now also showing double 0s and Y (processed) status.
Edit 2: Hmmm... this submission corrected itself...

Now that one can help you with easy. Show you the reason:
Jan 26, 09 11:59:20 0 0 Y
Jan 26, 09 10:32:32 87 774 Y
You notice that is only 33 minutes apart. There has to be 60 minutes between uploads or get 0 0 Y. But found it posted 15 minutes so will do a test to see if can do that without getting a 0 0 Y.
Update Jan 27, 09 9:47 GMT
Tested and it does take allow upload a lot faster now. So will leave the question with the experts of the database (Rollie )

________
vaporizer reviews
Posted: Mon Jan 26, 2009 6:52 pm
by Kerebo
15 mins between uploads, not one hour anymore
Posted: Tue Jan 27, 2009 2:16 am
by 1974ER
Hi all!
Further thanks on all answers... however...
Jan 26, 09 11:59:20 0 0 Y
Jan 26, 09 10:32:32 87 774 Y
That is actually a separation of 1 H and about 27 min, not 33 min...
My 26th is fully ok now. But those two from 22nd are still double 0s.
Jan 23, 09 03:37:40 705 2592 Y
Jan 22, 09 16:00:00 0 0 Y
Jan 22, 09 13:10:48 0 0 Y
Jan 22, 09 11:12:39 824 5038 Y
And as can be seen here, they do not break the rules, even if the limit was still 1 hour, so that does not explain it.
Posted: Wed Jan 28, 2009 1:12 am
by Rollie
I'll have to take a look to see if anything is amiss.
Posted: Wed Jan 28, 2009 2:48 am
by 1974ER
Thank you Rollie!
Please let us know, if you find out anything interesting.

Posted: Sat Jan 31, 2009 12:19 am
by 1974ER
No, no, no... /cry
Not again...

I am starting to really hate this...
Jan 29, 09 16:36:48 499 2402 Y
Jan 29, 09 14:26:39 0 0 Y
Jan 29, 09 13:17:47 280 1508 Y
Posted: Sat Jan 31, 2009 4:29 pm
by Rollie
I have added another option to the display. If the process failed for a file (for whatever reason), it will show with an 'E', as you file now does.
The most likely reasons for a file failing are either due to an incomplete file upload or the file was taking too long to parse so it was halted and moved to the next one.
Posted: Sun Feb 01, 2009 2:25 am
by 1974ER
Thank you for your trouble, Rollie!
The thing is... I remember absolutely nothing unusual about the 3 submissions that have gone wrong so far. They all gave the normal message, which displays after a successful upload, they were of similar size to files that were processed correctly, the submission times are not the deciding factor, because both myself and others can make successful submissions (see my earlier comment to Dromic)...
Posted: Tue Feb 03, 2009 2:06 am
by 1974ER
Well, well, well...
Jan 31, 09 11:57:59 523 3345 Y
Jan 31, 09 10:37:12 0 0 E
Jan 31, 09 09:20:22 495 1847 Y
The entry above also failed without any reason I could notice...

Well at least January is now completed. I am hoping February brings no further failures to me or anyone else.
Posted: Tue Feb 03, 2009 12:44 pm
by Rollie
I'll try to find time to check out why it would fail. The server has been doing some strange things lately so that could be the culprit.
Posted: Sat Feb 07, 2009 8:04 am
by Hybuir
GNOMES. GNOMES IN THE DATABASE. DAMN THEM GNOMES.