Project

General

Profile

Bug #29549

Database migration fails on SQLite

Added by Eric Helms 6 months ago. Updated 6 months ago.

Status:
Closed
Priority:
Normal
Category:
-
Target version:
Difficulty:
Triaged:
Yes
Bugzilla link:

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'

Associated revisions

Revision fc1dbc74 (diff)
Added by Justin Sherrill 6 months ago

Fixes #29549 - skip docker tag combining if none exist

History

#1 Updated by The Foreman Bot 6 months ago

  • Assignee set to Justin Sherrill
  • Status changed from New to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/8663 added

#2 Updated by The Foreman Bot 6 months ago

  • Fixed in Releases added

#3 Updated by Justin Sherrill 6 months ago

  • Status changed from Ready For Testing to Closed

#4 Updated by The Foreman Bot 6 months ago

  • Pull request https://github.com/Katello/katello/pull/8672 added

#5 Updated by Jonathon Turel 6 months ago

  • Triaged changed from No to Yes
  • Target version set to Katello 3.16.0
  • Fixed in Releases Katello 3.16.0 added
  • Fixed in Releases deleted ()

Also available in: Atom PDF