Hello,
I had written last week because I tried to send a mail to
[EMAIL PROTECTED] about MySQL transactions without success.
[EMAIL PROTECTED] answered me, but I can't send a mail to him.
Using "set autocommit=0;" doesn't fix the problem...
My problem was :
We have 2 threads using sql instruction BEGIN-COMMIT/ROLLBACK (with
Berkeley-db). There is a
conflict if we make this schema:
THREAD 1 | THREAD 2
|
begin; |
| begin;
select * from table; |
| 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)?
What is the difference between :
begin;
....
commit;
and :
set autocommit=0;
....
set autocommit=1;
Thank you for your support.
ChristopheDEMANGE
GAEL Consultant
Cité Descartes
18, rue Albert Einstein
77420 Champs-sur-Marne
France Project Manager
mailto:[EMAIL PROTECTED]
http://www.gael.fr
tel +33-(0)1 64 73 99 55
fax +33-(0)1 64 73 51 60
---------------------------------------------------------------------
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
