action #19270
Caching seems to deadlock itself
Start date:
2017-05-19
Due date:
% Done:
0%
Estimated time:
Difficulty:
Description
multiple workers aren't picking up jobs and I believe this is related:
May 18 13:13:59 openqaworker3 worker[3738]: [DEBUG] CACHE: Waiting 5 seconds for the lock. May 18 13:13:59 openqaworker3 worker[3738]: [DEBUG] CACHE: Aquiring lock for /var/lib/openqa/cache/SLE-12-SP2-Server-DVD-x86_64-GM-DVD1.iso in the database May 18 13:15:23 openqaworker3 worker[3738]: DBD::SQLite::db selectrow_hashref failed: database is locked at /usr/share/openqa/script/../lib/OpenQA/Worker/Cache.pm line 217. May 18 13:15:23 openqaworker3 worker[3738]: rollback ineffective with AutoCommit enabled at /usr/share/openqa/script/../lib/OpenQA/Worker/Cache.pm line 236. May 18 13:15:23 openqaworker3 worker[3738]: Mojo::Reactor::Poll: Timer failed: Rolling back DBD::SQLite::db selectrow_hashref failed: database is locked at /usr/share/openq...pm line 217.
Related issues
History
Updated by #2
Updated by okurz about 5 years ago
Updated by M8?
#3
Updated by szarate about 5 years ago
- Target version changed from Milestone 7 to Milestone 8
This PR will solve the problem https://github.com/os-autoinst/openQA/pull/1353
#4
Updated by szarate almost 5 years ago
- Related to action #20396: Deploy cache might lock the worker under race conditions added
#5
Updated by szarate almost 5 years ago
- Status changed from In Progress to Resolved
I think it's safe to assume that this is resolved.