[mythtv-users] mythtv failure

[Sid Boyce]

Sid Boyce wrote:
Same problems with trunk 14506 and 14511.
mythbackend is still running.
25880 pts/3    Sl     0:00 /usr/bin/mythbackend -l /var/log/mythbackend.log

I can do the queries to mythconverg as user mysql with pasword mysql.
# mysql -umythtv -pmythtv
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.0.45-Max SUSE MySQL RPM

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \u mythconverg
Database changed
mysql> SELECT chanid, channum, callsign, name, commmethod, outputfilters 
FROM channel WHERE chanid = '1714' ;
+--------+---------+----------+------+------------+---------------+
| chanid | channum | callsign | name | commmethod | outputfilters |
+--------+---------+----------+------+------------+---------------+
|   1714 | 714     | heat     | heat |         -1 |               |
+--------+---------+----------+------+------------+---------------+
1 row in set (0.00 sec)

mysql> 
 Don't understand what is happening. Lots of "QMYSQL3: Unable to execute 
query"

2007-09-21 13:52:02.942 DB Error (ProgramInfo: GetProgramAtDateTime):
Query was:
SELECT chanid, channum, callsign, name, commmethod, outputfilters FROM 
channel WHERE chanid = '1211' ;
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

2007-09-21 13:52:04.056 DB Error (ProgramList::FromProgram):
Query was:
SELECT DISTINCT program.chanid, program.starttime, program.endtime,     
program.title, program.subtitle, program.description,     
program.category, channel.channum, channel.callsign,     channel.name, 
program.previouslyshown, channel.commmethod,     channel.outputfilters, 
program.seriesid, program.programid,     program.airdate, program.stars, 
program.originalairdate,     program.category_type, 
oldrecstatus.recordid,     oldrecstatus.rectype, 
oldrecstatus.recstatus,     oldrecstatus.findid FROM program LEFT JOIN 
channel ON program.chanid = channel.chanid LEFT JOIN oldrecorded AS 
oldrecstatus ON     program.title = oldrecstatus.title AND     
channel.callsign = oldrecstatus.station AND     program.starttime = 
oldrecstatus.starttime WHERE program.chanid = '1206'   AND 
program.starttime < '2007-09-21T13:52:50'   AND program.endtime > 
'2007-09-21T13:52:50'  GROUP BY program.starttime, channel.channum,   
channel.callsign, program.title  ORDER BY program.starttime, 
atsc_major_chan,atsc_minor_chan,channum,callsign  LIMIT 1000
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

2007-09-21 13:52:04.056 DB Error (ProgramInfo: GetProgramAtDateTime):
Query was:
SELECT chanid, channum, callsign, name, commmethod, outputfilters FROM 
channel WHERE chanid = '1206' ;
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

2007-09-21 13:52:21.050 TV: CommitQueuedInput() livetv(1) qchannum() 
qchanid(0)
2007-09-21 13:52:21.054 TV: ChangeChannel(0, '')
Signal: Interrupt
Ungrabbing XVideo port: 224

Any ideas anyone?
Regards
Sid.

-- 
Sid Boyce ... Hamradio License G3VBV, Licensed Private Pilot
Emeritus IBM/Amdahl Mainframes and Sun/Fujitsu Servers Tech Support Specialist, Cricket Coach
Microsoft Windows Free Zone - Linux used for all Computing Tasks