Problem: connections doesn't close - linked server

More
8 years 5 months ago #2892 by jmarin
jmarin created the topic: Problem: connections doesn't close - linked server
I have a problem using Linked Server in MS SQL Server 2008 (10.0.1600) over Windows Server 2008 R2, to PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Ubuntu 4.3.3-5ubuntu4) 4.3.3.
Additional, the connection to Postgresql are controlled by connection pools (we have test with pgpool and pgbouncer).

Our client/server application (.NET) establish a connection to ms sqlserver, execute an operation in a transaction (distributed): insert in some ms sqlserver table and execute a postgres function (by linked server), and close the connection to ms sql server.
But occur that the postgresql server cache become full. It seems to be that connection coming from sql server doesn't close and go on open new connection every time.

What am I doing bad?

Is some configuration absent?

Sorry by my english.

José Marín

Please Log in or Create an account to join the conversation.

More
8 years 5 months ago #2909 by Moderator
Moderator replied the topic: Re: Problem: connections doesn't close - linked server
Jose, we'll try to reproduce the issue and will let you know.

Thank you!

Please Log in or Create an account to join the conversation.

Time to create page: 0.112 seconds
Powered by Kunena Forum