Getting Deadlock error while uploading test results from trcli with junit(Deadlock found when trying to get lock; try restarting transaction)

[ashishs2424]

TestRail CLI Version

v1.9.5

CLI Environment

Windows 11 ,Ubuntu 20.04 ,Ubuntu 22.04

TestRail Version

8.0.4 Default (7036)

TestRail Instance Type

Professional Cloud

Current behavior

Steps:-- trcli -y \ -h "https://lantronix.testrail.io" \ -u "[email protected]" \ -p "abc@xyz" \ --project "Automation Projects" \ parse_junit \ --case-fields "custom_version:1" \ --case-fields "custom_automation_type:1" \ --title "Testrun" \ --run-description "CI Build:${URL}" \ -f "./junit-report.xml"

Actual Results:- Parsing JUnit report. Processed 410 test cases in section pytest. Checking project. Done. Found 218 test cases not matching any TestRail case. Adding missing test cases to the suite. Adding test cases: 5/218 Error during add_case. Trying to cancel scheduled tasks. Aborting: add_case. Trying to cancel scheduled tasks. Adding test cases: 6/218 Deadlock found when trying to get lock; try restarting transaction Deleted created test cases

Desired behavior

Parsing JUnit report. Processed 410 test cases in section pytest. Checking project. Done. Adding results: 1/218 Adding results: 2/218 Adding results: 3/218, Done. Adding results: 4/218, Done. No attachments found to upload. Submitted 218 test results in 443.7 secs.

More Details

No response

[acuanico-tr-galt]

HI @ashishs2424 have you tried exploring the multithreading feature in trcli? Thank you.

[ashishs2424]

@acuanico-tr-galt yes we tried but getting failed .
For example we have test plan with 1000 test cases and xml has only 700 so if there is no test automation ids it is getting failed .
It should ignore the cases which doesn't have automation ids but its getting deadlock error.