Bug #29549: Database migration fails on SQLite - Katello - Foreman

Actions

Copy link

Bug #29549

closed

Database migration fails on SQLite

Added by Eric Helms almost 5 years ago. Updated almost 5 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Justin Sherrill

Category:

Target version:

Katello 3.16.0

Difficulty:

Triaged:

Yes

Bugzilla link:

Pull request:

https://github.com/Katello/katello/pull/8663, https://github.com/Katello/katello/pull/8672

Fixed in Releases:

Katello 3.16.0

Found in Releases:

Red Hat JIRA:

Description

StandardError: An error has occurred, this and all later migrations canceled:
SQLite3::SQLException: near "T1": syntax error: DELETE FROM katello_repository_docker_meta_tags T1
              USING   katello_repository_docker_meta_tags T2
              WHERE   T1.ctid < T2.ctid
              AND T1.repository_id  = T2.repository_id
              AND T1.docker_meta_tag_id = T2.docker_meta_tag_id;
/opt/theforeman/tfm/root/usr/share/gems/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:91:in `initialize'
/opt/theforeman/tfm/root/usr/share/gems/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:91:in `new'
/opt/theforeman/tfm/root/usr/share/gems/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:91:in `prepare'
/opt/theforeman/tfm/root/usr/share/gems/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:137:in `execute'
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-5.2.1/lib/active_record/connection_adapters/sqlite3_adapter.rb:255:in `block (2 levels) in execute'
/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-5.2.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-5.2.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-5.2.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'