| Tuesday, September 11th, 2012, 00:30 UTC | ||
| [00:30:37] | andreax1 (andreax1!~andreaz@p4FE64C95.dip.t-dialin.net) has joined #mythtv | |
| [00:31:54] | andreax (andreax!~andreaz@79.230.67.170) has quit (Ping timeout: 264 seconds) | |
| [00:33:44] | andreax1 (andreax1!~andreaz@p4FE64C95.dip.t-dialin.net) has quit (Read error: Connection reset by peer) | |
| [00:35:47] | pvr4me (pvr4me!~craigtrel@d24-150-182-175.home.cgocable.net) has joined #mythtv | |
| [00:36:23] | pvr4me: | Hi |
| [00:36:51] | pvr4me: | I posted a question the other day about using --setloglevel and --setverbose on a running backend |
| [00:37:18] | pvr4me: | If I use both, the latter seems to cancel the effect of the former |
| [00:37:32] | pvr4me: | Is that expected behaviour? |
| [00:45:13] | malelan (malelan!~malelan@173-9-101-130-NewEngland.hfc.comcastbusiness.net) has joined #mythtv | |
| [00:46:00] | malelan2 (malelan2!~malelan@173-9-101-130-NewEngland.hfc.comcastbusiness.net) has quit (Ping timeout: 276 seconds) | |
| [00:55:30] | pvr4me (pvr4me!~craigtrel@d24-150-182-175.home.cgocable.net) has quit (Quit: pvr4me) | |
| [01:11:20] | dekarl1 (dekarl1!~dekarl@p4FCEEA32.dip.t-dialin.net) has joined #mythtv | |
| [01:12:55] | dekarl (dekarl!~dekarl@p4FCEE536.dip.t-dialin.net) has quit (Ping timeout: 265 seconds) | |
| [01:42:05] | zombor (zombor!~zombor_@kohana/developer/zombor) has quit (Remote host closed the connection) | |
| [01:49:23] | neufeld_AFK is now known as neufeld | |
| [01:52:11] | neufeld: | jpabq: to continue our conversation about HD-PVR and polling, I did a test today. I have my change-channel script, which uses an IR-blaster to control the STB, and it also uses v4l2-ctl to set audio_encoding=4, because that's what I see happening in the MythTV logs. It then sleeps for 2 seconds. I use that in this invocation: |
| [01:52:21] | neufeld: | for j in `seq 1 100` ; do for i in 1 2 3 4 ; do /root/bin/change-hd.sh 550 ; /root/bin/change-hd.sh 575 ; timeout ${i} cat /dev/hdpvr > wibble-$j-$i ; sleep 3 ; done ; done |
| [01:55:01] | neufeld: | This produced 400 output files. 3 of them were 0-length, indicating a failure to read(). 397 of them were streams that consistently began about 0.3 seconds after the cat began. A less than 1% failure rate on startup is reasonable for me, but that's not what I get when mythbackend is doing approximately the same things. In that case, successful on-time starts are rare, typically I get 3 to 60 minutes of |
| [01:55:01] | neufeld: | consecutive poll timeouts before the reading begins working. |
| [01:56:17] | neufeld: | jpabq: my STB is set to force 1080i output regardless of the source resolution. I turned on 'VB_RECORD' logging in the backend, and handleHDPVR() reports nothing unpleasant |
| [01:57:29] | neufeld: | is there anything you can recommend to make my cat-based tests more like the backend? Another v4l2-ctl to run (strace isn't very helpful on ioctls)? I'm trying to figure out why cat works but the backend struggles. |
| [02:00:40] | jpabq: | neufeld, Try changing m_stable_time(2000) to m_stable_time(8000) in analogsignalmonitor.cpp . |
| [02:00:51] | jpabq: | audio_encoding=4 sets the audio input to S/PDIF |
| [02:02:18] | Ruler_Of_Heaven_ (Ruler_Of_Heaven_!~pipopopo@ip-83-101-33-39.customer.schedom-europe.net) has joined #mythtv | |
| [02:02:19] | neufeld: | jpabq: OK, patching... |
| [02:02:28] | jpabq: | neufeld, if you want, email me your backend log that shows a failure with -v record,channel — jppoet at gmail |
| [02:02:37] | pipopopo (pipopopo!~pipopopo@ip-83-101-33-78.customer.schedom-europe.net) has quit (Ping timeout: 260 seconds) | |
| [02:03:18] | neufeld: | jpabq: thanks, I'll send you that going once I've got the new lib in place |
| [02:04:02] | jpabq: | neufeld, okay — I am going to watch some TV, but will check back here after a while. |
| [02:05:27] | neufeld: | jpabq: absolutely, thank you for your time on this. I'll send an email shortly, but take your time with it, I'll be heading to sleep soon. |
| [02:08:57] | Ruler_Of_Heaven_ (Ruler_Of_Heaven_!~pipopopo@ip-83-101-33-39.customer.schedom-europe.net) has quit (Ping timeout: 268 seconds) | |
| [02:09:17] | pipopopo (pipopopo!~pipopopo@ip-83-101-33-91.customer.schedom-europe.net) has joined #mythtv | |
| [02:30:03] | jpabq: | neufeld, the only thing I can think of in Myth, that would cause variability in the HD-PVR working for some people, and not others, is that m_stable_time value. It is tricky, because we want it as small as possible for LiveTV, but large enough to provide reliability. If using a larger value fixes your problem, then perhaps we could use different values for LiveTV and Recording... |
| [02:34:11] | joki (joki!~joki@p54861E03.dip.t-dialin.net) has quit (Ping timeout: 245 seconds) | |
| [02:34:50] | joki (joki!~joki@p54861C4D.dip.t-dialin.net) has joined #mythtv | |
| [02:38:39] | neufeld: | jpabq: The longer settling time didn't fix it for me. I'm composing the email with the log now. |
| [02:41:22] | neufeld: | jpabq: OK, log sent |
| [02:42:15] | neufeld: | jpabq: BTW, that audio-encoding ioctl(), I believe that's an AAC/AC3 thing, not SPDIF/RCA |
| [03:03:35] | jpabq: | neufeld, re ioctl, you are right. |
| [03:04:28] | neufeld: | jpabq: well, I'm going to retire for the evening. Thank you again for taking the time to go over this with me, I'll continue poking at the library in the morning. |
| [03:04:30] | neufeld is now known as neufeld_AFK | |
| [03:04:59] | jpabq: | neufeld, what linux distribution are you using? I am on Fedora, and have a 99.9% success rate with both of my HD-PVRs |
| [03:05:33] | jpabq: | Those logs really seem to indicate some lower level system problem — or hardware problem. |
| [03:05:38] | neufeld_AFK: | jpabq: I'm using LinHES, a specialized MythTV distribution based on Arch Linux. |
| [03:06:08] | neufeld_AFK: | jpabq: Yeah, but I always come back to asking why cat works reliably. I'm trying to make the backend look like cat. |
| [03:06:47] | jpabq: | I will think about it |
| [03:07:30] | neufeld_AFK: | jpabq: thank you. If I make any progress tomorrow, I'll let you know. |
| [03:07:33] | ** neufeld_AFK really goes AFK ** | |
| [03:07:42] | jpabq: | good nighit |
| [03:12:53] | kurre2 (kurre2!~tomimo@xdsl-83-150-88-111.nebulazone.fi) has quit (Read error: Connection reset by peer) | |
| [03:18:37] | NightMonkey (NightMonkey!~NightrMon@pdpc/supporter/professional/nightmonkey) has quit (Remote host closed the connection) | |
| [03:26:16] | kurre2 (kurre2!~tomimo@xdsl-83-150-88-111.nebulazone.fi) has joined #mythtv | |
| [04:37:47] | foxbuntu (foxbuntu!~foxbuntu@ubuntu/member/foxbuntu) has quit (Ping timeout: 246 seconds) | |
| [04:41:34] | foxbuntu (foxbuntu!~foxbuntu@67-3-88-151.desm.qwest.net) has joined #mythtv | |
| [04:41:40] | foxbuntu (foxbuntu!~foxbuntu@ubuntu/member/foxbuntu) has joined #mythtv | |
| [04:41:40] | foxbuntu (foxbuntu!~foxbuntu@67-3-88-151.desm.qwest.net) has quit (Changing host) | |
| [05:34:49] | sraue (sraue!~stephan@xbmc/staff/sraue) has quit (Ping timeout: 260 seconds) | |
| [05:48:05] | sraue (sraue!~stephan@xbmc/staff/sraue) has joined #mythtv | |
| [06:03:45] | FabriceMG (FabriceMG!~Thunderbi@217.112.59.207) has joined #mythtv | |
| [06:37:16] | pheld (pheld!~heldal@cl-5.osl-01.no.sixxs.net) has joined #mythtv | |
| [07:26:27] | joki (joki!~joki@p54861C4D.dip.t-dialin.net) has quit (Ping timeout: 244 seconds) | |
| [07:26:52] | joki (joki!~joki@p54861C4D.dip.t-dialin.net) has joined #mythtv | |
| [07:39:38] | SteveGoodey (SteveGoodey!~steve@host86-140-215-72.range86-140.btcentralplus.com) has joined #mythtv | |
| [07:58:40] | Yanch0 (Yanch0!~mpulis@unaffiliated/yancho) has quit (Ping timeout: 246 seconds) | |
| [08:55:29] | Yancho (Yancho!~mpulis@46.11.41.183) has joined #mythtv | |
| [08:55:29] | Yancho (Yancho!~mpulis@unaffiliated/yancho) has joined #mythtv | |
| [08:55:29] | Yancho (Yancho!~mpulis@46.11.41.183) has quit (Changing host) | |
| [08:56:17] | SteveGoodey (SteveGoodey!~steve@host86-140-215-72.range86-140.btcentralplus.com) has quit (Remote host closed the connection) | |
| [09:09:44] | Yancho (Yancho!~mpulis@unaffiliated/yancho) has joined #mythtv | |
| [09:11:46] | ManGEE2 (ManGEE2!~ManGee2@59.167.103.234) has quit (Ping timeout: 246 seconds) | |
| [09:36:48] | SteveGoodey (SteveGoodey!~steve@host86-140-215-72.range86-140.btcentralplus.com) has joined #mythtv | |
| [09:43:48] | Yanch0 (Yanch0!~mpulis@unaffiliated/yancho) has joined #mythtv | |
| [09:46:48] | Yancho (Yancho!~mpulis@unaffiliated/yancho) has quit (Ping timeout: 276 seconds) | |
| [10:08:35] | SteveGoodey (SteveGoodey!~steve@host86-140-215-72.range86-140.btcentralplus.com) has quit (Remote host closed the connection) | |
| [10:08:46] | brfransen (brfransen!~brfransen@64.179.141.163) has quit (Ping timeout: 245 seconds) | |
| [10:09:43] | brfransen (brfransen!~brfransen@64.179.141.163) has joined #mythtv | |
| [10:18:54] | Yancho (Yancho!~mpulis@unaffiliated/yancho) has joined #mythtv | |
| [10:21:15] | Yanch0 (Yanch0!~mpulis@unaffiliated/yancho) has quit (Ping timeout: 276 seconds) | |
| [10:50:52] | zombor (zombor!~zombor_@kohana/developer/zombor) has joined #mythtv | |
| [10:57:54] | zombor (zombor!~zombor_@kohana/developer/zombor) has quit (Remote host closed the connection) | |
| [11:03:08] | IReboot (IReboot!~doug@CPE1caff7df6774-CM00252eac6f40.cpe.net.cable.rogers.com) has quit (Remote host closed the connection) | |
| [11:09:41] | coling (coling!~colin@cpc7-sgyl36-2-0-cust267.18-2.cable.virginmedia.com) has quit (Ping timeout: 244 seconds) | |
| [11:10:25] | coling (coling!~colin@cpc7-sgyl36-2-0-cust267.18-2.cable.virginmedia.com) has joined #mythtv | |
| [12:17:02] | amessina (amessina!~amessina@2001:470:c1dc:7779:d6be:d9ff:fe8d:7c1e) has joined #mythtv | |
| [12:22:45] | gregL (gregL!~greg@cpe-74-76-125-87.nycap.res.rr.com) has quit (Read error: Connection reset by peer) | |
| [12:38:00] | pheld (pheld!~heldal@cl-5.osl-01.no.sixxs.net) has quit (Quit: Leaving.) | |
| [12:39:47] | gregL (gregL!~greg@cpe-74-76-125-87.nycap.res.rr.com) has joined #mythtv | |
| [12:40:33] | dmfrey (dmfrey!~dmfrey@webdefence.cluster-h.websense.net) has joined #mythtv | |
| [13:23:13] | zombor (zombor!~zombor_@kohana/developer/zombor) has joined #mythtv | |
| [13:24:56] | beppo (beppo!5fdfe86f@gateway/web/freenode/ip.95.223.232.111) has joined #mythtv | |
| [13:25:38] | beppo (beppo!5fdfe86f@gateway/web/freenode/ip.95.223.232.111) has left #mythtv () | |
| [13:37:28] | stichnot: | sphery, gigem: In mythfrontend/customedit.cpp, custom rule "First Episodes (complete example for Data Direct)". The clause "AND program.originalairdate = DATE(program.starttime) " doesn't take UTC into account so (at least on the west coast) starttime ends up a day later than originalairdate and the rule doesn't match. |
| [13:38:09] | stichnot: | Several of the rules convert to UTC, and several don't. Any idea what the pattern is/should be? |
| [13:38:46] | gregL (gregL!~greg@cpe-74-76-125-87.nycap.res.rr.com) has quit (Quit: Leaving) | |
| [13:50:36] | stichnot: | Of course, changing code in customedit.cpp only helps first-time setup of one of these custom rule templates. Should we be trying to auto-update users' custom rules that are based on dates/times? |
| [14:20:13] | gigem: | stichnot: I thought I'd gotten all of the custom examples that needed fixing, but I guess I missed that one. If there are others, please let me know. As for existing users, I don't know that we can do much. It would take some advanced regex code to match and convert the right patterns, and even then, I'd be concerned about it not always working right. I thought I'd mentioned at one time putting a big |
| [14:20:15] | gigem: | warning in the release notes that users needed to update their custom rules themselves. |
| [14:20:56] | wagnerrp: | are those supposed to be in localtime or UTC? |
| [14:22:09] | clever (clever!~clever@142.134.225.213) has quit (Ping timeout: 260 seconds) | |
| [14:28:06] | andreax (andreax!~andreaz@p4FE64C95.dip.t-dialin.net) has joined #mythtv | |
| [14:30:29] | neufeld_AFK is now known as neufeld | |
| [14:30:37] | hemi770 (hemi770!~hemi666@ppp121-44-242-145.lns20.syd7.internode.on.net) has quit (Quit: leaving) | |
| [14:31:08] | andreax (andreax!~andreaz@p4FE64C95.dip.t-dialin.net) has quit (Client Quit) | |
| [14:31:42] | andreax (andreax!~andreaz@p4FE64C95.dip.t-dialin.net) has joined #mythtv | |
| [14:34:04] | stichnot: | wagnerrp: in my example, I have program.originalairdate=2012-09–24 and program.starttime=2012-09–25 03:30:00 |
| [14:38:14] | neufeld: | jpabq: I think I've had a breakthrough. I wrote up a tiny C++ program to open the HD-PVR device, and then read it either by bare read(), by select() then read(), or poll() then read(). I fiddled with the timeouts from 1 to 3 seconds in select and poll, and watched everything in strace. In my tests, the first select/poll after open() always times out, and the second one always returns immediately with data ready. |
| [14:38:15] | neufeld: | Unhappily, a bare read doesn't always work, but there's, so far, no pattern to this. It sounds, then, like a V4L driver bug. Because MythTV polls only once and on a timeout closes the descriptor to reset the device, it has a lot of difficulty starting up. I'm going to try to put in a dummy poll() in my libmythtv to see if I can fix my problems. |
| [14:49:06] | clever (clever!~clever@142.134.225.240) has joined #mythtv | |
| [14:53:01] | gigem: | wagnerrp: program.originalairdate is just a date, so it's effectively local time. |
| [14:58:47] | stichnot: | I changed my local rule to convert starttime to UTC and it works correctly again. |
| [15:02:29] | gigem: | stichnot: That's the correct change. |
| [15:02:51] | clever (clever!~clever@142.134.225.240) has quit (Read error: Operation timed out) | |
| [15:04:51] | FabriceMG (FabriceMG!~Thunderbi@217.112.59.207) has quit (Quit: FabriceMG) | |
| [15:05:57] | stichnot (stichnot!~stichnot@mythtv/developer/stichnot) has quit (Ping timeout: 276 seconds) | |
| [15:07:16] | bill6502 (bill6502!~bill@2002:cdb2:1a2b:7cd3:9ef4:32ea:c6ea:200) has joined #mythtv | |
| [15:11:06] | MissDee is now known as Anoia | |
| [15:13:56] | neufeld: | jpabq: that extra poll() is not fixing it, I'll try some more later |
| [15:23:10] | bill6502: | gigem: "Times in existing custom recording rules that include starttime or endtime must be manually changed to UTC" just added to the 0.26 notes (haven't pressed Save page yet.) |
| [15:36:55] | clever (clever!~clever@142.162.244.228) has joined #mythtv | |
| [15:38:35] | IReboot (IReboot!~doug@CPE1caff7df6774-CM00252eac6f40.cpe.net.cable.rogers.com) has joined #mythtv | |
| [15:39:44] | gregL (gregL!~greg@cpe-74-76-125-87.nycap.res.rr.com) has joined #mythtv | |
| [15:46:46] | NightMonkey (NightMonkey!~NightrMon@pdpc/supporter/professional/nightmonkey) has joined #mythtv | |
| [15:46:54] | gigem: | bill6502: Excellent! |
| [16:07:47] | natanojl (natanojl!~jonatan@c83-252-237-63.bredband.comhem.se) has joined #mythtv | |
| [16:23:57] | stichnot (stichnot!~stichnot@192.55.55.37) has joined #mythtv | |
| [16:23:58] | stichnot (stichnot!~stichnot@mythtv/developer/stichnot) has joined #mythtv | |
| [16:23:58] | stichnot (stichnot!~stichnot@192.55.55.37) has quit (Changing host) | |
| [16:31:09] | Mousey (Mousey!~r0dent_@ross154.net) has joined #mythtv | |
| [16:51:13] | IReboot (IReboot!~doug@CPE1caff7df6774-CM00252eac6f40.cpe.net.cable.rogers.com) has quit (Remote host closed the connection) | |
| [16:52:39] | Mousey (Mousey!~r0dent_@ross154.net) has quit (Read error: Connection reset by peer) | |
| [16:53:29] | Mousey (Mousey!~r0dent_@ross154.net) has joined #mythtv | |
| [16:58:55] | Cougar (Cougar!~cougar@2a03:5880:104:5:202:b3ff:fe2d:8a90) has quit (Ping timeout: 272 seconds) | |
| [17:02:07] | stichnot_ (stichnot_!~stichnot@134.134.137.71) has joined #mythtv | |
| [17:04:31] | stichnot_ is now known as stichnot | |
| [17:10:49] | Cougar (Cougar!~cougar@kkk.version6.net) has joined #mythtv | |
| [17:17:19] | NightMonkey (NightMonkey!~NightrMon@pdpc/supporter/professional/nightmonkey) has quit (Remote host closed the connection) | |
| [17:40:56] | Vernon_at_work (Vernon_at_work!~singv003@lightcloud.verns.net) has quit (Remote host closed the connection) | |
| [17:42:05] | SteveGoodey (SteveGoodey!~steve@host86-140-215-72.range86-140.btcentralplus.com) has joined #mythtv | |
| [17:42:37] | Vernon_at_work (Vernon_at_work!~singv003@lightcloud.verns.net) has joined #mythtv | |
| [17:43:49] | NightMonkey (NightMonkey!~NightrMon@pdpc/supporter/professional/nightmonkey) has joined #mythtv | |
| [17:43:53] | NightMonkey_ (NightMonkey_!~NightrMon@pdpc/supporter/professional/nightmonkey) has joined #mythtv | |
| [17:49:49] | Goga777 (Goga777!~Goga777@2.95.240.146) has joined #mythtv | |
| [17:55:32] | Goga777 (Goga777!~Goga777@2.95.240.146) has quit (Ping timeout: 248 seconds) | |
| [17:56:19] | Goga777 (Goga777!~Goga777@2.95.240.146) has joined #mythtv | |
| [18:02:05] | natanojl (natanojl!~jonatan@c83-252-237-63.bredband.comhem.se) has quit (Ping timeout: 260 seconds) | |
| [18:02:17] | dmfrey: | on mythbuntu 12.04 fresh install with libcec installed and user running mythtv in the dialout group, why can't mythtv find the libcec library with error: "cecadapter.cpp:128 (Open) CECAdapter: Failed to load libcec." |
| [18:02:32] | dmfrey: | that message is in the mythfrontend log |
| [18:03:42] | stuartm: | is the libcec binary in a directory included in ld.so.conf? |
| [18:03:44] | stichnot_ (stichnot_!stichnot@nat/intel/x-eciqundfbvhygedc) has joined #mythtv | |
| [18:04:41] | stuartm: | if the linker can't find the lib then it can't be used |
| [18:05:27] | stichnot (stichnot!~stichnot@134.134.137.71) has quit (Ping timeout: 245 seconds) | |
| [18:05:39] | stichnot_ is now known as stichnot | |
| [18:05:48] | dmfrey: | looks like it is installed in /usr/lib/libcec.so.1 |
| [18:11:21] | dmfrey: | so i just need to add a .conf file /etc/ld.so.conf.d/ and add the location of that file? |
| [18:16:13] | ElmerFudd: | dmfrey: /usr/lib is part of the standard lib path, maybe libcec has unresolved dependencies – does ldd /usr/lib/libcec.so.1 show any missing dependencies? |
| [18:18:15] | dmfrey: | ElmerFudd, http://pastebin.com/ps1q6Bs6 |
| [18:18:25] | dmfrey: | doesn't look like anything is missing |
| [18:28:08] | stuartm: | dmfrey: you would add a conf file and then run ldconfig to update, you might still try running ldconfig just in case it wasn't done when you installed libcec |
| [18:28:58] | NightMonkey_ (NightMonkey_!~NightrMon@pdpc/supporter/professional/nightmonkey) has quit (Quit: Body blow! Body blow!) | |
| [18:29:18] | dmfrey: | i can run cec-client without issue, btw |
| [18:30:17] | stuartm (stuartm!~stuartm@mythtv/developer/stuartm) has quit (Quit: Gone) | |
| [18:30:28] | stichnot: | bill6502, gigem: The special note in the Release Notes about custom recording rules is good, but almost no one will know what needs to be done. If someone who knows what they're doing (or alternatively me) posts additional instructions to the -users list, the release notes could link to that post. |
| [18:33:45] | stuartm (stuartm!~stuartm@cpc1-derb9-0-0-cust441.8-3.cable.virginmedia.com) has joined #mythtv | |
| [18:33:45] | stuartm (stuartm!~stuartm@cpc1-derb9-0-0-cust441.8-3.cable.virginmedia.com) has quit (Changing host) | |
| [18:33:45] | stuartm (stuartm!~stuartm@mythtv/developer/stuartm) has joined #mythtv | |
| [18:34:51] | stuartm (stuartm!~stuartm@mythtv/developer/stuartm) has quit (Client Quit) | |
| [18:35:23] | stuartm (stuartm!~stuartm@cpc1-derb9-0-0-cust441.8-3.cable.virginmedia.com) has joined #mythtv | |
| [18:35:28] | stuartm (stuartm!~stuartm@cpc1-derb9-0-0-cust441.8-3.cable.virginmedia.com) has quit (Changing host) | |
| [18:35:28] | stuartm (stuartm!~stuartm@mythtv/developer/stuartm) has joined #mythtv | |
| [18:40:06] | Goga777 (Goga777!~Goga777@2.95.240.146) has quit (Ping timeout: 246 seconds) | |
| [18:40:59] | stichnot (stichnot!stichnot@nat/intel/x-eciqundfbvhygedc) has quit (Quit: ChatZilla 0.9.88.2 [Firefox 15.0/20120824154833]) | |
| [18:45:07] | dmfrey: | had to install libcec-dev from the libcec ppa in order to get mythfrontend to know that libcec was installed |
| [18:45:42] | dmfrey: | went looking through the cecadapter.cpp and saw the libcec headers it was trying to load which were not on my system |
| [18:45:53] | dmfrey: | installing the dev package fixed that |
| [18:51:18] | bill6502: | stichnot: Good call, I just added; for example if you're in the CDT timezone (UTC-5) and you currently have a rule with starttime='2012-09–12 10:00:00', then change it to starttime='2012-09–12 05:00:00'. |
| [18:52:07] | caelor_ (caelor_!~caelor@cpc12-sotn9-2-0-cust374.15-1.cable.virginmedia.com) has quit (Ping timeout: 246 seconds) | |
| [18:52:38] | caelor_ (caelor_!~caelor@cpc12-sotn9-2-0-cust374.15-1.cable.virginmedia.com) has joined #mythtv | |
| [18:56:42] | SteveGoodey (SteveGoodey!~steve@host86-140-215-72.range86-140.btcentralplus.com) has quit (Remote host closed the connection) | |
| [18:57:26] | neufeld` (neufeld`!~user@ottawa-hs-206-191-28-140.s-ip.magma.ca) has joined #mythtv | |
| [18:57:33] | NightMonkey (NightMonkey!~NightrMon@pdpc/supporter/professional/nightmonkey) has quit (*.net *.split) | |
| [18:57:34] | _charly_ (_charly_!kroseneg@sunrise.schmidham.net) has quit (*.net *.split) | |
| [18:57:34] | sphery (sphery!~mdean@mythtv/developer/sphery) has quit (*.net *.split) | |
| [18:57:34] | neufeld (neufeld!~user@ottawa-hs-206-191-28-140.s-ip.magma.ca) has quit (*.net *.split) | |
| [18:57:34] | ElmerFudd (ElmerFudd!~le@0x5737a682.cpe.ge-0-1-0-1101.hsnqu1.customer.tele.dk) has quit (*.net *.split) | |
| [18:58:47] | NightMonkey (NightMonkey!~NightrMon@pdpc/supporter/professional/nightmonkey) has joined #mythtv | |
| [18:58:48] | _charly_ (_charly_!kroseneg@sunrise.schmidham.net) has joined #mythtv | |
| [18:58:48] | sphery (sphery!~mdean@mythtv/developer/sphery) has joined #mythtv | |
| [18:58:48] | ElmerFudd (ElmerFudd!~le@0x5737a682.cpe.ge-0-1-0-1101.hsnqu1.customer.tele.dk) has joined #mythtv | |
| [19:00:09] | gigem: | bill6502, stichnot: Any where the user has a time and needs to compare it to local time (e.g. starttime is in primetime or day of starttime is on some day) the time needs to be converted to local time. The way to do that is change "sometime" to "CONVERT_TZ(sometime, 'UTC', 'SYSTEM')". |
| [19:14:40] | laga (laga!~laga@h1626373.stratoserver.net) has quit (Ping timeout: 252 seconds) | |
| [19:14:46] | laga (laga!~laga@h1626373.stratoserver.net) has joined #mythtv | |
| [19:16:21] | natanojl (natanojl!~jonatan@c83-252-237-63.bredband.comhem.se) has joined #mythtv | |
| [19:32:04] | pvr4me (pvr4me!~craigtrel@d24-150-182-175.home.cgocable.net) has joined #mythtv | |
| [19:32:35] | IReboot (IReboot!~doug@CPE1caff7df6774-CM00252eac6f40.cpe.net.cable.rogers.com) has joined #mythtv | |
| [19:49:16] | bill6502: | gigem: stichnot: So, a generic statement with 2 examples: Timesstamps that use local time in existing custom recording rules must be manually changed to UTC. Examples: A rule with starttime='2012-09–12 10:00:00', should be changed to starttime=CONVERT_TZ('2012-09–12 10:00:00', 'UTC', 'SYSTEM'). A rule with: HOUR(program.endtime) < 22 becomes HOUR(CONVERT_TZ(program.endtime, 'UTC', 'SYSTEM')) < 22. |
| [19:49:53] | stichnot (stichnot!~stichnot@mythtv/developer/stichnot) has joined #mythtv | |
| [19:50:26] | stichnot: | gigem: Is Schedules Direct data always stored in the DB as local time? |
| [20:03:46] | stuartm: | stichnot: not now, it used to be though |
| [20:05:46] | Yanch0 (Yanch0!~mpulis@unaffiliated/yancho) has joined #mythtv | |
| [20:06:56] | stuartm: | stichnot: everything is now stored as GMT and we convert for display |
| [20:07:38] | stichnot: | stuartm: ok. I guess program.originalairdate is "special" because it's a date and not a date+time. |
| [20:08:18] | stichnot: | with respect to the comparison I found against program.starttime |
| [20:08:29] | stuartm: | I'm not so sure it's should be special |
| [20:08:48] | stuartm: | it should really be UTC like everything else IMHO |
| [20:09:07] | Yancho (Yancho!~mpulis@unaffiliated/yancho) has quit (Ping timeout: 240 seconds) | |
| [20:10:16] | stichnot: | iirc, SD provides just a date and mfdb adds "midnight", so I can't see any conversion making sense |
| [20:10:51] | stuartm: | mysql sadly has lousy timezone handling, it should be able to compare two different times from two different timezones correctly without explicitly converting :( |
| [20:11:44] | stuartm: | conversion makes sense from a comparison POV and also from a display one since we otherwise have to treat the airdate as a special case when formatting for display |
| [20:14:30] | stichnot: | My purpose for asking is to help think about how I would describe to a user what to look for in their custom recording rules and how to fix it manually |
| [20:14:46] | stuartm: | probably the best reason of all is that less mistakes/bugs are introduced in future if the format of dates is kept consistent throughout |
| [20:15:26] | stuartm: | stichnot: comparisons of start/end times to originalairdate would be a good one |
| [20:16:23] | stichnot: | yeah, that's the one that bit me :) |
| [20:17:05] | stichnot: | I was really surprised not to be seeing new shows/pilots coming up this close to the new TV season here... |
| [20:17:08] | stuartm: | i.e. if you're using that to ensure that you only record the first showing then it's possible for the conversion to UTC of the starttime pushes it into the next/previous day and it no longer matches |
| [20:18:43] | stuartm: | it continues to be a problem as long as we're mixing UTC datetimes and local datetimes in the DB :/ |
| [20:21:48] | clever: | ive run into similar problems when using a rule to record one episode per day |
| [20:22:14] | clever: | the show was airing in another timezone, 4 times per 'day', which put 3 airings in one of my days, and 1 airing in another day |
| [20:22:47] | clever: | in my case, its because another timezone (not local, not utc) was the reference for what day all 4 copies aired on |
| [20:22:53] | stuartm: | it's a more general problem with custom rules entirely, we'd be better off without that capability :( |
| [20:23:01] | stichnot: | in this particular case, maybe mfdb could set the time component of originalairdate to the time component of starttime if the two dates are the same |
| [20:23:21] | clever: | it could be solved by applying CONVERT_TZ to the start/end time, before checking the day, when enforcing 'once per day' |
| [20:23:34] | stuartm: | stichnot: that's not strictly necessary, it just needs to be stored in UTC |
| [20:23:47] | clever: | but each channel would need its own offset |
| [20:25:43] | stuartm: | you start pulling at a thread ... |
| [20:26:57] | clever: | i dont record that show anymore, but other people may have the same issue, i think it would apply to any daily show lacking program.subtitle and airing several times per 'day' (shifted past midnight due to timezones) |
| [20:27:03] | stuartm: | ultimately when a feature that was added to pacify a minority group of power users ends up demanding too much developer time at the cost of improvements to core functionality it's time to rethink |
| [20:35:38] | stichnot: | stuartm: clarification of my situation. SD provides originalairdate as say 2012-09–14 and starttime as say 2012-09–14T20:00:00. MFDB stores originalairdate as 2012-09–14T00:00:00 and starttime as something like 2012-09–15T02:00:00. When the date comparison happens, they are not equal. If originalairdate were stored as UTC, it would be 2012-09–14T06:00:00. In this case, the date... |
| [20:35:40] | stichnot: | ...comparison is still not equal. |
| [20:36:28] | zombor (zombor!~zombor_@kohana/developer/zombor) has quit (Remote host closed the connection) | |
| [20:38:32] | stichnot: | btw, I was a non-vocal fan of UTC conversion, just because I found it annoying to manually restart the backend twice a year at DST transitions. I wish I had realized how deep the changes would be. |
| [20:50:33] | dmfrey (dmfrey!~dmfrey@webdefence.cluster-h.websense.net) has quit (Quit: Ex-Chat) | |
| [20:57:24] | pvr4me (pvr4me!~craigtrel@d24-150-182-175.home.cgocable.net) has quit (Quit: pvr4me) | |
| [21:11:35] | NightMonkey (NightMonkey!~NightrMon@pdpc/supporter/professional/nightmonkey) has quit (Ping timeout: 244 seconds) | |
| [21:12:27] | pvr4me (pvr4me!~craigtrel@d24-150-182-175.home.cgocable.net) has joined #mythtv | |
| [21:17:36] | natanojl (natanojl!~jonatan@c83-252-237-63.bredband.comhem.se) has quit (Ping timeout: 252 seconds) | |
| [21:31:28] | stichnot_ (stichnot_!stichnot@nat/intel/x-lkbkjzlrlrnbxqbn) has joined #mythtv | |
| [21:34:06] | stichnot (stichnot!~stichnot@mythtv/developer/stichnot) has quit (Ping timeout: 252 seconds) | |
| [21:34:08] | stichnot_ is now known as stichnot | |
| [21:37:32] | NightMonkey (NightMonkey!~NightrMon@pdpc/supporter/professional/nightmonkey) has joined #mythtv | |
| [21:50:15] | stuartm: | thank you (to you know who you are) |
| [21:53:37] | stuartm: | light reading |
| [22:03:32] | stichnot_ (stichnot_!~stichnot@134.134.137.75) has joined #mythtv | |
| [22:04:54] | stichnot (stichnot!stichnot@nat/intel/x-lkbkjzlrlrnbxqbn) has quit (Ping timeout: 252 seconds) | |
| [22:04:57] | stichnot_ is now known as stichnot | |
| [22:15:58] | pvr4me (pvr4me!~craigtrel@d24-150-182-175.home.cgocable.net) has quit (Quit: pvr4me) | |
| [23:40:53] | stichnot (stichnot!~stichnot@134.134.137.75) has quit (Ping timeout: 246 seconds) | |
IRC Logs collected by
BeirdoBot.
Please use the above link to report any bugs.