Hello, bon jour try first with
setAutoCommit off then TRANSACTION Begin COMMIT OR ROLLBACK setAutoCommit ON younes Heidi DIAS wrote: > > Hello, > > Excuse me for my English, but I am French. > > I am studing MySQL and particularly replications. > When we have 2 threads which use BEGIN-COMMIT/ROLLBACK (with > Berkeley-db), there is a conflict if we make this schema: > > THREAD 1 ! THREAD 2 > ! > begin; ! > ! begin; > ! delete from table where id=4; > update table... ! > > An error comes on thread 1: > ERROR 1030: Got error -30996 from table handler > > What does it mean? > What can we do to lock table at the first BEGIN and not at the first > update or delete? > (We want that thread 1 locks table at the begin to avoid the error)? > > Thanks a lot, and have a good day. > -- > HeidiDIAS > ------------------------------------------ > GAEL Consultant Software > Engineer > Cité Descartes > 18, rue Albert Einstein > 77420 Champs-sur-Marne > France > mailto:[EMAIL PROTECTED] > > http://www.gael.fr > > --------------------------------------------------------------------- > 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