Re: [firebird-support] Re: Error on Gfix

[Jeferson Sisto jsis...@gmail.com [firebird-support]]

Hi Vlad, thank for your e-mail!

I understood what you said, however, in the link
http://www.firebirdsql.org/manual/gfix-dbverify.html I got the following
information:


Full Validation

By default, validation works at page level. If no need to go deeper and
validate at the record level as well, the command to do this is:

gfix -v[alidate] -full database_name

using this option will validate, report and update at both page and record
level. Any corrupted structures etc will be fixed.


With the text above, I understood that the command gfix -v -full would fix
both orphan page and record level error.

Is the text above wrong?


Thank you.

*Jeferson Sisto*
+55 (17) 98827-6685 (Oi - WhatsApp)
jsis...@gmail.com
jsis...@yahoo.com.br

2015-09-30 5:46 GMT-03:00 hv...@users.sourceforge.net [firebird-support] <
firebird-support@yahoogroups.com>:

>
>
> > ---In firebird-support@yahoogroups.com,  wrote :
> >
> > I'm using Firebird 2.5.x and the command gfix -v -full returned:
> >
> > Summary of validation errors
> >
> > Number of record level errors : 3
> > Number of database page errors : 1993
> >
> > What I have to do in order to fix it, without a backup/restore? I read
> in "Firebird Documentation" that the
> > command gfix -v -full will fix the orphan pages and record level erros,
> however, every time when i ran
> > "gfix -v -full" is returned the error above.
>
>   gfix will correct orphan pages if and only if there were no other
> errors. Strongly speaking, "orphan pages"
> is not error - in the sense that it not affect database operations. So,
> there is no strong need to fix it ASAP.
>
>
> Regards,
> Vlad
>
> PS In fb3 we divided all inconsistencies detectable by validation (gfix)
> by "errors" and "warnings".
> All kind of "warnings" are not affect correctness of database operation
>
> 
>

[firebird-support] Error on Gfix

[Jeferson Sisto jsis...@gmail.com [firebird-support]]

Hi!

I'm using Firebird 2.5.x and the command gfix -v -full returned:

Summary of validation errors

Number of record level errors : 3
Number of database page errors : 1993

What I have to do in order to fix it, without a backup/restore? I read in
"Firebird Documentation" that the command gfix -v -full will fix the orphan
pages and record level erros, however, every time when i ran "gfix -v
-full" is returned the error above.


Thank you


*Jeferson Sisto*
+55 (17) 98827-6685 (Oi - WhatsApp)
jsis...@gmail.com
jsis...@yahoo.com.br

Re: [firebird-support] Error on Gfix

[Jeferson Sisto jsis...@gmail.com [firebird-support]]

Ok, I know this full procedure about corrupt database.

But, when the unique problem about corrupt database is ORPHAN PAGE. In this
especific situation, is necessary to execute all the steps, including the
backup/restore?

Looking my situation, I'm having ONLY orphan page in a database that have
20~30 GB. In this database, the backup/restore procedure delay
significative time...





Obrigado.


*Jeferson Sisto*
(17) 98827-6685 (Oi - WhatsApp)
jsis...@gmail.com
jsis...@yahoo.com.br

2015-09-29 17:37 GMT-03:00 'Neil Pickles' neil.pick...@csy.co.uk
[firebird-support] :

>
>
> We have a 4 part fix process for fixing database, first two commands are
> gfix and the final two are gbak.
>
>
>
> 1.   %gfix% -v -ignore -full -user SYSDBA -password masterkey %1
>
> 2.   %gfix% -mend -ignore -user SYSDBA -password masterkey %1
>
> 3.   %gbak% -b -g -ig -v -user SYSDBA -password masterkey %1 %2
>
> 4.   %gbak% -c -v -p 8192 -user SYSDBA -password masterkey %1 %2
>
>
>
> Sometimes it is necessary to add the –i switch to the 4th command line so
> that indexes aren’t reactivated upon restore where data is missing that
> causes the restore to fail. You then have to turn the indices back on
> individually and fix any data related issues until all indices and
> referential constraints are all resolved and reactivated successfully.
>
>
>
> This process fixes most database corruption issues and has been gleaned
> from a variety of sources over the last few years, it works for v2.1 & v2.5.
>
>
>
> Cheers,
>
> Neil Pickles
>
> *From:* firebird-support@yahoogroups.com [mailto:
> firebird-support@yahoogroups.com]
> *Sent:* 29 September 2015 19:43
> *To:* firebird-support@yahoogroups.com
> *Subject:* Re: [firebird-support] Error on Gfix
>
>
>
>
>
> Hi,
>
>
>
> look into Firebird.log – there are more infos about corruptions recognized
> by gfix
>
>
>
>
>
> regards,
>
> Karol Bieniaszewski
>
>
>
> *From:* mailto:firebird-support@yahoogroups.com
> 
>
> *Sent:* Tuesday, September 29, 2015 2:53 PM
>
> *To:* firebird-support@yahoogroups.com
>
> *Subject:* [firebird-support] Error on Gfix
>
>
>
>
>
> Hi!
>
>
>
> I'm using Firebird 2.5.x and the command gfix -v -full returned:
>
>
>
> Summary of validation errors
>
>
>
> Number of record level errors : 3
>
> Number of database page errors : 1993
>
>
>
> What I have to do in order to fix it, without a backup/restore? I read in
> "Firebird Documentation" that the command gfix -v -full will fix the orphan
> pages and record level erros, however, every time when i ran "gfix -v
> -full" is returned the error above.
>
>
>
>
>
> Thank you
>
>
>
>
>
> *Jeferson Sisto*
>
> +55 (17) 98827-6685 (Oi - WhatsApp)
>
> jsis...@gmail.com
>
> jsis...@yahoo.com.br
>
> 
>

Re: [firebird-support] Error on Gfix

[Jeferson Sisto jsis...@gmail.com [firebird-support]]

Hi!

I know Firebird.log and its informations... also, this information are very
helpful.

However, always when we detect a corrupt database, our team run a
backup/restore. It can be a problem when a database has 20, 30 GB. I read
that gfix can fix orphan pages, and our corrupt is about orphan pages. I
ran the command gfix -v -full but I don't if it works because ALWAYS
returns the result below.

May someone else help us?



Obrigado.


*Jeferson Sisto*
(17) 98827-6685 (Oi - WhatsApp)
jsis...@gmail.com
jsis...@yahoo.com.br

2015-09-29 15:43 GMT-03:00 liviusliv...@poczta.onet.pl [firebird-support] <
firebird-support@yahoogroups.com>:

>
>
> Hi,
>
> look into Firebird.log – there are more infos about corruptions recognized
> by gfix
>
>
> regards,
> Karol Bieniaszewski
>
> *From:* mailto:firebird-support@yahoogroups.com
> 
> *Sent:* Tuesday, September 29, 2015 2:53 PM
> *To:* firebird-support@yahoogroups.com
> *Subject:* [firebird-support] Error on Gfix
>
>
>
> Hi!
>
> I'm using Firebird 2.5.x and the command gfix -v -full returned:
>
> Summary of validation errors
>
> Number of record level errors : 3
> Number of database page errors : 1993
>
> What I have to do in order to fix it, without a backup/restore? I read in
> "Firebird Documentation" that the command gfix -v -full will fix the orphan
> pages and record level erros, however, every time when i ran "gfix -v
> -full" is returned the error above.
>
>
> Thank you
>
>
> *Jeferson Sisto*
> +55 (17) 98827-6685 (Oi - WhatsApp)
> jsis...@gmail.com
> jsis...@yahoo.com.br
>
> 
>

Re: [firebird-support] Re: Connected users from MON$ATTACHMENT

[Jeferson Sisto jsis...@gmail.com [firebird-support]]

Jeferson said:
 I already try to do it, but when a connection from a client (another
 machine) is ended abnormally (for example, turn off the machine or
 disconnect the cable of network), this connection still stay on system
 table MON$ATTACHMENT.

Dmitry said:
It's because the connection is still really alive, the server has no
idea that it was terminated from the other side. You need to configure
either the TCP keepalive interval at the OS level or enable
DummyPacketInterval in firebird.conf, so that such forced disconnects
were detected faster by the server.


Thank Dmitry,

I read the firebird.conf and the article in Microsoft site. Please, help me
again:

1) In firebird.conf, in session about parameter DummyPacketInterval, there
is a warning DO NOT USE THIS OPTION. I can or cannot use this parameter?
This parameter only can be used  with the changes in OS, quoted in the
Microsoft article?

2) About OS, our customers uses Microsoft Windows. I read the documentation
and I understand (or I guess) that the unique parameter that I should add
in Windows Register is KeepAliveInterval. Is it right? Are mandatory the
other two parameters?

Sorry about so many questions, but this configuration is not my daily job
(I'm a Delphi/C# programmer).

Thank you.

*Jeferson Sisto*
jsis...@gmail.com
jsis...@yahoo.com.br


2015-08-12 7:23 GMT-03:00 Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] firebird-support@yahoogroups.com:



 11.08.2015 23:42, Jeferson Sisto wrote:

  I already try to do it, but when a connection from a client (another
  machine) is ended abnormally (for example, turn off the machine or
  disconnect the cable of network), this connection still stay on system
  table MON$ATTACHMENT.

 It's because the connection is still really alive, the server has no
 idea that it was terminated from the other side. You need to configure
 either the TCP keepalive interval at the OS level or enable
 DummyPacketInterval in firebird.conf, so that such forced disconnects
 were detected faster by the server.

 Dmitry

 

[firebird-support] Connected users from MON$ATTACHMENT

[Jeferson Sisto jsis...@gmail.com [firebird-support]]

Hello!


May I use the system table MON$ATTACHMENT in order to get the connected
users in moment?


I already try to do it, but when a connection from a client (another
machine) is ended abnormally (for example, turn off the machine or
disconnect the cable of network), this connection still stay on system
table MON$ATTACHMENT.


There are a way to refresh this system table?


Thank you!


*Jeferson Sisto*
jsis...@gmail.com
jsis...@yahoo.com.br