Project

General

Profile

Actions

action #19270

closed

Caching seems to deadlock itself

Added by coolo almost 7 years ago. Updated almost 7 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
-
Category:
Regressions/Crashes
Target version:
Start date:
2017-05-19
Due date:
% Done:

0%

Estimated time:

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 1 (0 open1 closed)

Related to openQA Project - action #20396: Deploy cache might lock the worker under race conditionsResolved2017-07-05

Actions
Actions #1

Updated by szarate almost 7 years ago

  • Status changed from New to In Progress

I'm taking on this.

Actions #2

Updated by okurz almost 7 years ago

M8?

Actions #3

Updated by szarate almost 7 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

Actions #4

Updated by szarate almost 7 years ago

  • Related to action #20396: Deploy cache might lock the worker under race conditions added
Actions #5

Updated by szarate almost 7 years ago

  • Status changed from In Progress to Resolved

I think it's safe to assume that this is resolved.

Actions

Also available in: Atom PDF