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

['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] 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

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

['Check_Mail' check_m...@satron.de [firebird-support]]

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

AW: [firebird-support] differences between firebird 2.5 cs and 3.0 rc2 ss

['Checkmail' check_m...@satron.de [firebird-support]]

Many Thanks, Ann :)

 

Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
Gesendet: Samstag, 5. März 2016 20:29
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] differences between firebird 2.5 cs and 3.0 rc2 
ss

 

  

On Fri, Mar 4, 2016 at 3:22 AM, 'Checkmail' check_m...@satron.de 
  [firebird-support] 
 > 
wrote:

 

 

If I must go back tot he 2.5 version of firebird, how can I gbak the new 
backup-file to the old version?

 

If you haven't used V3 features in data definitions or the new authorization 
options, reverting is pretty easy.  Leave V3 installed for the backup.   Find a 
copy of gbak from a 2.5 distribution and use it to create a backup file.  
Install Firebird 2.5.x and use the 2.5.x gbak to restore the database.  If 
you've used 3.0 features including the various authorization options, you'll 
probably need to extract the database metadata, edit out references to new 
features and create a new V2.5.x database in a separate environment.  You'll 
need to have both versions of Firebird available simultaneously.  Use one of 
the database migration tools to copy the data from thoe V3 database to the V 
2.5  You can find migration tools here: 
http://ibphoenix.com/download/tools/migration

 

Good luck,

 

Ann

AW: [firebird-support] differences between firebird 2.5 cs and 3.0 rc2 ss

['Checkmail' check_m...@satron.de [firebird-support]]

Ann, another question.

 

If I must go back tot he 5.5 version of firebird, how can I gbak the new 
backup-file to the old version?

 

Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
Gesendet: Donnerstag, 3. März 2016 17:53
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] differences between firebird 2.5 cs and 3.0 rc2 
ss

 

  

On Thu, Mar 3, 2016 at 11:16 AM, 'Checkmail' check_m...@satron.de 
  [firebird-support] 
 > 
wrote:

 

 

I’ve postet my problems with the new odbc driver and firebird 2.5 cs, the slow 
queries and all other issus. Now I have installed the firebird 3.0 rc2, the 
performance is great, superservers takes all cpu-cores and the problems now 
banned. I have not changed anything, is this a result of the superserver or the 
version 3 of firebird?

 

Both.  Firebird V3 introduces parallel execution of queries in SuperServer.  
SuperServer was always multi-threaded but only one thread could run at any one 
time even on a multi-processor server.  The benefit of threading in earlier 
versions was that queries could be interleaved, so a long report didn't block 
all other requests.  With V3, thread do run in parallel taking advantage of all 
the processing power of a multi-core machine.

 

Glad things are working better for you!

 

Good luck,

 

Ann 

 

AW: [firebird-support] differences between firebird 2.5 cs and 3.0 rc2 ss

['Checkmail' check_m...@satron.de [firebird-support]]

Thank you, Ann :)

 

Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
Gesendet: Donnerstag, 3. März 2016 17:53
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] differences between firebird 2.5 cs and 3.0 rc2 
ss

 

  

On Thu, Mar 3, 2016 at 11:16 AM, 'Checkmail' check_m...@satron.de 
  [firebird-support] 
 > 
wrote:

 

 

I’ve postet my problems with the new odbc driver and firebird 2.5 cs, the slow 
queries and all other issus. Now I have installed the firebird 3.0 rc2, the 
performance is great, superservers takes all cpu-cores and the problems now 
banned. I have not changed anything, is this a result of the superserver or the 
version 3 of firebird?

 

Both.  Firebird V3 introduces parallel execution of queries in SuperServer.  
SuperServer was always multi-threaded but only one thread could run at any one 
time even on a multi-processor server.  The benefit of threading in earlier 
versions was that queries could be interleaved, so a long report didn't block 
all other requests.  With V3, thread do run in parallel taking advantage of all 
the processing power of a multi-core machine.

 

Glad things are working better for you!

 

Good luck,

 

Ann 

 

AW: [firebird-support] sql and firebird

[checkmail]

Hello Mark,
it is very simple, I know. But sometimes... 
Thank you very much, best regards.
Olaf

On 4-11-2013 15:52, checkmail wrote:


 Hello,

 I would update a table (Primary key year and number), all records with 
 the same ordernumber for example - but not the record where is 
 currently in use and already updatet.

 Update table set field = value where ordernumber = XXX and (not record 
 with year 2013 and Number 1)

You just need to use the right syntax for the condition:

Update table set field = value
where ordernumber = XXX
and not (year = 2013 and Number = 1)

Mark
--
Mark Rotteveel




++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com 

++
Yahoo Groups Links

AW: [firebird-support] NOT in Firebird

[Olaf Kluge]

Hello Mark,

 

great, exactly what I was looking for. Only 1 and 0 is possible.

 

Thank you.

 

Olaf

On Thu, 4 Jul 2013 10:34:21 +0200, Olaf Kluge  
mailto:olaf.kluge%40satron.de olaf.kl...@satron.de
wrote:
 for example there are two variables. 
 
 Var1 = 0
 
 Now I would like to negate the Var1 to Var2. If var1 = 0, then should
Var2
 =
 1 and in the other direction.
 
 Ist it possible Var2 = invert(var1)??

Is this just about 0 and 1 or other values as well, if so what is the
exact transformation you need?

In this specific case, assuming var1 is always 1 or 0 you can use
BIN_XOR(var1, 1) to achieve the desired effect.

Mark





[Non-text portions of this message have been removed]

Re: AW: [firebird-support] NOT in Firebird

[Paul Vinkenoog]

Olaf wrote:

 great, exactly what I was looking for. Only 1 and 0 is possible.

Then you can also do

  Var2 = 1 - Var1

The outcome is the same, but perhaps this is more obvious than bitwise XORing 
with 1. And it might execute a wee little faster.


Cheers,
Paul Vinkenoog

Re: AW: [firebird-support] NOT in Firebird

[Mark Rotteveel]

On Thu, 04 Jul 2013 14:40:30 +0200, Paul Vinkenoog p...@vinkenoog.nl
wrote:
 Olaf wrote:
 
 great, exactly what I was looking for. Only 1 and 0 is possible.
 
 Then you can also do
 
   Var2 = 1 - Var1
 
 The outcome is the same, but perhaps this is more obvious than bitwise
 XORing with 1. And it might execute a wee little faster.

Totally forgot about that option ;)

Yet another way is to use DECODE
(http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-intfunc-decode.html
):

for example: DECODE(var1, 0, 1, 1, 0)

Mark

AW: AW: [firebird-support] restore a firebird 2.1 gbk in firebird 2.5

[Olaf Kluge]

Hi

 I am the first and only firbird user with this issue? What can I do?



 Thanks.


I think no. ;-)

In example:

http://sourceforge.net/mailarchive/message.php?msg_id=23092682


Gabor

Thank you!




++

Visit http://www.firebirdsql.org and click the Resources item on the main
(top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com 

++
Yahoo! Groups Links

Re: AW: [firebird-support] restore a firebird 2.1 gbk in firebird 2.5

[Gabor Boros]

2013.02.07. 15:36 keltezéssel, Olaf Kluge írta:
 I am the first and only firbird user with this issue? What can I do?



 Thanks.


I think no. ;-)

In example:

http://sourceforge.net/mailarchive/message.php?msg_id=23092682


Gabor




++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com 

++
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:
http://docs.yahoo.com/info/terms/

AW: [firebird-support] restore a firebird 2.1 gbk in firebird 2.5

[Olaf Kluge]

 

  

In Firebird 2.1 I can restore this backup successfully. What has changed in
2.5 that the timestamp cannot be restored?

Thanks.

Olaf Kluge  mailto:olaf.kluge%40satron.de olaf.kl...@satron.de schrieb:

Hello,

 

I have trouble. If I restore a fb 2.1 database-backup, I get the
following
error:

 

gbak: error: value exceeds the range for valid timestamps

gbak: error: gds_$send failed

fbak: Exiting before completion due to errors

 

The same Problem I had with a other database.

 

How can I fix them?

 

Thank you very much.

 

Best regards.

 

Olaf



[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]

AW: AW: [firebird-support] Timer in firebird?

[Olaf Kluge]

Hello

Em 13/9/2011 02:19, Olaf Kluge escreveu:
 Hi,



 I need to check the connectivity to our plc. A little tool is between
 database an plc. If the plc is down or the tool, I cannot see the
 connectivity.



 The visualization is also connected to our database, but not to the plc.
Now
 I would show the connectivity in the visualization to our database (it
 works) and to our sps. I have seen a tool named jobscheduler, but it works
 not so good. After the installation it does not start, not under windows
xp
 and also not under windows 7.



 Thanks.



 Olaf


You could use the Windows Task Scheduler to run an batch file that runs 
an script using ISQL that posts an event, your application listen to 
that event and respond back, so you will know wich clients are listenning.

see you !

--
many thanks.

Is there an example available? My internet connection is many poor at the
time (mobilephone)

Best regards

 

Olaf





[Non-text portions of this message have been removed]

AW: [firebird-support] Timer in firebird?

[Olaf Kluge]

Hi,

 

I need to check the connectivity to our plc. A little tool is between
database an plc. If the plc is down or the tool, I cannot see the
connectivity.

 

The visualization is also connected to our database, but not to the plc. Now
I would show the connectivity in the visualization to our database (it
works) and to our sps. I have seen a tool named jobscheduler, but it works
not so good. After the installation it does not start, not under windows xp
and also not under windows 7.

 

Thanks.

 

Olaf

 

 



[Non-text portions of this message have been removed]

Re: AW: [firebird-support] Timer in firebird?

[Alexandre Benson Smith]

Em 13/9/2011 02:19, Olaf Kluge escreveu:
 Hi,



 I need to check the connectivity to our plc. A little tool is between
 database an plc. If the plc is down or the tool, I cannot see the
 connectivity.



 The visualization is also connected to our database, but not to the plc. Now
 I would show the connectivity in the visualization to our database (it
 works) and to our sps. I have seen a tool named jobscheduler, but it works
 not so good. After the installation it does not start, not under windows xp
 and also not under windows 7.



 Thanks.



 Olaf


You could use the Windows Task Scheduler to run an batch file that runs 
an script using ISQL that posts an event, your application listen to 
that event and respond back, so you will know wich clients are listenning.

see you !