backuping, but did not work.
Any suggestion?
Thank you.
Atenciosamente,
+ + Hugo Eyng + +
Thank you Mr. Makowski
Atenciosamente,
+ + Hugo Eyng + +
De: firebird-support@yahoogroups.com em nome
de Philippe Makowski pmakow...@ibphoenix.fr [firebird-support]
Enviado: quarta-feira, 13 de maio de 2020 06:40
Para: firebird-support@yahoogroups.com
nable firebird-superserver.service"
How to start "classic" or "superclassic"? Is it possible? And would you use one
of those instead "superserver"?
Atenciosamente,
+ + Hugo Eyng + +
De: firebird-support@yahoogroups.c
Dear Friends,
Where can I find a good tutorial to learn how to install FB 2.5.9 ( or higher)
in CentOS 7?
If anyone already installed and used FB in this SO: what the best option:
1-superserver, 2-classic, 3-superclassic?
Thank you.
Atenciosamente,
+ + Hugo Eyng + +
Hello.
Try using a "WHERE" clause if possible.
Ex: WHERE "some_date_column_of_the_table" > (current_date - n)
Atenciosamente,
+ + Hugo Eyng + +
De: firebird-support@yahoogroups.com em nome
de Matthias Winkler spmm...@gmail.com [fire
Thank you Dimitry.
It was very usefull.
Atenciosamente,
+ + Hugo Eyng + +
De: firebird-support@yahoogroups.com em nome
de Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
Enviado: sexta-feira, 10 de janeiro de 2020 14:13
Para: firebird-support
Thank you Mark.
Restarting FB server worked. Some users in others foruns reported the same bug
and the same "solution", but do you know if this bug is restricted to what FB
version and if there is something we can do to avoid this happen again?
Atenciosamente,
+ +
Hello.
Win10 64 and Win7 32
FB 2.5 32bits
When I execute "select current_time from RDB$Database" FB returns 1 (one) hour
more then the current time.
Did somebody faced this troble?
Atenciosamente,
+ + Hugo Eyng + +
De: firebird-support@yahoogrou
w, because
"select count(id) from mytable" results in the same " ERROR:internal Firebird
consistency check (decompression overran buffer (179), file: sqz.cpp line: 239)"
Atenciosamente,
+ + Hugo Eyng + +
De: firebird-support@yahoogroups.com
Hello Alexey.
IBPump was a good idea.
IBPump doesn´t recover the corrupted table but at least it is possible to
restore all others.
Atenciosamente,
+ + Hugo Eyng + +
De: firebird-support@yahoogroups.com em nome
de Alexey Kovyazin a...@ib-aid.com [firebird
Hello Mark.
Gfix didn´t work even using it as you explained.
Atenciosamente,
+ + Hugo Eyng + +
De: firebird-support@yahoogroups.com em nome
de Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
Enviado: sábado, 28 de dezembro de 2019 07:02
Para
rrors
gbak: ERROR:internal Firebird consistency check (can't continue after bugcheck)
Any help will be apreciated.
Atenciosamente,
+ + Hugo Eyng + +
than one way, but I
would like to know what should I consider to decide.
Atenciosamente,
+ + Hugo Eyng + +
,
+ + Hugo Eyng + +
Thank You Mark.
Atenciosamente,
+ + Hugo Eyng + +
De: firebird-support@yahoogroups.com em nome
de Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
Enviado: quarta-feira, 19 de setembro de 2018 07:39
Para: firebird-support@yahoogroups.com
Assunto: Re
Thank you.
Atenciosamente,
+ + Hugo Eyng + +
De: firebird-support@yahoogroups.com em nome
de 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support]
Enviado: quarta-feira, 19 de setembro de 2018 06:12
Para: firebird-support@yahoogroups.com
Assunto: RE
Hello.
Does anybody know what causes this message in firebird.log?
Atenciosamente,
+ + Hugo Eyng + +
Hello.
How can I find out what mode of FB is runnig? SuperServer or SuperClassic?
Atenciosamente,
+ + Hugo Eyng + +
Hi Hamish.
I don't intend to be obvious, but would it be possible to check record
existence before inserting?
Atenciosamente,
+ + Hugo Eyng + +
De: firebird-support@yahoogroups.com em nome
de 'Hamish Moffatt' ham...@risingsoftware.com [firebird-support
Hi Hamish.
I am not sure if I understood clearly your problem. If I did, you probably
should use "WITH LOCK" clause.
Atenciosamente,
+ + Hugo Eyng + +
De: firebird-support@yahoogroups.com em nome
de 'Hamish Moffatt' ham...@risingsoftware.com
Thank you Karol.
I will check it. I think you are right.
Atenciosamente,
+ + Hugo Eyng + +
De: firebird-support@yahoogroups.com em nome
de liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Enviado: quinta-feira, 9 de agosto de 2018 03:58
Para
ect longer than 31
characters.
What is wrong?
Atenciosamente,
+ + Hugo Eyng + +
Thanks.
Em 21/09/2016 11:06, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] escreveu:
> 21.09.2016 15:51, Hugo Eyng hugoe...@msn.com [firebird-support] wrote:
>> Using gbak, Is it possible restoring only data into an existing
>> database.
> No, not with gbak. I
Hello.
Using gbak, Is it possible restoring only data into an existing
database. Not triggers, not SP. Only data.
The existing DB does not have data.
FirbirdSQL 2.5
Windows Server 2008
--
Atenciosamente,
Hugo Eyng
Hi Helen.
Thank you.
I should pay more attention to the command usage.
Hugo Eyng
Em 06/07/2016 19:49, Helen Borrie hele...@iinet.net.au
[firebird-support] escreveu:
Thursday, July 7, 2016, 10:20:50 AM, Hugo Eyng wrote:
> I tried to use gfix -w async -u USER -p PASSWAORD MYDB.FDB and g
Hello.
I tried to use gfix -w async -u USER -p PASSWAORD MYDB.FDB and gfix
displayed "full or reserve required".
What does it mean? That "full" or "reserve" is required? :))
--
Atenciosamente,
Hugo Eyng
Hello Friends.
I intend to set my DB to asynchronous mode. Should I close all
conections before do it?
--
Atenciosamente,
Hugo Eyng
om the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
>
>
> Yahoo Groups Links
>
>
>
>
>
--
Atenciosamente,
Hugo Eyng
---
Hello friends.
Is there the limitation of 31 bytes for column names in the new FB 3?
--
Atenciosamente,
Hugo Eyng
in this line too, but the lines are commented.
#CpuAffinityMask = 1
#CpuAffinityMask = 192
I am sure this could not cause problems, but the item 1 could? I think
it is not pr
Em 08/04/2016 04:12, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] escreveu:
On 7-4-2016 20:54, Hugo Eyng hugoe
Rotteveel m...@lawinegevaar.nl
[firebird-support] escreveu:
On 7-4-2016 20:54, Hugo Eyng hugoe...@msn.com [firebird-support] wrote:
> Hello Mark.
>
> I was like you showed 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB
>
> Than I changed from FB 32 to FB 64 and it stopped working. Afte
Thank you Dimitry.
I have this book. I will search.
Bye
Em 08/04/2016 10:29, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] escreveu:
> 08.04.2016 15:17, Hugo Eyng hugoe...@msn.com [firebird-support] wrote:
>> Do you know where could I find information about string co
connections and
protocols?
Thank you for answering.
Em 08/04/2016 04:12, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] escreveu:
On 7-4-2016 20:54, Hugo Eyng hugoe...@msn.com [firebird-support] wrote:
> Hello Mark.
>
> I was like you showed 192.168.0.158:C:\DIR1\BASEDIR\MYDAT
:\DIR1\BASEDIR\MYDATABASE.FDB
I open the 3050 port in FW. But it keep not connecting.
Hugo
Em 07/04/2016 11:45, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] escreveu:
On 2016-04-07 14:41, Hugo Eyng hugoe...@msn.com [firebird-support]
wrote:
> Hello.
>
> Thanks for answer my
Checked :)
Em 07/04/2016 13:33, Z T Minhas ztmin...@yahoo.com [firebird-support]
escreveu:
Just checking
--
Atenciosamente,
Hugo Eyng
t's normal? can i terminate it and
retry or maybe this can add other problems to my database file?
thanks
--
Atenciosamente,
Hugo Eyng
Firebird.conf? You
seem to be using relative paths to connect the database; I believe
that depends on the RootDirectory setting.
Mark
- Bericht beantwoorden -
Van: "Hugo Eyng hugoe...@msn.com [firebird-support]"
<firebird-support@yahoogroups.com>
Aan: <firebird-supp
to
database stopped working.
but Database: C:\DIR1\BASEDIR\MYDATABASE.FDB turned working
Any hint?
--
Atenciosamente,
Hugo Eyng
++
Visit http
Hi.
Is it possible to create an index like
CREATE INDEX MYINDEX_IDX1
ON MYTABLE (COLUMN1 ASCENDING, COLUMN2 DESCENDING )
?
--
Atenciosamente,
Hugo Eyng
same table and
built all the indexes in parallel rather than reading the table for
each index, but using an old index in a new database is not a good idea.
Good luck,
Ann
--
Atenciosamente,
Hugo Eyng
in the firebird.conf file.
I am not sure that is the best way, but I did some tests and it worked fine.
Hugo
Em 24/02/2016 16:37, Ann Harrison aharri...@ibphoenix.com
[firebird-support] escreveu:
On Wed, Feb 24, 2016 at 12:01 PM, Hugo Eyng hugoe...@msn.com
<mailto:hugoe...@msn.com> [firebird-s
Borrie hele...@iinet.net.au
[firebird-support] escreveu:
Wednesday, February 24, 2016, 12:22:31 PM, Hugo Eyng wrote:
> Hello.
> I tried to restore a backup using the -BU 20 switch and gbak
> returned an error message: invalid parameter.
That is not a gbak message. If you are usin
Hello.
I tried to restore a backup using the -BU 20 switch and gbak
returned an error message: invalid parameter.
Then I change the value 20 by 12 and gbak worked.
Is it a limitation?
switches
--
Atenciosamente,
Hugo Eyng
Hello Friends.
I am thinking about the better/faster/easier way to log changes made in
records on the tables of my DB.
Could someone share experience (good or bad)? Any suggestion?
--
Atenciosamente,
Hugo Eyng
be limited by how much it can do in its
single thread.
Mark
- Reply message -
Van: "Hugo Eyng hugoe...@msn.com [firebird-support]"
<firebird-support@yahoogroups.com>
Aan: <firebird-support@yahoogroups.com>
Onderwerp: [firebird-support] CPU Affinity
Datum: di, j
Health Check, Tuning etc.
> Does it make sense or could be better to use less cores, like core
> 5,6,7,8 or 3,4,5,6?
>
> --
>
>
> Atenciosamente,
>
> Hugo Eyng
>
>
>
>
>
>
>
&g
To define CPU Affinity in firebird.conf I set CPUAffinity to 255, in a
way to use all the 8 cores.
Does it make sense or could be better to use less cores, like core
5,6,7,8 or 3,4,5,6?
--
Atenciosamente,
Hugo Eyng
l also considers it as
clean.
Cheers,
Christian
--
Atenciosamente,
Hugo Eyng
so considers it as
>> clean.
> Avira Antivir locally does not report anything suspicious.
>
>
>
--
Atenciosamente,
Hugo Eyng
++
Vi
Hello.
I downloaded FB 2.5.5 from firebirdsql and my Microsoft Essentials
detected it as a malware.
Did anybody face the same problem?
--
Atenciosamente,
Hugo Eyng
that can affect the database
performance too.
Hugo Eyng
Em 07/12/2015 16:52, Rudi Feijó rudi.fe...@multidadosti.com.br
[firebird-support] escreveu:
I noticed our biggest data server have a lot of hard disk activity
creating fb_lock files.
Firebird 2.5.4, superclassic
My changed lock
Hello.
I am trying to use my application while gbak makes backup, but a message
is raised 'File alredy in use by another'.
Running on Vista.
--
Atenciosamente,
Hugo Eyng
Hello.
The message is 'File already in use by another process'
Em 16/07/2015 14:49, Hugo Eyng hugoe...@msn.com [firebird-support] escreveu:
Hello.
I am trying to use my application while gbak makes backup, but a message
is raised 'File alredy in use by another'.
Running on Vista
/tcp (SV-W12-L900)/P12
on disk structure version 11.2
--
Atenciosamente,
Hugo Eyng
...@users.sourceforge.net
[firebird-support] wrote:
25.05.2015 17:43, Hugo Eyng hugoe...@msn.com wrote:
1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD
NEW_COLUMN INTEGER NOT NULL). There were already some records in the
table. FB didn´t raise any warning or exception.
2 - I created a backup file from
on a table
with data if there is no DEFAULT clause provided.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
--
Atenciosamente,
Hugo Eyng
etc.
--
Atenciosamente,
Hugo Eyng
the database.
Ok, it works. But, the column that should be NOT NULL will change,
without warning, and I have to check my tables after restoring DB.
I am using FB 2.5 and I tried using FB 3.0 too.
Is it as I described or there is another way to treat this?
--
Atenciosamente,
Hugo Eyng
to implement them? I recognize the issues presented, just not
sure what the best approach is to solving them .
--
Atenciosamente,
Hugo Eyng
Hello.
I will develop an App for Android and I want to conect FB running on
windows.
Did somebody tried doing this? Some hint, article or information about
how can I implement that? Driver?
--
Atenciosamente,
Hugo Eyng
assume 3.0 will be
launched.
Nevertheless: I need a tool to maintain / develop the database. In the
past I used sql manager for interbase firebird. But it's not
supporting 3.0 yet. Any advice, which tools are able to handle 3.0
databases?
BR
Christoph
--
Atenciosamente,
Hugo Eyng
the knowledgebases at
http://www.ibphoenix.com/resources/documents/
++
Yahoo Groups Links
--
Atenciosamente,
Hugo Eyng
to occur. However, deadlock still occurs from time to time:
Deadlock.
Deadlock.
Update conflicts with concurrent update.
Concurrent transaction number is 57258.
What am I doing wrong?
Thans for your assistance :)
--
Atenciosamente,
Hugo Eyng
Thank you Dmitry.
I will try better tests.
Hugo Eyng
Em 22/12/2014 16:53, Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] escreveu:
22.12.2014 21:18, Hugo Eyng wrote:
I added the settings SharedDatabase = true and SharedCache = false like
you told and everything worked fine
field.
Is there some kind of setting that cause FB 3.0.0 acting like FB 2.5 in
this situation?
--
Atenciosamente,
Hugo Eyng
Hi Helen.
I am testing FB 3.0.0 but I use FB 2.5.3, that is why some question are
about 2.5.3.
Thanks.
On 23/12/2014 16:36, Helen Borrie hele...@iinet.net.au
[firebird-support] wrote:
Hugo,
At 06:25 a.m. 24/12/2014, Hugo Eyng hugoe...@msn.com
[firebird-support] wrote:
Hello Friends
.
Than I ask: should I use SuperServer?
Hugo
Em 20/12/2014 07:29, Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] escreveu:
19.12.2014 23:30, Hugo Eyng hugoe...@msn.com [firebird-support] wrote:
I am testing FB 3.0.0.31374 BETA.
Instalation Classic
Out of curiosity, why
) *
So my application cannot be opened by two or more users. Even using
IBExpert, I cannot open the same database more than one time.
Did anybody faced this situation?
--
Atenciosamente,
Hugo Eyng
/documents/
++
Yahoo Groups Links
--
Atenciosamente,
Hugo Eyng
Hello.
IBExpert shows the message:
lock conflict on no wait transaction
unsuccessful metada update
object MY_PROCEDURE is in use
How can I see 'who' is using the procedure?
--
Atenciosamente,
Hugo Eyng
?
--
Atenciosamente,
Hugo Eyng
.
A connection can hold an object in use for an indeterminant period of
time.
For me, I want to know that the change will apply/has been made, if
not, I will track down the source of the problem... and then re-run.
Sean
--
Atenciosamente,
Hugo Eyng
IBExpert shows the message:
HEhmcfs lock conflict on no wait transaction
HEhmcfs unsuccessful metada update
HEhmcfs object MY_PROCEDURE is in use
HEhmcfs How can I see 'who' is using the procedure?
--
Atenciosamente,
Hugo Eyng
--
Atenciosamente,
Hugo Eyng
the message:
HEhmcfs lock conflict on no wait transaction
HEhmcfs unsuccessful metada update
HEhmcfs object MY_PROCEDURE is in use
HEhmcfs How can I see 'who' is using the procedure?
--
Atenciosamente,
Hugo Eyng
--
Atenciosamente,
Hugo Eyng
--
Atenciosamente,
Hugo Eyng
Hello.
Is it possible to change/delete a trigger while it´s in use?
--
Atenciosamente,
Hugo Eyng
*From: * Hugo Eyng hugoe...@msn.com [firebird-support]
firebird-support@yahoogroups.com;
*To: * firebird-support@yahoogroups.com;
*Subject: * [firebird-support] Updating Firebird
*Sent: * Tue, May 20, 2014 6:26:55 PM
Hello.
I want to update Firebird from 2.5.2.26539 to 2.5.2.26540.
Should I
Thank you for the answers.
What libraries should I update?
Hugo
Em 20/05/2014 16:45, Helen Borrie hele...@iinet.net.au
[firebird-support] escreveu:
At 06:26 a.m. 21/05/2014, Hugo Eyng hugoe...@msn.com
[firebird-support] wrote:
Hello.
I want to update Firebird from 2.5.2.26539
Hello.
I want to update Firebird from 2.5.2.26539 to 2.5.2.26540.
Should I close all databases and stop de Firebird server?
--
Atenciosamente,
Hugo Eyng
Hello.
At http://www.firebirdsql.org/en/downloads the available release of
Firebird to download is 2.5.2.
Somebody mentioned a 2.5.3 release. Is there a 2.5.3 release? I exist,
where can I download it?
--
Atenciosamente,
Hugo Eyng
Hi.
It will be usefull. Thanks.
Hugo Eyng
Em 11/03/2014 19:38, liviusliv...@poczta.onet.pl escreveu:
Hi,
look at my FAQ about last table modification time
there is described another solution for this problem
it work on generators - use it if you like it
http://itstop.pl/en-en/Porady
Hello.
Is there a way to get information like last time the table was
updated/changed, the size in bytes of the table, how much records are
save in the table?
--
Atenciosamente,
Hugo Eyng
and
firebird.conf) and FileSystemCacheSize = 20,
but the CPU is having holiday.
I don't believe that I am the only one having these problems.
Help me please to force the performance.
Best regards, Roland Turcan
23.01.2014 19:23 - Hugo Eyng hugoe...@msn.com
I use SuperClassic and seted
have own
setting
about count of cache pages.
It seems to be still not solving this problem using by
FileSystemCacheSize.
What else can I test?
Thanks.
22.01.2014 15:05 - Hugo Eyng hugoe...@msn.com
Try changing values for DefaultDbCachePages
Em 21/01/2014 18:40, Roland Turcan
so, the FB performance is not compatible to the hardware used to
run it.
Em 20/01/2014 23:12, Helen Borrie escreveu:
At 02:01 p.m. 21/01/2014, Hugo Eyng wrote:
As Firebird do not use available RAM I created a RAM DRIVE with 10GB
and pointed parameter 'TempDirectories' (firebird.conf
.
Em 20/01/2014 23:01, Hugo Eyng hugoe...@msn.com
mailto:hugoe...@msn.com escreveu:
Hi.
I am facing a similar situation.
32GB RAM
Dell PowerEdge R420
Intel Xeon CPU E5-2609 two processors 2.40ghz 8 cores
RAID
Firebird 2.5.2 do not use the available resources
disk
controller.
Also read from Helen sayd. You are loosing the point when using a
gente ram disk.
Em 20/01/2014 23:01, Hugo Eyng hugoe...@msn.com
mailto:hugoe...@msn.com escreveu:
Hi.
I am facing a similar situation.
32GB RAM
Dell PowerEdge R420
Intel Xeon CPU E5-2609 two
,
but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the
RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB
could use this for every SELECTS and so improve the application.
Hugo Eyng
Em 20/01/2014 20:51, Roland Turcan escreveu:
Hello guys,
I found some info
Hi.
I am not sure if i understood your question.
You want to move the fdb file to another computer?
Hugo Eyng
Em 15/01/2014 12:52, Maury Markowitz escreveu:
I am a admin of the Fishbowl Inventory (FBI) system for our company,
which is a Java app on top of Firebird.
I need to move
source 'fdb' and then, in the destination
computer, use 'gbak' to restore and recreate the 'fdb'.
Em 15/01/2014 17:30, Maury Markowitz escreveu:
On 2014-01-15, at 2:02 PM, Hugo Eyng wrote:
I am not sure if i understood your question.
You want to move the fdb file to another computer
inserts and a delete per record. Â Why not just put the
records into the
real table to start with?
Good luck,
AnnÂ
--
Atenciosamente,
Hugo Eyng
,
Hugo Eyng
[Non-text portions of this message have been removed]
.
Could I have problems like data corruption?
In all other respects Classic engine functions the same as SuperServer
--
Atenciosamente,
Hugo Eyng
[Non-text portions of this message have been removed]
queries
that uses ORDER BY or GROUP BY.
Does somebody has comments, suggestions?
How to really increase the speed of my queries using RAM, a lot of RAM?
--
Atenciosamente,
Hugo Eyng
[Non-text portions of this message have been removed]
, it
is very difficult to provide meaningful suggestions.
Sean
--
Atenciosamente,
Hugo Eyng
[Non-text portions of this message have been removed]
Hello.
When should I use a Unique Key instead of a Index?
I know that a Unique Key does not allow duplicated values like a Primary
Key, but what more?
Is there some advantage using a Unique Key?
A Unique Key is the same that Alternate Key?
--
Atenciosamente,
Hugo Eyng
only changes,
so, it is faster.
But, if you use Classic, consider not to use nbackup with Firebird
less than 2.5.2 (or even 2.5.3).
--
Dmitry Kuzmenko, www.ib-aid.com
--
Atenciosamente,
Hugo Eyng
[Non-text portions of this message have been removed]
once a week, and incremental backup as many
times you need.
From: Hugo Eyng hugoe...@msn.com mailto:hugoeyng%40msn.com
To: firebird-support@yahoogroups.com
mailto:firebird-support%40yahoogroups.com
Sent: Wednesday, June 26, 2013 8:38 PM
Subject: [firebird
97 matches
Mail list logo