>> But why If nobody is using it and it does not apear in mon$statements the
>> object is in use?
>
> Because metadata locks are cached even if not explicitly used (to avoid
> repeating acquire/release overhead).
>
>
> Dmitry
Thank you dimitry for the explanation.
Then locks for triggers ar
Thank you, i'll test it.
But why If nobody is using it and it does not apear in mon$statements the
object is in use?
Jesus Angel Garcia Zarco
Cointec
--
Open source business process management suite built on Java and E
Firebird 2.5.2 classic server
I'm experiencing one problem when trying to recompile stored procedures.
Once I use one stored procedure from my application (that is not called
from triggers and other procedures), the only way to recompile the
procedure is to close user session.
I understand that
Hello:
I'm using Firebird 2.5.2 and Delphi+IBX. I have a very strange situation
with TransactionID.
I'm debugging my application to record Transaction usage. I have detected
sometimes jumps between transaction numbers and I have started to
investigate them.
I have used trace output to record sta
Hello, as Dimitry suggested, I want to propose, based on my experience,
what is required by new customers I'm trying to work with and existing
customers. Most of them are registered in tracker.
Allways my customers require me features that oracle and sql server has,
and I have lost new clients bec
>
>
>
> Interesting. Could you show also miliseconds part of the timestamp ?
> It is very possible, that tx 948265
> was really created few ms before tx 938474 but obtains its number after it
> (due to threads preempting by OS
> scheduler and needs to obtain EX lock for header page to assign tx
Sorry one mistake, in the phrase
I use 2.5.2 superclassic in windows 2008 server 64 bits. I have migrated
one customer from Interbase 2009 to Firebird two years ago, is two days
ago, not two years.
2012/7/6 Jesus Garcia
> Hello, y write to the developer group because i'm observin
Hello, y write to the developer group because i'm observing a very strange
behaviour in transaction counter, and i don't know what needed for open it
in the tracker.
I use 2.5.2 superclassic in windows 2008 server 64 bits. I have migrated
one customer from Interbase 2009 to Firebird two years ago.
2012/3/18 Mark Rotteveel m...@lawinegevaar.nl
> The working set size is the amount of memory currently paged into
> physical memory, not the total (virtual) memory size of a process (see
>
> http://msdn.microsoft.com/en-us/library/windows/desktop/cc441804%28v=vs.85%29.aspx
> )
>
> If Firebird is n
> > If you need it i can backup only metadata.
> >
>
> Please do.
>
>
You have it in the tracker
--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developer
2012/3/13 Alex Peshkoff
> > Sorry, is Delphi, but i supply sources. Are very simple.
> >
>
> hmm - will try to reproduce...
>
The script source has been extracted with ibexpert, don't know if is
compatible with isql. If you need it i can backup only metadata.
To reproduce the problem, just write
2012/3/12 Alexander Peshkov
> > I have prepared a script for create database, a little aplication to
> > open connections and tables
>
> Would be great if it's isql or at least something OS independent
>
>
>
Sorry, is Delphi, but i supply sources. Are very simple.
> > and a word document expla
2012/3/12 Alexander Peshkov
>
> That's very interesting effect. Can you prepare a testcase to look at
> it?
Of course, do you want that i send it you in the ticket i opened about
memory usage in Fb2.1 and fb 2.5?
I have prepared a script for create database, a little aplication to open
connect
2012/3/11 Alex Peshkoff
> That's sooner of a kind of OS-specific effect. Such small working set as
> 1Mb is too small for firebird.
>
I think so, but what is the real amount of memory needed for metadata
itself, 8 Kb or 25000 Kb? When the working set decreases and after that
i execute one qu
Sorry for post something posted in firebird support, but i have not had any
response and may be developers can do.
I'm trying to understand the memory usage with classic server 2.5.2 32/64
bits with cache pages set to 75/300.
Our production database, once one form is opened, uses around 12 Kb
> 05.01.2012 12:35, Alex Peshkoff wrote:
>> When I checked it on interbase server some
>> time ago protocol 10 was supported.
>
> But connection with fbclient to Interbase XE fail.
>
Also fails with gds32.dll of interbase 2009,2007,etc. To use old client dll the
table users of admin.ib has
>
> Single server without downtime is a myth anyway.
The problem is not downtime is how much downtime. Backup and restore is so much
downtime.
Jesus
--
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a
>
> We have 7 or 8 bits (out of 16) currently available.
>
>
> Dmitry
Is not better use 64 bits integer?. In the near future computers speed, hdd
speeds, etc. will increase, and transaction id of 64 bits overhead will affect
less and less to performance.
Jesus
---
> Heavy loaded systems should use clusters. That's all. While one node is on
> maintenance,
> others do all work. These systems need clusters anyway for high availability
> and/or load
> balancing. One can't be serious running critical systems on a single server.
>
I don't agree with you. Y
> This change was done in trunk. The reason for signed type here was (at
> least visible reason) very simple - into some functions using same
> parameter might be passed transaction number (positive value) and
> something else (negative value). I.e. negative sign meant 'this is not
> transaction'
2011/12/8 Ann Harrison
>
> An abnormal shutdown for any cause - power failure, O/S crash,
> Firebird crash will not corrupt the database if you have forced writes
> turned on and if your disk system actually forces writes in the order
> they are presented. Connections are transient, in memory en
>
> Does engine shutdown or die on AV in your case?
I'm talking About fb 2.5. When i test with it, an AV raises and the engine
shutdown abnormally.
The question is If an error in the engine that causes fb terminate abnormally
can corrupt database or the engine closes all connections and rollba
>
> UDF installation is restricted to administrators, for the same reason.
> The UDF directory is restricted, too.
> An UDF is simply a library that runs as native code in the same address
> space as the FB process. Big problem if it misbehaves. Maybe the problem
> could be isolated better by runni
>
>
> The only way to have absolutely save UDFs is to run them in separate
> process. But I'm afraid that this will make them work much slower.
>
> Catching unhandled exceptions from foreign module is impossible in
> almost all cases. Code invoking UDFs does catch what it can catch. To
> make sure
>
> Right. But I'm not going to describe how many stars must have right
> positions to allow
> that.
Thank you again for the lesson, i did never link the positions of thr stars
with programming, but i'll take it into account the next time.
Jesus
>
> Because every programmer know that exceptions can hardly pass boundaries of
> DLL. Now it
> is time for you to learn it too.
>
Thank you very much for the lesson, but you say can hardly not can't.
Sorry for the post and for waste your valuable time with me.
Jesus
---
>
>
>> an exception not catched in my app, would not restart my computer.
>
> But it will make OS to close your application harshly. Exactly as it is
> done with Firebird.
>
> --
My example was not a good example, i knew it Just after pressing send button.
But what i don't understand is
> So UDFs should not raise exceptions. Period. The bug is in it, not in
> Firebird.
May be i don't explain well, i know the bug is in the UDF, but an exception not
catched in my app, would not restart my computer.
>
> If your UDF instead write some bytes in random memory places, it will be
> e
>
> The engine does what is possible and tries to catch the 'alien exception'.
>
> You must do your part and write a correct UDF, testing them before in
> non-production environment.
>
> Adriano
I know it, and is not me, is firebird. I try To test everything, but nothing is
perfect. One simple
>How??? How the engine catch an alien exception? Could you show the
> method working in
> MSVC and GCC?
>
> I don,t know how and if is possible, There must be a point in firebird
where a call to an udf in a dll is executed, and i don't know if is
possible to catch an exception that is raised in
Hello all, i wrote time ago this item in the firebird-support list, but
vlad suggest to write it in the devel list.
The question is that doing some test, i use one udf function in one dll
that raises an exception that the function did not catch.
When that exception raised, the firebird engine cru
Hello Alexander, have you received two emails with the udf and new examples
of tables mon$?
Regards
Jesus
--
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Trac
I use Only one delphi udf that returns the function power and does not use
malloc. I use it because i have used until now fb 1.0 and my code Reference
that function
Jesus Angel Garcia Zarco
Cointec
Correo Móvil
El 16/06/2011, a las 08:52, Alexander Peshkov escribió:
> Nice report, thank you.
cel format, but is strange that there are rows
in mon$memory_usage that has a lot of memory allocated, but the user SYSDBA,
has only executed the above statements.
Jesus Garcia
fbmemory.rar
Description: application/rar
-
>
>
I made a mistake, but every day increases the engine between 50 and 100 mb, not
Kb.
If i disconnect all users and start To work, the memory used is less than 400
Mb in 2 days, and after 2 weeks is 1,4 Gb.
Jesus
011 в 14:02 +0200, Jesus Garcia пишет:
>> I'm using Firebird 2.5.1.26292 Superserver. The server is running for
>> two weeks and the memory consumption increase daily, but not decrease.
>> I have tested in other enviroment, and all the memory is freed only
>> when all
cting from
rdb$memory_usage y see 159 records, most of them with mon$memory_allocated
with values in (69632,135168), and mon$memory_used between 4160 and 913712.
Is correct that firebird does not release memory when is not in use?
Jesus G
Ideally would be to upload it somewhere and send url to me (privately,
> if necessary)
>
> Regards,
> Vlad
>
>
I have sent you the links to hv...@users.sourceforge.net, to decompress the
password is hvlad
Reg
Could you provide minimal reproducible test case ?
>
> Regards,
> Vlad
>
>
>
Yes of course, haw can i send to you both databases. The compressed size of
each one is around 8 MB.
Regards, Jesus Garcia
--
>
>
>
> >If this does not grow after repeating that action in an unlimited manner
> >- I do not see problems.
>
The problem is that FB 2.5.1 requiere 60% more RAM than fb 2.1.4 for the
same database, same metadata and same process, and i think that 60% is so
much. If it is normal, is a problem for
Hello, i don't know if it is a bug or is the correct behavior, and before
open a report in tracker i would like to confirm it.
I have one database with 1031 Tables, 1441 SP and 3173 triggers. I'm trying
fb 2.1 and 2.5 classic server. Cache pages is 75 and page buffers are 0.
When i connect to the
41 matches
Mail list logo
