grizzly-jersey and undertow-jersey: MySQL deadlock part 2

[zloster]

Lowering the JDBC pooled connections to 192 haven't resolved the problem. Next steps to try:

• Lower the thread count in the worker pool;
• Lower the pooled connections value;

But how the code manages to make 200+ waiting writing transactions with 192 connections?

[zloster]

The mystery is no mystery anymore: I've missed the fact that there IS really a transaction deadlocks. See PR №5239 in the parent repository.

So sorting by id should be added for the update statements.