1

Topic: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

Good afternoon.
Windows Server 2008 R2, Firebird 2.5.8 SuperClassic.
Literally one of these days led an upgrade to 2.5.8 from version 2.5.2 on which without special problems were since 2012 as in version 2.5.2 found out an unpleasant bug c slow operation sweep .
Configuration files saved (in the core, almost all has been installed by default, except a directory for temporal files and the size of a gain of a file of a database, necessarily I can lay out), security a database saved. Client libraries (fbclient.dll), of course, too updated.
On Firebird the site of average attendance and the infrastructural projects servicing the data, relevant for a site works.
The problem was while in service found out. After a while Firebird ceases to answer requests of clients. The clients connected earlier, also cease to receive the answer from the server and hang up. Check shows the following:
- In a broad gull firebird.log anything especial is not present.
- Great number owner (s) in fb_lock_print. From above 1000. Earlier on 2.5.2 at the same loading numbers no more than 300-400 were watched.
- Great number of TCP-connections to the server. We trace through netstat-ano.
- The server does not accept new connections, it is impossible to check up monitoring tables, sessions ISQL (and the normal user, and SYSDBA) hang up.
- At attempt to make gfix-shut single-force 0 server does not close connection. The number owners in fb_lock_print remains big.
- Attempt to stop the server through a Windows service stop net stop servicename does not lead to success. The message is produced that the service cannot be stopped.
- Murder of process and service restarting lead after a while to the same situation.
I will repeat that on 2.5.2 all the same worked as years without problems.
Whether it is known about any singularities 2.5.8 SuperClassic in comparison with 2.5.2 SuperClassic which can lead to accumulation of connections (apparently, they are not released) and to something similar?
I will repeat that client libraries fbclient.dll on servers-clients (such as ) updated to the actual version. The source code for operation with a database - Library UIB. Whether something could change in 2.5.8 in comparison with 2.5.2 so, what version UIB working without problems with 2.5.2, breaks on 2.5.8?
Thanks in advance.

2

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

P.S. Triggers on events like a connection/diskonnekt are not present. Generally among Database-triggers is only ON TRANSACTION COMMIT where context-sensitive variable USER_TRANSACTION and depending on its some values is researched, the data is added. The processes connected to this code, fulfill, if are in time before the server ceases to answer.

3

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

Igor Ivkin wrote:

the Great number of TCP-connections to the server. We trace through netstat-ano.

Well and to go and give on a cap to those who installed such amount of connections?. 1000
Connections it is a rigid limit for  on Windows.

4

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

Dimitry Sibiryakov wrote:

it is passed...
Well and to go and give on a cap to those who installed such amount of connections?. 1000
Connections it is a rigid limit for  on Windows.

Problem in that they are not present so much. Probably, the server does not release the closed connections since clients are not present so much and does not happen. Therefore I asked, whether it is known about any changes in 2.5.8 in comparison with 2.5.2 which could provoke such behavior.

5

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

P.P.S. In the code, certainly, it is used  connections by means of library UIB. That is there is a pool of connections, after clearing the connection gets to a pool and tries .

6

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

Igor Ivkin;
And where the warranty that this pool correctly works?

7

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

Denis wrote:

Igor Ivkin;
And where the warranty that this pool correctly works?

Well, it worked without problems since 2012 on 2.5.2. The part of my question also is connected To it just.

Igor Ivkin wrote:

whether something Could change in 2.5.8 in comparison with 2.5.2 so, what version UIB working without problems with 2.5.2, breaks on 2.5.8?

8

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

Igor Ivkin wrote:

In the code, certainly, it is used  connections by means of library UIB

In all client applications? It is a client - server, or a web?

9

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

kdv wrote:

it is passed...
In all client applications? It is a client - server, or a web?

Yes, in all client applications. Clients represent:
1. The web site of average or even small attendance (some hundreds thousand persons a month).
2. Applications which on a daily basis update a DB the actual data.
3. Applications which generate various reports on the basis of the data from a DB.
The site preferentially reads, 2 group of applications preferentially writes, 3 group of applications preferentially reads.

10

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

Igor Ivkin> the Problem that they are not present so much.
So, wait. These 1000 connections (what part from them ?) appeared after passage on 2.5.8?

11

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

What hinders to look in mon$attachments when connections at 500-600 more and new connections transit? And to check them with real clients. If there is a discrepancy, to make .

12

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

Rustam wrote:

Igor Ivkin> the Problem that they are not present so much.
So, wait. These 1000 connections (what part from them ?) appeared after passage on 2.5.8?

So, on 2.5.2 many years all was normal. During the moments of peak loadings when also all applications worked, and users resorted much, the number owner (s) in fb_lock_print was around 300-400.

13

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

Igor Ivkin wrote:

as in version 2.5.2 the unpleasant bug c by slow operation sweep was found out.

If that this "bug" existed still since Interbase and by and large a bug is not, is faster not optimal implementation.

14

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

So from here and it is necessary to dig (at least how above  prompted).
In sense, a subject of a current topic correct, and here  and all
Remaining - either it is secondary, or at all the factor.
How (the moment, the scenario) happens escalating of an amount of connections?
At least simple shooting (inactive, and so forth) tried the oldest?

15

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

Igor Ivkin wrote:

Yes, it is very similar on wash a case. Rupture makes 2 000 000 transactions, works the third days.

Well if your pool worked correctly such ruptures should not be. To a campaign a pool we tell so  and allows to return connections in a pool without completing transactions. Or at you frequent rollbacks of transactions also it is not fulfilled  or  under the schedule.
It is possible to try to include trace on the test bench and to look as there at your pool works

16

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

Denis wrote:

it is passed...
Well if your pool worked correctly such ruptures should not be. To a campaign a pool we tell so  and allows to return connections in a pool without completing transactions. Or at you frequent rollbacks of transactions also it is not fulfilled  or  under the schedule.
It is possible to try to include trace on the test bench and to look as there at your pool works

The above-stated rupture happened because of incident in date-center (Europe). The Internet disappeared during the most active night updates, something was rolled away, something . As a whole from last similar incident in 2015 (yes, incidents very rare and everyone is remembered), rupture between OIT and OST the minimum always kept.

17

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

Igor Ivkin wrote:

rupture between OIT and OST always kept the minimum.

Hammer you on this rupture. You will think, somewhere once transaction real  was completed. Well also what?

18

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

Igor Ivkin wrote:

the Problem that they are not present so much.

It to you netstat told or imagination? Keep alive it is adjusted?

19

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

kdv wrote:

it is passed...
Hammer you on this rupture. You will think, somewhere once transaction real  was completed. Well also what?

Simply Simonov Denis assumed that the problem in our poor-quality software, time it admits similar ruptures. I explained that such incident with rupture - unique for three years, last was in 2015 because of an error in the code. That is the considered pool of connections as a whole with transactions and connections addresses accurately, counters not , well and on version 2.5.2 of the problems described in the start message, was never since 2012, while we on it.

20

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

I will ask once again, it is simple and unambiguous: during hangup how many TCP connections to
To server Firebird (and from it) shows netstat? In digits, with grouping on a state
(established, time_wait, syn_send etc.)

21

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

Dimitry Sibiryakov wrote:

I Will ask once again, it is simple and unambiguous: during hangup how many TCP connections to
To server Firebird (and from it) shows netstat? In digits, with grouping on a state
(established, time_wait, syn_send etc.)

Now I will wait the following time and I will copy the live data.
Meanwhile it decided to be rolled away with despair on the version less, delivered 2.5.6 SuperClassic, night worked without special problems, loading created, in the core servicing applications (them some tens, worked simultaneously).
Let's look at a situation in the afternoon when visitors come.

22

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

I simply nearby will stand... The subject simply here Cast what case:
2.5.8 I did not begin in  to put, I will not recall precisely why.
But one of "experimental" clients after installation to it of our System under 2.5.8 (Windowsx64, a superserver) shouted a good floor-mat on  our applications. Errors fell down at performance of requests in critical places.
At all thus that development goes at us under 2.5.2 (Linux, Classic), I not especially  and to new clients simply put actual minor release FB 2.5, hoping that they are useful regarding bug fixing.
I did not begin to understand a reality and to do , the blessing in plans to pass on FB3-FB4.
Rolled away to the client on 2.5.6 - a whisker it was normalized. 2.5.7 like too for someone works - it has been noted problems.
But with 2.5.8  remained.

23

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

Igor Ivkin, o_v_a
Well here... Instead of removing  during hangup, to send to developers, and by that to help to correct to a bug, you silently were rolled away

24

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

Denis wrote:

Igor Ivkin, o_v_a
Well here... Instead of removing  during hangup, to send to developers, and by that to help to correct to a bug, you silently were rolled away

Problem in that I need to revive my site faster. And to try to catch a problem and to help developers if rollback to 2.5.6 solves this problem, I intend on the local beta server not to experiment on the fighting. I will simply load it properly on 2.5.8 and I will try to play back.

25

Re: Firebird 2.5.8 SuperClassic - hangs up because of a great number of connections

Igor Ivkin;
Buzzing