Обсуждение: The connection closed unexpectedly - C++ and Postgre
Greetings, I have a problem with postgresql that connect to a c++ server. I build some system servers that have connection to a postgresql server. When i add many object in the database, and the system server going to shoot the database server with the query. There will be an exception. The exception sound : "Server closed the connection unexpectedly". The configuration of my database server is standard. When i look into the log on database server : "connection reset by peer". Please help me with that problem. Thank you. -- View this message in context: http://www.nabble.com/The-connection-closed-unexpectedly---C%2B%2B-and-Postgre-tp24302840p24302840.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On Thu, Jul 2, 2009 at 2:05 AM, drestajumena<drestajumena@gmail.com> wrote: > > Greetings, > > I have a problem with postgresql that connect to a c++ server. > > I build some system servers that have connection to a postgresql server. > When i add many object in the database, and the system server going to shoot > the database server with the query. There will be an exception. The > exception sound : "Server closed the connection unexpectedly". > > The configuration of my database server is standard. When i look into the > log on database server : "connection reset by peer". > > Please help me with that problem. That's odd. The client says the server closed the connection, the server says the client closed the connection. Most the time you see something like this it's a firewall or some other networking issue cropping up. Is this limited to certain size, duration, or something else unique about the query? Do you have a firewall between the machines? On one of the machines? I'd run tcpdump on both of them and watch what's happening on each one from there.
If run the server, the server will be run for several minutes and then the error will happen. Most of error will held if the server run query : INSERT, DELETE. For database server, i use Postgre 8.3.1 on ubuntu 8.10 server. For system servers, i use standard C++. I am going to make an MMORPG. So i implements many servers. 1 MainServer and some AreaServer. Thank you ... -- View this message in context: http://www.nabble.com/The-connection-closed-unexpectedly---C%2B%2B-and-Postgre-tp24302840p24303787.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.