Defect #19344

MySQL 5.6: IssueNestedSetConcurrencyTest#test_concurrency : always fails

Added by Rupesh J almost 2 years ago. Updated almost 2 years ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Database
Target version:-
Resolution: Affected version:3.0.0

Description

Hello,

When I run rake test:units
I always get this test failure. Can you please correct this.

1) Failure:
IssueNestedSetConcurrencyTest#test_concurrency [E:/REDMINE/DEV3.0/redmine/test/unit/issue_nested_set_concurrency_test.rb:45]:
Expected "Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `issues`.`id` FROM `issues` WHERE (root_id IN (SEL
ECT root_id FROM issues WHERE id IN (390,388))) ORDER BY `issues`.`id` ASC FOR UPDATE" to be nil.

Redmine : 3.0.0
MySql : 5.6.14

Thanks.


Related issues

Related to Redmine - Feature #17460: MySQL 5.7 support New
Related to Redmine - Feature #19395: Support MariaDB New
Related to Redmine - Defect #6579: Tree hierachy being currupted on multiple submissions of ... Closed 2010-10-05
Related to Redmine - Defect #23318: #lock_nested_set very slow on mysql with thousands of sub... Reopened
Duplicated by Redmine - Defect #23942: Test: Mysql2::Error: Deadlock found when trying to get lock Closed

Associated revisions

Revision 14077
Added by Toshi MARUYAMA almost 2 years ago

add MariaDB 10.0 environment to travis (#17460, #19344)

Revision 14085
Added by Toshi MARUYAMA almost 2 years ago

add MySQL 5.6 and 5.7 environments to travis (#17460, #19344)

Revision 14128
Added by Toshi MARUYAMA almost 2 years ago

add MariaDB 5.5 environment to travis (#17460, #19344, #19395)

History

#1 Updated by Toshi MARUYAMA almost 2 years ago

  • Status changed from New to Needs feedback

I cannot reproduce on my Windows 8.1 Pro.

  • 5.5.40 - MySQL Community Server (GPL)
  • ruby 1.9.3p551 (2014-11-13) [i386-mingw32]
  • mysql2 (0.3.18-x86-mingw32)

#2 Updated by Toshi MARUYAMA almost 2 years ago

  • Category set to Database
  • Status changed from Needs feedback to New

#17460#note-7

it does not pass the issue concurrency test (dead locks) ...

#3 Updated by Toshi MARUYAMA almost 2 years ago

  • Subject changed from IssueNestedSetConcurrencyTest#test_concurrency : Always fails on standard redmine installation. to MySQL : 5.6: IssueNestedSetConcurrencyTest#test_concurrency : always fails

#4 Updated by Toshi MARUYAMA almost 2 years ago

  • Subject changed from MySQL : 5.6: IssueNestedSetConcurrencyTest#test_concurrency : always fails to MySQL 5.6: IssueNestedSetConcurrencyTest#test_concurrency : always fails

#5 Updated by Toshi MARUYAMA almost 2 years ago

#6 Updated by Toshi MARUYAMA almost 2 years ago

This test fails on MariaDB 5.5, too.

On my CentOS7:

$ rpm -q mariadb
mariadb-5.5.41-2.el7_0.x86_64

#7 Updated by Toshi MARUYAMA almost 2 years ago

#8 Updated by Toshi MARUYAMA 12 months ago

  • Related to Defect #6579: Tree hierachy being currupted on multiple submissions of an issue added

#9 Updated by Toshi MARUYAMA 5 months ago

  • Duplicated by Defect #23942: Test: Mysql2::Error: Deadlock found when trying to get lock added

#10 Updated by Toshi MARUYAMA 5 months ago

  • Related to Defect #23318: #lock_nested_set very slow on mysql with thousands of subtasks added

Also available in: Atom PDF