Update upgrading guide about error handling in transactional callbacks

- Part of 16576
- [ci skip]
Merge pull request #16846 from prathamesh-sonpatki/document-error-handling-in-transactions-callbacks

Update upgrading guide about error handling in transactional callbacks [ci skip]