Re: pgsql server reset the connection immediately after connected - Mailing list pgsql-general

From Dongkuo Ma
Subject Re: pgsql server reset the connection immediately after connected
Date
Msg-id CAMccLyfdm_VfyWerBYYeYtkfLQtsyzn00U5O1Mp9ZKPZDC+eDA@mail.gmail.com
Whole thread Raw
In response to Re: pgsql server reset the connection immediately after connected  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: pgsql server reset the connection immediately after connected  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: pgsql server reset the connection immediately after connected  (Chris Angelico <rosuav@gmail.com>)
List pgsql-general
Hi 
the python code is

logging.info("database connecting...")
conn = connect(database="dbname", user="user", password="password",host="127.0.0.1")
logging.info("database connected")
conn.autocommit = True
conn.set_client_encoding('UTF8')
cur = conn.cursor()
#the above code executed without exception
#and [server closed the connection unexpectedly] thrown when any cur.execute() called
I think it's strange because the server reset connection after connected,and the connect function should throw a exception.

It's nothing in the log file.

Thanks.

On Fri, Nov 2, 2012 at 10:42 AM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
On 11/01/2012 07:32 PM, Dongkuo Ma wrote:
Sorry!
I typed the enter key and sent the uncomplete message.


The psycopg2 connect function succesed,but throw a exception

server closed the connection unexpectedly
This probably means the server terminated abnormally before or while
processing the request.

when executing any sql statement.

What is the Python code being used?



Using tcpdump, I found the server reset the connection  immediately
after connected, and i cann't find any log about this.

Should be in /var/log/postgresql


This is the tcpdump log http://pastebin.com/uW0at4Zd




--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Corrupt Incrementally Updated Backup: missing pg_clog file
Next
From: Adrian Klaver
Date:
Subject: Re: pgsql server reset the connection immediately after connected