Skip to content

Instantly share code, notes, and snippets.

@sykesm
Created February 26, 2014 19:02
Show Gist options
  • Save sykesm/9236131 to your computer and use it in GitHub Desktop.
Save sykesm/9236131 to your computer and use it in GitHub Desktop.
Error during CloudController start when the service bindings foreign key constraint is violated
/var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/sequel-3.48.0/lib/sequel/adapters/postgres.rb:158:in `exec': PG::ForeignKeyViolation: ERROR: update or delete on table "apps" violates foreign key constraint "fk_service_bindings_app_id" on table "service_bindings" (Sequel::ForeignKeyConstraintViolation)
DETAIL: Key (id)=(117038) is still referenced from table "service_bindings".
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/sequel-3.48.0/lib/sequel/adapters/postgres.rb:158:in `block in execute_query'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/sequel-3.48.0/lib/sequel/database/logging.rb:37:in `log_yield'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/newrelic_rpm-3.6.9.171/lib/sequel/extensions/newrelic_instrumentation.rb:42:in `log_yield'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/sequel-3.48.0/lib/sequel/adapters/postgres.rb:158:in `execute_query'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/sequel-3.48.0/lib/sequel/adapters/postgres.rb:145:in `block in execute'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/sequel-3.48.0/lib/sequel/adapters/postgres.rb:124:in `check_disconnect_errors'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/sequel-3.48.0/lib/sequel/adapters/postgres.rb:145:in `execute'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/sequel-3.48.0/lib/sequel/adapters/postgres.rb:455:in `_execute'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/sequel-3.48.0/lib/sequel/adapters/postgres.rb:279:in `block (2 levels) in execute'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/sequel-3.48.0/lib/sequel/adapters/postgres.rb:476:in `check_database_errors'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/sequel-3.48.0/lib/sequel/adapters/postgres.rb:279:in `block in execute'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/sequel-3.48.0/lib/sequel/database/connecting.rb:235:in `block in synchronize'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/sequel-3.48.0/lib/sequel/connection_pool/threaded.rb:104:in `hold'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/sequel-3.48.0/lib/sequel/database/connecting.rb:235:in `synchronize'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/sequel-3.48.0/lib/sequel/adapters/postgres.rb:279:in `execute'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/sequel-3.48.0/lib/sequel/database/query.rb:57:in `execute_dui'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/sequel-3.48.0/lib/sequel/dataset/actions.rb:871:in `execute_dui'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/sequel-3.48.0/lib/sequel/dataset/actions.rb:137:in `delete'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/config/initializers/app_soft_delete_destroyer.rb:11:in `app_soft_delete_destroyer'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/lib/cloud_controller/config.rb:178:in `block in run_initializers'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/lib/cloud_controller/config.rb:175:in `each'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/lib/cloud_controller/config.rb:175:in `run_initializers'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/lib/cloud_controller/config.rb:151:in `configure_components'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/lib/cloud_controller/runner.rb:162:in `start_cloud_controller'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/lib/cloud_controller/runner.rb:111:in `block in run!'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/eventmachine-1.0.3/lib/eventmachine.rb:187:in `call'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/eventmachine-1.0.3/lib/eventmachine.rb:187:in `run_machine'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/vendor/bundle/ruby/1.9.1/gems/eventmachine-1.0.3/lib/eventmachine.rb:187:in `run'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/lib/cloud_controller/runner.rb:104:in `run!'
from /var/vcap/packages/cloud_controller_ng/cloud_controller_ng/bin/cloud_controller:12:in `<main>'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment