Bug #28006 | Falcon: isolation failed after alter | ||
---|---|---|---|
Submitted: | 21 Apr 2007 23:09 | Modified: | 17 Nov 2016 7:44 |
Reporter: | Peter Gulutzan | Email Updates: | |
Status: | Won't fix | Impact on me: | |
Category: | MySQL Server: Falcon storage engine | Severity: | S3 (Non-critical) |
Version: | 6.0.0-alpha-debug | OS: | Linux (SUSE 10 64-bit) |
Assigned to: | John Embretsen | CPU Architecture: | Any |
Tags: | F_ISOLATION |
[21 Apr 2007 23:09]
Peter Gulutzan
[23 Apr 2007 11:18]
MySQL Verification Team
Thank you for the bug report. Verified as described.
[22 Aug 2007 10:14]
Hakan Küçükyılmaz
Setting to Won't fix as this is a general problem. See also Bug#15491. Added test case falcon_bug_28006.test and pushed to 5.1-falcon tree.
[22 Aug 2007 10:16]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/32867 ChangeSet@1.2685, 2007-08-22 12:16:02+02:00, hakank@lu0011.wdf.sap.corp +3 -0 Added test for Bug #28006.
[26 Aug 2008 14:13]
John Embretsen
Attached Falcon test case for this issue. Will fail (result length mismatch) until this issue is fixed.
Attachment: falcon_bug_28006.test (application/octet-stream, text), 1.73 KiB.
[26 Aug 2008 14:15]
John Embretsen
Attached test result file corresponding to falcon_bug_28006.test. Test to be removed from source trees until issue is fixed.
Attachment: falcon_bug_28006.result (application/octet-stream, text), 661 bytes.
[31 Oct 2008 16:41]
Kevin Lewis
Similar to Bug#40460.
[10 Nov 2008 18:51]
Kevin Lewis
Assign to Kevin Lewis. This bug should be fixed by WL#4284. We will keep it open until that can be tested. See also Bug#40460
[12 May 2009 21:42]
Hakan Küçükyılmaz
The alter table t1 is now blocked, but not consistently in all cases. For details please see Bug#44836 DDL locking is not consistent
[20 May 2009 16:05]
Kevin Lewis
This needs to be tested again after Bug#44836 is fixed by the Server team. Hakan did not want to close the bug because of that inconsistency. Here are the results of Hakan's testing; Falcon InnoDB DROP TABLE blocked blocked TRUNCATE ERROR 1015 works without block DROP COLUMN ERROR 1015 blocked DROP INDEX ERROR 1015 blocked ADD COLUMN ERROR 1015 blocked ADD INDEX ERROR 1015 blocked Legend: ERROR 1015 (HY000): Can't lock file (errno: 212) DROP TABLE: DROP TABLE t1; TRUNCATE: TRUNCATE t1; DROP COLUMN: ALTER TABLE t1 DROP COLUMN b; DROP INDEX: ALTER TABLE t1 DROP PRIMARY KEY; ADD COLUMN: ALTER TABLE t1 ADD COLUMN c varchar(5); ADD INDEX: ALTER TABLE t1 ADD INDEX (b); Details: DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a int PRIMARY KEY, b varchar(5)) Engine Falcon; -- In another session with Falcon CREATE TABLE t1 (a int PRIMARY KEY, b varchar(5)) Engine InnoDB; INSERT INTO t1 VALUES (1, 'aaaaa'), (2, 'bbbbb'), (3, 'ccccc'); -- Connection 1 SET @@autocommit = 0; SELECT * FROM t1; -- Connection 2 SET @@autocommit = 0; -- Theses DML operations were tested in different sessions DROP TABLE t1; TRUNCATE t1; ALTER TABLE t1 DROP COLUMN b; ALTER TABLE t1 DROP PRIMARY KEY; ALTER TABLE t1 ADD COLUMN c varchar(5); ALTER TABLE t1 ADD INDEX (b); -- CONNECTION 1 SELECT * FROM t1; SELECT * FROM t1; COMMIT; SELECT * FROM t1; > 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
[4 Feb 2010 11:25]
John Embretsen
Bug#44836 is now closed as Duplicate/Fixed in mysql-next-4284 branch, to be merged into next-mr. No Falcon branch (old 6.0 server) is anywhere near compatibility with this branch, so I cannot test the fix against Falcon at this time.
[17 Nov 2016 7:44]
Erlend Dahl
The Falcon project was discontinued a long time ago.