Обсуждение: Random crashes on getConnection

I've traced the crash to:

org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(PGStream,
ProtocolConnectionImpl, Logger) line: 470

For some reason, client_encoding gets changed back and forth from
UNICODE to LATIN9. When it's LATIN9, it causes the exception.

In my connection URL/parameters I do not force any encoding. LATIN9 is
the encoding the database is set to. What can be causing this switch?

(Message that caused the exception: beresp = 83 (E),
client_encoding=LATIN9)


Any ideas?


-----------
 >I get random exceptions on GetConnection() on a Quartz-based job.
 >Sometimes everything works, and sometimes I get a "Protocol Error.
 >Session setup failed". Does anybody know what might be happening?

 >Client: Both postgresql-8.3-604.jdbc4.jar and
 >postgresql-8.4dev-700.jdbc4.jar.
 >Server: Postgres 8.1. The databases are stored in LATIN9 encoding.
 >JVM: java-6-sun-1.6.0.12

 >SEVERE: com.androme.phemium.statistics.EligibleCustomerList@3b1d04
 >org.postgresql.util.PSQLException: Protocol error.  Session setup >failed.
 >       at
 >org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:481)
 >       at
 >org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101)
 >       at
--
<b>Ramon Poca</b> <br/>
<a href="mailto:ramon.poca@androme.es">ramon.poca@androme.es</a>

And in a quick reply to myself: PGPOOL

The damn thing was installed on postgres port, and when reused a
connection from a php client (using LATIN9), broke the whole thing.

Please, someone add this to the documentation/FAQ/whatever.

Ramon Poca escribió:
> I've traced the crash to:
>
> org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(PGStream,
> ProtocolConnectionImpl, Logger) line: 470
>
> For some reason, client_encoding gets changed back and forth from
> UNICODE to LATIN9. When it's LATIN9, it causes the exception.
>
> In my connection URL/parameters I do not force any encoding. LATIN9 is
> the encoding the database is set to. What can be causing this switch?
>
> (Message that caused the exception: beresp = 83 (E),
> client_encoding=LATIN9)
>
>
> Any ideas?
>
>
> -----------
> >I get random exceptions on GetConnection() on a Quartz-based job.
> >Sometimes everything works, and sometimes I get a "Protocol Error.
> >Session setup failed". Does anybody know what might be happening?
>
> >Client: Both postgresql-8.3-604.jdbc4.jar and
> >postgresql-8.4dev-700.jdbc4.jar.
> >Server: Postgres 8.1. The databases are stored in LATIN9 encoding.
> >JVM: java-6-sun-1.6.0.12
>
> >SEVERE: com.androme.phemium.statistics.EligibleCustomerList@3b1d04
> >org.postgresql.util.PSQLException: Protocol error.  Session setup
> >failed.
> >       at
> >org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:481)
>
> >       at
> >org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101)
>
> >       at


--
*Ramon Poca*
ramon.poca@androme.es <mailto:ramon.poca@androme.es>

On Wed, 10 Jun 2009, Ramon Poca wrote:

> And in a quick reply to myself: PGPOOL
>
> The damn thing was installed on postgres port, and when reused a connection
> from a php client (using LATIN9), broke the whole thing.
>
> Please, someone add this to the documentation/FAQ/whatever.

It seems like a pgpool bug and should probably be reported there.  If
pgpool is ignoring the JDBC driver's connection setup parameters that's
not the JDBC drivers fault.

Kris Jurka