On Di, 2009-05-12 at 22:39 +0200, Hakan Kuecuekyilmaz wrote:
> On Di, 2009-05-12 at 16:13 -0400, Ann W. Harrison wrote:
> > Hi Hakan,
> >
> > Your explanation was just a bit terse. What happened in Connection 1
> > after the DDL operation but before the commit? After the commit?
> >
>
> What happened in case of Falcon and InnoDB in Connection 1 after
> Connection 2's DDL but before the commit?
>
> A: The SELECT * t1 worked as expected
>
> After the commit?
>
> A: The SELECT * t1 worked as expected
>
>
> For Falcon strange things are happening. In my last email I got
> ERROR 1015 (HY000): Can't lock file (errno: 212)
>
> This time I get:
> [22:33] root@test>SELECT * FROM t1;
> ERROR 1213 (40001): Deadlock found when trying to get lock; try
> restarting transaction
>
> This means, that I have to do some further testing ...
The strange behavior is now documented as
http://bugs.mysql.com/bug.php?id=44836 DDL locking is not consistent
--
Hakan Küçükyılmaz, Senior Software Engineer DBTG/MySQL +49 160
98953296
Sun Microsystems GmbH Sonnenallee 1, DE-85551 Kirchheim-Heimstetten
Geschaeftsfuehrer: Thomas Schroeder, Wolfang Engels, Dr. Roland Boemer
Vorsitz d. Aufs.rat.: Martin Haering HRB MUC 161028 49.011, 8.376
