ok so I got rid of caching and now in the pgpool.log I see the snippet below. Note that I can use pgpool to quesry the puppetdb to get data 2013-07-17 13:01:28 ERROR: pid 1193: Bind: cannot get parse message "S_1" 2013-07-17 13:01:28 LOG: pid 1193: do_child: exits with status 1 due to error 2013-07-17 13:01:28 LOG: pid 1178: ProcessFrontendResponse: failed to read kind from frontend. frontend abnormally exited 2013-07-17 13:01:28 LOG: pid 1192: ProcessFrontendResponse: failed to read kind from frontend. frontend abnormally exited 2013-07-17 13:01:28 LOG: pid 1191: ProcessFrontendResponse: failed to read kind from frontend. frontend abnormally exited 2013-07-17 13:01:28 LOG: pid 1189: ProcessFrontendResponse: failed to read kind from frontend. frontend abnormally exited 2013-07-17 13:01:28 LOG: pid 1187: ProcessFrontendResponse: failed to read kind from frontend. frontend abnormally exited 2013-07-17 13:01:28 LOG: pid 1185: ProcessFrontendResponse: failed to read kind from frontend. frontend abnormally exited 2013-07-17 13:01:28 LOG: pid 1181: ProcessFrontendResponse: failed to read kind from frontend. frontend abnormally exited 2013-07-17 13:01:28 LOG: pid 1179: ProcessFrontendResponse: failed to read kind from frontend. frontend abnormally exited 2013-07-17 13:01:28 LOG: pid 1183: ProcessFrontendResponse: failed to read kind from frontend. frontend abnormally exited 2013-07-17 13:01:28 LOG: pid 1190: ProcessFrontendResponse: failed to read kind from frontend. frontend abnormally exited 2013-07-17 13:01:28 LOG: pid 1188: ProcessFrontendResponse: failed to read kind from frontend. frontend abnormally exited On Friday, July 12, 2013 1:32:34 PM UTC-4, Robert Bachmann wrote:
> I am trying to set up puppet in an HA environment using pgpool to connect > to the postgres DB and I get this kind of thing in the pgpool log any ideas? > > 2013-07-12 11:56:45 LOG: pid 12275: DB node id: 1 backend pid: 732 > statement: DISCARD ALL > 2013-07-12 11:57:47 LOG: pid 12222: connection received: host= > xlabsvcdb2.hostname.com port=49722 > 2013-07-12 11:57:47 LOG: pid 12214: connection received: host= > xlabsvcdb2.hostname.com port=49723 > 2013-07-12 11:57:47 LOG: pid 12275: connection received: host= > xlabsvcdb2.hostname.com port=49726 > 2013-07-12 11:57:47 LOG: pid 12213: connection received: host= > xlabsvcdb2.hostname.com port=49727 > 2013-07-12 11:57:47 LOG: pid 12216: connection received: host= > xlabsvcdb2.hostname.com port=49730 > 2013-07-12 11:57:47 LOG: pid 12212: connection received: host= > xlabsvcdb2.hostname.com port=49731 > 2013-07-12 11:57:47 LOG: pid 12209: connection received: host= > xlabsvcdb2.hostname.com port=49734 > 2013-07-12 11:57:47 LOG: pid 12224: connection received: host= > xlabsvcdb2.hostname.com port=49737 > 2013-07-12 11:57:47 LOG: pid 12207: connection received: host= > xlabsvcdb2.hostname.com port=49738 > 2013-07-12 11:57:47 LOG: pid 12223: connection received: host= > xlabsvcdb2.hostname.com port=49741 > 2013-07-12 11:57:47 LOG: pid 12205: connection received: host= > xlabsvcdb2.hostname.com port=49742 > 2013-07-12 11:57:47 LOG: pid 12218: connection received: host= > xlabsvcdb2.hostname.com port=49745 > 2013-07-12 11:57:47 ERROR: pid 12193: Child process 12222 was terminated > by segmentation fault > 2013-07-12 11:57:47 LOG: pid 12214: ProcessFrontendResponse: failed to > read kind from frontend. frontend abnormally exited > > and this in teh puppetdb log > > 2013-07-12 11:57:47,737 ERROR [main] [puppetlabs.utils] Uncaught exception > org.postgresql.util.PSQLException: This connection has been closed. > at > org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714) > at > org.postgresql.jdbc2.AbstractJdbc2Connection.getAutoCommit(AbstractJdbc2Connection.java:680) > at > com.jolbox.bonecp.ConnectionHandle.getAutoCommit(ConnectionHandle.java:587) > at > clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:200) > at > com.puppetlabs.puppetdb.scf.migrate$migrate_BANG_.invoke(migrate.clj:379) > at > com.puppetlabs.puppetdb.cli.services$_main$fn__10279.invoke(services.clj:396) > at > clojure.java.jdbc.internal$with_connection_STAR_.invoke(internal.clj:186) > at > com.puppetlabs.puppetdb.cli.services$_main.doInvoke(services.clj:394) > at clojure.lang.RestFn.invoke(RestFn.java:421) > at clojure.lang.Var.invoke(Var.java:419) > at clojure.lang.AFn.applyToHelper(AFn.java:163) > at clojure.lang.Var.applyTo(Var.java:532) > at clojure.core$apply.invoke(core.clj:601) > at com.puppetlabs.puppetdb.core$_main.doInvoke(core.clj:79) > at clojure.lang.RestFn.applyTo(RestFn.java:137) > at com.puppetlabs.puppetdb.core.main(Unknown Source) > 2013-07-12 11:57:47,759 INFO [Thread-4] [cli.services] Shutdown request > received; puppetdb exiting. > -- 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 post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users. For more options, visit https://groups.google.com/groups/opt_out.
