Re: [firebird-support] Re: Firebird temp files

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

>>Either some GTT was used or temporary >>blob storage was requested. Why do 
>>you want it to be prevented?
RAM is fast disc is slow and i have plenty of free RAM. Also i have bigger 
cache then database pages count and this operations can be all done in memory.
>>In SS, it will be closed/deleted as soon as >>all connections are gone.
I use SS then it never happen to me..
Regards,Karol Bieniaszewski
null

Re: [firebird-support] Diagnosing CPU usage

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

10.05.2018 15:12, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] 
wrote:
> We have no way of debugging every single one of the applications being run,
> and there is no single obvious operation that could justify this high cpu
> usage.
> 
> Is there a way to monitor queries not only for the time they take, but for
> the CPU they use?

   Queries are not the only thing that consume CPU. Use Process Explorer to get 
call stack 
for CPU consuming thread several times in row. It may provide you an idea what 
this thread 
is doing. Don't forget to load PDB files to see function names in the stack.


-- 
   WBR, SD.

Re: [firebird-support] Trying to use FB3 example to encrypt database

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

10.05.2018 13:19, OAZEZ Software - José Eduardo joseedua...@oazez.com.br 
[firebird-support] wrote:
> 5) alter database encrypt with "cryptdb.dll";

   Name of the plugin is "cryptDb", not "cryptdb.dll".


-- 
   WBR, SD.

[firebird-support] Diagnosing CPU usage

[Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]]

Hello

I have a situation which is hard to debug. We are running about 50 databases
(firebird 3.0.3) on a single server, all of them connected to different
applications.


CPU usage is normaly low, but sporadically it will peak at 100% and cause
problems for all the connections.

 

We have no way of debugging every single one of the applications being run,
and there is no single obvious operation that could justify this high cpu
usage.

 

Is there a way to monitor queries not only for the time they take, but for
the CPU they use?

 

A few years ago I tried FBScanner, but as far as I remember it didn’t gauge
cpu usage.

 

 

Atenciosamente,

Rudi Feijó


Multidados Informática Ltda.
*  (11) 2579-8789

*   rudi.fe...@multidadosti.com.br

*   www.multidadosti.com.br 
*   www.whatsappmailing.com.br

 

 



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

[firebird-support] Re: Firebird temp files

[Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]]

09.05.2018 20:02, liviuslivius wrote:

> Ok, i understand temp file caching but why Firebird create this temp 
> file at all and how to prevent this?

Either some GTT was used or temporary blob storage was requested. Why do 
you want it to be prevented?

> And second question, why file handle is still active?

In SS, it will be closed/deleted as soon as all connections are gone.


Dmitry

[firebird-support] Trying to use FB3 example to encrypt database

[OAZEZ Software - José Eduardo joseedua...@oazez.com.br [firebird-support]]

I'm trying to build it with Delphi Tokyo, and when I try to encrypt the
database I'm getting the message:

- Error loading plugin cryptdb.dll

- Module {FIREBIRDDIR}\plugins\cryptdb.dll does not contain plugin
cryptdb.dll type 9

My steps:

1) Installed Firebird 3.0.3 (NNF)
2) Rename {FIREBIRDDIR}\examples\dbcrypt\crypdb.pas to cryptdb.dpr, and
build
3) Copied cryptdb.dll to {FIREBIRDDIR}\plugins
4) isql employee2.fdb -user sysdba -pass masterkey
5) alter database encrypt with "cryptdb.dll";
6) no joy, the obnoxious error message appears.

Any ideas what I'm doing wrong?

GOD Bless
José Eduardo 

Re: [firebird-support] Subscribe and question

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 10-5-2018 12:12, 'Primoz  Jenko' primoz.je...@domplan.si 
[firebird-support] wrote:
> 
> 
> Hi, Mark,
> 
> thank you very much for detailed questions!
> 
> Answers are:
> 
> -WIN 10 is only on client
> 
> -We have tried both: embeded and locall – nothing was working
> 
> -FB runs as service
> 
> -We wil try to run it as application
> 
> -FB process is working, we have verify it – we see it running
> 
> -With command netstat we do not see 3050 port in a list,
> 
> When we restore WIN to a 1709, port is visible again

That makes no sense, if this is just a client (as you mentioned in 
another post), then Firebird shouldn't even be installed and running on 
the client. The only machine where Firebird should be listening on port 
3050, is the server hosting the Firebird server.

> We add port 3050 into firewall but it is not visible in a list (problem 
> might be with port 3050 and firewall configuration?)
> 
>      WIN does not listen to port 3050 data through, even it 
> is configured in firewall
> 
> Does any one have any idea what to do?

What is the connection string that you are using? I know Windows 10 1803 
made some changes in its networking, so maybe that prevents WNET 
connections from working? This a guess, I'm not sure though, I always 
use TCP/IP connections.

Mark
-- 
Mark Rotteveel

RE: [firebird-support] Subscribe and question

['Primoz Jenko' primoz.je...@domplan.si [firebird-support]]

Hello, Karol,

thank you very much for your respond!


Firebird is installed on different machine with WIN Server OS, only on local 
machine (client) there is WIN 10, with no FB istalled. On local machine there  
is only our software that uses FB from server.
We can not acces it even with IBConsole, …

Other local machines with like WIN 7 are operating normally, connecting normaly 
to this server.

Best wishes,
Primoz




From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Thursday, May 10, 2018 12:34 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Subscribe and question


Ar you sure that your answers are true?
You say that win10 is only a clien and then that when you restore to update 
1709 you see that fb is listen. I suppose you have Firebird installed on this 
Win10 machine and it serve client and server in the same time. Is this true or 
your config os different?



Regards,
Karol Bieniaszewski


--
This message has been scanned for viruses and dangerous content by
E.F.A. Project, and is believed to be clean.
Click here to report this message as 
spam.


To elektronsko sporočilo in vse morebitne priloge predstavljajo poslovno 
skrivnost oziroma so zaupne in so namenjene izključno naslovniku. Kakršnokoli 
razkrivanje, distribucija ali kopiranje vsebine sporočila je izrecno 
prepovedano. Če ste sporočilo prejeli pomotoma, Vas prosimo, da o tem obvestite 
pošiljatelja, sporočilo pa takoj uničite.

RE: [firebird-support] Subscribe and question

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

Ar you sure that your answers are true?You say that win10 is only a clien and 
then that when you restore to update 1709 you see that fb is listen. I suppose 
you have Firebird installed on this Win10 machine and it serve client and 
server in the same time. Is this true or your config os different?


Regards,Karol Bieniaszewski
null

Re: [firebird-support] Re: Firebird temp files

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

Yes, you have right 
but i really try to avoid RAM disc which consume memory always i prefer if some 
resource free memory it is available to be consumed by any process. 
Do you know why this file is created at all and especially why its handle is 
still active in firebird process few days?
Regards,Karol Bieniaszewski
null

RE: [firebird-support] Subscribe and question

['Primoz Jenko' primoz.je...@domplan.si [firebird-support]]

Hi,


thank you! We will do it.



Best wishes,

Primoz


-Original Message-
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Thursday, May 10, 2018 12:17 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Subscribe and question

10.05.2018 12:12, 'Primoz  Jenko' primoz.je...@domplan.si [firebird-support] 
wrote:
> Does any one have any idea what to do?

   Look to firebird.log to see errors of port listening if any.


--
   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 elektronsko sporočilo in vse morebitne priloge predstavljajo poslovno 
skrivnost oziroma so zaupne in so namenjene izključno naslovniku. Kakršnokoli 
razkrivanje, distribucija ali kopiranje vsebine sporočila je izrecno 
prepovedano. Če ste sporočilo prejeli pomotoma, Vas prosimo, da o tem obvestite 
pošiljatelja, sporočilo pa takoj uničite.

RE: [firebird-support] Subscribe and question

['Primoz Jenko' primoz.je...@domplan.si [firebird-support]]

Hi, Mark,

thank you very much for detailed questions!

Answers are:


-  WIN 10 is only on client

-  We have tried both: embeded and locall – nothing was working

-  FB runs as service

-  We wil try to run it as application

-  FB process is working, we have verify it – we see it running

-  With command netstat we do not see 3050 port in a list,

When we restore WIN to a 1709, port is visible again

We add port 3050 into firewall but it is not visible in a list (problem might 
be with port 3050 and firewall configuration?)
WIN does not listen to port 3050 data through, even it is 
configured in firewall





Does any one have any idea what to do?



Thank you so much!





Best wishes,

Primoz






From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Thursday, May 10, 2018 9:34 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Subscribe and question



On 9-5-2018 16:48, 'Primoz Jenko' 
primoz.je...@domplan.si
[firebird-support] wrote:
> I would have a question why, after automatic upate of WIN 10, update
> package 1803,FB  2.0.5.13206 (our software using those two) generates an
> error 335544721, Failed to established a connection?
>
> We have tried a lot of posibilities, but no effect.
>
> We have upgrade to FB 3.0.3 and problem remains.
>
> We have been seeking solutions on WIN 10 part too (off IVP6, unblocked
> 3050 port, unblocked FB), but no effect.
>
> Any thoughts?

What is the full error

Exactly what is your setup: Is Windows 10 used to host the Firebird
server, or is Windows 10 used on the client machines (or both)? Are you
using Firebird Embedded, connecting locally, or over the network. Is
Firebird running as a service, if so under what user? What happens if
you run it as an application (firebird -a from the command prompt with
Firebird 3).

Have you verified the Firebird process is actually running, and is
listening on port 3050 (eg check in command prompt with netstat -ano).
Have you verified the Windows 10 firewall settings?

Did you also update the Firebird client install on the client machines?

Mark
--
Mark Rotteveel



To elektronsko sporočilo in vse morebitne priloge predstavljajo poslovno 
skrivnost oziroma so zaupne in so namenjene izključno naslovniku. Kakršnokoli 
razkrivanje, distribucija ali kopiranje vsebine sporočila je izrecno 
prepovedano. Če ste sporočilo prejeli pomotoma, Vas prosimo, da o tem obvestite 
pošiljatelja, sporočilo pa takoj uničite.

Re: [firebird-support] Re: Firebird temp files

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

10.05.2018 8:47, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] 
wrote:
> Thank you for the suggestion. We will consider RAM disc uses but first we 
> must be sure how 
> big it should be to catch all cases.

   It, actually, doesn't matter. If you configure several temporary locations, 
starting 
from your RAM drive, Firebird will switch to next one when the first is full.


-- 
   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] Hallo world

['Stellarancia.com' ni...@stellarancia.com [firebird-support]]

He,

now I enter in the Firebird group.

Good morning to all.

Antonio BIANCA


---
Questa e-mail è stata controllata per individuare virus con Avast antivirus.
https://www.avast.com/antivirus

RE: [firebird-support] Subscribe and question

[bog...@mordicom.si [firebird-support]]

Precisely that, thanks

 

Regards Bogdan.

 

 

From: firebird-support@yahoogroups.com  
Sent: Thursday, May 10, 2018 9:52 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Subscribe and question

 

  

On 10-5-2018 09:27, bog...@mordicom.si   
[firebird-support] wrote:
> 
> 
> We've had Firebird 2.0 database in dialect 1.
> 
> When we installed 2.5 64 server, connection was not possible.
> 
> If my memory serves me well 

Ah, well as far as I know the dialect shouldn't make a difference there.. 
I would sooner suspect that your old 2.0 database was 32 bit, and when 
you moved to a 64 bit Firebird you might have needed to back up and 
restore the database. Older Firebird database formats have minor 
differences between 32 bit and 64 bit processes (this was fixed - iirc - 
with Firebird 2.1).

Mark
-- 
Mark Rotteveel

Re: [firebird-support] Subscribe and question

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 10-5-2018 09:27, bog...@mordicom.si [firebird-support] wrote:
> 
> 
> We've had Firebird 2.0 database in dialect 1.
> 
> When we installed 2.5 64 server, connection was not possible.
> 
> If my memory serves me well 

Ah, well as far as I know the dialect shouldn't make a difference there. 
I would sooner suspect that your old 2.0 database was 32 bit, and when 
you moved to a 64 bit Firebird you might have needed to back up and 
restore the database. Older Firebird database formats have minor 
differences between 32 bit and 64 bit processes (this was fixed - iirc - 
with Firebird 2.1).

Mark
-- 
Mark Rotteveel

Re: [firebird-support] Subscribe and question

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 9-5-2018 16:48, 'Primoz  Jenko' primoz.je...@domplan.si 
[firebird-support] wrote:
> I would have a question why, after automatic upate of WIN 10, update 
> package 1803,FB  2.0.5.13206 (our software using those two) generates an 
> error 335544721, Failed to established a connection?
> 
> We have tried a lot of posibilities, but no effect.
> 
> We have upgrade to FB 3.0.3 and problem remains.
> 
> We have been seeking solutions on WIN 10 part too (off IVP6, unblocked 
> 3050 port, unblocked FB), but no effect.
> 
> Any thoughts?

What is the full error

Exactly what is your setup: Is Windows 10 used to host the Firebird 
server, or is Windows 10 used on the client machines (or both)? Are you 
using Firebird Embedded, connecting locally, or over the network. Is 
Firebird running as a service, if so under what user? What happens if 
you run it as an application (firebird -a from the command prompt with 
Firebird 3).

Have you verified the Firebird process is actually running, and is 
listening on port 3050 (eg check in command prompt with netstat -ano). 
Have you verified the Windows 10 firewall settings?

Did you also update the Firebird client install on the client machines?

Mark
-- 
Mark Rotteveel

RE: [firebird-support] Subscribe and question

[bog...@mordicom.si [firebird-support]]

We've had Firebird 2.0 database in dialect 1.

When we installed 2.5 64 server, connection was not possible.

 

If my memory serves me well 

 

Bogdan

 

From: firebird-support@yahoogroups.com  
Sent: Thursday, May 10, 2018 9:09 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Subscribe and question

 

  

On 10-5-2018 08:01, bog...@mordicom.si   
[firebird-support] wrote:
> What is the dialect of the database ?

I don't see how the dialect would be relevant for this problem. Could 
you explain what problem you where thinking of?

Mark
-- 
Mark Rotteveel

Re: [firebird-support] Subscribe and question

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 10-5-2018 08:01, bog...@mordicom.si [firebird-support] wrote:
> What is the dialect of the database ?

I don't see how the dialect would be relevant for this problem. Could 
you explain what problem you where thinking of?

Mark
-- 
Mark Rotteveel

[firebird-support] Monitoring tables indexes

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

Hi,
can i ask why monitoring tables have not any indexes? Any left join go into 
natural scan as we have not hash/merge for outer join (core-4823).
Regards,Karol Bieniaszewski

RE: [firebird-support] Re: Firebird temp files

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

Hi,
Thank you for the suggestion. We will consider RAM disc uses but first we must 
be sure how big it should be to catch all cases.
It should be docummented how temp tables work (maybe it is somwhere?) with temp 
files.
Regards,Karol Bieniaszewski
null

RE: [firebird-support] Subscribe and question

[bog...@mordicom.si [firebird-support]]

What is the dialect of the database ?

 

Regards

Bogdan

 

From: firebird-support@yahoogroups.com  
Sent: Wednesday, May 9, 2018 4:48 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Subscribe and question

 

  

Hello,

 

I would have a question why, after automatic upate of WIN 10, update package 
1803,FB  2.0.5.13206 (our software using those two) generates an error 
335544721, Failed to established a connection?

We have tried a lot of posibilities, but no effect. 

We have upgrade to FB 3.0.3 and problem remains. 

We have been seeking solutions on WIN 10 part too (off IVP6, unblocked 3050 
port, unblocked FB), but no effect.

 

Any thoughts? 

 

Thank you very much  in advance!

 

Best regards,

Primoz J.

 

 

 

  _  

To elektronsko sporočilo in vse morebitne priloge predstavljajo poslovno 
skrivnost oziroma so zaupne in so namenjene izključno naslovniku. Kakršnokoli 
razkrivanje, distribucija ali kopiranje vsebine sporočila je izrecno 
prepovedano. Če ste sporočilo prejeli pomotoma, Vas prosimo, da o tem obvestite 
pošiljatelja, sporočilo pa takoj uničite.

-- 
This message has been scanned for viruses and dangerous content by 
  E.F.A. Project, and is believed to be clean.