[Firebird-net-provider] [FB-Tracker] Created: (DNET-589) CLONE -FirebirdSQL Connection Pooling (ADO.NET) is not Working
CLONE -FirebirdSQL Connection Pooling (ADO.NET) is not Working -- Key: DNET-589 URL: http://tracker.firebirdsql.org/browse/DNET-589 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 4.6.0.0 Environment: Firebird 2.5.3.26780 (x64); Windows 10 Pro; Reporter: Luciano Mendes Assignee: Jiri Cincura Priority: Blocker Actual result: Engine Code: 335544726 Engine Message: Error reading data from the connection. See: ADONETConnectionPoolingERROR.png Expected Result: The Connection Pooling should be automatically restored when any disconnection occurs between requests; Steps to reproduce the issue: 1- Open a FirebirdSQL Connection Pooling (ADO.NET) using the ADO.NET Provider v.4.6.0.0 (Reference: http://msdn.microsoft.com/en-us/library/8xx3tyca(v=vs.100).aspx) and do a Data request: The data is received without any issue; 2- Interupt the FirebirdSQL Server (net stop FirebirdServerDefaultInstance) and restart it (net start FirebirdServerDefaultInstance); 3- Try to request any other data from the Database using the same FirebirdSQL Connection Pooling open before. Additional Information: This issue did not happen when using the previous ADO.NET Provider v.4.5.2.0. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] RES: Error reading data from the connection
But in this case the pooling problem give the correct would not try a new connection from the beginning and no longer use the pooling? -Mensagem original- De: Jiří Činčura [mailto:j...@cincura.net] Enviada em: sexta-feira, 23 de janeiro de 2015 09:56 Para: For users and developers of the Firebird .NET providers Assunto: Re: [Firebird-net-provider] Error reading data from the connection Probably the provider pulls a bad connection from the pool and tries to use it despite its being broken. OK, so once more. Provider is not reopening the connection or doing *anything* with it. In fact it's even impossible to do it reliably. -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Error reading data from the connection
That’s expected. The driver is not reopening the connection. -- Mgr. Jiří Činčura Independent IT Specialist From: Nicolas F. Timmers [mailto:nftimm...@hotmail.com] Sent: Friday, January 23, 2015 11:49 AM To: 'For users and developers of the Firebird .NET providers' Subject: [Firebird-net-provider] Error reading data from the connection Hello I am experiencing an error regarding the new version of Firebird Client 4.6.0 In summary the following steps are necessary to generate the error 1) Using a page Ex: Default.aspx, make a connection to the database 2) After made the connection end the firebird service by windows services 3) When you return to the page and try to make a new connection an error is generated 4) Error reading data from the connection What did seems to be is that when the firebird service is stopped the Firebird Client is trying to use the Pooling my question is if an attempt is made in pooling successfully should not the DLL fill the pooling again? -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Error reading data from the connection
I get this error too from time to time. When using pooling, after the firebird server is restarted it's immposible to establish a new connection to the serwer. Probably the provider pulls a bad connection from the pool and tries to use it despite its being broken. Cheers. Michał 2015-01-23 12:44 GMT+01:00 Jiří Činčura j...@cincura.net: That’s expected. The driver is not reopening the connection. -- Mgr. Jiří Činčura Independent IT Specialist *From:* Nicolas F. Timmers [mailto:nftimm...@hotmail.com] *Sent:* Friday, January 23, 2015 11:49 AM *To:* 'For users and developers of the Firebird .NET providers' *Subject:* [Firebird-net-provider] Error reading data from the connection Hello I am experiencing an error regarding the new version of Firebird Client 4.6.0 In summary the following steps are necessary to generate the error 1) Using a page Ex: Default.aspx, make a connection to the database 2) After made the connection end the firebird service by windows services 3) When you return to the page and try to make a new connection an error is generated 4) Error reading data from the connection What did seems to be is that when the firebird service is stopped the Firebird Client is trying to use the Pooling my question is if an attempt is made in pooling successfully should not the DLL fill the pooling again? -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Error reading data from the connection
Probably the provider pulls a bad connection from the pool and tries to use it despite its being broken. OK, so once more. Provider is not reopening the connection or doing *anything* with it. In fact it's even impossible to do it reliably. -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Error reading data from the connection
Hello I am experiencing an error regarding the new version of Firebird Client 4.6.0 In summary the following steps are necessary to generate the error 1) Using a page Ex: Default.aspx, make a connection to the database 2) After made the connection end the firebird service by windows services 3) When you return to the page and try to make a new connection an error is generated 4) Error reading data from the connection What did seems to be is that when the firebird service is stopped the Firebird Client is trying to use the Pooling my question is if an attempt is made in pooling successfully should not the DLL fill the pooling again? -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] ADO.NET provider 4.6.1.0
More info http://blog.cincura.net/233495-ado-net-provider-4-6-1-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] RES: Error reading data from the connection
Or alternatively you could flush the pool. Michał 2015-01-23 15:02 GMT+01:00 Nicolas F. Timmers nftimm...@hotmail.com: But in this case the pooling problem give the correct would not try a new connection from the beginning and no longer use the pooling? -Mensagem original- De: Jiří Činčura [mailto:j...@cincura.net] Enviada em: sexta-feira, 23 de janeiro de 2015 09:56 Para: For users and developers of the Firebird .NET providers Assunto: Re: [Firebird-net-provider] Error reading data from the connection Probably the provider pulls a bad connection from the pool and tries to use it despite its being broken. OK, so once more. Provider is not reopening the connection or doing *anything* with it. In fact it's even impossible to do it reliably. -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] RES: RES: Error reading data from the connection
But in this case Flush the pool will afect all the pools including from databases that dont have anything to do with this problem, but is on the same server De: Michał Ziemski [mailto:m...@e-adm.pl] Enviada em: sexta-feira, 23 de janeiro de 2015 12:14 Para: For users and developers of the Firebird .NET providers Assunto: Re: [Firebird-net-provider] RES: Error reading data from the connection Or alternatively you could flush the pool. Michał 2015-01-23 15:02 GMT+01:00 Nicolas F. Timmers nftimm...@hotmail.com mailto:nftimm...@hotmail.com : But in this case the pooling problem give the correct would not try a new connection from the beginning and no longer use the pooling? -Mensagem original- De: Jiří Činčura [mailto:j...@cincura.net mailto:j...@cincura.net ] Enviada em: sexta-feira, 23 de janeiro de 2015 09:56 Para: For users and developers of the Firebird .NET providers Assunto: Re: [Firebird-net-provider] Error reading data from the connection Probably the provider pulls a bad connection from the pool and tries to use it despite its being broken. OK, so once more. Provider is not reopening the connection or doing *anything* with it. In fact it's even impossible to do it reliably. -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net mailto:Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net mailto:Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] RES: RES: Error reading data from the connection
You could use FbConnection.ClearPool rather than ClearAllPools(). Anyhow if the server restarted there is possibility of bronek connections in other pools. 2015-01-23 16:30 GMT+01:00 Nicolas F. Timmers nftimm...@hotmail.com: But in this case Flush the pool will afect all the pools including from databases that dont have anything to do with this problem, but is on the same server *De:* Michał Ziemski [mailto:m...@e-adm.pl] *Enviada em:* sexta-feira, 23 de janeiro de 2015 12:14 *Para:* For users and developers of the Firebird .NET providers *Assunto:* Re: [Firebird-net-provider] RES: Error reading data from the connection Or alternatively you could flush the pool. Michał 2015-01-23 15:02 GMT+01:00 Nicolas F. Timmers nftimm...@hotmail.com: But in this case the pooling problem give the correct would not try a new connection from the beginning and no longer use the pooling? -Mensagem original- De: Jiří Činčura [mailto:j...@cincura.net] Enviada em: sexta-feira, 23 de janeiro de 2015 09:56 Para: For users and developers of the Firebird .NET providers Assunto: Re: [Firebird-net-provider] Error reading data from the connection Probably the provider pulls a bad connection from the pool and tries to use it despite its being broken. OK, so once more. Provider is not reopening the connection or doing *anything* with it. In fact it's even impossible to do it reliably. -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
