On Thursday, February 16, 2017 at 4:31:57 PM UTC-8, s...@la-z-boy.com wrote: > > Hi everyone, > > I'm trying to do my first ever install of PuppetDB. I'm installing > PuppetDB 4.3 from RPM with Postgres 9.4. When I try to start PuppetDB I > get the following errors (removed some of the non-important java debugging > lines): > > 2017-02-16 14:19:54,539 INFO [p.p.s.migrate] Applying database migration > version 43 > 2017-02-16 14:19:54,570 ERROR [p.p.s.migrate] Caught SQLException during > migration > java.sql.BatchUpdateException: Batch entry 1 CREATE AGGREGATE md5_agg > (BYTEA) > ( > sfunc = dual_md5, > stype = bytea, > initcond = '\x00' > ) was aborted. Call getNextException to see the cause. > > 2017-02-16 14:19:54,571 ERROR [p.p.s.migrate] Unravelled exception > org.postgresql.util.PSQLException: ERROR: invalid byte sequence for > encoding "UTF8": 0x00 > > > Any advice would be appreciated. >
Hi, Just to be sure, I verified that PuppetDB works as expected in Oracle Linux 7.3. I posted my Vagrant setup here: https://gist.github.com/mullr/c09d87332edb5fb074c298620fd3df24 How does that compare to the way you installed PostgreSQL and PuppetDB? Do you think you can reproduce the issue in that context? As my colleagues said, PuppetDB should complain if you're running against an older verison of PostgreSQL, so that doesn't really seem likely to be the problem. My best guess is that it's a database configuration issue that we haven't seen before. In any case, this is a very strange problem and we'd like to get to the bottom of it. - Russell -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/061882d4-6891-4447-8a90-c6eabdf70cfb%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
