On Sun, Dec 19, 2010 at 7:26 PM, Jim Morris <[email protected]> wrote:
> I've spent the day trying to track this down. I am not seeing it with
> my older rails/activerecord app, only with the newer rails 3.0.3/
> sequel app.
I am seeing it using activerecord on rails 3.0.3
The problem just occured and although the client is constantly putting
out errors like this
PGError: lost synchronization with server: got message type "o",
length 544501536
PGError: lost synchronization with server: got message type "�", length
-65536
PGError: lost synchronization with server: got message type "�", length
-65536
PGError: lost synchronization with server: got message type "�", length
-65536
PGError: lost synchronization with server: got message type "o",
length 544501536
PGError: lost synchronization with server: got message type
"o", length 544501536
PGError: lost synchronization with server: got message type
"o", length 544501536
there is nothing in the postgres log.
>
> I "think" it may be the ssl connection to postgresql. On newer Ubuntu
> systems a local tcp connection uses ssl by default (kind of odd but
> still).
>
> What I did was to remove the host,username,password settings from
> database.yml which forced it to use a local unix pipe to connect, so
> far I have not seen this error, but it is pretty infrequent.
>
I can't do this because my database is on another server.
> You can also switch off SSL in the posgresql,conf file., check to see
> if ssl is set to true in that file, or when yo connect at the command
> line with
>
>> psql -h localhost yourdbname
>
> if it prints out SSL connection (cipher: DHE-RSA-AES256-SHA, bits:
> 256) then it is using SSL.
It's definitely using SSL. I might try turning off the SSL and see if
that does any good.
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
