[mythtv-users] Mysql max-connections and bind-address

[Mark Perkins]

Hoping for some assistance. Have been running 0.27 updated every couple of
days until approx 2week ago while I was away for a while. This morning have
run a series of updates from the last two weeks including (I think) moving
from RC to Released version (and also a bunch of Ubuntu updates at the same
time, quite a number). Will try and keep the query brief but will also try
and include the steps that have led to where I currently am in case it
assists.

 

Immediately after upgrade everything was working perfectly. So I ran through
and touched up the commflags on a couple of recordings and started
transcoding (archiving to a NAS). I have set a max of 3 user jobs at one
time but queued about 6 jobs. This is when the trouble started.

 

The FE's now wont connect to the BE (both FE/BE that I use for commflag
touch-ups so I don't tie up the main TV's, and remote FE's). Also MythWeb is
failing to connect.

 

The Frontends just keep cycling through the Country / Database startup
config screens. The settings all appear to be correct but it just keeps
looping. Mythweb was mostly just showing 'unavailable' in the fields (ie
Encoder 9 [ DVB : /dev/dvb/adapter0/frontend0 ] is local on mark-P5K-Deluxe
and is UNAVAILABLE) rather than recording / not recording etc. But on one
refresh it failed to a message that indicated the maximum number of database
connections had been reached.

 

Bit of google led me to open /etc/mysql/my.cnf. Couldn't see anything
unusual in there (although what would I know, I'm a newbie to all this
stuff) but saw that bind-address was set to 192.168.1.33 (correct for my
setup) and there was a line for max-connections = 100 but was commented out.
I left all alone in that file but saw at the bottom an includedir =
/etc/mysql/conf.d/ for additional settings and a warning that the includedir
could override settings in the file.

 

In /etc/mysql/conf.d/ I have three files mysql_safe_syslog.cnf, mythtv.cnf
and mythtv-tweaks.cnf. The first and last did not seem to contain anything
unusual (to me) but mythtv.cnf contains two lines:

Bind-address = 0.0.0.0

Max-connections = 100

 

To me the bind-address seems clearly wrong, surely it should be my BE IP
address 192.168.1.33? However is it the max-connections = 100 that is
causing my immediate problem? Should I just comment it out which I assume
would allow unlimited connections? Or do I need to set a practical upper
limit. I only have 3 FE (one a BE/FE) and a couple of smartphones that
access mythweb but assume that the number of database connections is driven
by far more than simply the number of devices.

 

Update: while typing this message mythweb has now started working. I can see
3 user jobs running with 3 more queued. Also a recording has started. But
the remote FE still will not connect (repeatedly steps through initial
country / database config screens).

 

My current plan (thinking on the fly) is to sit tight and let the recording
and user jobs complete. Then I will change the mythtv.cnf bind-address to
192.168.1.33 and up the max-connections to 200, reboot and see if that
helps.

 

But any advice on my current situation would be greatly appreciated.

 

Mark.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20130926/dacb8b18/attachment.html>