Database Error When Creating a Pull Request
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Environment
Postgres database
Symptoms
When creating a pull request from a project, the process fails with {{a database error has occurred}} message and the logs report:
1
2
3
4
Next Exception: org.postgresql.util.PSQLException: ERROR: character with byte sequence 0xef 0x88 0x90 in encoding "UTF8" has no equivalent in encoding "LATIN1"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:338)Cause
Your database client encoding is not using UTF-8.
Resolution
Set database client encoding to UTF-8
1
2
3
Check for the current encoding: show client_encoding;
Set the encoding: SET client_encoding = 'UTF8';
Ensure it's correctly set: show client_encoding;Was this helpful?