[katello-devel] Upgrade error during reindex

[Tom McKay]

----- Original Message -----
> From: "Lukas Zapletal" <lzap at redhat.com>
> To: katello-devel at redhat.com
> Sent: Tuesday, December 11, 2012 9:16:28 AM
> Subject: [katello-devel] Upgrade error during reindex
> 
> Hello,
> 
> I have a BZ
> 
> https://bugzilla.redhat.com/show_bug.cgi?id=885261
> 
> with error during upgrade:
> 
> ** Invoke db:migrate (first_time)
> ** Invoke environment (first_time)
> ** Execute environment
> ** Execute db:migrate
> ** Invoke db:schema:dump (first_time)
> ** Invoke environment
> ** Execute db:schema:dump
> ** Invoke reindex (first_time)
> ** Invoke environment (first_time)
> ** Execute environment
> ** Invoke clear_search_indices (first_time)
> ** Execute clear_search_indices
> ** Execute reindex
> rake aborted!
> Couldn't find Organization with ID=3
> /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/relation/finder_methods.rb:304:in
> `find_one'
> /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/relation/finder_methods.rb:289:in
> `find_with_ids'
> /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/relation/finder_methods.rb:107:in
> `find'
> /usr/share/katello/app/models/provider.rb:112:in `organization'
> /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/associations/association_proxy.rb:222:in
> `send'
> /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/associations/association_proxy.rb:222:in
> `method_missing'
> /usr/share/katello/app/models/product.rb:105:in `organization'
> /usr/share/katello/app/models/product.rb:78:in `extended_index_attrs'
> /usr/share/katello/app/models/indexed_model.rb:140:in `send'
> /usr/share/katello/app/models/indexed_model.rb:140:in
> `to_indexed_json'
> /usr/lib/ruby/gems/1.8/gems/tire-0.3.12/lib/tire/index.rb:296:in
> `convert_document_to_json'
> /usr/lib/ruby/gems/1.8/gems/tire-0.3.12/lib/tire/index.rb:76:in
> `bulk_store'
> /usr/lib/ruby/gems/1.8/gems/tire-0.3.12/lib/tire/index.rb:68:in `map'
> /usr/lib/ruby/gems/1.8/gems/tire-0.3.12/lib/tire/index.rb:68:in
> `bulk_store'
> /usr/lib/ruby/gems/1.8/gems/tire-0.3.12/lib/tire/index.rb:118:in
> `import'
> /usr/share/katello/lib/tasks/reindex.rake:11
> /usr/share/katello/lib/tasks/reindex.rake:8:in `each'
> /usr/share/katello/lib/tasks/reindex.rake:8
> /usr/lib/ruby/gems/1.8/gems/rake-0.9.2/lib/rake/task.rb:205:in `call'
> /usr/lib/ruby/gems/1.8/gems/rake-0.9.2/lib/rake/task.rb:205:in
> `execute'
> /usr/lib/ruby/gems/1.8/gems/rake-0.9.2/lib/rake/task.rb:200:in `each'
> /usr/lib/ruby/gems/1.8/gems/rake-0.9.2/lib/rake/task.rb:200:in
> `execute'
> /usr/lib/ruby/gems/1.8/gems/rake-0.9.2/lib/rake/task.rb:158:in
> `invoke_with_call_chain'
> /usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
> /usr/lib/ruby/gems/1.8/gems/rake-0.9.2/lib/rake/task.rb:151:in
> `invoke_with_call_chain'
> /usr/lib/ruby/gems/1.8/gems/rake-0.9.2/lib/rake/task.rb:144:in
> `invoke'
> /usr/lib/ruby/gems/1.8/gems/rake-0.9.2/lib/rake/application.rb:112:in
> `invoke_task'
> /usr/lib/ruby/gems/1.8/gems/rake-0.9.2/lib/rake/application.rb:90:in
> `top_level'
> /usr/lib/ruby/gems/1.8/gems/rake-0.9.2/lib/rake/application.rb:90:in
> `each'
> /usr/lib/ruby/gems/1.8/gems/rake-0.9.2/lib/rake/application.rb:90:in
> `top_level'
> /usr/lib/ruby/gems/1.8/gems/rake-0.9.2/lib/rake/application.rb:129:in
> `standard_exception_handling'
> /usr/lib/ruby/gems/1.8/gems/rake-0.9.2/lib/rake/application.rb:84:in
> `top_level'
> /usr/lib/ruby/gems/1.8/gems/rake-0.9.2/lib/rake/application.rb:62:in
> `run'
> /usr/lib/ruby/gems/1.8/gems/rake-0.9.2/lib/rake/application.rb:129:in
> `standard_exception_handling'
> /usr/lib/ruby/gems/1.8/gems/rake-0.9.2/lib/rake/application.rb:59:in
> `run'
> /usr/lib/ruby/gems/1.8/gems/rake-0.9.2/bin/rake:32
> /usr/bin/rake:19:in `load'
> /usr/bin/rake:19
> Tasks: TOP => reindex
> Search Indices cleared.
> Re-indexing ActivationKey
> Re-indexing Changeset
> Re-indexing DeletionChangeset
> Re-indexing Filter
> Re-indexing GpgKey
> Re-indexing Job
> Re-indexing MarketingProduct
> 
> Reporter said there were several manifest imports that failed. Is
> there
> any known error that would leave database in inconsistent state?
> 
> 
> Also, I think we are indexing both MarketingProduct and Product which
> is
> not necessary, I guess. Any opinions about that?
> 
> LZ
> 
> --
> Later,
> 
>  Lukas "lzap" Zapletal
>  #katello #systemengine
> 
> _______________________________________________
> katello-devel mailing list
> katello-devel at redhat.com
> https://www.redhat.com/mailman/listinfo/katello-devel
> 

The indexing is failing because there are orphan "Red Hat" providers without an organization. My guess was that deleting an org is not properly cleaning up all the dependencies.

Indexing both MarketingProduct and Product is legitimate and useful.