Hide Forgot
Description of problem: When user try to create an deployable from Image, it will return PGError: ERROR: column catalogs.pool_family_id does not exist LINE 1: SELECT COUNT(*) FROM "catalogs" WHERE "catalogs"."pool_famil... ^ : SELECT COUNT(*) FROM "catalogs" WHERE "catalogs"."pool_family_id" = 1 Steps to Reproduce: 1. Create image through UI (New image) 2. Build & push the image 3. Create deployable from Image Actual results: PGError: ERROR: column catalogs.pool_family_id does not exist LINE 1: SELECT COUNT(*) FROM "catalogs" WHERE "catalogs"."pool_famil... ^ : SELECT COUNT(*) FROM "catalogs" WHERE "catalogs"."pool_family_id" = 1 Expected results: Created deployable from image Additional info: Rails log says the issue is on the line 47 : SELECT COUNT(*) FROM "catalogs" WHERE "catalogs"."pool_family_id" = 1 /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/connection_adapters/abstract_adapter.rb:207:in `log' /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/connection_adapters/postgresql_adapter.rb:514:in `execute' /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/connection_adapters/postgresql_adapter.rb:1004:in `select_raw' /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/connection_adapters/postgresql_adapter.rb:997:in `select' /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all' /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/connection_adapters/abstract/query_cache.rb:54:in `select_all' /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/connection_adapters/abstract/query_cache.rb:68:in `cache_sql' /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/connection_adapters/abstract/query_cache.rb:54:in `select_all' /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/connection_adapters/abstract/database_statements.rb:13:in `select_one' /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/connection_adapters/abstract/database_statements.rb:19:in `select_value' /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/relation/calculations.rb:207:in `execute_simple_calculation' /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/relation/calculations.rb:182:in `perform_calculation' /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/relation/calculations.rb:152:in `calculate' /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/relation/calculations.rb:58:in `count' /usr/lib/ruby/gems/1.8/gems/activerecord-3.0.10/lib/active_record/relation.rb:92:in `empty?' /home/jzigmund/deltacloud/aggregator/src/app/controllers/deployables_controller.rb:47:in `new' When I dug deeper, the regresion was impelement in patch with commit # 72f4dff0 so I'm assigning this bug to Scott. The PGErr is comming from deployables_controller.rb method load_catalogs.
Sorry I didnt run the newest migration.