Bitcoin Forum

Other => Meta => Topic started by: Holliday on December 22, 2013, 06:44:46 PM



Title: Database errors when replying and general forum sluggishness.
Post by: Holliday on December 22, 2013, 06:44:46 PM
.



Title: Re: Database errors when replying and general forum sluggishness.
Post by: QuestionAuthority on December 22, 2013, 07:03:38 PM
502 Bad Gateway

What....the fuck......is up?


Title: Re: Database errors when replying and general forum sluggishness.
Post by: QuestionAuthority on December 22, 2013, 07:09:12 PM

Database access is completely screwed. I can't even switch between pages now!


Title: Re: Database errors when replying and general forum sluggishness.
Post by: hilariousandco on December 22, 2013, 08:02:33 PM
502 Bad Gateway

What....the fuck......is up?

Yeah, was getting this intermittently a lot earlier, but it's slowed down now. 


Title: Re: Database errors when replying and general forum sluggishness.
Post by: bitpop on December 22, 2013, 08:24:47 PM
2 days now


Title: Re: Database errors when replying and general forum sluggishness.
Post by: jojo69 on December 22, 2013, 08:34:13 PM
almost goxlike


Title: Re: Database errors when replying and general forum sluggishness.
Post by: QuestionAuthority on December 22, 2013, 08:35:17 PM
502 Bad Gateway

What....the fuck......is up?

Yeah, was getting this intermittently a lot earlier, but it's slowed down now. 



It hasn't slowed up for me. I'm still getting it sporadically. It is usually revolved around posting or refreshing a page.

BTW: I've written this post twice now and it's damn annoying.

Three times cut and paste to answer.

Four times.

Five times....ok this is pissing me off now.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: guybrushthreepwood on December 22, 2013, 08:56:18 PM
I have also been getting a lot of those posting errors and report to administration pages.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: jojo69 on December 22, 2013, 11:56:32 PM
for fucks' sake


Title: Re: Database errors when replying and general forum sluggishness.
Post by: bitpop on December 22, 2013, 11:58:30 PM
Come on


Title: Re: Database errors when replying and general forum sluggishness.
Post by: Kluge on December 23, 2013, 12:50:41 AM
What others said. Has been bad for past 2-3 days, but db error frequency has been particularly severe today. Have been surprised to not see a notice up on Reddit page.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: theymos on December 23, 2013, 02:34:34 AM
I changed some things. Hopefully it's improved now.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: QuestionAuthority on December 23, 2013, 07:07:07 AM
It seems much improved. Thanks


Title: Re: Database errors when replying and general forum sluggishness.
Post by: bitpop on December 23, 2013, 02:14:39 PM
Much better
Wish we could afford xeround mysql


Title: Re: Database errors when replying and general forum sluggishness.
Post by: guybrushthreepwood on December 23, 2013, 03:51:56 PM
Yup, fine for me now.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: niktitan132 on December 23, 2013, 10:48:23 PM
I got a error few minutes ago.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: insertcoolusername on December 23, 2013, 10:50:07 PM
I got this error also just a few minutes ago.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: QuestionAuthority on December 23, 2013, 10:50:49 PM
Just happened to me again. Growing pains?


Title: Re: Database errors when replying and general forum sluggishness.
Post by: jackjack on December 23, 2013, 11:01:52 PM
Currently 80% of requests end in a 502 error


Title: Re: Database errors when replying and general forum sluggishness.
Post by: jojo69 on December 23, 2013, 11:18:40 PM
server melting load volumes I am sure


Title: Re: Database errors when replying and general forum sluggishness.
Post by: QuestionAuthority on December 29, 2013, 10:04:03 PM

502 Bad Gateway

Again today.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: niktitan132 on December 29, 2013, 10:04:47 PM

502 Bad Gateway

Again today.

Wanted to say the same.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: whiskers75 on December 30, 2013, 02:22:17 PM
None of this here.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: rarkenin on December 30, 2013, 05:45:02 PM
The forum 502s roughly 17 minutes before the launch of a highly popular coin. DDoS? Or just people clocking refresh every 15 seconds?

Honestly, I wouldn't mind a read-only cloudflare-based proxy as long as there's no chance to post or login there.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: Welsh on December 30, 2013, 05:45:42 PM
I've also had problems resulting in 80-90% requests ending up with a 502 error.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: hilariousandco on December 30, 2013, 06:42:09 PM
Been having a lot of problems the past hour or so. Couldn't even get on to the website for about 30 mins. 

The forum 502s roughly 17 minutes before the launch of a highly popular coin. DDoS? Or just people clocking refresh every 15 seconds?


 What coin is that?


Title: Re: Database errors when replying and general forum sluggishness.
Post by: Reece523 on December 30, 2013, 07:16:41 PM
I'm curious as to whether it is a DDoS or growing pains as well. I have noticed at times that Cryptsy and BitcoinTalk have been down simultaneously though I'm not sure which would explain that occurence -- clearly either could :(


The forum 502s roughly 17 minutes before the launch of a highly popular coin. DDoS? Or just people clocking refresh every 15 seconds?

Honestly, I wouldn't mind a read-only cloudflare-based proxy as long as there's no chance to post or login there.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: nahtnam on December 30, 2013, 08:38:09 PM
Same for me. Every other page gives me 502 error. I can barely even post! I doubt I will even be able to post this.  :-\


Title: Re: Database errors when replying and general forum sluggishness.
Post by: Welsh on December 30, 2013, 08:48:49 PM
Website seems to be running a little faster now. Fewer errors and faster response times. When I initially was having problems the server response was: 3800.01 ms it's now at 1063.78 ms. Which is a dramatic improvement.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: nahtnam on December 30, 2013, 08:54:00 PM
Website seems to be running a little faster now. Fewer errors and faster response times. When I initially was having problems the server response was: 3800.01 ms it's now at 1063.78 ms. Which is a dramatic improvement.

Yep. The post that I made above was my first actual post that went through.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: Walking Glitch on December 30, 2013, 09:05:09 PM
So this in addition to the broke-ass image proxy? Nice...


Title: Re: Database errors when replying and general forum sluggishness.
Post by: hilariousandco on December 30, 2013, 10:03:14 PM
Seems to be picking up a bit now. Wonder if it was a ddos or just a lot of users logging on (or at least trying to).


Title: Re: Database errors when replying and general forum sluggishness.
Post by: nahtnam on December 30, 2013, 10:32:53 PM
Seems to be picking up a bit now. Wonder if it was a ddos or just a lot of users logging on (or at least trying to).

Most likely ddos'ers


Title: Re: Database errors when replying and general forum sluggishness.
Post by: hilariousandco on January 03, 2014, 04:45:02 PM
Sites been running pretty slow for me the past few hours and a lor of 502 errors again.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: QuestionAuthority on January 03, 2014, 05:13:54 PM
Sites been running pretty slow for me the past few hours and a lor of 502 errors again.

Yep, started again for me too.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: guybrushthreepwood on January 03, 2014, 05:17:02 PM
Sites been running pretty slow for me the past few hours and a lor of 502 errors again.

Yep, started again for me too.

Same. Probably all the media interest from the Coinye West coin  :D.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: Bobs Yerunkle on January 03, 2014, 07:13:34 PM
See this fellow a lot today.

502 Bad Gateway


Title: Re: Database errors when replying and general forum sluggishness.
Post by: Bobs Yerunkle on January 03, 2014, 07:14:16 PM
See this fellow a lot today.

502 Bad Gateway


In fact, as I posted that post I saw it.
So meta.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: QuestionAuthority on January 03, 2014, 08:08:00 PM
See this fellow a lot today.

502 Bad Gateway


In fact, as I posted that post I saw it.
So meta.

Maybe 502 Bad Gateway is the new name of the forum. Is there a new coin called "Bad Gateway"?


Title: Re: Database errors when replying and general forum sluggishness.
Post by: LitecoinRates on January 03, 2014, 08:12:21 PM
Forum is growing rapidly with 31,775 new members in December and 65,132,393 page views per month so depends if admin is investing in HW upgrade to cope, seems not.

I would think there must be a way to cache some of the content to cope better with all the page refreshes everyone does.




Title: Re: Database errors when replying and general forum sluggishness.
Post by: smeagol on January 03, 2014, 09:21:18 PM
Still getting the error a lot...


Title: Re: Database errors when replying and general forum sluggishness.
Post by: jackjack on January 03, 2014, 10:24:00 PM
So many 502s
It's getting worse and worse


Title: Re: Database errors when replying and general forum sluggishness.
Post by: nahtnam on January 03, 2014, 10:35:31 PM
So many 502s
It's getting worse and worse

Yes it is. Every other page gives me a 502. I guess if we wait it will go away.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: deepceleron on January 03, 2014, 10:43:14 PM
Gar. 502 error ate my top post, and it took five minutes to navigate here to complain. Another DDoS?


Title: Re: Database errors when replying and general forum sluggishness.
Post by: Lethn on January 03, 2014, 10:44:40 PM
This is what happened when they were attacked before, not much we can do on our end since it's just a forum, I'm getting it too.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: MiningBuddy on January 03, 2014, 10:59:07 PM
I guess it had something to do with this:
I've had to totally disable this feature. I will fix it in a few days.

Seems to be running a lot better right now either way.  :)


Title: Re: Database errors when replying and general forum sluggishness.
Post by: nahtnam on January 04, 2014, 12:11:02 AM
I guess it had something to do with this:
I've had to totally disable this feature. I will fix it in a few days.

Seems to be running a lot better right now either way.  :)

What is "THIS FEATURE"?


Title: Re: Database errors when replying and general forum sluggishness.
Post by: BadBear on January 04, 2014, 12:14:00 AM
Ignore coloring.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: deepceleron on January 04, 2014, 12:14:09 AM
I guess it had something to do with this:
I've had to totally disable this feature. I will fix it in a few days.

Seems to be running a lot better right now either way.  :)

What is "THIS FEATURE"?
Coloring the word "ignore" with a darker color when a user is ignored by many people.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: nahtnam on January 04, 2014, 12:17:40 AM
I guess it had something to do with this:
I've had to totally disable this feature. I will fix it in a few days.

Seems to be running a lot better right now either way.  :)

What is "THIS FEATURE"?
Coloring the word "ignore" with a darker color when a user is ignored by many people.

I dont see how such a small error can make such a big difference.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: btcton on January 04, 2014, 12:44:47 AM
I was getting it with a 50% frequency a few days ago. I am still getting it today, but not as much as before.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: deepceleron on January 04, 2014, 12:59:29 AM
Coloring the word "ignore" with a darker color when a user is ignored by many people.
I dont see how such a small error can make such a big difference.
If the feature was written as:
-For every thread page of 20 posts that someone views:
 -for every user that posted:
  -look through every other user's ignore list and add up the times that user has been ignored

it certainly could cause server load. If it comes back, it would probably not be a "live" statistic, but one that is compiled nightly per-user.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: MiningBuddy on January 04, 2014, 01:10:01 AM
I guess it had something to do with this:
I've had to totally disable this feature. I will fix it in a few days.

Seems to be running a lot better right now either way.  :)

What is "THIS FEATURE"?
FYI: Clicking a quote title will take you to the appropriate thread where the post was quoted from (quotes can be edited so this may not always run true)


Title: Re: Database errors when replying and general forum sluggishness.
Post by: nahtnam on January 04, 2014, 01:14:32 AM
I guess it had something to do with this:
I've had to totally disable this feature. I will fix it in a few days.

Seems to be running a lot better right now either way.  :)

What is "THIS FEATURE"?
FYI: Clicking a quote title will take you to the appropriate thread where the post was quoted from (quotes can be edited so this may not always run true)

Ahhhh, that helps a lot. Thanks.


Title: Re: Database errors when replying and general forum sluggishness.
Post by: nahtnam on January 04, 2014, 01:15:32 AM
Coloring the word "ignore" with a darker color when a user is ignored by many people.
I dont see how such a small error can make such a big difference.
If the feature was written as:
-For every thread page of 20 posts that someone views:
 -for every user that posted:
  -look through every other user's ignore list and add up the times that user has been ignored

it certainly could cause server load. If it comes back, it would probably not be a "live" statistic, but one that is compiled nightly per-user.

That totally makes sense. Why add this feature if it was soooo resource intensive?


Title: Re: Database errors when replying and general forum sluggishness.
Post by: MiningBuddy on January 04, 2014, 01:24:20 AM
Coloring the word "ignore" with a darker color when a user is ignored by many people.
I dont see how such a small error can make such a big difference.
If the feature was written as:
-For every thread page of 20 posts that someone views:
 -for every user that posted:
  -look through every other user's ignore list and add up the times that user has been ignored

it certainly could cause server load. If it comes back, it would probably not be a "live" statistic, but one that is compiled nightly per-user.

That totally makes sense. Why add this feature if it was soooo resource intensive?
I don't think it was actually that bad back in 2012 (resource wise) but as the forum has grown such a huge amount since then it's just been getting slower and slower, have a look through the stats on here https://bitcointalk.org/index.php?action=stats


Title: Re: Database errors when replying and general forum sluggishness.
Post by: nahtnam on January 04, 2014, 01:37:51 AM
Coloring the word "ignore" with a darker color when a user is ignored by many people.
I dont see how such a small error can make such a big difference.
If the feature was written as:
-For every thread page of 20 posts that someone views:
 -for every user that posted:
  -look through every other user's ignore list and add up the times that user has been ignored

it certainly could cause server load. If it comes back, it would probably not be a "live" statistic, but one that is compiled nightly per-user.

That totally makes sense. Why add this feature if it was soooo resource intensive?
I don't think it was actually that bad back in 2012 (resource wise) but as the forum has grown such a huge amount since then it's just been getting slower and slower, have a look through the stats on here https://bitcointalk.org/index.php?action=stats

Didint even know this page existed. 65.1 million views last month!!!


Title: Re: Database errors when replying and general forum sluggishness.
Post by: theymos on January 04, 2014, 02:37:00 AM
If the feature was written as:
-For every thread page of 20 posts that someone views:
 -for every user that posted:
  -look through every other user's ignore list and add up the times that user has been ignored

That's basically how it works because the ignore mod (which I didn't write) stupidly stores ignore info in a single column per user like "35,3,...". So each ignore button needs to scan through all established users. The cost of this used to be very little, but it has increased substantially as the number of users has increased. I added a lot of caching long ago to offset this, but the cost is too high now even for that. I need to mostly rewrite the ignore mod so it stores data more sanely. No too difficult, but it requires a somewhat large uninterrupted block of time, which I don't have right now.