Defect #19344
MySQL 5.6: IssueNestedSetConcurrencyTest#test_concurrency : always fails
Status: | New | Start date: | ||
---|---|---|---|---|
Priority: | Normal | Due 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
Associated revisions
History
#1
Updated by Toshi MARUYAMA about 6 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 about 6 years ago
- Category set to Database
- Status changed from Needs feedback to New
it does not pass the issue concurrency test (dead locks) ...
#3
Updated by Toshi MARUYAMA about 6 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 about 6 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 about 6 years ago
- Related to Feature #17460: MySQL 5.7 support added
#6
Updated by Toshi MARUYAMA about 6 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 about 6 years ago
- Related to Feature #19395: Support MariaDB added
#8
Updated by Toshi MARUYAMA about 5 years ago
- Related to Defect #6579: Tree hierachy being currupted on multiple submissions of an issue added
#9
Updated by Toshi MARUYAMA over 4 years ago
- Duplicated by Defect #23942: Test: Mysql2::Error: Deadlock found when trying to get lock added
#10
Updated by Toshi MARUYAMA over 4 years ago
- Related to Defect #23318: #lock_nested_set very slow on mysql with thousands of subtasks added