Re: [RDD] rdairplay pausing/MySQL issue?

Sat, 12 Apr 2014 10:49:28 -0700 


If I log into nerodia and enter:

mysql -urduser -pwhatever Rivendell

...there is no problem.
There is another rdairplay running on nerodia (for a different station than the one running on storeria). It has never had a problem.
Oddly, the problem on storeria went away again shortly after I posted my last email. But it will come back again. It comes and goes. Weird, huh? 


Rob

On Sat, 12 Apr 2014, Lorne Tyndale wrote:


Hi Rob,

When it is doing this, have you tried opening up a shell on Nerodia and
tried to connect to the database located on that machine directly, the
same test you did connecting from Storeria?

This might tell you if it is a MySQL issue or something with the
network.

When was the last time you restarted MySQL on Nerordia?  And does the
MySQL log show any errors?

While this is not likely the issue, one machine that I has some serious
MySQL latency on had 2 Nic's in it, and I didn't realize it but I'd
managed to bind MySQL to only 1 of the Nics (not the one that had the
traffic coming in on it).  For some reason it still worked on the
network (I still don't understand that part) but was very slow.

I'm sure you've already checked this, but make sure you've got enough
memory assigned to MySQL and such in its setup. Lorne
I spoke too soon; the problem is back with a vengeance. It seems to be MySQL related.
The database resides on "nerodia"; the machine named "storeria" is running rdairplay. Rdairplay seems to freeze from time to time, but the current event will play in its entirety. Then there will be a delay, sometimes up to 2 minutes, before rdairplay starts the next event.
I can flood-ping "nerodia" from "storeria" with zero packet loss. I can ssh into "nerodia" from "storeria" while rdairplay is frozen with no problem. I don't think this is a general networking issue. 

If I open a terminal window on "storeria" and enter:

mysql -urduser -pwhatever -hnerodia Rivendell
...it takes forever to connect, and once connected, a command like "show tables" also takes forever. The same command run directly on "nerodia" is lightning-fast.
Sometimes, however, the connection attempt from "storeria" to "nerodia" times out, and I get:
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 0 

That has me baffled. Googling suggests it may be a bug in MySQL itself.
This is MySQL 5.1.73-1 (Debian 6). RD is version 2.5.5. Both "nerodia" and "storeria" are Dell Optiplex 755's. 


Rob


On Fri, 11 Apr 2014, Rob Landry wrote:

>
> I am using nfs.
>
> This afternoon I did a backup/restore on the database after deleting a bunch > of old logs. That seems to have helped. 
>
> Rob
>
>
> On Sat, 12 Apr 2014, Geoff Barkman wrote:
>
>> >> How is the network file share mounted? 
>> Are you using nfs or samba? Samba can be quite unstable if you are using
>> that.
>> Many thanks
>> Geoff Barkman
>> >> On Apr 12, 2014 3:08 AM, "Rob Landry" <[email protected]> wrote: 
>>
>>       That doesn't seem to have helped.
>>
>>       Alas, none of the logs I've checked offer any clues.
>> >> 
>>       Rob
>> >> 
>>       On Fri, 11 Apr 2014, Wayne Merricks wrote:
>>
>>             Hi,
>>
>>             Have you tried skip name resolve in the mysql conf
>>             file?
>>
>>             In the [mysqld] section just add:
>>
>>             skip-name-resolve
>>
>>             Then restart the server.
>>
>>             Wayne Merricks
>>             The Voice Asia
>>
>>             On 11/04/14 13:11, Rob Landry wrote:
>>
>>                   I have a Rivendell machine (Debian 6/RD
>>                   version 2.5.5) running rdairplay on a
>>                   network where it is using /var/snd and a
>>                   MySQL database residing on a second
>>                   machine (also running rdairplay).
>>
>>                   What I am observing is that rdairplay on
>>                   the first machine (but not the second,
>>                   where /var/snd and the database reside)
>>                   will occasionally pause for several
>>                   seconds while the audio continues to
>>                   play. At the end of the cut, however,
>>                   there will be a pause before the next
>>                   cut starts.
>>
>>                   I've never seen this behavior before; if
>>                   there were droputs in playback, I'd
>>                   suspect a network problem, but in this
>>                   case ecah cut will play in its entirety,
>>                   even though rdairplay may pause in the
>>                   middle of the cut, and there will be a
>>                   delay of some seconds before the next
>>                   cut starts.
>>
>>                   I'm guessing this is a MySQL issue. Are
>>                   there parameters I should try tuning in
>>                   my.cnf? If so, on which machine? The
>>                   machine exhibiting the pauses is not the
>>                   one hosting the database.
>>
>>                   Thanks all.
>> >> 
>>                   Rob
>>
>>                   _______________________________________________
>>                   Rivendell-dev mailing list
>>                   [email protected]
>>                   
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>> >> 
>>             _______________________________________________
>>             Rivendell-dev mailing list
>>             [email protected]
>>             http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>>
>>       _______________________________________________
>>       Rivendell-dev mailing list
>>       [email protected]
>>       http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>> >> >> > _______________________________________________ 
> Rivendell-dev mailing list
> [email protected]
> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev



_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Reply via email to