ActiveRecord::StatementInvalid in ForecastController#forecast_discussion
OCIError: ORA-00920: invalid relational operator: select * from (select raw_sql_.*, rownum raw_rnum_ from (SELECT * FROM us_zones WHERE (the_geom && SetSRID(MakePoint(-147.595555555556, 64.8366666666667),4326) AND Contains(the_geom,SetSRID(MakePoint(-147.595555555556,64.8366666666667),4326))) ) raw_sql_ where rownum <= 1) where raw_rnum_ > 0RAILS_ROOT: /opt/software/wxweb-1.9-r14108-fedex-x86_64-linux/releases/20110915001748

Application Trace | Framework Trace | Full Trace
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:188:in `log'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-oracle-adapter-1.0.0.9250/lib/active_record/connection_adapters/oracle_adapter.rb:221:in `execute'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-oracle-adapter-1.0.0.9250/lib/active_record/connection_adapters/oracle_adapter.rb:516:in `select'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:81:in `cache_sql'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:635:in `find_by_sql'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1490:in `find_every'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1452:in `find_initial'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:587:in `find'
app/controllers/forecast_controller.rb:168:in `forecast_discussion'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/request_handler.rb:65:in `perform_action'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/request_handler.rb:50:in `process_request'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/application_spawner.rb:378:in `start_request_handler'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/application_spawner.rb:336:in `handle_spawn_application'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/utils.rb:183:in `safe_fork'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/application_spawner.rb:334:in `handle_spawn_application'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:352:in `__send__'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:163:in `start'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/application_spawner.rb:213:in `start'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:352:in `__send__'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
/opt/software/wxweb/opt/passenger/bin/passenger-spawn-server:61/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:188:in `log'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-oracle-adapter-1.0.0.9250/lib/active_record/connection_adapters/oracle_adapter.rb:221:in `execute'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-oracle-adapter-1.0.0.9250/lib/active_record/connection_adapters/oracle_adapter.rb:516:in `select'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:81:in `cache_sql'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:635:in `find_by_sql'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1490:in `find_every'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1452:in `find_initial'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:587:in `find'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:1253:in `send'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:1253:in `perform_action_without_filters'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/filters.rb:617:in `call_filters'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/filters.rb:610:in `perform_action_without_benchmark'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/opt/software/wxweb/opt/lib/ruby/1.8/benchmark.rb:293:in `measure'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/rescue.rb:136:in `perform_action_without_caching'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/caching/sql_cache.rb:13:in `passenger_orig_perform_action'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/query_cache.rb:8:in `cache'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/caching/sql_cache.rb:12:in `passenger_orig_perform_action'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:524:in `send'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:524:in `process_without_filters'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/filters.rb:606:in `process_without_session_management_support'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/session_management.rb:134:in `process'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:392:in `process'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:183:in `handle_request'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:110:in `dispatch_unlocked'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:123:in `dispatch'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:122:in `synchronize'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:122:in `dispatch'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:132:in `dispatch_cgi'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:39:in `dispatch'/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:188:in `log'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-oracle-adapter-1.0.0.9250/lib/active_record/connection_adapters/oracle_adapter.rb:221:in `execute'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-oracle-adapter-1.0.0.9250/lib/active_record/connection_adapters/oracle_adapter.rb:516:in `select'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:81:in `cache_sql'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:635:in `find_by_sql'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1490:in `find_every'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1452:in `find_initial'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:587:in `find'
app/controllers/forecast_controller.rb:168:in `forecast_discussion'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:1253:in `send'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:1253:in `perform_action_without_filters'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/filters.rb:617:in `call_filters'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/filters.rb:610:in `perform_action_without_benchmark'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/opt/software/wxweb/opt/lib/ruby/1.8/benchmark.rb:293:in `measure'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/rescue.rb:136:in `perform_action_without_caching'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/caching/sql_cache.rb:13:in `passenger_orig_perform_action'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/query_cache.rb:8:in `cache'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/caching/sql_cache.rb:12:in `passenger_orig_perform_action'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/request_handler.rb:65:in `perform_action'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:524:in `send'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:524:in `process_without_filters'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/filters.rb:606:in `process_without_session_management_support'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/session_management.rb:134:in `process'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:392:in `process'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:183:in `handle_request'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:110:in `dispatch_unlocked'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:123:in `dispatch'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:122:in `synchronize'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:122:in `dispatch'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:132:in `dispatch_cgi'
/opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:39:in `dispatch'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/request_handler.rb:50:in `process_request'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/application_spawner.rb:378:in `start_request_handler'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/application_spawner.rb:336:in `handle_spawn_application'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/utils.rb:183:in `safe_fork'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/application_spawner.rb:334:in `handle_spawn_application'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:352:in `__send__'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:163:in `start'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/application_spawner.rb:213:in `start'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:352:in `__send__'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
/opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
/opt/software/wxweb/opt/passenger/bin/passenger-spawn-server:61Request
Parameters:

{"location"=>"PAFB",
 "type"=>"forecast_discussion",
 "icao"=>"PAFB"}
Show session dump

---
:radar_dot_layer: true
:user_id: 10004
flash: !map:ActionController::Flash::FlashHash {}

:keep_session_alive: !timestamp
  at: "2011-09-28 20:46:22.945359 +00:00"
  "@marshal_with_utc_coercion": false
:do_password_auth:
Response
Headers:

{"X-Powered-By"=>"Phusion Passenger (mod_rails/mod_rack) 2.2.5",
 "Content-Type"=>"",
 "cookie"=>[],
 "Cache-Control"=>"no-cache"}