Re: [firebird-support] backup security3.fdb

2019-12-10 Thread ehmmm.fireb...@seznam.cz [firebird-support]
groups.com Datum: 10. 12. 2019 11:31:38 Předmět: Re: [firebird-support] backup security3.fdb "10.12.2019 08:58, ehmmm.fireb...@seznam.cz [firebird-support] wrote: > Please, what is the best way? Try "gbak -se inet://server/serice_mgr security.db d:\backup\security.bak - user

[firebird-support] backup security3.fdb

2019-12-09 Thread ehmmm.fireb...@seznam.cz [firebird-support]
Hello, I'm trying to find out how to backup security DB in Firebird 3. I  googled that in Firebird 2 it was possible via Service Manager. And for Firebird 3 I  found if "Firebird 3.0.3 Release Notes" that I can enable RemoteAccess for security3.fdb in databases.conf, but I don't like this

Re: [firebird-support] [FB3 CS] Server stops accepting new connections - lock denied

2018-05-04 Thread ehmmm.fireb...@seznam.cz [firebird-support]
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

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

2017-12-08 Thread ehmmm.fireb...@seznam.cz [firebird-support]
Anyway thank you for your effort. Do you think the problem might be caused more likely by embedded clients vs. SuperClient or just by "heavy load"? (Meanwhile FB3.0 SuperServer runs already two days without any trouble.) Here are the version numbers but I'm not any linux guru so I hope that's

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

2017-12-06 Thread ehmmm.fireb...@seznam.cz [firebird-support]
Hi, here is the link: https://ulozto.net/!wM4fFP0Kpnuq/fb-lock-table-dump There are options "Fast download" and "Slow download". If you don't want to register then you must use "Slow download" and type captcha code. Jakub -- Původní e-mail -- Od: peshk...@mail.ru

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

2017-12-06 Thread ehmmm.fireb...@seznam.cz [firebird-support]
s suitable for this.) Do you think it's really worth it? Best regards, Jakub -- Původní e-mail -- Od: ehmmm.fireb...@seznam.cz [firebird-support] <firebird-support@ yahoogroups.com> Komu: firebird-support@yahoogroups.com Datum: 5. 12. 2017 13:50:30 Předmět: Re: [firebird-s

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

2017-12-05 Thread ehmmm.fireb...@seznam.cz [firebird-support]
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:

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

2017-12-05 Thread ehmmm.fireb...@seznam.cz [firebird-support]
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

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

2017-12-05 Thread ehmmm.fireb...@seznam.cz [firebird-support]
. 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.fireb...@seznam.cz [firebird-support] <firebird-support@ yahoogroups.com> Komu: firebird-s

[firebird-support] lock denied...

2017-12-04 Thread ehmmm.fireb...@seznam.cz [firebird-support]
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

Re: [firebird-support] Optimizer request

2016-10-19 Thread ehmmm.fireb...@seznam.cz [firebird-support]
I'm continuing in old conversation because I have similar question. How to avoid using IN(subselect) in UPDATE? Theoretical example: update orders o set o.something = 'something other' where o.delivery_date is null   and o.partid in (select p.partid from partners p where

Re: [firebird-support] from FB 2.5.2 to 2.5.6 and C application

2016-07-27 Thread ehmmm.fireb...@seznam.cz [firebird-support]
C_USER=sysdba export ISC_PASSWORD=... export ISC_DATABASE=employee.fdb cc -lfbclient stat2.c -o stat2 ./stat2 (Same for stat3.e and stat5.e) Like I said, in FB 2.5.6 stat3 and stat5 throw error. If I do the same with FB 2.5.5 then these examples work. -- Původní zpráva -- Od: ehmm

[firebird-support] from FB 2.5.2 to 2.5.6 and C application

2016-07-26 Thread ehmmm.fireb...@seznam.cz [firebird-support]
Hi, we have server with Debian 6.0 squeeze and there we have Firebird 2.5.2 (superclassic) which sometimes hangs and I don't know why. So my idea was to install there FB 2.5.6. I downloaded FB 2.5.6 superclassic i686 (debian is amd64 but previous firebird seems to be i686 so I decided to continue