Re: Random crashes on getConnection

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(dot)androme(dot)phemium(dot)statistics(dot)EligibleCustomerList(at)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(dot)poca(at)androme(dot)es <mailto:ramon(dot)poca(at)androme(dot)es>