Re: [firebird-support] FB3 Embedded Firedac Error
>This is quite interesting, if the service is stopped and no Firebird server >running, then how can you access the database, it might be that you >already >correctly setup the embedded server and the application load the embedded >server IB-Expert and Delphi still running with all databases.Probably the shutdown function is missing on FB 3, or the default engine is Embedded case it is off. Em terça-feira, 3 de setembro de 2019 09:23:59 BRT, Iwan Cahyadi Sugeng iwan.c.sug...@gmail.com [firebird-support] escreveu: See my replies below On Tue, Sep 3, 2019 at 1:13 PM Elton Fadel galdari...@yahoo.com.br [firebird-support] wrote: Thanks, Mark! It worked! I also notice something very interesting during my tests: 1. No matter if you use Firebird if a Service or Application, even without installing the guardian:Stop the Service or do Shutdown of the Application on tray icon has zero effect! It stays working normally on Delphi, IB-Expert and in your Applications.You really need to completely uninstall Firebird on Windows Settings. This is quite interesting, if the service is stopped and no Firebird server running, then how can you access the database, it might be that you already correctly setup the embedded server and the application load the embedded server 2. Delphi (Firedac at least) in Design Time uses BY DEFAULT Firebird installed on your machine, whatever if it is stoped or running (explained above).On Runtime it will use the settings that you have, to use Embedded. So, stay alert: You can't use Embedded in Design Time if you have Firebird installed on or machine. You need a complete uninstall to do it. Anyway, it works! Thanks again. Em terça-feira, 3 de setembro de 2019 02:00:25 BRT, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] escreveu: On 3-9-2019 05:38, Elton Fadel galdari...@yahoo.com.br [firebird-support] wrote: > /5. This error occurs when you are using a 'fbclient.dll' that doesn't have > access to 'plugins/engine12.dll'./ > /5b. This error can occur if your application is 32 > bit and the Firebird files are 64 bit (or vice versa), then at runtime > it could loads a different fbclient.dll./ > > *==About my installation and Fbclient.dll==* > *\Windows executable installer/* > https://github.com/FirebirdSQL/firebird/releases/download/R3_0_4/Firebird-3.0.4.33054_0_Win32. > > exe: > C:\Program Files (x86)\Firebird\Firebird_3_0\fbclient.dll > > *\Zip kit for manual/custom installs/* > https://github.com/FirebirdSQL/firebird/releases/download/R3_0_4/Firebird-3.0.4.33054-0_Win32.zip: > D:\Desktop\Server\EDBMS\fbclient.dll > > *Both are the same file: 3.0.4.33054 and both with 1.369.088 bytes.* > /6. You could use sysinternal procmon to check which files actually get > loaded and used./ > > *Apparently, there's no need and I even don't know how to do it.* Why is there "no need"? If you want to solve your problem, it is good to know which libraries get loaded by your application. I have only ever seen this error when plugins\engine12.dll is either not present in the folder with fbclient.dll, or with different bitness between application and client, or client and engine12.dll. > /7. In firebird.conf, what is the setting for Providers?/ > > *#Providers = Remote,Engine12,Loopback > *But i also tried only:* > * > *#Providers = Engine12* When it is prefixed with a # it is a comment, if you want to try with Providers = Engine12, then you need to remove the #. Mark -- Mark Rotteveel #yiv7328498315 #yiv7328498315 -- #yiv7328498315ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7328498315 #yiv7328498315ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7328498315 #yiv7328498315ygrp-mkp #yiv7328498315hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7328498315 #yiv7328498315ygrp-mkp #yiv7328498315ads {margin-bottom:10px;}#yiv7328498315 #yiv7328498315ygrp-mkp .yiv7328498315ad {padding:0 0;}#yiv7328498315 #yiv7328498315ygrp-mkp .yiv7328498315ad p {margin:0;}#yiv7328498315 #yiv7328498315ygrp-mkp .yiv7328498315ad a {color:#ff;text-decoration:none;}#yiv7328498315 #yiv7328498315ygrp-sponsor #yiv7328498315ygrp-lc {font-family:Arial;}#yiv7328498315 #yiv7328498315ygrp-sponsor #yiv7328498315ygrp-lc #yiv7328498315hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7328498315 #yiv7328498315ygrp-sponsor #yiv7328498315ygrp-lc .yiv7328498315ad {margin-bottom:10px;padding:0 0;}#yiv7328498315 #yiv7328498315actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7328498315 #yiv7328498315activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7328498315 #yiv7328498315activity span {font-weight:700;}#yiv7328498315 #yiv7328498315activity span:first-child {text-transform:uppercase;}#yiv7328498315 #yiv7328498315activity span a
Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage
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 into file on exit. You can use it for debugging. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ 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-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] FB3 Embedded Firedac Error
See my replies below On Tue, Sep 3, 2019 at 1:13 PM Elton Fadel galdari...@yahoo.com.br [firebird-support] wrote: > > > > Thanks, Mark! *It worked!* > > I also notice something very interesting during my tests: > > 1. No matter if you use Firebird if a Service or Application, even without > installing the guardian: > Stop the Service or do Shutdown of the Application on tray icon has zero > effect! > It stays working normally on Delphi, IB-Expert and in your Applications. > You really need to completely uninstall Firebird on Windows Settings. > > This is quite interesting, if the service is stopped and no Firebird server running, then how can you access the database, it might be that you already correctly setup the embedded server and the application load the embedded server > 2. Delphi (Firedac at least) in Design Time uses BY DEFAULT Firebird > installed on your machine, whatever if it is stoped or running (explained > above). > On Runtime it will use the settings that you have, to use Embedded. So, > stay alert: You can't use Embedded in Design Time if you have Firebird > installed on or machine. You need a complete uninstall to do it. > > Anyway, it works! > Thanks again. > Em terça-feira, 3 de setembro de 2019 02:00:25 BRT, Mark Rotteveel > m...@lawinegevaar.nl [firebird-support] > escreveu: > > > > > On 3-9-2019 05:38, Elton Fadel galdari...@yahoo.com.br > [firebird-support] wrote: > > /5. This error occurs when you are using a 'fbclient.dll' that doesn't > have > > access to 'plugins/engine12.dll'./ > > /5b. This error can occur if your application is 32 > > bit and the Firebird files are 64 bit (or vice versa), then at runtime > > it could loads a different fbclient.dll./ > > > > *==About my installation and Fbclient.dll==* > > *\Windows executable installer/* > > > https://github.com/FirebirdSQL/firebird/releases/download/R3_0_4/Firebird-3.0.4.33054_0_Win32. > > > exe: > > C:\Program Files (x86)\Firebird\Firebird_3_0\fbclient.dll > > > > *\Zip kit for manual/custom installs/* > > > https://github.com/FirebirdSQL/firebird/releases/download/R3_0_4/Firebird-3.0.4.33054-0_Win32.zip > : > > D:\Desktop\Server\EDBMS\fbclient.dll > > > > *Both are the same file: 3.0.4.33054 and both with 1.369.088 bytes.* > > > /6. You could use sysinternal procmon to check which files actually get > > loaded and used./ > > > > *Apparently, there's no need and I even don't know how to do it.* > > Why is there "no need"? If you want to solve your problem, it is good to > know which libraries get loaded by your application. > > I have only ever seen this error when plugins\engine12.dll is either not > present in the folder with fbclient.dll, or with different bitness > between application and client, or client and engine12.dll. > > > /7. In firebird.conf, what is the setting for Providers?/ > > > > *#Providers = Remote,Engine12,Loopback > > *But i also tried only:* > > * > > *#Providers = Engine12* > > When it is prefixed with a # it is a comment, if you want to try with > Providers = Engine12, then you need to remove the #. > > Mark > -- > Mark Rotteveel > > >
AW: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage
Hello Dmitry, but the UDFs I havent 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] CpuAffinityMask on firebird 3.X and firebird memory leakage 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, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage
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, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ 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-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
AW: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage
Hello Dimitry, Thank you. I have checked the monitoring table, the sum of active memory usage is 160MB, the max usage around 290MB. But the firebird process takes up ca. 730MB. How can I understand this gap? Also the memory usage of the firebird.exe increases over the time till the max of 32Bit (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@yahoogroups.com Gesendet: Dienstag, 3. September 2019 12:28 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage 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. For Firbird 3 CPU affinity has no point. > Does upgrading to 3.04 fix that problem or should we use the classic server? In the future, we should install a 64 Bit Windows, but the existing udf-files do not work with this architecture. You must detect where problem is before one can tell for sure whether it will be fixed or not. Start from inspecting MON$MEMORY_USAGE. In any case 3.0.4 has a lot of bugfixes so it is better to upgrade even if it cannot solve your memory problem. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage
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. For Firbird 3 CPU affinity has no point. > Does upgrading to 3.04 fix that problem or should we use the classic server? > In the future, we should install a 64 Bit Windows, but the existing udf-files > do not work with this architecture. You must detect where problem is before one can tell for sure whether it will be fixed or not. Start from inspecting MON$MEMORY_USAGE. In any case 3.0.4 has a lot of bugfixes so it is better to upgrade even if it cannot solve your memory problem. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ 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-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage
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 process increases to 2GB in RAM and then the server accepts no new connections. Does upgrading to 3.04 fix that problem or should we use the classic server? In the future, we should install a 64 Bit Windows, but the existing udf-files do not work with this architecture. Another question, we would like to update an old client to 64Bit architecture in C Visual Studio 2005, and therefore we need instead of the ib_util the ib_util64 libraries. The ib_util_malloc were not found during compiling. Thank you. Regards Olaf
Re: [firebird-support] Performance of deleting records based on another table
On 8/28/19 6:47 AM, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > Den 2019-08-17 kl. 12:51, skrev Joost van der Sluis jo...@cnoc.nl > [firebird-support]: > > > > Hi all, > > > > I finally realized today that I do not know how to properly remove > > records based on another table. > > > > Suppose I have two tables, one with data (called BIG), and one table > > (SMALL) with only some id's that has to be removed from the BIG-table. > > > > I cannot get this to work, without having Firebird looping over all > > records in BIG naturally, once for each record in SMALL. > > > > This is a problem I have faced many times. The best solution I've been > able to find is an execute block statement that iterates the records in > SMALL and uses a "delete ... where big.id = :found_small_id" statement > to delete each matching BIG record. Something like this (including set > term if required for your SQL tool): > > set term #; > execute block as > declare id int; > begin > for select small.id from small into :id > do delete from big where id = :id; > end# > set term ;# Thanks for the confirmation. I still find it strange, though. Would be nice if someone could come up with a solution for this. By improving the planning-engine (or how it is called). Or maybe adapt 'merge' so it also allows deletes. Regards, Joost.
Re: [firebird-support] FB3 Embedded Firedac Error
Thanks, Mark! It worked! I also notice something very interesting during my tests: 1. No matter if you use Firebird if a Service or Application, even without installing the guardian:Stop the Service or do Shutdown of the Application on tray icon has zero effect! It stays working normally on Delphi, IB-Expert and in your Applications.You really need to completely uninstall Firebird on Windows Settings. 2. Delphi (Firedac at least) in Design Time uses BY DEFAULT Firebird installed on your machine, whatever if it is stoped or running (explained above).On Runtime it will use the settings that you have, to use Embedded. So, stay alert: You can't use Embedded in Design Time if you have Firebird installed on or machine. You need a complete uninstall to do it. Anyway, it works! Thanks again. Em terça-feira, 3 de setembro de 2019 02:00:25 BRT, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] escreveu: On 3-9-2019 05:38, Elton Fadel galdari...@yahoo.com.br [firebird-support] wrote: > /5. This error occurs when you are using a 'fbclient.dll' that doesn't have > access to 'plugins/engine12.dll'./ > /5b. This error can occur if your application is 32 > bit and the Firebird files are 64 bit (or vice versa), then at runtime > it could loads a different fbclient.dll./ > > *==About my installation and Fbclient.dll==* > *\Windows executable installer/* > https://github.com/FirebirdSQL/firebird/releases/download/R3_0_4/Firebird-3.0.4.33054_0_Win32. > > exe: > C:\Program Files (x86)\Firebird\Firebird_3_0\fbclient.dll > > *\Zip kit for manual/custom installs/* > https://github.com/FirebirdSQL/firebird/releases/download/R3_0_4/Firebird-3.0.4.33054-0_Win32.zip: > D:\Desktop\Server\EDBMS\fbclient.dll > > *Both are the same file: 3.0.4.33054 and both with 1.369.088 bytes.* > /6. You could use sysinternal procmon to check which files actually get > loaded and used./ > > *Apparently, there's no need and I even don't know how to do it.* Why is there "no need"? If you want to solve your problem, it is good to know which libraries get loaded by your application. I have only ever seen this error when plugins\engine12.dll is either not present in the folder with fbclient.dll, or with different bitness between application and client, or client and engine12.dll. > /7. In firebird.conf, what is the setting for Providers?/ > > *#Providers = Remote,Engine12,Loopback > *But i also tried only:* > * > *#Providers = Engine12* When it is prefixed with a # it is a comment, if you want to try with Providers = Engine12, then you need to remove the #. Mark -- Mark Rotteveel #yiv0610135399 #yiv0610135399 -- #yiv0610135399ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0610135399 #yiv0610135399ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0610135399 #yiv0610135399ygrp-mkp #yiv0610135399hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0610135399 #yiv0610135399ygrp-mkp #yiv0610135399ads {margin-bottom:10px;}#yiv0610135399 #yiv0610135399ygrp-mkp .yiv0610135399ad {padding:0 0;}#yiv0610135399 #yiv0610135399ygrp-mkp .yiv0610135399ad p {margin:0;}#yiv0610135399 #yiv0610135399ygrp-mkp .yiv0610135399ad a {color:#ff;text-decoration:none;}#yiv0610135399 #yiv0610135399ygrp-sponsor #yiv0610135399ygrp-lc {font-family:Arial;}#yiv0610135399 #yiv0610135399ygrp-sponsor #yiv0610135399ygrp-lc #yiv0610135399hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0610135399 #yiv0610135399ygrp-sponsor #yiv0610135399ygrp-lc .yiv0610135399ad {margin-bottom:10px;padding:0 0;}#yiv0610135399 #yiv0610135399actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0610135399 #yiv0610135399activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0610135399 #yiv0610135399activity span {font-weight:700;}#yiv0610135399 #yiv0610135399activity span:first-child {text-transform:uppercase;}#yiv0610135399 #yiv0610135399activity span a {color:#5085b6;text-decoration:none;}#yiv0610135399 #yiv0610135399activity span span {color:#ff7900;}#yiv0610135399 #yiv0610135399activity span .yiv0610135399underline {text-decoration:underline;}#yiv0610135399 .yiv0610135399attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0610135399 .yiv0610135399attach div a {text-decoration:none;}#yiv0610135399 .yiv0610135399attach img {border:none;padding-right:5px;}#yiv0610135399 .yiv0610135399attach label {display:block;margin-bottom:5px;}#yiv0610135399 .yiv0610135399attach label a {text-decoration:none;}#yiv0610135399 blockquote {margin:0 0 0 4px;}#yiv0610135399 .yiv0610135399bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0610135399 .yiv0610135399bold a {text-decoration:none;}#yiv0610135399 dd.yiv0610135399last p a {font-family:Verdana;font-weight:700;}#yiv0610135399 dd.yiv0610135399last p span