Was this ever resolved? Is there a bug filed in Trac?<br><br>I see the same on my combined backend/frontend, whenever a recording finishes while I'm watching something the picture freezes for a few seconds, sometimes a lot longer if 2 or 3 recordings finish at the same time, and in the standard frontend log I see:<br>
<br>2011-03-22 20:57:59.996 TV: ASK_RECORDING 2 29 0 0 hasrec: 0 haslater: 0<br>2011-03-22 20:58:00.577 ALSA, Error: WriteAudio: buffer underrun<br>2011-03-22 20:58:42.380 ALSA, Error: WriteAudio: buffer underrun<br>2011-03-22 20:58:58.982 PlaybackBox: Ignoring PREVIEW_SUCCESS, item no longer on screen.<br>
2011-03-22 20:58:59.622 TV: ASK_RECORDING 4 29 0 0 hasrec: 0 haslater: 0<br>2011-03-22 20:59:00.006 TV: ASK_RECORDING 9 29 0 0 hasrec: 0 haslater: 0<br>2011-03-22 20:59:00.006 TV: ASK_RECORDING 9 29 0 0 hasrec: 0 haslater: 0<br>
2011-03-22 20:59:00.006 TV: ASK_RECORDING 5 29 0 0 hasrec: 0 haslater: 0<br>2011-03-22 20:59:00.070 TV: ASK_RECORDING 8 29 0 0 hasrec: 0 haslater: 0<br>2011-03-22 20:59:00.070 TV: ASK_RECORDING 8 29 0 0 hasrec: 0 haslater: 0<br>
2011-03-22 20:59:37.411 ALSA, Error: WriteAudio: buffer underrun<br>2011-03-22 20:59:40.843 PlaybackBox: Ignoring PREVIEW_SUCCESS, item no longer on screen.<br>2011-03-22 21:00:04.877 ALSA, Error: WriteAudio: buffer underrun<br>
2011-03-22 21:00:13.864 PlaybackBox: Ignoring PREVIEW_SUCCESS, item no longer on screen.<br>2011-03-22 21:00:15.995 ALSA, Error: WriteAudio: buffer underrun<br><br>/ Niklas<br><br><div class="gmail_quote">On 9 March 2011 18:08, <span dir="ltr"><<a href="mailto:pnetherwood@email.com">pnetherwood@email.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><font color="black" face="Arial, Helvetica, sans-serif" size="2"><font size="2"><font face="Arial, Helvetica, sans-serif">Further to Josu's mail, r</font></font>un<font color="black" face="Arial, Helvetica, sans-serif" size="2"> my edited version in my earlier post. The query below was the first query in my post that uses temporary tables (i.e. sched_temp_record) and you'll get errors about it not being found. My last query can run stand alone. The result should be a list of programs that are scheduled to be recorded next. If you put the keyword 'explain' before select it will give you the explain plan in my earlier mail.
<div><div></div><div class="h5"><div> </div>
<div> <br>
</div>
<div> <br>
</div>
<div style="font-family: arial,helvetica; font-size: 10pt; color: black;">-----Original Message-----<br>
From: Josu Lazkano <<a href="mailto:josu.lazkano@gmail.com" target="_blank">josu.lazkano@gmail.com</a>><br>
To: Discussion about MythTV <<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a>><br>
Sent: Tue, Mar 8, 2011 3:20 pm<br>
Subject: Re: [mythtv-users] Mythtv 0.24 Acer Revo ALSA WriteAudio buffer underruns<br>
<br>
<div style="margin: 0px; font-family: Tahoma,Verdana,Arial,Sans-Serif; font-size: 12px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<pre style="font-size: 9pt;"><tt>Hello again, I try to execute the SQL command this way:<br>
<br>
$ mysql -u mythtv -pPASS mythconverg<br>
<br>
SELECT c.chanid, c.sourceid, p.starttime, p.endtime, p.title,<br>
p.subtitle, p.description, c.channum, c.callsign, <a href="http://c.name" target="_blank">c.name</a>,<br>
oldrecduplicate, p.category, sched_temp_record.recpriority,<br>
sched_temp_record.dupin, recduplicate, findduplicate,<br>
sched_temp_record.type, sched_temp_record.recordid, p.starttime -<br>
INTERVAL sched_temp_record.startoffset minute AS recstartts, p.endtime<br>
+ INTERVAL sched_temp_record.endoffset minute AS recendts,<br>
p.previouslyshown, sched_temp_record.recgroup,<br>
sched_temp_record.dupmethod, c.commmethod, capturecard.cardid,<br>
cardinput.cardinputid,p.seriesid, p.programid, p.category_type,<br>
p.airdate, p.stars, p.originalairdate, sched_temp_record.inactive,<br>
sched_temp_record.parentid, (CASE sched_temp_record.type WHEN 6 THEN<br>
sched_temp_record.findid WHEN 9 THEN to_days(date_sub(p.starttime,<br>
interval time_format(sched_temp_record.findtime, '%H:%i')<br>
hour_minute)) WHEN 10 THEN floor((to_days(date_sub(p.starttime,<br>
interval time_format(sched_temp_record.findtime, '%H:%i')<br>
hour_minute)) - sched_temp_record.findday)/7) * 7 +<br>
sched_temp_record.findday WHEN 7 THEN sched_temp_record.findid ELSE 0<br>
END) , sched_temp_record.playgroup, oldrecstatus.recstatus,<br>
oldrecstatus.reactivate, p.videoprop+0, p.subtitletypes+0,<br>
p.audioprop+0, sched_temp_record.storagegroup, capturecard.hostname,<br>
recordmatch.oldrecstatus, sched_temp_record.avg_delay,<br>
c.recp0.24.0+fixes.20110206.1a69c92riority + cardinput.recpriority +<br>
(cardinput.cardinputid = sched_temp_record.prefinput) * 2 AS<br>
powerpriority FROM recordmatch INNER JOIN sched_temp_record ON<br>
(recordmatch.recordid = sched_temp_record.recordid) INNER JOIN program<br>
AS p ON ( recordmatch.chanid = p.chanid AND recordmatch.starttime =<br>
p.starttime AND recordmatch.manualid = p.manualid ) INNER JOIN channel<br>
AS c ON ( c.chanid = p.chanid ) INNER JOIN cardinput ON (c.sourceid =<br>
cardinput.sourceid) INNER JOIN capturecard ON (capturecard.cardid =<br>
cardinput.cardid) LEFT JOIN oldrecorded as oldrecstatus ON (<br>
oldrecstatus.station = c.callsign AND oldrecstatus.starttime =<br>
p.starttime AND oldrecstatus.title = p.title ) WHERE p.endtime >=<br>
NOW() - INTERVAL 1 DAY ORDER BY sched_temp_record.recordid DESC;<br>
<br>
But I have no any output and there is no buffer stop on the frontend,<br>
how can I test it?<br>
<br>
Sorry for my stupid questions, but I want to test to help fixing this<br>
problem. I have FE/BE on a Nvidia ION 330 board.<br>
<br>
Kind regards.<br>
<br>
-- <br>
Josu Lazkano<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
</tt></pre>
</div>
</div>
</div></div></font></font>
<br>_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<br></blockquote></div><br>