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

2017-08-23 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
> 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.

2017-08-21 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
> 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-21 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
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.

2017-08-17 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
> 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

2017-08-04 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
> 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

2017-08-04 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
> 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

2017-08-03 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
> > 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

2017-06-23 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
> 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

2016-12-01 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
>> 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

2016-10-31 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
> > 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

2015-09-07 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
> 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

2015-09-05 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
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)

2015-06-11 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
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

2015-06-09 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
Thank you ! Vlad Vlad, does this issue affect classic and superclassic?

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

2015-05-12 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
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

2015-05-05 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
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

2015-04-15 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
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 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
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

2014-06-20 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
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