search

AgileVentures / MetPlus_tracker

Git Repository for the Waffle issue in MetPlus project
2 stars 4 forks source link

Invalid Foreign key on company registration #700

Closed joaopapereira closed 6 years ago

joaopapereira commented 6 years ago

While deleting company 2 DELETE http://petsworkforce.com/admin/company_registrations/2

Stack trace:

/gems/activerecord-4.2.10/lib/active_record/connection_adapters/post[Truncated]:602 in exec_prepared
This is a sample code hunk. Code hunks are lines of code surrounding each backtrace frame.
159:
func (b *Buffer) Grow(n int) {
160:
    if n < 0 {
161:
        panic("bytes.Buffer.Grow: negative count")
162:
    }
163:
    m := b.grow(n)
Enable Code Hunks
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/post[Truncated]:602 in block in exec_cache
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abst[Truncated]:484 in block in log
/gems/activesupport-4.2.10/lib/active_support/notifications/instrume[Truncated]:20 in instrument
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abst[Truncated]:478 in log
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/post[Truncated]:601 in exec_cache
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/post[Truncated]:585 in execute_and_clear
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/post[Truncated]:173 in exec_delete
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abst[Truncated]:119 in delete
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abst[Truncated]:14 in delete
/gems/activerecord-4.2.10/lib/active_record/relation.rb:478 in delete_all
/gems/activerecord-4.2.10/lib/active_record/persistence.rb:487 in destroy_row
/gems/activerecord-4.2.10/lib/active_record/counter_cache.rb:152 in destroy_row
/gems/activerecord-4.2.10/lib/active_record/locking/optimistic.rb:115 in destroy_row
/gems/activerecord-4.2.10/lib/active_record/persistence.rb:172 in destroy
/gems/activerecord-4.2.10/lib/active_record/callbacks.rb:292 in block in destroy
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:88 in __run_callbacks__
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:778 in _run_destroy_callbacks
/gems/activerecord-4.2.10/lib/active_record/callbacks.rb:292 in destroy
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:281 in block in destroy
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:351 in block in with_transaction_returning_status
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abst[Truncated]:211 in transaction
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:220 in transaction
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:348 in with_transaction_returning_status
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:281 in destroy
/gems/activerecord-4.2.10/lib/active_record/persistence.rb:185 in destroy!
/gems/activerecord-4.2.10/lib/active_record/associations/has_many_as[Truncated]:171 in each
/gems/activerecord-4.2.10/lib/active_record/associations/has_many_as[Truncated]:171 in delete_records
/gems/activerecord-4.2.10/lib/active_record/associations/collection_[Truncated]:536 in remove_records
/gems/activerecord-4.2.10/lib/active_record/associations/collection_[Truncated]:529 in block in delete_or_destroy
/gems/activerecord-4.2.10/lib/active_record/associations/collection_[Truncated]:194 in block in transaction
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abst[Truncated]:211 in transaction
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:220 in transaction
/gems/activerecord-4.2.10/lib/active_record/associations/collection_[Truncated]:193 in transaction
/gems/activerecord-4.2.10/lib/active_record/associations/collection_[Truncated]:529 in delete_or_destroy
/gems/activerecord-4.2.10/lib/active_record/associations/collection_[Truncated]:290 in destroy
/gems/activerecord-4.2.10/lib/active_record/associations/collection_[Truncated]:234 in destroy_all
/gems/activerecord-4.2.10/lib/active_record/associations/has_many_as[Truncated]:27 in handle_dependency
/gems/activerecord-4.2.10/lib/active_record/associations/builder/ass[Truncated]:146 in block in add_destroy_callbacks
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:448 in instance_exec
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:448 in block in make_lambda
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:164 in block in halting
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:504 in block in call
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:504 in each
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:504 in call
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:92 in __run_callbacks__
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:778 in _run_destroy_callbacks
/gems/activerecord-4.2.10/lib/active_record/callbacks.rb:292 in destroy
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:281 in block in destroy
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:351 in block in with_transaction_returning_status
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abst[Truncated]:213 in block in transaction
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abst[Truncated]:184 in within_new_transaction
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abst[Truncated]:213 in transaction
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:220 in transaction
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:348 in with_transaction_returning_status
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:281 in destroy
app/controllers/company_registrations_controller.rb:21 in destroy
/gems/actionpack-4.2.10/lib/action_controller/metal/implicit_render.[Truncated]:4 in send_action
/gems/actionpack-4.2.10/lib/abstract_controller/base.rb:198 in process_action
/gems/actionpack-4.2.10/lib/action_controller/metal/rendering.rb:10 in process_action
/gems/actionpack-4.2.10/lib/abstract_controller/callbacks.rb:20 in block in process_action
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:117 in call
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:555 in block (2 levels) in compile
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:505 in call
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:92 in __run_callbacks__
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:778 in _run_process_action_callbacks
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:81 in run_callbacks
/gems/actionpack-4.2.10/lib/abstract_controller/callbacks.rb:19 in process_action
/gems/actionpack-4.2.10/lib/action_controller/metal/rescue.rb:29 in process_action
/gems/actionpack-4.2.10/lib/action_controller/metal/instrumentation.[Truncated]:32 in block in process_action
/gems/activesupport-4.2.10/lib/active_support/notifications.rb:164 in block in instrument
/gems/activesupport-4.2.10/lib/active_support/notifications/instrume[Truncated]:20 in instrument
/gems/activesupport-4.2.10/lib/active_support/notifications.rb:164 in instrument
/gems/actionpack-4.2.10/lib/action_controller/metal/instrumentation.[Truncated]:30 in process_action
/gems/actionpack-4.2.10/lib/action_controller/metal/params_wrapper.r[Truncated]:250 in process_action
/gems/activerecord-4.2.10/lib/active_record/railties/controller_runt[Truncated]:18 in process_action
/gems/actionpack-4.2.10/lib/abstract_controller/base.rb:137 in process
/gems/actionview-4.2.10/lib/action_view/rendering.rb:30 in process
Caused by PG::ForeignKeyViolation: ERROR: update or delete on table "addresses" violates foreign key constraint [Truncated]
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/post[Truncated]:602 in exec_prepared
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/post[Truncated]:602 in block in exec_cache
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abst[Truncated]:484 in block in log
/gems/activesupport-4.2.10/lib/active_support/notifications/instrume[Truncated]:20 in instrument
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abst[Truncated]:478 in log
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/post[Truncated]:601 in exec_cache
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/post[Truncated]:585 in execute_and_clear
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/post[Truncated]:173 in exec_delete
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abst[Truncated]:119 in delete
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abst[Truncated]:14 in delete
/gems/activerecord-4.2.10/lib/active_record/relation.rb:478 in delete_all
/gems/activerecord-4.2.10/lib/active_record/persistence.rb:487 in destroy_row
/gems/activerecord-4.2.10/lib/active_record/counter_cache.rb:152 in destroy_row
/gems/activerecord-4.2.10/lib/active_record/locking/optimistic.rb:115 in destroy_row
/gems/activerecord-4.2.10/lib/active_record/persistence.rb:172 in destroy
/gems/activerecord-4.2.10/lib/active_record/callbacks.rb:292 in block in destroy
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:88 in __run_callbacks__
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:778 in _run_destroy_callbacks
/gems/activerecord-4.2.10/lib/active_record/callbacks.rb:292 in destroy
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:281 in block in destroy
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:351 in block in with_transaction_returning_status
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abst[Truncated]:211 in transaction
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:220 in transaction
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:348 in with_transaction_returning_status
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:281 in destroy
/gems/activerecord-4.2.10/lib/active_record/persistence.rb:185 in destroy!
/gems/activerecord-4.2.10/lib/active_record/associations/has_many_as[Truncated]:171 in each
/gems/activerecord-4.2.10/lib/active_record/associations/has_many_as[Truncated]:171 in delete_records
/gems/activerecord-4.2.10/lib/active_record/associations/collection_[Truncated]:536 in remove_records
/gems/activerecord-4.2.10/lib/active_record/associations/collection_[Truncated]:529 in block in delete_or_destroy
/gems/activerecord-4.2.10/lib/active_record/associations/collection_[Truncated]:194 in block in transaction
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abst[Truncated]:211 in transaction
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:220 in transaction
/gems/activerecord-4.2.10/lib/active_record/associations/collection_[Truncated]:193 in transaction
/gems/activerecord-4.2.10/lib/active_record/associations/collection_[Truncated]:529 in delete_or_destroy
/gems/activerecord-4.2.10/lib/active_record/associations/collection_[Truncated]:290 in destroy
/gems/activerecord-4.2.10/lib/active_record/associations/collection_[Truncated]:234 in destroy_all
/gems/activerecord-4.2.10/lib/active_record/associations/has_many_as[Truncated]:27 in handle_dependency
/gems/activerecord-4.2.10/lib/active_record/associations/builder/ass[Truncated]:146 in block in add_destroy_callbacks
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:448 in instance_exec
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:448 in block in make_lambda
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:164 in block in halting
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:504 in block in call
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:504 in each
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:504 in call
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:92 in __run_callbacks__
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:778 in _run_destroy_callbacks
/gems/activerecord-4.2.10/lib/active_record/callbacks.rb:292 in destroy
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:281 in block in destroy
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:351 in block in with_transaction_returning_status
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abst[Truncated]:213 in block in transaction
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abst[Truncated]:184 in within_new_transaction
/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abst[Truncated]:213 in transaction
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:220 in transaction
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:348 in with_transaction_returning_status
/gems/activerecord-4.2.10/lib/active_record/transactions.rb:281 in destroy
app/controllers/company_registrations_controller.rb:21 in destroy
/gems/actionpack-4.2.10/lib/action_controller/metal/implicit_render.[Truncated]:4 in send_action
/gems/actionpack-4.2.10/lib/abstract_controller/base.rb:198 in process_action
/gems/actionpack-4.2.10/lib/action_controller/metal/rendering.rb:10 in process_action
/gems/actionpack-4.2.10/lib/abstract_controller/callbacks.rb:20 in block in process_action
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:117 in call
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:555 in block (2 levels) in compile
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:505 in call
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:92 in __run_callbacks__
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:778 in _run_process_action_callbacks
/gems/activesupport-4.2.10/lib/active_support/callbacks.rb:81 in run_callbacks
/gems/actionpack-4.2.10/lib/abstract_controller/callbacks.rb:19 in process_action
/gems/actionpack-4.2.10/lib/action_controller/metal/rescue.rb:29 in process_action
/gems/actionpack-4.2.10/lib/action_controller/metal/instrumentation.[Truncated]:32 in block in process_action
/gems/activesupport-4.2.10/lib/active_support/notifications.rb:164 in block in instrument
/gems/activesupport-4.2.10/lib/active_support/notifications/instrume[Truncated]:20 in instrument
/gems/activesupport-4.2.10/lib/active_support/notifications.rb:164 in instrument
/gems/actionpack-4.2.10/lib/action_controller/metal/instrumentation.[Truncated]:30 in process_action
/gems/actionpack-4.2.10/lib/action_controller/metal/params_wrapper.r[Truncated]:250 in process_action
/gems/activerecord-4.2.10/lib/active_record/railties/controller_runt[Truncated]:18 in process_action
/gems/actionpack-4.2.10/lib/abstract_controller/base.rb:137 in process
/gems/actionview-4.2.10/lib/action_view/rendering.rb:30 in process
joaopapereira commented 6 years ago

The problem is that the company as a Job Associated so it cannot be deleted. We need to understand what is the behavior expected in this case. Going to move the story back to another column to wait for Chets input

joaopapereira commented 6 years ago

Check if we can add a new state on the companies saying that the company is no longer active on the system. Eventually display that as a Icon or a visual indication in the administration that the company is no longer active

joaopapereira commented 6 years ago

Close this issue, because I created a set of stories starting with #702