[Loris-dev] Error when removing UploadID

Mon Oct 5 09:42:49 EDT 2020

Dear LorisDev team,

I am removing the images from some visits that need to be reuploaded. Out of 1.5K visits I have two of them failing to be removed. I am using the script “delete_imaging_upload.pl”. Here is the output I am getting:

===
Backing up files related to the upload(s) to delete...
/aaa/data/assembly/700759/w96/mri/native/IPMSA_700759_w96_flair_001.mnc
/aaa/data/assembly/700759/w96/mri/native/IPMSA_700759_w96_mtOFF_001.mnc
/aaa/data/assembly/700759/w96/mri/native/IPMSA_700759_w96_pdw_001.mnc
/aaa/data/assembly/700759/w96/mri/native/IPMSA_700759_w96_t1p_001.mnc
/aaa/data/assembly/700759/w96/mri/native/IPMSA_700759_w96_t1c_001.mnc
/aaa/data/assembly/700759/w96/mri/native/IPMSA_700759_w96_t2w_001.mnc
/aaa/data/assembly/310229/w96/mri/native/IPMSA_310229_w96_flair_001.mnc
/aaa/data/assembly/310229/w96/mri/native/IPMSA_310229_w96_mtOFF_001.mnc
/aaa/data/assembly/310229/w96/mri/native/IPMSA_310229_w96_pdw_001.mnc
/aaa/data/assembly/310229/w96/mri/native/IPMSA_310229_w96_t1p_001.mnc
/aaa/data/assembly/310229/w96/mri/native/IPMSA_310229_w96_t1c_001.mnc
/aaa/data/assembly/310229/w96/mri/native/IPMSA_310229_w96_t2w_001.mnc
/aaa/data/assembly/700759/w96/mri/processed/ConsensusGd/IPMSA_700759_w96_t1c_001_gvf_001.mnc.gz
/aaa/data/assembly/700759/w96/mri/processed/NewT2/IPMSA_700759_w96_t2w_001_newt2f_001.mnc.gz
/aaa/data/assembly/700759/w96/mri/processed/T2Vol/IPMSA_700759_w96_t2w_001_ct2f_001.mnc.gz
/aaa/data/assembly/310229/w96/mri/processed/ConsensusGd/IPMSA_310229_w96_t1c_001_gvf_001.mnc.gz
/aaa/data/assembly/310229/w96/mri/processed/NewT2/IPMSA_310229_w96_t2w_001_newt2f_001.mnc.gz
/aaa/data/assembly/310229/w96/mri/processed/T2Vol/IPMSA_310229_w96_t2w_001_ct2f_001.mnc.gz
/aaa/data/pic/310229/IPMSA_310229_w96_flair_001_162722_check.jpg
/aaa/data/pic/310229/IPMSA_310229_w96_mtOFF_001_162723_check.jpg
/aaa/data/pic/310229/IPMSA_310229_w96_pdw_001_162724_check.jpg
/aaa/data/pic/310229/IPMSA_310229_w96_t1c_001_162726_check.jpg
/aaa/data/pic/310229/IPMSA_310229_w96_t1c_001_gvf_001_285082_check.jpg
/aaa/data/pic/310229/IPMSA_310229_w96_t1p_001_162725_check.jpg
/aaa/data/pic/310229/IPMSA_310229_w96_t2w_001_162727_check.jpg
/aaa/data/pic/310229/IPMSA_310229_w96_t2w_001_ct2f_001_285077_check.jpg
/aaa/data/pic/310229/IPMSA_310229_w96_t2w_001_newt2f_001_285071_check.jpg
/aaa/data/pic/700759/IPMSA_700759_w96_flair_001_162488_check.jpg
/aaa/data/pic/700759/IPMSA_700759_w96_mtOFF_001_162489_check.jpg
/aaa/data/pic/700759/IPMSA_700759_w96_pdw_001_162490_check.jpg
/aaa/data/pic/700759/IPMSA_700759_w96_t1c_001_162492_check.jpg
/aaa/data/pic/700759/IPMSA_700759_w96_t1c_001_gvf_001_284706_check.jpg
/aaa/data/pic/700759/IPMSA_700759_w96_t1p_001_162491_check.jpg
/aaa/data/pic/700759/IPMSA_700759_w96_t2w_001_162493_check.jpg
/aaa/data/pic/700759/IPMSA_700759_w96_t2w_001_ct2f_001_284699_check.jpg
/aaa/data/pic/700759/IPMSA_700759_w96_t2w_001_newt2f_001_284693_check.jpg
/aaa/data/tarchive/2010/DCM_2010-05-19_ImagingUpload-16-19-BKCuuy.tar

DBD::mysql::db do failed: Cannot delete or update a parent row: a foreign key constraint fails (`IPMSA_LORIS`.`mri_upload`, CONSTRAINT `FK_mriupload_TarchiveID` FOREIGN KEY (`TarchiveID`) REFERENCES `tarchive` (`TarchiveID`)) at /bbb/IPMSA/bin/mri/tools//delete_imaging_upload.pl line 1612.
Issuing rollback() due to DESTROY without explicit disconnect() of DBD::mysql::db handle database=IPMSA_LORIS;host=111.222.333.44;port=3306; at /bbb/IPMSA/bin/mri/tools//delete_imaging_upload.pl line 1612.
Usage: /bbb/IPMSA/bin/mri/tools//delete_imaging_upload.pl [-profile file] [-ignore] [-backup_path path] [-protocol] [-form] [-uploadID list_of_uploadIDs]
            [-type list_of_scan_types] [-defaced] [-nosqlbk] [-nofilesbk]
===

Any ideas what can be happening?

Regards,
Alfredo.
The information in this e-mail is intended only for the person to whom it is addressed. If you believe this e-mail was sent to you in error and the e-mail contains patient information, please contact the Mass General Brigham Compliance HelpLine at http://www.massgeneralbrigham.org/complianceline . If the e-mail was sent to you in error but does not contain patient information, please contact the sender and properly dispose of the e-mail.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20201005/250c7f1b/attachment.html>