View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0025442 | mantisbt | db mssql | public | 2019-02-04 17:44 | 2019-03-16 20:20 |
Reporter | juliexn | Assigned To | cproensa | ||
Priority | normal | Severity | major | Reproducibility | random |
Status | closed | Resolution | fixed | ||
Platform | IE | OS | Windows | OS Version | 7 |
Product Version | 2.11.1 | ||||
Target Version | 2.20.0 | Fixed in Version | 2.20.0 | ||
Summary | 0025442: Wrong/duplicate bugnote_text_id in mantis_bugnote_table | ||||
Description | After we upgraded to MantisBT 2.11.1 in December 2018, users have noticed phantom notes added to their ticket/issue with their names on it. A query of the database shows that we have multiple bug_id pointing to the same bugnot_text_id. Attached is a screenshot showing the result of the select statement below. It show three bugnote pointing to the same bugnote_text. Those 3 notes were submitted within 15 seconds by different users in different issue#. Can you please advise what the issue/cause may be? select id, bug_id, reporter_id, bugnote_text_id, view_state, | ||||
Steps To Reproduce | Different users adding notes to different issue # withing seconds of each other. This issue appears to be random. However, we've had 83 instance of this occurring (83 bugnot_text_id, 181 issue#) since Dec 10, 2018. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
are you using sql-server? with mssql it uses SELECT IDENT_CURRENT to get the id of the inserted note, which:
|
|
juliexn, This is the first time I see such an issue. The provided information is not sufficient to provide help in resolving the issue.
Why did you use this outdated version? I recommend to upgrade to latest stable version (2.19.0 at the moment). |
|
@atrol |
|
We are using SQL server. The reason we are using an outdated version of MantisBT has to do we the business requirement for using IE 11 in compatibility mode and to display realname instead of username. We've tried newer version of MantisBT but the primary problem is that it doesn't render correctly in IE compatibility mode. Below are answers to your questions about our build: |
|
@juliexn |
|
@cproensa |
|
yes, with a debug session that is forced to wait between both inserts. |
|
Some general remarks
I assume you are talking about this effect https://mantisbt.org/forums/viewtopic.php?f=3&t=25649
Is there still an issue after all those changes in 2.15.0 ?
I hope you are aware that
Your countdown for upgrades is running :-) |
|
@atrol @cproensa |
|
MantisBT: master c0c7eb1c 2019-02-04 13:49 Committer: atrol Details Diff |
Fix mssql concurrent insert id The implementation of db_insert_id() in mssql relied on IDENT_CURRENT making it not thread safe. Modify it to use ADOdb native implementation, based on SCOPE_IDENTITY() which is session independent. Fixes: 0025442 |
Affected Issues 0025442 |
|
mod - core/database_api.php | Diff File |