utf8 4 bytes on SQL Server 2014 Standard
We've just came across a major issue in our production Redmine instance.
Description of the problem.
One of our coworkers tried to create a ticket containing a smiley face (copy paste from MS Outlook).
Form submission resulted in a 500 server error.
She removed the smiley face and the issue had been successfully submitted. Then other coworkers created about 10 more issues. The system was running fine. However the failed request created an open transaction.
We suspect that other issues where created in the scope of this running transaction as nested transactions. The transaction was active for about 24 hours and was blocking some of our housekeeping jobs and we had to kill it. As a result we lost all 10 issues that were (successfully) submitted after the one with the smiley face in it (resulting in a 500 error).
I was able to recreate the problem folowing the steps above.