Bug #5510

Delete information object throws 500 Internal Server Error (access_log FK)

Added by José Raddaoui Marín over 8 years ago. Updated over 8 years ago.

Status:VerifiedStart date:08/27/2013
Priority:MediumDue date:
Assignee:Jesús García Crespo% Done:

100%

Category:Data model / ORMEstimated time:3.00 hours
Target version:Release 2.0.0
Google Code Legacy ID: Tested version:
Sponsored:No Requires documentation:

Description

Process
1) Create description
2) View description
3) Delete description

Result
500 Internal Server Error

Expected result
Description deleted without errors

History

#1 Updated by José Raddaoui Marín over 8 years ago

It was a problem with the database schema. So, a new instalation is required

#2 Updated by José Raddaoui Marín over 8 years ago

  • Status changed from New to QA/Review
  • % Done changed from 0 to 100

Applied in changeset atom|commit:23d23a0939c714fc6ca4bdb88cc31225fbcc248a.

#3 Updated by Jessica Bushey over 8 years ago

  • Status changed from QA/Review to Feedback
  • Assignee changed from José Raddaoui Marín to Jesús García Crespo

I can't test this until Jesus updates the database manually.

#4 Updated by Jesús García Crespo over 8 years ago

  • Status changed from Feedback to QA/Review

You should be able to do that now Jess.

#5 Updated by Dan Gillean over 8 years ago

  • Status changed from QA/Review to Feedback

Still getting a 500 error on delete. Tried both creating a new archival description and deleting, as well as deleting a child record of an existing description - same result.

#6 Updated by Jesús García Crespo over 8 years ago

  • Status changed from Feedback to QA/Review

Can you share the traceback (if any), please? Thanks.

#7 Updated by Dan Gillean over 8 years ago

500 | Internal Server Error | Elastica\Exception\NotFoundException
Doc id 120933 not found and can not be deleted
stack trace

at ()
in SF_ROOT_DIR/plugins/arElasticSearchPlugin/lib/vendor/Elastica/lib/Elastica/Type.php line 381 ...
$responseData = $response->getData();
if (isset($responseData['found']) && false == $responseData['found']) {
throw new NotFoundException('Doc id ' . $id . ' not found and can not be deleted');
}
return $response;
at Elastica\Type->deleteById('120933')
in SF_ROOT_DIR/plugins/arElasticSearchPlugin/lib/arElasticSearchPlugin.class.php line 317 ...
at arElasticSearchPlugin->delete(object('QubitInformationObject'))
in SF_ROOT_DIR/lib/model/QubitInformationObject.php line 372 ...
at QubitInformationObject->delete()
in SF_ROOT_DIR/apps/qubit/modules/informationobject/actions/deleteAction.class.php line 53 ...
at InformationObjectDeleteAction->execute(object('sfWebRequest'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfExecutionFilter.class.php line 92 ...
at sfExecutionFilter->executeAction(object('InformationObjectDeleteAction'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfExecutionFilter.class.php line 78 ...
at sfExecutionFilter->handleAction(object('sfFilterChain'), object('InformationObjectDeleteAction'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfExecutionFilter.class.php line 42 ...
at sfExecutionFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/lib/filter/QubitLimitResults.class.php line 34 ...
at QubitLimitResults->execute(object('sfFilterChain'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/lib/filter/QubitMeta.class.php line 29 ...
at QubitMeta->execute(object('sfFilterChain'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/lib/filter/QubitSslRequirementFilter.class.php line 35 ...
at QubitSslRequirementFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/lib/filter/QubitLimitIp.class.php line 39 ...
at QubitLimitIpFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/lib/filter/QubitSettingsFilter.class.php line 43 ...
at QubitSettingsFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfRenderingFilter.class.php line 33 ...
at sfRenderingFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/plugins/sfHistoryPlugin/lib/sfHistoryPluginFilter.class.php line 18 ...
at sfHistoryPluginFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/lib/filter/QubitTransactionFilter.class.php line 40 ...
at QubitTransactionFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/vendor/symfony/lib/controller/sfController.class.php line 238 ...
at sfController->forward('informationobject', 'delete')
in SF_ROOT_DIR/vendor/symfony/lib/controller/sfFrontWebController.class.php line 48 ...
at sfFrontWebController->dispatch()
in SF_ROOT_DIR/vendor/symfony/lib/util/sfContext.class.php line 170 ...
at sfContext->dispatch()
in SF_ROOT_DIR/qubit_dev.php line 21 ...

etc...

#8 Updated by Dan Gillean over 8 years ago

  • Status changed from QA/Review to Feedback

#9 Updated by Jesús García Crespo over 8 years ago

  • Subject changed from Delete information object throws 500 Internal Server Error to Delete information object throws 500 Internal Server Error (access_log FK)
  • Status changed from Feedback to QA/Review

#10 Updated by Jesús García Crespo over 8 years ago

Dan, the problem that you are having shouldn't happen anymore as of commit:6ec75c76.

#11 Updated by Dan Gillean over 8 years ago

  • Status changed from QA/Review to Feedback

Still getting this error when trying to delete. from qubit_dev:

500 | Internal Server Error | PropelException
Unable to execute DELETE statement. [wrapped: SQLSTATE23000: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`atom_2x_test`.`access_log`, CONSTRAINT `access_log_FK_1` FOREIGN KEY (`object_id`) REFERENCES `object` (`id`))]
stack trace

at ()
in SF_ROOT_DIR/vendor/symfony/lib/plugins/sfPropelPlugin/lib/vendor/propel/util/BasePeer.php line 165 ...
$affectedRows = $stmt->rowCount();
} catch (Exception $e) {
Propel::log($e->getMessage(), Propel::LOG_ERR);
throw new PropelException("Unable to execute DELETE statement.",$e);
}
} // for each table
at BasePeer::doDelete(object('Criteria'), object('DebugPDO'))
in SF_ROOT_DIR/lib/model/om/BaseObject.php line 104 ...
at BaseObject::doDelete(object('Criteria'), object('DebugPDO'))
in SF_ROOT_DIR/lib/model/om/BaseObject.php line 730 ...
at BaseObject->delete(object('DebugPDO'))
in SF_ROOT_DIR/lib/model/QubitObject.php line 300 ...
at QubitObject->delete(null)
in SF_ROOT_DIR/lib/model/om/BaseInformationObject.php line 466 ...
at BaseInformationObject->delete(null)
in SF_ROOT_DIR/lib/model/QubitInformationObject.php line 374 ...
at QubitInformationObject->delete()
in SF_ROOT_DIR/apps/qubit/modules/informationobject/actions/deleteAction.class.php line 53 ...
at InformationObjectDeleteAction->execute(object('sfWebRequest'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfExecutionFilter.class.php line 92 ...
at sfExecutionFilter->executeAction(object('InformationObjectDeleteAction'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfExecutionFilter.class.php line 78 ...
at sfExecutionFilter->handleAction(object('sfFilterChain'), object('InformationObjectDeleteAction'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfExecutionFilter.class.php line 42 ...
at sfExecutionFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/lib/filter/QubitLimitResults.class.php line 34 ...
at QubitLimitResults->execute(object('sfFilterChain'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/lib/filter/QubitMeta.class.php line 29 ...
at QubitMeta->execute(object('sfFilterChain'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/lib/filter/QubitSslRequirementFilter.class.php line 35 ...
at QubitSslRequirementFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/lib/filter/QubitLimitIp.class.php line 39 ...
at QubitLimitIpFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/lib/filter/QubitSettingsFilter.class.php line 43 ...
at QubitSettingsFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfRenderingFilter.class.php line 33 ...
at sfRenderingFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/plugins/sfHistoryPlugin/lib/sfHistoryPluginFilter.class.php line 18 ...
at sfHistoryPluginFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/lib/filter/QubitTransactionFilter.class.php line 40 ...
at QubitTransactionFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/vendor/symfony/lib/controller/sfController.class.php line 238 ...
at sfController->forward('informationobject', 'delete')
in SF_ROOT_DIR/vendor/symfony/lib/controller/sfFrontWebController.class.php line 48 ...
at sfFrontWebController->dispatch()
in SF_ROOT_DIR/vendor/symfony/lib/util/sfContext.class.php line 170 ...
at sfContext->dispatch()
in SF_ROOT_DIR/qubit_dev.php line 21 ...

#12 Updated by Jesús García Crespo over 8 years ago

  • Status changed from Feedback to QA/Review

Try again, please!

#13 Updated by Dan Gillean over 8 years ago

  • Status changed from QA/Review to Verified

Works!

Also available in: Atom PDF