Duplicating records for hours worked on a user in ticket_change table in postgresql
|Reported by:||anebi||Owned by:||Colin Guthrie|
We noticed that there is a problem with duplicating records for work hours per user in table ticket_change in postgresql database. The problem is reproducing this way:
Go to a ticket and press: Start work.
Then without stopping the work, we just change resolution to something (for example Fixed) and apply changes. Then work is stopping and ticket is closing. After then in database i see 2 records for hours.
13 1235734626 anebi hours 0.0 2.81 13 1235734625 anebi comment 4 anebi worked on this ticket for 2 hours, 48 minut... 13 1235734625 anebi hours 0 2.81 13 1235734626 anebi comment 3 - Made some tests with PHPFileNavigator.
You see the hours field and value. They are the same. Only different is timestamp. This happens because worklog/timingandestimationplugin is recorded this 1 second before the other record.
I don't know witch one (worklog or timingandestimationplugin) is responsible for this.