No subject

2009-03-24 02:26:35.364 DB Error (Looking up chanID):
Query was:
SELECT chanid, useonairguide 
FROM channel, dtv_multiplex 
WHERE serviceid        = 18304   
AND       networkid        = 9018   
AND       transportid      = 16384 
AND channel.mplexid  = dtv_multiplex.mplexid 
AND channel.sourceid = 1

No error type from QSqlError?  Strange...
2009-03-24 02:26:38.903 DB Error (Looking up chanID):
Query was:

No error type from QSqlError?  Strange...
2009-03-24 02:26:38.904 DB Error (Looking up chanID):
Query was:

No error type from QSqlError?  Strange...
2009-03-24 02:26:39.115 DB Error (Looking up chanID):
Query was:

--repeated many times--
In this instance it looks as though it finally fell over and monit restarted
it.  In the past though it has just got stuck in this state.

I don't have anything in the channel table with serviceid 18304 and when
checking this query as expected it returns zero rows.  From the rest of the
query it would seem to be a channel on Mux B (BBC FOUR,BBC Red Button etc)

Some more information at the bottom of the email.

Any suggestions?

Cheers
Stephen



MythTV Version   : 20239
MythTV Branch    : branches/release-0-21-fixes
Library API      : 0.21.20080304-1
Network Protocol : 40
Options compiled in:
 linux profile using_oss using_alsa using_jack using_backend using_dbox2
using_dvb using_firewire using_frontend using_hdhomerun using_iptv
using_ivtv using_joystick_menu using_libfftw3 using_lirc using_opengl_vsync
using_opengl_video using_v4l using_x11 using_xrandr using_xv using_xvmc
using_xvmcw using_xvmc_vld using_glx_proc_addr_arb using_bindings_perl
using_bindings_python using_opengl using_ffmpeg_threads using_libavc_5_3
using_live

Possibly relevant section from eithelper.cpp:

636	// Figure out the chanid for this channel
637	static uint get_chan_id_from_db(uint sourceid, uint serviceid,
638	                                uint networkid, uint transportid)
639	{
640	    MSqlQuery query(MSqlQuery::InitCon());
641	
642	    // DVB Link to chanid
643	    QString qstr =
644	        "SELECT chanid, useonairguide "
645	        "FROM channel, dtv_multiplex "
646	        "WHERE serviceid        = :SERVICEID   AND "
647	        "      networkid        = :NETWORKID   AND "
648	        "      transportid      = :TRANSPORTID AND "
649	        "      channel.mplexid  = dtv_multiplex.mplexid";
650	
651	    if (sourceid)
652	        qstr += " AND channel.sourceid = :SOURCEID";
653	
654	    query.prepare(qstr);
655	    query.bindValue(":SERVICEID",   serviceid);
656	    query.bindValue(":NETWORKID",   networkid);
657	    query.bindValue(":TRANSPORTID", transportid);
658	
659	    if (sourceid)
660	        query.bindValue(":SOURCEID", sourceid);
661	
662	    if (!query.exec() || !query.isActive())
663	        MythContext::DBError("Looking up chanID", query);
664	    else if (query.next())
665	    {
666	        // Check to see if we are interseted in this channel
667	        bool useOnAirGuide = query.value(1).toBool();
668	        return (useOnAirGuide) ? query.value(0).toUInt() : 0;
669	    }
670	
671	    return 0;
672	}