Opened 13 years ago

Closed 13 years ago

Last modified 12 years ago

#9575 closed Bug Report (Fixed)

Idle system causes corrupt recording on last viewed channel

Reported by: arizonamythtv@… Owned by: danielk
Priority: minor Milestone:
Component: MythTV - General Version: 0.24-fixes
Severity: medium Keywords:
Cc: Ticket locked: no

Description (last modified by sphery)

I'm compiling 0.24 on Mythbuntu 10.04 AMD64 using a PVR150. I'm controlling a STB with a IR blaster. When the system sits idle for a few days when I attempt to watch or record the last viewed channel I end up with a corrupt recording. I know the IR blaster switched to the proper channel as the STB OSD shows the correct channel change. I've checked the db and it comes back with no errors. As a work around I run a cron job to switch the channel to an off channel that I wouldn't record then I start liveTV the recording works properly.

2011-02-04 15:38:35.947 adding: john-desktop as a client (events: 0)
2011-02-04 15:38:35.948 MainServer::ANN Monitor
2011-02-04 15:38:35.948 adding: john-desktop as a client (events: 1)  
2011-02-04 15:38:49.695 MainServer::ANN Playback
2011-02-04 15:38:49.695 adding: john-desktop as a client (events: 0)
2011-02-04 15:38:49.699 TVRec(1): Changing from None to WatchingLiveTV
2011-02-04 15:38:49.699 ChannelBase(1) Error: Setting start channel '104' failed,
                        and we failed to find any suitible channels on any input.
2011-02-04 15:38:49.700 Error preparing query: SELECT channum, callsign, channel.chanid,        atsc_major_chan, atsc_minor_$
2011-02-04 15:38:49.701 Driver error was [2/1052]:
QMYSQL3: Unable to prepare statement
Database error was:
Column 'sourceid' in where clause is ambiguous

2011-02-04 15:38:49.701 DB Error (ChannelUtil::GetChannels()):
Query was:
SELECT channum, callsign, channel.chanid,        atsc_major_chan, atsc_minor_chan,        name, icon, mplexid, visible,     $
Driver error was [2/1052]:
QMYSQL: Unable to execute query
Database error was:
Column 'sourceid' in where clause is ambiguous

2011-02-04 15:38:49.703 LoadFromScheduler(): Error, called from backend.
2011-02-04 15:38:49.704 AutoExpire: CalcParams(): Max required Free Space: 2.0 GB w/freq: 15 min
2011-02-04 15:38:53.016 Finished recording 48 Hours on ID "To Catch a Stalker": channel 4104
2011-02-04 15:38:53.027 LoadFromScheduler(): Error, called from backend.
2011-02-04 15:38:53.029 AutoExpire: CalcParams(): Max required Free Space: 2.0 GB w/freq: 15 min

Change History (6)

comment:1 Changed 13 years ago by Raymond Wagner

Version: Unspecified0.24-fixes

comment:2 Changed 13 years ago by sphery

Description: modified (diff)

comment:3 Changed 13 years ago by sphery

Owner: set to danielk
Status: newassigned

The ambiguous sourceid was fixed in master by d14b660c168b3ead0ce0ea8bec49243325e73047 . Daniel should decide whether the change is too invasive for backporting.

comment:4 Changed 13 years ago by danielk

Resolution: Fixed
Status: assignedclosed

Fixed by [d65631013]

Fixes #9575. Fix an ambiguous DB query (fixed by [d14b660c16] in master).

comment:5 Changed 13 years ago by Raymond Wagner

Milestone: unknown0.24.2

comment:6 Changed 12 years ago by stuartm

Milestone: 0.24.2

Milestone 0.24.2 deleted

Note: See TracTickets for help on using tickets.