[mythtv] [mythtv-commits] Ticket #6683: mysql error with mythtv trunk (incorrect arguments to mysql_stmt_execute) Qt 4.5

[Nick Rosier]

2009/7/1 MythTV <mythtv at cvs.mythtv.org>:
> #6683: mysql error with mythtv trunk (incorrect arguments to mysql_stmt_execute)
> Qt 4.5
> ---------------------------------+------------------------------------------
>  Reporter:  nneul at neulinger.org  |       Owner:  ijr
>     Type:  defect               |      Status:  new
>  Priority:  major                |   Milestone:  unknown
> Component:  MythTV - General     |     Version:  head
>  Severity:  high                 |     Mlocked:  0
> ---------------------------------+------------------------------------------
>  Updated my mandriva-current box today and it broke mythbackend (and
>  probably frontend as well, but can't really tell that).
>
>  It's getting the following error when starting mythbackend. Database is
>  fine, selects against database are working properly (verified with a
>  mysqld query log). Tested with mysql server 5.0.83, and the 5.1.35
>  mandriva package. qt4-database-plugin-mysql is version 4.5.2, but same
>  symptom with 4.5.0 - couldn't easily downgrade further than that without
>  invasive rpm hell.
>
>  ----------------------------
>  2009-06-30 21:11:22.897 Connected to database 'myth' at host: localhost
>  2009-06-30 21:11:23.987 DataDirectProcessor::FixProgramIDs() -- begin
>  2009-06-30 21:11:27.603 New DB DataDirect connection
>  2009-06-30 21:11:27.603 Connected to database 'myth' at host: localhost
>  2009-06-30 21:11:29.547 DB Error (Clear setting):
>  Query was:
>  DELETE FROM settings WHERE value = ? AND hostname = ? ;
>  Bindings were:
>  :HOSTNAME=tv.home.neulinger.org, :KEY=MythFillFixProgramIDsHasRunOnce
>  Driver error was [2/1210]:
>  QMYSQL3: Unable to execute statement
>  Database error was:
>  Incorrect arguments to mysql_stmt_execute
>
>  2009-06-30 21:11:29.547 DB Error
>  (SaveSettingOnHost('MythFillFixProgramIDsHasRunOnce') - query failure: ):
>  Query was:
>  INSERT INTO settings (value,data,hostname) VALUES ( ?, ?, ? );
>  Bindings were:
>  :DATA=1, :HOSTNAME=tv.home.neulinger.org,
>  :VALUE=MythFillFixProgramIDsHasRunOnce
>  Driver error was [2/1210]:
>  QMYSQL3: Unable to execute statement
>  Database error was:
>  Incorrect arguments to mysql_stmt_execute
>
>  2009-06-30 21:11:29.548 DataDirectProcessor::FixProgramIDs() -- end
>  2009-06-30 21:11:29.549 Current Schema Version: 1235
>  No setting found for this machine's BackendServerIP.
>  Please run setup on this machine and modify the first page
>  of the general settings.
>  ----------------------
>
>  Attempting to run mythtv-setup gets hundreds of similar errors.
>
>  The failing queries ARE making it to mysqld (verified with an strace), but
>  the server is returning the error about incorrect arguments.
>
>  -----------
>  9381  read(24, "\26INSERT INTO settings (value,data,hostname) VALUES ( ?,
>  ?, ? );", 63) = 63
>  9381  gettimeofday({1246414523, 315521}, NULL) = 0
>  9381  sched_setparam(-1222444028, 0)    = -1 EINVAL (Invalid argument)
>  9381  write(24,
>  "\f\0\0\1\0\v\0\0\0\0\0\3\0\0\0\0\27\0\0\2\3def\0\0\0\1?\0\f?\0\0\0\0\0\375\200\0\0\0\0\27\0\0\3\3def\0\0\0\1?\0\f?\0\0\0\0\0\375\200\0\0\0\0\27\0\0\4\3def\0\0\0\1?\0\f?\0\0\0\0\0\375\200\0\0\0\0\5\0\0\5\376\0\0\2\0",
>  106) = 106
>  9381  sched_setparam(24, { 16777228 })  = -1 EINVAL (Invalid argument)
>  9381  gettimeofday({1246414523, 315882}, NULL) = 0
>  9381  read(24, "\5\0\0\0", 4)           = 4
>  9381  read(24, "\32\v\0\0\0", 5)        = 5
>  9381  gettimeofday({1246414523, 316044}, NULL) = 0
>  9381  write(24, "\7\0\0\1\0\0\0\2\0\0\0", 11) = 11
>  9381  gettimeofday({1246414523, 316187}, NULL) = 0
>  9381  read(24, "F\0\0\0", 4)            = 4
>  9381  read(24,
>  "\27\v\0\0\0\0\1\0\0\0\0\1\376\0\37MythFillFixProgramIDsHasRunOnce\0011\25tv.home.neulinger.org",
>  70) = 70
>  9381  gettimeofday({1246414523, 316380}, NULL) = 0
>  9381  write(24, "2\0\0\1\377\272\4#HY000Incorrect arguments to
>  mysql_stmt_execute", 54 <unfinished ...>
>  -------------------
>
>
>
>  This has my main mythtv box dead in the water at this time. Any
>  suggestions?

Had the same problem after compiling MySQL with gcc 4.4.1. Found this
bug: http://bugs.gentoo.org/show_bug.cgi?id=283926
Now re-compiling with 4.3.4 and hope that fixes it.