Search Postgresql Archives

Re: pgsql server reset the connection immediately after connected

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Nov 2, 2012 at 1:57 PM, Dongkuo Ma <luc.mdk@xxxxxxxxx> wrote:
> 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.

Is there a long delay between connecting and executing a query? It may
be that something disconnected you during that time. Or could the
server have been restarted?

Can you make a simple Python script that always fails in this way?

Chris Angelico


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux