I add formula fild to form that's have around 7k row, all was ok, but in view formula value is empty.
I make experiments, add an other formula with value 1, and see same story. As i know formula value recal after row update, so i update some rows, w/o change filds values, and formula calcs in updated row, i try more and more, some to all was ok, some a have error "
Deadlock found when trying to get lock; Try restarting transaction, message from server: "Lock wait timeout exceeded; try restarting transaction"
Failed to update data."
how we can solve this error ?