Ruby on Rails
Wednesday, March 5, 2014
Are you really trying to match a users.id of xxxxx or is that just a log artifact? Is your MySQL server local or remote? What happens if you issue a "Customer.find(xxxxx)" in rails console? Obviously you need to provide a valid id, not xxxxx.
On Tuesday, March 4, 2014 12:43:35 PM UTC-5, David Webster wrote:
-- On Tuesday, March 4, 2014 12:43:35 PM UTC-5, David Webster wrote:
I keep getting this type of error, and have researched this for weeks on the internet. tried every suggestion and it still persists..An ActiveRecord::StatementInvalid occurred in customer#go_to_consultation:
Mysql2::Error: Lost connection to MySQL server during query: SELECT `users`.* FROM `users` WHERE `users`.`id` = xxxxx LIMIT 1
mysql2 (0.2.18) lib/active_record/connection_adapters/mysql2_adapter.rb: 265:in `query' nginx version: nginx/1.2.4ruby 1.8.7 (2011-06-30 patchlevel 352) [x86_64-linux]Phusion Passenger version 3.0.18rails (3.0.20)mysql2 (0.2.18)activerecord (3.0.20)activerecord-import (0.2.11)activerecord-mysql2-adapter (0.0.3)Ubuntu 12.04 (precise)other info:* PASSENGER_APP_SPAWNER_IDLE_TIME : -1
* PASSENGER_APP_TYPE : rack
* PASSENGER_CONNECT_PASSWORD : [FILTERED]
* PASSENGER_DEBUGGER : false
* PASSENGER_ENVIRONMENT : production
* PASSENGER_FRAMEWORK_SPAWNER_IDLE_TIME : -1
* PASSENGER_FRIENDLY_ERROR_PAGES : true
* PASSENGER_GROUP :
* PASSENGER_MAX_REQUESTS : 0
* PASSENGER_MIN_INSTANCES : 2
* PASSENGER_SHOW_VERSION_IN_HEADER : true
* PASSENGER_SPAWN_METHOD : smart-lv2
* PASSENGER_USER :
* PASSENGER_USE_GLOBAL_QUEUE : truemysql2 (0.2.18) lib/active_record/connection_adapters/mysql2_adapter.rb: 265:in `query'
mysql2 (0.2.18) lib/active_record/connection_adapters/mysql2_adapter.rb: 265:in `execute'
activerecord (3.0.20) lib/active_record/connection_adapters/abstract_adapter.rb: 202:in `log_without_newrelic_ instrumentation'
activesupport (3.0.20) lib/active_support/notifications/instrumenter.rb: 21:in `instrument'
activerecord (3.0.20) lib/active_record/connection_adapters/abstract_adapter.rb: 200:in `log_without_newrelic_ instrumentation'
newrelic_rpm (3.7.2.192) lib/new_relic/agent/instrumentation/active_record. rb:46:in `log'
newrelic_rpm (3.7.2.192) lib/new_relic/agent/method_tracer.rb:281:in `trace_execution_scoped'
newrelic_rpm (3.7.2.192) lib/new_relic/agent/instrumentation/active_record. rb:43:in `log'
mysql2 (0.2.18) lib/active_record/connection_adapters/mysql2_adapter.rb: 265:in `execute'
mysql2 (0.2.18) lib/active_record/connection_adapters/mysql2_adapter.rb: 586:in `select'
activerecord (3.0.20) lib/active_record/connection_adapters/abstract/database_ statements.rb:7:in `select_all'
activerecord (3.0.20) lib/active_record/connection_adapters/abstract/query_cache. rb:54:in `select_all'
activerecord (3.0.20) lib/active_record/connection_adapters/abstract/query_cache. rb:68:in `cache_sql'
activerecord (3.0.20) lib/active_record/connection_adapters/abstract/query_cache. rb:54:in `select_all'
activerecord (3.0.20) lib/active_record/base.rb:473:in `find_by_sql_without_trace_ ActiveRecord_self_name_find_ by_sql'
newrelic_rpm (3.7.2.192) lib/new_relic/agent/method_tracer.rb:549:in `find_by_sql'
newrelic_rpm (3.7.2.192) lib/new_relic/agent/method_tracer.rb:281:in `trace_execution_scoped'
newrelic_rpm (3.7.2.192) lib/new_relic/agent/method_tracer.rb:544:in `find_by_sql'
activerecord (3.0.20) lib/active_record/relation.rb:64:in `to_a'
activerecord (3.0.20) lib/active_record/relation/finder_methods.rb:343:in `find_first'
activerecord (3.0.20) lib/active_record/relation/finder_methods.rb:122:in `first'
activerecord (3.0.20) lib/active_record/relation/finder_methods.rb:244:in `send'
activerecord (3.0.20) lib/active_record/relation/finder_methods.rb:244:in `find_by_attributes'
activerecord (3.0.20) lib/active_record/base.rb:997:in `send'
activerecord (3.0.20) lib/active_record/base.rb:997:in `method_missing'
lib/authenticated_system.rb:11:in `current_user'
app/controllers/application_controller.rb:16:in `load_org_hash'
activesupport (3.0.20) lib/active_support/callbacks.rb:447:in `_run__1783524324__process_ action__741958110__callbacks'
activesupport (3.0.20) lib/active_support/callbacks.rb:410:in `send'
activesupport (3.0.20) lib/active_support/callbacks.rb:410:in `_run_process_action_ callbacks'
activesupport (3.0.20) lib/active_support/callbacks.rb:94:in `send'
activesupport (3.0.20) lib/active_support/callbacks.rb:94:in `run_callbacks'
actionpack (3.0.20) lib/abstract_controller/callbacks.rb:17:in `process_action'
actionpack (3.0.20) lib/action_controller/metal/rescue.rb:17:in `process_action'
actionpack (3.0.20) lib/action_controller/metal/instrumentation.rb:30:in `process_action'
activesupport (3.0.20) lib/active_support/notifications.rb:52:in `instrument'
activesupport (3.0.20) lib/active_support/notifications/instrumenter.rb: 21:in `instrument'
activesupport (3.0.20) lib/active_support/notifications.rb:52:in `instrument'
actionpack (3.0.20) lib/action_controller/metal/instrumentation.rb:29:in `process_action'
newrelic_rpm (3.7.2.192) lib/new_relic/agent/instrumentation/rails3/action_ controller.rb:38:in `process_action'
newrelic_rpm (3.7.2.192) lib/new_relic/agent/instrumentation/controller_ instrumentation.rb:339:in `perform_action_with_newrelic_ trace'
newrelic_rpm (3.7.2.192) lib/new_relic/agent/instrumentation/rails3/action_ controller.rb:37:in `process_action'
actionpack (3.0.20) lib/abstract_controller/base.rb:119:in `process'
actionpack (3.0.20) lib/abstract_controller/rendering.rb:41:in `process'
actionpack (3.0.20) lib/action_controller/metal.rb:138:in `dispatch'
actionpack (3.0.20) lib/action_controller/metal/rack_delegation.rb:14:in `dispatch'
actionpack (3.0.20) lib/action_controller/metal.rb:178:in `action'
actionpack (3.0.20) lib/action_dispatch/routing/route_set.rb:68:in `call'
actionpack (3.0.20) lib/action_dispatch/routing/route_set.rb:68:in `dispatch'
actionpack (3.0.20) lib/action_dispatch/routing/route_set.rb:33:in `call'
rack-mount (0.6.14) lib/rack/mount/route_set.rb:148:in `call'
rack-mount (0.6.14) lib/rack/mount/code_generation.rb:93:in `recognize'
rack-mount (0.6.14) lib/rack/mount/code_generation.rb:117:in `optimized_each'
rack-mount (0.6.14) lib/rack/mount/code_generation.rb:92:in `recognize'
rack-mount (0.6.14) lib/rack/mount/route_set.rb:139:in `call'
actionpack (3.0.20) lib/action_dispatch/routing/route_set.rb:499:in `call'
omniauth (1.1.4) lib/omniauth/strategy.rb:184:in `call!'
omniauth (1.1.4) lib/omniauth/strategy.rb:164:in `call'
omniauth (1.1.4) lib/omniauth/strategy.rb:184:in `call!'
omniauth (1.1.4) lib/omniauth/strategy.rb:164:in `call'
omniauth (1.1.4) lib/omniauth/builder.rb:49:in `call'
newrelic_rpm (3.7.2.192) lib/new_relic/rack/error_collector.rb:55:in `call'
newrelic_rpm (3.7.2.192) lib/new_relic/rack/agent_hooks.rb:32:in `call'
newrelic_rpm (3.7.2.192) lib/new_relic/rack/browser_monitoring.rb:27:in `call'
exception_notification (3.0.0) lib/exception_notifier.rb:40:in `call'
/home/deployer/apps/mdlive/shared/bundle/ruby/1.8/ bundler/gems/simple-captcha- 3557b78feb5f/lib/simple_ captcha/middleware.rb:20:in `call'
actionpack (3.0.20) lib/action_dispatch/middleware/best_standards_ support.rb:17:in `call'
actionpack (3.0.20) lib/action_dispatch/middleware/head.rb:14:in `call'
rack (1.2.8) lib/rack/methodoverride.rb:24:in `call'
actionpack (3.0.20) lib/action_dispatch/middleware/params_parser.rb: 21:in `call'
actionpack (3.0.20) lib/action_dispatch/middleware/flash.rb:182:in `call'
actionpack (3.0.20) lib/action_dispatch/middleware/session/abstract_ store.rb:149:in `call'
actionpack (3.0.20) lib/action_dispatch/middleware/cookies.rb:302:in `call'
rack-ssl (1.3.3) lib/rack/ssl.rb:27:in `call'
activerecord (3.0.20) lib/active_record/query_cache.rb:32:in `call'
activerecord (3.0.20) lib/active_record/connection_adapters/abstract/query_cache. rb:28:in `cache'
activerecord (3.0.20) lib/active_record/query_cache.rb:12:in `cache'
activerecord (3.0.20) lib/active_record/query_cache.rb:31:in `call'
activerecord (3.0.20) lib/active_record/connection_adapters/abstract/connection_ pool.rb:354:in `call'
actionpack (3.0.20) lib/action_dispatch/middleware/callbacks.rb:46:in `call'
activesupport (3.0.20) lib/active_support/callbacks.rb:416:in `_run_call_callbacks'
actionpack (3.0.20) lib/action_dispatch/middleware/callbacks.rb:44:in `call'
rack (1.2.8) lib/rack/sendfile.rb:106:in `call'
actionpack (3.0.20) lib/action_dispatch/middleware/remote_ip.rb:48:in `call'
actionpack (3.0.20) lib/action_dispatch/middleware/show_exceptions.rb: 47:in `call'
railties (3.0.20) lib/rails/rack/logger.rb:13:in `call'
rack (1.2.8) lib/rack/runtime.rb:17:in `call'
activesupport (3.0.20) lib/active_support/cache/strategy/local_cache.rb:72:in `call'
rack (1.2.8) lib/rack/lock.rb:13:in `call'
rack (1.2.8) lib/rack/lock.rb:13:in `synchronize'
rack (1.2.8) lib/rack/lock.rb:13:in `call'
railties (3.0.20) lib/rails/application.rb:168:in `call'
railties (3.0.20) lib/rails/application.rb:77:in `send'
railties (3.0.20) lib/rails/application.rb:77:in `method_missing'
passenger (3.0.18) lib/phusion_passenger/rack/request_handler.rb:96:in `process_request'
passenger (3.0.18) lib/phusion_passenger/abstract_request_handler.rb: 516:in `accept_and_process_next_ request'
passenger (3.0.18) lib/phusion_passenger/abstract_request_handler.rb: 274:in `main_loop'
passenger (3.0.18) lib/phusion_passenger/rack/application_spawner.rb:206:in `start_request_handler'
passenger (3.0.18) lib/phusion_passenger/rack/application_spawner.rb:171:in `send'
passenger (3.0.18) lib/phusion_passenger/rack/application_spawner.rb:171:in `handle_spawn_application'
passenger (3.0.18) lib/phusion_passenger/utils.rb:470:in `safe_fork'
passenger (3.0.18) lib/phusion_passenger/rack/application_spawner.rb:166:in `handle_spawn_application'
passenger (3.0.18) lib/phusion_passenger/abstract_server.rb:357:in `__send__'
passenger (3.0.18) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
passenger (3.0.18) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
passenger (3.0.18) lib/phusion_passenger/abstract_server.rb:180:in `start'
passenger (3.0.18) lib/phusion_passenger/rack/application_spawner.rb:129:in `start'
passenger (3.0.18) lib/phusion_passenger/spawn_manager.rb:253:in `spawn_rack_application'
passenger (3.0.18) lib/phusion_passenger/abstract_server_collection.rb: 132:in `lookup_or_add'
passenger (3.0.18) lib/phusion_passenger/spawn_manager.rb:246:in `spawn_rack_application'
passenger (3.0.18) lib/phusion_passenger/abstract_server_collection.rb: 82:in `synchronize'
passenger (3.0.18) lib/phusion_passenger/abstract_server_collection.rb: 79:in `synchronize'
passenger (3.0.18) lib/phusion_passenger/spawn_manager.rb:244:in `spawn_rack_application'
passenger (3.0.18) lib/phusion_passenger/spawn_manager.rb:137:in `spawn_application'
passenger (3.0.18) lib/phusion_passenger/spawn_manager.rb:275:in `handle_spawn_application'
passenger (3.0.18) lib/phusion_passenger/abstract_server.rb:357:in `__send__'
passenger (3.0.18) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
passenger (3.0.18) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
passenger (3.0.18) helper-scripts/passenger-spawn-server:99
MDLIVE, INC. CONFIDENTIALITY NOTICE:
This e-mail and any attachments are for the exclusive and confidential use of the intended recipient. If you are not the intended recipient, please do not read, distribute or take action in reliance on this message. If you have received this message in error, please notify us immediately by return e-mail and promptly delete this message and its attachments from your computer system. We do not waive attorney-client, work product, doctor-patient, therapist-client or intellectual property privileges by the transmission of this message.
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/0d3a60fd-6e5c-4629-948f-31135c0c663b%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment