Hi Bob,

Bob Murdoch wrote:

>Alexandre,
>
>
>
>You have to look at the firebird.log for the output of gfix.
>
>Bob M..
>
>
>
>

I didn't know that gfix only write to the log, I expected some screen
output, never used it to fix a DB :-)

here are some parts of my log. I didn't know when exactly I runned gfix.

The abnormal shutdown was when I killed the service.

NOTEBOOK (Client) Tue Mar 22 12:06:51 2005
C:\Program Files\Firebird\bin\fbserver.exe: terminated abnormally
(4294967295)


NOTEBOOK (Client) Tue Mar 22 12:06:53 2005
Guardian starting: C:\Program Files\Firebird\bin\fbserver.exe


NOTEBOOK (Client) Tue Mar 22 20:12:14 2005
C:\Program Files\Firebird\bin\fbserver.exe: terminated abnormally
(4294967295)


NOTEBOOK (Client) Tue Mar 22 20:12:32 2005
Guardian starting: C:\Program Files\Firebird\bin\fbserver.exe


NOTEBOOK (Server) Tue Mar 22 20:20:06 2005
Database: C:\LOCALPUB2\BD\SMC_TP.FDB
internal gds software consistency check (pointer page disappeared in
DPM_delete (245))

NOTEBOOK (Server) Tue Mar 22 20:20:06 2005
Database: C:\LOCALPUB2\BD\SMC_TP.FDB
internal gds software consistency check (pointer page disappeared in
DPM_delete (245))

NOTEBOOK (Client) Tue Mar 22 20:26:53 2005
C:\Program Files\Firebird\bin\fbserver.exe: terminated abnormally
(4294967295)


NOTEBOOK (Client) Tue Mar 22 20:26:59 2005
Guardian starting: C:\Program Files\Firebird\bin\fbserver.exe


NOTEBOOK (Server) Tue Mar 22 21:16:43 2005
Database: C:\LOCALPUB2\BD\SMC_TP.FDB
internal gds software consistency check (pointer page disappeared in
DPM_delete (245))
^^^^^^^^^^^^^^^^^^^^^^^^^^
I think this is the gfix output



NOTEBOOK (Server) Tue Mar 22 21:16:43 2005
Database: C:\LOCALPUB2\BD\SMC_TP.FDB
internal gds software consistency check (pointer page disappeared in
DPM_delete (245))

NOTEBOOK (Server) Tue Mar 22 21:20:03 2005
Database: C:\LOCALPUB2\BD\SMC_TP.FDB
internal gds software consistency check (pointer page disappeared in
DPM_delete (245))

NOTEBOOK (Client) Tue Mar 22 23:10:48 2005
C:\Program Files\Firebird\bin\fbserver.exe: normal shutdown


NOTEBOOK (Server) Tue Mar 22 23:10:47 2005
Shutting down the Firebird service with 1 active connection(s) to 1
database(s)

NOTEBOOK (Server) Tue Mar 22 23:10:48 2005
The database C:\LOCALPUB2\BD\SMC_TP.FDB was being accessed when the
server was shutdown

NOTEBOOK (Client) Tue Mar 22 23:10:48 2005
Control services error 1061

NOTEBOOK (Server) Tue Mar 22 23:10:49 2005
Database: C:\LOCALPUB2\BD\SMC_TP.FDB
internal gds software consistency check (Too many savepoints (287))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
don't know when I got this:


NOTEBOOK (Client) Tue Mar 22 23:11:31 2005
Guardian starting: C:\Program Files\Firebird\bin\fbserver.exe


NOTEBOOK (Client) Wed Mar 23 16:16:23 2005
Guardian starting: C:\Program Files\Firebird\bin\fbserver.exe


see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.1 - Release Date: 23/03/2005