[Pgpool-general] In load-balancing / master-slave / streaming replication mode, PSQLException 'portal "" does not exist' is thrown

[Marcos Ortiz]

I saw a unique error on the log:
Jul 15 10:37:27 pg-mx-srv pgpool: 2011-07-15 10:37:27 ERROR: pid 23970: 
pool_init_pool_passwd: couldn't open /etc/pgpool2/pool_passwd. reason: 
Permission denied

Which are the permissions of this file on your system?
Which is the log directory and its permissions?

Are you using JDBC for establish the connection with your Java application?

You should read the pgpool's resctrictions with JDBC because, this 
driver uses PREPARED STATEMENT and it is not supported yet by the 
middleware.



El 7/15/2011 4:55 AM, David Hartveld escribió:
> Op 14-07-11 20:29, Marcos Ortiz schreef:
>> Can you send to us the pgpool's logs?
>
> Attached the log file (+/- 665 kB). Note that it unpacks into a 56+ MB
> file.
>
>
>> On 07/14/2011 11:53 AM, David Hartveld wrote:
>>> Hi all,
>>>
>>> I'm experimenting with PGPool2 v3.0.4 in load-balancing master-slave
>>> mode with streaming replication, with two slaves. I'm running a java
>>> application, and once in a while a PSQLException with the message
>>> 'org.postgresql.util.PSQLException: ERROR: portal "" does not exist' is
>>> thrown when executing a statement. I was wondering whether this is a
>>> known problem - I regularly run into it when using multiple (test)
>>> clients to connect to the server.
>>>
>>> I've attached the pgpool conf file I'm using. If more information is
>>> needed to diagnose this problem, I can provide it.
>>>
>>> Thanks,
>>> David Hartveld
>>>
>>>
>>> _______________________________________________
>>> Pgpool-general mailing list
>>> Pgpool-general at pgfoundry.org
>>> http://pgfoundry.org/mailman/listinfo/pgpool-general
>>
>

-- 
Marcos Luís Ortíz Valmaseda
  Software Engineer (UCI)
  Linux User # 418229
  http://marcosluis2186.posterous.com
  http://twitter.com/marcosluis2186