Re: pgsql server reset the connection immediately after connected

Поиск
Список
Период
Сортировка
От Dongkuo Ma
Тема Re: pgsql server reset the connection immediately after connected
Дата
Msg-id CAMccLyfdm_VfyWerBYYeYtkfLQtsyzn00U5O1Mp9ZKPZDC+eDA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgsql server reset the connection immediately after connected  (Adrian Klaver <adrian.klaver@gmail.com>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Corrupt Incrementally Updated Backup: missing pg_clog file
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: pgsql server reset the connection immediately after connected