#1 Posted by pikahyper (11367 posts) - - Show Bio

I've been getting a lot of 500 errors on volume pages for about a week now, tried the same pages on multiple computers always getting 500 errors, the two most recent are The Crow: Midnight Legends and Doctor Who.

Moderator
#2 Edited by Rorie (816 posts) - - Show Bio

Hmm, yeah they're bugging out for me as well. I'll file a bug and see if the engineers can find anything systemic that might be causing this. Otherwise, post any other volume links that you see with the same error and we'll see about fixing them manually. Thanks!

Staff
#3 Posted by pikahyper (11367 posts) - - Show Bio

@rorie: I can visit that Doctor Who page now but not the other. I found Star Trek and Transformers: Robots in Disguise as well, oddly enough all the volume pages that I found last night with 500 errors are all volumes published by IDW even though I was on over a hundred volume pages last night, it wasn't every IDW volume I looked at though, I don't really see how volumes attached to a single publisher could cause such a bug but I dunno maybe that can help them narrow something down.

Moderator
#4 Posted by pikahyper (11367 posts) - - Show Bio
Moderator
#5 Edited by johnkmccubbin91 (3486 posts) - - Show Bio

I've been having the same bugs but for Superman: Secret Origin and Wonder Girl bit annoying as I was hoping to review Superman Secret Origin : ( That's life though.

Edit: Slightly scrap that. Superman worked when I opened the link here, but it still doesn't work on the search link. This no longer affects me as I'll keep the page open, but just though I'd inform for others.

#6 Edited by pikahyper (11367 posts) - - Show Bio

@johnkmccubbin91: I get 500 errors on both of those, if you want it for reviews though search for the specific issue, adding the pound sign will switch to issue searching and you can go directly to the issue instead of the volume page.

Moderator
#7 Posted by johnkmccubbin91 (3486 posts) - - Show Bio

@pikahyper: Thanks for that didn't know about that : )

#8 Posted by pikahyper (11367 posts) - - Show Bio
Moderator
#9 Posted by Mr. Messy Face (119 posts) - - Show Bio

I've been having a lot of problems with this over the last week or so and it's been a lot of different volumes. I found that some of them could be fixed by adding a '-' where one is missing but some of them have no place to put one without it being completely wrong.

#10 Edited by wmwadeii (3191 posts) - - Show Bio
#11 Posted by pikahyper (11367 posts) - - Show Bio

@rorie: any update on this? almost all of the reported pages are still not viewable.

Moderator
#12 Posted by Saren (25223 posts) - - Show Bio
Moderator Online
#13 Posted by SmashBrawler (5419 posts) - - Show Bio
#14 Posted by Rorie (816 posts) - - Show Bio

@pikahyper: I issued a bug, but haven't seen any updates. We've all been off since Wednesday, so I doubt anything will happen until Monday at the earliest.

Staff
#15 Edited by pikahyper (11367 posts) - - Show Bio

@rorie: whatever it is it is getting worse, at least half the existing volumes I go to these days are showing 500 errors, this might be seen as a small problem but this could be having a negative impact on CV's search engine rankings.

Moderator
#16 Posted by Squalleon (4041 posts) - - Show Bio
#17 Posted by Zauberin (4194 posts) - - Show Bio

I've been getting this while trying to log in, after entering my username and password. Firefox, and I also use Chrome, but I was already in and I don't want to log out and then not be able to get back.

#18 Posted by akbogert (3180 posts) - - Show Bio

I can't give any helpful specifics but I've had trouble loading most pages (or even getting the homepage to open) on and off for the last hour or so. Several times I didn't even get to the 500 page, but I did hit it at least once.

#19 Posted by _Grifter_ (10883 posts) - - Show Bio

What Zauberin and akbogert said.

Online
#20 Edited by pikahyper (11367 posts) - - Show Bio

@rorie: Did a push go out around 4:30PM PST? since then the site has been on and off down since, someone is still in the office working on this right?

Moderator
#21 Posted by ShadowSwordmaster (11409 posts) - - Show Bio

Glad I'm not the only one.

#22 Edited by Pro_Nelson (1503 posts) - - Show Bio

I was scurred. Like an hour ago I thought the whole site crashed.

#23 Posted by etragedy (1042 posts) - - Show Bio

@akbogert said:

I can't give any helpful specifics but I've had trouble loading most pages (or even getting the homepage to open) on and off for the last hour or so. Several times I didn't even get to the 500 page, but I did hit it at least once.

This happened to me too.

#24 Posted by akbogert (3180 posts) - - Show Bio

Not sure if related or separate issue, but my notifications no longer seem to work either. None of the mentions of me in the last couple hours have generated notifications. Of course it's a minor miracle I was able to view the pages on which I was mentioned in the first place, haha.

#25 Edited by pikahyper (11367 posts) - - Show Bio

I was scurred. Like an hour ago I thought the whole site crashed.

whole site did crash, GB too.

Moderator
#26 Posted by akbogert (3180 posts) - - Show Bio

@pro_nelson said:

I was scurred. Like an hour ago I thought the whole site crashed.

whole site did crash, GB too.

I actually presumed it was the other way around. With the tragedy GB faced today, I imagine their site traffic was inordinately high.

#27 Posted by DonFelipe (1096 posts) - - Show Bio

It seems to be a totally random error in terms of what volumes are affected or not - old and new, different publishers (though I have not seen any affected Marvel volume yet), number of issues listed (less and more). The only patterns is it only affects some volume and no other pages.

It's a mystery!

#28 Posted by pikahyper (11367 posts) - - Show Bio

@akbogert: I don't think it was traffic, pretty sure it was an update that was pushed out, it was fixed after an hour and a half but it looks like some other stuff got broken.

Anyways the site problems yesterday are not what this thread was about so time to get it back on track.

Moderator
#29 Posted by pikahyper (11367 posts) - - Show Bio

@donfelipe: hmm you are right, I have yet to land on a Marvel volume that produced a 500 error since this started, so far it has been Dark Horse, Viz, DC, IDW, Dynamite, Boom and Vertigo, don't think I've seen it happen with any other publishers yet.

Moderator
#30 Posted by Rorie (816 posts) - - Show Bio

Sorry for the errors, but it helps to get these examples. The engineers are looking into it. Likely some kind of database error; hopefully it'll be fixed soon.

Staff
#31 Posted by mrpibb (491 posts) - - Show Bio

The volumes should be working now. Turns out some of the larger lists associated with those volumes were taking longer then we expected.

Staff
#32 Posted by pikahyper (11367 posts) - - Show Bio

Looks good, slow loading but good.

Moderator
#33 Edited by mrpibb (491 posts) - - Show Bio

yeah, a fix is forthcoming for the slowness.

Staff
#34 Posted by pikahyper (11367 posts) - - Show Bio

sweet

Moderator
#35 Posted by DonFelipe (1096 posts) - - Show Bio
@mrpibb said:

The volumes should be working now. Turns out some of the larger lists associated with those volumes were taking longer then we expected.

Thanks for fixing the volume pages.

Wow! Some of those lists have +10k list items; for instance the first 2 lists associated with DC comics presents Metal Men. I think there should be a maximum number for list items. These lists don't make sense. It takes ages to browse such long lists in this format. Maybe it's just me preferring small lists. Anyhow, I think the performance problem here has something to do with a bad query (join) selecting and caching too much data at once that isn't necessarily needed for the view/page.