Hallo Franco,

I had quite similar problem around 5th December 2017, try to search "lock 
denied" around that date.

In my case it helped to switch to SuperServer mode.
(It required to change some SW to use the "TCP/IP" mode instead of the 
"file" access.)

I remember that I promised that I would test the SuperClassic mode on our 
backup server but I havn't done it yet.

Hope that helps,
Jakub

---------- Původní e-mail ----------
Od: 'Franco Perana' franco.per...@studiocentro.it [firebird-support] <
firebird-support@yahoogroups.com>
Komu: firebird-support@yahoogroups.com
Datum: 4. 5. 2018 3:21:55
Předmět: [firebird-support] [FB3 CS] Server stops accepting new connections 
- lock denied 
" 
  



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:
http://tracker.firebirdsql.org/browse/CORE-5436 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.

STUDIO CENTRO SRL - Soluzioni e Servizi - www.studiocentro.it
Sede: 36100 Vicenza - Via Luigi Boccherini, 13 Tel. 0444.56.31.66 Fax
0444.96.43.65 email: conta...@studiocentro.it

AVVERTENZE AI SENSI DEL DLGS 196/2003
Le informazioni contenute in questo messaggio di posta elettronica o nei
suoi allegati, sono da considerarsi strettamente riservate.
Il loro utilizzo si consente esclusivamente al destinatario, per le
finalità indicate nel messaggio stesso.. Qualora non siate il
destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e
di procedere alla cancellazione dello stesso dal Vostro sistema.
Costituisce comportamento contrario ai principi dettati dal
Dlgs.196/2003 trattenere il messaggio, divulgarlo anche in parte,
distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per fini
diversi. 

[Non-text portions of this message have been removed]






"

Reply via email to