Author Topic: 500 Internal Server Error/502 Bad Gateway  (Read 77287 times)

Offline AJK

  • Dansdeals Lifetime 20K Presidential Platinum Elite
  • ********
  • Join Date: Jun 2011
  • Posts: 25484
  • Total likes: 466
  • DansDeals.com Hat Tips 15
  • Gender: Male
    • View Profile
  • Programs: United Concierge Key; Delta Global Services; American Chairman; US Airways 1K; Hilton Sapphire; Hyatt Tritium; Marriott Californium; Starwood Kryptonium; Hertz Plutonium; National Adamantium, Avis Executive Proactanium
Re: 500 Internal Server Error/502 Bad Gateway
« Reply #200 on: November 19, 2012, 01:33:31 PM »
Never got this one before:

"Connection Problems

Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later."
2015: 116K bkd | 1.6M brnd | F: OZ,NH,AA,EK | J: UA,CA,TK,DL,TN,AF,VA | LIH,NRT,ROR,PEK,CNS,BOB,MEL,TLV & Pacific Hopper

Offline Dan

  • Administrator
  • Dansdeals Lifetime 50K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 60678
  • Total likes: 7975
  • DansDeals.com Hat Tips 16442
  • Gender: Male
    • View Profile
  • Location: CLE
  • Programs: UA Global Services, AA Lifetime Plat, DL Dirt, SPG Plat, Hyatt Diamond, Fairmont Lifetime Plat, Hilton Diamond, Priority Club Plat, Avis Chairman, National EE, Hertz PC
Re: 500 Internal Server Error/502 Bad Gateway
« Reply #201 on: November 19, 2012, 01:39:48 PM »
Never got this one before:

"Connection Problems

Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later."
BAHayman hard at work is my guess :)
Save your time, I don't answer PM. Post it in the forum and a dedicated DDF'er will get back to you as soon as possible.

Offline BAHayman

  • Administrator
  • Dansdeals Lifetime Platinum Elite
  • **********
  • Join Date: Mar 2010
  • Posts: 1944
  • Total likes: 24
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Re: 500 Internal Server Error/502 Bad Gateway
« Reply #202 on: November 19, 2012, 01:42:43 PM »
BAHayman hard at work is my guess :)
Yup, sorry about that one. I believe I have narrowed it down to an issue with pagination on large WordPress sites.

I'm looking into it more, but I think it's the pagination of search results.

Offline rots5

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2011
  • Posts: 8144
  • Total likes: 15
  • DansDeals.com Hat Tips 17
    • View Profile
    • Custom Cakes for Every Occassion
  • Location: Monsey
Re: Re: 500 Internal Server Error/502 Bad Gateway
« Reply #203 on: November 19, 2012, 01:55:22 PM »
Yup, sorry about that one. I believe I have narrowed it down to an issue with pagination on large WordPress sites.

I'm looking into it more, but I think it's the pagination of search results.

Dont u think its time we switch over to a custom site?
If you have any questions please search and then ask. PM me for detailed help.

Offline AsherO

  • Global Moderator
  • Dansdeals Lifetime 20K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 26073
  • Total likes: 3227
  • DansDeals.com Hat Tips 75
    • View Profile
  • Location: NYC
Re: 500 Internal Server Error/502 Bad Gateway
« Reply #204 on: November 19, 2012, 02:13:39 PM »
Yup, sorry about that one. I believe I have narrowed it down to an issue with pagination on large WordPress sites.

I'm looking into it more, but I think it's the pagination of search results.

So it's a DD issue and not a DDF issue? Maybe we can change how the DD search works (by using a wordpress plugin or something).

By we I mean you :)

Offline rots5

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2011
  • Posts: 8144
  • Total likes: 15
  • DansDeals.com Hat Tips 17
    • View Profile
    • Custom Cakes for Every Occassion
  • Location: Monsey
Re: 500 Internal Server Error/502 Bad Gateway
« Reply #205 on: November 19, 2012, 03:13:29 PM »
So it's a DD issue and not a DDF issue? Maybe we can change how the DD search works (by using a wordpress plugin or something).

By we I mean you :)
Just got it for the first time in months on the iPhone safari browser
If you have any questions please search and then ask. PM me for detailed help.

Offline BAHayman

  • Administrator
  • Dansdeals Lifetime Platinum Elite
  • **********
  • Join Date: Mar 2010
  • Posts: 1944
  • Total likes: 24
  • DansDeals.com Hat Tips 0
    • View Profile
Re: 500 Internal Server Error/502 Bad Gateway
« Reply #206 on: November 19, 2012, 10:01:49 PM »
Dont u think its time we switch over to a custom site?
Wordpress should be able to easily handle this kind of volume.

So it's a DD issue and not a DDF issue? Maybe we can change how the DD search works (by using a wordpress plugin or something).

By we I mean you :)
So I was on the right track, but it wasn't a search issue. It was an issue with certain proxies and bots not respecting <link rel="archive" /> and actually loading the URL.

Those pages that were linked and getting hit, had intense database queries to calculate pagination. And to further complicate hunting down the issue, it didn't always happen. It only happened once that query for the pagination was no longer in the query cache.

I am pretty sure that this was the issue and has been fixed. But I will continue reviewing the logs to be sure.

Offline jj1000

  • Administrator
  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • **********
  • Join Date: Jun 2008
  • Posts: 11753
  • Total likes: 2448
  • DansDeals.com Hat Tips 8016
    • View Profile
  • Location: The value of a forum such as this one is not in that one can post a question and receive an answer, but in that the question has most likely been asked before, and the answer is available to him that will but only use the search function.
  • Programs: 1. Search on google. 2. Search in the right board of DDF with a general word or two. 3. Read the wiki. 4. Read the thread. 5. Ask away.
Re: 500 Internal Server Error/502 Bad Gateway
« Reply #207 on: November 19, 2012, 10:09:53 PM »
Wordpress should be able to easily handle this kind of volume.
So I was on the right track, but it wasn't a search issue. It was an issue with certain proxies and bots not respecting <link rel="archive" /> and actually loading the URL.

Those pages that were linked and getting hit, had intense database queries to calculate pagination. And to further complicate hunting down the issue, it didn't always happen. It only happened once that query for the pagination was no longer in the query cache.

I am pretty sure that this was the issue and has been fixed. But I will continue reviewing the logs to be sure.
WOW! Your amazing. Thank you!!!
See my 5 step program to your left <--

(Real signature under my location)

Offline myb821

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Mar 2011
  • Posts: 7569
  • Total likes: 12
  • DansDeals.com Hat Tips 2
    • View Profile
  • Location: New York
Re: 500 Internal Server Error/502 Bad Gateway
« Reply #208 on: November 19, 2012, 10:10:22 PM »
WOW! Your amazing. Thank you!!!
+1000

Offline Saver2000

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Apr 2011
  • Posts: 7637
  • Total likes: 26
  • DansDeals.com Hat Tips 0
    • View Profile
Re: 500 Internal Server Error/502 Bad Gateway
« Reply #209 on: November 19, 2012, 10:12:58 PM »

Offline AsherO

  • Global Moderator
  • Dansdeals Lifetime 20K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 26073
  • Total likes: 3227
  • DansDeals.com Hat Tips 75
    • View Profile
  • Location: NYC
Re: 500 Internal Server Error/502 Bad Gateway
« Reply #210 on: November 19, 2012, 10:40:24 PM »
WOW! Your amazing. Thank you!!!

+1000 many thanks. May the almighty Dan reward you, over and over again :P

Offline meshugener

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Feb 2012
  • Posts: 7079
  • Total likes: 52
  • DansDeals.com Hat Tips 4
  • Gender: Female
    • View Profile
  • Location: DDF
  • Programs: Amex Platinum, Chase Freedom 10X10 Exclusives, Avis Presidents Club, National Executive, Hertz 5 Star, Hilton Gold, Accor Platinum, Hyatt Platinum, Marriott Silver, SPG Gold, Club Carlson Gold
Re: 500 Internal Server Error/502 Bad Gateway
« Reply #211 on: November 19, 2012, 10:41:38 PM »
Angel AsherO?
Love me or hate me. I still love you.

Offline AsherO

  • Global Moderator
  • Dansdeals Lifetime 20K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 26073
  • Total likes: 3227
  • DansDeals.com Hat Tips 75
    • View Profile
  • Location: NYC
Re: 500 Internal Server Error/502 Bad Gateway
« Reply #212 on: November 19, 2012, 10:43:07 PM »
Angel AsherO?

What would that make you, a demon? :o

/kidding

Offline jj1000

  • Administrator
  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • **********
  • Join Date: Jun 2008
  • Posts: 11753
  • Total likes: 2448
  • DansDeals.com Hat Tips 8016
    • View Profile
  • Location: The value of a forum such as this one is not in that one can post a question and receive an answer, but in that the question has most likely been asked before, and the answer is available to him that will but only use the search function.
  • Programs: 1. Search on google. 2. Search in the right board of DDF with a general word or two. 3. Read the wiki. 4. Read the thread. 5. Ask away.
Re: 500 Internal Server Error/502 Bad Gateway
« Reply #213 on: November 19, 2012, 10:50:50 PM »
What would that make you, a demon? :o
ftfy
See my 5 step program to your left <--

(Real signature under my location)

Offline bubbles

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2011
  • Posts: 5063
  • Total likes: 19
  • DansDeals.com Hat Tips 67
    • View Profile
Re: 500 Internal Server Error/502 Bad Gateway
« Reply #214 on: November 19, 2012, 10:55:03 PM »
Wordpress should be able to easily handle this kind of volume.
So I was on the right track, but it wasn't a search issue. It was an issue with certain proxies and bots not respecting <link rel="archive" /> and actually loading the URL.

Those pages that were linked and getting hit, had intense database queries to calculate pagination. And to further complicate hunting down the issue, it didn't always happen. It only happened once that query for the pagination was no longer in the query cache.

I am pretty sure that this was the issue and has been fixed. But I will continue reviewing the logs to be sure.


Offline AsherO

  • Global Moderator
  • Dansdeals Lifetime 20K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 26073
  • Total likes: 3227
  • DansDeals.com Hat Tips 75
    • View Profile
  • Location: NYC
Re: 500 Internal Server Error/502 Bad Gateway
« Reply #215 on: November 19, 2012, 11:04:03 PM »


BAHayman hu akhbar! BAHayman hu akhbar!...

Offline txtmax4

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2009
  • Posts: 6975
  • Total likes: 9
  • DansDeals.com Hat Tips 1
    • View Profile
Re: 500 Internal Server Error/502 Bad Gateway
« Reply #216 on: November 20, 2012, 12:34:23 AM »
Got an error about 10 mins ago..
If You See Something, Say Something!!

Offline rots5

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2011
  • Posts: 8144
  • Total likes: 15
  • DansDeals.com Hat Tips 17
    • View Profile
    • Custom Cakes for Every Occassion
  • Location: Monsey
Re: 500 Internal Server Error/502 Bad Gateway
« Reply #217 on: November 20, 2012, 02:11:03 AM »
Got an error about 10 mins ago..

Oh shush ...lol were praising BAHayman :).  Jk

But either way we really appreciate all the help you do to keep the site up.  Kol hakavod
If you have any questions please search and then ask. PM me for detailed help.

Offline txtmax4

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2009
  • Posts: 6975
  • Total likes: 9
  • DansDeals.com Hat Tips 1
    • View Profile
Re: 500 Internal Server Error/502 Bad Gateway
« Reply #218 on: November 20, 2012, 02:20:59 AM »
Oh shush ...lol were praising BAHayman :).  Jk

But either way we really appreciate all the help you do to keep the site up.  Kol hakavod
Aderaba, I assume he wants people to report when this happens after all his hard work.
BIG yasher koach!
If You See Something, Say Something!!

Offline BAHayman

  • Administrator
  • Dansdeals Lifetime Platinum Elite
  • **********
  • Join Date: Mar 2010
  • Posts: 1944
  • Total likes: 24
  • DansDeals.com Hat Tips 0
    • View Profile
Re: 500 Internal Server Error/502 Bad Gateway
« Reply #219 on: November 20, 2012, 07:10:55 AM »
Got an error about 10 mins ago..
Thanks for reporting that. From looking at the logs, it seems that it is an unrelated issue.

What happened is last night at 00:20, FlipboardProxy decided to slam the server for 541 different articles within a 9 second span... I have sent an email to Flipboard support and will see what they say.

Aside from 00:20 last night I don't see any errors due to load since I removed those <link rel="archive" /> links yesterday. :)

Edit: It seems that others are having this same issue.