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

Yury Bushmelev (JIRA)

unread,

Oct 17, 2019, 4:26:04 AM10/17/19

to puppe...@googlegroups.com

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.