OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: rollback error

From: Victoria Reznichenko (victoria.reznichenkoensita.net)
Date: Fri Nov 14 2003 - 09:54:27 CST

Fernando <proyectolsdwanadoo.es> wrote:
>
> In version 3.23.57 when i do a rollback i get this error message and the changes are not undone, why?
>
> This is what i typed: (NOTE: 'insert.sql' insert a row correctly in an InnoDB table)
>
> mysql> SET AUTOCOMMIT=0;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> BEGIN;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> \. /home/fernando/scripts/insert.sql
> Query OK, 1 row affected (0.00 sec)
>
> mysql> ROLLBACK;
> ERROR 1196: Warning: Some non-transactional changed tables couldn't be rolled back

Provide output of the SHOW CREATE TABLE command.

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __ ___ ___ ____ __
  / |/ /_ __/ __/ __ \/ / Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenkoensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
       <___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql