daily pastebin goal
41%
SHARE
TWEET

Untitled

a guest Jan 20th, 2019 66 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ActiveRecord::StatementInvalid in ForecastController#forecast_discussion
  2. 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
  3.  
  4. Application Trace | Framework Trace | Full Trace
  5. /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'
  6. /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'
  7. /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'
  8. /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'
  9. /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'
  10. /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'
  11. /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'
  12. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:635:in `find_by_sql'
  13. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1490:in `find_every'
  14. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1452:in `find_initial'
  15. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:587:in `find'
  16. app/controllers/forecast_controller.rb:168:in `forecast_discussion'
  17. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/request_handler.rb:65:in `perform_action'
  18. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/request_handler.rb:50:in `process_request'
  19. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
  20. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/application_spawner.rb:378:in `start_request_handler'
  21. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/application_spawner.rb:336:in `handle_spawn_application'
  22. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/utils.rb:183:in `safe_fork'
  23. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/application_spawner.rb:334:in `handle_spawn_application'
  24. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:352:in `__send__'
  25. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
  26. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
  27. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:163:in `start'
  28. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/application_spawner.rb:213:in `start'
  29. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
  30. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
  31. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
  32. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
  33. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
  34. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
  35. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
  36. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
  37. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:352:in `__send__'
  38. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
  39. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
  40. /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'
  41. /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'
  42. /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'
  43. /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'
  44. /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'
  45. /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'
  46. /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'
  47. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:635:in `find_by_sql'
  48. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1490:in `find_every'
  49. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1452:in `find_initial'
  50. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:587:in `find'
  51. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:1253:in `send'
  52. /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'
  53. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/filters.rb:617:in `call_filters'
  54. /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'
  55. /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'
  56. /opt/software/wxweb/opt/lib/ruby/1.8/benchmark.rb:293:in `measure'
  57. /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'
  58. /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'
  59. /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'
  60. /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'
  61. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/query_cache.rb:8:in `cache'
  62. /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'
  63. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:524:in `send'
  64. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:524:in `process_without_filters'
  65. /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'
  66. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/session_management.rb:134:in `process'
  67. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:392:in `process'
  68. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:183:in `handle_request'
  69. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:110:in `dispatch_unlocked'
  70. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:123:in `dispatch'
  71. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:122:in `synchronize'
  72. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:122:in `dispatch'
  73. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:132:in `dispatch_cgi'
  74. /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'
  75. /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'
  76. /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'
  77. /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'
  78. /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'
  79. /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'
  80. /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'
  81. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:635:in `find_by_sql'
  82. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1490:in `find_every'
  83. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1452:in `find_initial'
  84. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:587:in `find'
  85. app/controllers/forecast_controller.rb:168:in `forecast_discussion'
  86. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:1253:in `send'
  87. /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'
  88. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/filters.rb:617:in `call_filters'
  89. /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'
  90. /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'
  91. /opt/software/wxweb/opt/lib/ruby/1.8/benchmark.rb:293:in `measure'
  92. /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'
  93. /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'
  94. /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'
  95. /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'
  96. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/query_cache.rb:8:in `cache'
  97. /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'
  98. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/request_handler.rb:65:in `perform_action'
  99. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:524:in `send'
  100. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:524:in `process_without_filters'
  101. /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'
  102. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/session_management.rb:134:in `process'
  103. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/base.rb:392:in `process'
  104. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:183:in `handle_request'
  105. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:110:in `dispatch_unlocked'
  106. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:123:in `dispatch'
  107. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:122:in `synchronize'
  108. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:122:in `dispatch'
  109. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:132:in `dispatch_cgi'
  110. /opt/software/wxweb/opt/lib/ruby/gems/1.8/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:39:in `dispatch'
  111. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/request_handler.rb:50:in `process_request'
  112. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
  113. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/application_spawner.rb:378:in `start_request_handler'
  114. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/application_spawner.rb:336:in `handle_spawn_application'
  115. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/utils.rb:183:in `safe_fork'
  116. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/application_spawner.rb:334:in `handle_spawn_application'
  117. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:352:in `__send__'
  118. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
  119. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
  120. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:163:in `start'
  121. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/railz/application_spawner.rb:213:in `start'
  122. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
  123. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
  124. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
  125. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
  126. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
  127. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
  128. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
  129. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
  130. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:352:in `__send__'
  131. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
  132. /opt/software/wxweb/opt/passenger/lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
  133. /opt/software/wxweb/opt/passenger/bin/passenger-spawn-server:61Request
  134. Parameters:
  135.  
  136. {"location"=>"PAFB",
  137.  "type"=>"forecast_discussion",
  138.  "icao"=>"PAFB"}
  139. Show session dump
  140.  
  141. ---
  142. :radar_dot_layer: true
  143. :user_id: 10004
  144. flash: !map:ActionController::Flash::FlashHash {}
  145.  
  146. :keep_session_alive: !timestamp
  147.   at: "2011-09-28 20:46:22.945359 +00:00"
  148.   "@marshal_with_utc_coercion": false
  149. :do_password_auth:
  150. Response
  151. Headers:
  152.  
  153. {"X-Powered-By"=>"Phusion Passenger (mod_rails/mod_rack) 2.2.5",
  154.  "Content-Type"=>"",
  155.  "cookie"=>[],
  156.  "Cache-Control"=>"no-cache"}
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top