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@xxxxxxxxx> wrote:
On 11/01/2012 07:32 PM, Dongkuo Ma wrote:What is the Python code being used?
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.
Should be in /var/log/postgresql
Using tcpdump, I found the server reset the connection immediately
after connected, and i cann't find any log about this.
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
