[bitbucket server] emoji in PR is triggering 500 error in BB

[niorg]

Running renovate 20.19.2 docker against bitbucket server 7.0.1 is getting error:

FATAL: Failed to update PR (repository=xx/xxx)
         ...
         "body": {
           "errors": [
             {
               "context": null,
               "message": "A database error has occurred.",
               "exceptionName": "com.atlassian.bitbucket.DataStoreException"
             }
           ]
         },
         "message": "Response code 500 (Internal Server Error)",
         "stack": "HTTPError: Response code 500 (Internal Server Error)\n    at EventEmitter.<anonymous> (/usr/src/app/node_modules/got/source/as-promise.js:74:19)\n    at runMicrotasks (<anonymous>)\n    at processTicksAndRejections (internal/process/task_queues.js:97:5)"
       }

bitbucket server is logging this:
o.h.e.jdbc.spi.SqlExceptionHelper Data truncation: Incorrect string value: '\xF0\x9F\x93\x85 *...' for column `stash`.`sta_pull_request`.`description` at row 1

Version 19.xx is running fine, changing unicodeEmoji to False in the renovate.json of the repository is not making a difference either.

[rarkins]

Which database are you using, and exactly how did you try to configure unicodeEmoji?

[niorg]

This is on MariaDB 10.3

I modified the renovate.json in one of the discovered repositories in the project like this:

{
  "$schema": "https://docs.renovatebot.com/renovate-schema.json",
  "unicodeEmoji": false
}

But PR's on that repository still have this issue.

[rarkins]

You need to configure it in the bot and not repo

[niorg]

Ah yes, thank you, that seems to work. Wouldn't it make sense to make this the default for bitbucket server platform?

[rarkins]

There was some discussion in #3799 about it. The problem is specific to MySql/MariaDB, not Bitbucket Server itself.

Atlassian's documentation says "MySQL and MariaDB, while supported by Bitbucket Server, are currently not recommended"

[viceice]

Emojis are working fine on bitbucket server with mssql server. We use them since available.

[rarkins]

Let's add it to our self-hosted instructions for Bitbucket Server

[ronaldploeger]

Hi @rarkins,
Hi @niorg,

I am having the same problem with Bitbucket Server when Renovate tries to create the onboarding PR

Incorrect string value: '\xF0\x9F\x9A\xA6 T...' for column 'description' at row 1]

But I do not understand what you guys meant with "You need to configure it in the bot and not repo".

Can you please elaborate where I need to configure this or point me to the self-hosted instructions for Bitbucket Server where it has been documented.

Thank you!

[viceice]

@ronaldploeger Are you using MariaDB / MySQL for your Bitbucket server? see here: #3799 (comment)

Please checkout https://docs.renovatebot.com/configuration-options/#unicodeemoji for a workaround

[ronaldploeger]

@viceice Thank you.

I have now understood that I need to add this to my self-hosting RENOVATE_CONFIG_FILE, which now looks similar to this and it works like a charm:

module.exports = {
  endpoint: 'https://myBitbucketServer.com',
  platform: 'bitbucket-server',
  username: 'myUserName',
  unicodeEmoji: false,
  onboardingConfig: {
    extends: ['config:base'],
  }
}

[renovate-release]

🎉 This issue has been resolved in version 24.89.2 🎉

The release is available on:

• GitHub release
• 24.89.2

Your semantic-release bot 📦🚀