Lock wait timeout exceeded; try restarting transaction

[Richard]

Hello all,
I am getting this error "Lock wait timeout exceeded; try restarting transaction". When I get this error I am doing an INSERT into SELECT update.The update is into a MyISAM table with no activity and the select comes from joins of several Innodb tables. This is on a 5.1.22-rc server that is running as a replicated slave doing row based replication. At the time of the error the table is being updated through replication. Is there a way to avoid these errors by altering the "transaction_isolation" variable? It is currently set as "REPEATABLE-READ". I thought that with the REPEATABLE-READ the table(s) being SELECTed from would be versioned until the transaction making the changes to the Innodb tables completed. Hence, no lock timeouts. I am wrong, I just do not know why. Any help or pointers would be great.

Thanks,
Richard