spyglass icon indicating copy to clipboard operation
spyglass copied to clipboard

Low verbosity error `1217` on delete prevents cascade

Open samuelbray32 opened this issue 1 year ago • 31 comments

Describe the bug Attempting to delete an entry within the Session table results in the following error: IntegrityError: (1217, 'Cannot delete or update a parent row: a foreign key constraint fails')

To Reproduce Steps to reproduce the behavior:

  1. Run (Session & {"nwb_file_name": 'samtest20230817_.nwb'}).delete({"nwb_file_name": 'samtest20230817_.nwb'})

Expected behavior The entry and all other downstream should be removed

Additional context The only thing done with this nwb_file was insertion into spyglass, if that helps narrow down potential schema permission errors

samuelbray32 avatar Aug 31 '23 22:08 samuelbray32