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
