MySQL Forums
Forum List  »  NDB clusters

Can't get START TRANSACTION/COMMIT to work
Posted by: Patrick Chun
Date: June 08, 2005 04:21PM

I am using MySQL 4.1.12 with the NDB engine for clustering. I tried using the START TRANSACTION / COMMIT to insert into my database:

START TRANSACTION;

various INSERTs into tables...

COMMIT;

In order to simulate an application or OS crash, I intentionally made sure that one of the INSERTs will fail. I was hoping to see that none of the modifications within the above START TRANSACTION / COMMIT are done to my tables, however, I found that some of the tables ARE changed!

I have used the same kind of statements with Postgres and they had worked for 5 years.

In my.cnf, I have nothing much in it:
[mysqld]
skip-innodb
skip-bdb
skip-isam

skip-grant-tables
skip-name-resolve
skip-host-cache

sql-mode=ANSI

ndbcluster
default-table-type=NDBCLUSTER
ndb-connectstring=localhost
---------------------end my.cnf file --------------

Any suggestions would be greatly appreciated.

Thanks,
Patrick

Options: ReplyQuote


Subject
Views
Written By
Posted
Can't get START TRANSACTION/COMMIT to work
3070
June 08, 2005 04:21PM


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.