On 1/17/07, Vlad Horsun <hvlad@...> wrote:

>
> > Usually i have this problem (it seems it happens when a replication
> > cycle is running and the connection goes down). I was never able to
> > recover the database from this situation, except for doing a backup
> > and restore on both databases.
> >
> > Can someone explain what these messages means and what should i do?
> >
> > Thanks.
> >
> > [root@saopaulo firebird]# gfix -commit all caxambu
>
> On whicn host reside database 'caxambu' ? I.e. what is the name
> of your local host ?

It's the real name. I can connect to it using isql

>
>
>
>
>
>
> > Could not reattach to database for transaction 19557.
> > Original path: pocofundo.queijoscaxambu.com.br:caxambu
>
> gfix can't attach to database 'caxambu' on host
> 'pocofundo.queijoscaxambu.com.br'

The same here. I can connect to this machine using isql

>
> > Could not reattach to database for transaction 36808.
> > Original path: saopaulo.queijoscaxambu.com.br:caxambu
>
> gfix can't attach to database 'caxambu' on host
> 'saopaulo.queijoscaxambu.com.br'
>
> Perhaps this two hosts not available at this time or Firebird are not
> running there or you have different passwords for user accout with
> which you run gfix

They were available. Now i am passing the username and password as
parameters, and this is my output:

- trying to commit

[root@saopaulo firebird]# gfix -commit all caxambu -user sysdba -password <pass>
A commit of transaction 72946 will violate two-phase commit.
Multidatabase transaction:
Host Site: servidor.queijoscaxambu.com.br
Transaction 72946
has been prepared.
Remote Site: saopaulo.queijoscaxambu.com.br
Database Path: saopaulo.queijoscaxambu.com.br:caxambu
Host Site: servidor.queijoscaxambu.com.br
Transaction 46306
is not found, assumed not prepared.
Remote Site: pocofundo.queijoscaxambu.com.br
Database Path: pocofundo.queijoscaxambu.com.br:caxambu
Automated recovery would rollback this transaction.
unexpected end of input
Multidatabase transaction:
Host Site: servidor.queijoscaxambu.com.br
Transaction 107834
has been prepared.
Remote Site: saopaulo.queijoscaxambu.com.br
Database Path: saopaulo.queijoscaxambu.com.br:caxambu
Host Site: servidor.queijoscaxambu.com.br
Transaction 71042
has been prepared.
Remote Site: pocofundo.queijoscaxambu.com.br
Database Path: pocofundo.queijoscaxambu.com.br:caxambu
unexpected end of input
[root@saopaulo firebird]#

trying to rollback

[root@saopaulo firebird]# gfix -rollback all caxambu -user sysdba
-password <pass>
Multidatabase transaction:
Host Site: servidor.queijoscaxambu.com.br
Transaction 107834
has been prepared.
Remote Site: saopaulo.queijoscaxambu.com.br
Database Path: saopaulo.queijoscaxambu.com.br:caxambu
Host Site: servidor.queijoscaxambu.com.br
Transaction 71042
has been prepared.
Remote Site: pocofundo.queijoscaxambu.com.br
Database Path: pocofundo.queijoscaxambu.com.br:caxambu
unexpected end of input
[root@saopaulo firebird]#

Regards,

Fabiano.

>
> Regards,
> Vlad
>