Bug #5510: Delete information object throws 500 Internal Server Error (access_log FK) - Access to Memory (AtoM) - Artefactual Projects

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:

Verified

Start date:

08/27/2013

Priority:

Medium

Due date:

Assignee:

Jesús García Crespo

% Done:

100%

Category:

Data model / ORM

Estimated time:

3.00 hours

Target version:

Release 2.0.0

Google Code Legacy ID:

Tested version:

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: SQLSTATE²³⁰⁰⁰: 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

Access to Memory (AtoM)

Issues

Custom queries