[ATrpms-users] Problems with MySQL

[Axel Thimm]

> ----- Original Message ----
> From: Axel Thimm <Axel.Thimm at ATrpms.net>
> To: Javier Perez <pepebuho at yahoo.com>
> Cc: ATrpms user list <atrpms-users at ATrpms.net>
> Sent: Thursday, January 3, 2008 7:22:11 AM
> Subject: Re: Problems with MySQL
> 
> 
> On Wed, Jan 02, 2008 at 08:46:01PM -0800, Javier Perez wrote:
> > Hi. I am getting the following error each time I try
> > to run mythtranscode.
> > bash-3.2$ /bin/nice -n19 /usr/bin/mythtranscode
> > --showprogress -p 27 -c 1017 -s 2007-12-20-21-55-00 -f
> > "/tmp/fifodir_10216/" --honorcutlist
> > 2008-01-02 23:12:06.207 Using runtime prefix = /usr
> > 2008-01-02 23:12:25.346 New DB connection, total: 1
> > 2008-01-02 23:12:31.111 Unable to connect to database!
> > 2008-01-02 23:12:31.111 Driver error was [1/2013]:
> > QMYSQL3: Unable to connect
> > Database error was:
> > Lost connection to MySQL server at 'sending
> > authentication information', system error: 32
> > 
> > QSqlQuery::exec: database not open
> > 2008-01-02 23:12:32.497 Enabled verbose msgs:
> > important
> > 2008-01-02 23:12:35.209 New DB connection, total: 2
> > 2008-01-02 23:12:49.070 Using protocol version 31
> > 
> > =======================
> > If I use mysqladmin, I do notget such an error.
> 
> What about all the other mythtv related database access? Do your shows
> show up properly?

On Sat, Jan 05, 2008 at 09:19:57PM -0800, Javier Perez wrote:
> More news.
> 
> This problem happens with kernel 2.6.23.8-34.fc7
> 
> When I switched to kernel 2.6.23.1-21.fc7, everything works fine, mythtranscode finally works fast and there is no more problem with mysql.
> Is there any kernel connection/dependency with mythtranscode ?
> 
> I wonder, and even more important, how can I flesh it out?

I don't think it is very likely that the kernel could be selectively
deciding whether the database speaks to mythfrontend, mythbackend or
mythtranscode.

Most probably what did make a difference was the reboot. I would
reboot into the working kernel and record every step I make t end up
with the successful transcoding. Then I would reboot into the other
kernel and repeat these steps. It shouldn't fail, but if it does add
some diagnostics to both setups like checking which services are up
and running, 'netstap -pan | grep mysql' and the like.
-- 
Axel.Thimm at ATrpms.net
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.atrpms.net/pipermail/atrpms-users/attachments/20080106/9401d0f5/attachment.bin