0 new, 0 updated, anyone else getting the same?

General Discussion Area
1974ER
Epic Censi
Posts: 762
Joined: Fri Nov 07, 2008 3:30 am

0 new, 0 updated, anyone else getting the same?

Post 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?

Kerebo
Superior Census Taker
Posts: 37
Joined: Mon Nov 27, 2006 4:49 pm

Post by Kerebo »

its uploaded but data is not refreshed, give it some time.

1974ER
Epic Censi
Posts: 762
Joined: Fri Nov 07, 2008 3:30 am

Post 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... :(

Kerebo
Superior Census Taker
Posts: 37
Joined: Mon Nov 27, 2006 4:49 pm

Post 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.

User avatar
DM.
Census Taker
Posts: 1130
Joined: Mon Oct 03, 2005 12:27 pm
Location: Toronto, Canada

Post by DM. »

Rollie has halted processing for the time being until his performance improvements are in place. Those updates will eventually get processed.
Image
Click my sig

uigrad
Posts: 108
Joined: Tue Dec 20, 2005 12:26 am
Location: Illinois

Post 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.

1974ER
Epic Censi
Posts: 762
Joined: Fri Nov 07, 2008 3:30 am

Post by 1974ER »

Hi all!

Thanks for all comments. :D 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. :(

Dromic
Posts: 126
Joined: Tue Jul 17, 2007 11:07 am
Location: 3rd Rock from the Sun
Contact:

Post 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
Last edited by Dromic on Fri Feb 04, 2011 12:00 pm, edited 1 time in total.

1974ER
Epic Censi
Posts: 762
Joined: Fri Nov 07, 2008 3:30 am

Post 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!!! :D

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... :D

Dromic
Posts: 126
Joined: Tue Jul 17, 2007 11:07 am
Location: 3rd Rock from the Sun
Contact:

Post 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... :D
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 ) 8)
________
vaporizer reviews
Last edited by Dromic on Fri Feb 04, 2011 12:00 pm, edited 4 times in total.

Kerebo
Superior Census Taker
Posts: 37
Joined: Mon Nov 27, 2006 4:49 pm

Post by Kerebo »

15 mins between uploads, not one hour anymore

1974ER
Epic Censi
Posts: 762
Joined: Fri Nov 07, 2008 3:30 am

Post 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... :D

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.

User avatar
Rollie
Site Admin
Posts: 4783
Joined: Sun Nov 28, 2004 11:52 am
Location: Austin, TX
Contact:

Post by Rollie »

I'll have to take a look to see if anything is amiss.
phpbb:phpinfo()

1974ER
Epic Censi
Posts: 762
Joined: Fri Nov 07, 2008 3:30 am

Post by 1974ER »

Thank you Rollie!

Please let us know, if you find out anything interesting. :)

1974ER
Epic Censi
Posts: 762
Joined: Fri Nov 07, 2008 3:30 am

Post 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

User avatar
Rollie
Site Admin
Posts: 4783
Joined: Sun Nov 28, 2004 11:52 am
Location: Austin, TX
Contact:

Post 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.
phpbb:phpinfo()

1974ER
Epic Censi
Posts: 762
Joined: Fri Nov 07, 2008 3:30 am

Post 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)...

1974ER
Epic Censi
Posts: 762
Joined: Fri Nov 07, 2008 3:30 am

Post 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.

User avatar
Rollie
Site Admin
Posts: 4783
Joined: Sun Nov 28, 2004 11:52 am
Location: Austin, TX
Contact:

Post 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.
phpbb:phpinfo()

Hybuir
Gear Dependent Squirrel
Gear Dependent Squirrel
Posts: 1471
Joined: Tue Sep 06, 2005 6:22 am
Location: Austin, TX
Contact:

Post by Hybuir »

GNOMES. GNOMES IN THE DATABASE. DAMN THEM GNOMES.

Post Reply