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

[Dennis Gearon]

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/84612c6e/attachment.html>