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

[David Hartveld]

Op 15-07-11 15:46, Marcos Ortiz schreef:
> 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?

I believe this to be irrelevant to my original problem, because in my 
experimentation setup, I trust all clients.

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

Yes.

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

I just checked the docs[1] and read that prepared statements are only 
unsupported in parallel mode (search for 'prepared'), so this shouldn't 
be a problem, right? In fact, the application ran successfully for some 
time, before the PSQLException was thrown while executing a regular 
SELECT statement.

Any other thoughts?
David

[1] http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html


> 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
>>>
>>
>