[02:48] <UForgotten> The following packages have unmet dependencies: mythweb : Depends: mythtv-common (>= 2:0.25.0+fixes.20120510.f22e556-0ubuntu0mythbuntu4) but 2:0.25.0+fixes.20120509.7fbcfb4-0ubuntu0mythbuntu4 is to be installed
[02:48] <UForgotten> just an fyi - I can't install mythweb after updating from the mythbuntu repo.
[02:49] <UForgotten> those are some gnarly package names :(
[02:49] <tgm4883> mythtv-common is a gnarly package name?
[02:50] <UForgotten> ok, version string :P
[02:50] <tgm4883> I'll agree, but it's all important info
[02:52] <UForgotten> seems like it would be easy to create a dependency hell with the +fixes.yaddayadda if say more than one release per day happened.
[02:52] <Zinn> UForgotten: Please watch your language.
[02:53] <patdk-lap> that is what the 7fbcfb4 is for
[02:53] <UForgotten> what if you hash 7f first then a0 later?
[02:53] <UForgotten> pwned.
[02:54] <patdk-lap> is it a hash?
[02:54] <tgm4883> I'm not entirely sure why you would get into dependency hell
[02:54] <Zinn> tgm4883: Please watch your language.
[02:54] <UForgotten> for teh lulz.
[02:55] <UForgotten> just dont release more than once per day and you're fine :)
[02:55] <tgm4883> well the 7fbcfb4 is the git revision
[02:55] <UForgotten> I figured as much
[02:55] <tgm4883> which should be ever increasing
[02:55] <UForgotten> no, its a sha hash - the number can be anything.
[02:56] <tgm4883> ok
[02:56] <UForgotten> but thats not the point.  the point is, somebody broke dependencies on mythweb, so who can I politely ask to fix it :)
[02:56]  * tgm4883 doesn't do much with git, more with bzr
[02:57] <tgm4883> UForgotten, apt-get update?
[02:57] <UForgotten> tgm4883: that's what I did to get that error...
[02:57] <tgm4883> apt-get -f install?
[02:57]  * patdk-lap doubts they are broken
[02:57] <patdk-lap> I know I have this issue too
[02:57] <patdk-lap> I think you have to uninstall mythvideo
[02:58] <patdk-lap> update, then reinstall it
[02:58] <UForgotten> wierd
[02:58] <tgm4883> patdk-lap, mythvideo?
[02:58] <UForgotten> isnt mythvideo part of myth core now?
[02:58] <tgm4883> mythvideo doesn't exist anymore
[02:58] <tgm4883> UForgotten, yes
[02:58] <patdk-lap> yep
[02:58] <patdk-lap> oh, mythweb I mean
[02:58] <UForgotten> MYTHWEB is not YET installed
[02:59] <tgm4883> UForgotten, have you tried the -f install?
[02:59] <UForgotten> have not tried that, but should not have to force it if dependencies were correct
[02:59] <tgm4883> that doesn't mean force
[02:59] <patdk-lap> oh, you got a strange repo sync :)
[02:59] <patdk-lap> a newer mythweb than mythtv
[03:00] <patdk-lap> some mirror isn't syncing correctly, it sounds like
[03:00] <tgm4883> patdk-lap, doubtful
[03:00] <UForgotten> no, happens all the time
[03:00] <UForgotten> crappy cdn's
[03:00] <patdk-lap> heh?
[03:00] <tgm4883> strange
[03:01] <tgm4883> I've never had that happen
[03:01] <patdk-lap> mythweb depends on 20120510? but only 20120509 available
[03:01] <patdk-lap> sounds like a packaging mirror issue
[03:01] <UForgotten> someone rolled a mythweb fix and somehow its out of sync with myth-common
[03:03] <tgm4883> actually no, I don't think that is possible
[03:03] <UForgotten> anything's possible given chaos theory
[03:03] <patdk-lap> good movie :)
[03:03] <tgm4883> I mean the mirror sync issue
[03:03] <tgm4883> that can't happen
[03:03] <patdk-lap> ya, the package list would be mirrored
[03:03] <tgm4883> exactly
[03:04] <patdk-lap> so it happened where ever the package list came from
[03:04] <UForgotten> if you only have one server, it can't happen
[03:04] <UForgotten> the second you introduce a second server, it can happen :)
[03:04] <tgm4883> UForgotten, no it cannot
[03:04] <patdk-lap> no, it would give a different error
[03:04] <patdk-lap> file not found
[03:04] <patdk-lap> but the dependency would be fine
[03:04] <tgm4883> you are implying that the list of packages on the 2nd server is generated on the 2nd server
[03:04] <tgm4883> it's not, the list is transfered as well
[03:05] <UForgotten> ok, so to recap
[03:05] <UForgotten> the package itself references a non-existent package
[03:05] <patdk-lap> no
[03:05] <tgm4883> but that isn't the error you said
[03:05] <patdk-lap> you haven't downloaded any packages yet
[03:05] <patdk-lap> the package list is not right
[03:06] <UForgotten> where are the dependencies maintained? in the package list itself? not in the package?
[03:06] <UForgotten> must be a debian thing
[03:06] <patdk-lap> both
[03:06] <tgm4883> I see what happened
[03:07] <tgm4883> Unfortunately I don't have a fix for you right now
[03:08] <UForgotten> thats ok, as long as someone knows about it.
[03:08] <UForgotten> oh btw I tuned my file system and mysql settings
[03:08] <UForgotten> mythfilldb runs in 4 minutes flat
[03:09] <patdk-lap> 4min?
[03:09] <tgm4883> UForgotten, what did you change?
[03:09] <patdk-lap> I can't remember it ever taking >1min
[03:09] <UForgotten> yep. pretty sick considering it took 30+ mins before
[03:10] <tgm4883> I'm running some tests right now on some new defaults
[03:10] <UForgotten> tgm4883: http://www.mythtv.org/wiki/Optimizing_Performance
[03:10] <Zinn> [www.mythtv.org] Optimizing Performance - MythTV Official Wiki
[03:10] <UForgotten> tgm4883: there's a mysql section
[03:10] <UForgotten> for the fs, added noatime,barrier=0
[03:11] <patdk-lap> those are really just normal mysql adjustments
[03:11] <UForgotten> I added more tho
[03:11] <UForgotten> well
[03:11] <tgm4883> yea we can't really make that a generic end all be all
[03:11] <UForgotten> not more items, more memory
[03:11] <patdk-lap> mysql is unlikely to use more memory
[03:11] <patdk-lap> and that assumes myisam database
[03:12] <patdk-lap> if you want it even faster, switch it to innodb
[03:12] <patdk-lap> and tune for innodb instead of myisam
[03:12] <UForgotten> sure, there's tons of innodb tunings
[03:12] <UForgotten> but I didn't want to deal with all the alter tables :)
[03:12] <UForgotten> erll
[03:12] <patdk-lap> no, you don't want to altertable all of them
[03:12] <UForgotten> in this case alter database
[03:12] <tgm4883> UForgotten, are you using the default innodb engine or myisam?
[03:12] <patdk-lap> just the tables that change
[03:12] <tgm4883> in 12.04?
[03:13] <UForgotten> tgm4883: I'm using whatever mythbuntu ships with, probably myisam
[03:13] <tgm4883> nope, innodb in 12.04
[03:13] <tgm4883> it's the default in mysql 5.5
[03:13] <CyberKnet> hi tgm4883. Do you know if I have to switch to the 0.26 repository to get this patch? https://github.com/MythTV/mythtv/commit/f81f712537b63502814d1f274c7da14196cedd8c
[03:13] <Zinn> [github.com] Fixes #9830. Refs #10519. Fixes channel change on PVR350. Â· f81f712 Â· MythTV/mythtv Â· GitHub
[03:14] <UForgotten> tgm4883: I hate to break it to you but its myisam
[03:14] <tgm4883> CyberKnet, I hate git, so I have no idea :)
[03:14] <tgm4883> is it in the 0.25 branch?
[03:14] <CyberKnet> tgm: it's a post 0.25 patch
[03:14] <tgm4883> UForgotten, I hate to break it to you, but it's innodb
[03:14] <CyberKnet> but I wasn't sure if you guys were pulling stuff into a 0.25-fixes that I would get with 12.04, or if it requires moving to the 0.26 branch
[03:14] <CyberKnet> s/branch/repository
[03:14] <tgm4883> UForgotten, http://dev.mysql.com/doc/refman/5.5/en/innodb-storage-engine.html
[03:15] <Zinn> [dev.mysql.com] MySQL :: MySQL 5.5 Reference Manual :: 14.3 The InnoDB Storage Engine
[03:15] <patdk-lap> UForgotten, did you upgrade to 12.04 from something else?
[03:15] <UForgotten> tgm4883: ls /var/lib/mysql/mythconverg
[03:15] <tgm4883> UForgotten, InnoDB is a high-reliability and high-performance storage engine for MySQL. Starting with MySQL 5.5, it is the default MySQL storage engine. Key advantages of InnoDB include:
[03:15] <UForgotten> tgm4883: there are .MYD and .MYI files in there
[03:15] <tgm4883> UForgotten, so?
[03:15] <UForgotten> tgm4883: clean install of mythbuntu on a brand new hard drive
[03:16] <UForgotten> tgm4883: so those would not exist if it were innodb.  tell me the mysql root password and I will prove it
[03:16] <tgm4883> UForgotten, correct, upstream specifically makes some tables myisam (actually most of them)
[03:16] <UForgotten> well there you go
[03:16] <UForgotten> so its not innodb :)
[03:16] <UForgotten> by _default_ sure
[03:16] <tgm4883> UForgotten, the fact that you have to ask me the mysql root password proves you don't know what your talking about ;)
[03:16] <UForgotten> tgm4883: I can break into it in 2 seconds
[03:16] <patdk-lap> heh, just look for frm files, without MYD files
[03:16] <tgm4883> UForgotten, break what?
[03:17] <UForgotten> authentication in mysql
[03:17] <UForgotten> --skip-grant-tables
[03:17] <tgm4883> UForgotten, god I hope so, it's set to your first users password :)
[03:17] <tgm4883> and easily resettable via
[03:17] <tgm4883> !mysql
[03:17] <Zinn> If you are having problems connecting to your mysql database, perform the following to reconfigure it: [1] sudo dpkg-reconfigure mysql-server-5.1 (pay attention to the root password you set, you will need it later)  [2] sudo dpkg-reconfigure mythtv-database [3] sudo dpkg-reconfigure mythtv-common
[03:17] <UForgotten> sql
[03:17] <UForgotten> nice
[03:19] <tgm4883> so to reiterate what I was saying, the default storage engine in myql 5.5 is innodb. Upstream makes most tables myisam. mythweather tables are innodb (not sure if upstream specified this) and temp tables are the system default
[03:19] <UForgotten> ok, I have no argument with that statement.
[03:19] <UForgotten> what I was arguing was about all tables being myisam.
[03:19] <tgm4883> so issues with mythfilldatabase taking a really long time are due to the innodb switch with regards to temp tables
[03:20] <UForgotten> so you're saying innodb is slower on the temp tables?
[03:20] <patdk-lap> if you didn't give innodb any ram, it will be painful
[03:20] <tgm4883> UForgotten, only because it isn't tweaked
[03:20] <patdk-lap> default is 8megs :(
[03:21] <tgm4883> I'm trying to reproduce, but it seems to take about 12 - 15 minutes on my backend no matter what I throw at it
[03:21] <patdk-lap> innodb loves ram
[03:21] <UForgotten> tgm4883: seems like it would be trivial to tweak both innodb and myisam, if you assume all users have 512mb of ram and make that a requirement
[03:21] <tgm4883> UForgotten, well yes, and that is why we are looking at tweaking it. There are a few issues though
[03:21] <tgm4883> 1) I cannot reproduce the issue
[03:21] <patdk-lap> you want to dedicate 512megs of ram to mysql that is normally only 50-200megs?
[03:22] <UForgotten> I didnt say dedicate 512 megs to mysql
[03:22] <tgm4883> 2) we didn't know about this issue until after release
[03:22] <UForgotten> I meant to assume they HAVE 512 and adjust tunings accordingly
[03:22] <UForgotten> tgm4883: if you're taking 12-15 minutes, you are reproducing the issue
[03:22] <patdk-lap> 512megs isn't enough ram for a combined frontend/backend
[03:22] <CyberKnet> tgm4883: given that mine took 2.5h if you have something you want to try, let me know.
[03:23] <CyberKnet> I have 8gb ram in a dedicated back end, so I can throw as much memory at it as you want.
[03:23] <tgm4883> That couldn't have happened better if I asked :)
[03:23] <UForgotten> a full empty run took 7 hours before
[03:23] <patdk-lap> how large is the temp tables?
[03:25] <tgm4883> CyberKnet, what options are you running with when testing mythfilldatabase?
[03:25] <tgm4883> UForgotten, ^
[03:25] <UForgotten> no options
[03:25] <UForgotten> just mythfilldatabase
[03:25] <UForgotten> I dont know how large the temp tables got
[03:26] <CyberKnet> tgm4883: none. just mythfilldatabase on the command line - although I had just removed and re-added all my channels so I had no channel data.
[03:27] <CyberKnet> if there's a way to remove all the guide data without necessarily having to rescan my channels I'd love that more than having to rescan channels again :)
[03:28] <CyberKnet> It took quite a while to rescan the HD channels.
[03:28] <UForgotten> --dd-grab-all does that I think
[03:29] <UForgotten> it will still probably update channels
[03:29] <UForgotten> CyberKnet: what file system are you running?  probably some tweaks there
[03:29] <CyberKnet> ext4
[03:29] <UForgotten> ok definitely add noatime,barrier=0 to your options
[03:29] <UForgotten> that made a huge difference for me
[03:30] <UForgotten> instead of 2MB/s writes I get 5 MB/s now
[03:30] <CyberKnet> that's a dangerous change to make though.
[03:30] <UForgotten> not really
[03:30] <CyberKnet> if you live in an area with unreliable power.
[03:30] <UForgotten> its just disabling a feature.
[03:30] <UForgotten> you should never run a pc without a ups
[03:30] <UForgotten> ever
[03:30] <CyberKnet> ext4's failure mode on an irregular unmount is pretty bad.
[03:30] <CyberKnet> Sure. Or if you get a kernel panic.
[03:31] <CyberKnet> I'd like to say it never happens, but it wouldn't be true.
[03:31] <UForgotten> well thats a different story lol
[03:31] <CyberKnet> ;)
[03:31] <tgm4883> yea
[03:31] <tgm4883> --dd-grab-all                   refresh full data using DataDirect
[03:31] <tgm4883> I wasn't running that before, so I'm running it now
[03:31] <patdk-lap> UForgotten, try adding this to mysql: innodb_flush_log_at_trx_commit=2
[03:31] <CyberKnet> and I can never remember the sysreq magic keys
[03:31] <CyberKnet> there's an acronym for the keys to press and the order to press them, but I never remember.
[03:31] <CyberKnet> ext4 on root, xfs on video
[03:32] <patdk-lap> heh, I'm running mysql + video on zfs
[03:32] <tgm4883> CyberKnet, busier backwards
[03:32] <tgm4883> or Raising Elephants Is So Utterly Boring
[03:33] <tgm4883> I always remember busier though
[03:33] <tgm4883> as in, I'd be busier if I didn't have to reboot this box
[03:33] <CyberKnet> hahaha
[03:33] <CyberKnet> yeah
[03:33] <CyberKnet> I need to write it on paper and then tape it above my sysreq key :)
[03:34] <CyberKnet> tgm4883: ok, the patch in question for trac 9830 is in the fixes/0.25 branch. Is that building for 12.04 ?
[03:34] <tgm4883> yes
[03:34] <tgm4883> are you running amd64 or i386?
[03:34] <CyberKnet> amd64
[03:34] <tgm4883> then you will want to wait
[03:34] <tgm4883> probably 10 hours
[03:35] <tgm4883> that should be safe :)
[03:35] <tgm4883> UForgotten is running amd64 as well
[03:35] <CyberKnet> Linux thunder 3.2.0-24-generic #37-Ubuntu SMP Wed Apr 25 08:43:22 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
[03:35] <CyberKnet> I will want to wait 10 hours?
[03:35] <tgm4883> yea
[03:35] <CyberKnet> and there will be an update via apt-get?
[03:36] <tgm4883> otherwise you'll be like "why is it telling me it can't install mythtv-common!"
[03:36] <tgm4883> yea
[03:36] <UForgotten> heh
[03:36] <CyberKnet> aaah :)
[03:36] <CyberKnet> hah
[03:36] <CyberKnet> sweet, thanks tgm4883 :)
[03:36] <tgm4883> CyberKnet, in reality, you can watch for the amd64 builds to finish building here https://launchpad.net/~mythbuntu/+archive/0.25/+packages
[03:36] <Zinn> [launchpad.net] Packages in “0.25” : 0.25 : “Mythbuntu Developers” team
[03:36] <CyberKnet> I updated last night, so I don't mind waiting 24 hours.
[03:36] <tgm4883> but they aren't scheduled to start for 9 more hours
[03:36] <CyberKnet> can I still switch repos via dpkg-reconfigure, or do I have to use mcc?
[03:37] <tgm4883> you have to use MCC in 12.04
[03:37] <CyberKnet> does it have a command line counterpart?
[03:37] <tgm4883> if you really really don't want to use MCC, there is a cmd line way
[03:37] <CyberKnet> It's not that I mind MCC, it's nice.
[03:37] <CyberKnet> it's that I'm frequently not at the head of my backend :)
[03:37] <tgm4883> yea
[03:38] <CyberKnet> and VNC ... well it's VNC, right? :D
[03:38] <CyberKnet> over a LAN it's fine. over SSH ... not so much :)
[03:38] <tgm4883> you can add any PPA via apt-add-repository, such as 'apt-add-repository ppa:mythbuntu/0.25'
[03:38] <CyberKnet> anyways, I think I have them both on 0.25 right now anyway, so I'll update in a few hours.
[03:38] <CyberKnet> oh, cool.
[03:39] <tgm4883> that will probably confuse the MCC plugin though, I haven't tested that
[03:39] <CyberKnet> If I'm completely honest though, I will promptly forget that though, and bug you about it next time. :D
[03:39] <CyberKnet> I'll just make a habit of waiting to use MCC
[03:39] <CyberKnet> that will make us all happy.
[03:40] <CyberKnet> MCC really is quite a nice utility. And as of yet, I haven't heard myself offering to make it work in text mode :D
[03:40] <CyberKnet> ncurses.
[03:41] <CyberKnet> tgm4883: I'm about to be gone for 15 mins or so. Anything you need/want me to try mysql-related before I do?
[03:41] <tgm4883> CyberKnet, nope, I'm running another test right now that seems to be taking longer, so I'll wait until it finishes
[03:41] <tgm4883> if it's reproduced the issue, I can actually work on the tweaks
[03:42] <CyberKnet> nice. thanks for your hard work on this man. :)
[03:42] <CyberKnet> uh... stupid question ... how do I find out what version of myth packages I have installed from the command line?
[03:43] <tgm4883> dpkg -l mythtv*
[03:43] <tgm4883> or you could ask the binaries
[03:43] <tgm4883> mythfrontend --version
[03:43] <tgm4883> mythbackend --version
[03:44] <CyberKnet> hmmmm
[03:44] <CyberKnet> I think that I should already have that patch then.
[03:44] <CyberKnet> it was post 0.25 but my packages are 2:0.25.0+fixes.20120423.46062bf-0ubuntu0mythbuntu3
[03:46] <CyberKnet> which if I am reading that correctly should have an update made on 2012-04-02 15:03:40
[03:46] <CyberKnet> https://github.com/MythTV/mythtv/blob/fixes/0.25/mythtv/libs/libmythtv/mpegrecorder.cpp
[03:46] <Zinn> [github.com] mythtv/mythtv/libs/libmythtv/mpegrecorder.cpp at fixes/0.25 Â· MythTV/mythtv Â· GitHub
[03:46] <CyberKnet> Zinn is such a clever cookie.
[03:46] <Zinn> Hi CyberKnet, something I can help you with today?  I am a bot, use !help to see what I can do.
[03:47] <CyberKnet> anyways. that is not good news for me.
[03:47] <UForgotten> Zinn, can you calculate the airspeed velocity of a laden swallow?
[03:47] <Zinn> Hi UForgotten, something I can help you with today?  I am a bot, use !help to see what I can do.
[03:47] <UForgotten> !help
[03:47] <CyberKnet> I was hoping to fix an issue with the PVR-500 that occurred since I upgraded to 0.25.
[03:47] <Zinn> !help For a  complete list of my knowledge visit: http://www.baablogic.net/Zinn.cgi  Other available commands: !status, !about, !bug [bug_number].
[03:47] <CyberKnet> back to back recordings on the same tuner seem to keep both tuners on the card until reboot.
[03:47] <CyberKnet> drat.
[03:47] <CyberKnet> ok.
[03:47] <CyberKnet> thanks tgm4883.
[03:50] <UForgotten> tgm4883: mythfilldatabase --dd-grab-all finished in 15 minutes
[03:51] <tgm4883> UForgotten, mine is still going on the default settings
[03:51] <tgm4883> so I'd say it's reproduced
[03:51] <tgm4883> but I'll wait for it to finish so I can gauge how much better it gets
[03:51] <UForgotten> ok. have fun. g'night
[03:51] <tgm4883> night
[23:32] <a8s0lut0> hey hey, having loads of issues with mythbuntu 12.04 out of the box
[23:33] <a8s0lut0> anyone available to chat for a minute?  Love the product, was super pumped for mythbuntu 12.04, i figured it'd be nothing but improvements
[23:33] <a8s0lut0> that and my 11.10 quit tuning channels.. anyway..
[23:35] <a8s0lut0> 1) HDMI doesn't work after reboot (installed w/ VGA output)           2) HDHomeRun_config can't find my tuners    3) sound doesn't work (when HDMI did for a minute, and i can't find "sound preferences"!!
[23:40] <a8s0lut0> 4) VNC doesn't connect, but is running.
[23:41] <a8s0lut0> I had to overcome those in 11.10 but googling forums and things mostly worked
[23:41] <a8s0lut0> this time, not so much