[mythtv] mysql 5 bug affecting mythtv

[Rob Smith]

On Jan 26, 2008 10:19 AM, Keith Pyle <kpyle at austin.rr.com> wrote:
> The crashes are during mythfilldatabase runs and always seem to be on
> the following SQL command:
>
> INSERT IGNORE INTO credits (chanid, starttime, person, role) SELECT dd_v_program.chanid,
> DATE_ADD(starttime, INTERVAL channel.tmoffset MINUTE), person, role FROM
> dd_productioncrew, dd_v_program, channel, people WHERE ((dd_productioncrew.programid =
> dd_v_program.programid) AND (dd_productioncrew.fullname = people.name)) AND
> dd_v_program.chanid = channel.chanid

Can you drop all the indexes on credits and see if you still have the
same problem? If not, re-add them and see?