[firebird-support] Cannot delete Firebird database file as it is in use by the application..

2020-03-11 Thread Elmar Haneke el...@haneke.de [firebird-support]
Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-sup

Re: [firebird-support] Statement freezes firebird

2020-01-27 Thread Elmar Haneke el...@haneke.de [firebird-support]
>  select first(8) ID from TBL_TEST > >  where ID not in (select first(2) ID from TBL_TEST order by ID desc) >  order by ID desc > the execution plan can be show e.g. with flamerobin client. The result should be the same as "select first 8 skip 2 from TBL_TEST ORDER BY ID DESC" Elmar

Re: [firebird-support] Statement freezes firebird

2020-01-25 Thread Matthias Winkler spmm...@gmail.com [firebird-support]
hoenix.com [firebird-support] < firebird-support@yahoogroups.com> schrieb am Sa., 25. Jan. 2020, 11:27: > 25.01.2020 07:59, Matthias Winkler spmm...@gmail.com [firebird-support] > wrote: > > The major problem is, that with firebird 2.1.3 the query also completes > within 3 secon

Re: [firebird-support] Statement freezes firebird

2020-01-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.01.2020 07:59, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > The major problem is, that with firebird 2.1.3 the query also completes > within 3 seconds. > Something seems to have changed with the optimizer, execution plan or > whatever (~ sorry I > dont know

Re: [firebird-support] Statement freezes firebird

2020-01-25 Thread setysvar setys...@gmail.com [firebird-support]
ains changes that speeds up simple cases like yours but with side effects that made the developers remove this change later. I just know that Firebird 0.9.4 convinced me to shun away from (NOT) IN (). HTH, Set Den 25.01.2020 07:59, skrev Matthias Winkler spmm...@gmail.com [firebird-support]: Th

Re: [firebird-support] Statement freezes firebird

2020-01-24 Thread Matthias Winkler spmm...@gmail.com [firebird-support]
t;sub"-queries. BR Matthias On Fri, Jan 24, 2020 at 3:53 PM Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Hi > > > > „select first(8) ID from TBL_TEST > > where ID not in (s

ODP: [firebird-support] Statement freezes firebird

2020-01-24 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
Hi „select first(8) ID from TBL_TEST  where ID not in (select first(2) ID from TBL_TEST order by ID desc)   order by ID desc” few things: Just hint but „first” is not function First(8) is same as First 8  You should avoid NOT IN queries and use EXISTS/NOT EXISTS instead. But

Re: [firebird-support] Statement freezes firebird

2020-01-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.01.2020 15:19, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > It sounds to me like this is should be optimized by executing the > uncorrelated sub-queries only once. Yes, but Firebird optimizer cannot do it. -- W

Re: [firebird-support] Statement freezes firebird

2020-01-24 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-01-24 14:39, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 24.01.2020 14:29, Matthias Winkler spmm...@gmail.com [firebird-support] > wrote: >> I see the very same issue with firebird 3.0.4. Any ideas? > >You made nested loop on 18000*18000 re

Re: [firebird-support] Statement freezes firebird

2020-01-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.01.2020 15:01, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > Is there a way to force limiting the result set before sorting it? No. It is also meaningless because you in fact will get several pseudo-random records. Such result hardly have a practical purpose. --

Re: [firebird-support] Statement freezes firebird

2020-01-24 Thread Matthias Winkler spmm...@gmail.com [firebird-support]
@SD: Is there a way to force limiting the result set before sorting it? On Fri, Jan 24, 2020 at 2:55 PM Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 24.01.2020 14:49, Matthias Winkler spmm...@gmail.com [firebird-support] > wrote: > > The result are just 8 entr

Re: [firebird-support] Statement freezes firebird

2020-01-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.01.2020 14:49, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > The result are just 8 entries. Sorting those 3 entries should then take no > time at all, right? Wrong. Sorting happens before result set limit apply. > Any ideas? Rule number one:

Re: [firebird-support] Statement freezes firebird

2020-01-24 Thread Matthias Winkler spmm...@gmail.com [firebird-support]
the last "order by" it just takes forever... select first(8) ID from TBL_TEST where ID not in (select first(2) ID from TBL_TEST order by ID desc) order by ID desc Any ideas? On Fri, Jan 24, 2020 at 2:39 PM Dimitry Sibiryakov s...@ibphoenix.com [firebird-suppo

Re: [firebird-support] Statement freezes firebird

2020-01-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.01.2020 14:29, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > I see the very same issue with firebird 3.0.4. Any ideas? You made nested loop on 18000*18000 records with sorting on each itaretion. It cannot be fast. -- WBR,

Re: [firebird-support] Statement freezes firebird

2020-01-24 Thread Gabor Boros mlngl...@bgss.hu [firebird-support]
2020. 01. 24. 14:29 keltezéssel, Matthias Winkler spmm...@gmail.com [firebird-support] írta: > @Mark: I see the very same issue with firebird 3.0.4. Any ideas? I suggest try with 3.0.5 also. Ga

Re: [firebird-support] Statement freezes firebird

2020-01-24 Thread Matthias Winkler spmm...@gmail.com [firebird-support]
@Mark: I see the very same issue with firebird 3.0.4. Any ideas? On Fri, Jan 24, 2020 at 1:46 PM Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 2020-01-24 13:29, Matthias Winkler spmm...@gmail.com > [firebird-support] wrote: > > Hello, > >

Re: [firebird-support] Statement freezes firebird

2020-01-24 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-01-24 13:29, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > Hello, > > With Firebird 2.1.7 this statement freezes my firebird server > completely. Firebird will > take 100% CPU. > >> select first(8) ID from TBL_TEST >> where ID not in (se

[firebird-support] Statement freezes firebird

2020-01-24 Thread Matthias Winkler spmm...@gmail.com [firebird-support]
Hello, With Firebird 2.1.7 this statement freezes my firebird server completely. Firebird will take 100% CPU. select first(8) ID from TBL_TEST where ID not in (select first(2) ID from TBL_TEST order by ID desc) order by ID desc The used table has about 18`000 entries. If I remove ONE of

Re: [firebird-support] Re: Securing Firebird Embedded database

2020-01-08 Thread Elmar Haneke el...@haneke.de [firebird-support]
Am 20.12.19 um 22:59 schrieb Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support]: > The first would be using DotNetZip to compress and encrypt the Firebird > database file into a zip file with a pass word. The next level of encryption > would be to take the zip file an

Re: [firebird-support] Re: Securing Firebird Embedded database

2019-12-21 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 20/12/2019 16:43, Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support] wrote: > I am curious regarding your suggestion to use Firebird Server instead of the > embedded edition. > > Is there a way to silently install the Firebird Server without any user > interve

[firebird-support] Release of Firebird 3.0.5

2019-12-21 Thread Carsten Schäfer ca_schae...@gmx.de [firebird-support]
Hi, does someone know when Firebird 3.0.5 gets released? I thought the release date should be in 2019  and now we are facing Christmas, so not much time is left. Carsten

Re: [firebird-support] Re: Securing Firebird Embedded database

2019-12-20 Thread Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support]
security scheme built in to the database engine. Steve Naidamast Sr. Software Engineer blackfalconsoftw...@outlook.com [cid:8036d6f0-36cc-4285-90d6-ba5982a222e5] From: firebird-support@yahoogroups.com on behalf of Elmar Haneke el...@haneke.de [firebird

Re: [firebird-support] Re: Securing Firebird Embedded database

2019-12-20 Thread Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support]
blackfalconsoftw...@outlook.com [cid:075acb9c-c9a9-4a54-a258-c1892b39d161] From: firebird-support@yahoogroups.com on behalf of Mark Rotteveel m...@lawinegevaar.nl [firebird-support] Sent: Thursday, December 19, 2019 9:37 AM To: firebird-support@yahoogroups.com Subject

Re: [firebird-support] Re: Securing Firebird Embedded database

2019-12-20 Thread Elmar Haneke el...@haneke.de [firebird-support]
> All other database engines that I have worked with provide password > protection, even SQLite, which is used primarily for desktop and device > applications. I'm not familiar which the technique SQLite uses. But either they are using the password to encrypt database or it is an fake

Re: [firebird-support] Re: Securing Firebird Embedded database

2019-12-20 Thread Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support]
given that all such editions are primarily the same? In any event, thank you once again for your quick reply...  Steve Naidamast Sr. Software Engineer blackfalconsoftw...@outlook.com [cid:5dd563dd-e1c8-41ff-8c06-9187c92572a5] From: firebird-support

Re: [firebird-support] Re: Securing Firebird Embedded database

2019-12-19 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-12-18 16:30, Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support] wrote: > Is there any way to secure the FDB file from unauthorized access > (other than compression and encryption, which I am starting to > implement in my project) and if not, is there

Re: [firebird-support] Re: Securing Firebird Embedded database

2019-12-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.12.2019 16:30, Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support] wrote: > Is there any way to secure the FDB file from unauthorized access (other than > compression > and encryption, which I am starting to implement in my project) No. Firebird is an open sourc

Re: [firebird-support] Re: Securing Firebird Embedded database

2019-12-19 Thread Elmar Haneke el...@haneke.de [firebird-support]
> Is there any way to secure the FDB file from unauthorized access (other than > compression and encryption, which I am starting to implement in my project) > and if not, is there expected to be at least password protection for the > Embedded edition in Firebird 4.0? Password protection does

[firebird-support] Re: Securing Firebird Embedded database

2019-12-18 Thread Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support]
Hello... Is there any way to secure the FDB file from unauthorized access (other than compression and encryption, which I am starting to implement in my project) and if not, is there expected to be at least password protection for the Embedded edition in Firebird 4.0? Thank you... Steve

Re: [firebird-support] Why won't Firebird restore backups from a network drive?

2019-11-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.11.2019 18:53, dco...@sympatico.ca [firebird-support] wrote: > We're actually already doing the backups and restores with the Services API. Usually account used to run Firebird server has no access to network at all. Thus the error you see. -- WBR,

Re: [firebird-support] Why won't Firebird restore backups from a network drive?

2019-11-13 Thread dco...@sympatico.ca [firebird-support]
We're actually already doing the backups and restores with the Services API.

Re: [firebird-support] Why won't Firebird restore backups from a network drive?

2019-11-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.11.2019 16:45, dco...@sympatico.ca [firebird-support] wrote: > Whether I used a mapped drive letter, or a UNC path, if I try to restore a > backup from a > network drive it fails, with a message like "Cannot open file". Don't you by chance try it using Services API or &

[firebird-support] Why won't Firebird restore backups from a network drive?

2019-11-13 Thread dco...@sympatico.ca [firebird-support]
Whether I used a mapped drive letter, or a UNC path, if I try to restore a backup from a network drive it fails, with a message like "Cannot open file". I fully understand why Firebird won't open a database file on a network drive, but I'm trying to do the restore to a DB on a local drive.

Re: [firebird-support] Off-Topic: Firebird future

2019-10-25 Thread Fulvio Senore mail...@fsoft.it [firebird-support]
Il 23/10/2019 17:32, Stefan Heymann li...@stefanheymann.de [firebird-support] ha scritto: >>> For me it must continue with the development of Flamerobin. >>> >>> I know many people who feel very comfortable with him. >>> >>> I really don

Re: [firebird-support] Off-Topic: Firebird future

2019-10-24 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-10-23 17:32, Stefan Heymann li...@stefanheymann.de [firebird-support] wrote: >>> For me it must continue with the development of Flamerobin. >>> >>> I know many people who feel very comfortable with him. >>> >>> I really don

Re: [firebird-support] Off-Topic: Firebird future

2019-10-23 Thread Stefan Heymann li...@stefanheymann.de [firebird-support]
>> For me it must continue with the development of Flamerobin. >> >> I know many people who feel very comfortable with him. >> >> I really don't understand why its development has stopped. > Development of a free open source project happens by virtue of its > contributors. If those

Re: [firebird-support] Off-Topic: Firebird future

2019-10-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-10-22 16:12, 'Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support] wrote: > For me it must continue with the development of Flamerobin. > > I know many people who feel very comfortable with him. > > I really don't understand why its development has stoppe

Re: [firebird-support] Off-Topic: Firebird future

2019-10-22 Thread Lucas Franzen l...@frred.de [firebird-support]
Am 22.10.2019 um 16:08 schrieb 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]: > I wonder, Lucas, what will you be publishing then? :) Well the thingy we wrote. Didn't we?

Re: [firebird-support] Off-Topic: Firebird future

2019-10-22 Thread 'Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]
- From: Lucas Franzen l...@frred.de [firebird-support] To: firebird-support@yahoogroups.com Sent: Tuesday, October 22, 2019 9:50 AM Subject: Re: [firebird-support] Off-Topic: Firebird future Am 22.10.2019 um 15:24 schrieb Stefan Heymann li...@stefanheymann.de [firebird-support

Re: [firebird-support] Off-Topic: Firebird future

2019-10-22 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
22.10.2019 um 15:24 schrieb Stefan Heymann li...@stefanheymann.de [firebird-support]: >>> If you want to have it for free, like in >>> free beer, you can sit down, write it and publish it >> This is the plan. ;-) >> Gabor > > Sounds like a good plan :-)) Yes, I c

Re: [firebird-support] Off-Topic: Firebird future

2019-10-22 Thread Lucas Franzen l...@frred.de [firebird-support]
Am 22.10.2019 um 15:24 schrieb Stefan Heymann li...@stefanheymann.de [firebird-support]: >>> If you want to have it for free, like in >>> free beer, you can sit down, write it and publish it >> This is the plan. ;-) >> Gabor > > Sounds like a good plan :-))

Re: [firebird-support] Off-Topic: Firebird future

2019-10-22 Thread Stefan Heymann li...@stefanheymann.de [firebird-support]
>> If you want to have it for free, like in >> free beer, you can sit down, write it and publish it > This is the plan. ;-) > Gabor Sounds like a good plan :-)) Regards Stefan

Re: [firebird-support] Off-Topic: Firebird future

2019-10-21 Thread blackfalconsoftw...@outlook.com [firebird-support]
that was prevalent in the 1990s when Open Source was just beginning to emerge. Without more modern mechanisms to interact with the Firebird Community and a lack of professional, subscription based support for companies, Firebird has remained in the backwaters of the technical communities, which

Re: [firebird-support] Off-Topic: Firebird future

2019-10-21 Thread Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]
That would be awesome. > On Oct 21, 2019, at 10:29 AM, 'Alexey Kovyazin (ak)' a...@ib-aid.com > <mailto:a...@ib-aid.com> [firebird-support] <mailto:firebird-support@yahoogroups.com>> wrote: > > > Hello Stefan, > > > If Firebird users want to have

Re: [firebird-support] Off-Topic: Firebird future

2019-10-21 Thread Gabor Boros mlngl...@bgss.hu [firebird-support]
2019. 10. 21. 18:17 keltezéssel, Stefan Heymann li...@stefanheymann.de [firebird-support] írta: > If you want to have it for free, like in > free beer, you can sit down, write it and publish it This is the plan. ;-)

Re: [firebird-support] Off-Topic: Firebird future

2019-10-21 Thread 'Alexey Kovyazin (ak)' a...@ib-aid.com [firebird-support]
. Regards, Alexey Kovyazin IBSurgeon пн, 21 окт. 2019 г., 19:24 Stefan Heymann li...@stefanheymann.de [firebird-support] : > > > > > Official or not, we need a simple, up to date, Firebird only, native > > GUI. > > I don't get the point. There are GUI tools readily ava

Re: [firebird-support] Off-Topic: Firebird future

2019-10-21 Thread Stefan Heymann li...@stefanheymann.de [firebird-support]
> Official or not, we need a simple, up to date, Firebird only, native > GUI. I don't get the point. There are GUI tools readily available (IBExpert, Upscene, etc.). If you want to have it for free, like in free beer, you can sit down, write it and publish it (that's how free software is made

Re: [firebird-support] Off-Topic: Firebird future

2019-10-19 Thread Gabor Boros mlngl...@bgss.hu [firebird-support]
2019. 10. 09. 5:57 keltezéssel, Alex Castillo acr_k...@yahoo.com [firebird-support] írta: > I'm asking myself how much time I'll still be using Firebird if the > project evolves slow, there is no t GUI officially maintened and the > cool features are for the commercial companies. Ye

Re: [firebird-support] Re: Install firebird SS 2.5 on Debian 9/10

2019-10-11 Thread 'moj.mail.qmail' moj.mail.qm...@gmail.com [firebird-support]
, pablo sanchez pab...@adinet.com.uy [firebird-support] pisze: Use compressed tarball, instead of rpm package . https://github.com/FirebirdSQL/firebird/releases/download/R2_5_9/FirebirdSS-2.5.9.27139-0.amd64.tar.gz You me have to install libtommath (apt-get install libtommath) and create a softlink

Re: [firebird-support] Off-Topic: Firebird future

2019-10-09 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
time. It cannot addapt to value provided in parameter by histogram use. 16. Firebird have really good CTE also recursive where you can provide almost every feature avaiable in normal sql. 17. Firebird have quite good support. But i suppose, team do not have dedicated person for this point

[firebird-support] Off-Topic: Firebird future

2019-10-08 Thread Alex Castillo acr_k...@yahoo.com [firebird-support]
Hello everyone, I've been using FB since version 1 and I have only good comments about the database quality and performance. However, It's true that the development has evolved too slow and we had to wait almost 10 years since the first release to get a real SMP support (I know that's tricky

[firebird-support] Re: Install firebird SS 2.5 on Debian 9/10

2019-09-20 Thread pablo sanchez pab...@adinet.com.uy [firebird-support]
to /usr/lib/x86_64-linux-gnu/libtommath.so.1.1.0 Regards On 9/19/19 1:40 PM, 'moj.mail.qmail' moj.mail.qm...@gmail.com [firebird-support] wrote: > Hello, could someone help me install fb 2.5 on Debian 9 (buster)? > > I've installed Firebird from > https://github.com/FirebirdSQL/fireb

[firebird-support] Re: Install firebird SS 2.5 on Debian 9/10

2019-09-20 Thread pablo sanchez pab...@adinet.com.uy [firebird-support]
to /usr/lib/x86_64-linux-gnu/libtommath.so.1.1.0 Regards On 9/19/19 1:40 PM, 'moj.mail.qmail' moj.mail.qm...@gmail.com [firebird-support] wrote: > Hello, could someone help me install fb 2.5 on Debian 9 (buster)? > > I've installed Firebird from > https://github.com/FirebirdSQL/fireb

[firebird-support] Re: Install firebird SS 2.5 on Debian 9/10

2019-09-20 Thread pablo sanchez pab...@adinet.com.uy [firebird-support]
to /usr/lib/x86_64-linux-gnu/libtommath.so.1.1.0 Regards On 9/19/19 1:40 PM, 'moj.mail.qmail' moj.mail.qm...@gmail.com [firebird-support] wrote: > Hello, could someone help me install fb 2.5 on Debian 9 (buster)? > > I've installed Firebird from > https://github.com/FirebirdSQL/fireb

[firebird-support] Re: Install firebird SS 2.5 on Debian 9/10

2019-09-20 Thread pablo sanchez pab...@adinet.com.uy [firebird-support]
to /usr/lib/x86_64-linux-gnu/libtommath.so.1.1.0 Regards On 9/19/19 1:40 PM, 'moj.mail.qmail' moj.mail.qm...@gmail.com [firebird-support] wrote: > Hello, could someone help me install fb 2.5 on Debian 9 (buster)? > > I've installed Firebird from > https://github.com/FirebirdSQL/fireb

Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

2019-09-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.09.2019 13:53, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > but the UDFs I haven’t change in. So a leak in them (if any) has no chance to be fixed. > How can I delimit this leak? Can I debug > the memory? Developers version of Firebird writes memory leaks

AW: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

2019-09-03 Thread 'Check_Mail' check_m...@satron.de [firebird-support]
Hello Dmitry, but the UDFs I haven’t change in. How can I delimit this leak? Can I debug the memory? -Ursprüngliche Nachricht- Von: firebird-support@yahoogroups.com Gesendet: Dienstag, 3. September 2019 13:17 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support

Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

2019-09-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.09.2019 13:12, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > How can I understand this gap? The biggest probability is a memory leak in your UDFs. -- WBR,

AW: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

2019-09-03 Thread 'Check_Mail' check_m...@satron.de [firebird-support]
(2GB). This problem occurred only recently with no major changes in our database. Maybe windowsupdates have been a part of the problem? The clients uses firebird ODBC (MS Access) and some clients are written in C. Thanks a lot. -Ursprüngliche Nachricht- Von: firebird-support

Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

2019-09-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.09.2019 12:10, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > if we use the default firebird.conf with #CpuAffinityMask = 0, does firebird > use all > cpus/cores? Or should I set it to 15 for 4 cores? I have found some > information for the > 2.5 only. Fo

[firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

2019-09-03 Thread 'Check_Mail' check_m...@satron.de [firebird-support]
Hello, if we use the default firebird.conf with #CpuAffinityMask = 0, does firebird use all cpus/cores? Or should I set it to 15 for 4 cores? I have found some information for the 2.5 only. We have some memory-problems on firebird 3.0.1 32 Bit Superserver on server 2008 32 Bit, the one

RE: [firebird-support] Re: run firebird engine without fbguard

2019-07-16 Thread Yassir Kozha yassir.ko...@rohde-schwarz.com [firebird-support]
From: firebird-support@yahoogroups.com Sent: Monday, July 15, 2019 12:17 PM To: firebird-support@yahoogroups.com Subject: *EXT* [firebird-support] Re: run firebird engine without fbguard First of all I do not understand initial problem: [Kozha Yassir] In case firebird engine crashed, I don’t

Re: [firebird-support] Re: run firebird engine without fbguard

2019-07-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.07.2019 12:16, peshk...@mail.ru [firebird-support] wrote: > server does not contain code to daemonize itself, i.e. you will have to > perform all > required for it activity yourself. systemd does not require daemonization from services. If firebird use own listener it

[firebird-support] Re: run firebird engine without fbguard

2019-07-15 Thread peshk...@mail.ru [firebird-support]
First of all I do not understand initial problem: > The problem with this approach is that when killing the firebird engine > process ‘SIGKILL’ When firebird server is killed with any signal except 2 & 15 it's restarted by guardian, i.e. guardian does not exit.

Re: [firebird-support] Help with Firebird date ranges.

2019-05-02 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Hello traceya...@yahoo.com.au, Thursday, May 2, 2019, 11:15:24 PM, you wrote: > I am a complete noobie in regards Firebird, :-( and I have 1 system with that > has Firebird installed. > I need to be able to report on the last 7 days data from the date a report is > run. > Currently i have

[firebird-support] Help with Firebird date ranges.

2019-05-02 Thread traceya...@yahoo.com.au [firebird-support]
I am a complete noobie in regards Firebird, :-( and I have 1 system with that has Firebird installed. I need to be able to report on the last 7 days data from the date a report is run. Currently i have managed to cobble together (from a script, i have found) a script that will run and

RE: [firebird-support] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined

2019-04-26 Thread 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support]
<> Yes, by default we build and install as a Framework on MacOS, which means as part of the build process we finesse the locations of all the relevant libraries and executables etc using the install_name_tool. If you look at the source code specifically posix/postfix.darwin, and you will need

Re: [firebird-support] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined

2019-04-25 Thread Anil anil.muja...@gmail.com [firebird-support]
- libicuuc.dylib >- libicui18n.dylib > > > > On Fri, Apr 12, 2019 at 1:12 PM Mark Rotteveel m...@lawinegevaar.nl > [firebird-support] wrote: > >> >> >> On 2019-04-11 20:03, Dimitry Sibiryakov s...@ibphoenix.com >> [firebird-support] wrote: >> >

Re: [firebird-support] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined

2019-04-25 Thread Anil anil.muja...@gmail.com [firebird-support]
BTW, what are the equivalents of these libraries on macOS? I didn't manage to solve the issue on macOS by including these: - libicudata.dylib - libib_util.dylib - libicuuc.dylib - libicui18n.dylib On Fri, Apr 12, 2019 at 1:12 PM Mark Rotteveel m...@lawinegevaar.nl [firebird-support

Re: [firebird-support] Re: Automating Firebird maintenance on Linux

2019-04-19 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 17-4-2019 15:10, my...@techsol.org [firebird-support] wrote: > Yes, but gfix refuses to shutdown the database to single user > maintenance mode if there are any existing connections to it.  That is > the main problem - I need to kill those connections and prevent new ones > from

Re: [firebird-support] Re: Automating Firebird maintenance on Linux

2019-04-17 Thread Hamish Moffatt ham...@risingsoftware.com [firebird-support]
On 17/4/19 11:12 pm, my...@techsol.org [firebird-support] wrote: Thanks Steve.  That's interesting.  I forgot about stopping xinetd.  So if I understand you right, you are suggesting the following: 1.  Review all FB processes (ps -ax | grep fbserver) and kill -9 on those Yikes. You

Re: [firebird-support] Re: Automating Firebird maintenance on Linux

2019-04-17 Thread Steve Wiser st...@specializedbusinesssoftware.com [firebird-support]
at 10:20 AM my...@techsol.org [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Thanks Steve. That's interesting. I forgot about stopping xinetd. So if > I understand you right, you are suggesting the following: > > 1. Review all FB processes (ps -ax |

Re: [firebird-support] Re: Automating Firebird maintenance on Linux

2019-04-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.04.2019 15:10, my...@techsol.org [firebird-support] wrote: > but gfix refuses to shutdown the database to single user maintenance mode if > there are any > existing connections to it. Use -force_shutdown. --

[firebird-support] Re: Automating Firebird maintenance on Linux

2019-04-17 Thread my...@techsol.org [firebird-support]
Thanks Steve. That's interesting. I forgot about stopping xinetd. So if I understand you right, you are suggesting the following: 1. Review all FB processes (ps -ax | grep fbserver) and kill -9 on those 2. Shutdown the service of xinetd 3. gfix to single user - then do maintenance 4.

Re: [firebird-support] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined

2019-04-12 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-04-11 20:03, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 11.04.2019 18:02, Anil anil.muja...@gmail.com [firebird-support] wrote: >> It seems that the DB creation on Windows is resulting in an invalid DB >> file. > >Yes. Because you did

Re: [firebird-support] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined

2019-04-11 Thread Anil anil.muja...@gmail.com [firebird-support]
[firebird-support] wrote: > 11.04.2019 18:02, Anil anil.muja...@gmail.com [firebird-support] wrote: > > It seems that the DB creation on Windows is resulting in an invalid DB > file. > >Yes. Because you didn't put all necessary files into proper directory > structure, >

Re: [firebird-support] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined

2019-04-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
11.04.2019 18:02, Anil anil.muja...@gmail.com [firebird-support] wrote: > It seems that the DB creation on Windows is resulting in an invalid DB file. Yes. Because you didn't put all necessary files into proper directory structure, Firebird engine failed to load fbintl module. Database f

[firebird-support] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined

2019-04-11 Thread Anil anil.muja...@gmail.com [firebird-support]
I'm using Firebird 3.0 from .NET Core 2.1 application in embedded mode. Database is created using FbConnection.CreateDatabase. However, when trying to execute first query I get following exception. The application works fine on Windows 10 development machine, but I wanted to test the deployment

Re: [firebird-support] Ubuntu 18.04 Firebird 3.03 Server Connection String: Local Works, URL-Style Fails

2019-04-05 Thread LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
On Fri, Apr 5, 2019 at 6:32 PM Rustam rusta...@ukr.net [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Check your FB client library. May be you are using 'embed' version > ('fbembed' instead of 'fbclient', or 'fbembed' renamed to 'fbclient') > 1. Edit the

[firebird-support] Ubuntu 18.04 Firebird 3.03 Server Connection String: Local Works, URL-Style Fails

2019-04-05 Thread Rustam rusta...@ukr.net [firebird-support]
Check your FB client library. May be you are using 'embed' version ('fbembed' instead of 'fbclient', or 'fbembed' renamed to 'fbclient')

Re: [firebird-support] Ubuntu 18.04 Firebird 3.03 Server Connection String: Local Works, URL-Style Fails

2019-04-05 Thread LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
On Fri, Apr 5, 2019 at 4:49 PM Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 2019-04-05 12:22, LtColRDSChauhan rdsc1...@gmail.com > [firebird-support] wrote: > > Hello, > > > > 1. The following connection string works: > > > &

Re: [firebird-support] Ubuntu 18.04 Firebird 3.03 Server Connection String: Local Works, URL-Style Fails

2019-04-05 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-04-05 12:22, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > Hello, > > 1. The following connection string works: > > /home/ubuntu_user/Documents/Sample.FDB > > 2. While following connection strings fails: > Ubuntu_Machine:/home/ubuntu_u

Re: [firebird-support] Ubuntu 18.04 Firebird 3.03 Server Connection String: Local Works, URL-Style Fails

2019-04-05 Thread LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
On Fri, Apr 5, 2019 at 4:00 PM Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 05.04.2019 12:22, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] > wrote: > > 2. While following connection strings fails: > > Ubuntu_Machine:/home/ubuntu_user/Do

Re: [firebird-support] Ubuntu 18.04 Firebird 3.03 Server Connection String: Local Works, URL-Style Fails

2019-04-05 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
05.04.2019 12:22, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > 2. While following connection strings fails: > Ubuntu_Machine:/home/ubuntu_user/Documents/Sample.FDB > localhost:/home/ubuntu_user/Documents/Sample.FDB > 127.0.0.1:/home/ubuntu_user/Documents/Sample.FDB

[firebird-support] Ubuntu 18.04 Firebird 3.03 Server Connection String: Local Works, URL-Style Fails

2019-04-05 Thread LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
Hello, 1. The following connection string works: /home/ubuntu_user/Documents/Sample.FDB 2. While following connection strings fails: Ubuntu_Machine:/home/ubuntu_user/Documents/Sample.FDB localhost:/home/ubuntu_user/Documents/Sample.FDB 127.0.0.1:/home/ubuntu_user/Documents/Sample.FDB 3. The

[firebird-support] Fw: Connect Firebird Database with Entity Framework model - Connection Failed

2019-03-04 Thread Kathir Esan kathiresan...@yahoo.com [firebird-support]
Hi All, I want to connect the Firebird database with Entity Framework Model. Completed the successful installation and created the database. But, I am facing some issues while connecting the firebird with entity model. * Updated the values like below. But facing the issue ‘Unable to load dll

Re: [firebird-support] Re: New Firebird project/OpenEMR/Wind8.1/asgalib20/#201902a

2019-02-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
19.02.2019 20:03, blackfalconsoftw...@outlook.com [firebird-support] wrote: > Mark is correct in his previous reply as I went through some of the > documentation for the > Open EMR System.  The OpenEMR system makes use of the MySQL database engine, > not Firebird. I guess the a

[firebird-support] Re: New Firebird project/OpenEMR/Wind8.1/asgalib20/#201902a

2019-02-19 Thread blackfalconsoftw...@outlook.com [firebird-support]
Mark is correct in his previous reply as I went through some of the documentation for the Open EMR System. The OpenEMR system makes use of the MySQL database engine, not Firebird. You can look at the following two links for installation guidance for this system on windows...

Re: [firebird-support] Typo in Firebird Butler announcement

2019-02-01 Thread valdir.mar...@ig.com.br [firebird-support]
The typo still persists in the following links: http://ibphoenix.com/ https://www.firebirdnews.org/ https://www.firebirdnews.org/introducing-firebird-butler/ Thanks. Em 01/02/2019 04:46, valdir.mar...@ig.com.br [firebird-support] escreveu: > There is a typo in: > https://firebirdsql.

Re: ODP: ODP: [firebird-support] Re: Introducing Firebird Butler

2019-02-01 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-support]
Hi, Dne 01. 02. 19 v 14:10 Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] napsal(a): >>> You completely misunderstood the announcement. The Firebird Butler is a >>> thing that we develop. > > I am really interested if i am only one  And because of th

ODP: ODP: [firebird-support] Re: Introducing Firebird Butler

2019-02-01 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
>>You completely misunderstood the announcement. The Firebird Butler is a >>thing that we develop. I am really interested if i am only one  And because of this i am talking about any example as a first steep. >> Steam-like deployment platform for Butler services provided by Firebird Ok,

Re: ODP: [firebird-support] Re: Introducing Firebird Butler

2019-02-01 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-support]
Hi, Dne 01. 02. 19 v 8:04 Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] napsal(a): > > If you or someone can show me (and maybe others are also interested) any real > benefit, example, than i am more than interested in this. > And i am not only interes

Re: [firebird-support] Re: Introducing Firebird Butler

2019-02-01 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-support]
Hi, Dne 31. 01. 19 v 20:54 blackfalconsoftw...@outlook.com [firebird-support] napsal(a): > II... > My understanding of the Firebird Butler project could be two-fold... > A specification for best practices for developing distributed systems using > the Firebird Database

Re: [firebird-support] Re: Introducing Firebird Butler

2019-02-01 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-support]
Hi, Dne 31. 01. 19 v 21:05 blackfalconsoftw...@outlook.com [firebird-support] napsal(a): > > Has anyone considered using ZeroC's Ice Framework? Ice is classic RPC framework with all its limits and drawbacks. We think that RPC is wrong abstraction model to create dynamic heterog

ODP: [firebird-support] Re: Introducing Firebird Butler

2019-01-31 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
Thank you to be involved into discussion. But i am still oposite. Example do not required any unique description. Example is not less/more than only shortcut to description. It is introduction to description. Description can talk about example or will be totally unreleated. But example is

[firebird-support] Typo in Firebird Butler announcement

2019-01-31 Thread valdir.mar...@ig.com.br [firebird-support]
There is a typo in: https://firebirdsql.org/en/start/ and: https://firebirdsql.org/en/news/introducing-firebird-butler/ "alongside the core (Fierbird database system) and database drivers." There is a "FiERbird" instead of "FiREbird." Thanks.

[firebird-support] Re: Introducing Firebird Butler

2019-01-31 Thread blackfalconsoftw...@outlook.com [firebird-support]
Just a question about the use of ZeroMQ... Has anyone considered using ZeroC's Ice Framework? It appears to be a much more finished product with better diocumentation than ZeroMQ and is completely Open Source... Steve Naidamast Sr. Software Engineer

[firebird-support] Re: Introducing Firebird Butler

2019-01-31 Thread blackfalconsoftw...@outlook.com [firebird-support]
I have two comments on this thread... I... The examples provided (I & II) do not necessarily show a correct pattern of either. In the first example, the assumption can be made that the description is unique and thus requires a unique example. The second is merely a reverse of the

[firebird-support] UDFs for Firebird 1.5 on CentOS 7 64 Bit

2018-12-21 Thread my...@techsol.org [firebird-support]
Firstly I realize I am asking for support on a very old Firebird version that is no longer supported. However I'm in a situation where the upgrading of these FB 1.5 databases to 3.x will take some time, and I need to get an interim solution in place. I have been successfully able to get

Re: [firebird-support] very slow firebird embedded connection on a web application

2018-12-12 Thread Issam Boughanmi amigof...@gmail.com [firebird-support]
-support] a écrit : > 12.12.2018 17:18, Issam Boughanmi amigof...@gmail.com [firebird-support] > wrote: > > also sometimes i have a Network Error (tcp_error) during my various > tests changes . > >It means that you are wrong in your assumption about using of an > embedded

  1   2   3   4   5   6   >