Fix too small activation stack for low transaction_max_spans values

[JonasKunz]

What does this PR do?

Fixes #3642. Tests have been adapted to reproduce the issue.

Checklist

• [x] This is a bugfix
  • [x] I have updated CHANGELOG.asciidoc
  • [x] I have added tests that would fail without this fix