Jump to content


Welcome to DBSTalk


Sign In 

Create Account
Welcome to DBSTalk. Our community covers all aspects of video delivery solutions including: Direct Broadcast Satellite (DBS), Cable Television, and Internet Protocol Television (IPTV). We also have forums to discuss popular television programs, home theater equipment, and internet streaming service providers. Members of our community include experts who can help you solve technical problems, industry professionals, company representatives, and novices who are here to learn.

Like most online communities you must register to view or post in our community. Sign-up is a free and simple process that requires minimal information. Be a part of our community by signing in or creating an account. The Digital Bit Stream starts here!
  • Reply to existing topics or start a discussion of your own
  • Subscribe to topics and forums and get email updates
  • Send private personal messages (PM) to other forum members
  • Customize your profile page and make new friends
 
Guest Message by DevFuse

Photo

Intermittent site hang lockup?


  • Please log in to reply
73 replies to this topic

#26 OFFLINE   David MacLeod

David MacLeod

    Hall Of Fame

  • Registered
  • 5,689 posts
Joined: Jan 29, 2008

Posted 29 June 2013 - 05:53 PM

some of it was also me restarting services after I started to work on it, so between 7 and 730pm mostly it was me.


Dave MacLeod
S.I.H.

...Ads Help To Support This Site...

#27 OFFLINE   David MacLeod

David MacLeod

    Hall Of Fame

  • Registered
  • 5,689 posts
Joined: Jan 29, 2008

Posted 29 June 2013 - 06:15 PM

seems ok now, I have been hitting links for 20+ min straight.

750 to 850 online when doing it and was smooth for me.

will monitor tomorrow.


Dave MacLeod
S.I.H.

#28 OFFLINE   David Bott

David Bott

    Hall Of Fame

  • Administrators
  • 2,301 posts
  • LocationTraveling the USA
Joined: Jul 12, 2005

Posted 29 June 2013 - 10:03 PM

Ok, we seemed to have some issues with the MySQL config.  I THINK I have it sorted out as of the writing of this post.   We shall see.


David Bott

Admin - Owner

 

Founder - AVSForum.comTiVoCommunity.com, Home Theater Cruise, LLC, DBNet Consulting, LLC, 

Board of Advisers - Prelaunch.com

Connecting to Over 5 Million Unique Enthusiasts a Month

 

DISCLAIMER: All spelling and grammatical errors done on purpose for the proofreadingly challenged.


#29 OFFLINE   Stewart Vernon

Stewart Vernon

    Excellent Adventurer

  • Moderators
  • 20,553 posts
  • LocationKittrell, NC
Joined: Jan 07, 2005

Posted 30 June 2013 - 01:52 AM

I noticed the site was down again earlier... forgot to notice the time... then I got distracted with TV and didn't check back in until now.


-- !rotaredoM mA eM

What I do when I'm not here


#30 OFFLINE   David MacLeod

David MacLeod

    Hall Of Fame

  • Registered
  • 5,689 posts
Joined: Jan 29, 2008

Posted 30 June 2013 - 07:26 AM

my dsl crapped out last night so was not able to keep eye on much, sorry


Dave MacLeod
S.I.H.

#31 ONLINE   longrider

longrider

    Hall Of Fame

  • DBSTalk Club
  • 3,567 posts
  • LocationElizabeth, CO
Joined: Apr 21, 2007

Posted 30 June 2013 - 09:30 AM

Just experienced the issue today, 9:28AM MT, took about 2 minutes to get a response


My Setup

#32 OFFLINE   RAD

RAD

    Hall Of Fame

  • Topic Starter
  • DBSTalk Club
  • 16,255 posts
  • LocationDripping Springs, TX
Joined: Aug 05, 2002

Posted 30 June 2013 - 09:36 AM

Also happened here around the same time.

See post My Setup for configuration info.


#33 OFFLINE   David Bott

David Bott

    Hall Of Fame

  • Administrators
  • 2,301 posts
  • LocationTraveling the USA
Joined: Jul 12, 2005

Posted 30 June 2013 - 10:23 AM

Pondering, their is nothing in the logs at that time showing any issues with the database or connections etc.   As far as 2 mins to get a response, that I would think the browser would have timed out before that.  So even more lost.

 

When this happens...can you traceroute to the site?  Wondering if it is a network issue and I can only tell that with a trace.


David Bott

Admin - Owner

 

Founder - AVSForum.comTiVoCommunity.com, Home Theater Cruise, LLC, DBNet Consulting, LLC, 

Board of Advisers - Prelaunch.com

Connecting to Over 5 Million Unique Enthusiasts a Month

 

DISCLAIMER: All spelling and grammatical errors done on purpose for the proofreadingly challenged.


#34 OFFLINE   David MacLeod

David MacLeod

    Hall Of Fame

  • Registered
  • 5,689 posts
Joined: Jan 29, 2008

Posted 30 June 2013 - 10:29 AM

wonder if thats apache prefork (non threaded) bog

any idea how many online at that point?

server is also using suphp, there is evidence that can cause slowdowns too. unsure of who else is hosted on the server so could not really say if thats needed or not.


Dave MacLeod
S.I.H.

#35 ONLINE   longrider

longrider

    Hall Of Fame

  • DBSTalk Club
  • 3,567 posts
  • LocationElizabeth, CO
Joined: Apr 21, 2007

Posted 30 June 2013 - 11:02 AM

Pondering, their is nothing in the logs at that time showing any issues with the database or connections etc.   As far as 2 mins to get a response, that I would think the browser would have timed out before that.  So even more lost.

 

When this happens...can you traceroute to the site?  Wondering if it is a network issue and I can only tell that with a trace.

David, I will do a trace if it happens to me again. I know it is not my connection, I have verified that is functional while DBSTalk is not responding.  As for the timeout, when I know it is getting close to timing out I usually stop that load and either try again or try a different page on the site. The second attempts or alternate pages also do not load, if I do let it time out and use the browsers 'try again' it times out very quickly the second time


My Setup

#36 OFFLINE   David Bott

David Bott

    Hall Of Fame

  • Administrators
  • 2,301 posts
  • LocationTraveling the USA
Joined: Jul 12, 2005

Posted 30 June 2013 - 11:13 AM

Hi, thanks.  

 

What I am looking to see when you are seeing the issue is a traceroute.  I ask for while your connection to other sites might be good, I am trying to see if it at the network center I am in.  Thus as trace can show me is their are any issues network wise at the time.

 

I just made a few change, but I do not think it will de another other than to give me something else to look at time wise.

 

So, when it happens, note the time (The severs is in CT)  and if you can catch a trace route while it is happening....great!  Post it here.

 

Thank you for the help.


David Bott

Admin - Owner

 

Founder - AVSForum.comTiVoCommunity.com, Home Theater Cruise, LLC, DBNet Consulting, LLC, 

Board of Advisers - Prelaunch.com

Connecting to Over 5 Million Unique Enthusiasts a Month

 

DISCLAIMER: All spelling and grammatical errors done on purpose for the proofreadingly challenged.


#37 OFFLINE   RAD

RAD

    Hall Of Fame

  • Topic Starter
  • DBSTalk Club
  • 16,255 posts
  • LocationDripping Springs, TX
Joined: Aug 05, 2002

Posted 30 June 2013 - 11:21 AM

I'll also try to get a traceroute next time it happens. I did mention that I'm able to ping the site while it's hung, <20ms times. I've also pinged with a 1400 byte packet and while response time a tad higher also works fine, no drops.

See post My Setup for configuration info.


#38 OFFLINE   RAD

RAD

    Hall Of Fame

  • Topic Starter
  • DBSTalk Club
  • 16,255 posts
  • LocationDripping Springs, TX
Joined: Aug 05, 2002

Posted 30 June 2013 - 12:05 PM

Hung up again, both IOS client, IOS Safari broswer and PC with IE 9.0 browser happened around 13:00 CDT. While I was posting this the site hung up again for about a minute. Pings and traceroute taken while site hung below:

 

Ping statistics for 72.9.159.119:
    Packets: Sent = 34, Received = 34, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 17ms, Maximum = 30ms, Average = 19ms

 

Tracing route to www.dbstalk.com [72.9.159.119]
over a maximum of 30 hops:

  1    <1 ms     1 ms    <1 ms  192.168.10.1
  2     *        *        *     Request timed out.
  3    17 ms     9 ms     9 ms  tge7-3.austtxs-er01.texas.rr.com [66.68.1.105]
  4     9 ms    10 ms     7 ms  tge8-1.trswtx1202h.texas.rr.com [24.175.41.193]

  5    15 ms    15 ms    15 ms  te0-10-0-0.austtxrdcsc-cr02.texas.rr.com [24.27.
13.96]
  6    18 ms    23 ms    15 ms  agg22.hstntxl3-cr01.texas.rr.com [24.175.41.48]

  7    17 ms    19 ms    19 ms  ae-4-0.cr0.hou30.tbone.rr.com [66.109.6.54]
  8    20 ms    20 ms    18 ms  ae-0-0.pr0.dfw10.tbone.rr.com [66.109.6.181]
  9    17 ms    17 ms    17 ms  107.14.16.186
 10    31 ms    18 ms    20 ms  ae-2-70.edge3.Dallas1.Level3.net [4.69.145.72]
 11    20 ms    21 ms    23 ms  COLO4-DALLA.edge3.Dallas1.Level3.net [8.9.232.74
]
 12    28 ms    19 ms    21 ms  72.249.128.110
 13    22 ms    18 ms    25 ms  dbnet.bott.net [72.9.159.119]

Trace complete.


See post My Setup for configuration info.


#39 OFFLINE   David MacLeod

David MacLeod

    Hall Of Fame

  • Registered
  • 5,689 posts
Joined: Jan 29, 2008

Posted 30 June 2013 - 12:09 PM

when it bogs it does recover on its own now correct?

no sql or page not found errors now?


Dave MacLeod
S.I.H.

#40 OFFLINE   Drucifer

Drucifer

    Hall Of Fame

  • Registered
  • 8,601 posts
  • LocationNY Hudson Valley
Joined: Feb 12, 2009

Posted 30 June 2013 - 12:12 PM

Was doing fine until I hit the link in the email notification for this thread and got another delay of several minutes.


DREW
Do it Right, Do it Once
LR: HR34-700, Bsm: HR24-100, Den HR24-200, MB: HR24-500, Kit: H25-500
PrimeStar '95, DirecTV  '00


#41 OFFLINE   RAD

RAD

    Hall Of Fame

  • Topic Starter
  • DBSTalk Club
  • 16,255 posts
  • LocationDripping Springs, TX
Joined: Aug 05, 2002

Posted 30 June 2013 - 12:15 PM

when it bogs it does recover on its own now correct?

no sql or page not found errors now?

Correct, at least since things were missed up yesterday afternoon/evening. It just sits there no timeout and eventually responds. There are a few times where I'm catching it come back after a lockup, it works for a minute or so then hangs up again and again comes back on its own.


See post My Setup for configuration info.


#42 ONLINE   longrider

longrider

    Hall Of Fame

  • DBSTalk Club
  • 3,567 posts
  • LocationElizabeth, CO
Joined: Apr 21, 2007

Posted 30 June 2013 - 12:16 PM

I had done this earlier for comparison, this is while the site is working fine:

 

Tracing route to www.dbstalk.com [72.9.159.119]
over a maximum of 30 hops:

  1     4 ms     4 ms     4 ms  192.168.1.1
  2    86 ms    49 ms    34 ms  coloradosprings-pr732.kellin.net [198.57.1.1]
  3    93 ms    51 ms    39 ms  cls2-edge-03.inet.qwest.net [207.109.162.165]
  4    83 ms    99 ms    89 ms  dvr-brdr-02.inet.qwest.net [67.14.24.114]
  5   102 ms   119 ms    69 ms  63.146.26.134
  6   105 ms   101 ms    98 ms  vlan51.ebr1.Denver1.Level3.net [4.69.147.94]
  7    87 ms   347 ms    91 ms  ae-2-2.ebr2.Dallas1.Level3.net [4.69.132.106]
  8    87 ms   104 ms    95 ms  ae-72-72.csw2.Dallas1.Level3.net [4.69.151.141]

  9    83 ms   121 ms    99 ms  ae-2-70.edge3.Dallas1.Level3.net [4.69.145.72]
 10    93 ms   109 ms   109 ms  COLO4-DALLA.edge3.Dallas1.Level3.net [8.9.232.74
]
 11   102 ms    91 ms    97 ms  72.249.128.110
 12   109 ms    63 ms    59 ms  dbnet.bott.net [72.9.159.119]

Trace complete.

 

When the hangups happen I do not get any errors, just no response.  I was not online at the time RAD experienced the issue


My Setup

#43 OFFLINE   David Bott

David Bott

    Hall Of Fame

  • Administrators
  • 2,301 posts
  • LocationTraveling the USA
Joined: Jul 12, 2005

Posted 30 June 2013 - 12:36 PM

Well every long query error looks to be caused by TapaTalk...

 

/usr/sbin/mysqld, Version: 5.5.31-cll (MySQL Community Server (GPL)). started with:
Tcp port: 0  Unix socket: (null)
Time                 Id Command    Argument
# Time: 130630 12:36:39
# User@Host: dbstalk_ipb[dbstalk_ipb] @ localhost []
# Query_time: 52.141685  Lock_time: 0.000077 Rows_sent: 222  Rows_examined: 21973116
use dbstalk_ipb;
SET timestamp=1372613799;
SELECT p.*,m.member_id as author_id FROM tapatalk_push_data p  LEFT JOIN members m ON ( p.author = m.members_display_name )   WHERE p.user_id=454547 ORDER BY p.create_time DESC;
# Time: 130630 12:50:51
# User@Host: dbstalk_ipb[dbstalk_ipb] @ localhost []
# Query_time: 43.735035  Lock_time: 0.000088 Rows_sent: 171  Rows_examined: 16925238
SET timestamp=1372614651;
SELECT p.*,m.member_id as author_id FROM tapatalk_push_data p  LEFT JOIN members m ON ( p.author = m.members_display_name )   WHERE p.user_id=442206 ORDER BY p.create_time DESC;
# Time: 130630 13:01:39
# User@Host: dbstalk_ipb[dbstalk_ipb] @ localhost []
# Query_time: 345.505372  Lock_time: 0.000090 Rows_sent: 1451  Rows_examined: 143617078
SET timestamp=1372615299;
SELECT p.*,m.member_id as author_id FROM tapatalk_push_data p  LEFT JOIN members m ON ( p.author = m.members_display_name )   WHERE p.user_id=417495 ORDER BY p.create_time DESC;
# Time: 130630 13:15:21
# User@Host: dbstalk_ipb[dbstalk_ipb] @ localhost []
# Query_time: 7.772315  Lock_time: 0.000061 Rows_sent: 30  Rows_examined: 2969340
SET timestamp=1372616121;
SELECT p.*,m.member_id as author_id FROM tapatalk_push_data p  LEFT JOIN members m ON ( p.author = m.members_display_name )   WHERE p.user_id=454231 ORDER BY p.create_time DESC;
# Time: 130630 13:30:03
# User@Host: dbstalk_ipb[dbstalk_ipb] @ localhost []
# Query_time: 5.508243  Lock_time: 0.000045 Rows_sent: 21  Rows_examined: 2078538
SET timestamp=1372617003;
SELECT p.*,m.member_id as author_id FROM tapatalk_push_data p  LEFT JOIN members m ON ( p.author = m.members_display_name )   WHERE p.user_id=440109 ORDER BY p.create_time DESC;
 
 
...I will need to send them a note as this could be the issue making for the locks based on the time frame you gave me.

David Bott

Admin - Owner

 

Founder - AVSForum.comTiVoCommunity.com, Home Theater Cruise, LLC, DBNet Consulting, LLC, 

Board of Advisers - Prelaunch.com

Connecting to Over 5 Million Unique Enthusiasts a Month

 

DISCLAIMER: All spelling and grammatical errors done on purpose for the proofreadingly challenged.


#44 OFFLINE   David MacLeod

David MacLeod

    Hall Of Fame

  • Registered
  • 5,689 posts
Joined: Jan 29, 2008

Posted 30 June 2013 - 01:00 PM

tapatalk pushes to each member whenever watched item replied to ?


Dave MacLeod
S.I.H.

#45 OFFLINE   klang

klang

    Hall Of Fame

  • Registered
  • 1,268 posts
  • LocationNear Houston, TX
Joined: Oct 14, 2003

Posted 30 June 2013 - 01:02 PM

Wow, 143 million rows examined! My database experience was mainframe DB2 and now out of date but perhaps an index is needed?



#46 OFFLINE   David Bott

David Bott

    Hall Of Fame

  • Administrators
  • 2,301 posts
  • LocationTraveling the USA
Joined: Jul 12, 2005

Posted 30 June 2013 - 01:24 PM

Wow, 143 million rows examined! My database experience was mainframe DB2 and now out of date but perhaps an index is needed?

 

I do not disagree.  But I do not know what tables or rows to index. :)  I would like them to give me some guidance on what might be needed or look into the issue.  

 

It might not be the issue we are having...but it sure seems that the times match up and those are the only queries showing up in the slow query log. 


David Bott

Admin - Owner

 

Founder - AVSForum.comTiVoCommunity.com, Home Theater Cruise, LLC, DBNet Consulting, LLC, 

Board of Advisers - Prelaunch.com

Connecting to Over 5 Million Unique Enthusiasts a Month

 

DISCLAIMER: All spelling and grammatical errors done on purpose for the proofreadingly challenged.


#47 OFFLINE   MysteryMan

MysteryMan

    Hall Of Fame

  • DBSTalk Club
  • 7,370 posts
  • LocationUSA
Joined: May 17, 2010

Posted 01 July 2013 - 06:08 AM

Site became unresponsive at 07:41 Eastern Time this morning.


DIRECTV customer since 1995.

#48 OFFLINE   David MacLeod

David MacLeod

    Hall Of Fame

  • Registered
  • 5,689 posts
Joined: Jan 29, 2008

Posted 01 July 2013 - 06:11 AM

I do not disagree.  But I do not know what tables or rows to index. :)  I would like them to give me some guidance on what might be needed or look into the issue.  

 

It might not be the issue we are having...but it sure seems that the times match up and those are the only queries showing up in the slow query log. 

an interim test would be to disable tapatalk push notifications for a bit and watch the slow log for a bit.

now its been up for over 24hrs slqltuner may show some useful info too since this is basically a default mycnf


Dave MacLeod
S.I.H.

#49 OFFLINE   David Bott

David Bott

    Hall Of Fame

  • Administrators
  • 2,301 posts
  • LocationTraveling the USA
Joined: Jul 12, 2005

Posted 01 July 2013 - 06:56 AM

Just installed an update from Tapatalk that they sent me this morning.

 

I am also working on installing the Sphinx for the search engine.  So mySql will be going down for a few mins so access will be not possible.  


David Bott

Admin - Owner

 

Founder - AVSForum.comTiVoCommunity.com, Home Theater Cruise, LLC, DBNet Consulting, LLC, 

Board of Advisers - Prelaunch.com

Connecting to Over 5 Million Unique Enthusiasts a Month

 

DISCLAIMER: All spelling and grammatical errors done on purpose for the proofreadingly challenged.


#50 OFFLINE   David Bott

David Bott

    Hall Of Fame

  • Administrators
  • 2,301 posts
  • LocationTraveling the USA
Joined: Jul 12, 2005

Posted 01 July 2013 - 08:13 AM

Ok, had some issue with Sphinx as it is not as cut and dry as I thought.  So right now I have the Tapatalk update/fix installed.  So we will start their.  But I still want Sphinx a some point.


David Bott

Admin - Owner

 

Founder - AVSForum.comTiVoCommunity.com, Home Theater Cruise, LLC, DBNet Consulting, LLC, 

Board of Advisers - Prelaunch.com

Connecting to Over 5 Million Unique Enthusiasts a Month

 

DISCLAIMER: All spelling and grammatical errors done on purpose for the proofreadingly challenged.





Protected By... spam firewall...And...