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

Also available in: Atom PDF