Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-30465

Make directory sync more robust when handling names with emoji characters

XMLWordPrintable

    • 2
    • 4
    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      NOTE: This suggestion is for Confluence Server. Using Confluence Cloud? See the corresponding suggestion.

      Directory sync via ldap connection will break if some condition fails to meet a constraint, collation, etc.

      Improvement request to digest that error, report it to the admin, and continue on with the sync through completion.

      Graceful handling of errors without breaking sync.

      For example:
      Mysql database, utf8 characterset, utf8_bin collation. User directory sync with ldap system. LDAP user has emoji in name. When directory sync occurs, confluence logs report this error:

      ERROR [scheduler_Worker-6] [atlassian.crowd.directory.DbCachingDirectoryPoller] pollChanges Error occurred while refreshing the cache for directory [ 13205505 ].
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not update: com.atlassian.crowd.model.user.InternalUser#17850980; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF0\x9F\x90\x9C' for column 'first_name' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF0\x9F\x90\x9C' for column 'first_name' at row 1

      Another example:

      ERROR [scheduler_Worker-4] [atlassian.crowd.directory.DbCachingDirectoryPoller] pollChanges Error occurred while refreshing the cache for directory [ 59146241 ].
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not update: [com.atlassian.crowd.model.user.InternalUser#69320708]; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF0\x9F\x8E\x88' for column 'first_name' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF0\x9F\x8E\x88' for column 'first_name' at row 1

      '\xF0\x9F\x90\x9C', turns out to be emoji ant. This occurred on mysql 5.1. Upgrading to mysql 5.5.3 and setting characterset on tables to utf8mb4 does not resolve the issue. See here for more details:
      http://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html

      Once upgraded to mysql 5.5.3 a command line client can insert an emoji character into the database and the database handles this fine. When Confluence tries to sync an emoji character, the sync breaks and Confluence throws an error.

            [CONFSERVER-30465] Make directory sync more robust when handling names with emoji characters

            Sen made changes -
            Workflow Original: JAC Suggestion Workflow 4 [ 3566672 ] New: JAC Suggestion Workflow 3 [ 4330043 ]
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow 2 [ 3178188 ] New: JAC Suggestion Workflow 4 [ 3566672 ]
            Status Original: RESOLVED [ 5 ] New: Closed [ 6 ]
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3040517 ] New: JAC Suggestion Workflow 2 [ 3178188 ]
            Adam Barnes (Inactive) made changes -
            Resolution New: Won't Do [ 10000 ]
            Status Original: Gathering Interest [ 11772 ] New: Resolved [ 5 ]

            Adam Barnes (Inactive) added a comment -

            Thank you for raising this suggestion.
            We regret to inform you that due to limited demand, we have no plans to implement it in the foreseeable future. In order to set expectations, we're closing this request now. Sometimes potentially valuable tickets do get closed where the Summary or Description has not caught the attention of the community. If you feel that this suggestion is valuable, consider describing in more detail or outlining how this request will help you achieve your goals. We may then be able to provide better guidance.
            For more context, check out our Community blog on our updated workflow for Suggestions
            Cheers,

            Confluence Product Management

            Adam Barnes (Inactive) added a comment - Thank you for raising this suggestion. We regret to inform you that due to limited demand, we have no plans to implement it in the foreseeable future. In order to set expectations, we're closing this request now. Sometimes potentially valuable tickets do get closed where the Summary or Description has not caught the attention of the community. If you feel that this suggestion is valuable, consider describing in more detail or outlining how this request will help you achieve your goals. We may then be able to provide better guidance. For more context, check out our Community blog on our updated workflow for Suggestions Cheers, Confluence Product Management
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing v4 [ 2538153 ] New: JAC Suggestion Workflow [ 3040517 ]
            SET Analytics Bot made changes -
            UIS Original: 1 New: 2
            SET Analytics Bot made changes -
            UIS Original: 2 New: 1
            SET Analytics Bot made changes -
            UIS Original: 0 New: 2
            SET Analytics Bot made changes -
            UIS Original: 2 New: 0

              Unassigned Unassigned
              rgoodwin Ryan Goodwin (Inactive)
              Votes:
              7 Vote for this issue
              Watchers:
              11 Start watching this issue

                Created:
                Updated:
                Resolved: