| Subject | lock denied... |
|---|---|
| Author | |
| Post date | 2017-12-05T05:59:10Z |
Hi,
last weekend we switched from FB 2.5.x to FB V3.0.3.32796
We have couple databases, the biggest has around 12 GB.
About 100-200 clients are connecting to this DB via PHP approximately twice per minute to see some data.
Some services on server are writing data into this DB.
We are using FB in SuperClassic mode, because some services are written in C and compiled via gpre/gcc.
In firebird log I can see messages like this:
z3 Sun Dec 3 01:43:15 2017
Database: /opt/firebird/security3.fdb
page 0, page type 1 lock denied (216)
z3 Sun Dec 3 01:43:24 2017
Database:
page 0, page type 1 lock denied (216)
z3 Sun Dec 3 01:43:24 2017
Authentication error
page 0, page type 1 lock denied
...
z3 Mon Dec 4 01:36:53 2017
Fatal lock manager error: invalid lock id (82928), errno: 0
z3 Mon Dec 4 01:36:53 2017
/opt/firebird/bin/fbguard: /opt/firebird/bin/firebird terminated abnormally (-1)
z3 Mon Dec 4 01:36:53 2017
/opt/firebird/bin/fbguard: guardian starting /opt/firebird/bin/firebird
...
z3 Tue Dec 5 00:11:35 2017
Fatal lock manager error: invalid lock id (82928), errno: 0
z3 Tue Dec 5 00:11:35 2017
/opt/firebird/bin/fbguard: /opt/firebird/bin/firebird terminated abnormally (-1)
z3 Tue Dec 5 00:11:35 2017
/opt/firebird/bin/fbguard: guardian starting /opt/firebird/bin/firebird
...
z3 Tue Dec 5 01:02:55 2017
Database: /opt/firebird/security3.fdb
page 0, page type 1 lock denied (216)
z3 Tue Dec 5 01:03:04 2017
Database:
page 0, page type 1 lock denied (216)
z3 Tue Dec 5 01:03:04 2017
Authentication error
page 0, page type 1 lock denied
...
z3 Tue Dec 5 05:44:27 2017
Database: /opt/firebird/security3.fdb
page 0, page type 1 lock denied (216)
z3 Tue Dec 5 05:44:36 2017
Database:
page 0, page type 1 lock denied (216)
z3 Tue Dec 5 05:44:36 2017
Authentication error
page 0, page type 1 lock denied
Could you please explain me, what do this messages mean?
How can I avoid them?
What shall I look at?
Best regards,
Jakub
last weekend we switched from FB 2.5.x to FB V3.0.3.32796
We have couple databases, the biggest has around 12 GB.
About 100-200 clients are connecting to this DB via PHP approximately twice per minute to see some data.
Some services on server are writing data into this DB.
We are using FB in SuperClassic mode, because some services are written in C and compiled via gpre/gcc.
In firebird log I can see messages like this:
z3 Sun Dec 3 01:43:15 2017
Database: /opt/firebird/security3.fdb
page 0, page type 1 lock denied (216)
z3 Sun Dec 3 01:43:24 2017
Database:
page 0, page type 1 lock denied (216)
z3 Sun Dec 3 01:43:24 2017
Authentication error
page 0, page type 1 lock denied
...
z3 Mon Dec 4 01:36:53 2017
Fatal lock manager error: invalid lock id (82928), errno: 0
z3 Mon Dec 4 01:36:53 2017
/opt/firebird/bin/fbguard: /opt/firebird/bin/firebird terminated abnormally (-1)
z3 Mon Dec 4 01:36:53 2017
/opt/firebird/bin/fbguard: guardian starting /opt/firebird/bin/firebird
...
z3 Tue Dec 5 00:11:35 2017
Fatal lock manager error: invalid lock id (82928), errno: 0
z3 Tue Dec 5 00:11:35 2017
/opt/firebird/bin/fbguard: /opt/firebird/bin/firebird terminated abnormally (-1)
z3 Tue Dec 5 00:11:35 2017
/opt/firebird/bin/fbguard: guardian starting /opt/firebird/bin/firebird
...
z3 Tue Dec 5 01:02:55 2017
Database: /opt/firebird/security3.fdb
page 0, page type 1 lock denied (216)
z3 Tue Dec 5 01:03:04 2017
Database:
page 0, page type 1 lock denied (216)
z3 Tue Dec 5 01:03:04 2017
Authentication error
page 0, page type 1 lock denied
...
z3 Tue Dec 5 05:44:27 2017
Database: /opt/firebird/security3.fdb
page 0, page type 1 lock denied (216)
z3 Tue Dec 5 05:44:36 2017
Database:
page 0, page type 1 lock denied (216)
z3 Tue Dec 5 05:44:36 2017
Authentication error
page 0, page type 1 lock denied
Could you please explain me, what do this messages mean?
How can I avoid them?
What shall I look at?
Best regards,
Jakub