| Wednesday, February 20th, 2013, 00:00 UTC | ||
| [00:00:08] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has joined #mythtv-users | |
| [00:04:43] | Muzer (Muzer!~muzer@81.101.100.91) has quit (Ping timeout: 245 seconds) | |
| [00:05:12] | Muzer (Muzer!~muzer@cpc3-ando6-2-0-cust90.15-1.cable.virginmedia.com) has joined #mythtv-users | |
| [00:10:53] | jamesd2 (jamesd2!~jamesd@c-67-184-92-56.hsd1.il.comcast.net) has joined #mythtv-users | |
| [00:17:58] | roe_ (roe_!~roe@unaffiliated/roe) has joined #mythtv-users | |
| [00:18:48] | roe_: | Is there a secret to getting mythtv-backend setup as a UPnP server? I haven't configured any frontends yet but would like to access some of the recordings |
| [00:19:08] | roe_: | I was hoping it would just show up in the PS3 menu |
| [00:19:31] | petres (petres!~petre@scheie.homedns.org) has joined #mythtv-users | |
| [00:20:57] | deathadder (deathadder!deathadder@ganjaman.gotadsl.co.uk) has quit (Read error: Connection reset by peer) | |
| [00:21:10] | deathadder (deathadder!deathadder@ganjaman.gotadsl.co.uk) has joined #mythtv-users | |
| [00:22:00] | bentech (bentech!~bentech@host86-129-27-6.range86-129.btcentralplus.com) has quit (Ping timeout: 260 seconds) | |
| [00:22:18] | dkeith___ (dkeith___!~dkeith@65.210.104.2) has joined #mythtv-users | |
| [00:31:32] | BLZbubba (BLZbubba!~mark@pdpc/supporter/professional/blzbubba) has quit (Ping timeout: 252 seconds) | |
| [00:34:43] | petres: | I've been running mythbuntu 12.04 (mythtv 0.25) since last summer/fall. |
| [00:35:06] | petres: | About a month ago, it started to not record things that had been scheduled. |
| [00:35:30] | roe_: | what do the logs say? |
| [00:35:34] | petres: | I can't see anything obvious in the logs, but I don't really know what to look for, either. |
| [00:35:52] | petres: | Which log file should I start with? |
| [00:35:59] | roe_: | backend |
| [00:40:12] | petres: | ok, I see something. http://pastebin.com/iL8dTpWj |
| [00:40:51] | petres: | When the backend starts up (I rebooted the box on Feb. 14), it's failing when trying to talk to the capture card. |
| [00:41:20] | petres: | Not sure what would cause that, as nothing has changed recently. |
| [00:45:12] | petres: | It's also strange that it references 3 cards, as the card has only two tuners on it (Hauppauge, I forget the model). |
| [00:45:16] | petres: | http://pastebin.com/Wv80Duqv |
| [01:02:20] | zombor (zombor!~zombor__@65.29.231.135) has joined #mythtv-users | |
| [01:02:24] | zombor (zombor!~zombor__@65.29.231.135) has quit (Changing host) | |
| [01:02:24] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [01:07:16] | zombor (zombor!~zombor__@kohana/developer/zombor) has quit (Ping timeout: 248 seconds) | |
| [01:14:09] | quinten (quinten!~quinten@c-66-31-200-61.hsd1.ma.comcast.net) has quit (Ping timeout: 248 seconds) | |
| [01:15:20] | jpabq: | petres: My guess is that you actually have two instances of mythbackend running. Do a "ps aux | grep mythbackend". If there is more than one running, I would kill them both, and start up a fresh instance. |
| [01:15:47] | jpabq is now known as jpabq_afk | |
| [01:16:23] | petres: | jpabq_, ah, that could be. |
| [01:17:03] | petres: | Just to be thorough, I shut the machine down and pulled the card out, looked at it, then put it back in and rebooted the box. |
| [01:17:26] | petres: | This was in case on the outside chance the card had wiggled out of alignment in the slot. |
| [01:17:53] | petres: | Unlikely, I know, but there were no errors in the backend log when it came up (so far). |
| [01:18:28] | petres: | I've queued a recording to kickoff in 12 minutes; we'll see if it takes this time. |
| [01:22:31] | roe_ (roe_!~roe@unaffiliated/roe) has quit (Remote host closed the connection) | |
| [01:22:54] | skeeveman (skeeveman!~skeeve@64.254.35.23) has joined #mythtv-users | |
| [01:23:43] | Heliwr (Heliwr!~Heliwr@pdpc/supporter/student/heliwr) has quit (Read error: Operation timed out) | |
| [01:28:24] | Ryushin (Ryushin!proxy@cl-412.phx-01.us.sixxs.net) has quit (Ping timeout: 276 seconds) | |
| [01:29:00] | Heliwr (Heliwr!~Heliwr@pdpc/supporter/student/heliwr) has joined #mythtv-users | |
| [01:30:27] | DarthFrog (DarthFrog!~rob@S01060014bfba779e.vn.shawcable.net) has left #mythtv-users ("Konversation terminated!") | |
| [01:34:23] | Heliwr (Heliwr!~Heliwr@pdpc/supporter/student/heliwr) has quit (Ping timeout: 255 seconds) | |
| [01:34:45] | croppa (croppa!~stuart@CPE-120-146-137-99.static.nsw.bigpond.net.au) has joined #mythtv-users | |
| [01:38:32] | Heliwr (Heliwr!~Heliwr@2605:6400:2:fed5:22:0:7ad4:817e) has joined #mythtv-users | |
| [01:38:33] | Heliwr (Heliwr!~Heliwr@pdpc/supporter/student/heliwr) has joined #mythtv-users | |
| [01:38:34] | Heliwr (Heliwr!~Heliwr@2605:6400:2:fed5:22:0:7ad4:817e) has quit (Changing host) | |
| [01:39:44] | Korny: | Playing with my killawatt meter, my a6 3500 amd doesn't do to horribly playing movies/tv 45 watts while decoding anything, thats using a gt520 for a video card however |
| [01:40:48] | sheppard: | I'm afraid to put one on my server |
| [01:41:08] | sheppard: | one of the ups' which has one of the PSUs attached claims it draws a steady 600w |
| [01:41:45] | jamesd2: | my esxi server uses 150watts of power, but it replaced 3 other servers and has a lot of resources and power to scale, and my hp n40l uses about 50 watts as a fileserver |
| [01:42:14] | sheppard: | you obviously don't have enough drives in there |
| [01:42:16] | jamesd2: | esxi box is a quad core e5606 ml350 g6 and 50gB of ram |
| [01:42:16] | Korny: | I'm afraid to put it on my 6 core amd lol |
| [01:42:37] | sheppard: | mines a dual e5–2620 w/ 64gb |
| [01:42:37] | Korny: | with 10 HD's in it |
| [01:42:43] | sheppard: | 36 =\ |
| [01:43:37] | Korny: | I'm not happy with my tv |
| [01:43:41] | Korny: | 250 watts :/ |
| [01:43:49] | Korny: | 55" LCD but not LED |
| [01:43:58] | jamesd2: | i gave up recording stuff on mythtv... i use a lot less power and disk space |
| [01:44:21] | sheppard: | Korny: turn down the brightness |
| [01:45:28] | Korny: | I did the math, for every machine tahts on 24/7 I pay 1 dollar per 10 watts it uses per month |
| [01:45:29] | Korny: | about |
| [01:46:06] | Korny: | So the little i3 35 watt max tdp should be a good replacement for my 1055t which sits idle 90% of the time |
| [01:46:45] | sheppard: | wahoo |
| [01:46:50] | sheppard: | how long to pay off the hw investment? |
| [01:47:25] | Korny: | sheppard, I'm also turning it into a frontend for my living room so the 35watt chip was ideal for a passive heatsink if I need it |
| [01:47:52] | Korny: | and I haven't hooked up the 1055 yet, but tests online say it idles about 90 watts with mobo |
| [01:48:59] | Korny: | I'm also switching to a unraid setup instead of having a big giant server, I'm going to have myth be a front/backend in the living room and use old hardware to build my unraid setup |
| [01:49:06] | jamesd2: | i figure my hp ml350 g6 e5606 base has been paid for it self... vs the 3x servers it replaced, beige box dual core amd box, sun blade 1500, and a sun blade 1000... the memory and disks 48GB of dimms and about $200 in used sas drives are left to pay for but should be done in about 6 months. base took about a year. |
| [02:04:20] | Muzer (Muzer!~muzer@cpc3-ando6-2-0-cust90.15-1.cable.virginmedia.com) has quit (Ping timeout: 248 seconds) | |
| [02:10:42] | Muzer (Muzer!~muzer@cpc3-ando6-2-0-cust90.15-1.cable.virginmedia.com) has joined #mythtv-users | |
| [02:12:04] | joki (joki!~joki@p548640A2.dip.t-dialin.net) has quit (Ping timeout: 252 seconds) | |
| [02:12:25] | joki- (joki-!~joki@p54863DD5.dip.t-dialin.net) has joined #mythtv-users | |
| [02:12:32] | joki- is now known as joki | |
| [02:24:28] | petres (petres!~petre@scheie.homedns.org) has quit (Quit: Leaving) | |
| [03:04:41] | deathadder (deathadder!deathadder@ganjaman.gotadsl.co.uk) has quit (Ping timeout: 257 seconds) | |
| [03:09:41] | disputin (disputin!~sean@65.102.58.17) has quit (Quit: Leaving.) | |
| [03:19:28] | NightMonkey (NightMonkey!~NightrMon@pdpc/supporter/professional/nightmonkey) has quit (Quit: Body blow! Body blow!) | |
| [03:45:53] | J-e-f-f-A (J-e-f-f-A!~J-e-f-f-A@pool-173-48-113-147.bstnma.fios.verizon.net) has quit (Quit: Oh No!!!! ;-)) | |
| [03:48:17] | J-e-f-f-A (J-e-f-f-A!~J-e-f-f-A@pool-173-48-113-147.bstnma.fios.verizon.net) has joined #mythtv-users | |
| [03:57:41] | blassey_ (blassey_!~blassey@c-174-63-105-63.hsd1.ma.comcast.net) has quit (Remote host closed the connection) | |
| [04:01:56] | Skeeve_work (Skeeve_work!~skeeve@wsip-98-175-49-254.ks.ks.cox.net) has quit (Ping timeout: 257 seconds) | |
| [04:03:53] | zombor (zombor!~zombor__@65.29.231.135) has joined #mythtv-users | |
| [04:03:53] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [04:03:53] | zombor (zombor!~zombor__@65.29.231.135) has quit (Changing host) | |
| [04:05:13] | Skeeve_work (Skeeve_work!~skeeve@wsip-98-175-49-254.ks.ks.cox.net) has joined #mythtv-users | |
| [04:06:26] | wagnerrp: | why does my CBS affiliate have to tell everyone they may end up not carried by directv? |
| [04:06:39] | wagnerrp: | surely that's something they should only need to send to the directv feed |
| [04:09:45] | NightMonkey (NightMonkey!~NightrMon@pdpc/supporter/professional/nightmonkey) has joined #mythtv-users | |
| [04:26:59] | monkeypet69 (monkeypet69!~quassel@c-24-6-135-62.hsd1.ca.comcast.net) has quit (Remote host closed the connection) | |
| [04:32:29] | aloril (aloril!~aloril@dsl-tkubrasgw3-54f97e-153.dhcp.inet.fi) has quit (Ping timeout: 276 seconds) | |
| [04:35:17] | tgm4883: | wagnerrp, that sounds like a commercial |
| [04:35:31] | tgm4883: | surely mythcommflag should get rid of that for youi |
| [04:43:13] | wagnerrp: | no, it's a ticker in the bottom of the show |
| [04:43:56] | tgm4883: | well that sounds completely unnecessary then |
| [04:44:12] | aloril (aloril!~aloril@dsl-tkubrasgw3-54f97e-153.dhcp.inet.fi) has joined #mythtv-users | |
| [04:45:28] | ertyu-m: | wagnerrp, I was thinking the same thing yesterday when I lost half my screen telling me about a snowstorm that was happening in another country, days earlier |
| [04:45:59] | ertyu-m: | why must they pollute all the feeds with garbage |
| [04:48:55] | wagnerrp: | especially when there's no reason such things can't be sent out-of-band, so they can be ignored by DVRs |
| [04:49:11] | ertyu-m: | is there a protocol for it? |
| [04:49:14] | jamesd2 (jamesd2!~jamesd@c-67-184-92-56.hsd1.il.comcast.net) has quit (Ping timeout: 256 seconds) | |
| [04:49:32] | ertyu-m: | non-emergency urgent information you may want to ignore |
| [04:49:43] | wagnerrp: | DVB has their MHEG, ATSC has something simple but similar |
| [04:50:09] | wagnerrp: | and you can always force a redirect to a different channel if you need to "cut in" with emergency news |
| [04:50:24] | ertyu-m: | is MHEG some horribly complicated thing that tried to solve everything and never got anywhere? |
| [04:50:51] | wagnerrp: | MHEG is an advanced replacement for old teletype transmissions |
| [04:51:07] | wagnerrp: | they're basically little programs that run in a virtual machine |
| [04:51:36] | wagnerrp: | although it's usually just used for things like "click the red button to mark this series for recording" |
| [04:51:58] | ertyu-m: | not sure if I'm thinking about the right thing, based on your description it certainly could be used for anything, but probably whittled down to a tiny subset |
| [04:52:18] | wagnerrp: | it's primarily a UK thing |
| [04:52:28] | wagnerrp: | you would be more likely to find someone who has used it tomorrow morning |
| [04:52:32] | ertyu-m: | have you seen anything about RVU? |
| [04:53:02] | ertyu-m: | similar idea it seems, pushing a little app over dlna |
| [04:53:07] | wagnerrp: | that's some remote interface thing with DLNA, right? |
| [04:53:19] | ertyu-m: | remote view basically |
| [04:53:45] | ertyu-m: | directv is using it for satellite front ends for a pvr |
| [04:54:06] | wagnerrp: | as i understand it, current implementations are awful and slow |
| [04:54:09] | ertyu-m: | satellite in that context meaning a remote front end running purely on the tv and needing no additional hardware |
| [04:54:39] | ertyu-m: | sounds very likely, the first attempts often are |
| [04:54:48] | wagnerrp: | really? got any docs on that? |
| [04:54:54] | wagnerrp: | like what receivers have it enabled? |
| [04:55:18] | ertyu-m: | https://en.wikipedia.org/wiki/RVU_protocol |
| [04:55:25] | wagnerrp: | no, i mean directv receivers |
| [04:55:32] | ertyu-m: | http://hdguru.com/what-is-rvu-youll-want-to-know/9963/ |
| [04:55:48] | ertyu-m: | HR34, HR44 |
| [04:56:14] | wagnerrp: | oh, so it's not a typical DLNA thing, even though the spec is several years old |
| [04:56:14] | ertyu-m: | oh jeez, they charge extra for a remote client, bastards |
| [04:57:07] | wagnerrp: | maybe i'll plug the ethernet into my genie and see what happens |
| [04:58:39] | ertyu-m: | someday stuff will magically work when we plug it in, without a whole lot of fiddling, although the digital days seem to have taken us backwards as much as forwards |
| [04:59:33] | wagnerrp: | can you believe they charge a monthly rental for their "home cinema" kit, which is nothing more than a wireless ethernet adapter to allow you to communicate upstream to control VOD? |
| [05:01:21] | fetzerch (fetzerch!~quassel@unaffiliated/fetzerch) has quit (Ping timeout: 248 seconds) | |
| [05:02:42] | fetzerch (fetzerch!~quassel@unaffiliated/fetzerch) has joined #mythtv-users | |
| [05:03:01] | wagnerrp: | now that i think about it, i would hate to see what that thing looks like getting pumped over wireless |
| [05:04:23] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [05:08:08] | blassey (blassey!~blassey@c-174-63-105-63.hsd1.ma.comcast.net) has joined #mythtv-users | |
| [05:08:52] | zombor (zombor!~zombor__@kohana/developer/zombor) has quit (Ping timeout: 248 seconds) | |
| [05:12:36] | blassey (blassey!~blassey@c-174-63-105-63.hsd1.ma.comcast.net) has quit (Ping timeout: 248 seconds) | |
| [05:13:59] | NightMonkey (NightMonkey!~NightrMon@pdpc/supporter/professional/nightmonkey) has quit (Quit: Body blow! Body blow!) | |
| [05:22:18] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has quit (Ping timeout: 264 seconds) | |
| [05:46:23] | kusznir (kusznir!~kusznir@76.178.145.28) has quit (Ping timeout: 255 seconds) | |
| [05:55:39] | [R] ([R]!~rbox@unaffiliated/rbox) has joined #mythtv-users | |
| [06:00:10] | Sharky112065 is now known as Sharky-Sleep | |
| [06:04:55] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [06:09:40] | zombor (zombor!~zombor__@kohana/developer/zombor) has quit (Ping timeout: 248 seconds) | |
| [06:19:18] | Cougar (Cougar!~cougar@2a03:5880:104:10:34a5:35e:2a25:b96d) has quit (Ping timeout: 264 seconds) | |
| [06:30:22] | Cougar (Cougar!~cougar@2a03:5880:104:10:29d0:84:a6c6:a9a2) has joined #mythtv-users | |
| [06:43:33] | RedR (RedR!~redrvm@adsl-68-94-197-105.dsl.rcsntx.swbell.net) has joined #mythtv-users | |
| [06:45:12] | SteveGoodey (SteveGoodey!~steve@host86-147-183-135.range86-147.btcentralplus.com) has joined #mythtv-users | |
| [07:01:37] | Skeeve_work (Skeeve_work!~skeeve@wsip-98-175-49-254.ks.ks.cox.net) has quit (Ping timeout: 256 seconds) | |
| [07:04:32] | Skeeve_work (Skeeve_work!~skeeve@wsip-98-175-49-254.ks.ks.cox.net) has joined #mythtv-users | |
| [07:05:27] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [07:09:55] | zombor (zombor!~zombor__@kohana/developer/zombor) has quit (Ping timeout: 248 seconds) | |
| [07:13:24] | [R] ([R]!~rbox@unaffiliated/rbox) has quit (Quit: Leaving) | |
| [07:15:51] | linuxtech (linuxtech!~linuxtech@linuxtech-1-pt.tunnel.tserv13.ash1.ipv6.he.net) has quit (Read error: Connection reset by peer) | |
| [07:17:38] | ubIx (ubIx!~ulf@p5DD180C2.dip0.t-ipconnect.de) has quit (Read error: Operation timed out) | |
| [07:19:13] | SteveGoodey (SteveGoodey!~steve@host86-147-183-135.range86-147.btcentralplus.com) has quit (Quit: Konversation terminated!) | |
| [07:20:27] | linuxtech (linuxtech!~linuxtech@linuxtech-1-pt.tunnel.tserv13.ash1.ipv6.he.net) has joined #mythtv-users | |
| [07:21:29] | ubIx (ubIx!~ulf@p5DD180D7.dip0.t-ipconnect.de) has joined #mythtv-users | |
| [07:34:50] | faichele (faichele!~quassel@p57952A73.dip.t-dialin.net) has joined #mythtv-users | |
| [07:44:44] | croppa (croppa!~stuart@CPE-120-146-137-99.static.nsw.bigpond.net.au) has quit () | |
| [07:47:40] | croppa (croppa!~stuart@CPE-120-146-137-99.static.nsw.bigpond.net.au) has joined #mythtv-users | |
| [07:55:43] | RedR (RedR!~redrvm@adsl-68-94-197-105.dsl.rcsntx.swbell.net) has quit (Quit: Leaving) | |
| [07:57:58] | hpeter (hpeter!~hpeter@213-33-16-156.adsl.highway.telekom.at) has joined #mythtv-users | |
| [08:03:53] | hpeter (hpeter!~hpeter@213-33-16-156.adsl.highway.telekom.at) has quit (Read error: Connection reset by peer) | |
| [08:04:51] | hpeter (hpeter!~hpeter@213-33-16-156.adsl.highway.telekom.at) has joined #mythtv-users | |
| [08:05:49] | hpeter_ (hpeter_!~hpeter@213-33-16-156.adsl.highway.telekom.at) has joined #mythtv-users | |
| [08:05:58] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [08:08:18] | hpeter (hpeter!~hpeter@213-33-16-156.adsl.highway.telekom.at) has quit (Read error: Operation timed out) | |
| [08:08:18] | hpeter_ is now known as hpeter | |
| [08:10:41] | zombor (zombor!~zombor__@kohana/developer/zombor) has quit (Ping timeout: 248 seconds) | |
| [08:28:39] | faichele (faichele!~quassel@p57952A73.dip.t-dialin.net) has quit (Remote host closed the connection) | |
| [16:15:32] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v MythLogBot | |
| [16:16:24] | ** Korny is confused ** | |
| [16:16:42] | Korny: | So whatelse is new |
| [16:18:32] | tgm4883: | disputin, what is the problem |
| [16:19:59] | disputin: | locked tables in mysql under mysql 5.5.29 |
| [16:20:15] | tgm4883: | disputin, how is that a packaging problem? |
| [16:20:18] | disputin: | this then stops dead mythtv-backend |
| [16:20:30] | disputin: | nothing, that's not my problem right now |
| [16:20:36] | disputin: | it was a side comment |
| [16:20:37] | tgm4883: | <disputin> ok, so somebody needs to tell the mythbuntu packagers that, because they seem to have a blind spot to that little item |
| [16:20:45] | tgm4883: | <---- Mythbuntu packager |
| [16:21:26] | Korny: | Thank you tgm4883 I never knew that, you make my life easy |
| [16:21:30] | disputin: | sorry my mistake, I just did some looking and it looks better |
| [16:21:40] | disputin: | I retract that statement |
| [16:21:49] | tgm4883: | Thank you :) |
| [16:21:52] | kusznir (kusznir!~kusznir@76.178.145.28) has joined #mythtv-users | |
| [16:22:04] | disputin: | anyway someone want to chat about mysql table locking?> |
| [16:22:14] | tgm4883: | Korny, yw. I'll admit, I'm only one of the Mythbuntu devs and not the primary guy that takes care of packaging |
| [16:22:21] | zombor (zombor!~zombor__@50-73-122-41-ip-static.hfc.comcastbusiness.net) has joined #mythtv-users | |
| [16:22:24] | zombor (zombor!~zombor__@50-73-122-41-ip-static.hfc.comcastbusiness.net) has quit (Changing host) | |
| [16:22:24] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [16:22:30] | Korny: | Either way |
| [16:23:07] | Korny: | seting up a bedroom box with unattended upgrades and reboots twice a week, means no outside input from me for months on end |
| [16:24:19] | BLZbubba (BLZbubba!~mark@tpsit.com) has joined #mythtv-users | |
| [16:25:21] | disputin: | I agree, mythbuntu has made things very nice |
| [16:25:36] | disputin: | now mysql has been kicking my ass since early november |
| [16:25:48] | zombor (zombor!~zombor__@kohana/developer/zombor) has quit (Remote host closed the connection) | |
| [16:25:53] | disputin: | I only just realized it was mysql and not mythtv-backend |
| [16:26:04] | disputin: | Waiting for table metadata lock — LOCK TABLES recorded WRITE |
| [16:26:29] | Korny: | what symptoms? Because I haven't noticed anything with my backend, my my mysql has been super busy lately |
| [16:27:03] | Korny: | disputin, have you optimized the tables lately? I'm a mysql noob, but yah never know :) |
| [16:27:44] | disputin: | mythtv-backend will stop all activity, |
| [16:27:51] | disputin: | the backend log will show |
| [16:28:03] | disputin: | ProcessRequest mainserver.cpp:1360 (HandleAnnounce) MainServer::ANN Monitor |
| [16:28:03] | disputin: | ProcessRequest mainserver.cpp:1362 (HandleAnnounce) adding: hubble as a client (events: 2) |
| [16:28:07] | disputin: | over and over again |
| [16:28:28] | disputin: | you can only stop it with kill −9 and you couldn't start it again without a reboot. |
| [16:28:41] | disputin: | a few days ago I noticed the locked process list in mysql |
| [16:29:15] | disputin: | if I go about killing the oldest mysql processes, the log shows a mysql error. |
| [16:29:33] | disputin: | eventually I can kill enough processes and flush enough tables to start it again. |
| [16:30:01] | disputin: | but in the mean time, nothing records, and I'm sure I'm causing table corruption |
| [16:31:37] | disputin: | googling 'Waiting for table metadata lock' brings up MySQL bug references and discussions about autocommit=0 but nothing substantial to fix the problem |
| [16:32:24] | disputin: | I have been debating pinning in a pre mysql 5.5 version (say 5.1) and see if the problem goes away... |
| [16:32:52] | wagnerrp: | shouldn't make a difference |
| [16:33:03] | wagnerrp: | all mythbuntu users have been running 5.5 for probably a year nor |
| [16:33:05] | wagnerrp: | *now |
| [16:33:19] | disputin: | yeah that's why I'm a bit confused. |
| [16:34:25] | disputin: | no errors in mysql error log |
| [16:39:39] | zombor (zombor!~zombor__@50-73-122-41-ip-static.hfc.comcastbusiness.net) has joined #mythtv-users | |
| [16:39:40] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [16:39:40] | zombor (zombor!~zombor__@50-73-122-41-ip-static.hfc.comcastbusiness.net) has quit (Changing host) | |
| [16:39:43] | disputin: | this is the other sql process that seems to show up with the same time as the locked statement |
| [16:39:51] | disputin: | SELECT r.title, r.subtitle, r.description, r.season, r.episode, |
| [16:40:14] | disputin: | I don't know the entire query, that's all show processlist gives |
| [16:40:56] | disputin: | the reason I'm thinking of rolling back a mysql version is because the 'Waiting for table metadata lock' seems related to mysql 5.5 |
| [16:41:14] | disputin: | I think the change occurred around 5.5.3 |
| [16:44:10] | disputin: | ok, just me then |
| [16:44:16] | zombor (zombor!~zombor__@50-73-122-41-ip-static.hfc.comcastbusiness.net) has joined #mythtv-users | |
| [16:44:16] | zombor (zombor!~zombor__@50-73-122-41-ip-static.hfc.comcastbusiness.net) has quit (Changing host) | |
| [16:44:16] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [16:44:20] | disputin: | *sigh* |
| [16:44:49] | Wolfgang2 (Wolfgang2!~Thunderbi@178-27-144-160-dynip.superkabel.de) has joined #mythtv-users | |
| [16:46:10] | zombor (zombor!~zombor__@kohana/developer/zombor) has quit (Remote host closed the connection) | |
| [16:46:41] | Easy_Rider9999 (Easy_Rider9999!~Miranda@p548968D3.dip.t-dialin.net) has quit (Read error: Connection reset by peer) | |
| [16:50:56] | dkeith (dkeith!dkeith@cet-nat.comcastcntr.pa.bo.comcast.net) has joined #mythtv-users | |
| [16:56:34] | zombor (zombor!~zombor__@50-73-122-41-ip-static.hfc.comcastbusiness.net) has joined #mythtv-users | |
| [16:56:35] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [16:56:35] | zombor (zombor!~zombor__@50-73-122-41-ip-static.hfc.comcastbusiness.net) has quit (Changing host) | |
| [16:57:51] | Steve-Goodey (Steve-Goodey!~steve@host86-147-183-135.range86-147.btcentralplus.com) has joined #mythtv-users | |
| [17:01:20] | Skeeve_work (Skeeve_work!~skeeve@wsip-98-175-49-254.ks.ks.cox.net) has quit (Ping timeout: 256 seconds) | |
| [17:04:05] | faichele_ (faichele_!~quassel@d16-149.informatik.uni-stuttgart.de) has quit (Ping timeout: 240 seconds) | |
| [17:06:22] | Steve-Goodey (Steve-Goodey!~steve@host86-147-183-135.range86-147.btcentralplus.com) has quit (Quit: Konversation terminated!) | |
| [17:06:29] | Steve-Goodey (Steve-Goodey!~steve@host86-147-183-135.range86-147.btcentralplus.com) has joined #mythtv-users | |
| [17:07:48] | Skeeve_work (Skeeve_work!~skeeve@wsip-98-175-49-254.ks.ks.cox.net) has joined #mythtv-users | |
| [17:12:37] | XDS2010 (XDS2010!uid1218@gateway/web/irccloud.com/x-vqsspfnsmhpbwnif) has joined #mythtv-users | |
| [17:13:13] | stuarta (stuarta!~stuarta@mythtv/developer/stuarta) has left #mythtv-users () | |
| [17:15:18] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [17:16:12] | zombor (zombor!~zombor__@kohana/developer/zombor) has quit (Remote host closed the connection) | |
| [17:19:28] | Goga777 (Goga777!~Goga777@128-71-138-210.broadband.corbina.ru) has quit (Ping timeout: 256 seconds) | |
| [17:26:08] | Wolfgang2 (Wolfgang2!~Thunderbi@178-27-144-160-dynip.superkabel.de) has quit (Quit: Wolfgang2) | |
| [17:33:53] | hpeter (hpeter!~hpeter@193.170.147.50) has joined #mythtv-users | |
| [17:39:50] | dekarl: | disputin: are your indices ok? sounds like performing a full table lock due to missing indices or something along these lines |
| [17:40:36] | bentech (bentech!~bentech@host86-129-27-6.range86-129.btcentralplus.com) has quit (Quit: bentech) | |
| [17:41:05] | natanojl (natanojl!~jonatan@c83-252-237-63.bredband.comhem.se) has joined #mythtv-users | |
| [17:41:33] | disputin: | hmm so I've run the optimize script before and it checks out ok |
| [17:43:31] | maethorechannen (maethorechannen!~scot@80.229.12.97) has quit (Remote host closed the connection) | |
| [17:45:38] | NightMonkey (NightMonkey!~NightrMon@pdpc/supporter/professional/nightmonkey) has joined #mythtv-users | |
| [17:46:04] | NightMonkey (NightMonkey!~NightrMon@pdpc/supporter/professional/nightmonkey) has quit (Read error: Connection reset by peer) | |
| [17:52:21] | faichele_ (faichele_!~quassel@p57952A73.dip.t-dialin.net) has joined #mythtv-users | |
| [18:11:03] | dekarl (dekarl!~dekarl@p4FE85FC9.dip.t-dialin.net) has quit (Ping timeout: 257 seconds) | |
| [18:11:17] | drindt (drindt!~drindt@brln-4dba34ef.pool.mediaWays.net) has quit (Quit: Ex-Chat) | |
| [18:14:06] | Sharky-Sleep is now known as Sharky112065 | |
| [18:16:06] | dekarl (dekarl!~dekarl@p4FCEF157.dip.t-dialin.net) has joined #mythtv-users | |
| [18:27:41] | NightMonkey (NightMonkey!~NightrMon@pdpc/supporter/professional/nightmonkey) has joined #mythtv-users | |
| [18:46:32] | andreaz (andreaz!~andre_000@p5B298CAE.dip.t-dialin.net) has joined #mythtv-users | |
| [19:03:19] | zombor (zombor!~zombor__@50-73-122-41-ip-static.hfc.comcastbusiness.net) has joined #mythtv-users | |
| [19:03:19] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [19:03:19] | zombor (zombor!~zombor__@50-73-122-41-ip-static.hfc.comcastbusiness.net) has quit (Changing host) | |
| [19:05:36] | SteveGoodey (SteveGoodey!~steve@host86-147-183-135.range86-147.btcentralplus.com) has joined #mythtv-users | |
| [19:16:52] | wahrhaft (wahrhaft!~quassel@cpe-24-210-69-143.columbus.res.rr.com) has joined #mythtv-users | |
| [19:19:37] | z3mark (z3mark!~z3mark@ns1.exchangesolutions.net) has joined #mythtv-users | |
| [19:29:31] | hpeter (hpeter!~hpeter@193.170.147.50) has quit (Quit: hpeter) | |
| [19:31:16] | hpeter (hpeter!~hpeter@193.170.147.50) has joined #mythtv-users | |
| [19:44:41] | hpeter (hpeter!~hpeter@193.170.147.50) has quit (Quit: hpeter) | |
| [19:56:16] | dkeith____ (dkeith____!~dkeith@69.241.19.12) has joined #mythtv-users | |
| [19:59:04] | dkeith (dkeith!dkeith@cet-nat.comcastcntr.pa.bo.comcast.net) has quit (Ping timeout: 252 seconds) | |
| [20:04:12] | farmerjohn (farmerjohn!~lazyleste@cpc21-live22-2-0-cust99.know.cable.virginmedia.com) has joined #mythtv-users | |
| [20:04:58] | dkeith_____ (dkeith_____!~dkeith@69.241.19.12) has joined #mythtv-users | |
| [20:04:58] | dkeith_____ is now known as dkeith | |
| [20:07:30] | dkeith____ (dkeith____!~dkeith@69.241.19.12) has quit (Ping timeout: 272 seconds) | |
| [20:13:34] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has joined #mythtv-users | |
| [20:22:59] | bas-t (bas-t!~tycho@52484E89.cm-4-1b.dynamic.ziggo.nl) has quit (Quit: Leaving) | |
| [20:32:07] | dijonyummy (dijonyummy!~dijonyumm@208.66.30.195) has joined #mythtv-users | |
| [20:32:41] | dijonyummy (dijonyummy!~dijonyumm@208.66.30.195) has quit (Max SendQ exceeded) | |
| [20:32:43] | StevenR (StevenR!~foo@cpc14-sgyl28-2-0-cust18.18-2.cable.virginmedia.com) has quit (Remote host closed the connection) | |
| [20:35:09] | StevenR (StevenR!~foo@cpc14-sgyl28-2-0-cust18.18-2.cable.virginmedia.com) has joined #mythtv-users | |
| [20:37:39] | Tobbe5178 (Tobbe5178!~asdf@h186n5-sv-a13.ias.bredband.telia.com) has joined #mythtv-users | |
| [20:38:21] | ghoti (ghoti!~paul@205.233.216.25) has quit (Ping timeout: 245 seconds) | |
| [20:45:29] | ghoti (ghoti!~paul@205.233.216.25) has joined #mythtv-users | |
| [20:50:14] | dkeith_ (dkeith_!~dkeith@69.241.19.12) has joined #mythtv-users | |
| [20:54:00] | dkeith (dkeith!~dkeith@69.241.19.12) has quit (Ping timeout: 260 seconds) | |
| [20:56:16] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has quit (Ping timeout: 244 seconds) | |
| [20:57:28] | pmhahn (pmhahn!~pmhahn@2001:4dd0:ff00:8d31:219:dbff:fef2:e135) has joined #mythtv-users | |
| [21:00:53] | rsiebert (rsiebert!~quassel@g224250215.adsl.alicedsl.de) has joined #mythtv-users | |
| [21:04:12] | quinten (quinten!~quinten@c-66-31-200-61.hsd1.ma.comcast.net) has joined #mythtv-users | |
| [21:04:22] | z3mark (z3mark!~z3mark@ns1.exchangesolutions.net) has left #mythtv-users () | |
| [21:04:33] | rsiebert_ (rsiebert_!~quassel@g225055240.adsl.alicedsl.de) has quit (Ping timeout: 276 seconds) | |
| [21:06:18] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has joined #mythtv-users | |
| [21:11:18] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has quit (Ping timeout: 252 seconds) | |
| [21:15:50] | dkeith__ (dkeith__!~dkeith@69.241.19.12) has joined #mythtv-users | |
| [21:16:01] | zombor (zombor!~zombor__@50-73-122-41-ip-static.hfc.comcastbusiness.net) has joined #mythtv-users | |
| [21:16:01] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [21:16:01] | zombor (zombor!~zombor__@50-73-122-41-ip-static.hfc.comcastbusiness.net) has quit (Changing host) | |
| [21:16:17] | dkeith__ is now known as dkeith | |
| [21:19:04] | dkeith_ (dkeith_!~dkeith@69.241.19.12) has quit (Ping timeout: 272 seconds) | |
| [21:20:55] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has joined #mythtv-users | |
| [21:25:03] | disputin (disputin!~sean@2001:470:9758:1:250a:d270:1d64:2b81) has quit (Ping timeout: 276 seconds) | |
| [21:25:24] | paSserBy (paSserBy!~paSserBy@87-194-80-101.bethere.co.uk) has joined #mythtv-users | |
| [21:25:27] | baggy (baggy!~baggy@baggywrinkle.demon.co.uk) has joined #mythtv-users | |
| [21:26:01] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has quit (Ping timeout: 256 seconds) | |
| [21:35:27] | Ryushin (Ryushin!proxy@cl-412.phx-01.us.sixxs.net) has quit (Ping timeout: 276 seconds) | |
| [21:41:20] | Jordack (Jordack!~jordack@h69-131-44-221.plmomi.dedicated.static.tds.net) has quit () | |
| [21:43:38] | paSserBy (paSserBy!~paSserBy@87-194-80-101.bethere.co.uk) has quit (Quit: paSserBy) | |
| [21:50:45] | SteveGoodey (SteveGoodey!~steve@host86-147-183-135.range86-147.btcentralplus.com) has quit (Quit: Konversation terminated!) | |
| [21:55:09] | Steve-Goodey (Steve-Goodey!~steve@host86-147-183-135.range86-147.btcentralplus.com) has quit (Quit: Konversation terminated!) | |
| [22:08:25] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has joined #mythtv-users | |
| [22:12:37] | disputin (disputin!~sean@2001:470:9758:1:6deb:5723:8339:8b57) has joined #mythtv-users | |
| [22:13:44] | DarthFrog (DarthFrog!~rob@S01060014bfba779e.vn.shawcable.net) has joined #mythtv-users | |
| [22:19:19] | wylie (wylie!~wylie@ip72-208-123-25.ph.ph.cox.net) has joined #mythtv-users | |
| [22:20:31] | jamesd2 (jamesd2!~jamesd@198.207.185.100) has quit (Ping timeout: 260 seconds) | |
| [22:22:14] | wahrhaft (wahrhaft!~quassel@cpe-24-210-69-143.columbus.res.rr.com) has quit (Ping timeout: 255 seconds) | |
| [22:22:48] | skd5aner (skd5aner!~skd5aner@50.90.30.141) has quit (Read error: Connection reset by peer) | |
| [22:27:40] | Wolfgang2 (Wolfgang2!~Thunderbi@178-27-144-160-dynip.superkabel.de) has joined #mythtv-users | |
| [22:29:42] | jpabq_afk is now known as jpabq | |
| [22:31:29] | bobp127001 (bobp127001!~bobp12700@S0106c0c1c04187d0.vn.shawcable.net) has joined #mythtv-users | |
| [22:32:22] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has quit (Ping timeout: 244 seconds) | |
| [22:35:40] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has joined #mythtv-users | |
| [22:43:45] | jamesd2 (jamesd2!~jamesd@c-67-184-92-56.hsd1.il.comcast.net) has joined #mythtv-users | |
| [22:51:33] | kwmonroe (kwmonroe!~kwmonroe@32.97.110.60) has quit (Quit: Coyote finally caught me) | |
| [22:52:48] | kwmonroe (kwmonroe!~kwmonroe@32.97.110.60) has joined #mythtv-users | |
| [23:06:35] | gregL (gregL!~greg@cpe-74-76-105-205.nycap.res.rr.com) has joined #mythtv-users | |
| [23:07:11] | pmhahn (pmhahn!~pmhahn@2001:4dd0:ff00:8d31:219:dbff:fef2:e135) has quit (Quit: Konversation terminated!) | |
| [23:07:35] | streeter (streeter!streeter@nat/redhat/x-urjigwfvnasyefwu) has quit (Quit: Leaving) | |
| [23:16:19] | awalls (awalls!~awalls@d-216-36-6-220.cpe.metrocast.net) has joined #mythtv-users | |
| [23:17:10] | kwmonroe (kwmonroe!~kwmonroe@32.97.110.60) has quit (Quit: Coyote finally caught me) | |
| [23:17:30] | disputin (disputin!~sean@2001:470:9758:1:6deb:5723:8339:8b57) has quit (Ping timeout: 276 seconds) | |
| [23:18:52] | faichele_ (faichele_!~quassel@p57952A73.dip.t-dialin.net) has quit (Ping timeout: 244 seconds) | |
| [23:20:02] | dkeith (dkeith!~dkeith@69.241.19.12) has quit (Ping timeout: 272 seconds) | |
| [23:21:56] | disputin (disputin!~sean@65.102.58.17) has joined #mythtv-users | |
| [23:25:02] | emmanuelux (emmanuelux!~emmanuelu@vau92-2-82-228-217-1.fbx.proxad.net) has joined #mythtv-users | |
| [23:26:08] | natanojl (natanojl!~jonatan@c83-252-237-63.bredband.comhem.se) has quit (Ping timeout: 255 seconds) | |
| [23:32:15] | shubes (shubes!~shubes@tacs.shubes.net) has joined #mythtv-users | |
| [23:32:18] | shubes (shubes!~shubes@tacs.shubes.net) has left #mythtv-users () | |
| [23:38:52] | npm (npm!~npm@cpe-198-72-183-90.socal.res.rr.com) has quit (Excess Flood) | |
| [23:39:21] | npm (npm!~npm@cpe-198-72-183-90.socal.res.rr.com) has joined #mythtv-users | |
| [23:44:36] | k-man (k-man!~jason@unaffiliated/k-man) has quit (Quit: WeeChat 0.3.7) | |
| [23:46:23] | jamesd2 (jamesd2!~jamesd@c-67-184-92-56.hsd1.il.comcast.net) has quit (Ping timeout: 260 seconds) | |
| [23:51:20] | k-man (k-man!~jason@unaffiliated/k-man) has joined #mythtv-users | |
| [23:51:30] | kwmonroe (kwmonroe!~kwmonroe@32.97.110.60) has joined #mythtv-users | |
| [23:54:43] | kwmonroe (kwmonroe!~kwmonroe@32.97.110.60) has quit (Client Quit) | |
| [23:57:20] | NightMonkey (NightMonkey!~NightrMon@pdpc/supporter/professional/nightmonkey) has quit (Remote host closed the connection) | |
| [23:57:23] | kwmonroe (kwmonroe!~kwmonroe@32.97.110.60) has joined #mythtv-users | |
| [23:58:47] | npm_ (npm_!~npm@cpe-198-72-183-90.socal.res.rr.com) has joined #mythtv-users | |
| [23:59:24] | kwmonroe (kwmonroe!~kwmonroe@32.97.110.60) has quit (Client Quit) | |
| [23:59:34] | npm (npm!~npm@cpe-198-72-183-90.socal.res.rr.com) has quit (Read error: Connection reset by peer) | |
IRC Logs collected by
BeirdoBot.
Please use the above link to report any bugs.