We're trying to troubleshoot connection issues with our app, and I can't
figure where to go from here. The random DB errors seem to happen mostly
for simple short queries, nothing long running, and not during queries that
may be submitting strange data to the server (to rule out character
encoding issues in the queries that fail...)
Stack: Ruby 2.1.1 | phusion passenger 5.0.5 | sequel 4.24 | mysql2 0.3.18 |
mysql 5.5.38
On the client, we see this:
App 22840 stderr: 2015-08-03 09:16:08 - Sequel::DatabaseDisconnectError -
Mysql2::Error: Lost connection to MySQL server during query
On the server:
150803 9:16:08 [Warning] Aborted connection 77175869 to db: 'my_db' user:
'my_db_user' host: '1.2.3.4' (Got an error reading communication packets)
This is how we are setting up the connection (not sure if there is anything
else here, i'm somewhat new at this)
::DB = Sequel.connect("mysql2://#{user}:#{pass}@#{host}/#{db_name}")
::DB.extension(:connection_validator)
::DB.pool.connection_validation_timeout = -1
::DB.extension :newrelic_instrumentation
full stack trace:
App 22840 stderr: 2015-08-03 09:16:08 - Sequel::DatabaseDisconnectError -
Mysql2::Error: Lost connection to MySQL server during query:
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sequel-4.24.0/lib/sequel/adapters/mysql2.rb:78:in
`query'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sequel-4.24.0/lib/sequel/adapters/mysql2.rb:78:in
`block in _execute'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sequel-4.24.0/lib/sequel/database/logging.rb:33:in
`log_yield'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/sequel/extensions/newrelic_instrumentation.rb:45:in
`block in log_yield'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/method_tracer.rb:73:in
`block in trace_execution_scoped'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/method_tracer_helpers.rb:82:in
`trace_execution_scoped'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/method_tracer.rb:71:in
`trace_execution_scoped'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/sequel/extensions/newrelic_instrumentation.rb:42:in
`log_yield'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sequel-4.24.0/lib/sequel/adapters/mysql2.rb:78:in
`_execute'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sequel-4.24.0/lib/sequel/adapters/shared/mysql_prepared_statements.rb:34:in
`block in execute'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sequel-4.24.0/lib/sequel/database/connecting.rb:249:in
`block in synchronize'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sequel-4.24.0/lib/sequel/connection_pool/threaded.rb:103:in
`hold'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sequel-4.24.0/lib/sequel/database/connecting.rb:249:in
`synchronize'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sequel-4.24.0/lib/sequel/adapters/shared/mysql_prepared_statements.rb:34:in
`execute'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sequel-4.24.0/lib/sequel/dataset/actions.rb:921:in
`execute'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sequel-4.24.0/lib/sequel/adapters/mysql2.rb:195:in
`execute'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sequel-4.24.0/lib/sequel/adapters/mysql2.rb:154:in
`fetch_rows'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sequel-4.24.0/lib/sequel/dataset/actions.rb:137:in
`each'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sequel-4.24.0/lib/sequel/dataset/actions.rb:390:in
`map'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sequel-4.24.0/lib/sequel/dataset/actions.rb:390:in
`map'
App 22840 stderr:
/var/www/active/vhost/ourapp.example.org/html/lib/rest/offices.rb:7:in
`block in <class:Api>'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:1610:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:1610:in
`block in compile!'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:974:in
`[]'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:974:in
`block (3 levels) in route!'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:993:in
`route_eval'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/sinatra.rb:138:in
`route_eval_with_newrelic'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:974:in
`block (2 levels) in route!'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:1014:in
`block in process_route'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:1012:in
`catch'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:1012:in
`process_route'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/sinatra.rb:118:in
`process_route_with_newrelic'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:972:in
`block in route!'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:971:in
`each'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:971:in
`route!'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:1084:in
`block in dispatch!'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:1066:in
`block in invoke'
App 22840 stderr: /usr/local/rvm/gems/ruby-2.1.1/gems/sinat
App 22840 stderr: ra-1.4.6/lib/sinatra/base.rb:1066:in `catch'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:1066:in
`invoke'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:1081:in
`dispatch!'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/sinatra.rb:163:in
`dispatch_and_notice_errors_with_newrelic'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/sinatra.rb:149:in
`block in dispatch_with_newrelic'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/controller_instrumentation.rb:361:in
`perform_action_with_newrelic_trace'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/sinatra.rb:146:in
`dispatch_with_newrelic'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:906:in
`block in call!'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:1066:in
`block in invoke'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:1066:in
`catch'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:1066:in
`invoke'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:906:in
`call!'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:894:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/rack/agent_hooks.rb:30:in
`traced_call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/rack/browser_monitoring.rb:32:in
`traced_call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/rack-protection-1.5.3/lib/rack/protection/xss_header.rb:18:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/rack-protection-1.5.3/lib/rack/protection/path_traversal.rb:16:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/rack-protection-1.5.3/lib/rack/protection/json_csrf.rb:18:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/rack-protection-1.5.3/lib/rack/protection/frame_options.rb:31:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/rack-1.6.4/lib/rack/logger.rb:15:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/rack-1.6.4/lib/rack/commonlogger.rb:33:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:218:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:211:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/rack-1.6.4/lib/rack/head.rb:13:in `call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/middleware_tracing
App 22840 stderr: .rb:67:in `call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/rack-1.6.4/lib/rack/methodoverride.rb:22:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:181:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:2021:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:1486:in
`block in call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:1795:in
`synchronize'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/sinatra-1.4.6/lib/sinatra/base.rb:1486:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/rack-1.6.4/lib/rack/urlmap.rb:66:in
`block in call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/rack-1.6.4/lib/rack/urlmap.rb:50:in
`each'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/rack-1.6.4/lib/rack/urlmap.rb:50:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/newrelic_rpm-3.12.1.298/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in
`call'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/passenger-4.0.41/lib/phusion_passenger/rack/thread_handler_extension.rb:74:in
`process_request'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/passenger-4.0.41/lib/phusion_passenger/request_handler/thread_handler.rb:141:in
`accept_and_process_next_request'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/passenger-4.0.41/lib/phusion_passenger/request_handler/thread_handler.rb:109:in
`main_loop'
App 22840 stderr:
/usr/local/rvm/gems/ruby-2.1.1/gems/passenger-4.0.41/lib/phusion_passenger/request_handler.rb:448:in
`block (3 levels) in start_threads'
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
