data type mismatch error
Posted: 31 May 2018, 16:03
MantisBT Version 2.7.0
PHP Version 5.6.24
MantisBT Database Information
Schema Version 209
ADOdb Version 5.20.9
Unknowingly, two people in the same ticket, one a developer the other an administrator, the developer closes the ticket while at almost exactly the same time the admin changed the status and owner. Admin got this error message. Thinking this race condition could be mitigated by either using strict locking in mysql instead of opportunistic? Or adding code to "critical" actions such as status change that does a quick check to see if the ticket is still in a state the current instance thinks it is. If that made any sense...
PHP Version 5.6.24
MantisBT Database Information
Schema Version 209
ADOdb Version 5.20.9
Unknowingly, two people in the same ticket, one a developer the other an administrator, the developer closes the ticket while at almost exactly the same time the admin changed the status and owner. Admin got this error message. Thinking this race condition could be mitigated by either using strict locking in mysql instead of opportunistic? Or adding code to "critical" actions such as status change that does a quick check to see if the ticket is still in a state the current instance thinks it is. If that made any sense...