PostgreSQL Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesPostgreSQL Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old July 2nd, 2009, 04:05 AM
drestajumena drestajumena is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2009
Posts: 3 drestajumena User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 6 m 23 sec
Reputation Power: 0
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.

Reply With Quote
  #2  
Old July 9th, 2009, 08:06 AM
coredev coredev is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2006
Posts: 72 coredev User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 17 h 46 m 52 sec
Reputation Power: 4
Sounds like an error in your client... Try start with some example client code and test if it can connect to your server and run some queries. If it can, then you probably have some sort of pointer-problem in your application writing over something important.

Reply With Quote
  #3  
Old July 21st, 2009, 05:11 AM
drestajumena drestajumena is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2009
Posts: 3 drestajumena User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 6 m 23 sec
Reputation Power: 0
Already test

The problem is the error will come on some not spesific symptomps. The error not come for sure but for sometimes only. The Queries will be executed with nice return but for sometimes the error will exists.

Reply With Quote
  #4  
Old July 21st, 2009, 05:32 AM
shammat shammat is offline
Contributing User
Dev Shed Intermediate (1500 - 1999 posts)
 
Join Date: Oct 2003
Location: Munich, Bavaria
Posts: 1,532 shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Weeks 3 Days 16 h 34 m 21 sec
Reputation Power: 209
To me this sounds like a network problem, rather than a Postgres problem (especially because of the "reset by peer" which I have seen e.g. with Oracle as well and it always boiled down to a network problem)

Reply With Quote
  #5  
Old July 21st, 2009, 06:09 AM
drestajumena drestajumena is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2009
Posts: 3 drestajumena User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 6 m 23 sec
Reputation Power: 0
One PC

Ok then .... I have implement the system on two ways.

The database server and system server are on the same PC and 1 IP

The database server and system serer are on the same PC but run on 2 virtual machine that completely different

I think this is not a network problem. I guest the problem is about the memmory allocation, max connection, etc but i already expand it on maximal capacity. But the error sometimes still come out.

Thanks.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesPostgreSQL Help > The connection closed unexpectedly - C++ and Postgre


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump




 Free IT White Papers!
 
How to Present Effectively Online
This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.

 
Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual property restrictions (or arrangement such as the public domain), and is usually developed with the input of many contributors.

 
Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity management.

 
Scalable, Fault-Tolerant NAS for Oracle - The Next Generation
For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.

 
Understanding Web Application Security Challenges
This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.

 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 




© 2003-2009 by Developer Shed. All rights reserved. DS Cluster 2 Hosted by Hostway
Stay green...Green IT