<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>Hi Dennis,</div><div id="AppleMailSignature"><br></div><div id="AppleMailSignature">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.</div><div id="AppleMailSignature"><br></div><div id="AppleMailSignature">Thanks,<br><br>Sent from my iPhone</div><div><br>On 15 Nov 2016, at 14:01, Dennis Gearon <<a href="mailto:gearond@gmail.com">gearond@gmail.com</a>> wrote:<br><br></div><blockquote type="cite"><div><p dir="ltr"></p>
<p dir="ltr">On Nov 15, 2016 3:08 AM, "Felipe Garcia" <<a href="mailto:felipecpg@gmail.com">felipecpg@gmail.com</a>> wrote:<br>
><br>
> I have a pgpool 3.5.4 with memcache enabled, and I use it to connect to Redshift.<br>
><br>
> 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.<br>
><br>
> 1) Using JDBC with pgpool with caching enabled I get an error<br>
><br>
> 2016-11-15 10:56:27: pid 31043: FATAL: Backend throw an error message<br>
><br>
> 2016-11-15 10:56:27: pid 31043: DETAIL: Exiting current session because of an error from backend<br>
><br>
> 2016-11-15 10:56:27: pid 31043: HINT: BACKEND Error: "portal "pgpool31043" does not exist"<br>
><br>
><br>
> 2) Using JDBC with pgpool with caching disabled it works<br>
><br>
> 3) Using psycopg2 or psql command line with pgpool with caching either enabled or disabled it works<br>
><br>
> Can someone help me understand why only JDBC is not working?<br>
><br>
><br>
> Thanks<br>
><br>
> Felipe Garcia<br>
><br>
> Aviso: Geralmente, email é a melhor forma de me encontrar. Eu tentarei responder a sua mensagem o mais rápido possível.<br>
> Note: Generally, email is the best way to reach me. I will respond to your message as soon as possible<br>
><br>
><br>
> _______________________________________________<br>
> pgpool-general mailing list<br>
> <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
></p>
<p dir="ltr">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?</p>
</div></blockquote></body></html>