Re: [firebird-support] Slow execution of Stored Procedure after 20 min. inactivity

05.12.2017 10:07, Marcel Brink mbr...@xploration.onmicrosoft.com [firebird-support] wrote: > Does anyone have an idea why this happens only after around 20 minutes and > not every time ? You should, probably, turn performance counters output in trace as well. May be in these 20 minutes

[firebird-support] windows server 2016 as server for firebird 2.5.7

Hi I want to use windows server 2016 as server for firebird 2.5.7 (Classic Server) are there any known issus with using firebird with this system? with best regareds Nils PS: The power plan ist on "High Performance"

[firebird-support] Slow execution of Stored Procedure after 20 min. inactivity

Hello, After spending more than a week trying to resolve the following issue we hope someone has an answer on this. We have a database with about 230 tables and 200 stored procedures which is being used by our customers. Each customer have a dedicated installation with it's own database

Re: [firebird-support] Re: lock denied...

Thank you for your response. You are right, the /tmp/firebird/fb_lock_table.dump is really there. I've attached it. It has the same timestamp like the "Fatal lock manager error" event, ie. 00: 11. I'm quite interested what you will find inside. Jakub -- Původní e-mail -- Od:

[firebird-support] Re: lock denied...

Yes, minimum requirement to let your program talk to SS is to avoid embedded connections, and one of the ways to do it is to add hostname/ip-address before database name. Is there /tmp/firebird/fb_lock_table.dump on your box? If yes please upload it here - it can give an idea what's wrong with

Re: [firebird-support] Re: lock denied...

Thank you for your response. Compared to you I'm just a beginner so I have other questions. > i see no relation between such services and requirement to use SuperClassic I din't investigate it much but I think it is becuase the C programs it is historically written something like this: int

[firebird-support] Re: lock denied...

---In firebird-support@yahoogroups.com, wrote : > 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

Re: [firebird-support] lock denied...

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