Uploaded image for project: 'Artifactory Binary Repository'
  1. Artifactory Binary Repository
  2. RTFACT-17528

Regression: Emoji support removed in Artifactory 5.10 for MySQL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Resolution: Done
    • Affects Version/s: 5.10.0
    • Fix Version/s: 6.9.0
    • Component/s: NPM
    • Labels:
      None
    • Severity:
      Critical

      Description

      Symptoms: NPM packages that used to be published successfully in Artifactory cannot be published after upgrading.

      This looks to be due to a change in how NPM properties are created during the metadata calculation process.

      Steps to reproduce:

      1. Have an Artifactory 5.0.1 installed with a MySQL database and a separate Artifactory 6.X with a MySQL database
      2. Add an emoji to the "Description" field below (Jira does not support emojis):

      Save as a "package.json" file.

      {
      "name": "test-package",
      "version": "0.0.19",
      "description": "[EMOJI]",
      "main": "index.js",
      "scripts":

      { "test": "echo \"Error: no test specified\" && exit 1" }

      ,
      "author": "Pat",
      "license": "ISC",
      "publishConfig":

      { "registry": "<ART_URL>/api/npm/npm/" }

      ,
      "dependencies": {},
      "devDependencies": {},
      "maintainers": []

      }

      $ npm publish

      3. Note the publish goes through successfully

      4. Attempt to publish the same package to the Artifactory 6.3.3, and encounter a 500 error:

      2018-09-20 19:17:12,076 [http-nio-8081-exec-5] [ERROR] (o.a.r.c.e.GlobalExceptionMapper:48) - Failed to set properties on node: 47
      org.artifactory.storage.StorageException: Failed to set properties on node: 47

      [...]

      Caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x86 h...' for column 'prop_value' at row 1

       ** 

      No errors occur in Artifactory 5 when the publish goes through.

      This can affect users who are attempting to migrate Artifactory hosts and are using different versions for the target host.

       

        Attachments

          Issue Links

            Activity

                People

                Assignee:
                Dudim Dudi Morad (Inactive)
                Reporter:
                patrickr Patrick Russell
                Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved: