Project

General

Profile

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'
Actions
Copy link

Also available in: Atom PDF