Re: [firebird-support] Firebird 3 crashes ( terminated abnormally (4294967295) )

> El 23 ago 2017, a las 19:56, Rudi Feijó rudi.fe...@multidadosti.com.br > [firebird-support] escribió: Isn't better install a debug version and capture the crash dump? >

Re: [firebird-support] Re: Automatic Firing of Query.

> El 21 ago 2017, a las 15:47, anshuman.na...@airtelmail.in [firebird-support] > escribió: > > Thanks for this. Just a quick clarification. Which version are/were u > using. > > > We are using 2.5.2.26539 (x64) and the file IBDatabase.pas doesn't

Re: [firebird-support] Re: Automatic Firing of Query.

2017-08-17 16:19 GMT+02:00 anshuman.na...@airtelmail.in [firebird-support] < firebird-support@yahoogroups.com>: > > > Yes Jesús, we are using ibx. > > Can u please share the details with me. Of share the modified file if > possible. > I have modified IBDatabase.pas. There is some checks that

Re: [firebird-support] Re: Automatic Firing of Query.

> El 17 ago 2017, a las 15:33, Mark Rotteveel m...@lawinegevaar.nl > [firebird-support] escribió: Are you using ibx? I modified the source code of ibx in order to avoid this queries, that are only used to know if a field is computed or not, and of course I

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

> El 4 ago 2017, a las 19:05, Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support] <firebird-support@yahoogroups.com> escribió: > > 04.08.2017 18:52, Jesus Garcia jeg...@gmail.com [firebird-support] wrote: >> As I understood he was saying to not use nbackup, an

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

> El 4 ago 2017, a las 16:54, 'Leyne, Sean' s...@broadviewsoftware.com > [firebird-support] escribió: > > > I only see three items pending, but anyway, why not remove Nbackup from > > firebird until it is safe to use? > > As others have pointed out, the

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

> > Always use the latest release. For 2.5 it is 2.5.7. But even with this it is > not > guaranteed to work. Check list of nbackup-related bugs in tracker: > http://tracker.firebirdsql.org/secure/IssueNavigator.jspa?sorter/field=updated/order= > I only see three items pending, but anyway,

Re: [firebird-support] witch vresion of Firebird to choose for Delphi 7 and IBX 7.09

> El 23 jun 2017, a las 19:43, safirh...@yahoo.fr [firebird-support] > escribió: > > Hi , > Please i have developped an application with delphi 7 and interbase 7.5 > server. > I have used IBX components. > Just i want to use Firebird instead of interbase 7.5

Re: [firebird-support] Migration from Interbase 7.5 to Firebird 2.5.4

>> It is my First question in this group. >> >> I would like to know if someone has accomplished a migration from >> >> Interbase 7.5 to Firebird 2.5.4 I did it years ago. 1. Extract metadata from Interbase 2. Create the database in firebird with the metadata extracted. You may have to

Re: [firebird-support] Re: Best way to delete millions of rows

> > Here you delete some records, but then count whole table. > Add same "where" condition as in "count" query > > Regards, > Vlad I think the execution of select count is for garbage collection. If count of records that does not exists is executed, will be the garbage collection executed for

Re: [firebird-support] MAX() and index

> El 7/9/2015, a las 15:00, Tim Ward t...@telensa.com [firebird-support] > escribió: > > Please can someone explain to me, again, why > > select Max(MYCOL) from MYTAB > > doesn't use the primary key > > PLAN (MYTAB NATURAL) > I think you need to have a

Re: [firebird-support] About firebird performance

Hello Hector, what version of firebird are you running, super server, super classic or classic server? Jesus Angel Garcia Zarco Cointec > El 5/9/2015, a las 18:00, Hector Sánchez hec...@planatec.es > [firebird-support] escribió: > > I discovered something

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

Hello jack, may be you have a problem with the metadata of your database, that were compatible with interbase 6 but not with firebird. Firebird is more strict than Interbase was. I had problem in the past backing up interbase 5.6 and restoring in firebird. The problem was solved, extracting

Re: AW: AW: AW: AW: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4

Thank you ! Vlad Vlad, does this issue affect classic and superclassic?

Re: [firebird-support] losing connection with server on a local PC

El 12/5/2015, a las 20:56, shg_siste...@yahoo.com.ar [firebird-support] firebird-support@yahoogroups.com escribió: Hello! I have a Delphi app with Firebird. Everything in a single PC which is accesed via Remote Desktop by 5 or 6 users. It worked fine for much years. But since

Re: [firebird-support] large system slows over time

El 5/5/2015, a las 12:15, Nick Upson n...@telensa.com [firebird-support] firebird-support@yahoogroups.com escribió: Hi I have a system that is slowing down the longer it stays running and I'd like to know why. The system is running firebird 2.1.5 on centos 5 with an average of 27

Re: [firebird-support] Internal Transaction in Fb 2.5.4 Trace Log

If you execute transaction.commitretaining the transaction counter increases but no new transaction is created, then you don't see that number in the log. Jesus Angel Garcia Zarco Cointec El 15/4/2015, a las 9:50, hannu.laurikai...@yahoo.com [firebird-support]

Re: [firebird-support] Re: Trace cause of performance drop

2014-12-16 9:39 GMT+01:00 Mark Rotteveel m...@lawinegevaar.nl [firebird-support] firebird-support@yahoogroups.com: My first suggestion would be to upgrade to 2.5.3 Update 1 and backup and restore your database. Why is needed to backup + restore the database when upgrade to 2.5.3. As I know is

Re: [firebird-support] CORE-4467

El 20/06/2014, a las 21:33, Ivan Arabadzhiev intelru...@yahoo.com [firebird-support] firebird-support@yahoogroups.com escribió: So I was redirected to the list to discuss http://tracker.firebirdsql.org/browse/CORE-4467. What I can add is that it occurred to me to run a validation on

Re: [firebird-support] Is it normal for SWEEPER to take hours to finish?

Hi. Today, the users of one of my Firebird 2.5 databases reported that the database works very slow. After I checked I saw that there is an attachment from SWEEPER user and it is doing something. The database size is little over 500 MB. But the sweeper is working over 2 hours now, with no

Re: [firebird-support] flamerobin access from client

I have set up a server connection on the client (server name - server, host - \\server, port- 3050) and registered the database (name - DB, path - \\server\, user - sysdba, password - masterkey). Try with the connection string: Server:c:\data\db.fdb _

Re: [firebird-support] Online DDL

. Jesus Garcia

Re: [firebird-support] Online DDL

there are comments, some recent, that changing metadata while users connected can cause database corruption. Of course, If object in use raises, is not a problem, only if the database stay in the prior state after the error, but is a problem if trying to drop a table can cause database corruption. Jesus Garcia

Re: [firebird-support] Wrong page type, how to examine/fix?

Hello, Kjell, do you know the source of the issue? Is a reproducible error in engine what have caused the corruption? Jesus García

Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

Then, If it were only a firebird issue, all of us would have the problem. If some of us has the problem, may be an incompatibility between FB, OS and hardware. Perhaps, if we share information about our environments, the common origin of the problem would arise. Jesus Angel Garcia Zarco

Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

'So the only effective solution seems to disable the random access request (i.e. remove the FILE_FLAG_RANDOM_ACCESS flag) from the Windows API calls used to create/open the files. Moreover, in this case the file-system cache size limit should not be actual anymore, as Windows won't be

Re: [firebird-support] Table update performance dropped significantly within few days.

2014/1/15 fabianoas...@gmail.com Increase database page buffers and try again. It happens when you combine a large table with multiple indexes. Dropping one or two indices can also increase speed a lot in this case. I think, 100 million records are not so much records, and If you use

Re: [firebird-support] Re: Help, tunning database

El 22/07/2013, a las 14:10, trskopo trsk...@yahoo.com escribió: Dear all, Today, I faced same problem again, which is Firebird server became not responsive. Here are the latest settings : - win 7 64 bit - Firebirds 2.5.1 super server - page size 8192 - page buffer 8192 - no long

Re: [firebird-support] Re: Help, tunning database

El 15/07/2013, a las 18:23, trskopo trsk...@yahoo.com escribió: --- In firebird-support@yahoogroups.com, Jesús García jegaza@... wrote: El 15/07/2013, a las 16:31, trskopo trskopo@... escribió: Hi all, I have Superserver Firebird 2.5.1 installed on Win7 pro 64 bit on I7

Re: [firebird-support] GBak Backup Restore Problem

Hello, I think you have a row with null value. The option is update table set column = 0 where column is null and then try to backup restore. I have seen this issue when changing columns from null to not null and you have rows in the table. 2013/6/25 Tupy... nambá anhangu...@yahoo.com **

Re: [firebird-support] There are risks accessing a database with two servers?

it seems possible and desirable to have 2 Servers, one for long running reports (probably using Classic) and another for the other tasks (using SuperServer) Is that right? Classic server can't open a database opened by superserver, because SS opens it exclusive mode. May be the article

Re: [firebird-support] Delphi XE2. Migrating from IBX components

Hello I have all my apps in Delphi with the IBX components and ClientDataSets to conect with a FB Database. Since long time ago IBX creator says it doesn't support FB. So far I can work with very simple queries fine. But now I'd like to use a component which supports FB. I'd like to

Re: [firebird-support] Re: Scaling up Firebird-2.5.2.26539_0_x64.exe

Firebird can handle more than 10 concurent users here is an example with a production system http://www.firebirdnews.org/?p=6797 __,_._,_ There are not 10 concurrent users, are 10 end users using 2500 pooled connections, then there are 2500 concurrent users máximum., that are

Re: [firebird-support] Re: RES: Version number

This is also possible, but only if you migrate not to the official v2.5.2 release but to some earlier snapshot build. Dmitry One question Dimitry. We have some quite large databases and cannot do a backup restore cycle. Also rebuild indices may take so much time. What kind of indices has to

Re: [firebird-support] Re: firebird.conf improve for lot of memory

How many simultaneous users? What database size? How complex is metadata?

Re: [firebird-support] page 2226658, page type 5 lock denied (216)

El 27/09/2012, a las 17:08, Ann Harrison aharri...@ibphoenix.com escribió: Page type 5 is a data page. What you ran into was an internal deadlock that was recognized and your process lost. The problem was entirely in memory, so no, I wouldn't worry about datbase corruption. In theory,

Re: [firebird-support] Re: The worst day i can have with firebird

60 transactions / day, uniformly distributed means ~ 7 transactions per second, which is nothing. I'm sure you don't have that pattern in production, thus e.g. the most busy hour in respect to transaction throughput might be interesting. I know 7 transactions seconds and peaks of 20/30

Re: [firebird-support] Newbie: Viewing system users

2012/7/10 Danie van Eeden vaneeden.da...@gmail.com ** I will connect to security2.fdb to locate the users table and will post If I have trouble I think you can't connect no more to security2.fdb with firebird 2.5. You will have to get users trough API. Regards, Jesus [Non-text portions

Re: [firebird-support] Re: The worst day i can have with firebird

The Trace API is an underestimated new feature in 2.5, but a godsend to analyze such situations. I must say I have used the lite version of your fbtracemanager tool. Sounds a bit like running the query in a transaction with auto commit turned on. You might see COMMIT_RETAIN in the trace

[firebird-support] page type @ lock denied

Hello, i'm using Firebird 2.5.2 Superclassic in windows 2008 R2 64 bits. The system runs for two days, and i have seen in firebird log this entries in the first work day: Thu Jul 05 11:52:59 2012 Database: Gestlab page 1296554, page type 4 lock denied (216) Thu Jul 05 13:36:41 2012 Database:

[firebird-support] The worst day i can have with firebird

Two days ago, we moved from one server with interbase 2009 windows 2003 and 4 Gb RAM to Firebird 2.5.2 Superclassic, 16 Gb RAM The database is around 21 Gb, and yesterday seems all was running fine. Today, i have checked Firebird.log and i have seen that there is an error of type 1296554 page

Re: [firebird-support] Server

What is the memory consumption? I have had the same error When firebird reach near 2 gb RAM. Jesus Angel Garcia Zarco Cointec Correo Móvil El 07/06/2012, a las 11:38, Michael Vilhelmsen michael.vilhelm...@microcom.dk escribió: I have a server running windows 2003 32 bits. On this server

Re: [firebird-support] Firebird 2.5 (64 bit), strange SQL result

I also have seen that in ERRLOG table you have the entry DT USR MSG ERR_AT 29/04/2012 x!JKmn validation error for column ID_DIV_LC, value *** null *** 29/04/2012 17:00:02 Regards, Jesus [Non-text portions of this message have been removed]

Re: [firebird-support] OIT / NT

Hello, Tiberiu! Friday, March 30, 2012, 12:13:06 PM, you wrote: TH which) somehow foods my server. While this client is using my TH software, somehow the gap between OIT and NT increases 200 transactions each 5 seconds. I Other people noted lot of things, but I want to ask - what

Re: Re[2]: [firebird-support] OIT / NT

Sorry guys, I don't believe in magic or some spy applications, that suddenly generates lot of transactions. One of the cases like that, when some application started to generate millions transaction per day, was the programmer's fault, when he forgot to construct web page content from the

[firebird-support] Understanding memory usage in classic server

Hello, i'm trying to understand the memory usage with classic server 2.5.2, cache pages 300. Our production database, once one form is opened, uses 12 Kb memory, and the memory is allocated the first time a form that open a set of tables that is related with many other tables in the database

Re: [firebird-support] Firebird classic vs supperclassic

The thing with SC is, when something bad happens in a connection, which crashes the server, e.g. due to a bug in the engine or a faulty UDF, all connections are affected. This is probably the reason why people still prefer Classic over SC. SC might be easier to manage, because you only see

Re: [firebird-support] Checking if scripts ran correctly

Just found a remote database that did not have a field in a table which had been added some 4 or so scripts ago. That makes me suspect of all script updates. What is the fastest and most reliable way to check all my deployed databases (say 200 of them) to see if all the scripts have run

Re: [firebird-support] Re: FB 2.5 takes too much RAM

Hi Sean, I have just installed FB 2.5.1, but the problem still exists. Haven't the bug been fixed in FB 2.5.1? Regards Guido I opened the ticket, but i have not tested if it really solves the problem. When i opened the ticket, fb2.5 uses 47% more RAM than 2.1.4, now (2.5.1,2.5.2) uses

Re: [firebird-support] division by zero in FB2.5

What is the value of mmbtu? Jesus Angel Garcia Zarco Cointec Correo Móvil El 24/10/2011, a las 17:18, Alan J Davies alan.dav...@aldis-systems.co.uk escribió: Hi, has there been a change in the way division is done since FB 2.1 I realise I may be asking this question in the wrong list, but

[firebird-support] Shutdown engine with an exception inside a udf dll

Hello, is normal to crash the engine whe an exception is raised inside a udf dll or must be catch by the engine? I had a udf with the function power. If i call power with a negative valué in the base parameter an exception is raised and the engine is stopped. Why not catch the exception To

Re: [firebird-support] Re: Is Firebird 2.5 support running on multi core processors?

In Firebird 2.5 release note, I read this note : The default CpuAffinity setting still binds SuperServer to a single processor only. In order to take advantage of this improvement when working with multiple databases, this setting should be changed in firebird.conf It means,