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
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
