Yea turn off ssl if you are on local network and see if that helps... I suspect what is happening in my case, (and maybe yours), is the SSL connection is "renegotiating" and failing, which is documented elsewhere (google postgresql ssl renogotiation)
So far I have not seen this issue since I switched to a local connection. Although I have two other older rails apps running presumably with SSL and they have not exhibited this error. On Dec 19, 2:32 am, Tim Uckun <[email protected]> wrote: > 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.
