| superm1 | me | 00:01 |
|---|---|---|
| Daviey | superm1: you are of no use to me :) | 00:15 |
| === superm1 is now known as supermario | ||
| supermario | me 3 | 00:15 |
| === supermario is now known as superm1 | ||
| Daviey | heh | 00:15 |
| BullCreek | There seems to be a problem with the lucid beta1 alternate cd where partman can't handle partitions > 2TB anymore. I'm using the alternate cd in lieu of the mythbuntu beta1 cd due of course to the fact that your desktop build doesn't include support for mdadm. I started a thread for it in the forum and filed a bug on launchpad (probably should have been against partman instead of the kernel as I don't think it is a kernel problem after lookin | 00:37 |
| BullCreek | http://ubuntuforums.org/showthread.php?t=1436325 | 00:37 |
| BullCreek | I know quite a few mythbuntu folks use mdadm so was thinking it should probably be addressed before lucid goes gold if possible. | 00:37 |
| Zinn | [ubuntuforums.org] problem with large partition and 10.04BETA - Ubuntu Forums | 00:37 |
| BullCreek | FWIW, it would be great if you could somehow hack your live cd to include mdadm - maybe not a full blown ui for configuring it like the alternate cd has, but at least to where it could recognize pre-existing arrays and include the option of installing on them - particularly since grub2 can now boot from a raid5 or raid6 md device. | 00:41 |
| BullCreek | If one of you guys is savvy in the the machinations of how the partman stuff works and could give me some pointers I might even have some cycles to work on it. | 00:42 |
| superm1 | BullCreek, i think the intention is to eventually be able to support mdadm in the live installer | 00:44 |
| superm1 | BullCreek, you should test with the most recent alternate daily image though to see if it's been fixed since beta | 00:44 |
| superm1 | if it isn't, then please file a bug | 00:44 |
| Daviey | superm1: yeah, it's been a wish list for 3 years IIRC :) | 00:45 |
| BullCreek | i tried yesterdays daily build and it had problems and todays wasn't out yet when I checked this morning. | 00:45 |
| superm1 | it had other problems? | 00:45 |
| BullCreek | yes, the cdrom device was not found and the six sata drives on my motherboard were also not found | 00:46 |
| BullCreek | I will try todays if it is out there now | 00:46 |
| BullCreek | looks like the 3/28 builds must have not worked for some reason as there are no isos in the folder like for the 3/27 builds - maybe they don't do them on Sunday or something | 00:49 |
| BullCreek | http://cdimage.ubuntu.com/daily/20100328/ is the right place to be looking right? | 00:50 |
| Zinn | [cdimage.ubuntu.com] Ubuntu 10.04 LTS (Lucid Lynx) Daily Build | 00:50 |
| superm1 | they do them every day | 00:51 |
| superm1 | but it looks like they failed for today | 00:51 |
| superm1 | oh i heard about the bug you had from yesterdays | 00:51 |
| superm1 | there is something wrong with the updated kernel | 00:51 |
| superm1 | BullCreek, have you tried just apt-get installing mdadm before running ubiquity? | 00:52 |
| superm1 | for live disks that is | 00:52 |
| superm1 | i thought the partition handler didn't freak out entirely if you made the arrays outside of it and wanted to use them | 00:52 |
| superm1 | in which case we could always just include it in our pool for people like you until it's got proper support to make the arrays | 00:53 |
| BullCreek | i tried apt-getting mdadm back in the day on the livecd and it wouldn't pick up the array but that was way back in hardy days or even before if I recall - so it might be worth a shot to try it again (thanks for the suggestion). I agree that that would be a sufficient fix in that it is really easier to configure/build/manage the array on the command line than using the gui anyway. | 01:15 |
| superm1 | i remember at the last UDS that was an item of discussion and someone raised that it might do that today | 01:22 |
| === chromed is now known as chrome | ||
| BullCreek | I apt-getted mdadm - did an "mdadm --assemble /dev/md0" and appear to be off the races - ubiquity correctly puts a gpt partition on the array, and had no complaints about its size. Hopefully it will work - should know soon. Thanks for the help! | 01:44 |
| BullCreek | When they have a working daily build of the alternate cd again I will try it and if it is still broken I will file a bug against partman unless you have a better suggestion. I will also outline this fix in the bug. | 01:45 |
| superm1 | BullCreek, sounds great thanks. | 02:06 |
| dewman | so i got a new card today (well used) a pctv hdpci. I am still having the same issues as before when scanning channels. i dont get all the channels and some of the channels have music on them rather then tv. could that indicate that the channels are encrypted? | 02:50 |
| dewman | since this card has two tuners in it, i need to configure both tuners dont i? | 02:55 |
| matmatmat | my channel scan (which is m3u parsing) doesnt do anything | 03:16 |
| matmatmat | earlier it gave me an error in the console at least when the file formatted improperly | 03:16 |
| matmatmat | now that ive found the right format, it just sits at 0% and says tuning | 03:17 |
| ball | I think I just found a way to justify the cost of a Mythbuntu box. | 03:44 |
| styelz | tivo? | 03:45 |
| ball | styelz: No, but we're supposed to pay the cable TV company something like US$ 16/month for an abyssmal DVR | 03:46 |
| ball | ...perhaps it's more than that, I forget. If I build a Mythbuntu DVR that works, eventually it will pay for itself. | 03:47 |
| ball | ...hopefully. | 03:47 |
| ball | ...and will be less sucky. | 03:47 |
| dewman | and your wife/gf/parter will be happy | 03:58 |
| dewman | or husband | 03:58 |
| ball | dewman: She's really not happy with this DVR. | 03:58 |
| dewman | lol...mine isnt happy with me right now. upgraded to cable and it hasnt worked for a month....lol | 03:59 |
| dewman | my fault on the not working.... I only configured the digital side of the capture card and not the analog side.... | 04:00 |
| dewman | couldnt figure out why i was only getting 20 channels instead of 90 | 04:00 |
| ball | I raided savings to get Cable television installed. | 04:01 |
| ball | :-/ | 04:02 |
| dewman | well i am going to raid the savings to get raid... =P | 04:02 |
| ball | RAID-1? | 04:02 |
| dewman | not sure yet...I have a dl580 sitting idle....so i need to figure out what I am going to do with that, it already has a fiber card in it.... | 04:04 |
| ball | FDDI? | 04:04 |
| ball | ...or Ethernet? | 04:04 |
| dewman | for a san... | 04:06 |
| * ball blinks | 04:09 | |
| ball | Fibrechannel? | 04:09 |
| dewman | yep.. thats it... | 04:11 |
| ball | Just because you have FC, doesn't mean you have to use it. | 04:12 |
| ball | If it makes sense in your application, that's fair enough. | 04:13 |
| dewman | it was a good buy on the box....of course, the power bill will probably kill me.. | 04:14 |
| ball | Does MythTV benefit greatly from a quad core processor, especially if I buy a dual-tuner card? | 04:15 |
| mrand | ball: as long as they aren't frame grabbers, tuners don't chew up cpu. | 04:29 |
| mrand | video decoding can chew up some cpu if you don't have video decoding offload (like Nvidia VDPAU). For standard def, VDPAU isn't really needed, but if you're buying a video card anyway, might as well buy one that can do it, even if you don't move to HD until later. | 04:32 |
| === Metoer is now known as _Metoer | ||
| ball | mrand: any particular nVidia chip to look for? | 05:27 |
| rhpot1991 | ball: depends on your price point and needs | 05:27 |
| mrand | http://www.mythtv.org/wiki/NVidia_Cards | 05:28 |
| Zinn | [www.mythtv.org] NVidia Cards - MythTV | 05:28 |
| rhpot1991 | there are some nice 9500/9600 silent cards | 05:28 |
| mrand | that list looks old | 05:28 |
| rhpot1991 | and then there are things like the ion boxes that also work very well | 05:28 |
| rhpot1991 | !frontend | 05:28 |
| Zinn | Ion Boxes make a great frontend. http://www.baablogic.net/drupal/node/2 | 05:28 |
| mrand | http://www.mythtv.org/wiki/VDPAU | 05:28 |
| rhpot1991 | mrand: very :) | 05:28 |
| Zinn | [www.mythtv.org] VDPAU - MythTV | 05:28 |
| mrand | That list looks new | 05:28 |
| rhpot1991 | GT220 is prob a good card to get now, not sure if anyone ever came out with a silent cell version | 05:29 |
| * rhpot1991 is all about the silent | 05:29 | |
| mrand | I have decent hearing, but I swear I really have to load my machine down with all sorts of flash sites playing on a background website in order to be able to hear my combined FE+BE with 2x750 GB drives that sit 5' to the right of my TV. Hell, even when I'm sitting right in front of it, I barely hear it. | 05:31 |
| Zinn | mrand: Please watch your language. | 05:31 |
| ball | rhpot1991: I think even the GeForce 210 has a fan now. | 05:33 |
| ball | ...sadly. | 05:33 |
| rhpot1991 | I spent more money than I should have on a 1tb silcent cell 9600 | 05:35 |
| rhpot1991 | was the only card I could get to fit in my case though, so it was a good investment | 05:35 |
| ball | I'm going to have to build a whole new machine. | 05:39 |
| mrand | ball: it can be cheap or expensive - all depends on what you want to do. I went kinda middle of the road, but overall I'm not a fan of overspending on computer stuff because tech prices come down so quickly. | 05:42 |
| rhpot1991 | ball: do you already have anything mythtv in place? | 05:48 |
| ball | mrand: I'm not in a position to overspend. What's the bare minimum? | 05:48 |
| ball | rhpot1991: No. | 05:48 |
| rhpot1991 | I'd say you want to build a nice dual or quad core machine, with a nice big hard drive | 05:49 |
| rhpot1991 | look for a nice board with VDPAU capable video, or get a separate card for this | 05:49 |
| ball | 4 Gbytes RAM sufficient? | 05:49 |
| mrand | quad is overkill. I have a cheap dual-core E2200 (2.2 GHz) that keeps up with everything I throw at it. | 05:49 |
| mrand | 2 GB is enough RAM. | 05:50 |
| rhpot1991 | ya I'm on a dual core 5000+ | 05:50 |
| rhpot1991 | pleanty fine | 05:50 |
| rhpot1991 | and 2gb of ram on one, 4gb on another (it was on sale) | 05:51 |
| rhpot1991 | might want to break 2gb if you do onboard video, since you will want to devote 512-1024 of that to video | 05:51 |
| ball | Hmm... okay | 05:54 |
| mrand | I guess it depends on what else you plan on running on the system. If it is *only* Myth BE+FE, then I think that 2 GB is enough, even with video memory. If you're like me and run a zillion other apps on that same machine (including this irc session, along with NX that I'm connected to it with), then going above 2 GB could help slightly. | 05:57 |
| ball | Is VDPAU a binary thing, or open source? | 06:02 |
| mrand | VDPAU is binary. But until Intel manages to get their stuff straight, or AMD finally spits out something usable, it's the best thing going. | 06:02 |
| rhpot1991 | supposidly ATI has the same now, but its not in debian or ubuntu, and doesn't work with mythtv yet | 06:06 |
| ball | Hmm... | 06:11 |
| ball | Presumably VDPAU contains things that are missing from Xvideo | 06:40 |
| === Seeker`_ is now known as Seeker | ||
| === Seeker is now known as Seeker` | ||
| === markl__ is now known as markl_ | ||
| === tgm4883` is now known as tgm4883 | ||
| zyberzero | Hi! Today I've got an ION based HTPC (Intel Atom + Nvidia 9400M). It works fine, but here's the catch: I've got a Full-HD-projector (thru HDMI), a regular monitor (VGA) but I also want to have my old thick TV as well - which uses S-video. What's the most simple way to connect the old TV? I can live with only one output/time, but I want to have the offloading of h264 files. | 19:10 |
| rhpot1991 | zyberzero: that might be tough getting it hooked up to the old tv, IIRC there was a thread on the mailing list with people trying to do the same you might want to check that | 19:12 |
| zyberzero | rhpot1991: okay, thanks. Can you remember any keywords for me to search for? | 19:13 |
| mrand | zyberzero: if all else fails, there are VGA -> composite "scan converters." I get some color banding on mine, but it's functional. | 19:17 |
| mrand | I bought mine on ebay for $20 as I recall. | 19:17 |
| rhpot1991 | zyberzero: not really, I just searched quick here and couldn't find it | 19:17 |
| mrand | Some may have less banding - maybe I should have spent more. | 19:18 |
| rhpot1991 | mrand: just put it towards a fancy new tv instead :) | 19:18 |
| zyberzero | mrand: yes, I used to have one of those in early -00, I may have that somewhere in my "good-to-keep"-boxes. | 19:18 |
| zyberzero | rhpot1991: okay, thanks for your help! :) | 19:18 |
| zyberzero | Btw, have anybody heard that myth hangs up the whole computer while watching recorded tv? | 19:20 |
| mrand | rhpot1991: heh. Course, the TV I want probably doesn't come with VGA input, so I'll still need to buy a video card with HDMI (or else swap motherboards with my wife - she has an Intel G35 with buildin HDMI). All this means that I should have just bought a video card to begin with rather than the stupid scan converter. | 19:21 |
| mrand | zyberzero: it is borderline impossible for it to hang the whole computer... have you tried ssh'ing in from another machine? | 19:21 |
| mrand | Or telnet. | 19:21 |
| zyberzero | It hangs. I can't SSH, the display on the front stops at the time when it hangs etc. | 19:22 |
| rhpot1991 | zyberzero: when does this happen, watching video, in the menu? | 19:22 |
| zyberzero | watching video | 19:22 |
| zyberzero | never ever | 19:22 |
| rhpot1991 | you running VDPAU? | 19:22 |
| mrand | can't ssh? Wow. | 19:22 |
| zyberzero | Yes, VDPAU is activated | 19:23 |
| mrand | zyberzero: you running auto-builds? | 19:23 |
| zyberzero | mrand: I'm running the packages from ubuntu. | 19:23 |
| rhpot1991 | upgrading to audobuilds may help | 19:23 |
| rhpot1991 | you should use QT painter to avoid a potential memory leak issue | 19:24 |
| rhpot1991 | and there are some tweaks to xorg that may help you as well | 19:24 |
| zyberzero | Ok! I think I've actually changed it to OpenGL as I thought it would be smoother. | 19:24 |
| rhpot1991 | http://mythbuntu.pastebin.com/Fmu8cy4j | 19:25 |
| rhpot1991 | there is my xorg.conf | 19:25 |
| rhpot1991 | points of interest, you want UseEvents off (I commented mine out, feel free to delete) | 19:25 |
| rhpot1991 | Enabling tripple buffer and disabing composite may help with tearing but shouldn't really affect your crashing issue | 19:26 |
| rhpot1991 | I'd venture you would be best served upgrading to the latest nvidia drivers from our autobuilds | 19:26 |
| zyberzero | Okay, I'll try that! | 19:27 |
| zyberzero | Thanks one more time for your help! | 19:27 |
| rhpot1991 | you will have to dist-upgrade when installing, it will remove the old nvidia and put the new ones in | 19:27 |
| rhpot1991 | no problem, good luck | 19:28 |
| camelreef | good evening from Scotland | 21:15 |
| camelreef | just a question | 21:15 |
| camelreef | is there any know transiant issue with the packages in Lucid at this time ? | 21:16 |
| camelreef | I've just lost all my tuners, inputs and other storage groups info on a reboot | 21:16 |
| camelreef | the DB appears fine, but the BE or mythtv-setup appear lost | 21:16 |
| camelreef | mythtv-setup shows close to nothing | 21:17 |
| camelreef | I'm a bit stressed | 21:17 |
| camelreef | the last DB backup I have is from Saturday, from .22, before the upgrade | 21:18 |
| camelreef | I could backup the current DB and restore the pre-.23 and see what it does | 21:18 |
| camelreef | but if the pb is non-DB related, I might as well save the time | 21:19 |
| mrand | camelreef: there are no known problems. Do you have any idea what happened? Did you update software? | 21:19 |
| mrand | Have you checked over any logs? | 21:20 |
| rhpot1991 | camelreef: try to repair the db? | 21:21 |
| rhpot1991 | I've seen issues where a crash happened and data seemed lost but after db repairs all was good | 21:21 |
| camelreef | well, I had done normal lucid upgrades | 21:22 |
| camelreef | I do not remember if there was any BE packages in that | 21:22 |
| camelreef | I rebooted the system at noon | 21:23 |
| camelreef | I shut it down this evening | 21:24 |
| camelreef | added a disk | 21:24 |
| camelreef | turned it back on | 21:24 |
| camelreef | did not check anything | 21:24 |
| camelreef | formatted the disk | 21:24 |
| camelreef | mounted it | 21:24 |
| camelreef | then did a massive and long cp from one disk to another. | 21:25 |
| camelreef | that created big I/O wait | 21:25 |
| camelreef | as expected | 21:25 |
| camelreef | I went into mythtv-setup as I wanted to add some directories to storage groups | 21:26 |
| camelreef | and I notices the loss of the storage groups | 21:26 |
| camelreef | and saw the loss of cards, inputs, etc... | 21:26 |
| camelreef | the weird thing is that when I look at the DB, all the info is there | 21:26 |
| rhpot1991 | did it ever work after upgrading to lucid? | 21:27 |
| camelreef | capturecards, cardinput, channel, etc... | 21:27 |
| camelreef | mysqlcheck said all was OK | 21:27 |
| camelreef | and yes, it worked flowlessly from Saturday evening (lucid+.23 upgrade) to this evening | 21:28 |
| superm1 | camelreef, what's your build number and are you on autobuilds? | 21:30 |
| superm1 | i'm wondering if that new patch for the group magic didn't work right on autobuilds last night | 21:30 |
| camelreef | I'm on pure lucid | 21:31 |
| superm1 | okay that can't be it then, nvm | 21:31 |
| camelreef | + medibuntu, but that should make no difference | 21:31 |
| mrand | so you're saying the contents of the database appear to be there and correct. Is the backend running? does it show anything interesting in its log about missing tuners, etc? What happens when you fire up a frontend? | 21:31 |
| camelreef | ok, one answer at a time :o) | 21:32 |
| camelreef | if I fire up a front end I cannot watch Live TV | 21:32 |
| camelreef | I can watch a recordin | 21:32 |
| camelreef | but that's the only storage group lest in mythtv-setup | 21:32 |
| camelreef | let me check the rest of the functionality | 21:33 |
| camelreef | mythvideo shows content | 21:33 |
| camelreef | and it can play files | 21:34 |
| camelreef | said files are in one storage group normally | 21:34 |
| camelreef | that storage group is not seen in mythtv-setup anymore | 21:34 |
| camelreef | but all the onfo is still in the storagegroup table | 21:35 |
| mrand | backend log complain that you don't have any tuners defined now? | 21:35 |
| camelreef | backen is obviously running | 21:35 |
| camelreef | let me look at the logs | 21:36 |
| camelreef | backend logs show no complains during the lunch time reboot so far | 21:37 |
| camelreef | hmmm, a backen start when nothing should have happened i mid afternoon | 21:39 |
| camelreef | wow! | 21:40 |
| camelreef | tons of SQL errors! | 21:40 |
| camelreef | let me look further | 21:41 |
| camelreef | trying to correlate timing sith syslog events | 21:41 |
| camelreef | those errors happened during shutdown | 21:42 |
| camelreef | correlating with sudo logs | 21:43 |
| mrand | so the database maybe got corrupted and didn't get shut down, or had problems shutting down, perhaps? | 21:44 |
| camelreef | let me see | 21:44 |
| camelreef | poweroff issued at 18:10:14 | 21:45 |
| camelreef | first SQL error message at 18:10:16.067 | 21:45 |
| camelreef | nothing in syslog about MySQL shuting down after the issue of poweroff | 21:47 |
| camelreef | no real info in syslog at all | 21:47 |
| camelreef | 18:10:27.907 backen restarts | 21:48 |
| camelreef | 18:10:27.929 Unable to connect to database! | 21:49 |
| camelreef | tries multiple times to connect until machine is off | 21:49 |
| mrand | Is that maybe somewhat expected? I would have hoped that the backend would down first before sql, but maybe sql was shut down first and backend was still trying to talk? | 21:49 |
| camelreef | so we have the sutdown scenario/timing | 21:50 |
| mrand | camelreef: I certainly don't know for certain... just asking if that is maybe a possibility. | 21:51 |
| camelreef | I just have binary logs for mysql | 21:51 |
| camelreef | mrand, it looks like ot | 21:51 |
| camelreef | it | 21:52 |
| camelreef | so, let's look at the SQL error message befor complete sutdown | 21:52 |
| camelreef | 2010-03-29 18:10:16.067 Error preparing query: SELECT chanid, useonairguide FROM channel, dtv_multiplex WHERE serviceid = :SERVICEID AND networkid = :NETWORKID AND transportid = :TRANSPORTID AND channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = :SOURCEID | 21:53 |
| camelreef | 2010-03-29 18:10:16.068 Driver error was [2/2006]: | 21:53 |
| camelreef | QMYSQL3: Unable to prepare statement | 21:53 |
| camelreef | Database error was: | 21:53 |
| camelreef | MySQL server has gone away | 21:53 |
| camelreef | 2010-03-29 18:10:20.803 DB Error (Looking up chanID): | 21:53 |
| camelreef | Query was: | 21:53 |
| camelreef | SELECT chanid, useonairguide FROM channel, dtv_multiplex WHERE serviceid = :SERVICEID AND networkid = :NETWORKID AND transportid = :TRANSPORTID AND channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = :SOURCEID | 21:53 |
| camelreef | Bindings were: | 21:53 |
| camelreef | :NETWORKID=9018, :SERVICEID=16288, :SOURCEID=1, :TRANSPORTID=12291 | 21:53 |
| camelreef | Driver error was [2/2006]: | 21:53 |
| camelreef | QMYSQL: Unable to execute query | 21:53 |
| mrand | !pastebin | 21:53 |
| Zinn | when pasting more than 5 lines of data please use http://mythbuntu.pastebin.com so you don't flood the channel. Then please post the link in the channel. | 21:53 |
| camelreef | Database error was: | 21:53 |
| camelreef | MySQL server has gone away | 21:53 |
| camelreef | mrand is right | 21:53 |
| camelreef | MySQL gone before backend | 21:53 |
| camelreef | oops,, sorry | 21:54 |
| camelreef | all SQL are just queries for data, not modifications | 21:55 |
| camelreef | ok, let's look at the startup | 21:56 |
| camelreef | 18:33:36 syslog resumes | 21:56 |
| camelreef | 18:34:00.932 backend restarts | 21:57 |
| camelreef | let's look at syslog in-between | 21:57 |
| camelreef | 18:33:53 mysql starts | 21:58 |
| camelreef | 18:33:57 favia /etc/mysql/debian-start[1851]: Triggering myisam-recover for all MyISAM tables | 21:59 |
| camelreef | last entry is usual for mysql starts | 22:03 |
| camelreef | nothing else in syslog | 22:03 |
| camelreef | backend logs now | 22:03 |
| camelreef | 18:34:04.101 Connected to database 'mythconverg' at host: localhost | 22:04 |
| rhpot1991 | camelreef: might be easier if you pastebin the entire logs, or run mythbuntu-log-generator | 22:05 |
| camelreef | 18:34:04.546 Current MythTV Schema Version (DBSchemaVer): 1254 | 22:05 |
| camelreef | I will post all | 22:05 |
| camelreef | but I want to do my digging too | 22:05 |
| camelreef | first sign that something is wrong: 18:34:05.588 DiSEqCDevTree, Warning: No device tree for cardid 24 | 22:06 |
| camelreef | and then stuff about DTD mux and chans | 22:06 |
| camelreef | oh well | 22:08 |
| camelreef | so something got killed during poweroff | 22:08 |
| camelreef | running log-generator | 22:09 |
| camelreef | what package is it in? | 22:09 |
| camelreef | not in a package, apparently | 22:10 |
| camelreef | ok, posted the logs on my web site | 22:18 |
| camelreef | http://www.youplala.net/~will/htpc/20100329/ | 22:19 |
| Zinn | [www.youplala.net] Index of /~will/htpc/20100329 | 22:19 |
| camelreef | remeber, poweroff issued at 18:10 | 22:19 |
| camelreef | rhpot1991, logs are posted | 22:20 |
| mrand | what you described certainly seems to be reflected in the logs. | 22:26 |
| camelreef | the only thng we can get from the logs is indeed the MySQL shutdown before the backend | 22:26 |
| camelreef | or died somehow | 22:27 |
| camelreef | there isn't anything else to get from that | 22:27 |
| camelreef | frontend logs show absolutely nothing | 22:27 |
| camelreef | messages same thing | 22:27 |
| camelreef | sooooo...... | 22:29 |
| mrand | Yeah, I wouldn't expect it to. The likelihood of mysql dying on its own right then seem pretty small to me... more likely that the shutdown terminated the process. Safest thing to do for now (until this can be sorted out) is to shut down mythbackend first, then shutdown the rest of the machine. I'd try repairing your database, and if that doesn't work, restore. | 22:29 |
| camelreef | the database never showed any error on mysqlcheck | 22:29 |
| camelreef | that is also weird | 22:29 |
| camelreef | sooo..... | 22:30 |
| camelreef | I will take a dump of the current broken (?) db | 22:30 |
| camelreef | restore my .22 DB | 22:30 |
| camelreef | start the backend | 22:30 |
| camelreef | start mythtv-setup and go through the DB upgrade phase | 22:31 |
| mrand | yes, or mythtv-setup. I think either one will upgrade the database. | 22:31 |
| camelreef | yes, probably mythtv-setup first | 22:31 |
| mrand | don't need to start backend before firing off mythtv-setup... it'll just shut it down. | 22:31 |
| camelreef | then the backend | 22:31 |
| camelreef | then the frontend | 22:31 |
| mrand | yep | 22:31 |
| camelreef | then hunt orphan recordings from the last 2 days | 22:32 |
| camelreef | np, kids cartoons | 22:32 |
| mrand | everything is a learning experience ;-) | 22:32 |
| camelreef | here we go | 22:32 |
| camelreef | stop backend | 22:32 |
| camelreef | backing up current broken DB using phpmyadmin | 22:33 |
| camelreef | dropping all tables | 22:35 |
| camelreef | importing 0.22 DB | 22:36 |
| camelreef | ok, restored | 22:45 |
| camelreef | going to mythtv-setup | 22:45 |
| camelreef | and all the rest | 22:45 |
| camelreef | ok, all is back | 22:58 |
| camelreef | indedd a broken DB | 22:58 |
| camelreef | indeed | 22:58 |
| camelreef | probably from MySQL going away before mythbackend | 22:59 |
| camelreef | want a bug about it? | 23:00 |
| mrand | Very interesting. Yes, please attach those two log files to a bug if you could. | 23:01 |
| camelreef | with pleasure | 23:01 |
| camelreef | against mythtv-backen, I presume ? | 23:02 |
| mrand | camelreef: either backend or mythbuntu. The ticket can be moved around. | 23:03 |
| camelreef | ok | 23:05 |
| camelreef | I'll use ubuntu-bugs | 23:05 |
| camelreef | then atatche the 2 logs | 23:05 |
| mrand | Awesome. | 23:06 |
| camelreef | https://bugs.launchpad.net/ubuntu/+source/mythtv/+bug/551277 | 23:27 |
| Zinn | [bugs.launchpad.net] Bug #551277 in mythtv (Ubuntu): “mythtv-backen stopped after mysql on shutdown causing database corruption” | 23:27 |
| camelreef | how's that ? | 23:27 |
| camelreef | with typo and all... | 23:28 |
| camelreef | corrected the typo | 23:28 |
| camelreef | https://bugs.launchpad.net/ubuntu/+source/mythtv/+bug/551277 | 23:28 |
| Zinn | [bugs.launchpad.net] Bug #551277 in mythtv (Ubuntu): “mythtv-backend stopped after mysql on shutdown causing database corruption” | 23:28 |
| mrand | camelreef: that will certainly provide the developers with a reminder to check it out. | 23:32 |
| mrand | greatly appreciated. | 23:33 |
| camelreef | np | 23:34 |
| camelreef | thanks for the attention | 23:34 |
| superm1 | camelreef, oh man that's messy. i dunno how we can fix such things.... | 23:37 |
| camelreef | really ? | 23:37 |
| superm1 | well all the processes get sent the TERM signal at the same time I thought | 23:37 |
| camelreef | ouch | 23:37 |
| superm1 | i'm not sure you can really control which one goes down in what order | 23:37 |
| camelreef | maybe it was one in a million | 23:37 |
| camelreef | I had shut down the machine a few times since the upgrade | 23:38 |
| superm1 | although there are things like pre-stop scripts i think for upstart jobs | 23:38 |
| camelreef | or maybe I was hit by a solar flare or whatnot | 23:38 |
| camelreef | but the logs are there | 23:39 |
| camelreef | and I think that the one thing vsible is that mysql went down before mysql | 23:39 |
| camelreef | not much else is visible | 23:39 |
| camelreef | the real problem could be hidden | 23:40 |
| superm1 | is mysql an upstart job these days? | 23:40 |
| superm1 | i forget it if it got converted | 23:40 |
| superm1 | although maybe i converted it | 23:40 |
| superm1 | yeah i did - that's right | 23:40 |
| superm1 | so maybe there is a way to set dependencies on the way down | 23:41 |
| camelreef | that would be excellent | 23:41 |
| camelreef | could you do that on the way up to? | 23:42 |
| camelreef | I may remember an occasion when the backen was waiting for mysql | 23:42 |
| camelreef | I may be wrong, though | 23:42 |
| camelreef | anyway, good luck with that | 23:47 |
| camelreef | off to bed for me | 23:47 |
| camelreef | ttyl | 23:47 |
| superm1 | cya | 23:55 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!