search

FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.24k stars 214 forks source link

[FB3 CS] Server stops accepting new connections - lock denied [CORE5813] #6075

Open firebird-automations opened 6 years ago

firebird-automations commented 6 years ago

Submitted by: John Franck (bozzy)

Is related to CORE5436

Classic Server stops accepting new connections, while already active ones continue to work regularly.

Load conditions seems irrilevant, we had a total of 4 events in less than a week, two of these during very low load conditions and two in average conditions.

Error in firebird.log (this is the last event this morning, load conditions at 6 am are extremely low in our environment):

------------------------

sqlserver Thu May 3 06:17:56 2018 Database: /opt/firebird/security3.fdb page 0, page type 1 lock denied (216)

sqlserver Thu May 3 06:17:57 2018 Database: page 0, page type 1 lock denied (216)

------------------------

I've also noticed there are other errors in firebird.log, but these seems not to be related to any connection problems (I've got no reports from users). I put them here anyway:

------------------------

sqlserver Wed May 2 18:43:50 2018 Database: /opt/firebird/security3.fdb page 377, page type 3 lock denied (216)

sqlserver Wed May 2 18:43:52 2018 Database: /opt/firebird/security3.fdb page 377, page type 3 lock denied (216)

sqlserver Wed May 2 18:43:53 2018 Database: /opt/firebird/security3.fdb page 377, page type 3 lock denied (216)

------------------------

This problem seems to be similar to this one: CORE5436 which however affects Firebird on Windows.

This is a big problem for us, service is going down from time to time and requires a server restart.

firebird-automations commented 6 years ago

Commented by: Sean Leyne (seanleyne)

This is a support issue, please post it to the Firebird Support mailing list. If not otherwise resolved, you can request this issue to be re-opened.

firebird-automations commented 6 years ago
Modified by: Sean Leyne (seanleyne) status: Open \[ 1 \] =\> Resolved \[ 5 \] resolution: Incomplete \[ 4 \]
firebird-automations commented 6 years ago

Commented by: John Franck (bozzy)

Sorry but how is this different from CORE5436 ?

Vlad Khorsun suggested me to open a new ticket since this is probably the same problem as the just mentioned bug, but also affecting Linux platform (while CORE5436 was for Windows).

firebird-automations commented 6 years ago
Modified by: Sean Leyne (seanleyne) Link: This issue is related to [CORE5436](https://github.com/FirebirdSQL/firebird/issues?q=CORE5436+in%3Atitle) \[ [CORE5436](https://github.com/FirebirdSQL/firebird/issues?q=CORE5436+in%3Atitle) \]
firebird-automations commented 6 years ago
Modified by: Sean Leyne (seanleyne) status: Resolved \[ 5 \] =\> Reopened \[ 4 \] resolution: Incomplete \[ 4 \] =\>
firebird-automations commented 6 years ago
Modified by: @hvlad assignee: Vlad Khorsun \[ hvlad \]
firebird-automations commented 6 years ago

Commented by: @hvlad

Looks like original reason of the issue was found and fixed. And it is not platform dependent this time. Please, try next snapshot build (after 3.0.4.32985)