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

#41 OFFLINE   RAD

RAD

    Hall Of Fame

  • Topic Starter
  • DBSTalk Club
  • 15,985 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.


...Ads Help To Support This SIte...

#42 OFFLINE   longrider

longrider

    Hall Of Fame

  • DBSTalk Club
  • 3,080 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,079 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

  • DBSTalk Club
  • 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,079 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
  • 6,613 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,079 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,079 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.


#51 OFFLINE   David MacLeod

David MacLeod

    Hall Of Fame

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

Posted 01 July 2013 - 08:17 AM

chmod issue on wherever you stored the sphinx deltas/logs?

I'll be reinstalling that later today, last time only took 20 minutes or so.

this is still pretty pertinent, may help

http://www.invisionp...s/searching-r21


Dave MacLeod
S.I.H.

#52 OFFLINE   David Bott

David Bott

    Hall Of Fame

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

Posted 01 July 2013 - 10:26 AM

I removed it all at this point to start over when I get the chance. 


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.


#53 OFFLINE   David MacLeod

David MacLeod

    Hall Of Fame

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

Posted 01 July 2013 - 10:42 AM

hopefully I'll be doing mine in about 2 hours, I'll document it and send the info when I do.

usually any issues are just pathings and its a pita to remember them sometimes.


Dave MacLeod
S.I.H.

#54 OFFLINE   David Bott

David Bott

    Hall Of Fame

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

Posted 01 July 2013 - 12:52 PM

Is anyone still seeing the issue?


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.


#55 OFFLINE   longrider

longrider

    Hall Of Fame

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

Posted 01 July 2013 - 01:05 PM

I have not experienced it so far today, but I was only online a little early this morning and then right now


My Setup


#56 OFFLINE   RAD

RAD

    Hall Of Fame

  • Topic Starter
  • DBSTalk Club
  • 15,985 posts
  • LocationDripping Springs, TX
Joined: Aug 05, 2002

Posted 01 July 2013 - 01:25 PM

Working better on my iPhone and browsers.

But the app on my iPad not so much. When I open it, the notifications panel opens then sits there sitting on loading feeds and that's it. I've tried uninstalling/ reinstalling the app, didn't help.

See post My Setup for configuration info.


#57 OFFLINE   David MacLeod

David MacLeod

    Hall Of Fame

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

Posted 01 July 2013 - 01:27 PM

I removed it all at this point to start over when I get the chance. 

 

 

hopefully I'll be doing mine in about 2 hours, I'll document it and send the info when I do.

usually any issues are just pathings and its a pita to remember them sometimes.

 

took me about 15, let me know when you want to try it (tomorrow) and we can walk through sphinx setup.

tested with yesterdays tapatalk too and no issues, every now and then a tapatalk release gets through that does not work with sphinx.


Dave MacLeod
S.I.H.

#58 OFFLINE   David Bott

David Bott

    Hall Of Fame

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

Posted 01 July 2013 - 01:53 PM

RAD...I am not sure it is related to what we are trying to solve.  But seeing I did just apply an update given to me from Tapatalk, the issue could be related to what you are seeing.  But the issue really seemed to be PUSH notice related.  So thinking it is not.  (Did that come out right?) :)


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.


#59 OFFLINE   RAD

RAD

    Hall Of Fame

  • Topic Starter
  • DBSTalk Club
  • 15,985 posts
  • LocationDripping Springs, TX
Joined: Aug 05, 2002

Posted 01 July 2013 - 02:04 PM

David, if it helps, the iPad issue started later yesterday not this AM. Sometimes I can get to another screen like current but then if it try to do something, like reply to this thread it hangs up.

See post My Setup for configuration info.


#60 OFFLINE   David Bott

David Bott

    Hall Of Fame

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

Posted 01 July 2013 - 02:34 PM

Ok, so not related to the update.  Good.  But sorry you are having and issue.  :(


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.





spam firewall