FB 4.0.2 hangs in shutdown sequencie

[Fabiano SCI]

Hello. We are using Firebird 4.0.2 Classic in a Windows platform and we are experiencing ocasional hangs. A have the memory DUMPS of this.

The problem occurs that way: 

We close all Firebirds connections at once but one specified firebird.exe PID connection hangs in this process (firebird-that_hangs.DMP). When this occurs the firebird.exe PID remains in memory and hangs all other firebird attempts access - to close connections, open new connections etc.

When this occurs, the symptom is other firebird.exe PID with high CPU consumption waiting (firebird-waiting.DMP) . If I kill the Firebird PID that hangs the Firebird became normal and "unhang".

Analysing the dumps with the Firebird PBD's we concluded that is a problem in the shutdown sequence of the firebird.exe PID. Here is the dumps in case someone wants to take a look:

https://we.tl/t-mzkbaORQjQ 

[Vlad Khorsun]

  How do you  "close all Firebirds connections at once" ?

  RAR archive contains firebird-aguardando.DMP and firebird-segurando2.DMP.

Am I correct assuming that this corresponds to the firebird-that_hangs.DMP and firebird-waiting.DMP (in that order) ?

Regards,

Vlad

[Fabiano SCI]

How do you  "close all Firebirds connections at once" ?

We have a Windows Service that opens around ~100 Firebird Classic connections and when this service stops it closes all Firebird connections in rapid succession. Closes the first connection, then closes se second connection an so on to the last connection as fast as it can.

I uploaded a new ZIP file with the correct file names for your convenience.

https://we.tl/t-6kjyXVBpSS

[Fabiano SCI]

Also we discovered that in some circumstances there is an Access Violation in the fbclient.dll than only occurs in the version 4.0.2 (and not occur in 4.0.1). We thought than can be related to this alteration:

https://github.com/FirebirdSQL/firebird/commit/5d0fd129857d29167fe0e27498c5422cca1354d5#diff-a19cf70c40b068ce5cb09d70a726d90ba07b3312fd1946bb72ef6c03a879a87d

Attached there is a dump and some screenshots that can help.

Our process dump: https://we.tl/t-S4ejdM1Hxe

and

screenshots: https://wetransfer.com/downloads/e762c1cb7b309b0c53e7a33e760ad6a420230208173037/b81a934c9b44ef219998ee802f9f4ce820230208173050/e63d7a

Best regards! 

[Fabiano SCI]

https://we.tl/t-UYI5nWJYgn (both screenshots)

[Vlad Khorsun]

Also we discovered that in some circumstances there is an Access Violation in the fbclient.dll than only occurs in the version 4.0.2 (and not occur in 4.0.1). We thought than can be related to this alteration:

https://github.com/FirebirdSQL/firebird/commit/5d0fd129857d29167fe0e27498c5422cca1354d5#diff-a19cf70c40b068ce5cb09d70a726d90ba07b3312fd1946bb72ef6c03a879a87d

Attached there is a dump and some screenshots that can help.

Our process dump: https://we.tl/t-S4ejdM1Hxe

and

screenshots: https://wetransfer.com/downloads/e762c1cb7b309b0c53e7a33e760ad6a420230208173037/b81a934c9b44ef219998ee802f9f4ce820230208173050/e63d7a

  Yes, it look very much like bug that was introduced by fix at #7147 and fixed at #7271

Regards,

Vlad

[Fabiano SCI]

This bug generates the behavior described in the first post (firebird.exe process hanging on shutdown)?

[Vlad Khorsun]

> This bug generates the behavior described in the first post (firebird.exe process hanging on shutdown)?

  It is possible, although that dumps doesn't directly points to it.

Can't get more info from that dumps, unfortunately.

Regards,

Vlad