FS#3972 - MythTV update and bugfix - 0.19 and MySQL

Attached to Project: Arch Linux
Opened by Sasha (kleptophobiac) - Tuesday, 14 February 2006, 10:26 GMT
Last edited by Paul Mattal (paul) - Wednesday, 22 February 2006, 14:06 GMT
Task Type Bug Report
Category Packages: Extra
Status Closed
Assigned To Paul Mattal (paul)
Architecture not specified
Severity Medium
Priority Normal
Reported Version 0.7.1 Noodle
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

The current version of MythTV doesn't get along with the current versions of qt and mysql. Mysql 5.0.x have a different timeout setting for connections than mysql 4. It's dropping mythtv connections and then neither app starts them back up again.

I've included the PKGBUILD I use to build MythTV. It has a modified mythdbcon.cpp from the SVN repository that should bandaid over the real problem.

While I'm at it, I'd like to request ownership of the MythTV package and put it back in the AUR. I read the mythtv mailing lists daily, I use the app daily, and I maintain all of the plugin modules. I think it makes sense that the main app is built by the same person as the plugin modules. I also think it makes sense that the main app is built by someone that uses it every day.

It's your call, of course, but I think it's a logical request.
This task depends upon

Closed by  Paul Mattal (paul)
Wednesday, 10 May 2006, 14:32 GMT
Reason for closing:  Fixed
Additional comments about closing:  Upgraded to fixes branch svn, which contains the fix for the issue.
Comment by Dale Blount (dale) - Tuesday, 14 February 2006, 13:28 GMT
I for one don't use the AUR and would like at least the mythtv 0.19 to remain in extra. You're always welcome to add a mythtv-devel package or so for use in the AUR which contains the latest fixes.
Comment by Paul Mattal (paul) - Tuesday, 14 February 2006, 17:34 GMT
I agree that I have not had as much time as I would have liked to keep up with Myth as you, and I'd like to work toward your maintenance of the package. I expect you will also have more time than I to maintain ivtv, and it might be best to give that up to you, too, if you want.

The question would be how to go about doing this. It seems to me that the following would be logical:

1) I'll let you maintain the PKGBUILD materials, I'd just build them and rubber stamp them -- and we would list you as maintainer in the PKGBUILD. There could still be delay inherent here; sometimes I get swamped and have less than enough time to get to things. So I move that we get out of this state sooner rather than later.

2) I'll sponsor you for becoming TU. You could maintain the myth packages, then, in [community]. We could move mythtv and ivtv into [community]. Since Myth is plenty of work on its own, I don't think anyone would complain about you only maintaining those packages, even if it's below any package number minimum, to maintain TU status.

Then perhaps one day, based on what Judd and the others think about your work in the AUR, perhaps you end up made Developer and can put the whole lot of Myth packages into [extra].

Dale, are you content as long as you don't have to build the packages yourself? Or do you disprefer having to go to [community] at all? Sasha has demonstrated time and again that he's more knowledgeable than I about Myth, and I'd welcome having his energy put to good use.

Other thoughts?
Comment by Dale Blount (dale) - Tuesday, 14 February 2006, 18:25 GMT
I'm still weary of using binary packages from [community] at all. I know I'm probably over reacting, but better safe than sorry (at least for me). If you still want to move it out, I'll just build it from source, it's not a big deal.

Ideally your point #1 works best for me (even if I have to help out when you're overloaded to build/stamp the packages).

Comment by Sasha (kleptophobiac) - Friday, 17 February 2006, 11:25 GMT
I don't know if I'm ready to be a TU. Option #1 looks good to me for now.

I'll keep a watch on making sure mythtv operates as well as possible on Arch and just post to bugs when something comes up. :)
Comment by Paul Mattal (paul) - Wednesday, 22 February 2006, 13:11 GMT
A few things.

1) The mythdbconn.cpp in the p7zip didn't match the md5sum in the PKGBUILD. I determined that this was because it was using CRLF (DOS-style) endlines instead of UNIX ones. After I converted those, it matched the ms5sum. How would this have happened?

2) The mythdbconn.cpp in the myth 0.19 tarball seems to be exactly the same as the one you've provided. Is this left over from before the change was integrated into the main branch? I've removed this from the build since it has no effect.

3) It would be hugely helpful if you could send me future changes in the form of a patch file to the existing package; it will take less time for me to figure out what's going on and get the changes integrated.

4) I don't believe we need to require 'x-server'. One might want to run the backend on an x-less box, and it seems silly to require X for that unless it breaks something. In any case, there certainly should be some compile-time dependencies for X, which I need to re-do anyhow for the new xorg. I'll do that as soon as we get this thing working again.

5) I notice you required ffmpeg. That's probably fine, even though it might sometimes be overkill, it's relatively small for someone already installing myth.

The new build will be up in testing shortly. Let me know what you think!
Comment by Sasha (kleptophobiac) - Wednesday, 22 February 2006, 17:06 GMT
Ah, I didn't notice it got integrated into the main branch. Sorry about that. As for the line encoding, that's probably because I packaged it on a windows box after getting everything via scp from my linux box.

X-server is required for both the backend and the frontend. The backend requires it to run a configuration GUI (mythtv-setup, there's been some talk of making a CLI version). FFmpeg is required for various encoding, transcoding, decoding operations. There's no way of getting around that one.

Further testing of .19 tells me that mythtv still isn't getting along with the most recent builds of mysql. I honestly don't know what to do about it, since I don't know enough cpp to delve into the code and find out what's dying, and the devs don't acknowledge that the problem exists anymore (It's been fixed in .19!). The rate of failure is down significantly, but it's still unacceptably high. I personally recompiled everything with mysql4 and it's been rock solid, but there's some talk that mysql < 5.0.15 may be OK too.
Comment by Paul Mattal (paul) - Wednesday, 01 March 2006, 05:37 GMT
I just reopened the following bug at Myth and poked ijr a little for silly behavior:

http://svn.mythtv.org/trac/ticket/946

Let's see what happens. I may go digging in the code myself one of these days, but it would be much easier to hear from people who know more first.
Comment by arjan timmerman (blaasvis) - Sunday, 26 March 2006, 11:21 GMT
is this fixed in 0.19 ?
Comment by Paul Mattal (paul) - Wednesday, 29 March 2006, 05:55 GMT
So the answer to this is that the myth guys deny this is a bug, claiming instead that you need to configure mysql properly. I think I come down somewhere in the middle, and would like to see them put a little effort into making things work easily for their users.

Can anyone confirm or deny that they've tried to "configure" around this problem in their mysql configuration files and either succeeded or failed?

Personally, I haven't noticed the problem, but I haven't had time to use Myth much lately.
Comment by Sasha (kleptophobiac) - Wednesday, 29 March 2006, 11:24 GMT
The problem has been fixed in current SVN. I've been test running myth for a week now with current mysql and things have been pretty solid.

It may be good to make a myth-0.19.01-1 using the 0.19-fixes SVN branch. That branch will probably solidify into a real 0.19.1 in a few weeks.
Comment by Paul Mattal (paul) - Wednesday, 29 March 2006, 13:37 GMT
Actually, I've been planning to switch back onto the fixes branch in general -- seems like there's rarely a downside to doing so, and we get the fixes much faster that way. I'll do that.
Comment by Paul Mattal (paul) - Wednesday, 05 April 2006, 13:15 GMT
Just as an update -- having a hard time compiling the newest svn fixes branch against the new kernel headers. Stay tuned as I/they work through this.
Comment by Sasha (kleptophobiac) - Wednesday, 05 April 2006, 21:15 GMT
Try disabling joystick support.
Comment by Paul Mattal (paul) - Sunday, 07 May 2006, 04:20 GMT
The joystick support was it, and so it's disabled until I can determine they've fixed it.

Does this fix all our timeout problems?

Loading...