[BUGS] BUG #5804: Connection aborted after many queries.

2010-12-29 Thread Paul J. Davis
The following bug has been logged online: Bug reference: 5804 Logged by: Paul J. Davis Email address: paul.joseph.da...@gmail.com PostgreSQL version: 9.0.2 Operating system: OS X 10.6.5, Ubuntu 10.04 Description:Connection aborted after many queries. Details: After

Re: [BUGS] BUG #5804: Connection aborted after many queries.

2010-12-29 Thread Paul Davis
On Wed, Dec 29, 2010 at 10:30 AM, Paul J. Davis paul.joseph.da...@gmail.com wrote: The following bug has been logged online: Bug reference:      5804 Logged by:          Paul J. Davis Email address:      paul.joseph.da...@gmail.com PostgreSQL version: 9.0.2 Operating system:   OS X 10.6.5,

Re: [BUGS] BUG #5804: Connection aborted after many queries.

2010-12-29 Thread Kevin Grittner
Paul J. Davis paul.joseph.da...@gmail.com wrote: After running many queries (millions) a connection will report an error that the server has unexpectedly closed the connection. What message are you getting? (Copy/paste is a good thing.) What do you see in the server log at the time of

Re: [BUGS] BUG #5804: Connection aborted after many queries.

2010-12-29 Thread Paul Davis
On Wed, Dec 29, 2010 at 10:58 AM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Paul J. Davis paul.joseph.da...@gmail.com wrote: After running many queries (millions) a connection will report an error that the server has unexpectedly closed the connection. What message are you getting?  

Re: [BUGS] BUG #5804: Connection aborted after many queries.

2010-12-29 Thread Tom Lane
Paul Davis paul.joseph.da...@gmail.com writes: And this intriguing error in the server logs from around that time: 2010-12-28 18:40:02 EST LOG: SSL renegotiation failure 2010-12-28 18:40:02 EST LOG: SSL failed to send renegotiation request 2010-12-28 18:40:02 EST LOG: SSL renegotiation

Re: [BUGS] BUG #5804: Connection aborted after many queries.

2010-12-29 Thread Tom Lane
Paul Davis paul.joseph.da...@gmail.com writes: On Wed, Dec 29, 2010 at 11:27 AM, Tom Lane t...@sss.pgh.pa.us wrote: In all cases, you were testing a client against a server on a different machine, right? Yeah, all failures were between separate machines with various versions of OpenSSL that

[BUGS] BUG #5806: Julian Date routine miscalculates.

2010-12-29 Thread Leslie Satenstein
The following bug has been logged online: Bug reference: 5806 Logged by: Leslie Satenstein Email address: lsatenst...@yahoo.com PostgreSQL version: 8.4 + 9.0 Operating system: Linux 64bit Description:Julian Date routine miscalculates. Details: I found the Julian

Re: [BUGS] BUG #5806: Julian Date routine miscalculates.

2010-12-29 Thread Tom Lane
Leslie Satenstein lsatenst...@yahoo.com writes: I tested and found the algorithm in Postgres to have the day before January 1,0001 calculating as December 31, even though the world calculates the day before January 1,0001 as December 31,-0001. As I already replied on the other list, this

[BUGS] BUG #5807: psql fails to launch with Cannot read termcap database; using dumb terminal settings. Aborted

2010-12-29 Thread Gabe Nell
The following bug has been logged online: Bug reference: 5807 Logged by: Gabe Nell Email address: g...@kikini.com PostgreSQL version: 9.0.2 Operating system: Linux Ubuntu 10.04 Description:psql fails to launch with Cannot read termcap database; using dumb terminal

Re: [BUGS] BUG #5802: configure script does not check for perl devel files

2010-12-29 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 However, during the make, postgres requires perl devel. Should this not be covered in the configure script? No, it's not configure's job to do the job of make or the compiler. Nonsense, we should be checking everything we can. Why wait