i am getting Can't find record in 'tablename' error. I am using MySql.
What is cause for this error?
As I know if we insert and delete from a table while selecting from the same table, We can get this error.
but what is my doubt is we also get 'lock wait time out exception'.
Actually In my application while running the code related to insert and delete on xxx table, another member clicks on some service which also related to this xxx table for selection from this xxx table.
that is my scenario.
but what my doubt is, for the same scenario i can get lock wait timeout exception.But y I got this Exception?
My application is running since one and half year in live but this is the first time I got this exception.