No subject
Sun Mar 1 18:40:12 UTC 2009
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 }
More information about the mythtv-users
mailing list