[firebird-support] fbtracemgr and fb_trace files in /tmp/firebird

[Vladimir Zbodulja vladimir.zbodu...@pis.eu.com [firebird-support]]

Hi guys,
I've noticed that, when I start 'fbtracemgr' session, server starts to
create files (fb_trace.{.) in /tmp/firebird (on Linux) and the
number of this files keeps growing and this files are not deleted after
trace session is terminated.

For example, I've started trace session with (same happens if I redirect
output to some file):
/opt/firebird/bin/fbtracemgr -u sysdba -p masterkey -SE service_mgr
-START -NAME fbt-trace -CONFIG $CFG >/dev/null

$CFG points to file with this content:

database

{

   enabled = true

   log_connections = false

   log_transactions = false

   log_statement_finish = true

   log_errors = true

   print_plan = true

   explain_plan = false

   print_perf = true

   time_threshold = 0

   max_sql_length = 8192

   max_log_size = 100

}

services

{

}


After each minute there are around 150 new files (I'm tracing SQL on an
active database that has around 40 running sessions) and this keeps growing
until I terminate fbtracemg (with Ctrl-C) (i.e. after 10-15 minutes session
there are cca. 2000 files):



-rw-rw 1 firebird firebird 1048576 Jun  7 11:38
fb_trace.{59EE03A6-A2A6-40D4-BAB2-E4EE1D238DE1}.0002901

-rw-rw 1 firebird firebird 1048576 Jun  7 11:38
fb_trace.{59EE03A6-A2A6-40D4-BAB2-E4EE1D238DE1}.0002902

-rw-rw 1 firebird firebird 1048576 Jun  7 11:38
fb_trace.{59EE03A6-A2A6-40D4-BAB2-E4EE1D238DE1}.0002903

-rw-rw 1 firebird firebird 1048576 Jun  7 11:38
fb_trace.{59EE03A6-A2A6-40D4-BAB2-E4EE1D238DE1}.0002904

-rw-rw 1 firebird firebird 1048576 Jun  7 11:38
fb_trace.{59EE03A6-A2A6-40D4-BAB2-E4EE1D238DE1}.0002905

-rw-rw 1 firebird firebird 1048576 Jun  7 11:38
fb_trace.{59EE03A6-A2A6-40D4-BAB2-E4EE1D238DE1}.0002908

-rw-rw 1 firebird firebird 1048576 Jun  7 11:38
fb_trace.{59EE03A6-A2A6-40D4-BAB2-E4EE1D238DE1}.0002909

-rw-rw 1 firebird firebird 1048576 Jun  7 11:38
fb_trace.{59EE03A6-A2A6-40D4-BAB2-E4EE1D238DE1}.0002910

-rw-rw 1 firebird firebird 1048576 Jun  7 11:38
fb_trace.{59EE03A6-A2A6-40D4-BAB2-E4EE1D238DE1}.0002911

-rw-rw 1 firebird firebird 1048576 Jun  7 11:38
fb_trace.{59EE03A6-A2A6-40D4-BAB2-E4EE1D238DE1}.0002912

-rw-rw 1 firebird firebird 1048576 Jun  7 11:38
fb_trace.{59EE03A6-A2A6-40D4-BAB2-E4EE1D238DE1}.0002913




Documentation (https://firebirdsql.org/rlsnotesh/rnfb25-trace.html) states
that:

The output of a user session is stored in set of temporary files, each of 1
MB. Once a file has been completely read by the application, it is
automatically deleted. By default, the maximum total size of the output is
limited to 10 MB. It can be changed to a smaller or larger value using the
*MaxUserTraceLogSize* in firebird.conf.

Once the user trace session service has been started by the application,
the application has to read its output, using calls to *isc_service_query()*.
The service could be generating output faster than the application can read
it. If the total size of the output reaches the *MaxUserTraceLogSize* limit,
the engine automatically suspends the trace session. Once the application
has finished reading a file (a 1 MB part of the output) that file is
deleted, capacity is returned and the engine resumes the trace session
automatically.


Doesn't that mean that files should be kept on the filesystem only until
fbtracemsg was able to read them and then automatically deleted (so that
total size of them is constant if fbtracemsg manages to read them quickly
enough)?

I'm running: LI-V3.0.5.33125 Firebird 3.0
(*MaxUserTraceLogSize* is commented out in firebird.conf)

BR ,
   Vladimir.

[firebird-support] Fbtracemgr not working

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

Trying to run fbtracemgr is returning a windows message “this app can’t run
on your pc”, and in the prompt it prints “Access is denied”

 

Windows 8.1, firebird 3.0.3

 

Have tried elevated prompt, setting the .exe as “run as administrator”, and
changed both firebird.conf and fbtrace.conf in many ways.

The error happens even in a clean / default config files.

 

The error happens regardless of what arguments I used, have tried a bunch,
for clarity sake this is the one I’m tring to start a session :

 

fbtracemgr -se localhost/3051:service_mgr   -user SYSDBA -password masterkey
-start -name "User Trace 1"   -config "fbtrace.conf " > c:\traceout.txt

(have tried changing the port and whatnot)

Atenciosamente,

Rudi Feijó


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

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

 



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

[firebird-support] fbtracemgr

[hugo.lar...@yahoo.com [firebird-support]]

Hello,

Could someone please provide the configuration needed to trace all SQL queries 
executed.

I'm using Firebird 2.5 with following config file.

Thanks,
Hugo


enabled true
log_transactions true
log_procedure_start true
log_procedure_finish true

 

 

 

[firebird-support] fbtracemgr

[Köditz, Martin martin.koed...@it-syn.de [firebird-support]]

Hi Hugo,

use this and you will have everything you need:

enabled true
log_transactions true
log_procedure_start true
log_procedure_finish true
log_statement_prepare true
log_statement_start true
log_statement_finish true


Regards,
Martin