Staledataerror: While Updating A Row In A Table With Error : Expected To Update 1 Row(s); 2 Were Matched

I am trying to update a row in a table based on some filters. I could get the row_object and i could update it if the number of rows is one and if more than one it throws StaleData

Solution 1:

I had a similar problem (primarily due to my lack of attention-to-detail). The database table key was different from the key defined in my sql_alchemy models (for that table), which lead sql_alchemy to use a column (the old key) that matched more than one row in the database during the update step of the transaction.

Updating the sql_alchemy model primary key to the actual db primary key fixed the problem.