Bug #43002 maria.maria_notembedded fails sporadically

• Submitted: 19 Feb 2009 7:39
• Modified: 4 Jul 2013 13:10
• Reporter: Alexander Nozdrin
• Status: Won't fix
• Category: MySQL Server: Maria storage engine
• Severity: S3 (Non-critical)
• Version: 6.0-TRUNK
• OS: Any
• CPU Architecture: Any
• Tags: pushbuild, sporadic, test failure

[19 Feb 2009 7:39] Alexander Nozdrin

Description:
Symptoms:
-----------------------------------------------------------
CURRENT_TEST: maria.maria_notembedded
mysqltest: At line 81: query 'reap' failed with wrong errno 1213: 'Deadlock found when trying to get lock; try restarting transaction', instead of 1062...

The result from queries just before the failure was:
< snip >
insert t1 values (2);
lock table t1 write concurrent;
insert t1 values (3);
insert t1 values (2);
lock table t1 write concurrent;
insert t1 values (4);
insert t1 values (3);
lock table t1 write concurrent;
insert t1 values (5);
insert t1 values (4);
lock table t1 write concurrent;
insert t1 values (6);
insert t1 values (5);
insert t1 values (6);
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
unlock tables;
ERROR 23000: Duplicate entry '2' for key 'a'
unlock tables;
ERROR 23000: Duplicate entry '3' for key 'a'
unlock tables;
-----------------------------------------------------------

Reported after a failure on 2009-02-17 in 6.0
(http://tinyurl.com/cyewmr)

How to repeat:
XRef: http://tinyurl.com/bzhps9

[4 Jul 2013 13:10] Dmitry Lenev

Hello!

We have decided that is not feasible to fix this issue. Hence I am closing this bug report as "Won't fix".