Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-3368

Error log "ActiveRecord::JDBCError: Unknown column 'project_measures.variation_value_0'"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.14
    • Fix Version/s: 3.0
    • Component/s: Web
    • Labels:
      None

      Description

      2012.03.27 18:53:39 ERROR o.s.s.ui.JRubyFacade  Fail to render: http://nemo.sonarsource.org/drilldown/measures/219971?metric=test_errors&period=
      ActiveRecord::JDBCError: Unknown column 'project_measures.variation_value_0' in 'field list': SELECT project_measures.id,project_measures.metric_id,project_measures.variation_value_0,project_measures.text_value,project_measures.alert_status,project_measures.alert_text,project_measures.snapshot_id FROM `project_measures`   INNER JOIN `snapshots` ON `snapshots`.id = `project_measures`.snapshot_id  WHERE (snapshots.root_snapshot_id=22925758 AND snapshots.islast=1 AND snapshots.qualifier in ('SVW')  AND snapshots.path LIKE '22925758.%' AND project_measures.metric_id=10 AND project_measures.variation_value_0 IS NOT NULL AND project_measures.rule_id IS NULL  AND project_measures.characteristic_id IS NULL AND project_measures.person_id IS NULL)  ORDER BY project_measures.variation_value_0 DESC LIMIT 200
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:219:in `log'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:210:in `log'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/gems/activerecord-jdbc-adapter-1.1.3/lib/arjdbc/jdbc/adapter.rb:183:in `execute'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/gems/activerecord-jdbc-adapter-1.1.3/lib/arjdbc/jdbc/adapter.rb:273:in `select'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/gems/activerecord-jdbc-adapter-1.1.3/lib/arjdbc/jdbc/adapter.rb:202:in `jdbc_select_all'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all_with_query_cache'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:81:in `cache_sql'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all_with_query_cache'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/base.rb:661:in `find_by_sql'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/base.rb:1548:in `find_every'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/base.rb:615:in `find'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/app/models/drilldown.rb:134:in `init_measures'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/app/models/drilldown.rb:35:in `initialize'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/app/controllers/drilldown_controller.rb:57:in `measures'
      	org/jruby/RubyKernel.java:2052:in `send'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/base.rb:1331:in `perform_action'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/filters.rb:617:in `call_filters'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/filters.rb:610:in `perform_action_with_filters'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_with_benchmark'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in `ms'
      	file:/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/lib/jruby-complete-1.6.1.jar!/META-INF/jruby.home/lib/ruby/1.8/benchmark.rb:308:in `realtime'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in `ms'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_with_benchmark'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/rescue.rb:160:in `perform_action_with_rescue'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/flash.rb:146:in `perform_action_with_flash'
      	org/jruby/RubyKernel.java:2064:in `send'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/base.rb:532:in `process'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/filters.rb:606:in `process_with_filters'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/base.rb:391:in `process'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/base.rb:386:in `call'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/routing/route_set.rb:437:in `call'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:87:in `dispatch'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:85:in `dispatch'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:121:in `_call'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:130:in `build_middleware_stack'
      	org/jruby/RubyProc.java:268:in `call'
      	org/jruby/RubyProc.java:228:in `call'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/query_cache.rb:29:in `call'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/query_cache.rb:9:in `cache'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/query_cache.rb:28:in `call'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:in `call'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/string_coercion.rb:25:in `call'
      	file:/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/vendor/rack-1.2.1/rack/head.rb:9:in `call'
      	file:/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/vendor/rack-1.2.1/rack/methodoverride.rb:24:in `call'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/params_parser.rb:15:in `call'
      	file:/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/jruby/rack/session_store.rb:42:in `call'
      	file:/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/jruby/rack/session_store.rb:39:in `call'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/failsafe.rb:26:in `call'
      	/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:106:in `call'
      	file:/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/rack/adapter/rails.rb:36:in `serve_rails'
      	file:/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/rack/adapter/rails.rb:41:in `call'
      	file:/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/jruby/rack/rails.rb:185:in `call'
      	file:/vol/sonar/sonar-2.14/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/rack/handler/servlet.rb:19:in `call'
      
      

        Attachments

          Activity

            People

            Assignee:
            fabemn OLD - Fabrice Bellingard
            Reporter:
            simon.brandhof Simon Brandhof (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: