| Summary: | mythfilldatabase fails with SQL error | ||
|---|---|---|---|
| Product: | Fedora | Reporter: | Rodd Clarkson <rodd> |
| Component: | mythtv | Assignee: | Jarod Wilson <jarod> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | ||
| Priority: | P5 | ||
| Version: | 14 | ||
| Hardware: | All | ||
| OS: | GNU/Linux | ||
| namespace: | |||
|
Description
Rodd Clarkson
2009-03-08 05:23:18 CET
Yeah, just hit this one myself Thursday or Friday, looking into it... I did a little more digging and it's apparently a combination of creating a new database (it won't happen if you already have a database), mysql-5.1.x, qt-4.4.x and mythtv-0.22.x.
The key is this part:
> Database error was:
> This command is not supported in the prepared statement protocol yet
Apparently, mythtv never uses prepared statements (although is does ask for the ALTER DATABASE, but not in any 'prepared statement' sense) and something (probably qt, but not confirmed) is middle managing the sql requests and trying to use a prepared statement instead.
j-rod (maybe j-rod and jarod have something in common) at mythtv is apparently trying to figure this out.
We should keep this bug open until it's been fixed up stream, and it may be that there's a bug to track upstream, but I'm not sure what, and whether bugzilla can do that.
(In reply to comment #2) > I did a little more digging and it's apparently a combination of creating a new > database (it won't happen if you already have a database), mysql-5.1.x, > qt-4.4.x and mythtv-0.22.x. > > The key is this part: > > > Database error was: > > This command is not supported in the prepared statement protocol yet Yep, I know. :) > j-rod (maybe j-rod and jarod have something in common) at mythtv is apparently > trying to figure this out. He is I and I am him. > We should keep this bug open until it's been fixed up stream, and it may be > that there's a bug to track upstream, but I'm not sure what, and whether > bugzilla can do that. Yeah, I'm working on it w/some other mythtv folks, we'll track down who the bug actually belongs to and get it fixed for everyone. jarod (errr, j-rod), it's nice to know someone is looking into this and I wish you all the best. Is there anyway I can get a skeleton database to use so that I (and others) can work around this until it's resolved? (In reply to comment #4) > jarod (errr, j-rod), it's nice to know someone is looking into this and I wish > you all the best. We're onto something -- it seems its actually a bug in qt 4.5.0, not in mythtv. qt's mysql bindings in 4.5.0 are trying to run every single query as a prepared statement when many are destined to fail, per http://dev.mysql.com/doc/refman/5.1/en/c-api-prepared-statements.html, which lists what types of queries are actually supported as prepared statements (note the lack of 'alter database ...'). Mike Dean has a patch for qt that would sort of brute-force around it, but is going to file a ticket upstream, where they might hopefully come up with a better patch. > Is there anyway I can get a skeleton database to use so that I (and others) can > work around this until it's resolved? Yeah, there are a few ways you could go about getting a db... Could maybe take an F10 install and do the initial database population there, then move it to rawhide, or comb through mythtv/libs/libmythtv/dbcheck.cpp, scraping out all the sql statements, dropping them into a .sql file and importing them that way. Both would likely require some slight munging to get variable parts of the data correct (which mythtv normally does for you). With luck, we'll have a fix sooner than later though. Upstream bug filed here: http://www.qtsoftware.com/developer/task-tracker/index_html?method=entry&id=248078 However, a work-around has also been committed to mythtv. I'll try to get a new build together later today... New build w/the work-around in-progress: http://buildsys.rpmfusion.org/build-status/job.psp?uid=3008 Nggh. Build failed for reasons that are non-reproduceable building locally on an x86_64 rawhide box (at least outside of mock, still need to try inside mock). Any luck with the build. I'm guessing no at this stage, but I thought I'd check in since it's been a while. Finally had a build actually finish today, woo! This works for me now, clean rawhide install + mythtv-0.22-0.2.svn.r20293.fc11 |