Murugavel wrote:
Dear Mr. Venu & Tech Group,
We are facing few problem in mysql database.
Take an eg.
we have table called bb_usersession0
user A is trying to delete a record which is having the billingstatus B .
User A
delete from bb_usersession0 where ui_sessionid='cs_venkatesh0006A46C' AND us_billingstaus='B' User B update bb_usersession0 set us_billingstatus='Y' where us_billingstatus='N';
In the above case mYSQL IS LOCKING THE whole table so the USER B is not able to update the status.In user session B we are getting the followin message ERROR 1205: Lock wait timeout exceeded; Try restarting transaction
Kindly give me solution for the above problem.
Awaiting your reply
Regards velu
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
