It happened again.

z3  Tue Dec  5 08:37:45 2017
        Database: /opt/firebird/security3.fdb
        page 0, page type 1 lock denied (216)


z3  Tue Dec  5 08:37:54 2017
        Database:
        page 0, page type 1 lock denied (216)


zl3  Tue Dec  5 08:37:54 2017
        Authentication error
        page 0, page type 1 lock denied

I've noticed that since this moment I could conenct to tcp:3050 (eg. via telnet) but I couldn't open any working DB connection.
Applications that keep their connection still worked and collected data.
But applications that need to open new connection (eg. cron jobs, or php scripts in apache) are out of order.

So I restarted firebird.

It seems like that tonight I will have return to FB 2.5.

Jakub


---------- Původní e-mail ----------
Od: ehmmm.firebird@... [firebird-support] <firebird-support@yahoogroups.com>
Komu: firebird-support@yahoogroups.com
Datum: 5. 12. 2017 6:59:21
Předmět: [firebird-support] lock denied...

 

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