Project identifier - multiple adds same time

Added by Zach Hamman over 6 years ago

This question came up in our shop: If 2+ people attempt to create a new project at the same time, what happens with the identifier column?
We are using sequential identifiers, so there is a dependency on the last project in the table. We're seeing a possible issue with saving new projects. If this is not the case, please explain how redmine would handle this situation.

Replies (1)

RE: Project identifier - multiple adds same time - Added by Etienne Massip over 6 years ago

Please post in Open discussion forum, this is not development related.

Zach Hamman wrote:

This question came up in our shop: If 2+ people attempt to create a new project at the same time, what happens with the identifier column?

BTW, the new Project will get the identifier following the identifier of the last created project in the alphanumerical order when being persisted in DB, not when you open the new Project screen.

Thus, if you try to create 2 projects at the same time, the secondly persisted project will get the successor of the id of the firstly persisted.

We're seeing a possible issue with saving new projects.

Can't see, what would that be?

(1-1/1)