Jira (PDB-4553) PuppetDB 6.7.1 doesn't work with Azure Database for PostgreSQL

[Yury Bushmelev (JIRA)]

Title: Message Title

Yury Bushmelev created an issue   PuppetDB / PDB-4553 PuppetDB 6.7.1 doesn't work with Azure Database for PostgreSQL Issue Type: Bug Affects Versions: PDB 6.7.1 Assignee: Unassigned Components: PuppetDB Created: 2019/10/17 1:25 AM Priority: Normal Reporter: Yury Bushmelev I'm trying to install fresh PuppetDB to use with Azure Database for PostgreSQL 9.6 instance (PostgreSQL as a service). While PuppetDB 6.7.0 looks good (can connect to DB at least), v6.7.1 fails with following message: Oct 17 07:06:50 puppetp1 puppetdb[3065]: Execution error (IOException) at org.postgresql.core.UTF8Encoding/decode (UTF8Encoding.java:102). Oct 17 07:06:50 puppetp1 puppetdb[3065]: Illegal UTF-8 sequence: initial byte is 10xxxxxx: 160 Database is created in UTF-8 encoding with en-SG collation:  puppetdb=> \l puppetdb List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges ----------+----------+----------+---------+-------+----------------------- puppetdb | puppetdb | UTF8 | en-SG | en-SG | =T/puppetdb + | | | | | puppetdb=CTc/puppetdb I did some investigation and found it fails on 'show all' query which was introduced to check database settings in v6.7.1. I can see 'show all' query results in psql output without any issue though. I'll attach full trace and 'show all' results to this ticket a bit later. Will check is 6.7.0 really working too. Add Comment   This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.330138.1571300723000.4789.1571300760438%40Atlassian.JIRA.