Missing values in sequence after error

Issue description

When an error occurs in a POST service or a trigger after a sequence has been used, the sequential values are lost and the sequence misses the respective numbers.

Developer comments

E.g. in the case at hand 3 invoices were create in one POST request R1. Before that the sequence was in state 10, so the next value should be 11 Thus the invoices create in R1 should use the numbers 11,12,13. But at the end of R1 an error happend: a frozen topic was modified. This resulted in a rollback. But the sequence is not rolled back. Therefore the values 11,12,13 were never handed out, since instead of going back to state 10, it remained in state 13.

Looking at the source code revealed that there is probably more bugs lurking in the dark. This issue should serve as a container.

Affects

sequence(PHP API Function)

Reporting date

2024-01-10

Reported by

Robert Cerny

Resolving date

2024-01-22

Resolved by

Robert Cerny

Resolved in version

Topincs 9.4.0

Part of

Improve sequence(Change)

Work sessions3

12718

12730

12731