Bug #28551: sqlite db migration fails with Cannot add a NOT NULL column with default value NULL: - Katello - Foreman

Actions

Copy link

Bug #28551

closed

sqlite db migration fails with Cannot add a NOT NULL column with default value NULL:

Added by Justin Sherrill about 5 years ago. Updated almost 5 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Justin Sherrill

Category:

Target version:

Katello 3.15.0

Difficulty:

Triaged:

Yes

Bugzilla link:

Pull request:

https://github.com/Katello/katello/pull/8483

Fixed in Releases:

Katello 3.15.0

Found in Releases:

Red Hat JIRA:

Description

StandardError: An error has occurred, this and all later migrations canceled:
SQLite3::SQLException: Cannot add a NOT NULL column with default value NULL: ALTER TABLE "katello_distribution_references" ADD "repository_id" integer NOT NULL
/opt/theforeman/tfm-ror52/root/usr/share/gems/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:91:in `initialize'
/opt/theforeman/tfm-ror52/root/usr/share/gems/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:91:in `new'
/opt/theforeman/tfm-ror52/root/usr/share/gems/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:91:in `prepare'
/opt/theforeman/tfm-ror52/root/usr/share/gems/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:137:in `execute'
/opt/theforeman/tfm-ror52/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-ror52/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-ror52/root/usr/share/gems/gems/activesupport-5.2.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/opt/theforeman/tfm-ror52/root/usr/share/gems/gems/activesupport-5.2.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/opt/theforeman/tfm-ror52/root/usr/share/gems/gems/activerecord-5.2.1/lib/active_record/connection_adapters/sqlite3_adapter.rb:254:in `block in execute'
/opt/theforeman/tfm-ror52/root/usr/share/gems/gems/activerecord-5.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:579:in `block (2 levels) in log'
/opt/rh/rh-ruby25/root/usr/share/ruby/monitor.rb:226:in `mon_synchronize'