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

      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

        1. Artifactory-5X-description.png
          48 kB
          Patrick Russell
        2. Artifactory-5X-npmInfo.png
          50 kB
          Patrick Russell
        3. package.json
          0.7 kB
          Patrick Russell

          Issue Links

            Activity

                People

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

                  Dates

                  Created:
                  Updated:
                  Resolved: