Session error: "Query error: Commands out of sync; you can't run this command now..."

@Volder ,

Have you tried the query directly in the database (to see if an error appears)? Are you sure that the input data is clean?  Has any of the data field types in the table changed?

The problem is that there is no particular query that produces it. On the local environment I can't replicate it.
As I mentioned on the production it appears only several times a day out of thousands of user visits, so it is very rare case, which I believe would be hard to replicate.
Maybe something connected with heavy load.

What do you mean by input data and clean?

No data types were changed, neither application, nor the database was changed at all, it was only PHP upgrade 7.2 -> 7.4 and then the issue appeared.