MySQL Forums
Forum List  »  Newbie

Re: weird scenario after executing prepared statement
Posted by: Rick James
Date: May 19, 2014 10:29PM

Transactions. What is the value of autocommit? Are you using START TRANSACTION and COMMIT?

If a transaction is in progress (not yet committed), other processes cannot see the inserted/updated rows.

After a default of 50 seconds, a transaction will be ROLLBACK'd.

AUTO_INCREMENT numbers are taken but (with rare exceptions) never returned. So, 1001 may have been taken then thrown away by a ROLLBACK.

If this does not explain enough, please provide the SQL you used, plus value of autocommit.

Options: ReplyQuote


Subject
Written By
Posted
Re: weird scenario after executing prepared statement
May 19, 2014 10:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.