Defect #27769

utf8 4 bytes on SQL Server 2014 Standard

Added by Jan Wójcik over 4 years ago. Updated over 4 years ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Database
Target version:-
Resolution: Affected version:3.4.2

Description

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).

http://www.fileformat.info/info/unicode/char/1f60a/index.htm

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.

BR
Jan

2.jpg (19.7 KB) Jan Wójcik, 2017-12-09 22:03

1.jpg (77.9 KB) Jan Wójcik, 2017-12-09 22:03

History

#1 Updated by Toshi MARUYAMA over 4 years ago

  • Subject changed from Major issue with Redmine 3.4.2.stable running on SQL Server 2014 Standard to utf8 4 bytes on SQL Server 2014 Standard
  • Priority changed from High to Normal

#2 Updated by Toshi MARUYAMA over 4 years ago

  • Description updated (diff)

Also available in: Atom PDF