mysql 4.1 rollback ?

[ulefr01]

i have installed mysql-server-4.1.8a-4 and
mysql-client-4.1.8a-4 on Linux 2.6.9
mysql is working correctly;
the rollback is not working :

mysql> insert into tran_test (a,b) values (1,2);
Query OK, 1 row affected (0.01 sec)

mysql> select * from tran_test;
+------+------+
| a | b |
+------+------+
| 1 | 2 |
+------+------+
1 row in set (0.00 sec)

mysql> rollback;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> select * from tran_test;
+------+------+
| a | b |
+------+------+
| 1 | 2 |
+------+------+
1 row in set (0.00 sec)

mysql> quit
Normally after the rollback i should get here an empty table !
The AUTOCOMMIT is set off (SET AUTOCOMMIT = 0).
Any idea ?

 

[ulefr01]

I am missing the create table statement;
Attached the complete output:
mysql> use test;
Database changed
mysql> set autocommit = 0;
Query OK, 0 rows affected (0.00 sec)
mysql> create table tran_test (a int, b int) type = InnoDB;
Query OK, 0 rows affected, 2 warnings (0.04 sec)
mysql> begin;
Query OK, 0 rows affected (0.00 sec)
mysql> insert into tran_test (a,b) values (1,2);
Query OK, 1 row affected (0.00 sec)
mysql> select * from tran_test;
+------+------+
| a | b |
+------+------+
| 1 | 2 |
+------+------+
1 row in set (0.00 sec)
mysql> rollback;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> select * from tran_test;
+------+------+
| a | b |
+------+------+
| 1 | 2 |
+------+------+
1 row in set (0.00 sec)
mysql> quit

the Rollback seems to be OK but there is 1 warning , what does it means ?
Normally i should have an empty table but i haven't, any idea ?

 

[ericbrunson]

Is your table using the InnoDB storage engine?

 

[ulefr01]

See the create table statement :
create table tran_test (a int, b int) type = InnoDB;

i use InnoDB

 

[ericbrunson]

Oops, sorry, missed that.

 

[ericbrunson]

Rollback isn't working in my installation, either. It does from python and PHP, so I'm confused, too.

 

[ulefr01]

This must be a bug.

 

[ulefr01]

If i do exactly likes what is mention in section 15.7.1 page 807 of the MySQL Reference Manual 5.0.3-Alpha i get :
mysql> use test
Database changed
mysql> create table customer (a int, b char(20), index (a)) type=InnoDB;
Query OK, 0 rows affected, 2 warnings (0.05 sec)

mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into customer values (10, 'Heikki');
Query OK, 1 row affected (0.03 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

mysql> set autocommit=0;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into customer values (15, 'John');
Query OK, 1 row affected (0.02 sec)

mysql> rollback;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> select * from customer;
+------+--------+
| a | b |
+------+--------+
| 10 | Heikki |
| 15 | John |
+------+--------+
2 rows in set (0.00 sec)

mysql> quit

This is not what is mention in the manual ; the entry "15, John" may not occur after the ROLLBACK !

 

[ulefr01]

problem is solved now.
My my.cnf file contains the entry "skip-innodb"
If i adapt this file and put this entry in comment.
Restart mysqld
Redo test
It works now