Datagrip: Unexpected update count received

Viewed 32

I have a table with 2 columns: sample_id and sample_period.

sample_id: it is an ID of samples stored in another table.

sample_period: it is an ID of chronologies which I stored in another table.

I could not make sample_id unique or primary as they can be duplicated (a sample can have more chronologies).

Example:

sample_id sample_period
377 2
377 3

I am using DataGrip to deal with my tables (MariaDB), but I cannot delete or update some rows. It is a large database for my PhD project, so recreating the table would be almost impossible at this point. Do you have any advice?

Whenever I try to delete or update a row I get the error: Unexpected update count received (Actual: 3, Expected: 1)

Thank you in advance!

EDIT: Log Log

0 Answers
Related