?
Solved

VMWare and PostgreSQL, problems around transactions

Posted on 2007-08-03
15
Medium Priority
?
1,405 Views
Last Modified: 2013-11-05
Hello everyone, I have a PostgreSQL database installed into a VMWare session on a server. I connect to the database from an application but sometimes it goes getting connection lost with this message: "Could not send Query(connection dead)"... like somewhere VMWare loses connection transaction from user to the DB.... So I'm here to ask you what could be? Like if is there a VMWare option that would maintain keepalive the transaction while active till it closes by user?....

Thanks to everyone :)
0
Comment
Question by:npuleio
  • 7
  • 6
14 Comments
 
LVL 62

Expert Comment

by:gheist
ID: 19629576
That is inside vmware NAT driver.
0
 

Author Comment

by:npuleio
ID: 19630337
Uhm, since I'm not expert with VMWare...what do you mean about NAT driver? is there any options? or shall I have to update that driver with last driver?....
0
 
LVL 62

Expert Comment

by:gheist
ID: 19649666
You should set VMWare to connect host to network directly, i.e having IP address like your machine has.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:npuleio
ID: 19679494
Ah! Then that's not the problem because I use the IP address to connect so that would mean VMWare is settled to connect with IP address...
0
 
LVL 62

Expert Comment

by:gheist
ID: 19679636
Any other router/firewall/NAT between application and server?
0
 

Author Comment

by:npuleio
ID: 19680130
Actually the server is in the internal lan that's is normally controlled by a switch...firewalls are in another port of the lan to connect to the external area...so that's like a normal lan network...
0
 
LVL 62

Expert Comment

by:gheist
ID: 19682836
You should add error handling mechanisms in your client application.
PostgreSQL server does not close idle connections without reason.
0
 

Author Comment

by:npuleio
ID: 19683195
In fact there's error handling and it reports "Could not send Query(connection dead) No response from the backend"... no more error messages reports... Oh well, I guess I'll have to request database transfer to a normal machine without VMWare so it should work correctly...
0
 
LVL 62

Expert Comment

by:gheist
ID: 19685958
What is the "backend"
0
 

Author Comment

by:npuleio
ID: 21644013
hello.... I solved just transferring the database to a normal machine so I avoided the problem around VMWare settings as I said in my last response because it was a bit difficult to explain what was happening since I didn't really got what happened...
So, asking for a moderator, is it possible to cancel this question due to incomplete explaining of the problem and solved in different way?

Thanks
0
 
LVL 62

Expert Comment

by:gheist
ID: 21645275
I have no objections you have your points back.
Its client side that must keep-alive, vmware is not unique in matter of "forgetting" long-running tcp connections.
0
 

Author Comment

by:npuleio
ID: 21897423
For a moderator, since I solved just transferring to another machine as I said, can we close this question? Thanks
0
 
LVL 62

Expert Comment

by:gheist
ID: 21898673
Since you added a post refund will be delayed for another month unless you ask for it in Community Support area.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 22506778
PAQed with points refunded (250)

Computer101
EE Admin
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question