SELECT … FOR UPDATE makes the databases enter to recovering mode

We have ## SELECT … FOR UPDATE query. It was working perfectly in 7.2. When we upgraded to 8.1 it stopped working and it makes the db crash. Is there any setting for that?

Can you give us a little more information on the issue. What is the exact FOR UPDATE query that is having issues? If you look in the datadir do you see any .stack files that may indicate a crash. Those files should have the crashing callstack. Can you show us those.

-Adam