Project

General

Profile

Actions
Copy link

action #39776

closed

Mojo::Reactor::Poll: I/O watcher failed: DBD::SQLite::db do failed: table "assets" already exists error should be recoverable

Added by szarate over 6 years ago. Updated about 6 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
EDiGiacinto
Category:
Regressions/Crashes
Target version:
Done
Start date:
2018-08-15
Due date:
% Done:

0%

Estimated time:

Description

Currently when starting multiple worker instances at the same time, there's a high possibility of this happening: which is and should be a non fatal error, and the worker should be able to recover itself. 

Aug 15 14:17:17 openqaworker1 worker[12410]: DBD::SQLite::db do failed: table "assets" already exists at /usr/share/openqa/script/../lib/OpenQA/Worker/Cache.pm line 64, <DATA> chunk 1.                                                    
Aug 15 14:17:17 openqaworker1 worker[12340]: DBD::SQLite::db do failed: table "assets" already exists at /usr/share/openqa/script/../lib/OpenQA/Worker/Cache.pm line 64, <DATA> chunk 1.                                                     Aug 15 14:17:17 openqaworker1 worker[12340]: Issuing rollback() due to DESTROY without explicit disconnect() of DBD::SQLite::db handle dbname=/var/lib/openqa/cache/cache.sqlite at /usr/lib/perl5/vendor_perl/5.18.2/Mojo/Reactor/Poll.pm li
ne 143, <DATA> chunk 1.                                                                                                                                                                                                                      Aug 15 14:17:17 openqaworker1 worker[12410]: Issuing rollback() due to DESTROY without explicit disconnect() of DBD::SQLite::db handle dbname=/var/lib/openqa/cache/cache.sqlite at /usr/lib/perl5/vendor_perl/5.18.2/Mojo/Reactor/Poll.pm li
ne 143, <DATA> chunk 1.                                                                                                                                                                                                                     
Aug 15 14:17:17 openqaworker1 worker[12410]: Mojo::Reactor::Poll: I/O watcher failed: DBD::SQLite::db do failed: table "assets" already exists at /usr/share/openqa/script/../lib/OpenQA/Worker/Cache.pm line 64, <DATA> chunk 1.           
Aug 15 14:17:17 openqaworker1 worker[12340]: Mojo::Reactor::Poll: I/O watcher failed: DBD::SQLite::db do failed: table "assets" already exists at /usr/share/openqa/script/../lib/OpenQA/Worker/Cache.pm line 64, <DATA> chunk 1.           
Aug 15 14:17:17 openqaworker1 worker[12326]: DBD::SQLite::db do failed: table "assets" already exists at /usr/share/openqa/script/../lib/OpenQA/Worker/Cache.pm line 64, <DATA> chunk 1.                                                     Aug 15 14:17:17 openqaworker1 worker[12326]: Issuing rollback() due to DESTROY without explicit disconnect() of DBD::SQLite::db handle dbname=/var/lib/openqa/cache/cache.sqlite at /usr/lib/perl5/vendor_perl/5.18.2/Mojo/Reactor/Poll.pm li
ne 143, <DATA> chunk 1.                                                                                                                                                                                                                     
Aug 15 14:17:17 openqaworker1 worker[12326]: Mojo::Reactor::Poll: I/O watcher failed: DBD::SQLite::db do failed: table "assets" already exists at /usr/share/openqa/script/../lib/OpenQA/Worker/Cache.pm line 64, <DATA> chunk 1.
Actions
Copy link
 #1

Updated by coolo about 6 years ago

  • Category set to Regressions/Crashes
  • Status changed from New to In Progress
  • Assignee set to EDiGiacinto
  • Target version set to Current Sprint

part of the worker story being worked on

Actions
Copy link
 #2

Updated by EDiGiacinto about 6 years ago

  • Status changed from In Progress to Feedback

https://github.com/os-autoinst/openQA/pull/1783 has been merged, setting to Feedback. This should not happen anymore, since the DB deploy will be performed from the service.

Actions
Copy link
 #3

Updated by coolo about 6 years ago

  • Status changed from Feedback to Resolved
  • Target version changed from Current Sprint to Done
Actions
Copy link

Also available in: Atom PDF