[pgpool-general: 5126] Re: Issue with pgpool 3.5.4 and JDBC

[Felipe Garcia]

Hi Dennis,

I don't have logging enabled. But one thing I forgot to mention, in my tests I am using "shmem", and error happens with "memcache" as well.

Thanks,

Sent from my iPhone

> On 15 Nov 2016, at 14:01, Dennis Gearon <gearond at gmail.com> wrote:
> 
> On Nov 15, 2016 3:08 AM, "Felipe Garcia" <felipecpg at gmail.com> wrote:
> >
> > I have a pgpool 3.5.4 with memcache enabled, and I use it to connect to Redshift.
> >
> > I wrote two simple programs, one in Java (JDBC postgresql-9.4.1212.jre6.jar) and another one in Python (using psycopg2 postgres package) that just connects to pgpool, and execute a simple query (eg: select * from customer limit 10;) and I've noticed strange and different behaviors. I also ran the queries using the command line tool psql.
> >
> > 1) Using JDBC with pgpool with caching enabled I get an error
> >
> > 2016-11-15 10:56:27: pid 31043: FATAL:  Backend throw an error message
> >
> > 2016-11-15 10:56:27: pid 31043: DETAIL:  Exiting current session because of an error from backend
> >
> > 2016-11-15 10:56:27: pid 31043: HINT:  BACKEND Error: "portal "pgpool31043" does not exist"
> >
> >
> > 2) Using JDBC with pgpool with caching disabled it works
> >
> > 3) Using psycopg2 or psql command line with pgpool with caching either enabled or disabled it works
> >
> > Can someone help me understand why only JDBC is not working?
> >
> >
> > Thanks
> >
> > Felipe Garcia
> >
> > Aviso: Geralmente, email é a melhor forma de me encontrar. Eu tentarei responder a sua mensagem o mais rápido possível.
> > Note: Generally, email is the best way to reach me.  I will respond to your message as soon as possible
> >
> >
> > _______________________________________________
> > pgpool-general mailing list
> > pgpool-general at pgpool.net
> > http://www.pgpool.net/mailman/listinfo/pgpool-general
> >
> 
> Do you have logging enabled in the men cache setup? Is memcache being accessed in the JDBC case? A guess: JDBC and memcache are interfering with each other?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161115/5c524248/attachment.html>