Modify
Warning Please read the Ticket HowTo before creating or commenting on a ticket. Failure to do so may cause your ticket to be rejected or result in a slower response.

Opened 3 years ago

Closed 3 years ago

Last modified 2 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 mdean)

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

Attachments (0)

Change History (6)

comment:1 Changed 3 years ago by wagnerrp

  • Version changed from Unspecified to 0.24-fixes

comment:2 Changed 3 years ago by mdean

  • Description modified (diff)

comment:3 Changed 3 years ago by mdean

  • Owner set to danielk
  • Status changed from new to assigned

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

comment:4 Changed 3 years ago by danielk

  • Resolution set to Fixed
  • Status changed from assigned to closed

Fixed by [d65631013]

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

comment:5 Changed 3 years ago by wagnerrp

  • Milestone changed from unknown to 0.24.2

comment:6 Changed 2 years ago by stuartm

  • Milestone 0.24.2 deleted

Milestone 0.24.2 deleted

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'new'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.