action #39776

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

Added by szarate over 1 year ago. Updated about 1 year ago.

Status:ResolvedStart date:15/08/2018
Priority:NormalDue date:
Assignee:EDiGiacinto% Done:

0%

Category:Concrete Bugs
Target version:Done
Difficulty:
Duration:

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.

History

#1 Updated by coolo over 1 year ago

  • Category set to Concrete Bugs
  • 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

#2 Updated by EDiGiacinto over 1 year 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.

#3 Updated by coolo about 1 year ago

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

Also available in: Atom PDF