Improve sequence

Issue description

The Topincs PHP API function "sequence" has been around for a while, but in larger high load systems it might run into trouble: duplicate or missing numbers. Thouroughly test sequences so that there is no problems when there is simultaneous requests or errors. Also write out log message for everything affecting the sequence.

Developer comments

Built the test infrastructure and confirmed that a frozen topic modification in either the service directly (after a sequence call) or in a trigger running at the end of the service call will waste the numbers generated. This is the confirmation of [12689, this bug].

Implemented a test that confirms that concurrent requests are handled correctly: requests are denied until the lock is released.

Affects

sequence(PHP API Function)

Reporting date

2024-01-20

Reported by

Robert Cerny

Resolving date

2024-01-24

Resolved by

Robert Cerny

Resolved in version

Topincs 9.4.0

Has sub issue

Missing values in sequence after error(Bug)

Work sessions3

12729

12739

12741